Item instance

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

(Различия между версиями)
Перейти к: навигация, поиск
 
(6 промежуточных версий не показаны.)
Строка 2: Строка 2:
| __TOC__
| __TOC__
|}
|}
-
Back to [[charactersdb_struct|characters database]] list of tables.
+
[[Category: Mangos characters database tables]]
 +
К описанию таблиц [[Charactersdb_struct|базы данных characters]].
-
<big>'''The `item_instance` table'''</big>
+
<big>'''Таблица `item_instance`'''</big>
-
This table holds individual item instance information for all items currently equipped or in some kind of character bag or bank.
+
Таблица содержит информация о всех вещах, которые находятся в почте, банке, инвентаре или одеты на персонаже.
-
<big>'''Structure'''</big>
+
<big>'''Структура'''</big>
{| border="1"
{| border="1"
|'''Field'''
|'''Field'''
|'''Type'''
|'''Type'''
 +
|'''Attributes'''
|'''Null'''
|'''Null'''
|'''Key'''
|'''Key'''
|'''Default'''
|'''Default'''
-
|'''Extra'''
+
|'''Comments'''
|-
|-
|[[#guid|guid]]
|[[#guid|guid]]
-
|int(11) unsigned
+
|int(11)
 +
|unsigned
|NO
|NO
|PRI
|PRI
Строка 27: Строка 30:
|-
|-
|[[#owner_guid|owner_guid]]
|[[#owner_guid|owner_guid]]
-
|int(11) unsigned
+
|int(11)
 +
|unsigned
|NO
|NO
|MUL
|MUL
Строка 35: Строка 39:
|[[#data|data]]
|[[#data|data]]
|longtext
|longtext
-
|YES
+
|
 +
|
 +
|
 +
|
 +
|-
 +
|[[#text|text]]
 +
|longtext
 +
|
|
|
|
|
Строка 42: Строка 53:
-
<big>'''Description of the fields'''</big>
+
<big>'''Описание полей'''</big>
====guid====
====guid====
-
The GUID of the item. This number is unique for each item instance.
+
GUID вещи которая находится в инвентаре, банке, почте или на персонаже. Номер должен быть уникальным.
 +
 
====owner_guid====
====owner_guid====
-
The GUID of the character who has ownership of this item. See [[characters#guid|characters.guid]]
+
GUID персонажа которому принадлежит данная вещь. Смотри [[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.
 +
====text====
===3.0.9 Item Instance Data Table===
===3.0.9 Item Instance Data Table===
Строка 218: Строка 232:
| 59 || ITEM_FIELD_MAXDURABILITY || Maximum item durability.
| 59 || ITEM_FIELD_MAXDURABILITY || Maximum item durability.
|}
|}
-
 
-
(c)udbwiki
 

Текущая версия на 12:04, 13 февраля 2011

Содержание

К описанию таблиц базы данных characters.


Таблица `item_instance`

Таблица содержит информация о всех вещах, которые находятся в почте, банке, инвентаре или одеты на персонаже.


Структура

Field Type Attributes Null Key Default Comments
guid int(11) unsigned NO PRI 0
owner_guid int(11) unsigned NO MUL 0
data longtext
text longtext


Описание полей

guid

GUID вещи которая находится в инвентаре, банке, почте или на персонаже. Номер должен быть уникальным.

owner_guid

GUID персонажа которому принадлежит данная вещь. Смотри 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.

text

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.
Источник — «http://wiki.ytdb.ru:89/index.php/Item_instance»
Личные инструменты