From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/character_battleground_data.md | 195 ++++++++++++++++++++++++++++++++++++ 1 file changed, 195 insertions(+) create mode 100644 docs/character_battleground_data.md (limited to 'docs/character_battleground_data.md') diff --git a/docs/character_battleground_data.md b/docs/character_battleground_data.md new file mode 100644 index 0000000..d7961d3 --- /dev/null +++ b/docs/character_battleground_data.md @@ -0,0 +1,195 @@ +# 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](2129969.html#characters(table)-id). + +### instanceId + +This is the battleground instanceId. It's shared with [instance.id](instance_2130197.html#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 -- cgit