-
Notifications
You must be signed in to change notification settings - Fork 48
Characters
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.