Account

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

(Различия между версиями)

Перейти к: навигация, поиск

Версия 18:13, 7 марта 2010

Содержание

1 id
2 username
3 sha_pass_hash
4 gmlevel
5 sessionkey
6 v
7 s
8 email
9 joindate
10 last_ip
11 failed_logins
12 locked
13 last_login
14 online
15 expansion
16 mutetime
17 locale

Назад к списку таблиц realm database.

The `account` table

This table holds information on all available accounts.

Structure

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI		auto_increment
username	varchar(32)	NO	UNI
sha_pass_hash	varchar(40)	NO
gmlevel	tinyint(3) unsigned	NO	MUL	0
sessionkey	longtext	YES
v	longtext	YES
s	longtext	YES
email	varchar(255)	NO
joindate	timestamp	NO		CURRENT_TIMESTAMP
last_ip	varchar(30)	NO		127.0.0.1
failed_logins	int(11) unsigned	NO		0
locked	tinyint(3) unsigned	NO		0
last_login	timestamp	NO		0000-00-00 00:00:00
online	tinyint(4)	NO		0
expansion	tinyint(3) unsigned	NO		0
mutetime	bigint(40) unsigned	NO		0
locale	tinyint(3) unsigned	NO		0

Описание полей

id

The unique account ID.

username

The account user name.

sha_pass_hash

This field contains the encrypted password. The encryption is SHA1 and is in the following format: username:password. The SQL to create the password (or to compare with the current hash) is:

SELECT SHA1(CONCAT(UPPER(`username`), ':', UPPER(<pass>)));

gmlevel

The account security level. Different levels have access to different commands. The individual level required for a command is defined in the command table.

sessionkey

v

The verifier field for SRP handhsakes. Set it to '0' if you change sha_pass_hash.

s

The seed for SRP handhsakes. Set it to '0' if you change sha_pass_hash.

email

The e-mail address associated with this account.

joindate

The date when the account was created.

last_ip

The last IP used by the person who logged in the account.

failed_logins

The number of failed logins attempted on the account.

locked

Boolean 0 or 1 controlling if the account has been locked or not.

last_login

The date when the account was last logged into.

online

Boolean 0 or 1 controlling if the account is currently logged in and online.

expansion

ID	Expansion
0	WoW Classic
1	WoW Burning Crusade
2	WoW Wrath of the Lich King

The world server will block access to accounts with 0 in this field in the TBC and WotLK areas in-game.

The world server will block access to accounts with 1 in this field in the WotLK areas in-game.

mutetime

The time, in Unix time, when the account will be unmuted.

locale

The locale used by the client logged into this account. If multiple locale data has been configured and added to the world servers, the world servers will return the proper locale strings to the client. See localization IDs

@@ Строка 3: / Строка 3: @@
 |}
 [[Category: Realm database tables]]
-Back to [[realmdb_struct|realm database]] list of tables.
+Назад к списку таблиц  [[realmdb_struct|realm database]].
@@ Строка 141: / Строка 141: @@
-<big>'''Description of the fields'''</big>
+<big>'''Описание полей'''</big>
 ====id====
 The unique account ID.