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
| 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 |
|---|---|
| 1 | Alterac Valley |
| 2 | Warsong Gulch |
| 3 | Arathi Basin |
| 7 | Eye of the Storm |
| 9 | Strand of the Ancients |
| 30 | Isle of Conquest |
date
Unix timestamp of the battleground ending.