characters

Description of the 'characters' table for MaNGOSOne

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

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

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

account int(11) unsigned

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

name varchar(12)

The name of the character.

race tinyint(3) unsigned

The race of the character.

class tinyint(3) unsigned

The Class Id of the character [See chrclasses.dbc]

gender tinyint(3) unsigned

The Sex/Gender of the character.

level tinyint(3) unsigned

The current level of the designated player.

xp int(10) unsigned

The total amount of xp that the signified player has.

money int(10) unsigned

This is the amount of copper the character possesses.

playerBytes int(10) unsigned

This defines the following physical attributes of the character:
skin, face, hairstyle, hair colour

playerBytes2 int(10) unsigned

This defines the facial hair physical attribute of the character.

As with playerBytes, playerBytes2's bits (0 to 7) are used to change the character's facial hair

TODO (an example of setting this attribute)

playerFlags int(10) unsigned

These are the player flags. They are represented as decimal values in the database table, and hexidecimal values in the table below.

position_x float

The x position of the character's location.

position_y float

The y position of the character's location.

position_z float

The z position of the character's location.

map int(11) unsigned

The map ID the character is in. [See map.dbc]

dungeon_difficulty tinyint(1) unsigned

orientation float

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

taximask longtext

online tinyint(3) unsigned

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

cinematic tinyint(3) unsigned

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

totaltime int(11) unsigned

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

leveltime int(11) unsigned

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

logout_time bigint(20) unsigned

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

is_logout_resting tinyint(3) unsigned

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

rest_bonus float

This is part of the rest system, and is used to calculate how much rest bonus to give the player when they have been offline. Rest bonus affects the amount of experience the character can earn,

resettalents_cost int(11) unsigned

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

resettalents_time bigint(20) unsigned

trans_x float

The X coordinate of the character on the transport it is travelling on at the point of logging off.

trans_y float

The Y coordinate of the character on the transport it is travelling on at the point of logging off.

trans_z float

The Z coordinate of the character on the transport it is travelling on at the point of logging off.

trans_o float

The orientation of the character on the transport it is travelling on at the point of logging off.

transguid bigint(20) unsigned

This is the transprt the character is currently travelling on.

It's the entry ID from the transports table.

extra_flags int(11) unsigned

These flags control certain player specific attributes, mostly GM features

stable_slots tinyint(1) unsigned

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

at_login int(11) unsigned

The status of the character.

zone int(11) unsigned

The zone ID the character is in.

death_expire_time bigint(20) unsigned

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

taxi_path text

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

arenaPoints int(10) unsigned

totalHonorPoints int(10) unsigned

todayHonorPoints int(10) unsigned

yesterdayHonorPoints int(10) unsigned

totalKills int(10) unsigned

todayKills smallint(5) unsigned

yesterdayKills smallint(5) unsigned

chosenTitle int(10) unsigned

watchedFaction int(10) unsigned

The faction whose rep is being followed on the experience bar.

Only one faction at a time can be followed.

The ID of the faction being followed will appear in this field, e.g.
18 for Gnomeragan Exiles
20 for Ironforge
21 for Darnassus

These are not the same as the Faction IDs from the DBC file.

drunk smallint(5) unsigned

This represents the alcoholic strength of the drink. The stronger the drinker, the longer your character is drunk for

health int(10) unsigned

The character's health when logging out.

power1 int(10) unsigned

The character's mana level when logging out.

power2 int(10) unsigned

If a warrior, then this is character's rage level when logging out.

power3 int(10) unsigned

This is a hunter pet's focus level at point of logging off.

power4 int(10) unsigned

If a rogue, then this is character's energy level when logging out.

power5 int(10) unsigned

This is the current active pet's happiness level at the point of logging off.

exploredZones longtext

This is a record of all areas discovered by the character.

equipmentCache longtext

This is a record of all items that are currently equipped.

Changing this information does not affect what is equipped. It will just revert back to what was originally equipped.

ammoId int(10) unsigned

This is the item_template Entry ID of the ammo currently equipped.

e.g. 2516 light shot

knownTitles longtext

actionBars tinyint(3) unsigned

This represents which action bars are currently active.

deleteInfos_Account int(11) unsigned

This is the account number from the characters table, that the deleted character is on.

deleteInfos_Name varchar(12)

The is the name of the character being deleted.

deleteDate bigint(20) unsigned

This is the date the character was deleted,

auto-generated by the getMaNGOS.eu MAGNET dbdocs module