Skip to content

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 ​

FieldTypeAttributesKeyNullDefaultExtraComment
guidintunsignedPRINO0
itemEntrymediumintunsignedNO0
owner_guidintunsignedMULNO0
creatorGuidintunsignedNO0
giftCreatorGuidintunsignedNO0
countintunsignedNO1
durationintsignedNO0
chargestinytextYESNULL
flagsmediumintunsignedNO0
enchantmentstextNO
randomPropertyIdsmallintsignedNO0
durabilitysmallintunsignedNO0
playedTimeintunsignedNO0
texttextYESNULL

 

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:

ValueFlagNameComment
10x00000001ITEM_FIELD_FLAG_SOULBOUNDItem is soulbound and cannot be traded
40x00000004ITEM_FIELD_FLAG_UNLOCKEDItem had lock but can be opened now
80x00000008ITEM_FIELD_FLAG_WRAPPEDItem is wrapped and contains another item
2560x00000100ITEM_FIELD_FLAG_BOP_TRADEABLEAllows trading soulbound items
5120x00000200ITEM_FIELD_FLAG_READABLEOpens text page when right clicked
40960x00001000ITEM_FIELD_FLAG_REFUNDABLEItem can be returned to vendor for its original cost (extended cost)
2621440x00040000ITEM_FIELD_FLAG_UNK13?
5242880x00080000ITEM_FIELD_FLAG_UNK14?
7869440x000C0200ITEM_FLAG_MAIL_TEXT_MASK

 

enchantments ​

Stores all enchantments as 12 space separated 3-tuples of [EnchantmentId duration charges]. EnchantmentId is a SpellItemEnchantment ID.
enum EnchantmentSlot

IDNameComment
0PERM_ENCHANTMENT_SLOT
1TEMP_ENCHANTMENT_SLOT
2SOCK_ENCHANTMENT_SLOT
3SOCK_ENCHANTMENT_SLOT_2
4SOCK_ENCHANTMENT_SLOT_3
5BONUS_ENCHANTMENT_SLOT
6PRISMATIC_ENCHANTMENT_SLOTadded at apply special permanent enchantment
7PROP_ENCHANTMENT_SLOT_0used with RandomSuffix
8PROP_ENCHANTMENT_SLOT_1used with RandomSuffix
9PROP_ENCHANTMENT_SLOT_2used with RandomSuffix and RandomProperty
10PROP_ENCHANTMENT_SLOT_3used with RandomProperty
11PROP_ENCHANTMENT_SLOT_4used with RandomProperty

 

randomPropertyId ​

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)