Characters

Back to the characters database list of tables.

The `character` 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	Null	Key	Default	Extra
guid	int(11) unsigned	NO	PRI	0
account	int(11) unsigned	NO	MUL	0
data	longtext	YES		None
name	varchar(12)	NO
race	tinyint(3) unsigned	NO		0
class	tinyint(3) unsigned	NO		0
position_x	float	NO		0
position_y	float	NO		0
position_z	float	NO		0
map	int(11) unsigned	NO		0
dungeon_difficulty	tinyint(1) unsigned	NO		0
orientation	float	NO		0
taximask	longtext	YES		None
online	tinyint(3) unsigned	NO	MUL	0
cinematic	tinyint(3) unsigned	NO		0
totaltime	int(11) unsigned	NO		0
leveltime	int(11) unsigned	NO		0
logout_time	int(11)	NO		0
is_logout_resting	tinyint(3)	NO		0
rest_bonus	float	NO		0
resettalents_cost	int(11) unsigned	NO		0
resettalents_time	bigint(20) unsigned	NO		0
trans_x	float	NO		0
trans_y	float	NO		0
trans_z	float	NO		0
trans_o	float	NO		0
transguid	bigint(20) unsigned	NO		0
extra_flags	tinyint(3) unsigned	NO		0
stable_slots	tinyint(1) unsigned	NO		0
at_login	int(11) unsigned	NO		0
zone	int(11) unsigned	NO		0
death_expire_time	bigint(20) unsigned	NO		0
taxi_path	text	YES
arena_pending_points	int(10) unsigned	NO		0
bgid	int(10) unsigned	NO		0
bgteam	int(10) unsigned	NO		0
bgmap	int(10) unsigned	NO		0
bgx	float	NO		0
bgy	float	NO		0
bgz	float	NO		0
bgo	float	NO		0

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 realm database.

data

Big text field holding many different numbers all separated by a space that can be separated into an array with an explode function on the space. Table on what values are stored at what index can be found at character_data

name

The name of the character.

race

The race of the character.

Index	Decimal	Race
1	1	Human
2	2	Orc
3	4	Dwarf
4	8	Night Elf
5	16	Undead
6	32	Tauren
7	64	Gnome
8	128	Troll
10	512	Blood Elf
11	1024	Draenei

class

The class of the character:

position_x

The x position of the character’s location.

position_y

The y position of the character’s location.

position_z

The z position of the character’s location.

map

The map ID the character is in.

dungeon_difficulty

The current difficulty that the player is in.

orientation

The orientation the character is facing. (North = 0.0, South = 3.14159)

taximask

online

Records whether the character is online (1) or offline (0).

cinematic

Boolean 1 or 0 controlling whether the start cinematic has been shown or not.

totaltime

The total time that the character has been active in the world, measured in seconds.

leveltime

The total time the character has spent in the world at the current level, measured in seconds.

logout_time

The time when the character last logged out, measured in Unix time.

is_logout_resting

Boolean 1 or 0 controlling if the character is currently in a resting zone or not.

rest_bonus

resettalents_cost

The cost for the character to reset its talents, measured in copper.

resettalents_time

trans_x

trans_y

trans_z

trans_o

transguid

extra_flags

These flags control certain player specific attributes, mostly GM features

Bit	Name	Description
1	PLAYER_EXTRA_GM_ON	Defines GM state
2	PLAYER_EXTRA_GM_ACCEPT_TICKETS	Defines if tickets are accepted
4	PLAYER_EXTRA_ACCEPT_WHISPERS	Defines if whispers are accepted
8	PLAYER_EXTRA_TAXICHEAT	Sets taxicheat
16	PLAYER_EXTRA_GM_INVISIBLE	Control’s GM’s invisibly
32	PLAYER_EXTRA_GM_CHAT	Show GM badge in chat messages
64	PLAYER_EXTRA_PVP_DEATH	Store PvP death status until corpse creating

stable_slots

The number of stable slots the player has available. Maximum is 2.

at_login

This field is a bitmask controlling different actions taken once a player logs in with the character.

• 1 = Force character to change name
• 2 = Reset spells (professions as well)
• 4 = Reset talents
• 8 = Character Customization enabled

For multiple actions, add values together.

zone

The zone ID the character is in.

death_expire_time

Time when a character can be resurrected in case of a server crash or client exit while in ghost form.

taxi_path

Stores the players current taxi path (TaxiPath.dbc) if logged off while on one.