Skip to content

pvpstats_battlegrounds

This table holds data about BattleGrounds scores.
To enable storing this kind of informations, set Battleground.StoreStatistics.Enable = 1 in worldserver.config file.

Structure ​

FieldTypeAttributesKeyNullDefaultExtraComment
idbigintunsignedPRINOauto_increment
winner_factiontinyintsignedNO
bracket_idtinyintunsignedNO
typetinyintunsignedNO
datedatetimeNO

 

Description of fields ​

id ​

An unique value which identifies a pvpstats record.
 

winner_faction ​

The faction which won the BattleGround:

IDNameCommment
0PVP_TEAM_HORDE
1PVP_TEAM_ALLIANCE
2PVP_TEAM_NEUTRALno winner

 

bracket_id ​

Identifies the bracket level range:

IDRange
110 – 19
220 – 29
330 – 39
440 – 49
550 – 59
660 – 69
770 – 79
880

 

type ​

BattlemasterList ID

IDNameIDName
1Alterac Valley8Ruins of Lordaeron
2Warsong Gulch9Strand of the Ancients
3Arathi Basin10Dalaran Sewers
4Nagrand Arena11Ring of Valor
5Blade's Edge Arena30Isle of Conquest
6All Arenas32Random Battleground
7Eye of the Storm

 

date ​

Unix timestamp of the battleground ending.