diff options
| -rw-r--r-- | sql/updates/world/master/2024_04_20_00_world.sql | 311 |
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)); |