diff options
| -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; |