DB/Outland: Update creature static flags

1 files changed, 311 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_04_20_00_world.sql b/sql/updates/world/master/2024_04_20_00_world.sql
new file mode 100644
index 00000000000..5584ed0f3ea
--- /dev/null
+++ b/sql/updates/world/master/2024_04_20_00_world.sql
@@ -0,0 +1,311 @@
+-- Unit flags
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22293; -- Inactive Fel Reaver
+UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=20922; -- Fallen Vindicator
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=20899; -- Void Conduit
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20772; -- Netherock
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20769; -- Salaadin's Energy Ball
+UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=20561; -- Withered Corpse
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20454; -- Nexus-King Salhadaar
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=20243; -- Scrapped Fel Reaver
+UPDATE `creature_template` SET `unit_flags`=33555200, `unit_flags2`=2048, `unit_flags3`=1 WHERE `entry`=20148; -- Dead Doomguard
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20132; -- Socrethar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19568; -- Unending Voidwraith
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19565; -- Enormous Void Storm
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19554; -- Dimensius the All-Devouring
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19336; -- Void Spawner XL
+UPDATE `creature_template` SET `unit_flags`=33554496 WHERE `entry`=19507; -- Sunseeker Gene-Splicer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17980; -- Laj
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17978; -- Thorngrin the Tender
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17977; -- Warp Splinter
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17976; -- Commander Sarannis
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17975; -- High Botanist Freywinn
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=21962; -- Udalo
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=21101; -- Unbound Void Zone
+UPDATE `creature_template` SET `unit_flags`=832, `unit_flags2`=2048 WHERE `entry`=20977; -- Millhouse Manastorm
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20912; -- Harbinger Skyriss
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20911; -- Blackwing Drakonaar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20910; -- Twilight Drakonaar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20909; -- Sulfuron Magma-Thrower
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20908; -- Akkiris Lightning-Waker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20905; -- Blazing Trickster
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20904; -- Warden Mellichar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20900; -- Unchained Doombringer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20898; -- Gargantuan Abyssal
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20886; -- Wrath-Scryer Soccothrates
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20885; -- Dalliah the Doomsayer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20870; -- Zereketh the Unbound
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19710; -- Gatewatcher Iron-Hand
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19220; -- Pathaleon the Calculator
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19219; -- Mechano-Lord Capacitus
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19218; -- Gatewatcher Gyro-Kill
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22517; -- World Trigger (Large AOI)
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20064; -- Thaladred the Darkener
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20063; -- Master Engineer Telonicus
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20062; -- Grand Astromancer Capernian
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20060; -- Lord Sanguinar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20052; -- Crystalcore Mechanic
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20050; -- Crimson Hand Inquisitor
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20049; -- Crimson Hand Blood Knight
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20048; -- Crimson Hand Centurion
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20047; -- Crimson Hand Battle Mage
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20046; -- Astromancer Lord
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20045; -- Nether Scryer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20044; -- Novice Astromancer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20043; -- Apprentice Star Scryer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20042; -- Tempest-Smith
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20041; -- Crystalcore Sentinel
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20040; -- Crystalcore Devastator
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20039; -- Phoenix-Hawk
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20038; -- Phoenix-Hawk Hatchling
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20037; -- Tempest Falconer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20036; -- Bloodwarder Squire
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20035; -- Bloodwarder Marshal
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20034; -- Star Scryer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20033; -- Astromancer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20032; -- Bloodwarder Vindicator
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20031; -- Bloodwarder Legionnaire
+UPDATE `creature_template` SET `npcflag`=1, `unit_flags2`=2048 WHERE `entry`=19622; -- Kael'thas Sunstrider
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19551; -- Ember of Al'ar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19516; -- Void Reaver
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19514; -- Al'ar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18928; -- Astromancer Solarian Spotlight
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18925; -- Solarium Agent
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18806; -- Solarium Priest
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18805; -- High Astromancer Solarian
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=21364; -- Phoenix Egg
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=21362; -- Phoenix
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21274; -- Staff of Disintegration
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21273; -- Phaseshift Bulwark
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21272; -- Warp Slicer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21271; -- Infinity Blades
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21270; -- Cosmic Infuser
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21269; -- Devastation
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21268; -- Netherstrand Longbow
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=19400; -- Fel Reaver Sentry
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=19399; -- Fel Cannon
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=19398; -- Gan'arg Peon
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=19397; -- Mo'arg Overseer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19359; -- Legion Transporter: Beta (Alliance)
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19358; -- Legion Transporter: Alpha (Alliance)
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19336; -- Void Spawner XL
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19292; -- Legion Transporter: Beta
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19291; -- Legion Transporter: Alpha
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19215; -- Infernal Relay (Hellfire)
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18946; -- Infernal Siegebreaker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18945; -- Pit Commander
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18729; -- Infernal Rain (Hellfire)
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=16887; -- Eye of Honor Hold
+UPDATE `creature_template` SET `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=16852; -- Sedai's Corpse
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=16598; -- Eye of Thrallmar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=15242; -- Bat Rider Guard
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17537; -- Vazruden
+UPDATE `creature_template` SET `unit_flags`=64, `unit_flags2`=2048 WHERE `entry`=17307; -- Vazruden the Herald
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17309; -- Hellfire Watcher
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17308; -- Omor the Unscarred
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17306; -- Watchkeeper Gargolmar
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21174; -- Magtheridon
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17653; -- Shadowmoon Channeler
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17381; -- The Maker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17380; -- Broggok
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=17377; -- Keli'dan the Breaker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17256; -- Hellfire Channeler
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=57909; -- Thrallmar Invader
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=57908; -- Thrallmar Scryer
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=17693; -- Shattered Hand Scout
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17623; -- Reaver Guard
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17622; -- Sharpshooter Guard
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17621; -- Heathen Guard
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17611; -- Warchief's Portal
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17462; -- Shattered Hand Zealot
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17461; -- Shattered Hand Blood Guard
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17427; -- Shattered Hand Archer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=16809; -- Warbringer O'mrogg
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=16808; -- Warchief Kargath Bladefist
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=16807; -- Grand Warlock Nethekurse
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=20923; -- Blood Guard Porung
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18829; -- Hellfire Warder
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=17257; -- Magtheridon
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=24925; -- Boss Portal: Purple (3.00)
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23348; -- Captain Skyshatter
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23346; -- Wing Commander Mulverick
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23345; -- Wing Commander Ichman
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23344; -- Corlok the Vet
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23342; -- Trope the Filth-Belcher
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23340; -- Murg "Oldie" Muckjaw
+UPDATE `creature_template` SET `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=23287; -- Murkblood Miner
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23283; -- Lady Sinestra
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23188; -- Dragonmaw Transporter
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22859; -- Shadowhoof Summoner
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22274; -- Dragonmaw Skybreaker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22146; -- Summoning Voidstorm
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22112; -- Karynaku
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22082; -- Shadowmoon Slayer
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=21908; -- Spellbound Terrorguard
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21727; -- Flanis Swiftwing
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21725; -- Kagrosh
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=21711; -- Haalum
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=21710; -- Uylaru
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=21709; -- Eykenen
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21657; -- Neltharaku
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21648; -- Mature Netherwing Drake
+UPDATE `creature_template` SET `unit_flags`=576 WHERE `entry`=21506; -- Azaloth
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=21416; -- Lakaan
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21404; -- Legion Hold Fel Reaver
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21315; -- Ruul the Darkener
+UPDATE `creature_template` SET `unit_flags`=0, `unit_flags2`=2048 WHERE `entry`=21307; -- Eva
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21166; -- Illidari Dreadlord
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21153; -- Kor'kron Wyvern Rider
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=21102; -- Uvuros
+UPDATE `creature_template` SET `unit_flags2`=2048, `unit_flags3`=0 WHERE `entry`=19760; -- Cooling Infernal
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=19382; -- Wildhammer Gryphon Rider
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=18528; -- Xi'ri
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23524; -- Ashtongue Spiritbinder
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23523; -- Ashtongue Elementalist
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23472; -- World Trigger (Large AOI, Not Immune PC/NPC)
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23436; -- Image of Dementia
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=23421; -- Ashtongue Channeler
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23420; -- Essence of Anger
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23419; -- Essence of Desire
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23418; -- Essence of Suffering
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23403; -- Illidari Assassin
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23402; -- Illidari Battle-mage
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23401; -- Hungering Soul Fragment
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23400; -- Illidari Archon
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23399; -- Suffering Soul Fragment
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23397; -- Illidari Blood Lord
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23394; -- Promenade Sentinel
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23374; -- Ashtongue Stalker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23339; -- Illidari Heartseeker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23337; -- Illidari Centurion
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23330; -- Dragonmaw Wind Reaver
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23318; -- Ashtongue Rogue
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23239; -- Bonechewer Combatant
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23237; -- Bonechewer Blood Prophet
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23236; -- Bonechewer Shield Disciple
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23235; -- Bonechewer Blade Fury
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23226; -- Illidari Elite
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23223; -- Bonechewer Spectator
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23222; -- Bonechewer Brawler
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23216; -- Ashtongue Defender
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=23215; -- Ashtongue Sorcerer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23197; -- Maiev Shadowsong
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23196; -- Bonechewer Behemoth
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23147; -- Shadowmoon Grunt
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=23089; -- Akama
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23049; -- Shadowmoon Weapon Master
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23047; -- Shadowmoon Soldier
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23030; -- Dragonmaw Sky Stalker
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=23018; -- Shadowmoon Houndmaster
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22997; -- Flame of Azzinoth
+UPDATE `creature_template` SET `unit_flags2`=2080 WHERE `entry`=22996; -- Blade of Azzinoth
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22964; -- Priestess of Delight
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22962; -- Mistress of Woe
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22960; -- Dragonmaw Wyrmcaller
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22957; -- Mistress of Dementia
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22956; -- Priestess of Torment
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22954; -- Illidari Fearbringer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22953; -- Wrathbone Flayer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22952; -- Veras Darkshadow
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22951; -- Lady Malande
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22950; -- High Nethermancer Zerevor
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22949; -- Gathios the Shatterer
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22948; -- Gurtogg Bloodboil
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22947; -- Mother Shahraz
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=22946; -- Shadowmoon War Hound
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22945; -- Shadowmoon Blood Mage
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22917; -- Illidan Stormrage
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22898; -- Supremus
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22887; -- High Warlord Naj'entus
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22885; -- Dragon Turtle
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22884; -- Leviathan
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22883; -- Aqueous Spawn
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22882; -- Shadowmoon Deathshaper
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22881; -- Aqueous Surger
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22880; -- Shadowmoon Champion
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22879; -- Shadowmoon Reaver
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22878; -- Aqueous Lord
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22877; -- Coilskar Wrangler
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22875; -- Coilskar Sea-Caller
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22874; -- Coilskar Harpooner
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22873; -- Coilskar General
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22871; -- Teron Gorefiend
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22869; -- Illidari Boneslicer
+UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=22856; -- Reliquary of the Lost
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22855; -- Illidari Nightlord
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22853; -- Illidari Defiler
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22849; -- Ashtongue Feral Spirit
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22848; -- Storm Fury
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22847; -- Ashtongue Primalist
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22846; -- Ashtongue Stormcaller
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22845; -- Ashtongue Mystic
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22844; -- Ashtongue Battlelord
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22841; -- Shade of Akama
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22517; -- World Trigger (Large AOI)
+UPDATE `creature_template` SET `npcflag`=3, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=123252; -- Vormu
+UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=22876; -- Coilskar Soothsayer
+
+UPDATE `creature_template_addon` SET `visibilityDistanceType`=4 WHERE `entry`=20772; -- 20772 (Netherock)
+UPDATE `creature_template_addon` SET `StandState`=0, `emote`=0, `auras`='29266' WHERE `entry`=20148; -- 20148 (Dead Doomguard)
+
+DELETE FROM `creature_template_movement` WHERE `CreatureId`=115598;
+INSERT INTO `creature_template_movement` (`CreatureId`, `HoverInitiallyEnabled`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES
+(115598, 1, 0, 0, NULL);
+
+-- Static flags
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`Entry`=5202 AND `DifficultyID`=0);
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`DifficultyID`=0 AND `Entry` IN (20561,143231,72823,29145,28343,25994,25962,25918,25913,22494,22280,22279,21751,21734,21733,21732,21267,21259,21089,21065,20934,20931,20930,20929,20920,20803,20796,20780,20778,20774,20773,20772,20685,20512,20498,20485,20484,20471,20470,20464,20463,20447,20435,20416,20410,20409,20397,20393,20341,20326,20285,20281,20248,20221,20207,20203,20202,20194,20162,20140,20139,20136,20135,20134,20132,20112,20102,20092,20066,19940,19926,19880,19840,19839,19832,19831,19830,19780,19779,19776,19737,19731,19728,19727,19709,19707,19690,19686,19657,19651,19645,19643,19635,19634,19623,19621,19617,19612,19610,19593,19589,19588,19582,19578,19570,19569,19546,19545,19544,19543,19541,19529,19482,19469,19468,19467,19466,19453,18886,18885,18883,18882,18881,18880,18879,18857,18855,18853,18852,18850,18593,17636,16781));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`DifficultyID`=0 AND `Entry` IN (62627,20153,20133,19868,19867,19866,19724,19723,19654,19568,19565,19439,19336,17066));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0 WHERE (`DifficultyID`=0 AND `Entry` IN (26258,22351,22350,22348,20673,20671,20611,20454,16592));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`DifficultyID`=0 AND `Entry` IN (23491,22069,22068,22065,22063,21997,21974,21233,21090,20933,20858,20608,20553,20243,20148,19554));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=256 WHERE (`DifficultyID`=0 AND `Entry` IN (22293,20899));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435712 WHERE (`DifficultyID`=0 AND `Entry` IN (20922));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368 WHERE (`DifficultyID`=0 AND `Entry` IN (20804,20084,19656,19421));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306624 WHERE (`Entry`=20775 AND `DifficultyID`=0);
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368 WHERE (`Entry` IN (19919));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (19969,19964,19962,19958,19920,19953,19949,19633,19608,19557,19509,19508,19507,19505,19486,18587,18422,18421,18420,18419,18405,18404,18155,17994,17993,17980,17978,17977,17976,17975));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (21304,21303,20912,20886,20885,20883,20882,20870,20859,20857));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306624 WHERE (`Entry`=20904);
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`Entry` IN (21962,21761,21414,21290,21186,21101,21030));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (20990,20988,20481,20478,20059,19735,19510,19221,19220,19168,19167,19166));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (20064,20063,20062,20052,20050,20049,20048,20047,20046,20045,20044,20043,20042,20041,20040,20039,20038,20037,20036,20035,20034,20033,20032,20031,19622,19551,19516,18805,12999,21362,21274,21273,21272,21271,21269,21268,18925,18806));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`Entry` IN (20602,21369,18928));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368 WHERE (`Entry` IN (19514));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`Entry` IN (21002));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=806355200 WHERE (`Entry` IN (21364));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`DifficultyID`=0 AND `Entry` IN (66533,66532,66531,61325,51904,51903,51800,30735,30734,30722,30721,25994,25962,25934,25900,24937,24918,22431,22430,22231,22107,21283,21256,21175,21133,20793,20238,20237,20236,20235,20234,20231,19937,19836,19766,19764,19763,19736,19701,19683,19682,19562,19558,19459,19458,19457,19455,19451,19446,19445,19444,19443,19442,19436,19435,19426,19425,19424,19422,19415,19414,19413,19411,19410,19409,19408,19401,19354,19332,19316,19315,19314,19310,19309,19308,19298,19295,19273,19264,19263,19258,19257,19256,19255,19253,19229,19190,19007,19006,18998,18997,18986,18977,18972,18971,18970,18969,18966,18965,18950,18949,18948,18944,18931,18930,18785,18758,18733,18677,18267,18266,17657,17585,17282,17277,17226,17123,17058,16978,16977,16976,16964,16960,16954,16938,16937,16925,16912,16911,16907,16905,16904,16878,16876,16873,16871,16870,16867,16848,16847,16846,16845,16842,16794,16793,16792,16791,16790,16781,16591,16583,16580,12999));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=256 WHERE (`DifficultyID`=0 AND `Entry` IN (17062,16852));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`DifficultyID`=0 AND `Entry` IN (20251,19336,17066));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306624 WHERE (`DifficultyID`=0 AND `Entry` IN (24933,22177));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368 WHERE (`DifficultyID`=0 AND `Entry` IN (22432,21391,19656));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435712 WHERE (`Entry`=20158 AND `DifficultyID`=0);
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`DifficultyID`=0 AND `Entry` IN (24959,24921,22461,22002,22001,21996,21993,20781,20617,19624,19399,19393,19376,19359,19358,19329,19328,19326,19292,19291,19279,19278,19277,19276,19225,17060,17059,16865,2615,2614));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0 WHERE (`DifficultyID`=0 AND `Entry` IN (26258,26223,26222,22467,22403,22402,22401,22003,21999,21237,21236,21182,21173,20816,20815,20814,20813,19009,19008,18849,18828,18818,16592));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=1048576 WHERE (`DifficultyID`=0 AND `Entry` IN (18729));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`Entry`=17307);
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (54607,17537,17517,17478,17455,17308,17306,17281,17271,17270,17269,17264,17259));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=256 WHERE (`Entry`=17662);
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`Entry` IN (55108,54638,21174));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`Entry`=16006);
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (54746,54637,19016,18894,17626,17624,17491,17477,17429,17416,17414,17400,17399,17398,17397,17395,17381,17380,17377,17371,17370,17256));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0 WHERE (`Entry`=17296);
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`Entry` IN (17376,20709,19524,19523,18370,17611,17578,17471));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435712 WHERE (`Entry` IN (57909,57908));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (18829,17695,17694,17671,17670,17465,17464,17420,17083,16809,16808,16807,16704,16700,16699,16594,16593,16523,16507,17301));
+UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=9 WHERE (`Entry`=22515 AND `DifficultyID`=0);
+DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=1 AND `Entry` IN (23033,21348,23188,22417,22395,22146,22139,21879,21807,21657,21512,21417,21403,21347,21334,21211,21210,20289,20288,20286,19382,17066,21153,21710,113941,23496,23308,22315,22080,22079,22078,22071,22070,22066,22054,22001,21996,21993,21924,21705,21704,21703,21420,21096,21095,21094,21092,21041,20076,19388,19387,18528,2630,2615,2614,66545,66544,66543,61385,49568,25994,25962,25938,25905,23489,23454,23452,23443,23434,23376,23370,23348,23346,23345,23344,23342,23340,23324,23311,23309,23291,23166,23150,23148,23146,23145,23144,23143,23142,23141,23140,23139,22966,22864,22863,22862,22861,22860,22859,22858,22857,22433,22253,22252,22214,22211,22138,22113,22093,22084,22082,22081,22072,22037,22018,22017,22016,22012,22011,21986,21979,21955,21954,21953,21938,21937,21908,21897,21860,21822,21808,21803,21802,21797,21789,21777,21775,21774,21773,21772,21771,21770,21769,21754,21753,21749,21746,21744,21743,21742,21736,21722,21721,21720,21719,21718,21717,21699,21663,21656,21639,21520,21505,21503,21499,21478,21477,21472,21455,21454,21453,21450,21408,21404,21402,21386,21385,21384,21340,21337,21336,21330,21316,21315,21314,21309,21305,21302,21295,21293,21291,21207,21205,21196,21195,21183,21180,21179,21178,21171,21168,21166,21164,21108,21102,21059,21050,21049,21026,21024,20878,20872,20795,20684,20683,20563,20502,19827,19826,19825,19823,19806,19802,19801,19800,19799,19796,19795,19792,19789,19788,19784,19769,19768,19767,19765,19762,19759,21080,19757,19756,19755,19754,19740,19532,19530,19528,19526,19521,19520,19518,19517,19504,19395,19394,19384,19375,19374,19373,19372,19371,19370,19369,19368,19362,19355,19353,19352,19351,18696,18695,18694,17008,16781));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0 WHERE (`DifficultyID`=0 AND `Entry` IN (21307,26258,22003,22000,21999,21153,16592));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`DifficultyID`=0 AND `Entry` IN (23287,66545,66544,66543,61385,49568,25994,25962,25938,25905,23489,23454,23452,23443,23434,23376,23370,23348,23346,23345,23344,23342,23340,23324,23311,23309,23291,23166,23150,23148,23146,23145,23144,23143,23142,23141,23140,23139,22966,22864,22863,22862,22861,22860,22859,22858,22857,22433,22253,22252,22214,22211,22138,22113,22093,22084,22082,22081,22072,22037,22018,22017,22016,22012,22011,21986,21979,21955,21954,21953,21938,21937,21908,21897,21860,21822,21808,21803,21802,21797,21789,21777,21775,21774,21773,21772,21771,21770,21769,21754,21753,21749,21746,21744,21743,21742,21736,21722,21721,21720,21719,21718,21717,21699,21663,21656,21639,21520,21505,21503,21499,21478,21477,21472,21455,21454,21453,21450,21408,21404,21402,21386,21385,21384,21340,21337,21336,21330,21316,21315,21314,21309,21305,21302,21295,21293,21291,21207,21205,21196,21195,21183,21180,21179,21178,21171,21168,21166,21164,21108,21102,21059,21050,21049,21026,21024,20878,20872,20795,20684,20683,20563,20502,19827,19826,19825,19823,19806,19802,19801,19800,19799,19796,19795,19792,19789,19788,19784,19769,19768,19767,19765,19762,19759,21080,19757,19756,19755,19754,19740,19532,19530,19528,19526,19521,19520,19518,19517,19504,19395,19394,19384,19375,19374,19373,19372,19371,19370,19369,19368,19362,19355,19353,19352,19351,18696,18695,18694,17008,16781));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435712 WHERE (`DifficultyID`=0 AND `Entry` IN (21711,21709,21506,21416));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`DifficultyID`=0 AND `Entry` IN (23188,22417,22395,22146,22139,21879,21807,21657,21512,21417,21403,21347,21334,21211,21210,20289,20288,20286,19382,17066));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306624 WHERE (`DifficultyID`=0 AND `Entry` IN (23209,22083,22061));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368 WHERE (`DifficultyID`=0 AND `Entry` IN (23164,22274,22073,22006,21648,21348,21292,21029,21027));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=256 WHERE (`DifficultyID`=0 AND `Entry` IN (21727,21725,21710,19760));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`DifficultyID`=0 AND `Entry` IN (113941,23496,23308,22315,22080,22079,22078,22071,22070,22066,22054,22001,21996,21993,21924,21705,21704,21703,21420,21096,21095,21094,21092,21041,20076,19388,19387,18528,2630,2615,2614));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912 WHERE (`Entry` IN (23124,23472,23033,22517,22515));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`Entry` IN (23499,22897,22894));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306624 WHERE (`Entry` IN (23410,23369));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0 WHERE (`Entry` IN (23095,23084));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368 WHERE (`Entry` IN (23330,23030,22886));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456 WHERE (`Entry` IN (22876,123252,23524,23523,23469,23436,23421,23411,23403,23402,23401,23400,23399,23397,23394,23374,23371,23339,23337,23319,23318,23239,23237,23236,23235,23232,23226,23223,23222,23216,23215,23197,23196,23172,23159,23158,23147,23083,23049,23047,23028,23018,22965,22964,22963,22962,22960,22959,22957,22956,22955,22954,22953,22952,22951,22949,22948,22947,22946,22945,22939,22898,22887,22885,22884,22883,22882,22881,22880,22879,22878,22877,22875,22874,22873,22871,22869,22855,22853,22849,22848,22847,22846,22845,22844));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=537919744 WHERE (`Entry` IN (23417));
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168 WHERE (`Entry` IN (23502,23448,23412,23351,23336,23288,23259,23210,23080,22996,22896,22856));