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.