Files
mod-individual-progression/data/sql/world/base/vanilla_spell_school_immunity.sql
Grimfeather 01b0ffc5f7 Moving sql files to data folder (#670)
- all sql files moved to data directory
- vanilla_regen_values is now labeled as optional. zz_optional_vanilla_regen_values.sql
- vanilla_mob_factions removed, content moved to zone_ sql files
- naxx40_remove_disables removed, content moved to naxx40 sql file
- zone_elwynn_forest clean up
- zone_durotar clean up
- zone_tirisfal_glades clean up
2025-08-23 09:59:54 +02:00

57 lines
2.5 KiB
SQL

/* Infernal */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|4 WHERE entry=89;
/* Weaver */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|8 WHERE entry=5720;
/* Black Drake */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|4 WHERE entry=7044;
/* Scalding Drake */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|4 WHERE entry=7045;
/* Searscale Drake */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|4 WHERE entry=7046;
/* Smoldar */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|8 WHERE entry=8278;
/* Hematos */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|4 WHERE entry=8976;
/* Onyxia */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|4 WHERE entry=10184;
/* Whip Lasher */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|8 WHERE entry=13022;
/* Rogue Black Drake */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|4 WHERE entry=14388;
/* Viscidus Trigger */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|1|2|4|8|16|32|64 WHERE entry=15922;
/* Sapphiron */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|16 WHERE entry=15989;
/* Spectral Trainee */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|4|8|16|32|64 WHERE entry=16127;
/* Spectral Horse */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|4|8|16|32|64 WHERE entry=16149;
/* Spectral Rider */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|4|8|16|32|64 WHERE entry=16150;
/* Plague Slime */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|32 WHERE entry=16243;
/* Plague Slime (Blue) */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|16 WHERE entry=16783;
/* Plague Slime (Red) */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|4 WHERE entry=16784;
/* Plague Slime (Green) */
UPDATE `creature_template` SET `spell_school_immune_mask` = `spell_school_immune_mask`|8 WHERE entry=16785;