DB/Gossips: Remove outdated custom gossips

(cherry picked from commit 8c29c997e6bc949d044cadc7e53c15c1a4016282)

1 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_12_19_27_world_2020_01_02_01_world.sql b/sql/updates/world/master/2021_12_19_27_world_2020_01_02_01_world.sql
new file mode 100644
index 00000000000..5e0519d4500
--- /dev/null
+++ b/sql/updates/world/master/2021_12_19_27_world_2020_01_02_01_world.sql
@@ -0,0 +1,10 @@
+-- 
+UPDATE `creature_template` SET `gossip_menu_id`=181 WHERE `entry`=6586;
+DELETE FROM `gossip_menu` WHERE `MenuID`=21200 AND `TextID`=522;
+DELETE FROM `gossip_menu` WHERE `MenuID`=21201 AND `TextID`=539;
+DELETE FROM `gossip_menu` WHERE `MenuID`=21202 AND `TextID`=559;
+DELETE FROM `gossip_menu` WHERE `MenuID`=21203 AND `TextID`=563;
+DELETE FROM `gossip_menu` WHERE `MenuID`=21204 AND `TextID`=581;
+DELETE FROM `gossip_menu` WHERE `MenuID`=21205 AND `TextID`=623;
+DELETE FROM `gossip_menu` WHERE `MenuID`=21206 AND `TextID`=638;
+DELETE FROM `gossip_menu` WHERE `MenuID`=21207 AND `TextID`=678;