blob: 09f18864b32ff1adfa9eabb86231cf4dfa7b0469 (
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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
# character\_battleground\_data
[<-Back-to:Characters](database-characters.md)
**The \`character\_battleground\_data\` table**
This table holds information for each character in a battleground. Also hold info about their last position before joining the battleground.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|------------------|--------------|------------|-----|------|---------|-------|--------------------------|
| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier |
| [instanceId][2] | INT | UNSIGNED | | NO | 0 | | Instance Identifier |
| [team][3] | SMALLINT | UNSIGNED | | NO | | | |
| [joinX][4] | FLOAT | SIGNED | | NO | 0 | | |
| [joinY][5] | FLOAT | SIGNED | | NO | 0 | | |
| [joinZ][6] | FLOAT | SIGNED | | NO | 0 | | |
| [joinO][7] | FLOAT | SIGNED | | NO | 0 | | |
| [joinMapId][8] | SMALLINT | UNSIGNED | | NO | 0 | | Map Identifier |
| [taxiStart][9] | INT | UNSIGNED | | NO | 0 | | |
| [taxiEnd][10] | INT | UNSIGNED | | NO | 0 | | |
| [mountSpell][11] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
[1]: #guid
[2]: #instanceid
[3]: #team
[4]: #joinx
[5]: #joiny
[6]: #joinz
[7]: #joino
[8]: #joinmapid
[9]: #taxistart
[10]: #taxiend
[11]: #mountspell
**Description of the fields**
### guid
The character guid. See [characters.guid](2129969.html#characters(table)-id).
### instanceId
This is the battleground instanceId. It's shared with [instance.id](instance_2130197.html#instance-id), but instead of putting data in that table, it's here.
### team
teamId:
| ID | Description |
|-----|-------------|
| 0 | GM |
| 67 | Horde |
| 469 | Alliance |
### joinX
Character's last X position before joining a battleground.
### joinY
Character's last Y position before joining a battleground.
### joinZ
Character's last Z position before joining a battleground.
### joinO
Character's last orientation bbefore joining a battleground.
### joinMapId
Character's last mapId before joining a battleground.
### taxiStart
Character's last taxi node before joining a battleground.
### taxiEnd
Character's heading taxi node before joining a battleground.
### mountSpell
The mount spell ID. See Spell.dbc column 1
|
