pvpstats_players
This table holds data about BattleGrounds scores. To enable storing this kind of informations, set
Battleground.StoreStatistics.Enable= 1 in worldserver.config file.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| battleground_id | bigint | unsigned | PRI | NO | |||
| character_guid | int | unsigned | PRI | NO | |||
| winner | bit(1) | 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 fields
battleground_id
references pvpstats_battlegrounds.id
character_guid
The guid of the participating character.
winner
- 0: my team lost the BG
- 1: i won the BG
score_*
Accumulated statistics, shared among all Battlegrounds.
attr_[1-5]
Accumulated statistics, unique to a battleground type.
| type | Name | attr_1 | attr_2 | attr_3 | attr_4 | attr_5 |
|---|---|---|---|---|---|---|
| 1 | AV | GraveyardsAssaulted | GraveyardsDefended | TowersAssaulted | TowersDefended | MinesCaptured |
| 2 | WSG | FlagCaptures | FlagReturns | 0 | 0 | 0 |
| 3 | AB | BasesAssaulted | BasesDefended | 0 | 0 | 0 |
| 7 | EotS | FlagCaptures | 0 | 0 | 0 | 0 |
| 9 | SotA | DemolishersDestroyed | GatesDestroyed | 0 | 0 | 0 |
| 30 | IoC | BasesAssaulted | BasesDefended | 0 | 0 | 0 |