item_loot_items
Back-to:Characters
The `item_loot_items` table
Contains the items associated with a lootable inventory item such as a "watertight trunk" or "Bulging Sack of Gems"
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.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
int(10) | unsigned |
| NO | 0 |
|
| |
int(10) | unsigned |
| NO | 0 |
|
| |
int(10) |
|
| NO | 0 |
|
| |
tinyint(1) |
|
| NO | 0 |
|
| |
tinyint(1) |
|
| NO | 0 |
|
| |
tinyint(1) |
|
| NO | 0 |
|
| |
tinyint(1) |
|
| NO | 0 |
|
| |
tinyint(1) |
|
| NO | 0 |
|
| |
tinyint(1) |
|
| NO | 0 |
|
| |
int(10) |
|
| NO | 0 |
|
| |
int(10) |
|
| NO | 0 |
|
|
Description of the fields
container_id
The GUID of the container item that holds the loot item(s). See item_instance.guid
Note: A container_id can have more than one item_id associated with it.
item_id
The entry of the loot item. See item_instance.itemEntry
Note: It is possible for there to be more than one of the same item in a container.
item_count
The stack size of the item. Only stackable items can be > 1.
follow_rules
Flag to determine if the core should apply additional loot rules when the item
is removed from the container.
ffa
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.
blocked
field-no-description|6
counted
field-no-description|6
under_threshold
field-no-description|6
needs_quest
Flag to determine if the item is a quest item to be counted as a "quest drop".
rnd_prop
The random enchantment (if any) that was rolled and added to the item when the loot container was
originally opened.
For example: "Ebon Scimitar" (as opposed to a plain "Scimitar").
rnd_suffix
The random suffix (if any) that was rolled and added to the item when the loot container was
originally opened.
For example: "of the Monkey"