From 5c54d6265f36c7f870504550c960f1ecee51939a Mon Sep 17 00:00:00 2001 From: Killyana Date: Wed, 2 Sep 2015 17:53:38 +0200 Subject: DB/Creature: Remove a Duplicate spawn for Overseer Deathgaze Add a cosmetic channeling spell for Decrepit Necromancer and remove a wrong emote. Closes #15404 (cherry picked from commit 24a624b38c5d436341a4b87eef6fbe66afc4bfb6) --- sql/updates/world/2015_10_20_04_world_2015_09_02_04.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2015_10_20_04_world_2015_09_02_04.sql (limited to 'sql') diff --git a/sql/updates/world/2015_10_20_04_world_2015_09_02_04.sql b/sql/updates/world/2015_10_20_04_world_2015_09_02_04.sql new file mode 100644 index 00000000000..2a66eb3390f --- /dev/null +++ b/sql/updates/world/2015_10_20_04_world_2015_09_02_04.sql @@ -0,0 +1,5 @@ +-- +DELETE FROM `creature` WHERE `guid`=118724 AND `id`=27122; +UPDATE `creature` SET `equipment_id`=1 WHERE `guid`=52290; +UPDATE `creature_template_addon` SET `emote`=0 WHERE `entry`=26942; +UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=45491, `target_type`=19, `target_param1`=27180, `target_param2`=10, `comment`="Decrepit Necromancer - Out of Combat - Cast Necrotic Purple Beam" WHERE `entryorguid`=26942 AND `source_type`=0 AND `id`=0; -- cgit v1.2.3