characters (table)
Back-to:Characters
The `characters` table
This table holds vital static information for each character. This information loaded and used to create the player objects in-game.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
int(10) | unsigned | PRI | NO | 0 | Unique | Global Unique Identifier | |
int(10) | unsigned | NO | 0 | Account Identifier | |||
varchar(12) | signed | NO | NULL | ||||
tinyint(3) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
float | signed | NO | 0 | ||||
float | signed | NO | 0 | ||||
float | signed | NO | 0 | ||||
smallint(5) | unsigned | NO | 0 | Map Identifier | |||
int(10) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 | ||||
float | signed | NO | 0 | ||||
text | signed | NO | NULL | ||||
tinyint(3) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 | ||||
float | signed | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(0) | unsigned | NO | 0 | ||||
float | signed | NO | 0 | ||||
float | signed | NO | 0 | ||||
float | signed | NO | 0 | ||||
float | signed | NO | 0 | ||||
mediumint(8) | unsigned | NO | 0 | ||||
smallint(5) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 | ||||
smallint(5) | unsigned | NO | 0 | ||||
smallint(5) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
text | signed | YES | NULL | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
smallint(5) | unsigned | NO | 0 | ||||
smallint(5) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
bigint(20) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
mediumint(8) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 1 | ||||
tinyint(3) | unsigned | NO | 0 | ||||
longtext | signed | YES | |||||
longtext | signed | YES | |||||
int(10) | unsigned | NO | 0 | ||||
longtext | signed | YES | |||||
tinyint(3) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 | ||||
int(10) | unsigned | YES | NULL | ||||
varchar(12) | unsigned | YES | NULL | ||||
int(10) | signed | YES | NULL |
Description of the fields
guid
The character global unique identifier. This number must be unique and is the best way to identify separate characters.
account
The account ID in which this character resides. See account.id. in the auth database.
name
The name of the character.
race
The race of the character. See ChrRaces.dbc
class
The class of the character: ChrClasses.dbc
gender
The gender of the character. 0 = Male, 1 = Female, 2 = Unknown
level
The level of the character.
xp
The amount of experience this character has earned towards the next level.
money
The amount of copper this character has.
playerBytes
contains data about the skincolor,facestyle,hairstyle and haircolor of the character
- skinColor = playerbytes % 256
- faceStyle = (playerbytes >> 8) % 256
- hairStyle = (playerbytes >> 16) % 256
- hairColor = (playerbytes >> 24) % 256
playerBytes2
data about facial hair
- facialHair = playerBytes2 % 256
playerFlags
A bitmask that represents what Player flags the player has. Each bit controls a different flag and to combine flags, you can add each flag that you want, in effect activating the respective bits.
Flag | Name | Comment | |
---|---|---|---|
1 | 0x00000001 | PLAYER_FLAGS_GROUP_LEADER | |
2 | 0x00000002 | PLAYER_FLAGS_AFK | |
4 | 0x00000004 | PLAYER_FLAGS_DND | |
8 | 0x00000008 | PLAYER_FLAGS_GM | |
16 | 0x00000010 | PLAYER_FLAGS_GHOST | |
32 | 0x00000020 | PLAYER_FLAGS_RESTING | |
64 | 0x00000040 | PLAYER_FLAGS_UNK7 | |
128 | 0x00000080 | PLAYER_FLAGS_UNK8 | pre-3.0.3 PLAYER_FLAGS_FFA_PVP flag for FFA PVP state |
256 | 0x00000100 | PLAYER_FLAGS_CONTESTED_PVP | Player has been involved in a PvP combat and will be attacked by contested guards |
512 | 0x00000200 | PLAYER_FLAGS_IN_PVP | |
1024 | 0x00000400 | PLAYER_FLAGS_HIDE_HELM | |
2048 | 0x00000800 | PLAYER_FLAGS_HIDE_CLOAK | |
4096 | 0x00001000 | PLAYER_FLAGS_PLAYED_LONG_TIME | played long time |
8192 | 0x00002000 | PLAYER_FL |