The `character_banned` table
This table lists all of the characters that have been banned along with the date when (or if) the ban will expire.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guid | INT | UNSIGNED | PRI | NO | 0 | Global Unique Identifier | |
| 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 character guid. See characters.guid.
The date when the character was banned, in Unix time.
The date when the character will be automatically unbanned, in Unix time. A value less than the current date means, in effect, a permanent ban.
The character with the rights to the .ban command that banned the character.
The reason for the ban.
Boolean 0 or 1 controlling if the ban is currently active or not.