Character equipmentsets
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
| Строка 13: | Строка 13: | ||
<big>'''Структура'''</big> | <big>'''Структура'''</big> | ||
{| border="1" | {| border="1" | ||
| - | |''' | + | |'''Field''' |
| - | |''' | + | |'''Type''' |
| + | |'''Attributes''' | ||
|'''Null''' | |'''Null''' | ||
| - | |||
|'''Default''' | |'''Default''' | ||
| + | |'''Key''' | ||
| + | |'''Comments''' | ||
|'''Extra''' | |'''Extra''' | ||
|- | |- | ||
| Строка 53: | Строка 55: | ||
| | | | ||
|(NULL) | |(NULL) | ||
| + | | | ||
| + | |- | ||
| + | |[[#ignore_mask|ignore_mask]] | ||
| + | |int(11) | ||
| + | |unsigned | ||
| + | |NO | ||
| + | | | ||
| + | |0 | ||
| + | | | ||
| + | |- | ||
| + | |[[#itemX|item0]] | ||
| + | |int(11) | ||
| + | |unsigned | ||
| + | |NO | ||
| + | | | ||
| + | |0 | ||
| | | | ||
|- | |- | ||
|[[#itemX|item1]] | |[[#itemX|item1]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 63: | Строка 82: | ||
|- | |- | ||
|[[#itemX|item2]] | |[[#itemX|item2]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 70: | Строка 90: | ||
|- | |- | ||
|[[#itemX|item3]] | |[[#itemX|item3]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 77: | Строка 98: | ||
|- | |- | ||
|[[#itemX|item4]] | |[[#itemX|item4]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 84: | Строка 106: | ||
|- | |- | ||
|[[#itemX|item5]] | |[[#itemX|item5]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 91: | Строка 114: | ||
|- | |- | ||
|[[#itemX|item6]] | |[[#itemX|item6]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 98: | Строка 122: | ||
|- | |- | ||
|[[#itemX|item7]] | |[[#itemX|item7]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 105: | Строка 130: | ||
|- | |- | ||
|[[#itemX|item8]] | |[[#itemX|item8]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 112: | Строка 138: | ||
|- | |- | ||
|[[#itemX|item9]] | |[[#itemX|item9]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 119: | Строка 146: | ||
|- | |- | ||
|[[#itemX|item10]] | |[[#itemX|item10]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 126: | Строка 154: | ||
|- | |- | ||
|[[#itemX|item11]] | |[[#itemX|item11]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 133: | Строка 162: | ||
|- | |- | ||
|[[#itemX|item12]] | |[[#itemX|item12]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 140: | Строка 170: | ||
|- | |- | ||
|[[#itemX|item13]] | |[[#itemX|item13]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 147: | Строка 178: | ||
|- | |- | ||
|[[#itemX|item14]] | |[[#itemX|item14]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 154: | Строка 186: | ||
|- | |- | ||
|[[#itemX|item15]] | |[[#itemX|item15]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 161: | Строка 194: | ||
|- | |- | ||
|[[#itemX|item16]] | |[[#itemX|item16]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 168: | Строка 202: | ||
|- | |- | ||
|[[#itemX|item17]] | |[[#itemX|item17]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 175: | Строка 210: | ||
|- | |- | ||
|[[#itemX|item18]] | |[[#itemX|item18]] | ||
| - | | | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
Версия 18:41, 10 июня 2011
|
К описанию таблиц базы данных characters.
Таблица `character_equipmentsets`
Эта таблица используется для описания комплектов экипировки.
Структура
| Field | Type | Attributes | Null | Default | Key | Comments | Extra |
| guid | INT(11) | NO | MUL | 0 | |||
| setguid | BIGINT(20) | NO | PRI | (NULL) | AUTO_INCREMENT | ||
| setindex | TINYINT(4) | NO | 41 | ||||
| NAME | VARCHAR(100) | NO | (NULL) | ||||
| iconname | VARCHAR(100) | NO | (NULL) | ||||
| ignore_mask | int(11) | unsigned | NO | 0 | |||
| item0 | int(11) | unsigned | NO | 0 | |||
| item1 | int(11) | unsigned | NO | 0 | |||
| item2 | int(11) | unsigned | NO | 0 | |||
| item3 | int(11) | unsigned | NO | 0 | |||
| item4 | int(11) | unsigned | NO | 0 | |||
| item5 | int(11) | unsigned | NO | 0 | |||
| item6 | int(11) | unsigned | NO | 0 | |||
| item7 | int(11) | unsigned | NO | 0 | |||
| item8 | int(11) | unsigned | NO | 0 | |||
| item9 | int(11) | unsigned | NO | 0 | |||
| item10 | int(11) | unsigned | NO | 0 | |||
| item11 | int(11) | unsigned | NO | 0 | |||
| item12 | int(11) | unsigned | NO | 0 | |||
| item13 | int(11) | unsigned | NO | 0 | |||
| item14 | int(11) | unsigned | NO | 0 | |||
| item15 | int(11) | unsigned | NO | 0 | |||
| item16 | int(11) | unsigned | NO | 0 | |||
| item17 | int(11) | unsigned | NO | 0 | |||
| item18 | int(11) | unsigned | NO | 0 |
Описание полей
GUID
GUID персонажа. См. characters.guid
setguid
GUID экипировки.
setindex
Поле, в меню управления экипировкой, выбранное под данный комплект экипировки (0-9)
NAME
Название комплекта экипировки
iconname
Название иконки для данного комплекта экипировки.
itemX
GUID предмета в каждом слоте данного комплекта экипировки.См. Item_instance.guid
| Номер слота | Описание |
|---|---|
| 1 | Head |
| 2 | Neck |
| 3 | Shoulders |
| 4 | Body |
| 5 | Chest |
| 6 | Waist |
| 7 | Legs |
| 8 | Feet |
| 9 | Wrists |
| 10 | Hands |
| 11 | Finger 1 |
| 12 | Finger 2 |
| 13 | Trinket 1 |
| 14 | Trinket 2 |
| 15 | Back |
| 16 | Main Hand |
| 17 | Off Hand |
| 18 | Ranged |
