AzerothCore
Pages :

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.

Table Structure

Field Type Attributes Key Null Default Extra Comment
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

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"