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/character_inventory.md | 217 ++++++++++++++++++++++++++++++++++++++++++-- 1 file changed, 209 insertions(+), 8 deletions(-) (limited to 'docs/character_inventory.md') diff --git a/docs/character_inventory.md b/docs/character_inventory.md index d592f46..06c1ed8 100644 --- a/docs/character_inventory.md +++ b/docs/character_inventory.md @@ -1,8 +1,209 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [character_inventory](character_inventory) - -Column | Type | Description ---- | --- | --- -Guid | int(10) unsigned | -Bag | int(10) unsigned | -Slot | tinyint(3) unsigned | -Item | int(10) unsigned | +# character\_inventory + +`Back-to:Characters` + +**The \`character\_inventory\` table** + +Contains all the character inventory data, including the bank data. + +**Structure** + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

Unique

NO

0

 

Global Unique Identifier

bag

int(10)

unsigned

Unique

NO

0

 

 

slot

tinyint(3)

unsigned

Unique

NO

0

 

 

item

int(10)

unsigned

PRI

NO

0

 

Item Global Unique Identifier

+ +**Description of the fields** + +### guid + +The GUID of the character. See characters.guid + +### bag + +If it isn't 0, then it is the bag's item GUID. See item\_instance.guid + +### slot + +If the bag field is non-zero, then the slot is the slot in the bag where the item is kept. The range can differ depending on the number of slots the bag has. + +If the bag field is zero, then the slot has a range of 0 to 130 and the value stands for the following: + + ++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Slot #

Value

0

Head

1

Neck

2

Shoulders

3

Body

4

Chest

5

Waist

6

Legs

7

Feet

8

Wrists

9

Hands

10

Finger 1

11

Finger 2

12

Trinket 1

13

Trinket 2

14

Back

15

Main Hand

16

Off Hand

17

Ranged

18

Tabard

19-22

Equipped Bags

23-38

Main Backpack

39-66

Main Bank

67-73

Bank Bags

86-117

Keys in Keyring

118-135

Currencies (Emblems,badges,marks etc.)

+ +### item + +The item's GUID. See item\_instance.guid -- cgit