From a902fd43ed00e70a9307d76360597cf794e22635 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sat, 16 Jan 2016 19:56:20 +0100 Subject: DB/Creature: Spell Shade Closes #15988 (cherry picked from commit 1e75569852d5a4c82b5c9ff5d761234967a9fc91) --- sql/updates/world/2016_03_22_11_world_2016_01_16_02_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2016_03_22_11_world_2016_01_16_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/2016_03_22_11_world_2016_01_16_02_world.sql b/sql/updates/world/2016_03_22_11_world_2016_01_16_02_world.sql new file mode 100644 index 00000000000..b36d7d69ff6 --- /dev/null +++ b/sql/updates/world/2016_03_22_11_world_2016_01_16_02_world.sql @@ -0,0 +1,7 @@ +-- +DELETE FROM `creature_template_addon` WHERE `entry` IN (16525); +INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES +(16525, 1, '29920'); + +UPDATE `smart_scripts` SET `event_chance`=100 WHERE `entryorguid`=16525 AND `source_type`=0; +UPDATE `smart_scripts` SET `event_flags`=3, `event_param1`=0, `event_param2`=0, `event_param3`=0, `event_param4`=0, `action_type`=28, `comment`="Spell Shade - In Combat - Remove Aura 'Phasing Invisibility' (Normal Dungeon)" WHERE `entryorguid`=16525 AND `source_type`=0 AND `id`=3; -- cgit v1.2.3