diff options
| -rw-r--r-- | sql/updates/3592_world_spell_(dk).sql | 11 | ||||
| -rw-r--r-- | sql/world_spell_full.sql | 17 | ||||
| -rw-r--r-- | src/game/SpellMgr.cpp | 6 |
3 files changed, 34 insertions, 0 deletions
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 -- -------- diff --git a/src/game/SpellMgr.cpp b/src/game/SpellMgr.cpp index 165b274a7a3..8b01639d1be 100644 --- a/src/game/SpellMgr.cpp +++ b/src/game/SpellMgr.cpp @@ -3422,6 +3422,12 @@ void SpellMgr::LoadSpellCustomAttr() case 28200: // Ascendance (Talisman of Ascendance trinket) spellInfo->procCharges=6; break; + case 51852: // The Eye of Acherus (no spawn in phase 2 in db) + spellInfo->EffectMiscValue[0] |= 1; + break; + case 51904: // Summon Ghouls On Scarlet Crusade (core does not know the triggered spell is summon spell) + spellInfo->EffectImplicitTargetA[0] = TARGET_UNIT_CASTER; + break; default: break; } |