From 5e485cba769d3b640d56a00ea179a8ee0090febc Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 8 Apr 2012 15:15:16 +0200 Subject: Scripts/Icecrown Citadel: Fixed Mystic Buffet applying on targets hidden behind Ice Tombs --- sql/updates/world/2012_04_08_00_world_creature_template.sql | 2 -- sql/updates/world/2012_04_08_01_world_creature_template.sql | 2 ++ sql/updates/world/2012_04_08_02_world_spell_script_names.sql | 6 ++++++ 3 files changed, 8 insertions(+), 2 deletions(-) delete mode 100644 sql/updates/world/2012_04_08_00_world_creature_template.sql create mode 100644 sql/updates/world/2012_04_08_01_world_creature_template.sql create mode 100644 sql/updates/world/2012_04_08_02_world_spell_script_names.sql (limited to 'sql') diff --git a/sql/updates/world/2012_04_08_00_world_creature_template.sql b/sql/updates/world/2012_04_08_00_world_creature_template.sql deleted file mode 100644 index c6665729b75..00000000000 --- a/sql/updates/world/2012_04_08_00_world_creature_template.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Gymer -UPDATE `creature_template` SET `unit_class`=4,`spell1`=55426,`spell2`=55429,`spell3`=55516,`spell4`=55421,`VehicleId`=205 WHERE `entry`=29884; diff --git a/sql/updates/world/2012_04_08_01_world_creature_template.sql b/sql/updates/world/2012_04_08_01_world_creature_template.sql new file mode 100644 index 00000000000..c6665729b75 --- /dev/null +++ b/sql/updates/world/2012_04_08_01_world_creature_template.sql @@ -0,0 +1,2 @@ +-- Gymer +UPDATE `creature_template` SET `unit_class`=4,`spell1`=55426,`spell2`=55429,`spell3`=55516,`spell4`=55421,`VehicleId`=205 WHERE `entry`=29884; diff --git a/sql/updates/world/2012_04_08_02_world_spell_script_names.sql b/sql/updates/world/2012_04_08_02_world_spell_script_names.sql new file mode 100644 index 00000000000..dd23c9ef560 --- /dev/null +++ b/sql/updates/world/2012_04_08_02_world_spell_script_names.sql @@ -0,0 +1,6 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_sindragosa_mystic_buffet'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(70127,'spell_sindragosa_mystic_buffet'), +(72528,'spell_sindragosa_mystic_buffet'), +(72529,'spell_sindragosa_mystic_buffet'), +(72530,'spell_sindragosa_mystic_buffet'); -- cgit v1.2.3