Item instance
Материал из YTDB DataBase
(Различия между версиями)
(перевел) |
(→guid: перевел) |
||
| Строка 44: | Строка 44: | ||
<big>'''Описание полей'''</big> | <big>'''Описание полей'''</big> | ||
====guid==== | ====guid==== | ||
| - | + | GUID вещи которая находится в инвентаре, банке, почте или на персонаже. Номер должен быть уникальным. | |
| + | |||
====owner_guid==== | ====owner_guid==== | ||
The GUID of the character who has ownership of this item. See [[characters#guid|characters.guid]] | The GUID of the character who has ownership of this item. See [[characters#guid|characters.guid]] | ||
Версия 09:46, 8 апреля 2010
|
Список таблиц базы characters
Таблица `item_instance`
Таблица содержит информация о всех вещах, которые находятся в почте, банке, инвентаре или одеты на персонаже.
Структура
| Field | Type | Null | Key | Default | Extra |
| guid | int(11) unsigned | NO | PRI | 0 | |
| owner_guid | int(11) unsigned | NO | MUL | 0 | |
| data | longtext | YES |
Описание полей
guid
GUID вещи которая находится в инвентаре, банке, почте или на персонаже. Номер должен быть уникальным.
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
