`pvpstats_battlegrounds` 表
此表保存关于战场(BattleGround)得分的数据。要启用此类信息的存储,请在 worldserver.config.dist 文件中设置 Battleground.StoreStatistics.Enable = 1。
表结构
| 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 | SIGNED | NO |
字段说明
标识某个战场(BattleGround)的唯一值。
赢得战场的阵营:
| Value | Description |
|---|---|
| 0 | HORDE |
| 1 | ALLIANCE |
| 2 | NONE |
标识分组等级范围:
| Value | 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 |
战场类型:
| Value | Description |
|---|---|
| 1 | Alterac Valley |
| 2 | Warsong Gulch |
| 3 | Arathi Basin |
| 7 | Eye of the Storm |
| 9 | Strand of the Ancients |
| 30 | Isle of Conquest |
战场结束的日期和时间。