AzerothCore
Posts (Latest 10 updated) :
Read all

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