目录

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

Structure

Field Type Attributes Key Null Default Extra Comment
id BIGINT UNSIGNED PRI NO AUTO_INCREMENT
winner_faction TINYINT SIGNED NO
bracket_id TINYINT UNSIGNED NO
type TINYINT UNSIGNED NO
date DATETIME SIGNED NO

Description of the fields

id

An unique value which identifies a BattleGround.

winner_faction

The faction which won the BattleGround:

Value Description
0 HORDE
1 ALLIANCE
2 NONE

bracket_id

Identifies the bracket level range:

Value 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:

Value Description
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.