Back-to:Characters
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 |
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 |
| Map Identifier | |
int(10) | unsigned |
| NO | 0 |
|
| |
int(10) | unsigned |
| NO | 0 |
|
| |
mediumint(8) | 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:
469 - Alliance
67 - Horde
0 - GM
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