Characters

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

(Различия между версиями)
Перейти к: навигация, поиск
Строка 298: Строка 298:
|
|
|-
|-
-
|[[#arena_pending_points|arena_pending_points]]
+
|[[#arenaPoints|arenaPoints]]
|int(10) unsigned
|int(10) unsigned
|NO
|NO
Строка 305: Строка 305:
|
|
|-
|-
-
|[[#bgid|bgid]]
+
|[[#totalHonorPoints|totalHonorPoints]]
|int(10) unsigned
|int(10) unsigned
|NO
|NO
Строка 312: Строка 312:
|
|
|-
|-
-
|[[#bgteam|bgteam]]
+
|[[#todayHonorPoints|todayHonorPoints]]
|int(10) unsigned
|int(10) unsigned
|NO
|NO
Строка 319: Строка 319:
|
|
|-
|-
-
|[[#bgmap|bgmap]]
+
|[[#yesterdayHonorPoints|yesterdayHonorPoints]]
|int(10) unsigned
|int(10) unsigned
|NO
|NO
Строка 326: Строка 326:
|
|
|-
|-
-
|[[#bgx|bgx]]
+
|[[#totalKills|totalKills]]
-
|float
+
|int(10) unsigned
|NO
|NO
|
|
Строка 333: Строка 333:
|
|
|-
|-
-
|[[#bgy|bgy]]
+
|[[#todayKills|todayKills]]
-
|float
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 340: Строка 340:
|
|
|-
|-
-
|[[#bgz|bgz]]
+
|[[#yesterdayKills|yesterdayKills]]
-
|float
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 347: Строка 347:
|
|
|-
|-
-
|[[#bgo|bgo]]
+
|[[#chosenTitle|chosenTitle]]
-
|float
+
|int(10) unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#knownCurrencies|knownCurrencies]]
 +
|bigint(20) unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#watchedFaction|watchedFaction]]
 +
|int(10) unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#drunk|drunk]]
 +
|smallint(5) unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#health|health]]
 +
|int(10) unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#power1|power1]]
 +
|int(10) unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#power2|power2]]
 +
|int(10) unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#power3|power3]]
 +
|int(10) unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#power4|power4]]
 +
|int(10) unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#power5|power5]]
 +
|int(10) unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#power6|power6]]
 +
|int(10) unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#power7|power7]]
 +
|int(10) unsigned
 +
|NO
 +
|
 +
|0
 +
|
 +
|-
 +
|[[#speccount|speccount]]
 +
|tinyint(3) unsigned
 +
|NO
 +
|
 +
|1
 +
|
 +
|-
 +
|[[#activespec|activespec]]
 +
|tinyint(3) unsigned
|NO
|NO
|
|
Строка 355: Строка 446:
|}
|}
-
<big>'''Description of the fields'''</big>
+
<big>'''Описание полей'''</big>
====guid====
====guid====
-
The character global unique identifier. This number must be unique and is the best way to identify separate characters.
+
Глобальный уникальный идентификатор(global unique identifier) персонажа. Этот номер должен быть уникальным, это наилучшый способ идентифицировать несколько персонажей.
====account====
====account====
-
The account ID in which this character resides. See account.id in the realm database.
+
Ид (identifier) аккаунта, к которому относится данный персонаж. Смотрите [[Account#id]].
====data====
====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]]
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====
====name====
-
The name of the character.
+
Имя персонажа.
====race====
====race====
-
The race of the character:
+
Раса персонажа:
{{:ChrRaces.dbc}}
{{:ChrRaces.dbc}}
====class====
====class====
-
The class of the character:
+
Клас персонажа:
{{:ChrClasses.dbc}}
{{:ChrClasses.dbc}}
Строка 463: Строка 554:
(c)udbwiki
(c)udbwiki
 +
====arenaPoints====
 +
Количество очков арены персонажа.
 +
====totalHonorPoints====
 +
Общее количество очков чести персонажа.
 +
====todayHonorPoints====
 +
Количество очков арены персонажа, полученных сегодня.
 +
====yesterdayHonorPoints====
 +
Количество очков арены персонажа, полученных вчера.
 +
====totalKills====
 +
Общее количество почётных убийств персонажа.
 +
====todayKills====
 +
Количество почётных убийств персонажа, полученных сегодня.
 +
====yesterdayKills====
 +
Количество почётных убийств персонажа, полученных вчера.
 +
====chosenTitle====
 +
 +
====knownCurrencies====
 +
 +
====watchedFaction====
 +
 +
====drunk====
 +
Степень нетрезвости персонажа.
 +
====health====
 +
 +
====power1====
 +
 +
====power2====
 +
 +
====power3====
 +
 +
====power4====
 +
 +
====power5====
 +
 +
====power6====
 +
 +
====power7====
 +
 +
====speccount====
 +
Количество спеков персонажа (раскладка талантов, символов и панелей).
 +
====activespec====
 +
Активный(текущий) спек персонажа.

Версия 15:30, 11 марта 2010

Содержание

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

class

Клас персонажа:

IDНазвание
1Воин
2Паладин
3Охотник
4Разбойник
5Жрец
6Рыцарь смерти Файл:Icon-wotlk.gif
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

Активный(текущий) спек персонажа.

Источник — «http://wiki.ytdb.ru:89/index.php/Characters»
Личные инструменты