目录

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