diff options
| author | Killyana <morphone1@gmail.com> | 2015-12-29 17:34:33 +0100 |
|---|---|---|
| committer | MitchesD <majklprofik@seznam.cz> | 2016-01-17 13:57:37 +0100 |
| commit | 44e2a7fbc655818182917e0fb2f381d9c258ffdc (patch) | |
| tree | b53410025c84e4cbb60c7fef130308fd40669dd9 | |
| parent | 5d7cc696b83f058c440e287d731df286e191f8d6 (diff) | |
DB/Creature: Remove unneeded SAI for Water Terror and move the aura to creature addon
Closes #16107
(cherry picked from commit 335ec729bd0b6829f9f5bf98f63f3acc738b2a58)
| -rw-r--r-- | sql/updates/world/2016_01_17_08_world_2015_12_29_04.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2016_01_17_08_world_2015_12_29_04.sql b/sql/updates/world/2016_01_17_08_world_2015_12_29_04.sql new file mode 100644 index 00000000000..22a1ee3edcf --- /dev/null +++ b/sql/updates/world/2016_01_17_08_world_2015_12_29_04.sql @@ -0,0 +1,4 @@ +-- +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=30645; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 30645 AND `source_type` = 0; +UPDATE `creature_template_addon` SET `auras`=57664 WHERE `entry`=30645; |