aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDanVS <DanVS@users.noreply.github.com>2018-10-15 21:11:18 +0200
committerKillyana <morphone1@gmail.com>2018-10-15 21:11:18 +0200
commitc6e80a4bfa48924be42479530ea29e4509bd1e7a (patch)
tree2e7681281ebdd753d7d437152b4c4f5b27d2d1fa
parentd7189d3e31679a08841c29b954806eb2e110f92a (diff)
DB/Creature: Player Summoned Elementals
Closes #22642
-rw-r--r--sql/updates/world/3.3.5/2018_10_15_04_world_335.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_10_15_04_world_335.sql b/sql/updates/world/3.3.5/2018_10_15_04_world_335.sql
new file mode 100644
index 00000000000..1322915f934
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_15_04_world_335.sql
@@ -0,0 +1,11 @@
+-- Infernal (89)
+UPDATE `creature_template` SET `spell_school_immune_mask`=`spell_school_immune_mask`|4 WHERE `entry`=89;
+
+-- Water Elemental (501)
+UPDATE `creature_template` SET `spell_school_immune_mask`=`spell_school_immune_mask`|16 WHERE `entry`=501;
+
+-- Greater Earth Elemental (15352)
+UPDATE `creature_template` SET `spell_school_immune_mask`=`spell_school_immune_mask`|8 WHERE `entry`=15352;
+
+-- Greater Fire Elemental (15438)
+UPDATE `creature_template` SET `spell_school_immune_mask`=`spell_school_immune_mask`|4 WHERE `entry`=15438;