Item instance
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
| Строка 38: | Строка 38: | ||
|[[#data|data]] | |[[#data|data]] | ||
|longtext | |longtext | ||
| - | | | + | | |
| | | | ||
| | | | ||
| Строка 45: | Строка 45: | ||
|[[#text|text]] | |[[#text|text]] | ||
|longtext | |longtext | ||
| - | | | + | | |
| | | | ||
| | | | ||
Версия 15:50, 5 декабря 2010
|
К описанию таблиц базы данных 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. |
(c)udbwiki
