diff options
| author | offl <offl@users.noreply.github.com> | 2021-05-07 20:59:13 +0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-09 14:21:48 +0100 |
| commit | 2dd539b1bae27878c8f27f0bee4f0f8881aeef91 (patch) | |
| tree | f457d483fec9f5cd6541ef5c1d6f735fc661265b | |
| parent | 2d38b03b001b71e25f04bf1328ceee3f16593fcd (diff) | |
DB/Creature: Remove UNIT_FLAG_STUNNED / UNIT_FLAG_PREVENT_EMOTES_FROM_CHAT_TEXT in more cases
Ref #25764
(cherry picked from commit 521325217a9caec2760c83c38ae75711c9e0cb49)
| -rw-r--r-- | sql/updates/world/master/2022_03_09_21_world_2021_05_07_01_world.sql | 18 |
1 files changed, 18 insertions, 0 deletions
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; |