blob: 552c8f22a1b9391f6ebc357ab1f02e138baa0979 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
# pvpstats\_battlegrounds
[<-Back-to:Characters](database-characters.md)
**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.dist** file.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| ------------------- | -------- | ---------- | --- | ---- | ------- | -------------- | ------- |
| [id][1] | BIGINT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | |
| [winner_faction][2] | TINYINT | SIGNED | | NO | | | |
| [bracket_id][3] | TINYINT | UNSIGNED | | NO | | | |
| [type][4] | TINYINT | UNSIGNED | | NO | | | |
| [date][5] | DATETIME | SIGNED | | NO | | | |
[1]: #id
[2]: #winnerfaction
[3]: #bracketid
[4]: #type
[5]: #date
**Description of the fields**
### id
An unique value which identifies a BattleGround.
### winner\_faction
The faction which won the BattleGround:
| Value | Description |
| ----- | ----------- |
| 0 | HORDE |
| 1 | ALLIANCE |
| 2 | NONE |
### bracket\_id
Identifies the bracket level range:
| 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 |
### type
The BattleGround type:
| 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 |
### date
Date and time of BattleGround ending.
|
