From a8e4b66c998cd4e9ed6318529bedd3eba8dafb3e Mon Sep 17 00:00:00 2001 From: Killyana Date: Fri, 3 Jan 2020 19:54:55 +0100 Subject: DB/GossipMenu: Remove some custom gossips (cherry picked from commit 739383b52e4dfc710d9878cc85a45d20c2c23ecb) --- .../world/master/2021_12_19_33_world_2020_01_03_03_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/master/2021_12_19_33_world_2020_01_03_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_12_19_33_world_2020_01_03_03_world.sql b/sql/updates/world/master/2021_12_19_33_world_2020_01_03_03_world.sql new file mode 100644 index 00000000000..d22b813fa24 --- /dev/null +++ b/sql/updates/world/master/2021_12_19_33_world_2020_01_03_03_world.sql @@ -0,0 +1,6 @@ +-- +UPDATE `creature_template` SET `gossip_menu_id`=522 WHERE `entry` IN (3402); +DELETE FROM `gossip_menu` WHERE `MenuID` IN (21216,21220,21219) AND `TextID` IN (907,1041,1039); +DELETE FROM `gossip_menu` WHERE `MenuID` IN (522) AND `TextID` IN (1039); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`) VALUES +(522,1039); -- cgit v1.2.3