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

container_id

int(10)

unsigned

 

NO

0

 

 

item_id

int(10)

unsigned

 

NO

0

 

 

item_count

int(10)

 

 

NO

0

 

 

follow_rules

tinyint(1)

 

 

NO

0

 

 

ffa

tinyint(1)

 

 

NO

0

 

 

blocked

tinyint(1)

 

 

NO

0

 

 

counted

tinyint(1)

 

 

NO

0

 

 

under_threshold

tinyint(1)

 

 

NO

0

 

 

needs_quest

tinyint(1)

 

 

NO

0

 

 

rnd_prop

int(10)

 

 

NO

0

 

 

rnd_suffix

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"