Item instance

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

(Различия между версиями)
Перейти к: навигация, поиск
м (Новая страница: «{| align="right" | __TOC__ |} Back to characters database list of tables. <big>'''The `item_instance` table'''</big> This table holds indi…»)
Строка 46: Строка 46:
The GUID of the item. This number is unique for each item instance.
The GUID of the item. This number is unique for each item instance.
====owner_guid====
====owner_guid====
-
The GUID of the character who has ownership of this item. See [[character#guid|character.guid]]
+
The GUID of the character who has ownership of this item. See [[characters#guid|characters.guid]]
====data====
====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.
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.
Строка 71: Строка 71:
| 8 || ITEM_FIELD_CONTAINED || If the item is in a bag, the GUID of the bag item; otherwise 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 || [[character#guid|GUID]] of character who created the item.
+
| 10 || ITEM_FIELD_CREATOR || [[characters#guid|GUID]] of character who created the item.
|-
|-
-
| 12 || ITEM_FIELD_GIFTCREATOR || [[character#guid|GUID]] of character who created the [[character_gifts#item_guid|item]].
+
| 12 || ITEM_FIELD_GIFTCREATOR || [[characters#guid|GUID]] of character who created the [[character_gifts#item_guid|item]].
|-
|-
| 14 || ITEM_FIELD_STACK_COUNT || Current number of item copies in the stack.
| 14 || ITEM_FIELD_STACK_COUNT || Current number of item copies in the stack.
Строка 194: Строка 194:
| 8 || ITEM_FIELD_CONTAINED || If the item is in a bag, the GUID of the bag item; otherwise 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 || [[character#guid|GUID]] of character who created the item.
+
| 10 || ITEM_FIELD_CREATOR || [[characters#guid|GUID]] of character who created the item.
|-
|-
-
| 12 || ITEM_FIELD_GIFTCREATOR || [[character#guid|GUID]] of character who created the [[character_gifts#item_guid|item]].
+
| 12 || ITEM_FIELD_GIFTCREATOR || [[characters#guid|GUID]] of character who created the [[character_gifts#item_guid|item]].
|-
|-
| 14 || ITEM_FIELD_STACK_COUNT || Current number of item copies in the stack.
| 14 || ITEM_FIELD_STACK_COUNT || Current number of item copies in the stack.

Версия 05:55, 11 марта 2010

Содержание

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

Источник — «http://wiki.ytdb.ru:89/index.php/Item_instance»
Личные инструменты