diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/3813_world_spell_(dk).sql | 10 | ||||
| -rw-r--r-- | sql/world_scripts_full.sql | 1 | ||||
| -rw-r--r-- | sql/world_spell_full.sql | 26 |
3 files changed, 30 insertions, 7 deletions
diff --git a/sql/updates/3813_world_spell_(dk).sql b/sql/updates/3813_world_spell_(dk).sql new file mode 100644 index 00000000000..ee12a70afd0 --- /dev/null +++ b/sql/updates/3813_world_spell_(dk).sql @@ -0,0 +1,10 @@ +UPDATE `creature_template` SET `ScriptName`='npc_dkc1_gothik' WHERE `entry`=28658; + +-- gift of harvester +DELETE FROM `spell_script_target` WHERE entry IN +(52479); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(52479,1,28819), +(52479,1,28822); + +update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110, VehicleId = 156 where entry = 28670; diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql index c6b0486456a..fe6fa57933a 100644 --- a/sql/world_scripts_full.sql +++ b/sql/world_scripts_full.sql @@ -109,6 +109,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_taxi' WHERE `entry` IN (17435, UPDATE `creature_template` SET `ScriptName`='npc_death_knight_initiate' WHERE `entry`=28406; UPDATE `creature_template` SET `ScriptName`='npc_salanar_the_horseman' WHERE `entry` IN (28653, 28788); UPDATE `creature_template` SET `ScriptName`='npc_ros_dark_rider' WHERE `entry`=28768; +UPDATE `creature_template` SET `ScriptName`='npc_dkc1_gothik' WHERE `entry`=28658; /* */ /* ZONE */ diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql index 503b5f0bc2e..c1a59dd43c2 100644 --- a/sql/world_spell_full.sql +++ b/sql/world_spell_full.sql @@ -1579,12 +1579,6 @@ spell4 = VALUES(spell4); -- Three-seat mammoth UPDATE creature_template SET VehicleId = 312 WHERE entry IN (31857,31858,31861,31862,32212,32213,32633,32640); --- Horses for quest 12680 / not sure if its offilike -UPDATE creature_template SET `VehicleId`=200 WHERE `entry` IN (28605,28606,28607); - --- Vehicle and summon spell(summon npc 28788) for Acherus Deathcharger -UPDATE creature_template SET `spell1`=52362, `VehicleId`=200 WHERE `entry`=28782; - -- -------- -- Death Knight -- -------- @@ -1611,8 +1605,26 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (52124, 1, 28655); UPDATE `creature_template` SET spell1=52372,spell2=52373,spell3=52374,spell4=52375 WHERE `entry`=28406; +-- death charger +DELETE FROM spell_area WHERE spell = 52693; +INSERT INTO spell_area (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES +(52693, 4298, 12687, 1, 12687, 0, 0, 0, 1); + +-- Horses for quest 12680 / not sure if its offilike +UPDATE creature_template SET `VehicleId`=200 WHERE `entry` IN (28605,28606,28607); + +-- Vehicle and summon spell(summon npc 28788) for Acherus Deathcharger +UPDATE creature_template SET `spell1`=52362, `VehicleId`=200 WHERE `entry`=28782; + +-- gift of harvester +DELETE FROM `spell_script_target` WHERE entry IN +(52479); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(52479,1,28819), +(52479,1,28822); + -- frostbrood vanquisher -update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110 where entry = 28670; +update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110, VehicleId = 156 where entry = 28670; -- -------- |