Back to 'item_instance' Return to characters Go to 'item_loot_money'
Contains the items associated with a lootable container item.
This table is populated the first time the player right-clicks to open an item. Rows are deleted when the player either removes an item or destroys the container item.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| container_id | int | unsigned | NO | 0 | guid of container (item_instance.guid) | ||
| item_id | int | unsigned | NO | 0 | loot item entry (item_instance.itemEntry) | ||
| item_count | int | signed | NO | 0 | stack size | ||
| item_index | int | unsigned | NO | 0 | |||
| follow_rules | tinyint(1) | signed | NO | 0 | follow loot rules | ||
| ffa | tinyint(1) | signed | NO | 0 | free-for-all | ||
| blocked | tinyint(1) | signed | NO | 0 | |||
| counted | tinyint(1) | signed | NO | 0 | |||
| under_threshold | tinyint(1) | signed | NO | 0 | |||
| needs_quest | tinyint(1) | signed | NO | 0 | quest drop | ||
| rnd_prop | int | signed | NO | 0 | random enchantment added when originally rolled | ||
| rnd_suffix | int | signed | NO | 0 | random suffix added when originally rolled |
The item guid of the container that holds the loot item(s).
Note: A container_id can have more than one item_id associated with it.
The item entry of the loot item.
Note: It is possible for there to be more than one of the same item in a container.
The stack size of the item.
(item_count <= stackable)
The items position in loot window.
Flag to determine if the core should apply additional loot rules when the item is removed from the container.
Flag to determine if free-for-all looting applies. This should typically be 0 because the items are inside an item in the character's inventory.
Flag to determine if the item can be looted directly?
Flag if item is counted towards loot content? Quest loot or unfulfilled conditions may hide an item from the looter.
The item is below the quality threshold and can be looted normally?
Flag to determine if the item is a quest item to be counted as a "quest drop".
ItemRandomProperty ID (if any) that was rolled and added to the item when the loot container was originally opened.
Mutually exclusive with rnd_suffix.
ItemRandomSuffix ID (if any) that was rolled and added to the item when the loot container was originally opened.
Mutually exclusive with rnd_prop.
Back to 'item_instance' Return to characters Go to 'item_loot_money'