From e16f69545376e87dc918634af22c550db3ee57f7 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Wed, 30 Dec 2015 01:50:27 +0100
Subject: DB/Creature: Franclorn Forgewright

Make the npc visible only for dead players
Remove the SAI and move the aura to Creature addon

(cherry picked from commit 1c877ecbd2a4c81204f932a4f249b8f9dd6f5b90)
---
 sql/updates/world/2016_01_17_16_world_2015_12_29_12.sql | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 sql/updates/world/2016_01_17_16_world_2015_12_29_12.sql

(limited to 'sql')

diff --git a/sql/updates/world/2016_01_17_16_world_2015_12_29_12.sql b/sql/updates/world/2016_01_17_16_world_2015_12_29_12.sql
new file mode 100644
index 00000000000..c065e1d6a18
--- /dev/null
+++ b/sql/updates/world/2016_01_17_16_world_2015_12_29_12.sql
@@ -0,0 +1,4 @@
+-- 
+UPDATE `creature_template` SET `npcflag`=32771, `AIName`='' WHERE `entry`=8888;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 8888  AND `source_type` = 0;
+UPDATE `creature_template_addon` SET `auras`=10848 WHERE `entry` IN (8888);
-- 
cgit v1.2.3