Skip to content

disenchant_loot_template Table

Loot tables for disenchanting items - defines what materials drop when an item is disenchanted.


Schema Summary

Field Type Key Null Default Extra
entry mediumint(8) unsigned PRI NO 0
item mediumint(8) unsigned PRI NO 0
ChanceOrQuestChance float NO 100
groupid tinyint(3) unsigned NO 0
mincountOrRef mediumint(9) NO 1
maxcount tinyint(3) unsigned NO 1
condition_id mediumint(8) unsigned NO 0
patch_min tinyint(3) unsigned NO 0
patch_max tinyint(3) unsigned NO 10

Field Breakdown

  • entry - Primary Key. Disenchant loot ID (item_template.DisenchantID).
  • item - Primary Key. Resulting item ID. (see item_template.entry)
  • ChanceOrQuestChance - Drop probability (0-100).
  • groupid - Loot group; items in same group are mutually exclusive.
  • mincountOrRef - Minimum stack size; a negative value -n pulls from reference_loot_template.entry n.
  • maxcount - Maximum stack count.
  • condition_id - Condition required for this drop. (see conditions.condition_entry)
  • patch_min / patch_max - Client patch range.