pvpstats_battlegrounds

Back-to:Characters

The `pvpstats_battlegrounds` 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

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.