DB/Gossip: fix some gossip option texts for guards that give directions.

(cherry picked from commit 31f82182167070f326d71b2c1ff1c396df09e44b)

1 files changed, 19 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_12_16_09_world_2019_07_17_05_world.sql b/sql/updates/world/master/2021_12_16_09_world_2019_07_17_05_world.sql
new file mode 100644
index 00000000000..e641d158cb7
--- /dev/null
+++ b/sql/updates/world/master/2021_12_16_09_world_2019_07_17_05_world.sql
@@ -0,0 +1,19 @@
+--
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3426 WHERE `OptionBroadcastTextID`=7066 AND `OptionText`="Bank";
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=4888 WHERE `OptionBroadcastTextID`=7066 AND `OptionText`="The bank";
+
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2868 WHERE `OptionBroadcastTextID`=2870 AND `OptionText`="Class Trainer";
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=5513 WHERE `OptionBroadcastTextID`=2870 AND `OptionText`="Inn";
+
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=4893 WHERE `OptionBroadcastTextID`=7075 AND `OptionText`="The inn";
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=5513 WHERE `OptionBroadcastTextID`=7075 AND `OptionText`="Inn";
+
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=4895 WHERE `OptionBroadcastTextID` IN (45381, 5514);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2869 WHERE `OptionBroadcastTextID`=4895 AND `OptionText`="Profession Trainer";
+
+UPDATE `gossip_menu_option` SET `OptionText`="Zeppelin Master" WHERE `OptionBroadcastTextID`=5518;
+
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=15232 WHERE `MenuId`=7777 AND `OptionIndex`=7;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=5518 WHERE `MenuId`=10769 AND `OptionIndex`=10;
+
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2870 WHERE `MenuId`=10769 AND `OptionIndex`=4;