diff options
| author | Shauren <shauren.trinity@gmail.com> | 2022-10-09 18:23:14 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-10-09 18:23:14 +0200 |
| commit | fcf2c5c803a9d1b13f6b4cb18c03685aa66be764 (patch) | |
| tree | d3b2acfc55c2c6adc7843dca9f43c5c5fddb0435 | |
| parent | b3dadaf2d0620817daf28f6225882a45b1c62076 (diff) | |
DB/Gossip: Add missing gossip_menu_option for battlemasters that were relying on fallback options (menuid = 0)
| -rw-r--r-- | sql/updates/world/master/2022_10_09_07_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_10_09_07_world.sql b/sql/updates/world/master/2022_10_09_07_world.sql new file mode 100644 index 00000000000..9fb26002e77 --- /dev/null +++ b/sql/updates/world/master/2022_10_09_07_world.sql @@ -0,0 +1,8 @@ +DELETE FROM `gossip_menu_option` WHERE (`OptionID`=0 AND `MenuID` IN (9827,9830,9828,9829)); +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextId`, `OptionNpcFlag`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(9827, 0, 9, 'I would like to go to the battleground.', 10355, 1048576, 0, 0, 0, 0, 0, NULL, 0, 45745), +(9830, 0, 9, 'I would like to go to the battleground.', 10355, 1048576, 0, 0, 0, 0, 0, NULL, 0, 45745), +(9828, 0, 9, 'I would like to go to the battleground.', 10355, 1048576, 0, 0, 0, 0, 0, NULL, 0, 45745), +(9829, 0, 9, 'I would like to go to the battleground.', 10355, 1048576, 0, 0, 0, 0, 0, NULL, 0, 45745); + +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=10355, `VerifiedBuild`=45745 WHERE (`MenuID`=10602 AND `OptionID`=0); |