Back to 'instance_reset' Return to characters Go to 'item_loot_items'
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.
| 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 |
The GUID of the item. This number is unique for each item instance.
The item entry this copy was derived from.
The character guid who has ownership of this item.
The character guid who created this item, if any.
Displayed on the bottom of an items tooltip.
The character guid who created this gift, if any.
Current number of item copies out of stackable in the stack.
Remaining item duration in sec.
The number of charges for each of the five possible spellcharges on an item, specified via five space separated integers.
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) |
Stores all enchantments as 12 space separated 3-tuples of [EnchantmentId duration charges]. EnchantmentId is index of SpellItemEnchantment.dbc.
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 |
Remaining item MaxDurability.
Stores the age of the item in seconds. (governs refundability)
Player composed text on readable item. (see Plain Letter, created by mail system)
Back to 'instance_reset' Return to characters Go to 'item_loot_items'