item_loot_items

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	Null
container_id	INT	UNSIGNED	NO
item_id	INT	UNSIGNED	NO
item_count	INT		NO
follow_rules	TINYINT		NO
ffa	TINYINT		NO
blocked	TINYINT		NO
counted	TINYINT		NO
under_threshold	TINYINT		NO
needs_quest	TINYINT		NO
rnd_prop	INT		NO
rnd_suffix	INT		NO

Description of the fields

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.

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.

The stack size of the item. Only stackable items can be > 1.

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.

field-no-description|6

Flag to determine if the item is a quest item to be counted as a “quest drop”.

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”).

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”

item_loot_items

container_id

item_id

item_count

follow_rules

ffa

blocked

counted

under_threshold

needs_quest

rnd_prop

rnd_suffix