aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_03_06_03_world_2021_01_26_02_world.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_06_03_world_2021_01_26_02_world.sql b/sql/updates/world/master/2022_03_06_03_world_2021_01_26_02_world.sql
new file mode 100644
index 00000000000..f0500bbfd89
--- /dev/null
+++ b/sql/updates/world/master/2022_03_06_03_world_2021_01_26_02_world.sql
@@ -0,0 +1,14 @@
+-- Fire
+UPDATE `creature_template` SET `spell_school_immune_mask` = 4 WHERE `entry` IN (19551);
+
+-- Arcane
+UPDATE `creature_template` SET `spell_school_immune_mask` = 64 WHERE `entry` IN (15691);
+
+-- All
+UPDATE `creature_template` SET `spell_school_immune_mask` = 127 WHERE `entry` IN (11439,23111,20481,21538);
+
+-- Magic, except holy
+UPDATE `creature_template` SET `spell_school_immune_mask` = 124 WHERE `entry` IN (15275);
+
+-- Physical
+UPDATE `creature_template` SET `spell_school_immune_mask` = 1 WHERE `entry` IN (15276);