aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2011_09_14_06_world_creature_template.sql40
1 files changed, 40 insertions, 0 deletions
diff --git a/sql/updates/world/2011_09_14_06_world_creature_template.sql b/sql/updates/world/2011_09_14_06_world_creature_template.sql
new file mode 100644
index 00000000000..4c7474895ad
--- /dev/null
+++ b/sql/updates/world/2011_09_14_06_world_creature_template.sql
@@ -0,0 +1,40 @@
+UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`
+|1 -- CHARM
+|2 -- DISORIENTED
+|4 -- DISARM
+|8 -- DISTRACT
+|16 -- FEAR
+|32 -- GRIP
+|64 -- ROOT
+|128 -- PACIFY
+|256 -- SILENCE
+|512 -- SLEEP
+|1024 -- SNARE
+|2048 -- STUN
+|4096 -- FREEZE
+|8192 -- KNOCKOUT
+|65536 -- POLYMORPH
+|131072 -- BANISH
+|524288 -- SHACKLE
+|4194304 -- TURN
+|8388608 -- HORROR
+|67108864 -- DAZE
+|536870912 -- SAPPED
+WHERE `entry` IN
+(36597,39166,39167,39168, -- The Lich King
+36612,37957,37958,37959, -- Lord Marrowgar
+36626,37504,37505,37506, -- Festergut
+36627,38390,38549,38550, -- Rotface
+36678,38431,38585,38586, -- Professor Putricide
+36853,38265,38266,38267, -- Sindragosa
+36855,38106,38296,38297, -- Lady Deathwhisper
+37813,38402,38582,38583, -- Deathbringer Saurfang
+37955,38434,38435,38436, -- Blood-Queen Lana'thel
+37970,38401,38784,38785, -- Prince Valanar
+37972,38399,38769,38770, -- Prince Keseleth
+37973,38400,38771,38772); -- Prince Taldaram
+
+UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`&~2097152 /* INFECTED */ WHERE `entry` IN
+(36626,37504,37505,37506,-- Festergut
+36627,38390,38549,38550, -- Rotface
+36678,38431,38585,38586); -- Professor Putricide