aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2019_07_17_05_world.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_07_17_05_world.sql b/sql/updates/world/3.3.5/2019_07_17_05_world.sql
new file mode 100644
index 00000000000..a1f5bf5e119
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_07_17_05_world.sql
@@ -0,0 +1,11 @@
+--
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=4888, `OptionText`="The bank" WHERE `OptionBroadcastTextID`=7066;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=0, `OptionText`="The guild master" WHERE `OptionBroadcastTextID`=2870;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=4893, `OptionText`="The inn" WHERE `OptionBroadcastTextID`=7075;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=0, `OptionText`="The mailbox" WHERE `OptionBroadcastTextID` IN (45381, 5514, 4895);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=0, `OptionText`="The auction house" WHERE `OptionBroadcastTextID` IN (44627, 5515);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=0, `OptionText`="The zeppelin master" WHERE `OptionBroadcastTextID`=5518;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=0, `OptionText`="The weapon master" WHERE `OptionBroadcastTextID` IN (15230, 7253);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=8521, `OptionText`="The stable master" WHERE `OptionBroadcastTextID`=45383;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=0, `OptionText`="The officers' lounge" WHERE `OptionBroadcastTextID`=9756;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=0, `OptionText`="The battlemaster" WHERE `OptionBroadcastTextID` IN (19209, 10359);