creature_loot_template Table¶
Loot tables for creatures - defines items, drop chances, groups, and patch ranges.
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 | PRI | 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 | PRI | NO | 0 | |
patch_max |
tinyint(3) unsigned | PRI | NO | 10 |
Field Breakdown¶
entry- Primary Key. Creature loot ID =creature_template.loot_id (a creature withloot_id= 0 has no body loot).item- Primary Key. Item ID fromitem_template.entry.ChanceOrQuestChance- Drop percentage (0-100). Negative values indicate quest item chance.groupid- Primary Key. 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 that must be met for the drop. (seeconditions.condition_entry)patch_min/patch_max- Client patch range.