DB/Creature: Fixed Valkyr Shadowguard immunities

(cherrypicked from d61daf23cc130c42691ed4a510742502fb834183)

1 files changed, 22 insertions, 0 deletions

diff --git a/sql/updates/world/master/2019_06_20_09_world_2017_01_09_00_world.sql b/sql/updates/world/master/2019_06_20_09_world_2017_01_09_00_world.sql
new file mode 100644
index 00000000000..f0df5c4ed39
--- /dev/null
+++ b/sql/updates/world/master/2019_06_20_09_world_2017_01_09_00_world.sql
@@ -0,0 +1,22 @@
+-- Valkyr Shadowguard Imunity
+UPDATE `creature_template` SET `mechanic_immune_mask` = 
+1|          -- charm
+2|          -- disorient
+4|          -- disarm
+8|          -- distract
+16|         -- fear
+32|         -- grip
+64|         -- root
+256|        -- silence
+512|        -- sleep
+4096|       -- freeze
+8192|       -- knockout
+65536|      -- polymorph
+131072|     -- banish
+524288|     -- shackle
+1048576|    -- mount
+4194304|    -- turn
+8388608|    -- horror
+33554432|   -- interrupt
+536870912   -- sapped
+WHERE `entry` IN (36609,39120,39121,39122);