# 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](account_2130004.html#account-id). in the auth database. ### name The name of the character. ### race The race of the character. See [ChrRaces.dbc](ChrRaces) ### class The class of the character: [ChrClasses.dbc](https://trinitycore.atlassian.net/wiki/display/tc/ChrClasses) ### gender The gender of the character. 0 = Male, 1 = Female, 2 = Unknown![(question)](images/icons/emoticons/help_16.png){.emoticon .emoticon-question} ### 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
256	0x00000100	PLAYER_FLAGS_CONTESTED_PVP
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
8192	0x00002000	PLAYER_FLAGS_TOO_LONG
16384	0x00004000	PLAYER_FLAGS_IS_OUT_OF_BOUNDS
32768	0x00008000	PLAYER_FLAGS_DEVELOPER
65536	0x00010000	PLAYER_FLAGS_UNK17
131072	0x00020000	PLAYER_FLAGS_TAXI_BENCHMARK
262144	0x00040000	PLAYER_FLAGS_PVP_TIMER
524288	0x00080000	PLAYER_FLAGS_UNK20
1048576	0x00100000	PLAYER_FLAGS_UNK21
2097152	0x00200000	PLAYER_FLAGS_UNK22
4194304	0x00400000	PLAYER_FLAGS_COMMENTATOR2
8388608	0x00800000	PLAYER_ALLOW_ONLY_ABILITY
16777216	0x01000000	PLAYER_FLAGS_UNK25
33554432	0x02000000	PLAYER_FLAGS_NO_XP_GAIN

### 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. ### instance\_id The instance ID the character is currently in and bound to ### instance\_mode\_mask The current dungeon difficulty that the player is in. This field is bitmask. Values are put together, however, only two of four should be used at once. This description may not be 100% correct.

Flag	Comment
0	Normal
1	Heroic
16	10 man
32	25 man

### orientation The orientation the character is facing. (North = 0.0, South = 3.14159) ### taximask Known taxi nodes separated with space ### 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 The cumulated bonus of rested rate for gaining experience. ### resettalents\_cost The cost for the character to reset its talents, measured in copper. ### resettalents\_time `field-no-description|30` ### trans\_x The x position of the transport this character was on when they were last saved. ### trans\_y The y position of the transport this character was on when they were last saved. ### trans\_z The z position of the transport this character was on when they were last saved. ### trans\_o The orientation of the transport this character was on when they were last saved. ### transguid The global unique identifier of the transport this character was on when they were last saved. ### extra\_flags These flags control certain player specific attributes, mostly GM features

Flag	Name	Description
1	0x00000001	PLAYER_EXTRA_GM_ON
2	0x00000002	PLAYER_EXTRA_GM_ACCEPT_TICKETS
4	0x00000004	PLAYER_EXTRA_ACCEPT_WHISPERS
8	0x00000008	PLAYER_EXTRA_TAXICHEAT
16	0x00000010	PLAYER_EXTRA_GM_INVISIBLE
32	0x00000020	PLAYER_EXTRA_GM_CHAT
64	0x00000040	PLAYER_EXTRA_HAS_310_FLYER
256	0x00000100	PLAYER_EXTRA_PVP_DEATH

### stable\_slots The Stable Slots available (bought) at the Stable Master. ### at\_login This field is a bitmask controlling different actions taken once a player logs in with the character. | Flag | Name | Description | |------|------|--------------------------------| | 1 | 0x01 | AT\_LOGIN\_RENAME | | 2 | 0x02 | AT\_LOGIN\_RESET\_SPELLS | | 4 | 0x04 | AT\_LOGIN\_RESET\_TALENTS | | 8 | 0x08 | AT\_LOGIN\_CUSTOMIZE | | 16 | 0x10 | AT\_LOGIN\_RESET\_PET\_TALENTS | | 32 | 0x20 | AT\_LOGIN\_FIRST | | 64 | 0x40 | AT\_LOGIN\_CHANGE\_FACTION | | 128 | 0x80 | AT\_LOGIN\_CHANGE\_RACE | 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, measured in Unix time. ### taxi\_path Stores the players current taxi path ([TaxiPath.dbc](TaxiPath)) if logged off while on one. ### arenaPoints The amount of arena points this character has stored up, and will receive next time arena points are distributed. ### totalHonorPoints The amount of honor points this character has got ### todayHonorPoints The amount of honor points this character has gotten today ### yesterdayHonorPoints The amount of honor points this character got yesterday ### totalKills The amount of players this character has killed ### todayKills The amount of players this character has killed today ### yesterdayKills The amount of players this character killed yesterday ### chosenTitle Current title, using the bit\_index field (InGameOrder in [CharTitles.dbc](CharTitles)) ### knownCurrencies Known currencies (what to be listed in the Currency tab), bitmask of BitIndexes, see [CurrencyTypes.dbc](CurrencyTypes) ### watchedFaction Tracked faction at experience bar (using reputation ID, see [Faction.dbc](Faction)) ### drunk Character's drunk state, 0-100 - 0 = Sober - 1-49 = Tipsy - 50-89 = Drunk - 90-100 = Smashed ### health The characters current health. ### power Current character powers (snapshot from when the character was saved)

Field	Power name
power1	Mana
power2	Rage
power3	Focus
power4	Energy
power5	Happiness
power6	Runes
power7	Runic Power

### latency This characters latency, or ping, in milliseconds, as of the last update. ### speccount The number of specs this character has access to. Default value is 1. Maximum currently supported value is 2. Should never be 0 (this is a sign of a character created before the dual spec system.) ### activespec The currently activated spec for this character, spec = 0 is the first spec, spec = 1 is the second spec. ### exploredZones Bitmasks of explored zones (1 bit for explored, 0 bit for unexplored) ### equipmentCache `field-no-description|58` ### ammoId [Template ID](item_template_2130222.html#item_template-entry) of the ammo item ### knownTitles Contains data about known Titles stored in 6 x 16bit integers. To calculate where a knownTitle is in one of those 6 integers you do the following: We select one of the titles from [CharTitles.dbc](CharTitles), take Archmage title for example:

TitleID	UnkRef?	MaleTitle	FemaleTitle	InGameOrder
93	0	Archmage %s	Archmage %s	61

We use the InGameOrder to calculate in which one of the 6 (16bit) integer is the title stored: InGameOrder / 32 = X 61 / 32 = **1,90625** (1 - Do **NOT** round the value!) so the 1st integer stores the title. Because counting starts from **0** to 5, it would be "0 **TITLE\_BIT** 0 0 0 0". Now which bit stores the title? We use modulo to calculate this. InGameOrder Modulo 32 = X 61 Mod 32 = **29** so the 29bit stores the title. This would be 2 ^ 29 = 536870912. This bit stores the Archmage title. This would mean if you **only** have the Archmage title, characters.knownTitles would be "0 536870912 0 0 0 0". ### actionBars A bitmask that contains visible actionbars for the player

Flag	Comment
1	0x00000001
2	0x00000002
4	0x00000004
8	0x00000008

### grantableLevels {{field-no-description|61)) ### deleteInfos\_Account Stores the account id if the character is deleted and CharDelete.Method in worldserver.conf is set to 1. ### deleteInfos\_Name Stores the name of character if the character is deleted and CharDelete.Method in worldserver.conf is set to 1. ### deleteDate Stores the date when the character was deleted and CharDelete.Method in worldserver.conf is set to 1. Will be checked by worldserver against CharDelete.KeepDays in worldserver.conf. If this value is lower than deleteDate + CharDelete.KeepDays the character will be purged. /ptr data-emoticon-name=/tdconfluenceTd/pp