character_battleground_data

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

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

instanceId

int(10)

unsigned

 

NO

0

 

Instance Identifier

team

smallint(5)

unsigned

 

NO

 

 

 

joinX

float

signed

 

NO

0

 

 

joinY

float

signed

 

NO

0

 

 

joinZ

float

signed

 

NO

0

 

 

joinO

float

signed

 

NO

0

 

 

joinMapId

smallint(5)

unsigned

 

NO

0

 

Map Identifier

taxiStart

int(10)

unsigned

 

NO

0

 

 

taxiEnd

int(10)

unsigned

 

NO

0

 

 

mountSpell

mediumint(8)

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:

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