aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-05-10 22:24:58 +0300
committerShauren <shauren.trinity@gmail.com>2022-03-09 14:41:12 +0100
commitba51fb9ccb767a0b0996eb42e63e0d11742b4f2d (patch)
treea585db8c17c9e916a02455484feabfe88a4f595f
parent3764a439fba36a65f1943190b19d8b37a6f9e247 (diff)
DB/Creature: Remove few more evil flags
Ref #25764 (cherry picked from commit 7ff98464adaa06a346475422164780b517cb0adc)
-rw-r--r--sql/updates/world/master/2022_03_09_27_world_2021_05_10_00_world.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_09_27_world_2021_05_10_00_world.sql b/sql/updates/world/master/2022_03_09_27_world_2021_05_10_00_world.sql
new file mode 100644
index 00000000000..29dba85c954
--- /dev/null
+++ b/sql/updates/world/master/2022_03_09_27_world_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);