diff options
| -rw-r--r-- | sql/FULL/world_scripts_full.sql | 4 | ||||
| -rw-r--r-- | sql/updates/5866_gameobject_template.sql | 2 | ||||
| -rw-r--r-- | sql/updates/6008_world.sql | 5 | ||||
| -rw-r--r-- | sql/updates/6176_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/6186_world_scripts.sql | 2 |
5 files changed, 3 insertions, 12 deletions
diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index 7dff477ae98..e80dacc6eb3 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -1349,7 +1349,7 @@ UPDATE `creature_template` SET `ScriptName`='mob_ohgan' WHERE `entry`=14988; -- -------- UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE entry IN (26796,26798,26929,26928,26930); DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (26796,26798,26929,26928,26930); -UPDATE `creature_template` SET `ScriptName`='EventAI',`modelid1` = 16925,`modelid3` = 16925, `minmana` = 1000000,`maxmana` = 1000000, `unit_flags` = 33554434 WHERE `entry` IN(29998,33753,33752,33751,33750); +UPDATE `creature_template` SET `ScriptName`='EventAI' WHERE `entry` IN(29998,33753,33752,33751,33750); DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (29998,33753,33752,33751,33750); INSERT INTO `creature_ai_scripts` VALUES -- Commander Stoutbeard @@ -1410,7 +1410,7 @@ INSERT INTO `creature_ai_scripts` (`creature_id`,`event_type`,`event_chance`,`ev (23035,6,100,6,34,2,3,'Anzu - Set Inst Data on Death'); -- dk final quest -UPDATE `creature_template` SET `unit_flags`=32768,`AIName`='EventAI' WHERE `entry` IN (29199,29204,29200,29174,29182,29186,29190,29219,29206,29176,29178,29179,29180,29177,29181); +UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` IN (29199,29204,29200,29174,29182,29186,29190,29219,29206,29176,29178,29179,29180,29177,29181); DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (29199,29204,29200,29174,29182,29186,29190,29219,29206,29176,29178,29179,29180,29177,29181); INSERT INTO `creature_ai_scripts` VALUES (2919901,29199,0,0,100,3,10000,20000,10000,20000,11,52374,1,0,0,0,0,0,0,0,0,0,'Koltira Deathweaver - SPELL_BLOOD_STRIKE1'), diff --git a/sql/updates/5866_gameobject_template.sql b/sql/updates/5866_gameobject_template.sql deleted file mode 100644 index cc31e49aae8..00000000000 --- a/sql/updates/5866_gameobject_template.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `gameobject_template` SET `type`='10',`data0`='0',`ScriptName`='go_wg2voa_portal' WHERE (`entry`='190763'); - diff --git a/sql/updates/6008_world.sql b/sql/updates/6008_world.sql deleted file mode 100644 index 19a805660b8..00000000000 --- a/sql/updates/6008_world.sql +++ /dev/null @@ -1,5 +0,0 @@ -UPDATE `creature_template` SET `modelid1`='11686' WHERE `entry`=23537; -UPDATE `creature_template` SET `modelid1`='11686' WHERE `entry`=23686; -UPDATE `creature_template` SET `modelid1`='11686' WHERE `entry`=23758; -UPDATE `creature_template` SET `modelid1`='11686' WHERE `entry`=24034; -UPDATE `creature_template` SET `modelid1`='11686' WHERE `entry`=23775;
\ No newline at end of file diff --git a/sql/updates/6176_world_scripts.sql b/sql/updates/6176_world_scripts.sql index 84b89fc172d..f88fbdfae72 100644 --- a/sql/updates/6176_world_scripts.sql +++ b/sql/updates/6176_world_scripts.sql @@ -1,4 +1,4 @@ -UPDATE `creature_template` SET `AIName` = 'AOEAI',`flags_extra` = '0',`minlevel` = '70',`maxlevel` = '70',`maxlevel` = '70',`faction_A` = '14',`faction_H` = '14' WHERE `entry` IN ('23336','23069','23259'); +UPDATE `creature_template` SET `AIName` = 'AOEAI' WHERE `entry` IN ('23336','23069','23259'); UPDATE `creature_template` SET `spell1` = '40029' WHERE `entry` = 23069; UPDATE `creature_template` SET `spell1` = '40610' WHERE `entry` = 23259; UPDATE `creature_template` SET `spell1` = '40836' WHERE `entry` = 23336;
\ No newline at end of file diff --git a/sql/updates/6186_world_scripts.sql b/sql/updates/6186_world_scripts.sql deleted file mode 100644 index f8e91a7b019..00000000000 --- a/sql/updates/6186_world_scripts.sql +++ /dev/null @@ -1,2 +0,0 @@ -DELETE FROM `creature_template_addon` WHERE `entry` = 24895; -UPDATE `creature_template` SET `unit_flags`='0' WHERE `entry`=24882; |