DB/Outland: Update creature static flags

(cherry picked from commit e3f25bbc38d3c35cb88090d24dfba10859e6171b)

1 files changed, 199 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_03_28_00_world_2024_03_26_00_world.sql b/sql/updates/world/cata_classic/2024_03_28_00_world_2024_03_26_00_world.sql
new file mode 100644
index 00000000000..945dba5d79e
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_03_28_00_world_2024_03_26_00_world.sql
@@ -0,0 +1,199 @@
+-- Unit flags
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33623; -- Fishing
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33621; -- Bandage Recipes
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33619; -- Cooking
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33618; -- Skinning
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33617; -- Mining
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33616; -- Herbalism
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33615; -- Inscription
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33614; -- Jewelcrafting
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33613; -- Tailoring
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33612; -- Leatherworking
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33611; -- Engineering
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33610; -- Enchanting
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33609; -- Blacksmithing
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=33608; -- Alchemy
+UPDATE `creature_template` SET `unit_flags`=33554688 WHERE `entry`=5202; -- Archery Target
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=23257; -- Skyguard Windcharger
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23051; -- Monstrous Kaliri
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22980; -- Skyguard Scout
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22441; -- Teribus the Cursed
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21859; -- Slain Sha'tar Vindicator
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21846; -- Slain Auchenai Warrior
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18707; -- Torgos
+UPDATE `creature_template` SET `unit_flags3`=0 WHERE `entry`=18490; -- Fallen Druid
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17076; -- Lady Liadrin
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=15241; -- Gryphon Rider Guard
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21931; -- Avian Flyer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18473; -- Talon King Ikiss
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18472; -- Darkweaver Syth
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23035; -- Anzu
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18778; -- Cosmetic Raging Soul
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18726; -- Flying Raging Soul
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18497; -- Auchenai Monk
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18373; -- Exarch Maladaar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18371; -- Shirrak the Dead Watcher
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18344; -- Nexus-Prince Shaffar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18343; -- Tavarok
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18341; -- Pandemonius
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21159; -- Containment Beam
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19427; -- Voidwalker Summoner
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=19224; -- Void Portal
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18848; -- Malicious Instructor
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18796; -- Fel Overseer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18794; -- Cabal Ritualist
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18793; -- Invisible Target
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18732; -- Grandmaster Vorpil
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18731; -- Ambassador Hellmaw
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=18708; -- Murmur
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18667; -- Blackheart the Inciter
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=24222; -- Windy Cloud
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18352; -- Boulderfist Hunter
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18351; -- Lump
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18259; -- Banthar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18258; -- Bach'lor
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18257; -- Gutripper
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18238; -- Murkblood Invader
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=18209; -- Kurenai Captive
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=18192; -- Horde Halaani Guard
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18102; -- Kalandrios
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18101; -- Aborius
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18100; -- Incineratus
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18099; -- Gordawg
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=17133; -- Aged Clefthoof
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18733; -- Fel Reaver
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=18282; -- Lord Klaq
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=18035; -- Scout Jyoba
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18409; -- Large AOI Underbat
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18105; -- Ghaz'an
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17882; -- The Black Stalker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17871; -- Underbog Shambler
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17826; -- Swamplord Musel'ek
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17770; -- Hungarfen
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17725; -- Underbog Lurker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22299; -- Spore Strider
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17991; -- Rokmar the Crackler
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17942; -- Quagmirran
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17941; -- Mennu the Betrayer
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=17890; -- Weeder Greenthumb
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21338; -- Coilfang Leper
+UPDATE `creature_template` SET `unit_flags`=33554432 WHERE `entry`=17954; -- Naga Distiller
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17951; -- Steamrigger Mechanic
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17798; -- Warlord Kalithresh
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17797; -- Hydromancer Thespia
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17796; -- Mekgineer Steamrigger
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=21695; -- Tidal Surger
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22335; -- Mushrom Spell Effect
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22119; -- Fathom Lurker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22056; -- Coilfang Strider
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22055; -- Coilfang Elite
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22036; -- Tainted Spawn of Hydross
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22009; -- Tainted Elemental
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21966; -- Fathom-Guard Sharkkis
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21965; -- Fathom-Guard Tidalvess
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21964; -- Fathom-Guard Caribdis
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=21958; -- Enchanted Elemental
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21933; -- Hydross Beam Helper
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21216; -- Hydross the Unstable
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21812; -- Phantom Leotheras
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21806; -- Greyheart Spellbinder
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21251; -- Underbog Colossus
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21228; -- Tidewalker Hydromancer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21227; -- Tidewalker Harpooner
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21226; -- Tidewalker Shaman
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21225; -- Tidewalker Warrior
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21224; -- Tidewalker Depth-Seer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21215; -- Leotheras the Blind
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21214; -- Fathom-Lord Karathress
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21213; -- Morogrim Tidewalker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21212; -- Lady Vashj
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23512; -- Crystalforge Bunny
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23500; -- Legion Ring Shield Zapper InvisMan
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23378; -- Simon Game Bunny Large
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=23282; -- Obsidia
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=23281; -- Insidion
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=23261; -- Furywing
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23119; -- Bombing Run Explosion Bunny
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=23076; -- Legion Flak Cannon
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=23061; -- Rivendark
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23059; -- Legion Ring Event InvisMan
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22422; -- Blade's Edge - Legion - Anger Camp - Invis Bunny
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22268; -- Leokk
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22196; -- Wrath Reaver
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22089; -- Toshley Flying Machine
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21984; -- Rexxar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21690; -- R-3D0
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21497; -- Blackscale
+UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=21349; -- T'chali the Witch Doctor
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20600; -- Maggoc
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20216; -- Grulloc
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21350; -- Gronn-Priest
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19389; -- Lair Brute
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19044; -- Gruul the Dragonkiller
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18847; -- Wild Fel Stalker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18836; -- Blindeye the Seer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18835; -- Kiggler the Crazed
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18834; -- Olm the Summoner
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18832; -- Krosh Firehand
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18831; -- High King Maulgar
+
+-- Difficulties
+UPDATE `creature_template_difficulty` SET `VerifiedBuild`=48526 WHERE (`Entry`=14881 AND `DifficultyID`=0);
+DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=1 AND `Entry` IN (17378,18035,18275,17637,17841,17858,17896,17904,17909,17969,18070,18080,18086,18122,18124,18138,18212,18213,18214,18243,18244,18245,18246,18247,18564,18788,18791,18909,18910,18911,18922,19380,19383,19402,19946,19947,20079,20290,20324,20762,22832,23373,119287));
+DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID` IN (1,2) AND `Entry` IN (13321));
+
+-- Static flags
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0 WHERE (`Entry`=22326 AND `DifficultyID`=0);
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=537395456 WHERE (`Entry`=5202 AND `DifficultyID`=0);
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`DifficultyID`=0 AND `Entry` IN (27723,25967,24936,24411,24410,23855,23854,23853,23852,23850,23845));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=256 WHERE (`DifficultyID`=0 AND `Entry` IN (33623,33621,33619,33618,33617,33616,33615,33614,33613,33612,33611,33610,33609,33608));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`DifficultyID`=0 AND `Entry` IN (66542,66541,66540,52277,50145,50143,50140,50139,50130,50025,50024,50023,50020,50019,50018,33684,33683,33682,33681,33680,33679,33678,33677,33676,33675,33674,33642,33641,33640,33639,33638,33637,33636,33635,33634,33633,33631,33630,27667,27666,25992,25196,25195,25115,24938,24932,24437,24393,24370,24369,23948,23484,23483,23449,23433,23273,23272,23271,23270,23263,22940,22819,22213,22212,21906,21905,21816,21655,21518,21517,21432,21411,20808,20807,20791,20616,20613,20331,20125,20124,20123,19726,19725,19720,19715,19684,19678,19664,19663,19662,19661,19485,19475,19390,19377,19346,19340,19338,19337,19331,19330,19321,19318,19289,19283,19271,19270,19252,19251,19250,19249,19248,19246,19245,19244,19243,19242,19240,19239,19238,19236,19235,19234,19232,19227,19223,19216,19213,19202,19197,19196,19195,19194,19187,19186,19184,19182,19180,19170,19153,19150,19144,19142,19120,19077,19076,19065,19064,19063,19050,19046,19043,19034,19033,18940,18893,18756,18652,18600,18597,18596,18594,18585,18584,18549,18547,18538,18537,18531,18530,18166));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`DifficultyID`=0 AND `Entry` IN (115695,24886,24885,23415,23383,23367,23102,23094,23093,23092,23091,23048,23042,23038,23016,22481,22477,22476,22464,22463,22462,22458,22456,22453,22446,22420,22407,22388,22387,22381,22378,22365,22364,22278,22100,22045,21911,21907,21902,21870,21869,21859,21858,21852,21846,21728,21724,21723,21662,21661,21660,21650,21649,21644,21636,21515,21504,21400,21399,21398,21397,21285,21284,21242,21194,21193,21192,21188,21007,20893,20892,20891,20890,19773,19772,19718,19693,19689,19606,19417,19296,19181,19159,19154,19147,19056,19053,19048,19042,19003,19002,19000,18999,18973,18957,18809,18807,18760,18745,18720,18719,18718,18717,18716,18714,18713,18712,18704,18685,18676,18675,18670,18647,18595,18588,18583,18566,18554,18548,18541,18540,18539,18492,18477,18475,18470,18469,18468,18467,18465,18464,18463,18460,18459,18457,18456,18455,18454,18453,18452,18451,18450,18449,18447,18446,18438,18437,18424,18390,18389,18387,18386,18385,18384,18383,18273,18262,18260,18252,18249,17143,17142,17088,16810,16805,16772,16769,16519));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`DifficultyID`=0 AND `Entry` IN (24893,22355,21899,21898,21039,20809,20767,19677,19674,18843));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0 WHERE (`Entry`=22831 AND `DifficultyID`=0);
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306624 WHERE (`DifficultyID`=0 AND `Entry` IN (18705,22457));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368 WHERE (`DifficultyID`=0 AND `Entry` IN (22441,18707,22340,22288));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435712 WHERE (`DifficultyID`=0 AND `Entry` IN (18490,18480));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`DifficultyID`=0 AND `Entry` IN (21856,21793,21792,21791));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`DifficultyID`=0 AND `Entry` IN (14881,2914));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`Entry` IN (83996,53488,20343,19224,18766));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=537919744 WHERE (`Entry` IN (19427));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (54698,18524,18521,18473,18472,54840,18702,18559,18558,18557,18556,18497,18495,18493,18373,18371,18341,18343,18344,18703,23035,18503,18501,18500,18499,18498,54891,54890,18891,18848,18830,18797,18796,18794,18732,18731,18667,18663,18642,18641,18640,18639,18638,18637,18636,18635,18634,18633,18632,18631));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368 WHERE (`Entry` IN (18793,21159));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306624 WHERE (`Entry` IN (18708));
+UPDATE `creature_template_difficulty` SET `StaticFlags3`=33554432 WHERE (`Entry` IN (54847));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`DifficultyID`=0 AND `Entry` IN (18240,121086,115655,66539,66538,66537,24881,24866,23268,23265,23022,22981,22893,22836,22394,22363,22362,22343,22342,22341,22309,22199,22148,22144,22143,21484,21483,21474,20812,20241,20240,20097,20096,19844,19687,19201,19161,19158,19156,19151,19149,19141,19140,19137,19133,19071,19068,19035,19030,19027,19026,19025,19024,19023,19022,19021,19020,19019,19018,19017,19015,19014,19013,19012,19011,18914,18913,18821,18816,18789,18683,18658,18567,18536,18535,18489,18488,18471,18445,18440,18428,18417,18416,18415,18414,18413,18408,18407,18391,18369,18353,18352,18334,18302,18301,18300,18299,18296,18293,18292,18261,18238,18234,18233,18229,18224,18223,18222,18211,18210,18209,18207,18204,18203,18202,18192,18183,18145,18141,18106,18074,18073,18072,18071,18068,18067,18066,18065,18064,18063,18043,18037,17155,17154,17153,17152,17151,17148,17147,17146,17144,17138,17137,17136,17135,17134,16945));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0 WHERE (`DifficultyID`=0 AND `Entry` IN (22979,22839,22838));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368 WHERE (`DifficultyID`=0 AND `Entry` IN (22400,19152,18662));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`DifficultyID`=0 AND `Entry` IN (21893,19660,19646,19590,19212,19211,19139,19041,18842,18841,18840,18590,18589,18532,18444,18395,18393,18388,18354,18308,18307,18306,18305,18228,18218,18215,18208,18196,18144,18143,18142,18110));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`Entry`=18257 AND `DifficultyID`=0);
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=256 WHERE (`DifficultyID`=0 AND `Entry` IN (17545));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`DifficultyID`=0 AND `Entry` IN (119287));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=256 WHERE (`DifficultyID`=0 AND `Entry` IN (18035));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`DifficultyID`=0 AND `Entry` IN (22088,22087,22086));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0 WHERE (`DifficultyID`=0 AND `Entry` IN (22829,18275));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`DifficultyID`=0 AND `Entry` IN (66536,66535,66534,61142,23373,22832,22823,22489,22488,22485,22144,22143,21854,20762,20710,20477,20444,20443,20442,20324,20295,20294,20293,20090,20089,20088,20079,19947,19946,19734,19732,19519,19402,19383,19380,18992,18943,18922,18911,18910,18909,18791,18788,18684,18680,18586,18581,18564,18476,18466,18461,18340,18334,18247,18246,18245,18244,18243,18238,18214,18213,18160,18139,18127,18125,18124,18123,18122,18121,18120,18119,18118,18117,18089,18088,18087,18086,18080,18070,18046,18044,17969,17909,17904,17896,17858,17841,17637));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268697600 WHERE (`DifficultyID`=0 AND `Entry` IN (20290,18750,18212,18138));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268697600 WHERE (`Entry` IN (20465));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=537919744 WHERE (`Entry` IN (17990));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`Entry` IN (54638,18409));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (54678,18105,17827,17882,17826,17770,17735,17727,17726));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=256 WHERE (`Entry` IN (17890));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (54668,21127,21126,17991,17961,17960,17959,17958,17957,17942,17941,17940,17938,17893,17817,17816));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368 WHERE (`Entry` IN (22421));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`Entry` IN (20208,18179,18176));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`Entry` IN (20926));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`Entry` IN (17954));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `StaticFlags3`=33554432 WHERE (`Entry` IN (54849));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (54851,17805,17803,17802,17801,17800,17798,17797,17796,17722,17721));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268697600 WHERE (`Entry` IN (21508));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`Entry` IN (22486,22250,22236,22091));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (22352,22238,22119,22104,22056,22055,22036,21966,21965,21964,21958,21863,21812,21806,21339,21301,21299,21298,21263,21253,21251,21246,21232,21231,21230,21229,21228,21227,21226,21225,21224,21221,21220,21218,21215,21214));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`Entry` IN (22057));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306624 WHERE (`Entry` IN (22009));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`DifficultyID`=0 AND `Entry` IN (115644,115598,115597,62638,62184,50481,23473,23428,23413,23362,23347,23335,23334,23316,23300,23280,23257,23256,23233,23208,23154,23153,23120,23115,23112,23110,22995,22982,22980,22941,22924,22922,22911,22469,22465,22410,22396,22386,22384,22308,22306,22305,22298,22291,22282,22271,22270,22266,22264,22255,22254,22244,22243,23385,22242,22241,22215,22206,22204,22196,22195,22180,22160,22151,22150,22149,22130,22110,22108,22103,22099,22053,22044,22019,22007,22004,21984,21983,21981,21975,21956,21896,21895,21837,21824,21810,21809,21782,21755,21692,21691,21690,21637,21496,21389,21383,21382,21311,21300,21296,21254,21238,21197,21158,21151,21147,21117,21115,21081,21066,21048,21047,21046,21032,21023,20998,20987,20924,20766,20765,20757,20756,20753,20732,20731,20730,20729,20728,20726,20723,20714,20600,20557,20514,20330,20329,20216,20211,20161,20113,20095,20058,19998,19997,19996,19995,19994,19993,19992,19991,19990,19989,19988,19987,19986,19985,19984,19983,19982,19957,19952,19948,19945,19944,19943,19747,19500,19449,18937,18693,18098,17855,16952,10204));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`DifficultyID`=0 AND `Entry` IN (51612,23278,23119,23082,23077,23076,23040,22919,22495,22472,22471,22443,22126,22125,22124,22090,21814,21352,20214));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`DifficultyID`=0 AND `Entry` IN (23500,23395,23378,23301,23281,23261,23255,23228,23212,23061,23059,22923,22422,22021,21840,21447,21203,20635,20024,20023,20003));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368 WHERE (`DifficultyID`=0 AND `Entry` IN (21349,21944,21942,21935,21930,21413,23253,22268,22039,21757,21737));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0 WHERE (`DifficultyID`=0 AND `Entry` IN (22918,22801,22800,22799,22798,22500,22181,22116,22052,21142,21124,21123,21033,21022,21004,20751,20749,20748,20127));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`Entry` IN (19198));