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. (seeitem_template.entry)ChanceOrQuestChance- Drop probability (0-100).groupid- Loot group; items in same group are mutually exclusive.mincountOrRef- Minimum stack size; a negative value-npulls fromreference_loot_template.entry n.maxcount- Maximum stack count.condition_id- Condition required for this drop. (seeconditions.condition_entry)patch_min/patch_max- Client patch range.