T1ti
commented
3 years ago how it should work : If Item level is lower than 60 : (no idea how it works for BC/wotlk items) Min level of the creature = Itemlevel -1, Max = Itemlevel +3
Which means a lvl 40 mob can drop items from lvl 39 to 43.
So a lvl 40 item can be obtained from mobs lvl 37 to 41.
This formula seems to only apply to non elite creatures and colored and white items(white/green/blue/purple). Grey items seem to be lvl min +4/+10(based on lvl), max is always -1 from monster.
So it's not just "10 levles higher", the querry should be, any item that has ilevel (not req level), 4 higher than creature's max level and also, any item 2 levels lower than min level.
here's a querrry for this(only vanilla non elites) :
SELECT ct.name, ct.maxlevel, it.name, it.ItemLevel
FROM `creature_template` ct
LEFT JOIN `creature_loot_template` clt ON ct.lootid = clt.entry
JOIN `item_template` it ON clt.item = it.entry
WHERE ct.maxlevel + 4 <= it.ItemLevel AND clt.Reference = 0 AND it.class IN (2, 4) AND ct.maxlevel < 61 AND ct.rank=0 AND it.Quality>0;
Azcobu
UltraNix
CURRENT BEHAVIOUR:
There have been a number of reports of item drops with levels that are significantly higher than the NPCs who drop them recently. This is an attempt to identify such drops.
Updated the query with @T1ti 's query and tweaked to sort by level disparity and exclude various quest items like the Pendant of Myzrael.
Updated to only check open world mobs, i.e. those in world maps 0 and 1, as dungeon/raid NPCs seem to have different limits on permissible item levels.
Underlevelled items - not the full list, but selected rows:
EXPECTED BLIZZLIKE BEHAVIOUR:
NPCs should drop level-appropriate items.
EXTRA NOTES:
AC HASH/COMMIT:
rev. 63a273507c75 2021-05-22 00:10:46 +0200