AzerothCore
Pages :

pvpstats_players

<-Back-to:Characters

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.

Table 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.