From 7ac4fb46c417ecbc68cf4844c6078ed88015bc90 Mon Sep 17 00:00:00 2001 From: megamage Date: Tue, 26 May 2009 22:13:36 -0500 Subject: *Fix DK quest 12641 --HG-- branch : trunk --- sql/updates/3592_world_spell_(dk).sql | 11 +++++++++++ sql/world_spell_full.sql | 17 +++++++++++++++++ 2 files changed, 28 insertions(+) create mode 100644 sql/updates/3592_world_spell_(dk).sql (limited to 'sql') diff --git a/sql/updates/3592_world_spell_(dk).sql b/sql/updates/3592_world_spell_(dk).sql new file mode 100644 index 00000000000..394350b9745 --- /dev/null +++ b/sql/updates/3592_world_spell_(dk).sql @@ -0,0 +1,11 @@ +update creature_template set spell5=51890 where entry = 28511; -- Eye of Acherus flight + +DELETE FROM `spell_script_target` WHERE entry IN +(51859); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(51859, 1, 28525), -- siphon of archerus +(51859, 1, 28542), +(51859, 1, 28543), +(51859, 1, 28544); + +update creature_template set minlevel=50,maxlevel=52,minhealth=2215,maxhealth=2317,faction_A=2084,faction_H=2084,mindmg=50,maxdmg=50 where entry=28528; -- ghoul diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql index 82aa9af433c..9c6f3bf1775 100644 --- a/sql/world_spell_full.sql +++ b/sql/world_spell_full.sql @@ -1549,9 +1549,26 @@ spell4 = VALUES(spell4); -- Three-seat mammoth UPDATE creature_template SET VehicleId = 312 WHERE entry IN (31857,31858,31861,31862,32212,32213,32633,32640); + +-- -------- +-- Death Knight +-- -------- +update creature_template set spell5=51890 where entry = 28511; -- Eye of Acherus flight + +DELETE FROM `spell_script_target` WHERE entry IN +(51859); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(51859, 1, 28525), -- siphon of archerus +(51859, 1, 28542), +(51859, 1, 28543), +(51859, 1, 28544); + +update creature_template set minlevel=50,maxlevel=52,minhealth=2215,maxhealth=2317,faction_A=2084,faction_H=2084,mindmg=50,maxdmg=50 where entry=28528; -- ghoul + -- frostbrood vanquisher update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110 where entry = 28670; + -- -------- -- NAXXARAMAS -- -------- -- cgit v1.2.3