Skip to content

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 with loot_id = 0 has no body loot).
  • item - Primary Key. Item ID from item_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 -n pulls from reference_loot_template.entry n.
  • maxcount - Maximum stack count.
  • condition_id - Condition that must be met for the drop. (see conditions.condition_entry)
  • patch_min / patch_max - Client patch range.