Character equipmentsets
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
Строка 44: | Строка 44: | ||
| | | | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 53: | Строка 53: | ||
| | | | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 62: | Строка 62: | ||
| | | | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 71: | Строка 71: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 80: | Строка 80: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 89: | Строка 89: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 98: | Строка 98: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 107: | Строка 107: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 116: | Строка 116: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 125: | Строка 125: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 134: | Строка 134: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 143: | Строка 143: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 152: | Строка 152: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 161: | Строка 161: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 170: | Строка 170: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 179: | Строка 179: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 188: | Строка 188: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 197: | Строка 197: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 206: | Строка 206: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 215: | Строка 215: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 224: | Строка 224: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 233: | Строка 233: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | | ||
Строка 242: | Строка 242: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
- | |||
|0 | |0 | ||
+ | | | ||
| | | | ||
| | | |
Версия 18:49, 10 июня 2011
|
К описанию таблиц базы данных characters.
Таблица `character_equipmentsets`
Эта таблица используется для описания комплектов экипировки.
Структура
Field | Type | Attributes | Null | Default | Key | Comments | Extra |
guid | int(11) | NO | 0 | MUL | |||
setguid | bigint(20) | NO | 0 | PRI | AUTO_INCREMENT | ||
setindex | tinyint(4) | NO | 0 | ||||
name | varchar(100) | NO | 0 | ||||
iconname | varchar(100) | NO | 0 | ||||
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 |