Skip to content

item_loot_template Table

Loot tables for items (e.g., when an item is opened).


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 PRI NO 0
patch_max tinyint(3) unsigned PRI NO 10

Field Breakdown

  • entry - Primary Key. Loot list id referenced by the owner system (see Loot System).
  • item - Primary Key. Item entry (from item_template.entry).
  • ChanceOrQuestChance - Positive = plain % chance · negative = quest drop (% magnitude) · 100 always.
  • groupid - Equal-chance group id; rows sharing a group share the drop budget. 0 = independent roll.
  • mincountOrRef - Minimum stack size; a negative value -n pulls from reference_loot_template.entry n.
  • maxcount - Max stack size (or max pulls for references).
  • condition_id - Optional conditions row gating this loot line.
  • patch_min - Primary Key. Progression visibility window.
  • patch_max - Primary Key. Progression visibility window.