From 772a68d624c779bee55f802ca189249f077c04fa 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 --- sql/updates/world/3.3.5/2019_01_14_03_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/3.3.5/2019_01_14_03_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2019_01_14_03_world.sql b/sql/updates/world/3.3.5/2019_01_14_03_world.sql new file mode 100644 index 00000000000..559019ee43a --- /dev/null +++ b/sql/updates/world/3.3.5/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`IN (21331,21330); +DELETE FROM `gossip_menu` WHERE `MenuID`IN (21331,21330); +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