aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2014-03-06 07:23:10 +0100
committerAokromes <Aokromes@users.noreply.github.com>2014-03-06 07:23:10 +0100
commit932173f88d8edc2b556b0ef2f41a1f946de44e2f (patch)
treec8af1f6a76a4c4bd0e8c6d4a9f5cc735073dcccf
parentdb3c4b3072a7b49652a2ef8876a59b62c9ce017f (diff)
DB/Creature: Fix wrong npcflag for Alchemist Kanhu
By MrSmite, closes #11671
-rw-r--r--sql/updates/world/2014_03_06_00_creature_template.sql3
1 files changed, 3 insertions, 0 deletions
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;