aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/master/2018_03_17_04_world_2016_12_24_03_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_03_17_04_world_2016_12_24_03_world.sql b/sql/updates/world/master/2018_03_17_04_world_2016_12_24_03_world.sql
new file mode 100644
index 00000000000..587770aebfb
--- /dev/null
+++ b/sql/updates/world/master/2018_03_17_04_world_2016_12_24_03_world.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (22174,22182,22187,22201,22202,22217,22218,22221,22392,22283,22289,22287,22451,22187,22385,22327,22286));
+DELETE FROM `creature` WHERE `id` IN (22174,22182,22187,22201,22202,22217,22218,22221,22392,22283,22289,22287,22451,22187,22385,22327,22286);
+
+UPDATE `creature_template` SET `unit_flags`=33555202 WHERE `entry`=22196;
+