diff options
| author | Killyana <morphone1@gmail.com> | 2015-09-02 17:53:38 +0200 |
|---|---|---|
| committer | MitchesD <majklprofik@seznam.cz> | 2015-10-20 15:45:38 +0200 |
| commit | 5c54d6265f36c7f870504550c960f1ecee51939a (patch) | |
| tree | 4d78306b3680b9283f911f305d198c4346e56450 | |
| parent | 124db01dd4042fb45c911a8c977736301f19309c (diff) | |
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)
| -rw-r--r-- | sql/updates/world/2015_10_20_04_world_2015_09_02_04.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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; |