diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/FULL/world_scripts_full.sql | 3 | ||||
| -rw-r--r-- | sql/FULL/world_spell_full.sql | 5 | ||||
| -rw-r--r-- | sql/updates/5175_world_scripts_dk.sql | 10 |
3 files changed, 17 insertions, 1 deletions
diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index b26a1c83536..0c22ae65a8c 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -117,6 +117,9 @@ UPDATE `creature_template` SET `ScriptName`='npc_scarlet_miner' WHERE (`entry`=' UPDATE `creature_template` SET `ScriptName`='npc_crusade_persuaded' WHERE `entry` IN (28939,28940,28610); UPDATE `creature_template` SET `ScriptName`='mob_scarlet_courier' WHERE `entry`='29076'; +update creature_template set scriptname="mob_anti_air" where entry in (29102,29103,29104); + + /* */ /* ZONE */ diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql index f7bd1efbccd..11380f04afd 100644 --- a/sql/FULL/world_spell_full.sql +++ b/sql/FULL/world_spell_full.sql @@ -1984,7 +1984,8 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (52479, 1, 28822), (52576, 1, 28834), -- Electro-magnetic Pulse (52576, 1, 28886), -(53110, 1, 28940); -- Devour Humanoid +(53110, 1, 29102), +(53110, 1, 29103); -- Devour Humanoid -- Eye of Acherus DELETE FROM `spell_target_position` WHERE `id`=51852; @@ -2039,6 +2040,8 @@ UPDATE `quest_template` SET `PrevQuestId`=12751 WHERE `entry`=12754; update spell_area set quest_end = 12756 where spell=53081; +update creature_template set spell1=53117 where entry=29104; +update creature_template set spell1=53348,killcredit1=29150 where entry IN (29102,29103); -- -------- -- NAXXARAMAS diff --git a/sql/updates/5175_world_scripts_dk.sql b/sql/updates/5175_world_scripts_dk.sql new file mode 100644 index 00000000000..33f62d77f31 --- /dev/null +++ b/sql/updates/5175_world_scripts_dk.sql @@ -0,0 +1,10 @@ +update creature_template set spell1=53117 where entry=29104; +update creature_template set spell1=53348,killcredit1=29150 where entry IN (29102,29103); +update creature_template set scriptname="mob_anti_air" where entry in (29102,29103,29104); + + +DELETE FROM `spell_script_target` WHERE entry IN +(53110); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(53110, 1, 29102), +(53110, 1, 29103); -- Devour Humanoid |