diff options
| author | Killyana <morphone1@gmail.com> | 2015-12-30 01:50:27 +0100 |
|---|---|---|
| committer | MitchesD <majklprofik@seznam.cz> | 2016-01-17 14:04:01 +0100 |
| commit | e16f69545376e87dc918634af22c550db3ee57f7 (patch) | |
| tree | 88f7589a879f7f7e7decaa17691ebbbd9935095b | |
| parent | d7bfacbd657f789bcab823d320b5cd07b0b826d8 (diff) | |
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)
| -rw-r--r-- | sql/updates/world/2016_01_17_16_world_2015_12_29_12.sql | 4 |
1 files changed, 4 insertions, 0 deletions
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); |