pvpstats_players
The `pvpstats_players` table
This table holds datas about BattleGrounds scores. To enable storing this kind of informations, set Battleground.StoreStatistics.Enable = 1 in worldserver.config.dist file.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| battleground_id | BIGINT | UNSIGNED | PRI | NO | |||
| character_guid | INT | UNSIGNED | PRI | NO | |||
| winner | BIT | SIGNED | NO | ||||
| score_killing_blows | MEDIUMINT | UNSIGNED | NO | ||||
| score_deaths | MEDIUMINT | UNSIGNED | NO | ||||
| score_honorable_kills | MEDIUMINT | UNSIGNED | NO | ||||
| score_bonus_honor | MEDIUMINT | UNSIGNED | NO | ||||
| score_damage_done | MEDIUMINT | UNSIGNED | NO | ||||
| score_healing_done | MEDIUMINT | UNSIGNED | NO | ||||
| attr_1 | MEDIUMINT | UNSIGNED | NO | 0 | |||
| attr_2 | MEDIUMINT | UNSIGNED | NO | 0 | |||
| attr_3 | MEDIUMINT | UNSIGNED | NO | 0 | |||
| attr_4 | MEDIUMINT | UNSIGNED | NO | 0 | |||
| attr_5 | MEDIUMINT | UNSIGNED | NO | 0 |
Description of the fields
battleground_id
Link to pvpstats_battlegrounds.id.
character_guid
Link to characters.guid.
winner
1 when player has won the BG, 0 otherwise.
score_*
All scores which are in common between all BattleGrounds.
attr_*
All scores which are not in common between all BattleGrounds. This fields changes their mean according to pvpstats_battlegrounds.type.