diff options
| author | offl <offl@users.noreply.github.com> | 2021-01-26 23:43:50 +0200 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2021-01-26 23:43:50 +0200 |
| commit | 1ed79d7a2e61bf98178954a427cd4b7acd6c4509 (patch) | |
| tree | c033e302c0d5892473f595507f4673d7ce66091c /sql/updates | |
| parent | 41bdec22098776f669935444922975c529ede9a0 (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
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/3.3.5/2021_01_26_02_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
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); |