loot_gameobjects
This table contains the loots for gameobjects.
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 | |
| comment | |||
| is_currency | tinyint unsigned | 0 |
entryid
The Entry ID of the loot. This referres to gameobject_properties table parameter_1 (Only for type 3 and 25)
itemid
The Entry ID of the Item that will drop, from item_properties.
normal10percentchance
The percent chance (1 - 100) that the Item will drop outside instances, in normal dungeons, normal 10 mode raids, old 25 and 40 man raids.
normal25percentchance
The percent chance (1 - 100) that the Item will drop in heroic dungeons and in Normal 25-mode raids.
heroic10percentchance
The percent chance (1 - 100) that the Item will drop in Heroic 10-mode.
heroic25percentchance
The percent chance (1 - 100) that the Item will drop in Heroic 25-mode.
mincount
The minimum amount of the Item that will drop.
maxcount
The maximum amount of the Item that will drop.
comment
An optional comment describing the loot entry.
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.