[CREATURE] Difficulty entry stats update

Kaelima · March 29, 2011, 12:37am

This SQL has been used before, we should run it again.

UPDATE `creature_template` AS `c1`,`creature_template` AS `c2` SET
`c2`.`unit_class`=`c1`.`unit_class`,
`c2`.`unit_flags`=`c1`.`unit_flags`,
`c2`.`exp`=`c1`.`exp`,
`c2`.`npcflag`=`c1`.`npcflag`,
`c2`.`faction_A`=`c1`.`faction_A`,
`c2`.`faction_H`=`c1`.`faction_H`,
`c2`.`speed_walk`=`c1`.`speed_walk`,
`c2`.`speed_run`=`c1`.`speed_run`,
`c2`.`scale`=`c1`.`scale`,
`c2`.`InhabitType`=`c1`.`InhabitType`,
`c2`.`MovementType`=`c1`.`MovementType`,
`c2`.`equipment_id`=`c1`.`equipment_id`,
`c2`.`flags_extra`=`c1`.`flags_extra` 
WHERE `c2`.`entry`=`c1`.`difficulty_entry_1` OR `c2`.`entry`=`c1`.`difficulty_entry_2` OR `c2`.`entry`=`c1`.`difficulty_entry_3`;
[/SQL]



[SQL]
UPDATE `creature_template` AS `ct`,`creature` AS `c` SET `ct`.`equipment_id`=`c`.`equipment_id` 
WHERE `ct`.`entry`=`c`.`id`
AND `ct`.`equipment_id`<>`c`.`equipment_id`
AND `c`.`equipment_id`>0
AND `ct`.`equipment_id`<>0;

UPDATE `creature_template` AS `ct`,`creature` AS `c` SET `c`.`equipment_id`=0 
WHERE `ct`.`entry`=`c`.`id`
AND `ct`.`equipment_id`=`c`.`equipment_id`
AND `ct`.`equipment_id`<>0;
[/SQL]
Above is somewhat messy, the point is to remove duplicates equipment_id in creature

I'm sleepy and have probably messed up somewhere /emoticons/default_tongue.png

Nay · April 10, 2011, 1:52pm

First query is equivalent to:

