Item instance

Материал из YTDB DataBase

Содержание 1 guid 2 owner_guid 3 data 4 3.0.9 Item Instance Data Table 5 2.4.3 Item Instance Data Table

Back to characters database list of tables.

The `item_instance` table

This table holds individual item instance information for all items currently equipped or in some kind of character bag or bank.

Structure

Field	Type	Null	Key	Default	Extra
guid	int(11) unsigned	NO	PRI	0
owner_guid	int(11) unsigned	NO	MUL	0
data	longtext	YES

Description of the fields

guid

The GUID of the item. This number is unique for each item instance.

owner_guid

The GUID of the character who has ownership of this item. See characters.guid

data

Much like the data field in the character 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.

3.0.9 Item Instance Data Table

This table was last updated for 3.0.9 values.

Index	Value Name	Comments
0	OBJECT_FIELD_GUID	Item GUID
2	OBJECT_FIELD_TYPE	Should be 3 (TYPE_OBJECT + TYPE_ITEM)
3	OBJECT_FIELD_ENTRY	Item template entry
4	OBJECT_FIELD_SCALE_X	1.0
5	OBJECT_FIELD_PADDING
6	ITEM_FIELD_OWNER	Same value as 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.
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
21	ITEM_FIELD_FLAGS	Stores items Flags (from item_template)
22	ITEM_FIELD_ENCHANTMENT_PERM_ID
23	ITEM_FIELD_ENCHANTMENT_PERM_DURATION
24	ITEM_FIELD_ENCHANTMENT_PERM_CHARGES
22	ITEM_FIELD_ENCHANTMENT_PERM_ID	Permanent enchantment.
23	ITEM_FIELD_ENCHANTMENT_PERM_DURATION
24	ITEM_FIELD_ENCHANTMENT_PERM_CHARGES
25	ITEM_FIELD_ENCHANTMENT_TEMP_ID	Temporary enchantment.
26	ITEM_FIELD_ENCHANTMENT_TEMP_DURATION
27	ITEM_FIELD_ENCHANTMENT_TEMP_CHARGES
28	ITEM_FIELD_ENCHANTMENT_SOCK_1_ID	Socket 1 enchantment.
29	ITEM_FIELD_ENCHANTMENT_SOCK_1_DURATION
30	ITEM_FIELD_ENCHANTMENT_SOCK_1_CHARGES
31	ITEM_FIELD_ENCHANTMENT_SOCK_2_ID	Socket 2 enchantment.
32	ITEM_FIELD_ENCHANTMENT_SOCK_2_DURATION
33	ITEM_FIELD_ENCHANTMENT_SOCK_2_CHARGES
34	ITEM_FIELD_ENCHANTMENT_SOCK_3_ID	Socket 3 enchantment.
35	ITEM_FIELD_ENCHANTMENT_SOCK_3_DURATION
36	ITEM_FIELD_ENCHANTMENT_SOCK_3_CHARGES
37	ITEM_FIELD_ENCHANTMENT_BONUS_ID
38	ITEM_FIELD_ENCHANTMENT_BONUS_DURATION
39	ITEM_FIELD_ENCHANTMENT_BONUS_CHARGES
40	ITEM_FIELD_ENCHANTMENT_PRISMATIC_ID	Special permanent enchantment.
41	ITEM_FIELD_ENCHANTMENT_PRISMATIC_DURATION
42	ITEM_FIELD_ENCHANTMENT_PRISMATIC_CHARGES
43	ITEM_FIELD_ENCHANTMENT_PROP_1_ID	Used with RandomSuffix.
44	ITEM_FIELD_ENCHANTMENT_PROP_1_DURATION
45	ITEM_FIELD_ENCHANTMENT_PROP_1_CHARGES
46	ITEM_FIELD_ENCHANTMENT_PROP_2_ID	Used with RandomSuffix.
47	ITEM_FIELD_ENCHANTMENT_PROP_2_DURATION
48	ITEM_FIELD_ENCHANTMENT_PROP_2_CHARGES
49	ITEM_FIELD_ENCHANTMENT_PROP_3_ID	Used with RandomSuffix and RandomProperty.
50	ITEM_FIELD_ENCHANTMENT_PROP_3_DURATION
51	ITEM_FIELD_ENCHANTMENT_PROP_3_CHARGES
52	ITEM_FIELD_ENCHANTMENT_PROP_4_ID	Used with RandomProperty.
53	ITEM_FIELD_ENCHANTMENT_PROP_4_DURATION
54	ITEM_FIELD_ENCHANTMENT_PROP_4_CHARGES
55	ITEM_FIELD_ENCHANTMENT_PROP_5_ID	Used with RandomProperty.
56	ITEM_FIELD_ENCHANTMENT_PROP_5_DURATION
57	ITEM_FIELD_ENCHANTMENT_PROP_5_CHARGES
58	ITEM_FIELD_PROPERTY_SEED	Also called ITEM_FIELD_SUFFIX_FACTOR
59	ITEM_FIELD_RANDOM_PROPERTIES_ID
60	ITEM_FIELD_ITEM_TEXT_ID	Text id used and shown by the item.
61	ITEM_FIELD_DURABILITY	Current item durability.
62	ITEM_FIELD_MAXDURABILITY	Maximum item durability.
63	ITEM_FIELD_PAD

2.4.3 Item Instance Data Table

This table was last updated for 2.4.3 values.

Index	Value Name	Comments
0	OBJECT_FIELD_GUID	Item GUID
2	OBJECT_FIELD_TYPE	Should be 3 (TYPE_OBJECT + TYPE_ITEM)
3	OBJECT_FIELD_ENTRY	Item template entry
4	OBJECT_FIELD_SCALE_X	1.0
5	OBJECT_FIELD_PADDING
6	ITEM_FIELD_OWNER	Same value as 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.
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
21	ITEM_FIELD_FLAGS	Stores items Flags (from item_template)
22	ITEM_FIELD_ENCHANTMENT
55	ITEM_FIELD_PROPERTY_SEED	Also called ITEM_FIELD_SUFFIX_FACTOR
56	ITEM_FIELD_RANDOM_PROPERTIES_ID
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.

(c)udbwiki