From 65a40a5437eeb43897923ed44122d480d98da2af Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 2 Jul 2011 12:36:48 +0200 Subject: Scripts/Icecrown Citadel: Teleporting to the Frozen Throne should now happen as on retail (with an areatrigger, not gossip), also added missing spawns to Frozen Throne and Tirion's gossip NOTE: This does NOT mean The Lich King script is coming soon --- .../world/2011_07_02_00_world_areatrigger_scripts.sql | 3 +++ .../world/2011_07_02_00_world_instance_misc.sql | 18 ++++++++++++++++++ 2 files changed, 21 insertions(+) create mode 100644 sql/updates/world/2011_07_02_00_world_areatrigger_scripts.sql create mode 100644 sql/updates/world/2011_07_02_00_world_instance_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_07_02_00_world_areatrigger_scripts.sql b/sql/updates/world/2011_07_02_00_world_areatrigger_scripts.sql new file mode 100644 index 00000000000..6a9a93e59c6 --- /dev/null +++ b/sql/updates/world/2011_07_02_00_world_areatrigger_scripts.sql @@ -0,0 +1,3 @@ +DELETE FROM `areatrigger_scripts` WHERE `entry`=5718; +INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES +(5718,'at_frozen_throne_teleport'); diff --git a/sql/updates/world/2011_07_02_00_world_instance_misc.sql b/sql/updates/world/2011_07_02_00_world_instance_misc.sql new file mode 100644 index 00000000000..f8d37d99385 --- /dev/null +++ b/sql/updates/world/2011_07_02_00_world_instance_misc.sql @@ -0,0 +1,18 @@ +UPDATE `gameobject_template` SET `flags`=48 WHERE `entry`=202223; -- Scourge Transporter to the Frozen Throne +UPDATE `gameobject_template` SET `flags`=32 WHERE `entry` IN (202242,202243,202244,202245,202235,202246); -- Scourge Transporters + +DELETE FROM `gameobject` WHERE `id` IN (202189,202188); +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(151,202189,631,15,1,503.62,-2124.66,836.607,3.14159,0,0,0,1,6000,255,1), +(153,202188,631,15,1,503.62,-2124.66,836.607,3.14159,0,0,0,1,6000,255,0); + +-- Highlord Tirion Fordring gossip +UPDATE `creature_template` SET `gossip_menu_id`=10993 WHERE `entry`=38995; + +DELETE FROM `gossip_menu` WHERE `entry`=10993; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES +(10993,15290); + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=10993; +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES +(10993,0,0,'We are prepared, Highlord. Let us battle for the fate of Azeroth! For the light of dawn!',1,1,0,0,0,0,''); -- cgit v1.2.3