From 161d688d936b2ba49083711c1e7eae001101ed16 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Mon, 22 Dec 2014 16:57:57 +0000 Subject: DB/Gossip: some missing gossip menu ids, menus and menu options) Brann Bronzebeard and Lore Keeper of Norgannon (Ulduar) --- sql/updates/world/2014_12_22_00_world.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sql/updates/world/2014_12_22_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/2014_12_22_00_world.sql b/sql/updates/world/2014_12_22_00_world.sql new file mode 100644 index 00000000000..ec1776e5c5b --- /dev/null +++ b/sql/updates/world/2014_12_22_00_world.sql @@ -0,0 +1,16 @@ +DELETE FROM `gossip_menu` WHERE `entry` in(10355,10366,10477); + +INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES +(10355, 14369), +(10366, 14375), +(10477, 14496); + +DELETE FROM `gossip_menu_option` WHERE `menu_id` in(10355,10366,10477); + +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 +(10355, 0, 0, 'We''re ready. Begin the assault!', 33652, 1, 1, 0, 0, 0, 0, NULL, 0), +(10366, 0, 0, 'Activate secondary defensive systems.', 34420, 1, 1, 10477, 0, 0, 0, NULL, 0), +(10477, 0, 0, 'Confirmed.', 34421, 1, 1, 0, 0, 0, 0, NULL, 0); + +UPDATE `creature_template` SET `gossip_menu_id`=10355 WHERE `entry`=33579; +UPDATE `creature_template` SET `gossip_menu_id`=10366 WHERE `entry`=33686; -- cgit v1.2.3