diff options
| author | Killyana <morphone1@gmail.com> | 2015-12-30 01:50:27 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2015-12-30 01:50:27 +0100 |
| commit | 1c877ecbd2a4c81204f932a4f249b8f9dd6f5b90 (patch) | |
| tree | f78e366ae147583ee5c31bff65a0be7e0b510fae | |
| parent | bc6c380e7d928fd193cfdf01ee178ad10774df98 (diff) | |
DB/Creature: Franclorn Forgewright
Make the npc visible only for dead players
Remove the SAI and move the aura to Creature addon
| -rw-r--r-- | sql/updates/world/2015_12_29_12_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2015_12_29_12_world.sql b/sql/updates/world/2015_12_29_12_world.sql new file mode 100644 index 00000000000..c065e1d6a18 --- /dev/null +++ b/sql/updates/world/2015_12_29_12_world.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); |