Pvpstats players
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) (Новая страница: «{| align="right" | __TOC__ |} Category: Mangos characters database tables К описанию таблиц [[Charactersdb_struct|базы данных characters…») |
NeatElves (Обсуждение | вклад) |
||
| Строка 6: | Строка 6: | ||
| - | <big>'''Таблица ` | + | <big>'''Таблица `pvpstats_players`'''</big> |
| Строка 22: | Строка 22: | ||
|'''Comments''' | |'''Comments''' | ||
|- | |- | ||
| - | |[[# | + | |[[#battleground_id|battleground_id]] |
|bigint(20) | |bigint(20) | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
|PRI | |PRI | ||
| - | | | + | | |
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#character_guid|character_guid]] |
| - | | | + | |int(10) |
| + | |unsigned | ||
| + | |NO | ||
| + | |PRI | ||
| | | | ||
| + | | | ||
| + | |- | ||
| + | |[[#score_killing_blows|score_killing_blows]] | ||
| + | |mediumint(8) | ||
| + | |unsigned | ||
| + | |NO | ||
| + | | | ||
| + | | | ||
| + | | | ||
| + | |- | ||
| + | |[[#score_deaths|score_deaths]] | ||
| + | |mediumint(8) | ||
| + | |unsigned | ||
| + | |NO | ||
| + | | | ||
| + | | | ||
| + | | | ||
| + | |- | ||
| + | |[[#score_honorable_kills|score_honorable_kills]] | ||
| + | |mediumint(8) | ||
| + | |unsigned | ||
| + | |NO | ||
| + | | | ||
| + | | | ||
| + | | | ||
| + | |- | ||
| + | |[[#score_bonus_honor|score_bonus_honor]] | ||
| + | |mediumint(8) | ||
| + | |unsigned | ||
| + | |NO | ||
| + | | | ||
| + | | | ||
| + | | | ||
| + | |- | ||
| + | |[[#score_damage_done|score_damage_done]] | ||
| + | |mediumint(8) | ||
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 38: | Строка 78: | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#score_healing_done|score_healing_done]] |
| - | | | + | |mediumint(8) |
|unsigned | |unsigned | ||
|NO | |NO | ||
| Строка 46: | Строка 86: | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#attr_1|attr_1]] |
| - | | | + | |mediumint(8) |
|unsigned | |unsigned | ||
|NO | |NO | ||
Версия 21:58, 16 декабря 2016
|
К описанию таблиц базы данных characters.
Таблица `pvpstats_players`
Таблица содержит информацию о статусе игрока на БГ.
Структура
| Field | Type | Attributes | Null | Key | Default | Comments |
| battleground_id | bigint(20) | unsigned | NO | PRI | ||
| character_guid | int(10) | unsigned | NO | PRI | ||
| score_killing_blows | mediumint(8) | unsigned | NO | |||
| score_deaths | mediumint(8) | unsigned | NO | |||
| score_honorable_kills | mediumint(8) | unsigned | NO | |||
| score_bonus_honor | mediumint(8) | unsigned | NO | |||
| score_damage_done | mediumint(8) | unsigned | NO | |||
| score_healing_done | mediumint(8) | unsigned | NO | |||
| attr_1 | mediumint(8) | unsigned | NO | |||
| date | datetime | NO |
Описание полей
