aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2014-07-21 02:11:50 +0200
committerAokromes <Aokromes@users.noreply.github.com>2014-07-21 02:11:50 +0200
commitc1006c5a53b4d33c9b9163483f42e1162c063ffb (patch)
tree9ee782a54a6f6e1f207005c8d9edec9da2373f16
parent8934eb00849cdd9c9601f7f6cfddc8797823ab5f (diff)
DB/Creature: Remove some incorrect bytes from Coilskar mobs
Closes #6891
-rw-r--r--sql/updates/world/2014_07_21_00_world_misc.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/2014_07_21_00_world_misc.sql b/sql/updates/world/2014_07_21_00_world_misc.sql
new file mode 100644
index 00000000000..4e649dc52d4
--- /dev/null
+++ b/sql/updates/world/2014_07_21_00_world_misc.sql
@@ -0,0 +1,3 @@
+--
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 19768);
+UPDATE creature_template_addon SET `bytes1`=0, `bytes2`=0 WHERE `entry` IN (19762, 19768, 19784);