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 | UNSIGNED | PRI | NO | 0 | Account id | |
| bandate | INT | UNSIGNED | PRI | NO | 0 | ||
| unbandate | INT | UNSIGNED | NO | 0 | |||
| bannedby | VARCHAR(50) | SIGNED | NO | ||||
| banreason | VARCHAR(255) | SIGNED | NO | ||||
| active | TINYINT | UNSIGNED | NO | 1 |
Description of the fields
The account ID. See account.id.
The date when the account was banned, in Unix time.
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.
The GM character's name who banned that account. If banned from the console, then it will be empty (until improved).
The reason for the ban.
Boolean 0 or 1 controlling if the ban is currently active or not.