diff options
| author | offl <offl@users.noreply.github.com> | 2021-05-07 20:59:13 +0300 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2021-05-07 20:59:13 +0300 |
| commit | 521325217a9caec2760c83c38ae75711c9e0cb49 (patch) | |
| tree | 4bbdd8b17762ccdea793d2f7eff28d6f795fda22 | |
| parent | 10c7c5786678fc2db5b08ef5cf0302074e1a3179 (diff) | |
DB/Creature: Remove UNIT_FLAG_STUNNED / UNIT_FLAG_PREVENT_EMOTES_FROM_CHAT_TEXT in more cases
Ref #25764
| -rw-r--r-- | sql/updates/world/3.3.5/2021_05_07_01_world.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_05_07_01_world.sql b/sql/updates/world/3.3.5/2021_05_07_01_world.sql new file mode 100644 index 00000000000..8de3aba5a97 --- /dev/null +++ b/sql/updates/world/3.3.5/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; |