|
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 'item_instance' table for MaNGOSTwo
This table holds individual item instance information for all items currently equipped or in some kind of character bag or bank.
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 | PRI | '0' | The GUID of the item. This number is unique for each item instance. | |
| owner_guid | int(11) unsigned | NO | MUL | '0' | The GUID of the character who has ownership of this item. [See character.guid] | |
| data | longtext | YES | NULL | Much like the playerbytes fields in the characters table. | ||
| text | longtext | YES | NULL |
Description of the fields
guid int(11) unsigned
The GUID of the item. This number is unique for each item instance.
owner_guid int(11) unsigned
The GUID of the character who has ownership of this item. [See character.guid]
data longtext
Much like the playerbytes fields in the characters table, this field has many number fields all separated by a space which contain specific individual item information like any enchantments applied to the item, etc.
| Index | Flag Name | Meaning |
|---|---|---|
| 0 | OBJECT_FIELD_GUID | Item GUID |
| 2 | OBJECT_FIELD_TYPE | Should be 3 (TYPE_OBJECT + TYPE_ITEM) |
| 3 | OBJECT_FIELD_ENTRY | Entry |
| 4 | OBJECT_FIELD_SCALE_X | 1.0 |
| 5 | OBJECT_FIELD_PADDING | Some padding, need more info here. |
| 6 | ITEM_FIELD_OWNER | owner_guid |
| 8 | ITEM_FIELD_CONTAINED | If the item is in a bag, the GUID of the bag item; otherwise owner GUID. |
| 10 | ITEM_FIELD_CREATOR | GUID of character who created the item. |
| 12 | ITEM_FIELD_GIFTCREATOR | GUID of character who created the "item". [See character_gifts.item_guid]. |
| 14 | ITEM_FIELD_STACK_COUNT | Current number of item copies in the stack. |
| 15 | ITEM_FIELD_DURATION | Current duration (in milliseconds) |
| 16 | ITEM_FIELD_SPELL_CHARGES | Current Number of charges left in the item |
| 21 | ITEM_FIELD_FLAGS | Flags from "item_template" (See Item_template.flags). |
| 22 | ITEM_FIELD_ENCHANTMENT | Unknown |
| 55 | ITEM_FIELD_PROPERTY_SEED | Also called ITEM_FIELD_SUFFIX_FACTOR |
| 56 | ITEM_FIELD_RANDOM_PROPERTIES_ID | Unknown |
| 57 | ITEM_FIELD_ITEM_TEXT_ID | Text id used and shown by the item. |
| 58 | ITEM_FIELD_DURABILITY | Current item durability. |
| 59 | ITEM_FIELD_MAXDURABILITY | Maximum item durability. |
text longtext
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