diff options
| author | Gustavo <sirikfoll@hotmail.com> | 2016-08-25 08:40:02 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-18 16:16:00 +0100 |
| commit | a4fc7d9d2d66b3d5f8a87f13bd368377d186d9dd (patch) | |
| tree | 6b1d33c7170a696ba54a5ed82d1a5fc0c314a552 /sql | |
| parent | e8df5babe61491d49922b48e4f88be1784390e07 (diff) | |
Core/Scripts Implement Pit of Saron Cavern event
(cherry picked from commit b459c6607f80701945cb822d8c7519998cad205f)
Rename 2016_99_99_99_world.sql to 2016_08_25_01_world.sql
(cherry picked from commit 05df3cc98813688247dc2ec0ce3899a1369ec0d5)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_02_18_21_world_2016_08_25_01_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_18_21_world_2016_08_25_01_world.sql b/sql/updates/world/master/2017_02_18_21_world_2016_08_25_01_world.sql new file mode 100644 index 00000000000..a1af94861e2 --- /dev/null +++ b/sql/updates/world/master/2017_02_18_21_world_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'); |