...
The `character_battleground_data` table
This table holds vital static information for each character in a battleground. This information loaded and used to create the player objects in-gameAlso hold info about their last position before joining the battleground.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment | |
int(10) | unsigned | PRI | NO | 0 |
| Global Unique Identifier | ||
int(10) | unsigned |
| NO | 0 |
| Instance Identifier | ||
smallint(5) | unsigned |
| NO |
|
|
| ||
float | signed |
| NO | 0 |
|
| ||
float | signed |
| NO | 0 |
|
| ||
float | signed |
| NO | 0 |
|
| ||
float | signed |
| NO | 0 |
|
| ||
smallint(5) | unsigned |
| NO | 0 |
|
| taxi_start Map Identifier | |
int(10) | unsigned |
| NO | 0 |
|
| ||
int(10) | unsigned |
| NO | 0 |
|
| ||
mediumint(8) | unsigned |
| NO | 0 |
|
|
Description of the fields
guid
The character global unique identifier. This number must be unique and is the best way to identify separate characters.
instance_id
field-no-description|2
team
field-no-description|3
join_x
field-no-description|4
join_y
field-no-description|5
join_z
field-no-description|6
join_o
field-no-description|7
join_map
field-no-description|8
taxi_start
field-no-description|9
taxi_end
field-no-description|10
mount_spell
field-no-description|11guid. See characters.guid.
instanceId
This is the battleground instanceId. It's shared with instance.id, but instead of putting data in that table, it's here.
team
teamId:
469 - Alliance
67 - Horde
0 - GM
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