From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/item_loot_items.md | 206 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 206 insertions(+) create mode 100644 docs/item_loot_items.md (limited to 'docs/item_loot_items.md') diff --git a/docs/item_loot_items.md b/docs/item_loot_items.md new file mode 100644 index 0000000..75d0001 --- /dev/null +++ b/docs/item_loot_items.md @@ -0,0 +1,206 @@ +# 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](#item_loot_items-container_id) can have more than one [item\_id](#item_loot_items-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" -- cgit