From 1ed79d7a2e61bf98178954a427cd4b7acd6c4509 Mon Sep 17 00:00:00 2001 From: offl Date: Tue, 26 Jan 2021 23:43:50 +0200 Subject: Core/Scripts: Verify & migrate spell school immunities to DB Some already are stored in DB. Looks like they all are still valid for master --- sql/updates/world/3.3.5/2021_01_26_02_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/3.3.5/2021_01_26_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2021_01_26_02_world.sql b/sql/updates/world/3.3.5/2021_01_26_02_world.sql new file mode 100644 index 00000000000..f0500bbfd89 --- /dev/null +++ b/sql/updates/world/3.3.5/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); -- cgit v1.2.3