DB/Gossip: Northrend Gossips

Closes #22097

1 files changed, 241 insertions, 0 deletions

diff --git a/sql/updates/world/master/2018_09_09_00_world.sql b/sql/updates/world/master/2018_09_09_00_world.sql
new file mode 100644
index 00000000000..71c924e9fe3
--- /dev/null
+++ b/sql/updates/world/master/2018_09_09_00_world.sql
@@ -0,0 +1,241 @@
+-- 
+DELETE FROM `points_of_interest` WHERE `ID` IN (616, 615, 663, 662, 661, 660, 659, 654, 658, 657, 656, 655, 623, 622, 647, 653, 652, 651, 650, 649, 648, 646, 645, 644, 643, 618, 642, 628, 627, 641, 640, 639, 630, 638, 637, 636, 635, 634, 633, 632, 631, 620, 619, 617, 626, 629, 625, 624, 621);
+INSERT INTO `points_of_interest` (`ID`, `PositionX`, `PositionY`, `Icon`, `Flags`, `Importance`, `Name`, `VerifiedBuild`) VALUES
+(616, 5816.39, 760.085, 7, 99, 0, 'Dalaran Western Sewer Entrance', 26365),
+(615, 5802.76, 552.28, 7, 99, 0, 'Dalaran Eastern Sewer Entrance', 26365),
+(663, 5884.7, 608.281, 7, 99, 0, 'Dalaran Wine & Cheese', 26365),
+(662, 5667.76, 645.391, 7, 99, 0, 'Dalaran Staves & Wands', 26365),
+(661, 5780.4, 558.349, 7, 99, 0, 'Dalaran Ranged Weapons', 26365),
+(660, 5727.33, 603.694, 7, 99, 0, 'Dalaran Melee Weapons', 26365),
+(659, 5752.08, 645.427, 7, 99, 0, 'Dalaran Trinkets', 26365),
+(654, 5684.03, 617.319, 7, 99, 0, 'Dalaran General & Trade Store', 26365),
+(658, 5814.42, 690.78, 7, 99, 0, 'Dalaran Toy Store', 26365),
+(657, 5765.6, 734.329, 7, 99, 0, 'Dalaran Reagents', 26365),
+(656, 5906.35, 628.194, 7, 99, 0, 'Dalaran Pie, Pastry & Cake', 26365),
+(655, 5847.11, 567.15, 7, 99, 0, 'Dalaran Pet Store', 26365),
+(623, 5857.26, 595.421, 7, 99, 0, 'Dalaran Sunreaver\'s Sanctuary', 26365),
+(622, 5758.11, 715.641, 7, 99, 0, 'Dalaran Silver Enclave', 26365),
+(647, 5873.86, 721.729, 7, 99, 0, 'Dalaran Jewelcrafting Trainer', 26365),
+(653, 5750.41, 695.409, 7, 99, 0, 'Dalaran Fruit Vendor', 26365),
+(652, 5773.1, 576.271, 7, 99, 0, 'Dalaran Flowers', 26365),
+(651, 5790.16, 689.124, 7, 99, 0, 'Dalaran Cloth Armor & Clothing', 26365),
+(650, 5882.51, 745.847, 7, 99, 0, 'Dalaran Tailoring Trainer', 26365),
+(649, 5919.47, 709.664, 7, 99, 0, 'Dalaran Mining Trainer', 26365),
+(648, 5903.03, 750.206, 7, 99, 0, 'Dalaran Leatherworking Trainer', 26365),
+(646, 5860.68, 702.517, 7, 99, 0, 'Dalaran Inscription Trainer', 26365),
+(645, 5875.57, 691.28, 7, 99, 0, 'Dalaran Herbalism Trainer', 26365),
+(644, 5704.84, 613.969, 7, 99, 0, 'Dalaran Fishing Fountain', 26365),
+(643, 5862.84, 743.351, 7, 99, 0, 'Dalaran First Aid Trainer', 26365),
+(618, 5920.67, 728.168, 7, 99, 0, 'Dalaran Engineering Trainer', 26365),
+(642, 5837.26, 722.8, 7, 99, 0, 'Dalaran Enchanting Trainer', 26365),
+(628, 5885.62, 521.776, 7, 99, 0, 'Dalaran Horde Inn', 26365),
+(627, 5731.46, 678.199, 7, 99, 0, 'Dalaran Alliance Inn', 26365),
+(641, 5904.31, 680.889, 7, 99, 0, 'Dalaran Blacksmithing Trainer', 26365),
+(640, 5890.97, 704.071, 7, 99, 0, 'Dalaran Alchemy Trainer', 26365),
+(639, 5808.53, 581.308, 7, 99, 0, 'Dalaran Mage Trainer', 26365),
+(630, 5831.51, 508.617, 7, 99, 0, 'Dalaran Krasus\' Landing', 26365),
+(638, 5859.73, 557.745, 7, 99, 0, 'Dalaran Stable Master', 26365),
+(637, 5851.66, 766.287, 7, 99, 0, 'Dalaran Cemetary', 26365),
+(636, 5710.33, 645.397, 7, 99, 0, 'Dalaran Eventide', 26365),
+(635, 5804.6, 639.554, 7, 99, 0, 'Dalaran Runeweaver Square', 26365),
+(634, 5952.15, 674.611, 7, 99, 0, 'Dalaran Antonidas Memorial', 26365),
+(633, 5899.21, 728.851, 7, 99, 0, 'Dalaran Trade District', 26365),
+(632, 5691.49, 500.56, 7, 99, 0, 'Dalaran Violet Hold', 26365),
+(631, 5797.48, 794.906, 7, 99, 0, 'Dalaran Violet Citadel', 26365),
+(620, 5640.99, 687.532, 7, 99, 0, 'Dalaran Southern Bank', 26365),
+(619, 5966.82, 613.917, 7, 99, 0, 'Dalaran Northern Bank', 26365),
+(617, 5879.9, 652.782, 7, 99, 0, 'Dalaran Well', 26365),
+(626, 5848.26, 636.675, 7, 99, 0, 'Dalaran Inn', 26365),
+(629, 5934.05, 575.626, 7, 99, 0, 'Dalaran Locksmith', 26365),
+(625, 5756.87, 620.785, 7, 99, 0, 'Dalaran Visitor Center', 26365),
+(624, 5813.97, 449.107, 7, 99, 0, 'Dalaran Flight Master', 26365),
+(621, 5889.37, 622.227, 7, 99, 0, 'Dalaran Barber', 26365);
+
+DELETE FROM `gossip_menu` WHERE (`MenuId`=15035 AND `TextId`=21269) OR (`MenuId`=10133 AND `TextId`=14069) OR (`MenuId`=18643 AND `TextId`=27081) OR (`MenuId`=10034 AND `TextId`=13944) OR (`MenuId`=18865 AND `TextId`=27472) OR (`MenuId`=10883 AND `TextId`=15119) OR (`MenuId`=15086 AND `TextId`=21408) OR (`MenuId`=14163 AND `TextId`=13845) OR (`MenuId`=9873 AND `TextId`=27896) OR (`MenuId`=15029 AND `TextId`=21261) OR (`MenuId`=9660 AND `TextId`=13083) OR (`MenuId`=9659 AND `TextId`=13082) OR (`MenuId`=15032 AND `TextId`=21264) OR (`MenuId`=15134 AND `TextId`=12909) OR (`MenuId`=9608 AND `TextId`=12982) OR (`MenuId`=18293 AND `TextId`=26320) OR (`MenuId`=9798 AND `TextId`=13502) OR (`MenuId`=9019 AND `TextId`=12186) OR (`MenuId`=9014 AND `TextId`=12180) OR (`MenuId`=8985 AND `TextId`=12124) OR (`MenuId`=15028 AND `TextId`=21260) OR (`MenuId`=15135 AND `TextId`=11291) OR (`MenuId`=13045 AND `TextId`=18320) OR (`MenuId`=9600 AND `TextId`=12960) OR (`MenuId`=21161 AND `TextId`=12976) OR (`MenuId`=20913 AND `TextId`=31474) OR (`MenuId`=15030 AND `TextId`=21262) OR (`MenuId`=9429 AND `TextId`=12687) OR (`MenuId`=9259 AND `TextId`=12568) OR (`MenuId`=13046 AND `TextId`=18321) OR (`MenuId`=11520 AND `TextId`=15569);
+INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `VerifiedBuild`) VALUES
+(15035, 21269, 26365), -- Major Payne
+(10133, 14069, 26365), -- 31737 (Skybreaker Squad Leader)
+(18643, 27081, 26365), -- 95959 (Krul Rockhorn)
+(10034, 13944, 26365), -- 31135 (Geirrvif)
+(18865, 27472, 26365), -- 98223 (Dani Earthtouch)
+(10883, 15119, 26365), -- 30322 (Earthen Jormungar Handler)
+(15086, 21408, 26365), -- 29529 (Ninsianna)
+(14163, 13845, 26365), -- 28956 (Warcaster Fanoraithe)
+(9873, 27896, 26365), -- 28701 (Timothy Jones)
+(15029, 21261, 26365), -- Nearly Headless Jacob
+(9660, 13083, 26365), -- 28142 (Crusader Lamoof)
+(9659, 13082, 26365), -- 28136 (Crusader Jonathan)
+(15032, 21264, 26365), -- Gutretch
+(15134, 12909, 26365), -- 26377 (Squire Percy)
+(9608, 12982, 26365), -- 26212 (Captain Gryan Stoutmantle)
+(18293, 26320, 26365), -- 91632 (Remington Brode)
+(9798, 13502, 26365), -- 29244 (Jesse Masters)
+(9019, 12186, 26365), -- 24741 (Annie Bonn)
+(9014, 12180, 26365), -- 24639 (Olga, the Scalawag Wench)
+(8985, 12124, 26365), -- 24544 (Old Icefin)
+(15028, 21260, 26365), -- Beegle Blastfuse
+(15135, 11291, 26365), -- 23733 (Horatio the Stable Boy)
+(13045, 18320, 26365), -- 23736 (Pricilla Winterwind)
+(9600, 12960, 26365), -- 27784 (Commander Eligor Dawnbringer)
+(21161, 12976, 26365), -- 27856 (Chromie)
+(20913, 31474, 26365), -- 27938 (Trizormu)
+(15030, 21262, 26365), -- Okrut Dragonwaste
+(9429, 12687, 26365), -- 26619 (Fizzcrank Paratrooper)
+(9259, 12568, 26365), -- 26117 (Raelorasz)
+(13046, 18321, 26365), -- 26879 (Tomas Riverwell)
+(11520, 15569, 26365); -- 36915 (Erunak Stonespeaker)
+
+DELETE FROM `gossip_menu_option` WHERE  (`MenuId`=18865 AND `OptionIndex`=1) OR (`MenuId`=14163 AND `OptionIndex`=9) OR (`MenuId`=14163 AND `OptionIndex`=8) OR (`MenuId`=15134 AND `OptionIndex`=2) OR (`MenuId`=15134 AND `OptionIndex`=1) OR (`MenuId`=8886 AND `OptionIndex`=0) OR (`MenuId`=15135 AND `OptionIndex`=2) OR (`MenuId`=15135 AND `OptionIndex`=1) OR (`MenuId`=20913 AND `OptionIndex`=1) OR (`MenuId`=9165 AND `OptionIndex`=1) OR (`MenuId`=9165 AND `OptionIndex`=0) OR (`MenuId`=9219 AND `OptionIndex`=0) OR (`MenuId`=9218 AND `OptionIndex`=0) OR (`MenuId`=9217 AND `OptionIndex`=0);
+INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `VerifiedBuild`) VALUES
+(18865, 1, 3, 'Train me in the ways of herbalism.', 15944, 26365),
+(14163, 9, 0, 'I want to talk about the Arcane Momentum technique.', 125293, 26365),
+(14163, 8, 0, 'Enter the Proving Grounds', 74757, 26365),
+(15134, 2, 0, 'I\'d like to heal and revive my battle pets.', 64115, 26365),
+(15134, 1, 1, 'I\'m looking for a lost companion.', 56613, 26365),
+(8886, 0, 0, 'Sergeant, loan me your spyglass.', 22774, 26365),
+(15135, 2, 0, 'I\'d like to heal and revive my battle pets.', 64115, 26365),
+(15135, 1, 1, 'I\'m looking for a lost companion.', 56613, 26365),
+(20913, 1, 1, 'What do you have for sale?', 20994, 26365), -- OptionBroadcastTextID: 10182 - 16129 - 16134 - 16135 - 16452 - 20994 - 53758 - 66614 - 117193 - 122305 - 122306
+(9165, 1, 0, 'Crafty, I need another Warsong banner.', 24760, 26365),
+(9165, 0, 0, 'Crafty, I lost my Warsong orc disguise.', 24759, 26365),
+(9219, 0, 0, 'How long have you worked for the Cult of the Damned?', 25242, 26365),
+(9218, 0, 0, 'I have reason to believe you\'re involved in cultist activity.', 25239, 26365),
+(9217, 0, 0, 'What do you know about the Cult of the Damned?', 25237, 26365);
+
+DELETE FROM `gossip_menu_option` WHERE  `MenuId`=9253;
+INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`) VALUES
+(9253, 0, 0, "What is the cause of this conflict?", 25371, 1, 1),
+(9253, 1, 0, "I seem to have lost the Augmented Arcane Prison. Did I leave it here with you?", 25369, 1, 1);
+
+DELETE FROM `gossip_menu_option` WHERE (`MenuId`=9763 AND `OptionIndex`=0);
+DELETE FROM `gossip_menu_option` WHERE (`MenuId`=10202 AND `OptionIndex`=1 AND `OptionIcon`=1);
+UPDATE `gossip_menu_option` SET `OptionIndex`=1, `OptionBroadcastTextId`=2822, `OptionType`=8, `OptionNpcFlag`=65536, `VerifiedBuild`=26365 WHERE (`MenuId`=10202 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=8097, `OptionType`=3, `OptionNpcFlag`=128, `VerifiedBuild`=26365 WHERE (`MenuId`=10202 AND `OptionIndex`=2);
+DELETE FROM `gossip_menu_option` WHERE (`MenuId`=10201 AND `OptionIndex`=1 AND `OptionIcon`=1);
+UPDATE `gossip_menu_option` SET `OptionIndex`=1, `OptionBroadcastTextId`=2822, `OptionType`=8, `OptionNpcFlag`=65536, `VerifiedBuild`=26365 WHERE (`MenuId`=10201 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=8097, `OptionType`=3, `OptionNpcFlag`=128, `VerifiedBuild`=26365 WHERE (`MenuId`=10201 AND `OptionIndex`=2);
+DELETE FROM `gossip_menu_option` WHERE (`MenuId`=9733 AND `OptionIndex`=1 AND `OptionIcon`=1);
+UPDATE `gossip_menu_option` SET `OptionIndex`=1, `OptionBroadcastTextId`=2822, `OptionType`=8, `OptionNpcFlag`=65536, `VerifiedBuild`=26365 WHERE (`MenuId`=9733 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=8097, `OptionType`=3, `OptionNpcFlag`=128, `VerifiedBuild`=26365 WHERE (`MenuId`=9733 AND `OptionIndex`=2);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32104, `VerifiedBuild`=26365 WHERE (`MenuId`=10160 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32103, `VerifiedBuild`=26365 WHERE (`MenuId`=10160 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=33190, `VerifiedBuild`=26365 WHERE (`MenuId`=10273 AND `OptionIndex`=0); -- for 3.3.5
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=33194, `VerifiedBuild`=26365 WHERE (`MenuId`=10274 AND `OptionIndex`=0); -- for 3.3.5
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=30634, `VerifiedBuild`=26365 WHERE (`MenuId`=9860 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=30634, `VerifiedBuild`=26365 WHERE (`MenuId`=9855 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=23824, `VerifiedBuild`=26365 WHERE (`MenuId`=9013 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=23829, `VerifiedBuild`=26365 WHERE (`MenuId`=9014 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=53141, `VerifiedBuild`=26365 WHERE (`MenuId`=13045 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionText`='Take their clothing.', `OptionBroadcastTextId`=24733, `VerifiedBuild`=26365 WHERE (`MenuId`=9155 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionText`='Take their clothing.', `OptionBroadcastTextId`=24733, `VerifiedBuild`=26365 WHERE (`MenuId`=9156 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=25042, `VerifiedBuild`=26365 WHERE (`MenuId`=9190 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=25923, `VerifiedBuild`=26365 WHERE (`MenuId`=9429 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionText`="Thank you for telling me your story.", `VerifiedBuild`=26365 WHERE (`MenuId`=9182 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=29212, `VerifiedBuild`=26365 WHERE (`MenuId`=9761 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=53141, `VerifiedBuild`=26365 WHERE (`MenuId`=13046 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=41414, `VerifiedBuild`=26365 WHERE (`MenuId`=11520 AND `OptionIndex`=0);
+
+DELETE FROM `gossip_menu_option_action` WHERE (`MenuId`=9812 AND `OptionIndex`=0) OR (`MenuId`=9900 AND `OptionIndex`=1) OR (`MenuId`=9832 AND `OptionIndex`=0) OR (`MenuId`=9860 AND `OptionIndex`=0) OR (`MenuId`=9855 AND `OptionIndex`=0) OR (`MenuId`=8886 AND `OptionIndex`=0) OR (`MenuId`=9546 AND `OptionIndex`=1) OR (`MenuId`=9182 AND `OptionIndex`=0) OR (`MenuId`=9253 AND `OptionIndex`=1) OR (`MenuId`=9253 AND `OptionIndex`=0);
+INSERT INTO `gossip_menu_option_action` (`MenuId`, `OptionIndex`, `ActionMenuId`, `ActionPoiId`) VALUES
+(9812, 0, 9806, 0),
+-- (9900, 1, 9899, 0),
+(9832, 0, 11431, 0),
+(9860, 0, 9852, 0),
+(9855, 0, 9852, 0),
+(8886, 0, 8929, 0),
+(9546, 1, 8926, 0),
+-- (9182, 0, 9181, 0),
+(9253, 1, 9259, 0),
+(9253, 0, 9283, 0);
+
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=616 WHERE (`MenuId`=10105 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=615 WHERE (`MenuId`=10105 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=663 WHERE (`MenuId`=10173 AND `OptionIndex`=14);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=662 WHERE (`MenuId`=10168 AND `OptionIndex`=2);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=661 WHERE (`MenuId`=10168 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=660 WHERE (`MenuId`=10168 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=659 WHERE (`MenuId`=10173 AND `OptionIndex`=12);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=654 WHERE (`MenuId`=10173 AND `OptionIndex`=11);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=658 WHERE (`MenuId`=10173 AND `OptionIndex`=10);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=657 WHERE (`MenuId`=10173 AND `OptionIndex`=9);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=656 WHERE (`MenuId`=10173 AND `OptionIndex`=8);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=655 WHERE (`MenuId`=10173 AND `OptionIndex`=7);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=623 WHERE (`MenuId`=10160 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=622 WHERE (`MenuId`=10160 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionMenuId`=10160 WHERE (`MenuId`=10173 AND `OptionIndex`=6);
+UPDATE `gossip_menu_option_action` SET `ActionMenuId`=10169, `ActionPoiId`=647 WHERE (`MenuId`=10173 AND `OptionIndex`=5);
+UPDATE `gossip_menu_option_action` SET `ActionMenuId`=10157, `ActionPoiId`=654 WHERE (`MenuId`=10173 AND `OptionIndex`=4);
+UPDATE `gossip_menu_option_action` SET `ActionMenuId`=10158, `ActionPoiId`=653 WHERE (`MenuId`=10173 AND `OptionIndex`=3);
+UPDATE `gossip_menu_option_action` SET `ActionMenuId`=10159, `ActionPoiId`=652 WHERE (`MenuId`=10173 AND `OptionIndex`=2);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=651 WHERE (`MenuId`=10173 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=651 WHERE (`MenuId`=10170 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=650 WHERE (`MenuId`=10078 AND `OptionIndex`=14);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=649 WHERE (`MenuId`=10078 AND `OptionIndex`=12);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=648 WHERE (`MenuId`=10078 AND `OptionIndex`=11);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=647 WHERE (`MenuId`=10078 AND `OptionIndex`=10);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=646 WHERE (`MenuId`=10078 AND `OptionIndex`=9);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=645 WHERE (`MenuId`=10078 AND `OptionIndex`=8);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=644 WHERE (`MenuId`=10078 AND `OptionIndex`=7);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=643 WHERE (`MenuId`=10078 AND `OptionIndex`=6);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=618 WHERE (`MenuId`=10078 AND `OptionIndex`=5);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=642 WHERE (`MenuId`=10078 AND `OptionIndex`=4);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=628 WHERE (`MenuId`=10073 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=627 WHERE (`MenuId`=10073 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=641 WHERE (`MenuId`=10078 AND `OptionIndex`=2);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=640 WHERE (`MenuId`=10078 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=639 WHERE (`MenuId`=10082 AND `OptionIndex`=4);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=630 WHERE (`MenuId`=10082 AND `OptionIndex`=3);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=639 WHERE (`MenuId`=10082 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=638 WHERE (`MenuId`=10043 AND `OptionIndex`=11);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=637 WHERE (`MenuId`=10056 AND `OptionIndex`=10);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=636 WHERE (`MenuId`=10056 AND `OptionIndex`=9);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=635 WHERE (`MenuId`=10056 AND `OptionIndex`=8);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=634 WHERE (`MenuId`=10056 AND `OptionIndex`=7);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=630 WHERE (`MenuId`=10056 AND `OptionIndex`=6);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=633 WHERE (`MenuId`=10056 AND `OptionIndex`=5);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=632 WHERE (`MenuId`=10056 AND `OptionIndex`=3);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=631 WHERE (`MenuId`=10056 AND `OptionIndex`=2);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=623 WHERE (`MenuId`=10056 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=622 WHERE (`MenuId`=10056 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=630 WHERE (`MenuId`=10090 AND `OptionIndex`=2);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=626 WHERE (`MenuId`=10090 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=629 WHERE (`MenuId`=10043 AND `OptionIndex`=8);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=628 WHERE (`MenuId`=10084 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=627 WHERE (`MenuId`=10084 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=626 WHERE (`MenuId`=10043 AND `OptionIndex`=7);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=625 WHERE (`MenuId`=10043 AND `OptionIndex`=6);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=624 WHERE (`MenuId`=10043 AND `OptionIndex`=5);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=623 WHERE (`MenuId`=10058 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=622 WHERE (`MenuId`=10058 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=621 WHERE (`MenuId`=10043 AND `OptionIndex`=3);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=617 WHERE (`MenuId`=10055 AND `OptionIndex`=2);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=616 WHERE (`MenuId`=10055 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=615 WHERE (`MenuId`=10055 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=620 WHERE (`MenuId`=10089 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=619 WHERE (`MenuId`=10089 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=618 WHERE (`MenuId`=10043 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=617 WHERE (`MenuId`=10057 AND `OptionIndex`=2);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=616 WHERE (`MenuId`=10057 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option_action` SET `ActionPoiId`=615 WHERE (`MenuId`=10057 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option_action` SET `ActionMenuId`=9014 WHERE (`MenuId`=9015 AND `OptionIndex`=0);
+
+DELETE FROM `gossip_menu_option_trainer` WHERE (`MenuId`=18865 AND `OptionIndex`=1) OR (`MenuId`=9750 AND `OptionIndex`=0) OR (`MenuId`=10723 AND `OptionIndex`=0) OR (`MenuId`=10210 AND `OptionIndex`=0) OR (`MenuId`=9777 AND `OptionIndex`=0) OR (`MenuId`=9833 AND `OptionIndex`=0) OR (`MenuId`=9772 AND `OptionIndex`=0) OR (`MenuId`=10628 AND `OptionIndex`=1) OR (`MenuId`=10627 AND `OptionIndex`=0) OR (`MenuId`=9873 AND `OptionIndex`=0) OR (`MenuId`=10118 AND `OptionIndex`=0) OR (`MenuId`=10116 AND `OptionIndex`=0) OR (`MenuId`=9985 AND `OptionIndex`=0) OR (`MenuId`=9894 AND `OptionIndex`=0) OR (`MenuId`=8802 AND `OptionIndex`=0) OR (`MenuId`=10114 AND `OptionIndex`=0) OR (`MenuId`=9892 AND `OptionIndex`=0) OR (`MenuId`=9986 AND `OptionIndex`=0);
+INSERT INTO `gossip_menu_option_trainer` (`MenuId`, `OptionIndex`, `TrainerId`) VALUES
+(18865, 1, 133),
+(9750, 0, 386),
+(10723, 0, 137),
+(10210, 0, 386),
+(9777, 0, 114),
+(9833, 0, 10),
+(9772, 0, 136),
+(10628, 1, 122),
+(10627, 0, 122),
+(9873, 0, 29),
+(10118, 0, 163),
+(10116, 0, 163),
+(9985, 0, 136),
+(9894, 0, 29),
+(8802, 0, 160),
+(10114, 0, 163),
+(9892, 0, 29),
+(9986, 0, 136);