loot_items
This table contains the items that can be dropped from loot tables.
Structure
| Field | Type | Default | Comment |
|---|---|---|---|
| entryid | int(10) | 0 | |
| itemid | int(11) | 0 | |
| normal10percentchance | float(5) | 0.00 | |
| normal25percentchance | float(5) | 0.00 | |
| heroic10percentchance | float(5) | 0.00 | |
| heroic25percentchance | float(5) | 0.00 | |
| mincount | int(10) | 0 | |
| maxcount | int(10) | 0 | |
| is_currency | tinyint unsigned | 0 |
entryid
The Entry ID of the zone from item_properties.
itemid
The Entry ID of the Item that will drop, from item_properties.
normal10percentchance
The percent chance (1 - 100) you have of getting the item from Normal 10-mode.
normal25percentchance
The percent chance (1 - 100) you have of getting the item from Normal 25-mode.
heroic10percentchance
The percent chance (1 - 100) you have of getting the item from Heroic 10-mode.
heroic25percentchance
The percent change (1 - 100) you have of getting the item from Heroic 25-mode.
mincount
The minimum amount of the Item that will drop.
maxcount
The maximum amount of the Item that will drop.
is_currency
Determines whether itemid contains an item ID or a currency ID.
When set to 0, itemid refers to an entry from item_properties.
When set to a non-zero value, itemid refers to a currency ID from CurrencyTypes.dbc.
This field is available for Cata and later versions and is always the last column in the loot table.