|
NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'character_inventory' table for MaNGOSOne
Contains all the character inventory data, including the bank data.
Table Notes
This table uses the 'MyISAM' DB Engine
The Field definitions follow:
| Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
|---|---|---|---|---|---|---|
| guid | int(11) unsigned | NO | MUL | '0' | The GUID (Global Unique Identifier) of the character. [See character.guid]. | |
| bag | int(11) unsigned | NO | '0' | If it isn't 0, then it is the bag's item GUID (Global Unique Identifier). | ||
| slot | tinyint(3) unsigned | NO | '0' | The slot is the slot in the bag where the item is. | ||
| item | int(11) unsigned | NO | PRI | '0' | The item's GUID. [See item_instance.guid]. | |
| item_template | int(11) unsigned | NO | '0' | The item's template entry (Item Identifier). [See item_template.entry]. |
Description of the fields
guid int(11) unsigned
The GUID (Global Unique Identifier) of the character. [See character.guid].
bag int(11) unsigned
If it isn't 0, then it is the bag's item GUID (Global Unique Identifier). [See item_instance.guid].
slot tinyint(3) unsigned
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 84 and the value stands for the following:
| Slot # | Slot Name |
|---|---|
| 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-62 | Main Bank - 24 positions |
| 63-68 | Bank Bags - 6 positions |
| later changed to | |
| 39-67 | Main Bank - 28 positions ? |
| 68-74 | Bank Bags - 7 positions ? |
item int(11) unsigned
The item's GUID. [See item_instance.guid].
item_template int(11) unsigned
The item's template entry (Item Identifier). [See item_template.entry].
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now