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

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
battleground_id	bigint	unsigned	PRI	NO
character_guid	int	unsigned	PRI	NO
win	bit
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