*Script for quest "An End To All Things..."

--HG--
branch : trunk

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