item_loot_items

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.

Structure

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

Description of fields

container_id

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.

 

item_id

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.

 

item_count

The stack size of the item. (item_count <= stackable)  

item_index

The items position in loot window.  

follow_rules

Flag to determine if the core should apply additional loot rules when the item is removed from the container.

• 0: no extra conditions
• 1: if player is in a group apply its loot rules  

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.

• 0: container owner also owns its' content
• 1: container owners party also rolls for loot  

blocked

Flag to determine if the item can be looted directly?

• 0: can be taken directly from container?
• 1: must be rolled for or assigned by master looter?  

counted

Flag if item is counted towards loot content? Quest loot or unfulfilled conditions may hide an item from the looter.

• 0: item is not visible in loot
• 1: can be looted  

under_threshold

The item is below the quality threshold and can be looted normally?

• 0: looting is blocked
• 1: can be looted  

needs_quest

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

• 0: not a quest drop
• 1: considered a quest drop  

rnd_prop

ItemRandomProperty ID (if any) that was rolled and added to the item when the loot container was originally opened. Mutually exclusive with rnd_suffix.  

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.