Back to 'pool_quest_save' Return to characters Go to 'pvpstats_players'
This table holds data about BattleGrounds scores.
To enable storing this kind of informations, setBattleground.StoreStatistics.Enable= 1 in worldserver.config file.
| 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 |
An unique value which identifies a pvpstats record.
The faction which won the BattleGround:
| ID | Name | Commment |
|---|---|---|
| 0 | PVP_TEAM_HORDE | |
| 1 | PVP_TEAM_ALLIANCE | |
| 2 | PVP_TEAM_NEUTRAL | no winner |
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 |
| 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 |
Unix timestamp of the battleground ending.
Back to 'pool_quest_save' Return to characters Go to 'pvpstats_players'