What's new

More Mob Level Fixes

orangefire

Gold Supporter
Gold Supporter
Registered User
Veteran User
Joined
Jun 14, 2021
Messages
87
Reaction score
52
Gender
Other
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
 

Blackvision

Moderator
Staff Member
Super Moderator
Gold Supporter
MoP Premium
Mythical User
Joined
Sep 10, 2015
Messages
2,058
Reaction score
234
Location
Denmark
Gender
Male
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
Thank you mate :) Keep it up
 
Top