aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2015-12-29 17:34:33 +0100
committerKillyana <morphone1@gmail.com>2015-12-29 17:34:33 +0100
commit335ec729bd0b6829f9f5bf98f63f3acc738b2a58 (patch)
treec1c4edc3fe45f220dd0ae3d6a02175c4193f41e8
parent17b57453c1082659f28f2bf3d20678f842f9c953 (diff)
DB/Creature: Remove unneeded SAI for Water Terror and move the aura to creature addon
Closes #16107
-rw-r--r--sql/updates/world/2015_12_29_04_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2015_12_29_04_world.sql b/sql/updates/world/2015_12_29_04_world.sql
new file mode 100644
index 00000000000..22a1ee3edcf
--- /dev/null
+++ b/sql/updates/world/2015_12_29_04_world.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;