blob: 7f6c67d04f3917f865644ff1834d15ac344dcfa1 (
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
|
# pvpstats\_players
[<-Back-to:Characters](database-characters.md)
**The \`pvpstats\_players\` 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 |
| -------------------------- | --------- | ---------- | --- | ---- | ------- | ----- | ------- |
| [battleground_id][1] | BIGINT | UNSIGNED | PRI | NO | | | |
| [character_guid][2] | INT | UNSIGNED | PRI | NO | | | |
| [winner][3] | BIT | SIGNED | | NO | | | |
| [score_killing_blows][4] | MEDIUMINT | UNSIGNED | | NO | | | |
| [score_deaths][5] | MEDIUMINT | UNSIGNED | | NO | | | |
| [score_honorable_kills][6] | MEDIUMINT | UNSIGNED | | NO | | | |
| [score_bonus_honor][7] | MEDIUMINT | UNSIGNED | | NO | | | |
| [score_damage_done][8] | MEDIUMINT | UNSIGNED | | NO | | | |
| [score_healing_done][9] | MEDIUMINT | UNSIGNED | | NO | | | |
| [attr_1][10] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
| [attr_2][11] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
| [attr_3][12] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
| [attr_4][13] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
| [attr_5][14] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
[1]: #battlegroundid
[2]: #characterguid
[3]: #winner
[4]: #score
[5]: #score
[6]: #score
[7]: #score
[8]: #score
[9]: #score
[10]: #attr
[11]: #attr
[12]: #attr
[13]: #attr
[14]: #attr
**Description of the fields**
### battleground\_id
Link to [pvpstats\_battlegrounds.id](pvpstats_battlegrounds#id).
### character\_guid
Link to [characters.guid](characters#guid).
### winner
1 when player has won the BG, 0 otherwise.
### score\_\*
All scores which are in common between all BattleGrounds.
### attr\_\*
All scores which are not in common between all BattleGrounds. This fields changes their mean according to [pvpstats\_battlegrounds.type](pvpstats_battlegrounds#type).
|
