差别

这里会显示出您选择的修订版和当前版本之间的差别。

--- 数据库:auth数据库:account [2023/09/24 08:29] – 创建 admin
+++ 数据库:auth数据库:account [2023/10/04 00:40] (当前版本) – [salt] admin
@@ 行 2: / 行 2: @@
 ----
 [[数据库:auth数据库:首页|<-返回:Auth 数据库]]
-This table contains the autobroadcast entries for your realms. Values like it's activity, position and Timer (*.On, *.Center, *.Timer) are defined within the worldserver.conf. They are chosen randomly, based on their weight.
 **表结构**
 ^Field^Type^Attributes^Key^Null^Default^extra^Comment^
-|[[#realmid|realmid]]|INT|SIGNED|PRI|NO|-1| | |
+|[[#id|id]]|INT|UNSIGNED|PRI|NO| |AUTO_INCREMENT|Identifier|
-|[[#id|id]]|TINYINT|UNSIGNED|PRI|NO| |AUTO_INCREMENT| |
+|[[#username|username]]|VARCHAR(32)|SIGNED|UNI|NO|' '| | |
-|[[#weight|weight]]|TINYINT|UNSIGNED| |YES|1| | |
+|[[#salt|salt]]|BINARY(32)|SIGNED| |NO| | | |
-|[[#text|text]]|LONGTEXT|SIGNED| |NO| | | |
+|[[#verifier|verifier]]|BINARY(32)|SIGNED| |NO| | | |
+|[[#session_key|session_key]]|BINARY(40)|SIGNED| |YES| | | |
+|[[#totp_secret|totp_secret]]|VARBINARY(100)|SIGNED| |YES| | | |
+|[[#email|email]]|VARCHAR(255)|SIGNED| |NO|' '| | |
+|[[#reg_mail|reg_mail]]|VARCHAR(255)|SIGNED| |NO|' '| | |
+|[[#joindate|joindate]]|TIMESTAMP|SIGNED| |NO|CURRENT_TIMESTAMP| | |
+|[[#last_ip|last_ip]]|VARCHAR(15)|SIGNED| |NO|127.0.0.1| | |
+|[[#last_attempt_ip|last_attempt_ip]]|VARCHAR(15)|SIGNED| |NO|127.0.0.1| | |
+|[[#failed_logins|failed_logins]]|INT|UNSIGNED| |NO|0| | |
+|[[#locked|locked]]|TINYINT|UNSIGNED| |NO|0| | |
+|[[#lock_country|lock_country]]|VARCHAR(2)|SIGNED| |NO|0| | |
+|[[#last_login|last_login]]|TIMESTAMP|SIGNED| |YES| | | |
+|[[#online|online]]|INT|UNSIGNED| |NO|0| | |
+|[[#expansion|expansion]]|TINYINT|UNSIGNED| |NO|2| | |
+|[[#mutetime|mutetime]]|BIGINT|SIGNED| |NO|0| | |
+|[[#mutereason|mutereason]]|VARCHAR(255)|SIGNED| |NO|' '| | |
+|[[#muteby|muteby]]|VARCHAR(50)|SIGNED| |NO|' '| | |
+|[[#locale|locale]]|TINYINT|UNSIGNED| |NO|0| | |
+|[[#os|os]]|VARCHAR(3)|SIGNED| |NO|' '| | |
+|[[#recruiter|recruiter]]|INT|UNSIGNED| |NO|0| | |
+|[[#totaltime|totaltime]]|INT|UNSIGNED| |NO|0| | |
 ===== 字段说明 =====
+----
+==== id ====
+唯一的帐号ID。
+==== username ====
+用户的帐号名。
+**注意:**用户名不能超过20个字符，并且没有字符限制。
+==== salt ====
+Salt 是一个随机的32字节加密值。
+==== verifier ====
+verifier is derived from salt, as well as the user's username (all uppercase) and their password (all uppercase).
+To obtain the verifier you need to calculate:
+Calculate h1 = SHA1("USERNAME:PASSWORD"), substituting the user's username and password converted to uppercase.
+Calculate h2 = SHA1(salt || h1), where || is concatenation (the . operator in PHP).
+NOTE: Both salt and h1 are binary, not hexadecimal strings!
+Treat h2 as an integer in little-endian order (the first byte is the least significant).
+Calculate (g ^ h2) % N.
+NOTE: g and N are parameters, which are fixed in the WoW implementation.
+g = 7
+N = 0x894B645E89E1535BBDAD5B8B290650530801B18EBFBF5E8FAB3C82872A3E9BB7
+Convert the result back to a byte array in little-endian order.
+For PHP implementations
+Make sure the PHP GMP extension is loaded! Uncomment extension=gmp in your php.ini.
+CalculateSRP6Verifier.php
+GetSRP6RegistrationData.php
+VerifySRP6Login.php
+==== session_key ====
+field-no-description|5
+==== totp_secret ====
+The authenticator key.
+Key can be generated through the Google Authenticator API, a 3rd-party TOTP generator, or manually specified (must be a Base32-compliant expression that is 16 characters).
+Implementation link on Wikipedia for the Google Authenticator API.
+http://en.wikipedia.org/wiki/Google_Authenticator#Implementations
+==== email ====
+The e-mail address associated with this account.
+==== reg_mail ====
+The registration 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. This can be controlled with the ".account lock" GM command. If locked (1), the user can only log in with their last_ip. If unlocked (0), a user can log in from any IP, and their last_ip will be updated if it is different. ".Ban account" does not lock it.
+==== last_login ====
+The date when the account was last logged into.
+==== totaltime ====
+Total time played on all the characters of a player. Even the deleted characters that are no longer in the database. Stored in Unix Time.
+==== online ====
+Boolean 0 or 1 controlling if the account is currently logged in and online.
+==== expansion ====
+Integer 0, 1 or 2 controlling if the client logged in on the account has any expansions. (for example if client is TBC, but expansion is set to 0, it will not be able to enter outlands and etc.)
+^Value	^Expansion^
+|0	|Classic|
+|1	|The Burning Crusade (TBC)|
+|2	|Wrath of the Lich King (WotLK)|
+==== mutetime ====
+The time, in Unix time, when the account will be unmuted. To see when mute will be expired you can use this query:
+<code>
+SELECT FROM_UNIXTIME(`mutetime`);
+</code>
+==== mutereason ====
+The reason for the mute.
+==== muteby ====
+The character name with the rights to the .mute command that give the mute.
+==== 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
+==== os ====
+Stores information about client's OS. Used by Warden system.
+  * Win
+  * Mac
+==== recruiter ====
+The account ID of another account. Used for recuit-a-friend system. See account.id