diff options
| author | Shauren <shauren.trinity@gmail.com> | 2022-10-09 18:12:16 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-10-09 18:12:16 +0200 |
| commit | b3dadaf2d0620817daf28f6225882a45b1c62076 (patch) | |
| tree | 514c8b3d2f73b9b269b05bd50bb644bdd5763ce0 | |
| parent | 2c7eaa8224e2387e785b6631dc8333255ca34a9d (diff) | |
DB/Gossip: Add missing gossip_menu_option for guild masters that were relying on fallback options (menuid = 0)
| -rw-r--r-- | sql/updates/world/master/2022_10_09_06_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_10_09_06_world.sql b/sql/updates/world/master/2022_10_09_06_world.sql new file mode 100644 index 00000000000..d8a8089da0f --- /dev/null +++ b/sql/updates/world/master/2022_10_09_06_world.sql @@ -0,0 +1,8 @@ +DELETE FROM `gossip_menu_option` WHERE (`MenuID`=1626 AND `OptionID` IN (1,0)) OR (`MenuID`=5461 AND `OptionID` IN (0,1)) OR (`MenuID`=7487 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 +(1626, 0, 8, 'I want to create a guild crest.', 3415, 524288, 0, 0, 0, 0, 0, NULL, 0, 45745), +(1626, 1, 7, 'How do I form a guild?', 3413, 262144, 0, 0, 0, 0, 0, NULL, 0, 45745), +(5461, 0, 8, 'I want to create a guild crest.', 3415, 524288, 0, 0, 0, 0, 0, NULL, 0, 45745), +(5461, 1, 7, 'How do I form a guild?', 3413, 262144, 0, 0, 0, 0, 0, NULL, 0, 45745), +(7487, 0, 7, 'How do I form a guild?', 3413, 262144, 0, 0, 0, 0, 0, NULL, 0, 45745), +(7487, 1, 8, 'I want to create a guild crest.', 3415, 524288, 0, 0, 0, 0, 0, NULL, 0, 45745); |