aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2021_05_10_00_world.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_05_10_00_world.sql b/sql/updates/world/3.3.5/2021_05_10_00_world.sql
new file mode 100644
index 00000000000..29dba85c954
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_05_10_00_world.sql
@@ -0,0 +1,11 @@
+-- Beaten Corpse
+UPDATE `creature_template` SET `dynamicflags` = 0 WHERE `entry` = 10668;
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 10668);
+
+-- Night Elf Corpse
+UPDATE `creature_template` SET `dynamicflags` = 0 WHERE `entry` = 16804;
+
+-- The Lich King
+-- AoD Impact Bunny
+-- Vegard Bunny
+UPDATE `creature_template` SET `unit_flags2` = 2048, `dynamicflags` = 0 WHERE `entry` IN (37857,37878,37894);