From 01023320cf839718fafd6cd424b63dafc1632bbb Mon Sep 17 00:00:00 2001 From: Killyana Date: Sun, 12 Jan 2020 22:39:09 +0100 Subject: DB/Gossips: Fix gossips for Elder Runetotem & Elder Darkhorn Closes #24056 (cherry picked from commit f1c338f1371efe6e8a6b11dc45f3d450bc658d13) --- .../2021_12_20_13_world_2020_01_12_05_world.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/updates/world/master/2021_12_20_13_world_2020_01_12_05_world.sql (limited to 'sql') 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; -- cgit v1.2.3