From bb8922a5e49f907da8a9671a952d46b6b1a523c5 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Wed, 9 Jul 2014 08:58:27 +0200 Subject: DB/Misc: Chromie at begining of The Culling of Stratholme By w1sht0l1v3, updates #5516 --- sql/updates/world/2014_07_09_00_world_misc.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/world/2014_07_09_00_world_misc.sql (limited to 'sql') diff --git a/sql/updates/world/2014_07_09_00_world_misc.sql b/sql/updates/world/2014_07_09_00_world_misc.sql new file mode 100644 index 00000000000..ddc83353176 --- /dev/null +++ b/sql/updates/world/2014_07_09_00_world_misc.sql @@ -0,0 +1,18 @@ +-- Chromie -- at start of CoS +SET @SPELL_TRIGGER := 53435; -- Teleport to CoT Stratholme Phase 4 +SET @SPELL_EFFECT := 53436; -- Teleport to CoT Stratholme Phase 4 + +DELETE FROM `gossip_menu_option` WHERE `menu_id` = @MENUID5 or `menu_id` = @MENUID1 and `id` = 2; +INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES +(9586, 2, 0, 'Chromie, you and I both know what\'s going to happen in this time stream. We\'ve seen this all before. Can you just skip us ahead to all the real action?', 39667, 1, 1, 11277, 0, 0, 0, '', 0), +(11277, 0, 0, 'Yes, please!', 32024, 1, 1, 0, 0, 0, 0, '', 0); + +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=@SPELL_TRIGGER; +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(@SPELL_TRIGGER,@SPELL_EFFECT,1,'Teleport to CoT Stratholme Phase 4'); + +DELETE FROM `spell_target_position` WHERE `id`=@SPELL_EFFECT; +INSERT INTO `spell_target_position` (`id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`) VALUES +(@SPELL_EFFECT,595,2071.55,1287.68,141.687,0); + +UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=18338; -- cgit v1.2.3