Account 548 - Revision history

Augustomendes4426: Augustomendes4426 moved page DB:Auth:account 548 to Account 548: Removing prefix to match with world and to come characters wiki

2025-06-14T15:50:15Z

Augustomendes4426 moved page DB:Auth:account 548 to Account 548: Removing prefix to match with world and to come characters wiki

← Older revision	Revision as of 10:50, 14 June 2025
(No difference)

Admin: Format

2021-08-09T23:59:53Z

Format

@@ Line 181: / Line 181: @@
 | NO
 | 0
+|
+|
@@ Line 209: / Line 227: @@
 | 0
+|
+|
 |}
 <br> <big>'''DB Structure'''</big>
@@ Line 313: / Line 339: @@
 ==== lock_country ====
-{{field-no-description|13}}
+{{field-no-description|14}}
 ==== last_login ====
@@ Line 327: / Line 353: @@
 The time, in Unix time, when the account will be unmuted. To see when mute will be expired you can use this query:
 <pre>SELECT FROM_UNIXTIME(`mutetime`);</pre>
 ==== locale ====
@@ Line 339: / Line 371: @@
 The account ID of another account. Used for recuit-a-friend system. See [[DB:Auth:account#id|account.id]]
+==== hasBoost ====
-[[Category: SkyFire Auth database tables]]
+{{field-no-description|24}}

Admin: Format

2021-08-09T23:49:40Z

Format

← Older revision		Revision as of 18:49, 9 August 2021
Line 262:		Line 262:

	==== sessionkey ====		==== sessionkey ====
	{{field-no-description\|6}}		{{field-no-description\|4}}

	==== v ====		==== v ====

Admin: Format

2021-08-09T23:47:56Z

Format

← Older revision		Revision as of 18:47, 9 August 2021
Line 262:		Line 262:

	==== sessionkey ====		==== sessionkey ====
	{{field-no-description\|5}}		{{field-no-description\|6}}

	==== v ====		==== v ====
Line 292:		Line 292:

	==== token_key ====		==== token_key ====
	{{field-no-description\|6}}		{{field-no-description\|7}}

	==== email ====		==== email ====

Admin: Format

2021-08-09T23:47:01Z

Format

@@ Line 69: / Line 69: @@
 | [[#s|s]]
 | varchar(64)
 | signed
+|
@@ Line 77: / Line 86: @@
 |-
 | [[#email|email]]
 | varchar(254)
 | signed
@@ Line 118: / Line 136: @@
 | NO
 | 0
+|
+|
@@ Line 238: / Line 265: @@
 ==== v ====
-{{field-no-description|6}}
+v is derived from salt, as well as the user's username (all uppercase) and their password (all uppercase).
 ==== s ====
-{{field-no-description|7}}
+s is a cryptographically random 32-byte value.
 ==== email ====
 The e-mail address associated with this account.
 ==== joindate ====
@@ Line 257: / Line 311: @@
 ==== 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 [[DB:Auth:account#last_ip|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 ====

Admin: Update structure and add DB structure.

2021-08-09T23:25:42Z

Update structure and add DB structure.

@@ Line 184: / Line 184: @@
+|
 |}
 <br> <big>'''Description of the fields'''</big>

Admin at 14:27, 16 September 2018

2018-09-16T14:27:10Z

← Older revision		Revision as of 09:27, 16 September 2018
Line 3:		Line 3:
	\| __TOC__		\| __TOC__
	\|}		\|}
	{{Back-to:~~Auth~~}}		{{Back-to:Auth_18414}}

	<br> <big>'''The `account` table'''</big>		<br> <big>'''The `account` table'''</big>

Admin: Created page with "{| align="right" |- | TOC |} {{Back-to:Auth}}
'''The `account` table''' This table holds information on all available accounts.
'''Structur..."

2018-09-16T14:25:03Z

Created page with "{| align="right" |- | __TOC__ |} {{Back-to:Auth}} <big>'''The `account` table'''</big> This table holds information on all available accounts. <big>'''Structur..."

New page

{| align="right"
|-
| __TOC__
|}
{{Back-to:Auth}}

 <big>'''The `account` table'''</big>

This table holds information on all available accounts.

 <big>'''Structure'''</big>

{| border="1"
|-
| '''Field'''
| '''Type'''
| '''Attributes'''
| '''Key'''
| '''Null'''
| '''Default'''
| '''Extra'''
| '''Comment'''
|-
| [[#id|id]]
| int(10)
| unsigned
| PRI
| NO
|
| Auto increment
| Identifier
|-
| [[#username|username]]
| varchar(32)
| signed
| UNI
| NO
| "
|
|
|-
| [[#sha_pass_hash|sha_pass_hash]]
| varchar(40)
| signed
|
| NO
| "
|
|
|-
| [[#sessionkey|sessionkey]]
| varchar(80)
| signed
|
| NO
| "
|
|
|-
| [[#v|v]]
| varchar(64)
| signed
|
| NO
| "
|
|
|-
| [[#s|s]]
| varchar(64)
| signed
|
| NO
| "
|
|
|-
| [[#email|email]]
| varchar(254)
| signed
|
| NO
| "
|
|
|-
| [[#joindate|joindate]]
| timestamp
| signed
|
| NO
| CURRENT_TIMESTAMP
|
|
|-
| [[#last_ip|last_ip]]
| varchar(15)
| signed
|
| NO
| 127.0.0.1
|
|
|-
| [[#failed_logins|failed_logins]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#locked|locked]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#last_login|last_login]]
| timestamp
| signed
|
| NO
| 0000-00-00 00:00:00
|
|
|-
| [[#online|online]]
| tinyint(3)
| signed
|
| NO
| 0
|
|
|-
| [[#expansion|expansion]]
| tinyint(3)
| unsigned
|
| NO
| 2
|
|
|-
| [[#mutetime|mutetime]]
| bigint(20)
| signed
|
| NO
| 0
|
|
|-
| [[#locale|locale]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#os|os]]
| varchar(3)
| signed
|
| NO
| "
|
|
|-
| [[#recruiter|recruiter]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|}

 <big>'''Description of the fields'''</big>

==== 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:
<pre>SELECT SHA1(CONCAT(UPPER(`username`), ':', UPPER(<pass>)));</pre>

==== sessionkey ====
{{field-no-description|5}}

==== v ====
{{field-no-description|6}}

==== s ====
{{field-no-description|7}}

==== 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. This can be controlled with the ".account lock" GM command. If locked (1), the user can only log in with their [[DB:Auth:account#last_ip|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.

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

==== expansion ====
Boolean 0 or 1 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.)

==== mutetime ====
The time, in Unix time, when the account will be unmuted. To see when mute will be expired you can use this query:
<pre>SELECT FROM_UNIXTIME(`mutetime`);</pre>

==== 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 lang|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 [[DB:Auth:account#id|account.id]]

[[Category: SkyFire Auth database tables]]

Account 548 - Revision history

Augustomendes4426: Augustomendes4426 moved page DB:Auth:account 548 to Account 548: Removing prefix to match with world and to come characters wiki

Admin: Format

Admin: Format

Admin: Format

Admin: Format

Admin: Update structure and add DB structure.

Admin at 14:27, 16 September 2018

Admin: Created page with "{| align="right" |- | __TOC__ |} {{Back-to:Auth}} '''The `account` table''' This table holds information on all available accounts. '''Structur..."

Admin: Created page with "{| align="right" |- | TOC |} {{Back-to:Auth}}
'''The `account` table''' This table holds information on all available accounts.
'''Structur..."