pvpstats_battlegrounds
This table holds data about BattleGrounds scores.
To enable storing this kind of informations, setBattleground.StoreStatistics.Enable= 1 in worldserver.config 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 | NO |
Description of fields
id
An unique value which identifies a pvpstats record.
winner_faction
The faction which won the BattleGround:
| ID | Name | Commment |
|---|---|---|
| 0 | PVP_TEAM_HORDE | |
| 1 | PVP_TEAM_ALLIANCE | |
| 2 | PVP_TEAM_NEUTRAL | no winner |
bracket_id
Identifies the bracket level range:
| ID | 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
| ID | Name | ID | Name | |
|---|---|---|---|---|
| 1 | Alterac Valley | 8 | Ruins of Lordaeron | |
| 2 | Warsong Gulch | 9 | Strand of the Ancients | |
| 3 | Arathi Basin | 10 | Dalaran Sewers | |
| 4 | Nagrand Arena | 11 | Ring of Valor | |
| 5 | Blade's Edge Arena | 30 | Isle of Conquest | |
| 6 | All Arenas | 32 | Random Battleground | |
| 7 | Eye of the Storm |
date
Unix timestamp of the battleground ending.
