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

Faction ID

• 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 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.