character_battleground_data
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 | Instance Identifier | |||
| team | smallint | unsigned | NO | ||||
| joinX | float | NO | 0 | ||||
| joinY | float | NO | 0 | ||||
| joinZ | float | NO | 0 | ||||
| joinO | float | NO | 0 | ||||
| joinMapId | smallint | unsigned | NO | 0 | Map Identifier | ||
| taxiStart | int | unsigned | NO | 0 | |||
| taxiEnd | int | unsigned | NO | 0 | |||
| mountSpell | int | unsigned | NO | 0 |
Description of fields
guid
The guid of the character.
instanceId
This is the battleground instanceId. It's shared with instance.id, but instead of putting data in that table, it's here.
team
(0: GM)enum Team (a Faction ID)
| ID | Name |
|---|---|
| 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 before joining a battleground.
joinMapId
Character's last Map ID before joining a battleground.
taxiStart
Character's last TaxiNode ID before joining a battleground.
taxiEnd
Character's heading TaxiNode ID before joining a battleground.
mountSpell
Character's mount Spell ID before joining a battleground.
