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
guid	int(10)	unsigned	PRI	NO	0	Unique	Global Unique Identifier
account	int(10)	unsigned		NO	0		Account Identifier
name	varchar(12)	signed		NO	NULL
race	tinyint(3)	unsigned		NO	0
class	tinyint(3)	unsigned		NO	0
gender	tinyint(3)	unsigned		NO	0
level	tinyint(3)	unsigned		NO	0
xp	int(10)	unsigned		NO	0
money	int(10)	unsigned		NO	0
playerBytes	int(10)	unsigned		NO	0
playerBytes2	int(10)	unsigned		NO	0
playerFlags	int(10)	unsigned		NO	0
position_x	float	signed		NO	0
position_y	float	signed		NO	0
position_z	float	signed		NO	0
map	smallint(5)	unsigned		NO	0		Map Identifier
instance_id	int(10)	unsigned		NO	0
instance_mode_mask	tinyint(3)	unsigned		NO	0
orientation	float	signed		NO	0
taximask	text	signed		NO	NULL
online	tinyint(3)	unsigned		NO	0
cinematic	tinyint(3)	unsigned		NO	0
totaltime	int(10)	unsigned		NO	0
leveltime	int(10)	unsigned		NO	0
logout_time	int(10)	unsigned		NO	0
is_logout_resting	tinyint(3)	unsigned		NO	0
rest_bonus	float	signed		NO	0
resettalents_cost	int(10)	unsigned		NO	0
resettalents_time	int(0)	unsigned		NO	0
trans_x	float	signed		NO	0
trans_y	float	signed		NO	0
trans_z	float	signed		NO	0
trans_o	float	signed		NO	0
transguid	mediumint(8)	unsigned		NO	0
extra_flags	smallint(5)	unsigned		NO	0
stable_slots	tinyint(3)	unsigned		NO	0
at_login	smallint(5)	unsigned		NO	0
zone	smallint(5)	unsigned		NO	0
death_expire_time	int(10)	unsigned		NO	0
taxi_path	text	signed		YES	NULL
arenaPoints	int(10)	unsigned		NO	0
totalHonorPoints	int(10)	unsigned		NO	0
todayHonorPoints	int(10)	unsigned		NO	0
yesterdayHonorPoints	int(10)	unsigned		NO	0
totalKills	int(10)	unsigned		NO	0
todayKills	smallint(5)	unsigned		NO	0
yesterdayKills	smallint(5)	unsigned		NO	0
chosenTitle	int(10)	unsigned		NO	0
knownCurrencies	bigint(20)	unsigned		NO	0
watchedFaction	int(10)	unsigned		NO	0
drunk	tinyint(3)	unsigned		NO	0
health	int(10)	unsigned		NO	0
power1	int(10)	unsigned		NO	0
power2	int(10)	unsigned		NO	0
power3	int(10)	unsigned		NO	0
power4	int(10)	unsigned		NO	0
power5	int(10)	unsigned		NO	0
power6	int(10)	unsigned		NO	0
power7	int(10)	unsigned		NO	0
latency	mediumint(8)	unsigned		NO	0
speccount	tinyint(3)	unsigned		NO	1
activesp data-base-url=confluenceTdpec	tinyint(3)	unsigned		NO	0
exploredZones	longtext	signed		YES
equipmentCache	longtext	signed		YES
ammoId	int(10)	unsigned		NO	0
knownTitles	longtext	signed		YES
actionBars	tinyint(3)	unsigned		NO	0
grantableLevels	tinyint(3)	unsigned		NO	0
deleteInfos_Account	int(10)	unsigned		YES	NULL
deleteInfos_Name	varchar(12)	unsigned		YES	NULL
deleteDate	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