character_battleground_data
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 | INT | UNSIGNED | PRI | NO | 0 | Global Unique Identifier | |
| instanceId | INT | UNSIGNED | NO | 0 | Instance Identifier | ||
| team | SMALLINT | UNSIGNED | NO | ||||
| joinX | FLOAT | SIGNED | NO | 0 | |||
| joinY | FLOAT | SIGNED | NO | 0 | |||
| joinZ | FLOAT | SIGNED | NO | 0 | |||
| joinO | FLOAT | SIGNED | NO | 0 | |||
| joinMapId | SMALLINT | UNSIGNED | NO | 0 | Map Identifier | ||
| taxiStart | INT | UNSIGNED | NO | 0 | |||
| taxiEnd | INT | UNSIGNED | NO | 0 | |||
| mountSpell | MEDIUMINT | UNSIGNED | NO | 0 |
Description of the fields
guid
The character guid. 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:
| 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