Characters - cmangos/issues GitHub Wiki

Back to the characters database list of tables.

This table holds vital static information for each character. This information loaded and used to create the player objects in-game.

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

The character global unique identifier. This number must be unique and is the best way to identify separate characters.

The account ID in which this character resides. See account.id in the realm database.

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

The name of the character.

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

The class of the character:

Index	Class
1	Warrior
2	Paladin
3	Hunter
4	Rogue
5	Priest
7	Shaman
8	Mage
9	Warlock
11	Druid

The x position of the character’s location.

The y position of the character’s location.

The z position of the character’s location.

The map ID the character is in.

The current difficulty that the player is in.

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

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

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

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

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

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

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

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

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

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

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.

The zone ID the character is in.

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

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