DB/Gossip: some missing gossip menu ids, menus and menu options)

Brann Bronzebeard and Lore Keeper of Norgannon (Ulduar)

1 files changed, 16 insertions, 0 deletions

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;