Automatically set RequiredDisenchantSkill & DisenchantID (item_template)

[NotCoffee418]

Add a checkbox on the right (auto check when weapon/armor is chosen, uncheck when not weapon/armor)
if checked set required skill = level * 5
You can slap the DisenchantID (loot) into the program with data from the following query.

SELECT DISTINCT Quality, RequiredLevel, DisenchantID FROM item_template WHERE RequiredLevel > 0 AND DisenchantID > 0 ORDER BY RequiredLevel ASC

[NotCoffee418]

This is the full query that works with atleast Trinity Latest. Make sure to default to 0 if it fails.
SELECT Quality, RequiredLevel, DisenchantID, RequiredDisenchantSkill FROM item_template WHERE RequiredLevel <= 80 AND Quality = 3 AND DisenchantID > 0 GROUP BY Quality, RequiredLevel ORDER BY RequiredLevel DESC, DisenchantId ASC LIMIT 1

Replace 80 with level and 4 with quality.