diff options
| author | Killyana <morphone1@gmail.com> | 2020-01-12 22:39:09 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-20 21:22:18 +0100 |
| commit | 01023320cf839718fafd6cd424b63dafc1632bbb (patch) | |
| tree | 65c22fed0b57a7b31a611979d1ea38ea9caeb963 | |
| parent | 40c7ffcd991bec9848eb476a7486cc02bcae3441 (diff) | |
DB/Gossips: Fix gossips for Elder Runetotem & Elder Darkhorn
Closes #24056
(cherry picked from commit f1c338f1371efe6e8a6b11dc45f3d450bc658d13)
| -rw-r--r-- | sql/updates/world/master/2021_12_20_13_world_2020_01_12_05_world.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_20_13_world_2020_01_12_05_world.sql b/sql/updates/world/master/2021_12_20_13_world_2020_01_12_05_world.sql new file mode 100644 index 00000000000..57d11c34e32 --- /dev/null +++ b/sql/updates/world/master/2021_12_20_13_world_2020_01_12_05_world.sql @@ -0,0 +1,21 @@ +-- +DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (6815) AND `OptionIndex`=4; +DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (6899) AND `OptionIndex`=2; +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `VerifiedBuild`) VALUES +(6815, 4, 0, "Where is Elder Darkhorn?", 11584, 1, 1, 0), +(6899, 2, 0, "Where is Elder Wheathoof?", 11582, 1, 1, 0); + +DELETE FROM `gossip_menu_option_action` WHERE `MenuID` IN (6815) AND `OptionIndex`=4; +DELETE FROM `gossip_menu_option_action` WHERE `MenuID` IN (6899) AND `OptionIndex` IN (1,2); +INSERT INTO `gossip_menu_option_action` (`MenuID`, `OptionIndex`, `ActionMenuID`, `ActionPoiID`) VALUES +(6815, 4, 6896, 0), +(6899, 1, 6854, 0), +(6899, 2, 6895, 0); + +-- UPDATE `gossip_menu_option_action` SET `ActionMenuID` = 21097 WHERE `MenuID` = 6815 AND `OptionIndex` = 1; +-- UPDATE `gossip_menu_option_action` SET `ActionMenuID` = 21107 WHERE `MenuID` = 6815 AND `OptionIndex` = 2; +-- UPDATE `gossip_menu_option_action` SET `ActionMenuID` = 21147 WHERE `MenuID` = 6815 AND `OptionIndex` = 3; +-- UPDATE `gossip_menu_option_action` SET `ActionMenuID` = 21086 WHERE `MenuID` = 6899 AND `OptionIndex` = 0; +-- UPDATE `gossip_menu_option_action` SET `ActionMenuID` = 6854 WHERE `MenuID` = 6899 AND `OptionIndex` = 1; +-- UPDATE `gossip_menu_option_action` SET `ActionMenuID` = 21122 WHERE `MenuID` = 6899 AND `OptionIndex` = 3; +-- UPDATE `gossip_menu_option_action` SET `ActionMenuID` = 21147 WHERE `MenuID` = 6899 AND `OptionIndex` = 4; |