From b7a3affc0c461cf05fe2fb2380ac358cc90799e0 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Thu, 10 Jan 2019 15:07:09 +0100
Subject: DB/Creature: Remove wrong gossips

Ref #22912
---
 sql/updates/world/3.3.5/2019_01_10_03_world.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2019_01_10_03_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2019_01_10_03_world.sql b/sql/updates/world/3.3.5/2019_01_10_03_world.sql
new file mode 100644
index 00000000000..fcd7ac5c05a
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_01_10_03_world.sql
@@ -0,0 +1,3 @@
+-- 
+UPDATE `creature_template` SET `gossip_menu_id`=0 WHERE `entry` = 733;
+UPDATE `creature_template` SET `gossip_menu_id`=0, `npcflag` = `npcflag`&~1 WHERE `entry` = 3139;
-- 
cgit v1.2.3