diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2017-11-12 11:29:38 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-11-12 11:29:38 +0100 |
| commit | 287445c32d1a64719958b9aa6f0c8e6765296aec (patch) | |
| tree | bc8055447f854d1ae19b8f343da103917bc4b724 | |
| parent | 232b79ad9088aa009d62475f99b2d60db3c122df (diff) | |
DB/Creature: Fix tabard vendors
By Kilyana
Closes #18517
| -rw-r--r-- | sql/updates/world/master/2017_11_12_02_world.sql | 9 |
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); |