aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2011_09_15_03_world_creature_template.sql35
1 files changed, 35 insertions, 0 deletions
diff --git a/sql/updates/world/2011_09_15_03_world_creature_template.sql b/sql/updates/world/2011_09_15_03_world_creature_template.sql
new file mode 100644
index 00000000000..82f6138f17a
--- /dev/null
+++ b/sql/updates/world/2011_09_15_03_world_creature_template.sql
@@ -0,0 +1,35 @@
+-- Applied immunities to following mechanics:
+-- MECHANIC_CHARM
+-- MECHANIC_DISORIENTED
+-- MECHANIC_DISARM
+-- MECHANIC_DISTRACT
+-- MECHANIC_FEAR
+-- MECHANIC_GRIP
+-- MECHANIC_ROOT
+-- MECHANIC_SILENCE
+-- MECHANIC_SLEEP
+-- MECHANIC_SNARE
+-- MECHANIC_STUN
+-- MECHANIC_FREEZE
+-- MECHANIC_KNOCKOUT
+-- MECHANIC_POLYMORPH
+-- MECHANIC_BANISH
+-- MECHANIC_SHACKLE
+-- MECHANIC_TURN
+-- MECHANIC_HORROR
+-- MECHANIC_DAZE
+-- MECHANIC_SAPPED
+
+UPDATE `creature_template` SET `mechanic_immune_mask`=617299839 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