aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/master/2017_11_12_02_world.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_11_12_02_world.sql b/sql/updates/world/master/2017_11_12_02_world.sql
new file mode 100644
index 00000000000..9d2cc01c26b
--- /dev/null
+++ b/sql/updates/world/master/2017_11_12_02_world.sql
@@ -0,0 +1,9 @@
+DELETE FROM `gossip_menu_option` WHERE `MenuId` IN (708, 1626, 7487,5108,5461,5462,7440,7484,9838);
+UPDATE `creature_template` SET `gossip_menu_id`=5108 WHERE `entry`=4613;
+
+UPDATE `creature_template` SET `npcflag`=129 WHERE `entry` IN (5049, 5188, 5189, 5190, 5191,16610, 16766, 28776, 52278);
+UPDATE `gossip_menu_option` SET `OptionType`=1, `OptionNpcFlag`=1, `OptionBroadcastTextID`=33438 WHERE `MenuID` IN (9832) AND `OptionID` IN (12);
+UPDATE `gossip_menu_option` SET `OptionType`=1, `OptionNpcFlag`=1, `OptionBroadcastTextID`=33439 WHERE `MenuID` IN (9832) AND `OptionID` IN (13);
+UPDATE `gossip_menu_option` SET `OptionType`=3, `OptionNpcFlag`=128, `OptionBroadcastTextID`=8097 WHERE `MenuID` IN (9832) AND `OptionID` IN (0);
+UPDATE `gossip_menu_option` SET `OptionType`=3, `OptionNpcFlag`=128 WHERE `MenuID` IN (10392) AND `OptionID` IN (0);
+UPDATE `gossip_menu_option` SET `OptionType`=11, `OptionNpcFlag`=524288, `OptionBroadcastTextID`= 3415 WHERE `MenuID` IN (10392) AND `OptionID` IN (1);