- 91
- 2021
- 57
Hello! A while back I posted some fixes to mob levels in dungeons. I've caught a few more issues that I missed in my initial fixes as well as the same issue in Cataclysm dungeons.
SQL:
-- Hellfire Ramparts
UPDATE creature_template SET maxlevel=61 WHERE entry=17450; -- fixes Fiendish Hound level
UPDATE creature_template SET maxlevel=61 WHERE entry=17281; -- fixes Bonechewer Ripper level
-- Escape From Durnholde Keep
UPDATE creature_template SET maxlevel=68 WHERE entry=23179; -- fixes Tarren Mill Protector level
UPDATE creature_template SET maxlevel=68 WHERE entry=23175; -- fixes Tarren Mill Guardsman level
UPDATE creature_template SET maxlevel=68 WHERE entry=23177; -- fixes Tarren Mill Guardsman level
UPDATE creature_template SET maxlevel=68 WHERE entry=18094; -- fixes Tarren Mill Lookout level
-- Azjol-Nerub
UPDATE creature_template SET maxlevel=70 WHERE entry=29209; -- fixes Carrion Beetle level
UPDATE creature_template SET maxlevel=70 WHERE entry=29097; -- fixes Anub'ar Champion level
-- Ahn'kahet: The Old Kingdom
UPDATE creature_template SET maxlevel=74 WHERE entry=30178; -- fixes Ahn'Kahet Swarmer level
-- Gundrak
UPDATE creature_template SET maxlevel=77 WHERE entry=29874; -- fixes Drakkari Inciter level
-- Vortex Pinnacle
UPDATE creature_template SET Health_mod=2.5, maxlevel=83 WHERE entry=45704; -- fixes Lurking Tempest Health and level
UPDATE creature_template SET maxlevel=83 WHERE entry=45912; -- fixes Wild Vortex level
UPDATE creature_template SET maxlevel=83 WHERE entry=45477; -- fixes Gust Soldier level
UPDATE creature_template SET Health_mod=5, maxlevel=83 WHERE entry=45917; -- fixes Cloud Prince Health and level
UPDATE creature_template SET maxlevel=83 WHERE entry=45924; -- fixes Turbulent Squall level
UPDATE creature_template SET maxlevel=83 WHERE entry=45932; -- fixes Skyfall Star level
UPDATE creature_template SET maxlevel=83 WHERE entry=45915; -- fixes Armored Minstral level
UPDATE creature_template SET maxlevel=83 WHERE entry=45919; -- fixes Young Storm Dragon level
-- Throne of the Tides
UPDATE creature_template SET maxlevel=80 WHERE entry=41139; -- fixes Naz'jar Spiritmender max level
UPDATE creature_template SET minlevel=80 WHERE entry=41139; -- fixes Naz'jar Spiritmender min level
UPDATE creature_template SET maxlevel=80 WHERE entry=40634; -- fixes Naz'jar Tempest max Witch level
UPDATE creature_template SET minlevel=80 WHERE entry=40634; -- fixes Naz'jar Tempest min Witch level
UPDATE creature_template SET maxlevel=80 WHERE entry=40579; -- fixes Deep Murloc Hunter max level
UPDATE creature_template SET minlevel=80 WHERE entry=40579; -- fixes Deep Murloc Hunter min level
UPDATE creature_template SET maxlevel=80 WHERE entry=40584; -- fixes Naz'jar Invader max level
UPDATE creature_template SET minlevel=80 WHERE entry=40584; -- fixes Naz'jar Invader min level
UPDATE creature_template SET maxlevel=80 WHERE entry=39616; -- fixes Naz'jar Invader max level
UPDATE creature_template SET minlevel=80 WHERE entry=39616; -- fixes Naz'jar Invader min level
UPDATE creature_template SET maxlevel=82 WHERE entry=40586; -- fixes Lady Naz'Jar max level
UPDATE creature_template SET minlevel=82 WHERE entry=40586; -- fixes Lady Naz'Jar min level
UPDATE creature_template SET maxlevel=82 WHERE entry=40825; -- fixes Erunak Stonespeaker max level
UPDATE creature_template SET minlevel=82 WHERE entry=40825; -- fixes Erunak Stonespeaker min level
UPDATE creature_template SET maxlevel=82 WHERE entry=40788; -- fixes Mindbender Ghur'sha max level
UPDATE creature_template SET minlevel=82 WHERE entry=40788; -- fixes Mindbender Ghur'sha min level
UPDATE creature_template SET maxlevel=80 WHERE entry=44658; -- fixes Deep Murloc Invader max level
UPDATE creature_template SET minlevel=80 WHERE entry=44658; -- fixes Deep Murloc Invader min level
UPDATE creature_template SET maxlevel=82 WHERE entry=44715; -- fixes Vicious Mindlasher max level
UPDATE creature_template SET minlevel=82 WHERE entry=44715; -- fixes Vicious Mindlasher min level
UPDATE creature_template SET maxlevel=82 WHERE entry=44648; -- fixes Unyielding Behemoth max level
UPDATE creature_template SET minlevel=82 WHERE entry=44648; -- fixes Unyielding Behemoth min level
UPDATE creature_template SET maxlevel=82 WHERE entry=42172; -- fixes Ozumat max level
UPDATE creature_template SET minlevel=82 WHERE entry=42172; -- fixes Ozumat min level
-- Stonecore
UPDATE creature_template SET maxlevel=84, minlevel=84 WHERE entry=43391; -- fixes Millhouse Manastorm level
UPDATE creature_template SET maxlevel=83, minlevel=82 WHERE entry=43430; -- fixes Stonecore Berserker level
UPDATE creature_template SET maxlevel=83 WHERE entry=43537; -- fixes Stonecore Earthshaper level
UPDATE creature_template SET maxlevel=83, minlevel=82 WHERE entry=43662; -- fixes Unbound Earth Rager level
UPDATE creature_template SET maxlevel=82 WHERE entry=42845; -- fixes Rock Borer level
UPDATE creature_template SET maxlevel=83, minlevel=82 WHERE entry=42695; -- fixes Stonecore Sentry level
UPDATE creature_template SET maxlevel=83, minlevel=82 WHERE entry=42789; -- fixes Stonecore Magmalord level
UPDATE creature_template SET maxlevel=82 WHERE entry=43014; -- fixes Imp level
UPDATE creature_template SET maxlevel=83 WHERE entry=42691; -- fixes Stonecore Rift Conjuror level
UPDATE creature_template SET maxlevel=83, minlevel=82 WHERE entry=42692; -- fixes Stonecore Bruiser level
UPDATE creature_template SET maxlevel=83 WHERE entry=42428; -- fixes Devout Follower level
UPDATE creature_template SET maxlevel=83, minlevel=82 WHERE entry=42428; -- fixes Stonecore Flayer level
Keep it up
