Characters
Материал из YTDB DataBase
Back to the characters database list of tables.
The `character` table
Эта таблица содержит основную информацию для каждого персонажа. Эта информация загружается и используется для создания и определения игроков в мире.
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 | ||
| 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 | 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:
| ID | Название |
| 1 | Человек |
| 2 | Орк |
| 3 | Дворф |
| 4 | Ночной эльф |
| 5 | Нежить |
| 6 | Таурен |
| 7 | Гном |
| 8 | Тролль |
| 9 | Гоблин 
|
| 10 | Кровавый эльф 
|
| 11 | Дреней
|
| 22 | Ворген
|
class
The class of the character:
| ID | Название |
| 1 | Воин |
| 2 | Паладин |
| 3 | Охотник |
| 4 | Разбойник |
| 5 | Жрец |
| 6 | Рыцарь смерти 
|
| 7 | Шаман |
| 8 | Маг |
| 9 | Чернокнижник |
| 11 | Друид |
gender
level
Уровень персонажа.
xp
Количество очков опыта персонажа.
money
Количество золота у персонажа.
playerBytes
playerBytes2
playerFlags
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
- 16 = Reset pet talents
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.
(c)udbwiki
