item_instance
This table holds individual item instance information for all items currently equipped in some kind of character bag or bank, in auctionhouses, in guild banks or in mails.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guid | int | unsigned | PRI | NO | 0 | ||
| itemEntry | mediumint | unsigned | NO | 0 | |||
| owner_guid | int | unsigned | MUL | NO | 0 | ||
| creatorGuid | int | unsigned | NO | 0 | |||
| giftCreatorGuid | int | unsigned | NO | 0 | |||
| count | int | unsigned | NO | 1 | |||
| duration | int | signed | NO | 0 | |||
| charges | tinytext | YES | NULL | ||||
| flags | mediumint | unsigned | NO | 0 | |||
| enchantments | text | NO | |||||
| randomPropertyId | smallint | signed | NO | 0 | |||
| durability | smallint | unsigned | NO | 0 | |||
| playedTime | int | unsigned | NO | 0 | |||
| text | text | YES | NULL | ||||
Description of fields
guid
The GUID of the item. This number is unique for each item instance.
itemEntry
The item entry this copy was derived from.
owner_guid
The character guid who has ownership of this item.
creatorGuid
The character guid who created this item, if any. Displayed on the bottom of an items tooltip.
giftCreatorGuid
The character guid who created this gift, if any.
count
Current number of item copies out of stackable in the stack.
duration
Remaining item duration in sec.
charges
The number of charges for each of the five possible spellcharges on an item, specified via five space separated integers.
flags
enum ItemFieldFlags excerpt:
| Value | Flag | Name | Comment |
|---|---|---|---|
| 1 | 0x0001 | ITEM_FIELD_FLAG_SOULBOUND | Item is soulbound and cannot be traded |
| 4 | 0x0004 | ITEM_FIELD_FLAG_UNLOCKED | Item had lock but can be opened now |
| 8 | 0x0008 | ITEM_FIELD_FLAG_WRAPPED | Item is wrapped and contains another item |
| 256 | 0x0100 | ITEM_FIELD_FLAG_BOP_TRADEABLE | Allows trading soulbound items |
| 512 | 0x0200 | ITEM_FIELD_FLAG_READABLE | Opens text page when right clicked |
| 4096 | 0x1000 | ITEM_FIELD_FLAG_REFUNDABLE | Item can be returned to vendor for its original cost (extended cost) |
enchantments
Stores all enchantments as 12 space separated 3-tuples of [EnchantmentId duration charges]. EnchantmentId is a SpellItemEnchantment ID. enum EnchantmentSlot
| ID | Name | Comment |
|---|---|---|
| 0 | PERM_ENCHANTMENT_SLOT | |
| 1 | TEMP_ENCHANTMENT_SLOT | |
| 2 | SOCK_ENCHANTMENT_SLOT | |
| 3 | SOCK_ENCHANTMENT_SLOT_2 | |
| 4 | SOCK_ENCHANTMENT_SLOT_3 | |
| 5 | BONUS_ENCHANTMENT_SLOT | |
| 6 | PRISMATIC_ENCHANTMENT_SLOT | added at apply special permanent enchantment |
| 7 | PROP_ENCHANTMENT_SLOT_0 | used with RandomSuffix |
| 8 | PROP_ENCHANTMENT_SLOT_1 | used with RandomSuffix |
| 9 | PROP_ENCHANTMENT_SLOT_2 | used with RandomSuffix and RandomProperty |
| 10 | PROP_ENCHANTMENT_SLOT_3 | used with RandomProperty |
| 11 | PROP_ENCHANTMENT_SLOT_4 | used with RandomProperty |
randomPropertyId
- randomPropertyId > 0: ItemRandomProperty ID
- randomPropertyId < 0: ItemRandomSuffix ID
durability
Remaining item MaxDurability.
playedTime
Stores the age of the item in seconds. (governs refundability)
text
Player composed text on readable item. (see Plain Letter, created by mail system)