From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/item_instance.md | 252 ++++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 234 insertions(+), 18 deletions(-) (limited to 'docs/item_instance.md') diff --git a/docs/item_instance.md b/docs/item_instance.md index 8cdea1c..8f255b0 100644 --- a/docs/item_instance.md +++ b/docs/item_instance.md @@ -1,18 +1,234 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [item_instance](item_instance) - -Column | Type | Description ---- | --- | --- -Guid | int(10) unsigned | -ItemEntry | mediumint(8) unsigned | -Owner_guid | int(10) unsigned | -CreatorGuid | int(10) unsigned | -GiftCreatorGuid | int(10) unsigned | -Count | int(10) unsigned | -Duration | int(10) | -Charges | tinytext | -Flags | mediumint(8) unsigned | -Enchantments | text | -RandomPropertyId | smallint(5) | -Durability | smallint(5) unsigned | -PlayedTime | int(10) unsigned | -Text | text | +# item\_instance + +`Back-to:Characters` + +**The \`item\_instance\` table** + +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(10)

unsigned

PRI

NO

0

 

 

itemEntry

mediumint(8)

unsigned

 

NO

0

 

 

owner_guid

int(10)

unsigned

 

NO

0

 

 

creatorGuid

int(10)

unsigned

 

NO

0

 

 

giftCreatorGuid

int(10)

unsigned

 

NO

0

 

 

count

int(10)

unsigned

 

NO

1

 

 

duration

int(10)

unsigned

 

NO

0

 

 

charges

tinytext

signed

 

YES

 

 

 

flags

mediunint(8)

unsigned

 

NO

0

 

 

enchantments

text

signed

 

NO

 

 

 

randomPropertyId

smallint(5)

signed

 

NO

0

 

 

durability

smallint(5)

unsigned

 

NO

0

 

 

playedTime

int(10)

unsigned

 

NO

0

 

 

text

text

signed

 

YES

 

 

 

+ +**Description of the fields** + +### guid + +The GUID of the item. This number is unique for each item instance. + +### itemEnry + +[Item](item_template_2130222.html#item_template-entry) entry. + +### owner\_guid + +The GUID of the character who has ownership of this item. See [characters.guid](2129969.html#characters(table)-guid) + +### creatorGuid + +[GUID](2129969.html#characters(table)-guid) of character who created the item. + +### giftCreatorGuid + +[GUID](2129969.html#characters(table)-guid) of character who created the [item](character_gifts_2129986.html#character_gifts-item_guid). + +### count + +Current number of item copies in the stack. + +### duration + +`field-no-description|6` + +### charges + +`The number of charges for each of the five possible spellcharges on an item,  specified via five space separated integers.` + +### flags + +`field-no-description|8` + +### enchantments + +Enchantments from SpellItemEnchantment.dbc + +### randomPropertyId + +`field-no-description|10` + +### durability + +Current item durability. + +### playedTime + +Time in seconds + +### text + +The text contained in that specific item. + +data-anchor= -- cgit