DB:Auth:account banned
Jump to navigation
Jump to search
Back to auth database list of tables.
The `account_banned` table
This table lists all of the accounts that have been banned along with the date when (or if) the ban will expire.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
id | int(10) | unsigned | PRI | NO | 0 | Account id | |
bandate | int(10) | signed | PRI | NO | 0 | ||
unbandate | int(10) | unsigned | NO | 0 | |||
bannedby | varchar(50) | signed | NO | ||||
banreason | varchar(255) | signed | NO | ||||
active | tinyint(3) | signed | NO | 1 |
Description of the fields
id
The account ID. See account.id.
bandate
The date when the account was banned, in Unix time.
unbandate
The date when the account will be automatically unbanned, in Unix time. A value less than the current date means, in effect, a permanent ban.
bannedby
The character with the rights to the .ban command that banned the account.
banreason
The reason for the ban.
active
Boolean 0 or 1 controlling if the ban is currently active or not.