Characters

Материал из YTDB DataBase

Версия от 16:29, 7 марта 2010; Neggod (Обсуждение | вклад)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

Содержание

Back to the characters database list of tables.


The `character` 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 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

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Гоблин Файл:Icon-cata.gif
10Кровавый эльф Файл:Icon-bc.gif
11Дреней Файл:Icon-bc.gif
22Ворген Файл:Icon-cata.gif

class

The class of the character:

IDНазвание
1Воин
2Паладин
3Охотник
4Разбойник
5Жрец
6Рыцарь смерти Файл:Icon-wotlk.gif
7Шаман
8Маг
9Чернокнижник
11Друид

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

Личные инструменты