From 932173f88d8edc2b556b0ef2f41a1f946de44e2f Mon Sep 17 00:00:00 2001
From: Aokromes <Aokromes@users.noreply.github.com>
Date: Thu, 6 Mar 2014 07:23:10 +0100
Subject: DB/Creature: Fix wrong npcflag for Alchemist Kanhu

By MrSmite, closes #11671
---
 sql/updates/world/2014_03_06_00_creature_template.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/updates/world/2014_03_06_00_creature_template.sql

(limited to 'sql')

diff --git a/sql/updates/world/2014_03_06_00_creature_template.sql b/sql/updates/world/2014_03_06_00_creature_template.sql
new file mode 100644
index 00000000000..43e693d2cdb
--- /dev/null
+++ b/sql/updates/world/2014_03_06_00_creature_template.sql
@@ -0,0 +1,3 @@
+-- Fix Missing 'gossip' flag (1) so player can choose trainer or vendor window,
+--  current flag (208) only allowed vendor window to appear
+UPDATE `creature_template` SET `npcflag`=209 WHERE entry=33674;
-- 
cgit v1.2.3