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 | |||
| 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 | smallint(5) 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 | ||
| speccount | tinyint(3) unsigned | NO | 1 | ||
| activespec | tinyint(3) unsigned | NO | 0 |
Описание полей
guid
Глобальный уникальный идентификатор(global unique identifier) персонажа. Этот номер должен быть уникальным, это наилучшый способ идентифицировать несколько персонажей.
account
Ид (identifier) аккаунта, к которому относится данный персонаж. Смотрите Account#id.
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
Имя персонажа.
race
Раса персонажа:
| ID | Название |
| 1 | Человек |
| 2 | Орк |
| 3 | Дворф |
| 4 | Ночной эльф |
| 5 | Нежить |
| 6 | Таурен |
| 7 | Гном |
| 8 | Тролль |
| 9 | Гоблин 
|
| 10 | Кровавый эльф 
|
| 11 | Дреней
|
| 22 | Ворген
|
class
Клас персонажа:
| 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
arenaPoints
Количество очков арены персонажа.
totalHonorPoints
Общее количество очков чести персонажа.
todayHonorPoints
Количество очков арены персонажа, полученных сегодня.
yesterdayHonorPoints
Количество очков арены персонажа, полученных вчера.
totalKills
Общее количество почётных убийств персонажа.
todayKills
Количество почётных убийств персонажа, полученных сегодня.
yesterdayKills
Количество почётных убийств персонажа, полученных вчера.
chosenTitle
knownCurrencies
watchedFaction
drunk
Степень нетрезвости персонажа.
health
power1
power2
power3
power4
power5
power6
power7
speccount
Количество спеков персонажа (раскладка талантов, символов и панелей).
activespec
Активный(текущий) спек персонажа.
