diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/455_world.sql | 14 | ||||
| -rw-r--r-- | sql/updates/full/world_script.sql | 1 |
2 files changed, 14 insertions, 1 deletions
diff --git a/sql/updates/455_world.sql b/sql/updates/455_world.sql new file mode 100644 index 00000000000..74c52f164b0 --- /dev/null +++ b/sql/updates/455_world.sql @@ -0,0 +1,14 @@ +-- demon fire +update creature_template set spell1 = 40029, flags_extra = 128, scriptname = '' where entry = 23069; +-- pillar of fire +update creature_template set spell1 = 43218, flags_extra = 128, scriptname = '' where entry = 24187; +-- Broggok Poison Cloud +update creature_template set spell1 = 30914, flags_extra = 128, scriptname = '' where entry = 17662; + + +INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43468, 44007, 1, 'Storm Eye Safe Zone'); +INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43658, 43653, 0, 'Electrical Arc Visual'); +INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43658, 43654, 0, 'Electrical Arc Visual'); +INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43658, 43655, 0, 'Electrical Arc Visual'); +INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43658, 43656, 0, 'Electrical Arc Visual'); +INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43658, 43659, 0, 'Electrical Arc Visual');
\ No newline at end of file diff --git a/sql/updates/full/world_script.sql b/sql/updates/full/world_script.sql index e1bd272425a..278ed085a65 100644 --- a/sql/updates/full/world_script.sql +++ b/sql/updates/full/world_script.sql @@ -19,7 +19,6 @@ UPDATE `creature_template` SET `ScriptName` = 'boss_fenstalker' WHERE `entry` =2 UPDATE `creature_template` SET `ScriptName` = 'boss_darkheart' WHERE `entry` =24246; UPDATE `creature_template` SET `ScriptName` = 'boss_koragg' WHERE `entry` =24247; UPDATE `creature_template` SET `ScriptName` = 'boss_zuljin' WHERE `entry` =23863; -UPDATE `creature_template` SET `ScriptName` = 'do_nothing' WHERE `entry` = '24187'; UPDATE `creature_template` SET `ScriptName` = 'mob_zuljin_vortex' WHERE `entry` = '24136'; UPDATE `creature_template` SET `ScriptName` = 'npc_zulaman_hostage' WHERE `entry` IN (23790, 23999, 24024, 24001); |