diff options
| author | FrancescoBorzi <borzifrancesco@gmail.com> | 2019-02-25 19:24:20 +0100 |
|---|---|---|
| committer | FrancescoBorzi <borzifrancesco@gmail.com> | 2019-02-25 19:24:20 +0100 |
| commit | a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 (patch) | |
| tree | 91e0cde00f6f27b730b0df3f4338fcf99fa8447a /docs/character_battleground_data.md | |
| parent | d8d1823802ded97300fa57405d80b16736603489 (diff) | |
| download | wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.gz wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.bz2 wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.zip | |
Import DB wiki from TC 335
Diffstat (limited to 'docs/character_battleground_data.md')
| -rw-r--r-- | docs/character_battleground_data.md | 195 |
1 files changed, 195 insertions, 0 deletions
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** + +<table> +<colgroup> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +</colgroup> +<tbody> +<tr class="odd"> +<td><p><strong>Field</strong></p></td> +<td><p><strong>Type</strong></p></td> +<td><p><strong>Attributes</strong></p></td> +<td><p><strong>Key</strong></p></td> +<td><p><strong>Null</strong></p></td> +<td><p><strong>Default</strong></p></td> +<td><p><strong>Extra</strong></p></td> +<td><p><strong>Comment</strong></p></td> +</tr> +<tr class="even"> +<td><p><a href="#character_battleground_data-guid">guid</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p>Global Unique Identifier</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#character_battleground_data-instanceId">instanceId</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p>Instance Identifier</p></td> +</tr> +<tr class="even"> +<td><p><a href="#character_battleground_data-team">team</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p> </p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#character_battleground_data-joinX">joinX</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#character_battleground_data-joinY">joinY</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#character_battleground_data-joinZ">joinZ</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#character_battleground_data-joinO">joinO</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#character_battleground_data-joinMapId">joinMapId</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p>Map Identifier</p></td> +</tr> +<tr class="even"> +<td><p><a href="#character_battleground_data-taxiStart">taxiStart</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#character_battleground_data-taxiEnd">taxiEnd</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#character_battleground_data-mountSpell">mountSpell</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +</tbody> +</table> + +**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 |
