azerothcore/mod-random-enchants

White item got enchanted with a Tier 4 enchant

Opened this issue · 1 comments

GScilingo commented

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 commented

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='{}')

  • 👍1