From 2dd539b1bae27878c8f27f0bee4f0f8881aeef91 Mon Sep 17 00:00:00 2001 From: offl Date: Fri, 7 May 2021 20:59:13 +0300 Subject: DB/Creature: Remove UNIT_FLAG_STUNNED / UNIT_FLAG_PREVENT_EMOTES_FROM_CHAT_TEXT in more cases Ref #25764 (cherry picked from commit 521325217a9caec2760c83c38ae75711c9e0cb49) --- .../master/2022_03_09_21_world_2021_05_07_01_world.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/world/master/2022_03_09_21_world_2021_05_07_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2022_03_09_21_world_2021_05_07_01_world.sql b/sql/updates/world/master/2022_03_09_21_world_2021_05_07_01_world.sql new file mode 100644 index 00000000000..8de3aba5a97 --- /dev/null +++ b/sql/updates/world/master/2022_03_09_21_world_2021_05_07_01_world.sql @@ -0,0 +1,18 @@ +-- Defense System +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ (536870912|262144) WHERE `entry` = 30837; + +-- Flame Sphere +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ (536870912|262144) WHERE `entry` IN (30106,31458,31686,31687); + +-- Crystalline Tangler +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ (536870912|262144) WHERE `entry` = 32665; + +-- Wrath Enforcer +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ 536870912 WHERE `entry` = 25030; + +-- Drom Frostgrip +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ (536870912|262144) WHERE `entry` = 29751; + +-- Forsaken Prisoner +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ 536870912, `dynamicflags` = 0 WHERE `entry` = 27400; +UPDATE `creature_addon` SET `auras` = "31261" WHERE `guid` = 97213; -- cgit v1.2.3