From ffbc016d441ac3330a03aef127edf4a9f90176ab Mon Sep 17 00:00:00 2001 From: Keader Date: Thu, 22 Dec 2016 09:03:16 -0300 Subject: Rename SQL file --- sql/updates/world/3.3.5/2016_12_22_00_world.sql | 24 ++++++++++++++++++++++++ sql/updates/world/3.3.5/2058_18_10_87_world.sql | 24 ------------------------ 2 files changed, 24 insertions(+), 24 deletions(-) create mode 100644 sql/updates/world/3.3.5/2016_12_22_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2058_18_10_87_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_12_22_00_world.sql b/sql/updates/world/3.3.5/2016_12_22_00_world.sql new file mode 100644 index 00000000000..1530d2f5f8f --- /dev/null +++ b/sql/updates/world/3.3.5/2016_12_22_00_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'); 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 deleted file mode 100644 index 1530d2f5f8f..00000000000 --- a/sql/updates/world/3.3.5/2058_18_10_87_world.sql +++ /dev/null @@ -1,24 +0,0 @@ -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