DB/Gossip: Restore gossip_menu_option Box* values that were wrongly set by 88659dcebf9f033cd99e87595151f42fbcd96310

1 files changed, 103 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_27_03_world.sql b/sql/updates/world/master/2022_01_27_03_world.sql
new file mode 100644
index 00000000000..3672e5de85d
--- /dev/null
+++ b/sql/updates/world/master/2022_01_27_03_world.sql
@@ -0,0 +1,103 @@
+UPDATE `gossip_menu_option` SET `BoxCoded`=0,`BoxMoney`=0,`BoxText`=NULL,`BoxBroadcastTextID`=0;
+
+UPDATE `gossip_menu_option` SET `BoxMoney`=100000,`BoxText`='Are you sure you wish to purchase a Dual Talent Specialization?' WHERE `MenuID`=0 AND `OptionID`=16;
+UPDATE `gossip_menu_option` SET `BoxText`='Do you really want to unlearn your Gnomish Engineering specialization and lose all associated recipes?' WHERE `MenuID`=4150 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=6565 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=6565 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=6565 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=7034 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxMoney`=10000,`BoxText`='Do you really want to bribe Olga?',`BoxBroadcastTextID`=25743 WHERE `MenuID`=9014 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxMoney`=10000,`BoxText`='Do you really want to bribe Olga?',`BoxBroadcastTextID`=25743 WHERE `MenuID`=9016 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9191 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9191 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9191 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9192 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9192 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9192 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9193 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9193 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9193 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9193 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9193 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9193 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9193 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9193 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9193 AND `OptionID`=8;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9193 AND `OptionID`=9;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9194 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9194 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9194 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9195 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9195 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9195 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9196 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9196 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9196 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9629 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9629 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9629 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9682 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9682 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9682 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=9768 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxMoney`=1000,`BoxText`='A small fee for supplies is required.',`BoxBroadcastTextID`=66369 WHERE `MenuID`=9821 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=10330 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=10330 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=10330 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxMoney`=100000,`BoxText`='Are you sure you would like to purchase your second talent specialization?' WHERE `MenuID`=10371 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=10533 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=10533 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=10533 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxMoney`=100000,`BoxText`='Are you certain you wish to stop gaining experience?',`BoxBroadcastTextID`=35535 WHERE `MenuID`=10638 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxMoney`=100000,`BoxText`='Are you certain you wish to start gaining experience again?',`BoxBroadcastTextID`=35533 WHERE `MenuID`=10638 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=10810 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=10810 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=10810 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=11342 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=11342 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=11342 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=11343 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=11343 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=11343 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxMoney`=2,`BoxText`='Are you sure you want to give this hobo money?' WHERE `MenuID`=11635 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=12658 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=12658 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=12658 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxMoney`=500000,`BoxText`='Are you sure you want to pay to abandon your minion?' WHERE `MenuID`=12670 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxMoney`=500000,`BoxText`='Are you sure you want to pay to abandon your minion?' WHERE `MenuID`=12670 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxMoney`=500000,`BoxText`='Are you sure you want to pay to abandon your minion?' WHERE `MenuID`=12670 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxMoney`=500000,`BoxText`='Are you sure you want to pay to abandon your minion?' WHERE `MenuID`=12670 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `BoxMoney`=10000,`BoxText`='Will you pay "Pretty Boy" Duncan 1 gold to swab the decks for you?' WHERE `MenuID`=12723 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=12784 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=12784 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=12784 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=12785 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=12785 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=12785 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxMoney`=25,`BoxText`='Travel to the faire staging area will cost:' WHERE `MenuID`=12992 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxMoney`=500,`BoxText`='Travel to the faire staging area will cost:' WHERE `MenuID`=12992 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxMoney`=3000,`BoxText`='Travel to the faire staging area will cost:' WHERE `MenuID`=12992 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=13003 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=13003 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=13003 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=13088 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=13088 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=13088 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=13089 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=13089 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=13089 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxMoney`=25,`BoxText`='Travel to the faire staging area will cost:' WHERE `MenuID`=13124 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxText`='Do you want to start the encounter?' WHERE `MenuID`=13295 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxMoney`=25,`BoxText`='Teleportation to the cannon will cost:' WHERE `MenuID`=13352 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=13506 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=13506 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=13506 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=15404 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=15404 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxCoded`=1 WHERE `MenuID`=15404 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `BoxText`='Leave Dalaran for Val\'sharah?',`BoxBroadcastTextID`=102284 WHERE `MenuID`=18723 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxText`='This action costs 5 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:15|t Ancient Mana. Do you wish to continue?' WHERE `MenuID`=19929 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `BoxMoney`=100000,`BoxText`='A single goblin glider kit will cost:',`BoxBroadcastTextID`=119663 WHERE `MenuID`=20131 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxText`='This action costs 10 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:15|t Ancient Mana. Do you wish to continue?' WHERE `MenuID`=20332 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxText`='This action costs 20 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:15|t Ancient Mana. Do you wish to continue?' WHERE `MenuID`=20393 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `BoxText`='This action costs 10 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:15|t Ancient Mana. Do you wish to continue?' WHERE `MenuID`=20424 AND `OptionID`=0;