From 05df3cc98813688247dc2ec0ce3899a1369ec0d5 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 25 Aug 2016 08:41:55 +0200 Subject: Rename 2016_99_99_99_world.sql to 2016_08_25_01_world.sql --- sql/updates/world/3.3.5/2016_08_25_01_world.sql | 15 +++++++++++++++ sql/updates/world/3.3.5/2016_99_99_99_world.sql | 15 --------------- 2 files changed, 15 insertions(+), 15 deletions(-) create mode 100644 sql/updates/world/3.3.5/2016_08_25_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2016_99_99_99_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_08_25_01_world.sql b/sql/updates/world/3.3.5/2016_08_25_01_world.sql new file mode 100644 index 00000000000..cc2a6e9049d --- /dev/null +++ b/sql/updates/world/3.3.5/2016_08_25_01_world.sql @@ -0,0 +1,15 @@ +UPDATE `creature_template` SET `ScriptName`='npc_pit_of_saron_icicle' WHERE `entry`=36847; +DELETE FROM `creature` WHERE `id`=32780 AND `guid` IN (202016,202240,201907,201923,202162,202021,202194,202235,202241,202020,202272,202169,202189,202262,202220,202245,202234,202219,202226,201933,202106,202123,201832,202025,202252,202039,202224,202274,202052,202133,202267,201966,202005,202066,202116,202153,202201,201896,202138,202218,201913,202004,201995,202178,202268,202280,202040,202176,201979,202090,202134,202154,202243,201895,202073,202195,202251,202167,202064,201972,201993,202117,201891,201812,201929,202012,202173,202092,202247,202136,201925,202239); +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=12994 AND `type`=18; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_pos_ice_shards'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(70827, 'spell_pos_ice_shards'); + +DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5580,5581); +INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES +(5580, 'at_pit_cavern_entrance'), +(5581, 'at_pit_cavern_end'); + +DELETE FROM `creature_text` WHERE `entry`=36794 AND `groupid`=3; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(36794,3,0,'Rimefang, trap them within the tunnel! BURY THEM ALIVE!',14,0,100,0,0,16757,36714,1,'SAY_TYRANNUS_CAVERN_ENTRANCE'); diff --git a/sql/updates/world/3.3.5/2016_99_99_99_world.sql b/sql/updates/world/3.3.5/2016_99_99_99_world.sql deleted file mode 100644 index cc2a6e9049d..00000000000 --- a/sql/updates/world/3.3.5/2016_99_99_99_world.sql +++ /dev/null @@ -1,15 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_pit_of_saron_icicle' WHERE `entry`=36847; -DELETE FROM `creature` WHERE `id`=32780 AND `guid` IN (202016,202240,201907,201923,202162,202021,202194,202235,202241,202020,202272,202169,202189,202262,202220,202245,202234,202219,202226,201933,202106,202123,201832,202025,202252,202039,202224,202274,202052,202133,202267,201966,202005,202066,202116,202153,202201,201896,202138,202218,201913,202004,201995,202178,202268,202280,202040,202176,201979,202090,202134,202154,202243,201895,202073,202195,202251,202167,202064,201972,201993,202117,201891,201812,201929,202012,202173,202092,202247,202136,201925,202239); -DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=12994 AND `type`=18; -DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_pos_ice_shards'; -INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES -(70827, 'spell_pos_ice_shards'); - -DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5580,5581); -INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES -(5580, 'at_pit_cavern_entrance'), -(5581, 'at_pit_cavern_end'); - -DELETE FROM `creature_text` WHERE `entry`=36794 AND `groupid`=3; -INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES -(36794,3,0,'Rimefang, trap them within the tunnel! BURY THEM ALIVE!',14,0,100,0,0,16757,36714,1,'SAY_TYRANNUS_CAVERN_ENTRANCE'); -- cgit v1.2.3