From 4da8ff95e6c48c30f66bf127792b54b9152990da Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Thu, 28 Apr 2016 17:10:52 +0100
Subject: DB/Creature: Fix some npc flags

(cherry picked from commit 6392887f2b903d052e778711c30431b738e5edd1)
---
 .../6.x/2016_04_27_04_world_2016_04_23_02_world.sql   | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 sql/updates/world/6.x/2016_04_27_04_world_2016_04_23_02_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/6.x/2016_04_27_04_world_2016_04_23_02_world.sql b/sql/updates/world/6.x/2016_04_27_04_world_2016_04_23_02_world.sql
new file mode 100644
index 00000000000..e3806947c9c
--- /dev/null
+++ b/sql/updates/world/6.x/2016_04_27_04_world_2016_04_23_02_world.sql
@@ -0,0 +1,19 @@
+--
+UPDATE `creature_template` SET `npcflag`=4096 WHERE `entry`=2404;
+UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=2910;
+UPDATE `creature_template` SET `npcflag`=81 WHERE `entry`=7231;
+UPDATE `creature_template` SET `npcflag`=128 WHERE `entry`=8121;
+UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=15309;
+
+DELETE FROM `npc_vendor` WHERE `entry`=8121;
+INSERT INTO `npc_vendor` (`entry`, `slot`, `item`) VALUES
+(8121, 0, 5740),
+(8121, 0, 8624),
+(8121, 0, 8625),
+(8121, 0, 8626),
+(8121, 0, 9312),
+(8121, 0, 9313),
+(8121, 0, 9314),
+(8121, 0, 9315),
+(8121, 0, 9317),
+(8121, 0, 9318);
-- 
cgit v1.2.3