AccountsTable - Revision history

Grimston at 14:16, 11 January 2022

2022-01-11T14:16:21Z

← Older revision		Revision as of 14:16, 11 January 2022
Line 1:		Line 1:


	{\| class="wikitable"		{\| class="wikitable"
	\|+		\|+
Line 17:		Line 15:
	\|		\|
	\|auto_increment		\|auto_increment
	\|Unique account id		\|Unique account id
	\|-		\|-
	\|		\|
Line 25:		Line 23:
	\|0		\|0
	\|		\|
	\|Login name for the account		\|Login name for the account
	\|-		\|-
	\|~~DIF~~		\|
	\|password		\|password
	\|varchar(64)		\|varchar(64)
Line 33:		Line 31:
	\|0		\|0
	\|		\|
	\|The encrypted password. ~~Type used to be '~~varchar(32)~~' in PSLegacy.~~		\|The encrypted password.
			\|-
			\|
			\|password256
			\|varchar(64)
			\|
			\|0
			\|
			\|
	\|-		\|-
	\|		\|
Line 73:		Line 79:
	\|		\|
	\|		\|
	\|The verification id used in the URL to activate/reset account.		\|The verification id used in the URL to activate/reset account.
	\|-		\|-
	\|		\|
Line 81:		Line 87:
	\|		\|
	\|		\|
	\|The country this user is from.		\|The country this user is from.
	\|-		\|-
	\|		\|
Line 121:		Line 127:
	\|0		\|0
	\|		\|
	\|The number of advisor points this account has accumulated.		\|The number of advisor points this account has accumulated.
	\|-		\|-
	\|		\|
Line 145:		Line 151:
	\|0		\|0
	\|		\|
	\|If the account is banned from being an advisor		\|If the account is banned from being an advisor
	\|-		\|-
	\|		\|
Line 156:		Line 162:
	\|-		\|-
	\|		\|
	~~\|graphics_card~~
	~~\|varchar(64)~~
	\|
	\|
	\|
	\|
	\|-
	\|
	~~\|graphics_version~~
	~~\|varchar(32)~~
	\|
	\|
	\|
	\|
	\|-
	~~\|ADD~~
	~~\|password256~~
	~~\|varchar(64)~~
	\|
	\|0
	\|
	\|
	\|-
	~~\|ADD~~
	\|OS		\|OS
	\|char(1)		\|char(1)
Line 187:		Line 169:
	\|		\|
	\|-		\|-
	\|~~ADD~~		\|
	\|OS_ver_major		\|OS_ver_major
	\|int(2)		\|int(2)
Line 195:		Line 177:
	\|		\|
	\|-		\|-
	\|~~ADD~~		\|
	\|OS_ver_minor		\|OS_ver_minor
	\|int(2)		\|int(2)
Line 203:		Line 185:
	\|		\|
	\|-		\|-
	\|~~ADD~~		\|
	\|OS_platform		\|OS_platform
	\|char(14)		\|char(14)
Line 211:		Line 193:
	\|		\|
	\|-		\|-
	\|~~ADD~~		\|DIF
	\|Machine_type		\|Machine_type
	\|varchar(64)		\|varchar(64)
			\|
			\|
			\|
			\| Type used to be 'char(6)' in PSLegacy.
			\|-
			\|
			\|graphics_card
			\|varchar(64)
			\|
			\|
			\|
			\|
			\|-
			\|
			\|graphics_version
			\|varchar(32)
	\|		\|
	\|		\|

Grimston at 11:05, 11 January 2022

2022-01-11T11:05:25Z

Show changes

Talad at 15:41, 7 March 2020

2020-03-07T15:41:26Z

← Older revision		Revision as of 15:41, 7 March 2020
Line 39:		Line 39:
	\| tinyint(3)		\| tinyint(3)
	\| N		\| N
	\| The ~~GM level~~ of this account.		\| The [[Security Level]] of this account.
	\|-		\|-
	\| verificationid		\| verificationid

Ethryn: add to category (Engine documents)

2010-10-23T00:13:18Z

add to category (Engine documents)

← Older revision		Revision as of 00:13, 23 October 2010
Line 106:		Line 106:
	\|		\|
	\|}		\|}


			[[Category:Engine documents]]

Talad: Created page with '{| border=1 |- ! field ! type ! foreign key ! description |- | id | int(10) | N | unique account id |- | username | varchar(50) | N | Login name for the account |- | password | v…'

2010-10-12T22:12:27Z

Created page with '{| border=1 |- ! field ! type ! foreign key ! description |- | id | int(10) | N | unique account id |- | username | varchar(50) | N | Login name for the account |- | password | v…'

New page

{| border=1
|-
! field
! type
! foreign key
! description
|-
| id
| int(10)
| N
| unique account id
|-
| username
| varchar(50)
| N
| Login name for the account
|-
| password
| varchar(32)
| N
| The MD5 encrypted password.
|-
| last_login
| datetime
| N
| The last login time this account was used.
|-
| created_date
| datetime
| N
| The date this account was created
|-
| last_login_ip
| varchar(16)
| N
| The IP address last used to login with this account.
|-
| security_level
| tinyint(3)
| N
| The GM level of this account.
|-
| verificationid
| varchar(32)
| N
| The verification id used in the URL to activate/reset account.
|-
| country
| varchar(64)
| N
| The country this user is from.
|-
| gender
| varchar(1)
| N
| The gender of the player.
|-
| birth
| int(4)
| N
| The year this player was born.
|-
| status
| char(1)
| N
| The status of this account. (A)ctive (U)nactive.
|-
| spam_points
| int
| N
| The amount of spam points this account has accumulated.
|-
| advisor_points
| int
| N
| The number of advisor points this account has accumulated.
|-
| comments
| text
| N
| Additional comments about account.
|-
| realname
| varchar(64)
| N
| The real name of the person using account.
|-
| advisor_ban
| tinyint(1)
| N
|
|-
| operating_system
| varchar(32)
| N
|
|-
| graphics_card
| varchar(64)
| N
|
|-
| graphics_version
| varchar(32)
| N
|
|}