diff options
| author | Shauren <shauren.trinity@gmail.com> | 2022-10-09 17:59:20 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-10-09 17:59:20 +0200 |
| commit | 2c7eaa8224e2387e785b6631dc8333255ca34a9d (patch) | |
| tree | 2f5fbfc68ae9a0c2e020b167249e0b9dafa9c69d | |
| parent | 1ebd862cee6855eb130bc0774d9d1f6860d30d42 (diff) | |
DB/Gossip: Add missing gossip_menu_option for bankers that were relying on fallback options (menuid = 0)
| -rw-r--r-- | sql/updates/world/master/2022_10_09_05_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_10_09_05_world.sql b/sql/updates/world/master/2022_10_09_05_world.sql new file mode 100644 index 00000000000..e25790be5ec --- /dev/null +++ b/sql/updates/world/master/2022_10_09_05_world.sql @@ -0,0 +1,10 @@ + +DELETE FROM `gossip_menu` WHERE (`MenuID`=26904 AND `TextID`=42825); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(26904, 42825, 45745); -- 178170 (Night Guardian Vekraala) + +DELETE FROM `gossip_menu_option` WHERE (`MenuID`=7811 AND `OptionID`=0) OR (`MenuID`=26904 AND `OptionID` IN (0,1)); +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextId`, `OptionNpcFlag`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(7811, 0, 6, 'I would like to check my deposit box.', 3398, 131072, 0, 0, 0, 0, 0, NULL, 0, 45745), +(26904, 0, 5, 'Make this inn your home.', 2822, 65536, 0, 0, 0, 0, 0, NULL, 0, 45745), +(26904, 1, 1, 'Let me browse your goods.', 2823, 128, 0, 0, 0, 0, 0, NULL, 0, 45745); |