From 07046d0cf09d38c295765232cfc94cc0538ef3a9 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Fri, 3 Jan 2020 17:07:14 +0100
Subject: DB/Gossips: Remove a custom gossip from some Innkeepers

(cherry picked from commit 87e1f7366a6b73475f4ca893d0e7a22651c5c1ad)
---
 .../world/master/2021_12_19_32_world_2020_01_03_02_world.sql        | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 sql/updates/world/master/2021_12_19_32_world_2020_01_03_02_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2021_12_19_32_world_2020_01_03_02_world.sql b/sql/updates/world/master/2021_12_19_32_world_2020_01_03_02_world.sql
new file mode 100644
index 00000000000..e9275e6585c
--- /dev/null
+++ b/sql/updates/world/master/2021_12_19_32_world_2020_01_03_02_world.sql
@@ -0,0 +1,6 @@
+-- 
+UPDATE `creature_template` SET `gossip_menu_id`=344 WHERE `entry` IN (11106,6746,9501,7737);
+DELETE FROM `gossip_menu` WHERE `MenuID` IN (21215) AND `TextID` IN (822);
+DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (21215);
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN(21215);
+UPDATE `smart_scripts` SET `event_param1`=344, `event_param2`=2 WHERE `entryorguid`=6746 AND `source_type`=0 AND `id`=0;
-- 
cgit v1.2.3