From c2dace57db69f679432a790e90603f7a0e6f21e1 Mon Sep 17 00:00:00 2001 From: Keader Date: Thu, 22 Dec 2016 08:59:08 -0300 Subject: Core/Scripts: Mother Shahraz encounter rewrite (#18446) --- sql/updates/world/3.3.5/2058_18_10_87_world.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 sql/updates/world/3.3.5/2058_18_10_87_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2058_18_10_87_world.sql b/sql/updates/world/3.3.5/2058_18_10_87_world.sql new file mode 100644 index 00000000000..1530d2f5f8f --- /dev/null +++ b/sql/updates/world/3.3.5/2058_18_10_87_world.sql @@ -0,0 +1,24 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( +'spell_mother_shahraz_fatal_attraction', +'spell_mother_shahraz_fatal_attraction_link', +'spell_mother_shahraz_saber_lash', +'spell_mother_shahraz_generic_periodic', +'spell_mother_shahraz_random_periodic'); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(40869,'spell_mother_shahraz_fatal_attraction'), +(40870,'spell_mother_shahraz_fatal_attraction_link'), +(40816,'spell_mother_shahraz_saber_lash'), +(40863,'spell_mother_shahraz_generic_periodic'), +(40865,'spell_mother_shahraz_generic_periodic'), +(40866,'spell_mother_shahraz_generic_periodic'), +(40862,'spell_mother_shahraz_generic_periodic'), +(40867,'spell_mother_shahraz_random_periodic'); + +DELETE FROM `creature_addon` WHERE `guid`=52760; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(52760, 0, 0, 0, 0, 0, 40816); + +DELETE FROM `creature_text` WHERE entry=22947 AND `groupid` IN(6,7); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(22947, 6, 0, '%s goes into a frenzy!', 41, 0, 100, 0, 0, 0, 2384, 0, 'shahraz EMOTE_ENRAGE'), +(22947, 7, 0, '%s goes into a berserker rage!', 16, 0, 100, 0, 0, 0, 4428, 0, 'shahraz EMOTE_BERSERK'); -- cgit v1.2.3