From f497534b15330f194d949ddb5ac2b19b005df16b Mon Sep 17 00:00:00 2001 From: Killyana Date: Mon, 14 Jan 2019 18:03:01 +0100 Subject: DB/Creature: Update Lord Victor Nefarius gossips with the correct entry Closes #22946 --- .../master/2021_11_21_27_world_2019_01_14_03_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/master/2021_11_21_27_world_2019_01_14_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_11_21_27_world_2019_01_14_03_world.sql b/sql/updates/world/master/2021_11_21_27_world_2019_01_14_03_world.sql new file mode 100644 index 00000000000..a57fddd3383 --- /dev/null +++ b/sql/updates/world/master/2021_11_21_27_world_2019_01_14_03_world.sql @@ -0,0 +1,14 @@ +-- +UPDATE `creature_template` SET `gossip_menu_id`=5981 WHERE `entry`=10162; +DELETE FROM `gossip_menu_option` WHERE `MenuID`=21331; +DELETE FROM `gossip_menu` WHERE `MenuID` IN (21331,21330) AND `TextId` IN (7134,7198); +-- DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (6045,5981,6046); +-- INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`) VALUES +-- (6045, 0, 0, 'Please do.', 9906, 1, 1, 0), +-- (5981, 0, 0, "I've made no mistakes.", 9902, 1, 1, 6046), +-- (6046, 0, 0, "You have lost your mind, Nefarius. You speak in riddles.", 9904, 1, 1, 6045); + +-- DELETE FROM `gossip_menu` WHERE `MenuId` IN (5981,6046) AND `TextId` IN (7134,7198); +-- INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `VerifiedBuild`) VALUES +-- (5981, 7134, 0), +-- (6046, 7198, 0); -- cgit v1.2.3