White item got enchanted with a Tier 4 enchant

[GScilingo]

I've looted from a corpse a low lvl cape and got the +28 Spirit enchant which shouldn't be posible as it is a tier 4 enchantment in the item_enchantment_random_tier table

Looking at the code the maximum enchant tier for a white item should be 2.

[LordAle]

The SQL query results in any entry being chosen. It can be fixed by changing the WHERE clause to something similar to this :

tier={} AND (exclusiveSubClass IS NULL OR exclusiveSubClass={}) AND (class='ANY' OR class='{}')