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
The character guid. See characters.guid.
This is the battleground instanceId. It's shared with instance.id, but instead of putting data in that table, it's here.
teamId:
| ID | Description |
|---|---|
| 0 | GM |
| 67 | Horde |
| 469 | Alliance |
Character's last X position before joining a battleground.
Character's last Y position before joining a battleground.
Character's last Z position before joining a battleground.
Character's last orientation bbefore joining a battleground.
Character's last mapId before joining a battleground.
Character's last taxi node before joining a battleground.
Character's heading taxi node before joining a battleground.
The mount spell ID. See Spell.dbc column 1