Core/Scripts: Mother Shahraz encounter rewrite (#18446)

1 files changed, 24 insertions, 0 deletions

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');