diff options
| author | offl <offl@users.noreply.github.com> | 2021-01-26 23:43:50 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-06 16:30:51 +0100 |
| commit | 8e9e15629fb00c742695325c6ccba2fff8ad4939 (patch) | |
| tree | 1c50675f97d0993a42bce113e32f77a97003cd67 /sql/updates | |
| parent | 7c2129b60e4529e826ac1fdd4918bad400329a71 (diff) | |
Core/Scripts: Verify & migrate spell school immunities to DB
Some already are stored in DB. Looks like they all are still valid for master
(cherry picked from commit 1ed79d7a2e61bf98178954a427cd4b7acd6c4509)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2022_03_06_03_world_2021_01_26_02_world.sql | 14 |
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); |