diff options
| author | offl <offl@users.noreply.github.com> | 2017-12-17 19:42:59 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-12-17 19:42:59 +0100 |
| commit | afa891d04d90189c9eeef49b4fd00f95936c540d (patch) | |
| tree | 963fc0c0dbba2f2cb332168b2c54e5b838385248 | |
| parent | 99cc4bb525abee4007d2313526226abfe641cba2 (diff) | |
DB/Creature: Add school immunity for some creatures
Ref https://github.com/TrinityCore/TrinityCore/pull/20709
| -rw-r--r-- | sql/updates/world/3.3.5/2017_12_17_01_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_12_17_01_world.sql b/sql/updates/world/3.3.5/2017_12_17_01_world.sql new file mode 100644 index 00000000000..3ae0c2d95f4 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_12_17_01_world.sql @@ -0,0 +1,11 @@ +-- +UPDATE `creature_template` SET `spell_school_immune_mask`=`spell_school_immune_mask`|2 WHERE `entry` IN (12457,16491); -- Holy +UPDATE `creature_template` SET `spell_school_immune_mask`=`spell_school_immune_mask`|4 WHERE `entry` IN (2091,2108,2447,2726,2760,4036,4037,4038,4676,5850,5852,7137,7664,7734,7735,9016,9017,9026,9816,9878,9879,10485,11502,11666,11667,11668,12056,12143,12457,16491,19203,19973,20703,21706,22323,25001,25417,30847); -- Fire +UPDATE `creature_template` SET `spell_school_immune_mask`=`spell_school_immune_mask`|8 WHERE `entry` IN (92,2258,2592,2735,2736,2752,2762,2791,4499,10485,11321,11744,11777,11778,11779,11783,11784,12201,12237,12457,14435,14455,16491,17085,17154,17156,17157,17158,17159,17160,18062,18181,21707,22036,23029,26407,28411,28585,28825); -- Nature +UPDATE `creature_template` SET `spell_school_immune_mask`=`spell_school_immune_mask`|16 WHERE `entry` IN (691,2761,3917,5461,5462,7079,7132,7428,7429,7664,7734,7735,9453,10198,10485,10642,10756,10757,12457,13280,16491,17153,17155,17167,17207,17358,19204,20704,21428,21728,22009,22035,22309,25740,25755,25756,25757,25865,26116,26178,26204,26214,26215,26216,26338,26339,26340,26341,26342,16570,24228,24601,25226,25514,25715,26316,30846); -- Frost +UPDATE `creature_template` SET `spell_school_immune_mask`=`spell_school_immune_mask`|32 WHERE `entry` IN (703,1043,1364,7664,10485,12457,16491,19206,20705,21032); -- Shadow +UPDATE `creature_template` SET `spell_school_immune_mask`=`spell_school_immune_mask`|64 WHERE `entry` IN (7734,7735,10202,10485,10662,10663,10664,11480,11483,12457,16488,16491,16530,16854,18864,18865,18866,18867,19205,20516,20702,21032,22310,26370,30848); -- Arcane + +UPDATE `creature_template` SET `dmgschool` = 4 WHERE `entry` = 17153; -- Lake Spirit +UPDATE `creature_template` SET `dmgschool` = 3 WHERE `entry` = 17154; -- Muck Spawn +UPDATE `creature_template` SET `dmgschool` = 4 WHERE `entry` = 17155; -- Lake Surger |