[CODE]
UPDATE creature_template SET equipment_id=997 WHERE entry=18434; – Vazruden (1)
UPDATE creature_template SET InhabitType=7, flags_extra=128 WHERE entry=18602; – Broggok Poison Cloud (1)
UPDATE creature_template SET equipment_id=18 WHERE entry=18604; – Felguard Annihilator (1)
UPDATE creature_template SET equipment_id=248 WHERE entry=18607; – Keli’dan the Breaker (1)
UPDATE creature_template SET equipment_id=476 WHERE entry=18609; – Laughing Skull Legionnaire (1)
UPDATE creature_template SET equipment_id=1492 WHERE entry=18610; – Laughing Skull Rogue (1)
UPDATE creature_template SET equipment_id=1489 WHERE entry=18611; – Laughing Skull Warden (1)
UPDATE creature_template SET equipment_id=1490 WHERE entry=18612; – Nascent Fel Orc (1)
UPDATE creature_template SET equipment_id=29 WHERE entry=18618; – Shadowmoon Technician (1)
UPDATE creature_template SET equipment_id=1500 WHERE entry=19885; – Coilfang Champion (1)
UPDATE creature_template SET equipment_id=1501 WHERE entry=19886; – Coilfang Defender (1)
UPDATE creature_template SET equipment_id=71 WHERE entry=19887; – Coilfang Enchantress (1)
UPDATE creature_template SET equipment_id=283 WHERE entry=19888; – Coilfang Observer (1)
UPDATE creature_template SET equipment_id=730 WHERE entry=19889; – Coilfang Slavehandler (1)
UPDATE creature_template SET equipment_id=464 WHERE entry=19890; – Coilfang Soothsayer (1)
UPDATE creature_template SET equipment_id=29 WHERE entry=19891; – Coilfang Technician (1)
UPDATE creature_template SET equipment_id=1241 WHERE entry=19893; – Mennu the Betrayer (1)
UPDATE creature_template SET equipment_id=53 WHERE entry=19901; – Wastewalker Captive (1)
UPDATE creature_template SET equipment_id=53 WHERE entry=19902; – Wastewalker Slave (1)
UPDATE creature_template SET equipment_id=312 WHERE entry=19903; – Coilfang Collaborator (1)
UPDATE creature_template SET equipment_id=53 WHERE entry=19904; – Wastewalker Worker (1)
UPDATE creature_template SET equipment_id=1 WHERE entry=20177; – Murkblood Healer (1)
UPDATE creature_template SET equipment_id=9 WHERE entry=20179; – Murkblood Oracle (1)
UPDATE creature_template SET equipment_id=1494 WHERE entry=20180; – Murkblood Spearman (1)
UPDATE creature_template SET equipment_id=1493 WHERE entry=20181; – Murkblood Tribesman (1)
UPDATE creature_template SET equipment_id=1499 WHERE entry=20183; – Swamplord Musel’ek (1)
UPDATE creature_template SET equipment_id=730 WHERE entry=20191; – Wrathfin Myrmidon (1)
UPDATE creature_template SET equipment_id=11 WHERE entry=20192; – Wrathfin Sentry (1)
UPDATE creature_template SET equipment_id=1495 WHERE entry=20193; – Wrathfin Warrior (1)
UPDATE creature_template SET equipment_id=269 WHERE entry=20298; – Angered Skeleton (1)
UPDATE creature_template SET equipment_id=109 WHERE entry=20299; – Auchenai Monk (1)
UPDATE creature_template SET equipment_id=572 WHERE entry=20300; – Auchenai Necromancer (1)
UPDATE creature_template SET equipment_id=578 WHERE entry=20301; – Auchenai Soulpriest (1)
UPDATE creature_template SET equipment_id=1529 WHERE entry=20302; – Auchenai Vindicator (1)
UPDATE creature_template SET equipment_id=319 WHERE entry=20303; – Avatar of the Martyred (1)
UPDATE creature_template SET equipment_id=1522 WHERE entry=20306; – Exarch Maladaar (1)
UPDATE creature_template SET equipment_id=235 WHERE entry=20310; – Phasing Cleric (1)
UPDATE creature_template SET equipment_id=1530 WHERE entry=20311; – Phasing Soldier (1)
UPDATE creature_template SET equipment_id=1531 WHERE entry=20313; – Phasing Stalker (1)
UPDATE creature_template SET equipment_id=50 WHERE entry=20315; – Raging Skeleton (1)
UPDATE creature_template SET equipment_id=235 WHERE entry=20320; – Unliving Cleric (1)
UPDATE creature_template SET equipment_id=1530 WHERE entry=20321; – Unliving Soldier (1)
UPDATE creature_template SET equipment_id=1531 WHERE entry=20323; – Unliving Stalker (1)
UPDATE creature_template SET equipment_id=1401 WHERE entry=20536; – Lodaeron Sentry Specimen (1)
UPDATE creature_template SET equipment_id=1402 WHERE entry=20539; – Lordaeron Watchman Specimen (1)
UPDATE creature_template SET flags_extra=257 WHERE entry=20596; – Warbringer O’mrogg (1)
UPDATE creature_template SET equipment_id=2 WHERE entry=20620; – Coilfang Engineer (1)
UPDATE creature_template SET equipment_id=1497 WHERE entry=20621; – Coilfang Myrmidon (1)
UPDATE creature_template SET equipment_id=35 WHERE entry=20622; – Coilfang Oracle (1)
UPDATE creature_template SET equipment_id=19 WHERE entry=20623; – Coilfang Siren (1)
UPDATE creature_template SET equipment_id=35 WHERE entry=20624; – Coilfang Slavemaster (1)
UPDATE creature_template SET equipment_id=265 WHERE entry=20625; – Coilfang Sorceress (1)
UPDATE creature_template SET equipment_id=1498 WHERE entry=20626; – Coilfang Warrior (1)
UPDATE creature_template SET equipment_id=53 WHERE entry=20628; – Dreghood Slave (1)
UPDATE creature_template SET equipment_id=19 WHERE entry=20629; – Hydromancer Thespia (1)
UPDATE creature_template SET equipment_id=1454 WHERE entry=20632; – Steamrigger Mechanic (1)
UPDATE creature_template SET equipment_id=1496 WHERE entry=20633; – Warlord Kalithresh (1)
UPDATE creature_template SET equipment_id=1544 WHERE entry=20645; – Cabal Ritualist (1)
UPDATE creature_template SET InhabitType=7, flags_extra=130 WHERE entry=20654; – Invisible Target (1)
UPDATE creature_template SET equipment_id=96 WHERE entry=20660; – Summoned Cabal Acolyte (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=20665; – Voidwalker Summoner (1)
UPDATE creature_template SET equipment_id=99 WHERE entry=20691; – Time-Lost Controller (1)
UPDATE creature_template SET equipment_id=1449 WHERE entry=20692; – Sethekk Guard (1)
UPDATE creature_template SET equipment_id=1516 WHERE entry=20693; – Sethekk Initiate (1)
UPDATE creature_template SET equipment_id=96 WHERE entry=20694; – Sethekk Oracle (1)
UPDATE creature_template SET equipment_id=1237 WHERE entry=20695; – Sethekk Prophet (1)
UPDATE creature_template SET equipment_id=1270 WHERE entry=20696; – Sethekk Ravenguard (1)
UPDATE creature_template SET equipment_id=94 WHERE entry=20697; – Time-Lost Scryer (1)
UPDATE creature_template SET equipment_id=1319 WHERE entry=20698; – Time-Lost Shadowmage (1)
UPDATE creature_template SET equipment_id=1518 WHERE entry=20699; – Sethekk Shaman (1)
UPDATE creature_template SET equipment_id=1517 WHERE entry=20701; – Sethekk Talon Lord (1)
UPDATE creature_template SET equipment_id=1370 WHERE entry=20706; – Talon King Ikiss (1)
UPDATE creature_template SET flags_extra=257 WHERE entry=20745; – Temporus (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=21620; – Unbound Void Zone (1)
UPDATE creature_template SET InhabitType=7, flags_extra=130 WHERE entry=21625; – Wrath-Scryer’s Felfire (1)
UPDATE creature_template SET equipment_id=18 WHERE entry=21645; – Felguard Brute (1)
UPDATE creature_template SET equipment_id=19 WHERE entry=21842; – Coilfang Scale-Healer (1)
UPDATE creature_template SET equipment_id=1567 WHERE entry=21843; – Coilfang Tempest (1)
UPDATE creature_template SET equipment_id=936 WHERE entry=21915; – Coilfang Leper (1)
UPDATE creature_template SET equipment_id=2187 WHERE entry=22542; – Dun Baldar North Marshal (1)
UPDATE creature_template SET equipment_id=2188 WHERE entry=22543; – Dun Baldar North Warmaster (1)
UPDATE creature_template SET equipment_id=2187 WHERE entry=22544; – Dun Baldar South Marshal (1)
UPDATE creature_template SET equipment_id=2188 WHERE entry=22548; – East Frostwolf Warmaster (1)
UPDATE creature_template SET equipment_id=2011 WHERE entry=22557; – Herald (1)
UPDATE creature_template SET equipment_id=2188 WHERE entry=22560; – Iceblood Warmaster (1)
UPDATE creature_template SET equipment_id=2187 WHERE entry=22561; – Icewing Marshal (1)
UPDATE creature_template SET equipment_id=2172 WHERE entry=22568; – Primalist Thurloga (1)
UPDATE creature_template SET equipment_id=1417 WHERE entry=22569; – Ravak Grimtotem (1)
UPDATE creature_template SET equipment_id=2 WHERE entry=22571; – Smith Regzar (1)
UPDATE creature_template SET equipment_id=2011 WHERE entry=22574; – Stormpike Herald (1)
UPDATE creature_template SET equipment_id=2188 WHERE entry=22580; – Tower Point Warmaster (1)
UPDATE creature_template SET equipment_id=629 WHERE entry=22581; – Trigger Guse (1)
UPDATE creature_template SET equipment_id=629 WHERE entry=22582; – Trigger Ichman (1)
UPDATE creature_template SET equipment_id=629 WHERE entry=22583; – Trigger Jeztor (1)
UPDATE creature_template SET equipment_id=629 WHERE entry=22584; – Trigger Mulverick (1)
UPDATE creature_template SET equipment_id=629 WHERE entry=22585; – Trigger Slidore (1)
UPDATE creature_template SET equipment_id=629 WHERE entry=22586; – Trigger Vipore (1)
UPDATE creature_template SET equipment_id=2187 WHERE entry=22595; – West Frostwolf Marshal (1)
UPDATE creature_template SET equipment_id=2188 WHERE entry=22596; – West Frostwolf Warmaster (1)
UPDATE creature_template SET equipment_id=1552 WHERE entry=22606; – Captain Galvangar (1)
UPDATE creature_template SET equipment_id=1770 WHERE entry=22613; – Commander Dardosh (1)
UPDATE creature_template SET equipment_id=2176 WHERE entry=22614; – Commander Duffy (1)
UPDATE creature_template SET equipment_id=2177 WHERE entry=22615; – Commander Karl Philips (1)
UPDATE creature_template SET equipment_id=2168 WHERE entry=22616; – Commander Louis Philips (1)
UPDATE creature_template SET equipment_id=2167 WHERE entry=22617; – Commander Malgor (1)
UPDATE creature_template SET equipment_id=1767 WHERE entry=22618; – Commander Mortimer (1)
UPDATE creature_template SET equipment_id=1769 WHERE entry=22619; – Commander Mulfort (1)
UPDATE creature_template SET equipment_id=1678 WHERE entry=22628; – Lieutenant Haggerdin (1)
UPDATE creature_template SET equipment_id=317 WHERE entry=22638; – Voggah Deathgrip (1)
UPDATE creature_template SET equipment_id=1342 WHERE entry=22640; – Warmaster Laggrond (1)
UPDATE creature_template SET equipment_id=10104 WHERE entry=22641; – Drek’Thar (1)
UPDATE creature_template SET faction_A=14, faction_H=14 WHERE entry=22643; – Korrak the Bloodrager (1)
UPDATE creature_template SET equipment_id=10103 WHERE entry=22644; – Vanndar Stormpike (1)
UPDATE creature_template SET equipment_id=2158 WHERE entry=22648; – Frostwolf Quartermaster (1)
UPDATE creature_template SET equipment_id=2127 WHERE entry=22650; – Grelkor (1)
UPDATE creature_template SET equipment_id=308 WHERE entry=22652; – Kurdrum Barleybeard (1)
UPDATE creature_template SET equipment_id=7 WHERE entry=22654; – Rarck (1)
UPDATE creature_template SET equipment_id=238 WHERE entry=22655; – Shrye Ragefist (1)
UPDATE creature_template SET unit_flags=256 WHERE entry=22656; – Stormpike Emissary (1)
UPDATE creature_template SET equipment_id=475 WHERE entry=22657; – Stormpike Mountaineer (1)
UPDATE creature_template SET equipment_id=53 WHERE entry=22659; – Svalbrad Farmountain (1)
UPDATE creature_template SET equipment_id=413 WHERE entry=22660; – Yaelika Farclaw (1)
UPDATE creature_template SET equipment_id=53 WHERE entry=22661; – Zora Guthrek (1)
UPDATE creature_template SET equipment_id=2173 WHERE entry=22678; – Frostwolf Shaman (1)
UPDATE creature_template SET equipment_id=16 WHERE entry=22681; – Grunnda Wolfheart (1)
UPDATE creature_template SET equipment_id=2171 WHERE entry=22682; – Jekyll Flandring (1)
UPDATE creature_template SET equipment_id=19 WHERE entry=22685; – Morloch (1)
UPDATE creature_template SET equipment_id=454 WHERE entry=22695; – Thanthaldis Snowgleam (1)
UPDATE creature_template SET equipment_id=2161 WHERE entry=22696; – Umi Thorson (1)
UPDATE creature_template SET equipment_id=2170 WHERE entry=22697; – Wing Commander Jeztor (1)
UPDATE creature_template SET equipment_id=1774 WHERE entry=22700; – Lieutenant Greywand (1)
UPDATE creature_template SET equipment_id=2165 WHERE entry=22701; – Lieutenant Grummus (1)
UPDATE creature_template SET equipment_id=2174 WHERE entry=22702; – Lieutenant Largent (1)
UPDATE creature_template SET equipment_id=2166 WHERE entry=22703; – Lieutenant Lewis (1)
UPDATE creature_template SET equipment_id=2175 WHERE entry=22704; – Lieutenant Lonadin (1)
UPDATE creature_template SET equipment_id=1772 WHERE entry=22706; – Lieutenant Murp (1)
UPDATE creature_template SET equipment_id=2162 WHERE entry=22707; – Lieutenant Rugba (1)
UPDATE creature_template SET equipment_id=2163 WHERE entry=22708; – Lieutenant Spencer (1)
UPDATE creature_template SET equipment_id=1771 WHERE entry=22710; – Lieutenant Stronghoof (1)
UPDATE creature_template SET equipment_id=2164 WHERE entry=22711; – Lieutenant Vol’talar (1)
UPDATE creature_template SET equipment_id=614 WHERE entry=22712; – Najak Hexxen (1)
UPDATE creature_template SET equipment_id=2169 WHERE entry=22721; – Wing Commander Guse (1)
UPDATE creature_template SET equipment_id=2178 WHERE entry=22722; – Wing Commander Vipore (1)
UPDATE creature_template SET equipment_id=2182 WHERE entry=22723; – Jotek (1)
UPDATE creature_template SET equipment_id=34 WHERE entry=22724; – Mountaineer Boombellow (1)
UPDATE creature_template SET equipment_id=1305 WHERE entry=22730; – Coldmine Guard (1)
UPDATE creature_template SET equipment_id=53 WHERE entry=22733; – Coldmine Peon (1)
UPDATE creature_template SET equipment_id=94 WHERE entry=22734; – Coldmine Surveyor (1)
UPDATE creature_template SET equipment_id=244 WHERE entry=22736; – Corporal Teeka Bloodsnarl (1)
UPDATE creature_template SET equipment_id=18 WHERE entry=22743; – Irondeep Guard (1)
UPDATE creature_template SET equipment_id=53 WHERE entry=22744; – Irondeep Miner (1)
UPDATE creature_template SET equipment_id=135 WHERE entry=22747; – Irondeep Shaman (1)
UPDATE creature_template SET equipment_id=354 WHERE entry=22748; – Irondeep Skullthumper (1)
UPDATE creature_template SET equipment_id=146 WHERE entry=22749; – Irondeep Surveyor (1)
UPDATE creature_template SET equipment_id=36 WHERE entry=22750; – Irondeep Trogg (1)
UPDATE creature_template SET equipment_id=2009 WHERE entry=22759; – Sergeant Durgen Stormpike (1)
UPDATE creature_template SET equipment_id=2179 WHERE entry=22760; – Sergeant Yazra Bloodsnarl (1)
UPDATE creature_template SET equipment_id=38 WHERE entry=22782; – Whitewhisker Vermin (1)
UPDATE creature_template SET equipment_id=2155 WHERE entry=22783; – Wildpaw Alpha (1)
UPDATE creature_template SET equipment_id=819 WHERE entry=22784; – Wildpaw Brute (1)
UPDATE creature_template SET equipment_id=33 WHERE entry=22785; – Wildpaw Gnoll (1)
UPDATE creature_template SET equipment_id=109 WHERE entry=22786; – Wildpaw Mystic (1)
UPDATE creature_template SET equipment_id=9 WHERE entry=22787; – Wildpaw Shaman (1)
UPDATE creature_template SET equipment_id=18 WHERE entry=23185; – Tarren Mill Protector (1)
UPDATE creature_template SET equipment_id=0 WHERE entry=23186; – Tarren Mill Protector (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=25543; – Arcane Sphere (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=25546; – Broken Sentinel (1)
UPDATE creature_template SET equipment_id=2077 WHERE entry=25548; – Dawnblade Summoner (1)
UPDATE creature_template SET equipment_id=288 WHERE entry=25567; – Sunblade Keeper (1)
UPDATE creature_template SET equipment_id=1416 WHERE entry=28171; – Don Carlos (1)
UPDATE creature_template SET equipment_id=1716 WHERE entry=29247; – Naxxramas Cultist (1)
UPDATE creature_template SET equipment_id=1717 WHERE entry=29248; – Naxxramas Acolyte (1)
UPDATE creature_template SET equipment_id=1627 WHERE entry=29268; – Grand Widow Faerlina (1)
UPDATE creature_template SET equipment_id=1815 WHERE entry=29273; – Naxxramas Follower (1)
UPDATE creature_template SET equipment_id=1727 WHERE entry=29274; – Naxxramas Worshipper (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=29446; – Stalagg (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=29447; – Feugen (1)
UPDATE creature_template SET equipment_id=467 WHERE entry=29632; – Plagued Warrior (1)
UPDATE creature_template SET equipment_id=160 WHERE entry=29633; – Plagued Champion (1)
UPDATE creature_template SET equipment_id=188 WHERE entry=29634; – Plagued Guardian (1)
UPDATE creature_template SET equipment_id=271 WHERE entry=29701; – Heigan the Unclean (1)
UPDATE creature_template SET equipment_id=1029 WHERE entry=29823; – Death Knight (1)
UPDATE creature_template SET equipment_id=1026 WHERE entry=29824; – Death Knight Captain (1)
UPDATE creature_template SET equipment_id=1724 WHERE entry=29828; – Necro Knight (1)
UPDATE creature_template SET equipment_id=106 WHERE entry=29831; – Risen Squire (1)
UPDATE creature_template SET equipment_id=1722 WHERE entry=29833; – Dark Touched Warrior (1)
UPDATE creature_template SET equipment_id=2199 WHERE entry=29835; – Bony Construct (1)
UPDATE creature_template SET equipment_id=498 WHERE entry=29837; – Skeletal Smith (1)
UPDATE creature_template SET equipment_id=1723 WHERE entry=29842; – Death Knight Cavalier (1)
UPDATE creature_template SET equipment_id=1725 WHERE entry=29898; – Unholy Axe (1)
UPDATE creature_template SET equipment_id=1003 WHERE entry=29899; – Unholy Staff (1)
UPDATE creature_template SET equipment_id=1726 WHERE entry=29900; – Unholy Swords (1)
UPDATE creature_template SET equipment_id=1763 WHERE entry=29955; – Gothik the Harvester (1)
UPDATE creature_template SET equipment_id=1813 WHERE entry=29985; – Unrelenting Death Knight (1)
UPDATE creature_template SET equipment_id=1763 WHERE entry=29986; – Unrelenting Rider (1)
UPDATE creature_template SET equipment_id=1812 WHERE entry=29987; – Unrelenting Trainee (1)
UPDATE creature_template SET equipment_id=1763 WHERE entry=29988; – Spectral Rider (1)
UPDATE creature_template SET equipment_id=1813 WHERE entry=29990; – Spectral Death Knight (1)
UPDATE creature_template SET speed_run=2.8, equipment_id=1821 WHERE entry=30397; – Commander Kolurg (1)
UPDATE creature_template SET speed_walk=1.125, speed_run=3.15 WHERE entry=30457; – Azure Magus (1)
UPDATE creature_template SET speed_walk=1.125, speed_run=3.15 WHERE entry=30459; – Azure Warder (1)
UPDATE creature_template SET speed_run=2.8 WHERE entry=30460; – Mage Hunter Ascendant (1)
UPDATE creature_template SET speed_walk=1.5, speed_run=4.2 WHERE entry=30473; – Mage Slayer (1)
UPDATE creature_template SET speed_run=2.8, equipment_id=1822 WHERE entry=30495; – Horde Berserker (1)
UPDATE creature_template SET speed_run=2.8, equipment_id=1824 WHERE entry=30497; – Horde Cleric (1)
UPDATE creature_template SET speed_run=2.8, equipment_id=1823 WHERE entry=30508; – Horde Ranger (1)
UPDATE creature_template SET speed_run=2.8 WHERE entry=30510; – Grand Magus Telestra (1)
UPDATE creature_template SET speed_run=2.8WHERE entry=30540; – Keristrasza (1)
UPDATE creature_template SET equipment_id=1763 WHERE entry=30600; – Baron Rivendare (1)
UPDATE creature_template SET equipment_id=1721 WHERE entry=30601; – Lady Blaumeux (1)
UPDATE creature_template SET equipment_id=1719 WHERE entry=30602; – Sir Zeliek (1)
UPDATE creature_template SET equipment_id=1720 WHERE entry=30603; – Thane Korth’azz (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=30758; – Black Dragon Smoke Image (1)
UPDATE creature_template SET equipment_id=9 WHERE entry=30759; – Bladespire Elder (1)
UPDATE creature_template SET equipment_id=2324 WHERE entry=30760; – Bladespire Guardian (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=30768; – Ethereal Smoke Image (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=30769; – Felguard Smoke Image (1)
UPDATE creature_template SET InhabitType=7, flags_extra=128 WHERE entry=30771; – Flame Brazier (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=30776; – Gronn Smoke Image (1)
UPDATE creature_template SET flags_extra=130 WHERE entry=30777; – Harpoon Loot Sparkles (1)
UPDATE creature_template SET InhabitType=7, flags_extra=131 WHERE entry=30780; – King Bjorn (1)
UPDATE creature_template SET InhabitType=7, flags_extra=131 WHERE entry=30782; – King Haldor (1)
UPDATE creature_template SET InhabitType=7, flags_extra=131 WHERE entry=30784; – King Ranulf (1)
UPDATE creature_template SET InhabitType=7, flags_extra=131 WHERE entry=30786; – King Tor (1)
UPDATE creature_template SET equipment_id=4 WHERE entry=30789; – Lakota Windsong (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=30792; – Mingo (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=30796; – Ogri’la Keg King (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=30800; – Ogri’la Storyteller (1)
UPDATE creature_template SET InhabitType=7, flags_extra=130 WHERE entry=30805; – Ritual Target (1)
UPDATE creature_template SET InhabitType=7, flags_extra=130 WHERE entry=27339; – Spirit Fount, Heroic version got proper values
UPDATE creature_template SET flags_extra=2 WHERE entry=30811; – Tork (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=30812; – Torki (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=30813; – Torkus Jr. (1)
UPDATE creature_template SET speed_run=0.99206 WHERE entry=30936; – Drakkari Rhino (1)
UPDATE creature_template SET equipment_id=1765 WHERE entry=30998; – Onyx Blaze Mistress (1)
UPDATE creature_template SET equipment_id=1764 WHERE entry=30999; – Onyx Brood General (1)
UPDATE creature_template SET equipment_id=1766 WHERE entry=31000; – Onyx Flight Captain (1)
UPDATE creature_template SET equipment_id=1762 WHERE entry=31001; – Onyx Sanctum Guardian (1)
UPDATE creature_template SET equipment_id=1552 WHERE entry=31055; – Captain Galvangar (2)
UPDATE creature_template SET flags_extra=64 WHERE entry=31183; – Skeletal Minion (1)
UPDATE creature_template SET unit_flags=64 WHERE entry=31339; – Drakkari Guardian (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=31445; – Ahn’kahar Guardian Egg (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=31446; – Ahn’kahar Swarm Egg (1)
UPDATE creature_template SET equipment_id=1751, flags_extra=0 WHERE entry=31536; – Volkhan (1)
UPDATE creature_template SET exp=2 WHERE entry=31539; – Twilight Egg (1)
UPDATE creature_template SET exp=2 WHERE entry=31540; – Twilight Whelp (1)
UPDATE creature_template SET flags_extra=64 WHERE entry=31585; – Animated Bones (1)
UPDATE creature_template SET flags_extra=64 WHERE entry=31635; – Vrykul Skeleton (1)
UPDATE creature_template SET InhabitType=5 WHERE entry=31748; – Hover Disk (1)
UPDATE creature_template SET faction_A=35, faction_H=35, InhabitType=5 WHERE entry=31749; – Hover Disk (1)
UPDATE creature_template SET InhabitType=5 WHERE entry=31752; – Wyrmrest Skytalon (1)
UPDATE creature_template SET equipment_id=10103 WHERE entry=31818; – Vanndar Stormpike (2)
UPDATE creature_template SET equipment_id=10104 WHERE entry=31819; – Drek’Thar (2)
UPDATE creature_template SET equipment_id=2178 WHERE entry=31823; – Wing Commander Vipore (2)
UPDATE creature_template SET equipment_id=2170 WHERE entry=31826; – Wing Commander Jeztor (2)
UPDATE creature_template SET equipment_id=2169 WHERE entry=31828; – Wing Commander Guse (2)
UPDATE creature_template SET equipment_id=2188 WHERE entry=31829; – West Frostwolf Warmaster (2)
UPDATE creature_template SET equipment_id=721 WHERE entry=31835; – Ingvar Throw Dummy (1)
UPDATE creature_template SET InhabitType=7, flags_extra=130 WHERE entry=31874; – Dark Matter (1)
UPDATE creature_template SET equipment_id=2188 WHERE entry=31909; – Tower Point Warmaster (2)
UPDATE creature_template SET equipment_id=1305 WHERE entry=31947; – Coldmine Guard (2)
UPDATE creature_template SET equipment_id=53 WHERE entry=31950; – Coldmine Peon (2)
UPDATE creature_template SET equipment_id=94 WHERE entry=31951; – Coldmine Surveyor (2)
UPDATE creature_template SET equipment_id=2187 WHERE entry=31966; – Dun Baldar North Marshal (2)
UPDATE creature_template SET equipment_id=2187 WHERE entry=31968; – Dun Baldar South Marshal (2)
UPDATE creature_template SET equipment_id=2188 WHERE entry=31972; – East Frostwolf Warmaster (2)
UPDATE creature_template SET equipment_id=2158 WHERE entry=31986; – Frostwolf Quartermaster (2)
UPDATE creature_template SET equipment_id=2173 WHERE entry=31989; – Frostwolf Shaman (2)
UPDATE creature_template SET equipment_id=2127 WHERE entry=31999; – Grelkor (2)
UPDATE creature_template SET equipment_id=16 WHERE entry=32001; – Grunnda Wolfheart (2)
UPDATE creature_template SET equipment_id=2188 WHERE entry=32007; – Iceblood Warmaster (2)
UPDATE creature_template SET equipment_id=2187 WHERE entry=32008; – Icewing Marshal (2)
UPDATE creature_template SET equipment_id=18 WHERE entry=32014; – Irondeep Guard (2)
UPDATE creature_template SET equipment_id=53 WHERE entry=32015; – Irondeep Miner (2)
UPDATE creature_template SET equipment_id=135 WHERE entry=32018; – Irondeep Shaman (2)
UPDATE creature_template SET equipment_id=354 WHERE entry=32019; – Irondeep Skullthumper (2)
UPDATE creature_template SET equipment_id=146 WHERE entry=32020; – Irondeep Surveyor (2)
UPDATE creature_template SET equipment_id=36 WHERE entry=32021; – Irondeep Trogg (2)
UPDATE creature_template SET equipment_id=2182 WHERE entry=32025; – Jotek (2)
UPDATE creature_template SET equipment_id=308 WHERE entry=32028; – Kurdrum Barleybeard (2)
UPDATE creature_template SET equipment_id=19 WHERE entry=32045; – Morloch (2)
UPDATE creature_template SET equipment_id=34 WHERE entry=32046; – Mountaineer Boombellow (2)
UPDATE creature_template SET equipment_id=614 WHERE entry=32049; – Najak Hexxen (2)
UPDATE creature_template SET equipment_id=2172 WHERE entry=32050; – Primalist Thurloga (2)
UPDATE creature_template SET equipment_id=7 WHERE entry=32052; – Rarck (2)
UPDATE creature_template SET equipment_id=1417 WHERE entry=32053; – Ravak Grimtotem (2)
UPDATE creature_template SET equipment_id=2179 WHERE entry=32077; – Sergeant Yazra Bloodsnarl (2)
UPDATE creature_template SET equipment_id=238 WHERE entry=32078; – Shrye Ragefist (2)
UPDATE creature_template SET equipment_id=2 WHERE entry=32080; – Smith Regzar (2)
UPDATE creature_template SET equipment_id=2011 WHERE entry=32095; – Stormpike Herald (2)
UPDATE creature_template SET equipment_id=53 WHERE entry=32106; – Svalbrad Farmountain (2)
UPDATE creature_template SET equipment_id=2161 WHERE entry=32119; – Umi Thorson (2)
UPDATE creature_template SET equipment_id=38 WHERE entry=32143; – Whitewhisker Vermin (2)
UPDATE creature_template SET equipment_id=2155 WHERE entry=32144; – Wildpaw Alpha (2)
UPDATE creature_template SET equipment_id=819 WHERE entry=32145; – Wildpaw Brute (2)
UPDATE creature_template SET equipment_id=33 WHERE entry=32146; – Wildpaw Gnoll (2)
UPDATE creature_template SET equipment_id=109 WHERE entry=32147; – Wildpaw Mystic (2)
UPDATE creature_template SET equipment_id=9 WHERE entry=32148; – Wildpaw Shaman (2)
UPDATE creature_template SET equipment_id=53 WHERE entry=32764; – Zora Guthrek (2)
UPDATE creature_template SET equipment_id=413 WHERE entry=32765; – Yaelika Farclaw (2)
UPDATE creature_template SET equipment_id=1843 WHERE entry=32846; – Hodir (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=33070; – Algalon the Observer (1)
UPDATE creature_template SET equipment_id=1844 WHERE entry=33147; – Thorim (1)
UPDATE creature_template SET equipment_id=1852 WHERE entry=33150; – Captured Mercenary Captain (1)
UPDATE creature_template SET equipment_id=1847 WHERE entry=33152; – Captured Mercenary Soldier (1)
UPDATE creature_template SET equipment_id=1846 WHERE entry=33155; – Dark Rune Warbringer (1)
UPDATE creature_template SET equipment_id=1003 WHERE entry=33156; – Dark Rune Evoker (1)
UPDATE creature_template SET equipment_id=849 WHERE entry=33158; – Dark Rune Champion (1)
UPDATE creature_template SET equipment_id=627 WHERE entry=33162; – Iron Ring Guard (1)
UPDATE creature_template SET equipment_id=1845 WHERE entry=33163; – Iron Honor Guard (1)
UPDATE creature_template SET equipment_id=1845 WHERE entry=33164; – Iron Honor Guard (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=33191; – Iron Construct (1)
UPDATE creature_template SET equipment_id=850 WHERE entry=33234; – Sif (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=33391; – Elder Brightleaf (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=33392; – Elder Ironbranch (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=33393; – Elder Stonebark (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=33449; – General Vezax (1)
UPDATE creature_template SET equipment_id=1855 WHERE entry=33737; – Misguided Nymph (1)
UPDATE creature_template SET equipment_id=870 WHERE entry=33757; – Dark Rune Thunderer (1)
UPDATE creature_template SET equipment_id=1862 WHERE entry=33758; – Dark Rune Ravager (1)
UPDATE creature_template SET speed_run=0.785714, InhabitType=7, flags_extra=128 WHERE entry=33906; – Focused Eyebeam (1)
UPDATE creature_template SET speed_run=0.785714, InhabitType=7, flags_extra=128 WHERE entry=33907; – Focused Eyebeam Right (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=33909; – Kologarn (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=33955; – Yogg-Saron (1)
UPDATE creature_template SET speed_walk=1.2, speed_run=0.71429 WHERE entry=34003; – Flame Leviathan (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=34106; – Leviathan Mk II (1)
UPDATE creature_template SET equipment_id=1854 WHERE entry=34112; – Titanium Stormlord (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=34166; – Sanctum Sentry (1)
UPDATE creature_template SET flags_extra=2 WHERE entry=34254; – Expedition Commander (1)
UPDATE creature_template SET equipment_id=1016 WHERE entry=34255; – Expedition Defender (1)
UPDATE creature_template SET equipment_id=361, flags_extra=2 WHERE entry=34256; – Expedition Engineer (1)
UPDATE creature_template SET equipment_id=1762, flags_extra=2 WHERE entry=34257; – Expedition Trapper (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=34332; – Sara (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=34442; – Vivienne Blackwhisper (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=34443; – Vivienne Blackwhisper (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35438; – Gormok the Impaler (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35439; – Gormok the Impaler (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35440; – Gormok the Impaler (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35511; – Acidmaw (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35512; – Acidmaw (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35513; – Acidmaw (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35514; – Dreadscale (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35515; – Dreadscale (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35516; – Dreadscale (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35662; – Alyssia Moonstalker (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35663; – Alyssia Moonstalker (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35664; – Alyssia Moonstalker (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35665; – Anthar Forgemender (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35666; – Anthar Forgemender (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35667; – Anthar Forgemender (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35668; – Baelnor Lightbearer (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35669; – Baelnor Lightbearer (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35670; – Baelnor Lightbearer (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35671; – Birana Stormhoof (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35672; – Birana Stormhoof (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35673; – Birana Stormhoof (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35674; – Brienna Nightfell (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35675; – Brienna Nightfell (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35676; – Brienna Nightfell (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35680; – Broln Stouthorn (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35681; – Broln Stouthorn (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35682; – Broln Stouthorn (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35683; – Caiphus the Stern (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35684; – Caiphus the Stern (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35685; – Caiphus the Stern (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35686; – Erin Misthoof (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35687; – Erin Misthoof (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35688; – Erin Misthoof (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35689; – Ginselle Blightslinger (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35690; – Ginselle Blightslinger (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35691; – Ginselle Blightslinger (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35692; – Gorgrim Shadowcleave (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35693; – Gorgrim Shadowcleave (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35694; – Gorgrim Shadowcleave (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35695; – Harkzog (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35696; – Harkzog (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35697; – Harkzog (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35699; – Irieth Shadowstep (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35700; – Irieth Shadowstep (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35701; – Irieth Shadowstep (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35702; – Kavina Grovesong (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35703; – Kavina Grovesong (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35704; – Kavina Grovesong (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35705; – Liandra Suncaller (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35706; – Liandra Suncaller (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35707; – Liandra Suncaller (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35708; – Malithas Brightblade (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35709; – Malithas Brightblade (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35710; – Malithas Brightblade (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35711; – Maz’dinah (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35712; – Maz’dinah (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35713; – Maz’dinah (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35714; – Melador Valestrider (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35715; – Melador Valestrider (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35716; – Melador Valestrider (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35718; – Narrhok Steelbreaker (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35719; – Narrhok Steelbreaker (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35720; – Narrhok Steelbreaker (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35721; – Noozle Whizzlestick (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35722; – Noozle Whizzlestick (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35723; – Noozle Whizzlestick (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35724; – Ruj’kah (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35725; – Ruj’kah (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35726; – Ruj’kah (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35728; – Saamul (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35729; – Saamul (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35730; – Saamul (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35731; – Serissa Grimdabbler (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35732; – Serissa Grimdabbler (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35733; – Serissa Grimdabbler (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35734; – Shaabad (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35735; – Shaabad (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35736; – Shaabad (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35737; – Shocuul (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35738; – Shocuul (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35739; – Shocuul (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35740; – Thrakgar (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35741; – Thrakgar (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35742; – Thrakgar (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35743; – Tyrius Duskblade (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35744; – Tyrius Duskblade (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35745; – Tyrius Duskblade (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35746; – Velanaa (1)
UPDATE creature_template SET flags_extra=1 WHERE entry=35747; – Velanaa (2)
UPDATE creature_template SET flags_extra=1 WHERE entry=35748; – Velanaa (3)
UPDATE creature_template SET flags_extra=1 WHERE entry=35749; – Vivienne Blackwhisper (3)
UPDATE creature_template SET rank=1 WHERE entry=36083; – Colosos (1)
UPDATE creature_template SET rank=1 WHERE entry=36084; – Deathstalker Visceri (1)
UPDATE creature_template SET rank=1 WHERE entry=36085; – Eressea Dawnsinger (1)
UPDATE creature_template SET rank=1 WHERE entry=36087; – Lana Stouthammer (1)
UPDATE creature_template SET rank=1 WHERE entry=36088; – Marshal Jacob Alerius (1)
UPDATE creature_template SET rank=1 WHERE entry=36089; – Mokra the Skullcrusher (1)
UPDATE creature_template SET rank=1 WHERE entry=36090; – Runok Wildmane (1)
UPDATE creature_template SET equipment_id=10046 WHERE entry=36498; – Bronjahm (1)
UPDATE creature_template SET speed_walk=0.888888, speed_run=1.5873 WHERE entry=37504; – Festergut (1)
UPDATE creature_template SET speed_walk=0.888888, speed_run=1.5873 WHERE entry=37505; – Festergut (2)
UPDATE creature_template SET speed_walk=0.888888, speed_run=1.5873 WHERE entry=37506; – Festergut (3)
UPDATE creature_template SET faction_A=1771, faction_H=1771 WHERE entry=37549; – Lumbering Abomination (1)
UPDATE creature_template SET faction_A=1771, faction_H=1771, speed_walk=2, speed_run=1.42857 WHERE entry=37550; – Raging Ghoul (1)
UPDATE creature_template SET faction_A=1771, faction_H=1771, speed_walk=2, speed_run=1.42857 WHERE entry=37551; – Risen Witch Doctor (1)
UPDATE creature_template SET speed_walk=1.11111 WHERE entry=37563; – Spectral Warden (1)
UPDATE creature_template SET equipment_id=10055 WHERE entry=37566; – Soulguard Adept (1)
UPDATE creature_template SET equipment_id=10086 WHERE entry=37567; – Soulguard Animator (1)
UPDATE creature_template SET equipment_id=10051 WHERE entry=37568; – Soulguard Reaper (1)
UPDATE creature_template SET equipment_id=10087 WHERE entry=37569; – Soulguard Watchman (1)
UPDATE creature_template SET faction_A=534, faction_H=534, unit_flags=32832, equipment_id=10137 WHERE entry=37604; – Coliseum Champion (1)
UPDATE creature_template SET equipment_id=254 WHERE entry=37607; – Gorkun Ironskull (1)
UPDATE creature_template SET equipment_id=10034 WHERE entry=37608; – Dark Ranger Kalira (1)
UPDATE creature_template SET equipment_id=10085 WHERE entry=37609; – Deathwhisper Necrolyte (1)
UPDATE creature_template SET equipment_id=10048 WHERE entry=37612; – Fallen Warrior (1)
UPDATE creature_template SET speed_run=1.42857, equipment_id=10045 WHERE entry=37613; – Forgemaster Garfrost (1)
UPDATE creature_template SET equipment_id=254 WHERE entry=37618; – Gorkun Ironskull (1)
UPDATE creature_template SET speed_walk=2, speed_run=1.42857 WHERE entry=37622; – Geist Ambusher (1)
UPDATE creature_template SET equipment_id=10042 WHERE entry=37623; – Coliseum Champion (1)
UPDATE creature_template SET equipment_id=10043 WHERE entry=37624; – Coliseum Champion (1)
UPDATE creature_template SET equipment_id=10041 WHERE entry=37625; – Coliseum Champion (1)
UPDATE creature_template SET speed_walk=1.44444, speed_run=1.5873 WHERE entry=37626; – Iceborn Proto-Drake (1)
UPDATE creature_template SET speed_run=1.28968 WHERE entry=37627; – Ick (1)
UPDATE creature_template SET equipment_id=637, flags_extra=2 WHERE entry=37628; – Archmage Koreln (1)
UPDATE creature_template SET speed_run=1.28968 WHERE entry=37635; – Plagueborn Horror (1)
UPDATE creature_template SET speed_run=0.99206 WHERE entry=37637; – Wrathbone Coldwraith (1)
UPDATE creature_template SET faction_A=21, faction_H=21, equipment_id=104 WHERE entry=37638; – Wrathbone Laborer (1)
UPDATE creature_template SET equipment_id=122 WHERE entry=37639; – Wrathbone Siegesmith (1)
UPDATE creature_template SET unit_flags=32832 WHERE entry=37640; – Wrathbone Skeleton (1)
UPDATE creature_template SET speed_run=1.42857, equipment_id=1877 WHERE entry=37641; – Ymirjar Deathbringer (1)
UPDATE creature_template SET speed_walk=2.8, speed_run=1.42857 WHERE entry=37642; – Ymirjar Flamebearer (1)
UPDATE creature_template SET faction_A=1885, faction_H=1885, speed_run=1.42857, unit_flags=32832, equipment_id=1871 WHERE entry=37643; – Ymirjar Skycaller (1)
UPDATE creature_template SET speed_run=1.07143 WHERE entry=37644; – Ymirjar Wrathbringer (1)
UPDATE creature_template SET equipment_id=254 WHERE entry=37645; – Alliance Slave (1)
UPDATE creature_template SET speed_run=1.42857, equipment_id=254 WHERE entry=37646; – Alliance Slave (1)
UPDATE creature_template SET equipment_id=254 WHERE entry=37647; – Alliance Slave (1)
UPDATE creature_template SET equipment_id=254 WHERE entry=37649; – Horde Slave (1)
UPDATE creature_template SET equipment_id=254 WHERE entry=37650; – Horde Slave (1)
UPDATE creature_template SET equipment_id=254 WHERE entry=37651; – Horde Slave (1)
UPDATE creature_template SET equipment_id=254 WHERE entry=37652; – Horde Slave (1)
UPDATE creature_template SET faction_A=16, faction_H=16, unit_flags=64, equipment_id=1870 WHERE entry=37720; – Frostsworn General (1)
UPDATE creature_template SET unit_flags=537165888, equipment_id=10034 WHERE entry=37797; – Dark Ranger Loralen (1)
UPDATE creature_template SET faction_A=1770, faction_H=1770, unit_flags=32832, equipment_id=637, flags_extra=2 WHERE entry=37809; – Archmage Elandra (1)
UPDATE creature_template SET equipment_id=10085 WHERE entry=38025; – Deathwhisper Shadowcaster (1)
UPDATE creature_template SET equipment_id=1744 WHERE entry=38026; – Deathwhisper Torturer (1)
UPDATE creature_template SET speed_walk=2, speed_run=1.42857, unit_flags=33587520, equipment_id=10079 WHERE entry=38031; – Deathbound Ward (1)
UPDATE creature_template SET equipment_id=10049 WHERE entry=38059; – Ancient Skeletal Soldier (1)
UPDATE creature_template SET speed_run=1.71429 WHERE entry=38064; – Stinky (1)
UPDATE creature_template SET equipment_id=10057 WHERE entry=38080; – Skybreaker Hierophant (1)
UPDATE creature_template SET equipment_id=10058 WHERE entry=38081; – Skybreaker Luminary (1)
UPDATE creature_template SET equipment_id=10060 WHERE entry=38083; – Skybreaker Sorcerer (1)
UPDATE creature_template SET equipment_id=10069 WHERE entry=38084; – Skybreaker Summoner (1)
UPDATE creature_template SET equipment_id=10062 WHERE entry=38086; – Skybreaker Vindicator (1)
UPDATE creature_template SET equipment_id=10063 WHERE entry=38087; – Kor’kron Defender (1)
UPDATE creature_template SET equipment_id=10064 WHERE entry=38088; – Kor’kron Invoker (1)
UPDATE creature_template SET equipment_id=2427 WHERE entry=38089; – Kor’kron Necrolyte (1)
UPDATE creature_template SET equipment_id=10065 WHERE entry=38090; – Kor’kron Oracle (1)
UPDATE creature_template SET equipment_id=10057 WHERE entry=38091; – Kor’kron Primalist (1)
UPDATE creature_template SET equipment_id=2430 WHERE entry=38092; – Kor’kron Reaver (1)
UPDATE creature_template SET equipment_id=2429 WHERE entry=38093; – Kor’kron Sniper (1)
UPDATE creature_template SET faction_A=83, faction_H=83, unit_flags=32832, equipment_id=2428 WHERE entry=38095; – Kor’kron Templar (1)
UPDATE creature_template SET equipment_id=10068 WHERE entry=38096; – Kor’kron Vanquisher (1)
UPDATE creature_template SET speed_run=1.71429 WHERE entry=38103; – Precious (1)
UPDATE creature_template SET speed_walk=0.8, speed_run=0.99206 WHERE entry=38249; – Hungering Ghoul (1)
UPDATE creature_template SET speed_walk=0.888888, speed_run=1.5873 WHERE entry=38390; – Rotface (1)
UPDATE creature_template SET speed_run=1.07143, equipment_id=10084 WHERE entry=38418; – Val’kyr Herald (1)
UPDATE creature_template SET speed_walk=1.2, speed_run=1.71429, unit_flags=33554688 WHERE entry=38431; – Professor Putricide (1)
UPDATE creature_template SET InhabitType=5 WHERE entry=38444; – Spire Frostwyrm (1)
UPDATE creature_template SET speed_walk=0.8, speed_run=0.992057, unit_flags=559168 WHERE entry=38445; – Spire Minion (1)
UPDATE creature_template SET scale=1 WHERE entry=38524; – Phantom Mage (1)
UPDATE creature_template SET scale=1, equipment_id=107 WHERE entry=38525; – Spectral Footman (1)
UPDATE creature_template SET scale=1, equipment_id=1868 WHERE entry=38544; – Tortured Rifleman (1)
UPDATE creature_template SET speed_walk=0.888888, speed_run=1.5873 WHERE entry=38549; – Rotface (2)
UPDATE creature_template SET speed_walk=0.888888, speed_run=1.5873 WHERE entry=38550; – Rotface (3)
UPDATE creature_template SET scale=1, equipment_id=14 WHERE entry=38563; – Ghostly Priest (1)
UPDATE creature_template SET scale=1, equipment_id=1218 WHERE entry=38564; – Shadowy Mercenary (1)
UPDATE creature_template SET unit_flags=64 WHERE entry=38568; – Phantom Hallucination (1)
UPDATE creature_template SET speed_walk=1.2, speed_run=1.71429, unit_flags=33554688 WHERE entry=38585; – Professor Putricide (2)
UPDATE creature_template SET speed_walk=1.2, speed_run=1.71429, unit_flags=33554688 WHERE entry=38586; – Professor Putricide (3)
UPDATE creature_template SET equipment_id=1866 WHERE entry=38599; – Falric (1)
UPDATE creature_template SET equipment_id=1867 WHERE entry=38603; – Marwyn (1)
UPDATE creature_template SET exp=2 WHERE entry=38605; – Mutated Abomination (1)
UPDATE creature_template SET unit_flags=0 WHERE entry=38717; – Alchemist Adrianna (1)
UPDATE creature_template SET exp=2 WHERE entry=38786; – Mutated Abomination (2)
UPDATE creature_template SET exp=2 WHERE entry=38787; – Mutated Abomination (3)
UPDATE creature_template SET exp=2, faction_A=14, faction_H=14, speed_walk=2, speed_run=1.71429, unit_flags=33554944 WHERE entry=39120; – Val’kyr Shadowguard (1)
UPDATE creature_template SET exp=2, faction_A=14, faction_H=14, speed_walk=2, speed_run=1.71429, unit_flags=33554944 WHERE entry=39121; – Val’kyr Shadowguard (2)
UPDATE creature_template SET exp=2, faction_A=14, faction_H=14, speed_walk=2, speed_run=1.71429, unit_flags=33554944 WHERE entry=39122; – Val’kyr Shadowguard (3)
UPDATE creature_template SET faction_A=974, faction_H=974, speed_walk=2, speed_run=1.71429, unit_flags=768, equipment_id=2418 WHERE entry=39166; – The Lich King (1)
UPDATE creature_template SET faction_A=974, faction_H=974, speed_walk=2, speed_run=1.71429, unit_flags=768, equipment_id=2418 WHERE entry=39167; – The Lich King (2)
UPDATE creature_template SET faction_A=974, faction_H=974, speed_walk=2, speed_run=1.71429, unit_flags=768, equipment_id=2418 WHERE entry=39168; – The Lich King (3)
UPDATE creature_template SET speed_walk=0.888888, speed_run=1.42857, flags_extra=1 WHERE entry=39805; – General Zarithrian (1)
UPDATE creature_template SET faction_A=103, faction_H=103, speed_walk=0.888888, speed_run=1.42857, equipment_id=2421 WHERE entry=39815; – Onyx Flamecaller (1)
UPDATE creature_template SET speed_walk=2, speed_run=2.14286, scale=1.2, InhabitType=7, flags_extra=1 WHERE entry=39823; – Saviana Ragefire (1)
UPDATE creature_template SET exp=2, speed_walk=1.6, speed_run=1.42857, flags_extra=1 WHERE entry=39864; – Halion (1)
UPDATE creature_template SET speed_walk=2.8, speed_run=1.71429, scale=1.5, flags_extra=1 WHERE entry=39920; – Baltharus the Warborn (1)
UPDATE creature_template SET exp=2 WHERE entry IN (39751,39899,39920); – Baltharus the Warborn
UPDATE creature_template SET exp=2, speed_walk=1.6, speed_run=1.42857, flags_extra=1 WHERE entry=39944; – Halion (2)
UPDATE creature_template SET exp=2, speed_walk=1.6, speed_run=1.42857, flags_extra=1 WHERE entry=39945; – Halion (3)
UPDATE creature_template SET speed_walk=1.6, speed_run=1.42857 WHERE entry=40418; – Charscale Invoker (1)
UPDATE creature_template SET speed_walk=1.6, speed_run=1.42857 WHERE entry=40420; – Charscale Assaulter (1)
UPDATE creature_template SET speed_walk=1.6, speed_run=1.42857 WHERE entry=40422; – Charscale Elite (1)
UPDATE creature_template SET speed_walk=1.6, speed_run=1.42857 WHERE entry=40424; – Charscale Commander (1)

[/sql]

We might want to update these too:

`c2`.`dynamicflags`=`c1`.`dynamicflags`
`c2`.`family`=`c1`.`family`,
`c2`.`trainer_type`=`c1`.`trainer_type`,
`c2`.`trainer_spell`=`c1`.`trainer_spell`,
`c2`.`trainer_class`=`c1`.`trainer_class`,
`c2`.`trainer_race`=`c1`.`trainer_race`,
`c2`.`type`=`c1`.`type`,
`c2`.`type_flags`=`c1`.`type_flags`,
`c2`.`resistance1`=`c1`.`resistance1`,
`c2`.`resistance2`=`c1`.`resistance2`,
`c2`.`resistance3`=`c1`.`resistance3`,
`c2`.`resistance4`=`c1`.`resistance4`,
`c2`.`resistance5`=`c1`.`resistance5`,
`c2`.`resistance6`=`c1`.`resistance6`,
`c2`.`VehicleId`=`c1`.`VehicleId`,
`c2`.`RacialLeader`=`c1`.`RacialLeader`,
`c2`.`spell1`=`c1`.`spell1`,
`c2`.`spell2`=`c1`.`spell2`,
`c2`.`spell3`=`c1`.`spell3`,
`c2`.`spell4`=`c1`.`spell4`,
`c2`.`spell5`=`c1`.`spell5`,
`c2`.`spell6`=`c1`.`spell6`,
`c2`.`spell7`=`c1`.`spell7`,
`c2`.`spell8`=`c1`.`spell8`,
`c2`.`mindmg`=`c1`.`mindmg`, <- wrong
`c2`.`maxdmg`=`c1`.`maxdmg`, <- wrong
`c2`.`modelid1`=`c1`.`modelid1`,
`c2`.`modelid2`=`c1`.`modelid2`,
`c2`.`modelid3`=`c1`.`modelid3`,
`c2`.`modelid4`=`c1`.`modelid4`,
`c2`.`subname`=`c1`.`subname`,
`c2`.`gossip_menu_id`=`c1`.`gossip_menu_id`,
`c2`.`IconName`=`c1`.`IconName`,
`c2`.`mechanic_immune_mask`=`c1`.`mechanic_immune_mask`, <- wrong
`c2`.`skinloot`=`c1`.`skinlook`,[/code]
Spot errors, please.

Edit 1: Flags_extra can't be equal (normal mode 5m bosses shouldn't bind the player, etc)

Edit 2: Removed all the flags_extra=0

Malcrom · April 10, 2011, 3:23pm

I love you /emoticons/default_smile.png

Kaelima · April 10, 2011, 3:33pm

flags_extra should not be shared with their heroic entry (will remove instance binding for heroic dungeons).

Some ranks also isnt shared with normal/heroic

ZxBiohazardZx · April 11, 2011, 10:31am

looking good kaelima, i vote go

Kaelima · April 11, 2011, 11:01am

We might want to update these too:

`c2`.`dynamicflags`=`c1`.`dynamicflags` `c2`.`family`=`c1`.`family`, `c2`.`trainer_type`=`c1`.`trainer_type`, `c2`.`trainer_spell`=`c1`.`trainer_spell`, `c2`.`trainer_class`=`c1`.`trainer_class`, `c2`.`trainer_race`=`c1`.`trainer_race`, `c2`.`type`=`c1`.`type`, `c2`.`type_flags`=`c1`.`type_flags`, `c2`.`resistance1`=`c1`.`resistance1`, `c2`.`resistance2`=`c1`.`resistance2`, `c2`.`resistance3`=`c1`.`resistance3`, `c2`.`resistance4`=`c1`.`resistance4`, `c2`.`resistance5`=`c1`.`resistance5`, `c2`.`resistance6`=`c1`.`resistance6`, `c2`.`VehicleId`=`c1`.`VehicleId`, `c2`.`RacialLeader`=`c1`.`RacialLeader`, `c2`.`spell1`=`c1`.`spell1`, `c2`.`spell2`=`c1`.`spell2`, `c2`.`spell3`=`c1`.`spell3`, `c2`.`spell4`=`c1`.`spell4`, `c2`.`spell5`=`c1`.`spell5`, `c2`.`spell6`=`c1`.`spell6`, `c2`.`spell7`=`c1`.`spell7`, `c2`.`spell8`=`c1`.`spell8`, `c2`.`mindmg`=`c1`.`mindmg`, <- wrong `c2`.`maxdmg`=`c1`.`maxdmg`, <- wrong `c2`.`modelid1`=`c1`.`modelid1`, `c2`.`modelid2`=`c1`.`modelid2`, `c2`.`modelid3`=`c1`.`modelid3`, `c2`.`modelid4`=`c1`.`modelid4`, `c2`.`subname`=`c1`.`subname`, `c2`.`gossip_menu_id`=`c1`.`gossip_menu_id`, `c2`.`IconName`=`c1`.`IconName`, `c2`.`mechanic_immune_mask`=`c1`.`mechanic_immune_mask`, <- wrong `c2`.`skinloot`=`c1`.`skinlook`,

Some here are wdb fields

Whats left is:

`c2`.`dynamicflags`=`c1`.`dynamicflags`
`c2`.`trainer_type`=`c1`.`trainer_type`,
`c2`.`trainer_spell`=`c1`.`trainer_spell`,
`c2`.`trainer_class`=`c1`.`trainer_class`,
`c2`.`trainer_race`=`c1`.`trainer_race`,
`c2`.`resistance1`=`c1`.`resistance1`,
`c2`.`resistance2`=`c1`.`resistance2`,
`c2`.`resistance3`=`c1`.`resistance3`,
`c2`.`resistance4`=`c1`.`resistance4`,
`c2`.`resistance5`=`c1`.`resistance5`,
`c2`.`resistance6`=`c1`.`resistance6`,
`c2`.`VehicleId`=`c1`.`VehicleId`,
`c2`.`spell1`=`c1`.`spell1`,
`c2`.`spell2`=`c1`.`spell2`,
`c2`.`spell3`=`c1`.`spell3`,
`c2`.`spell4`=`c1`.`spell4`,
`c2`.`spell5`=`c1`.`spell5`,
`c2`.`spell6`=`c1`.`spell6`,
`c2`.`spell7`=`c1`.`spell7`,
`c2`.`spell8`=`c1`.`spell8`,
`c2`.`gossip_menu_id`=`c1`.`gossip_menu_id`,
`c2`.`skinloot`=`c1`.`skinloot`

Aokromes · April 11, 2011, 11:14am

imho every heroic creature must have AT LEAST the same mechanic_immune_mask and maybe some more /emoticons/default_tongue.png

Nay · April 11, 2011, 11:47am

Yeah, it was on purpose. As far as I know some diff templates were forged.

Discover · June 8, 2011, 12:37pm

Any news on this? =)