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 |
bigint | unsigned | PRI | NO |
|
|
| |
tinyint |
| NO |
|
|
| ||
tinyint | unsigned |
| NO |
|
|
| |
tinyint | unsigned |
| NO |
|
|
| |
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.