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
id	bigint	unsigned	PRI	NO
winner_faction	tinyint			NO
bracket_id	tinyint	unsigned		NO
type	tinyint	unsigned		NO
date	datetime			NO
date	datetime			NO
date	datetime			NO
date	datetime			NO
date	datetime			NO
date	datetime			NO
date	datetime			NO
date	datetime			NO
date	datetime			NO

Description of the fields

id

An unique value which identifies a BattleGround.

winner_faction

The faction which won the BattleGround:

0 = HORDE

1 = ALLIANCE

2 = NOONE

bracket_id

Identifies the bracket level range:

1 = 10-19

2 = 20-29

3 = 30-39

4 = 40-49

5 = 50-59

6 = 60-69

7 = 70-79

8 = 80

type

The BattleGround type:

1 = Alterac Valley

2 = Warsong Gulch

3 = Arathi Basin

7 = Eye of the Storm

9 = Strand of the Ancients

30 = Isle of Conquest

date

Date and time of BattleGround ending.