aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorWyrserth <wyrserth@protonmail.com>2019-07-17 22:02:48 +0200
committerGitHub <noreply@github.com>2019-07-17 22:02:48 +0200
commit31f82182167070f326d71b2c1ff1c396df09e44b (patch)
tree592d8b23266c110b3c1f94283d37db9a85f4781d
parenta58955d88cb1f426f0af5db16e388f7f2b999349 (diff)
DB/Gossip: fix some gossip option texts for guards that give directions.
-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);