character_banned
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
guid
The character guid. See characters.guid.
bandate
The date when the character was banned, in Unix time.
unbandate
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.
bannedby
The character with the rights to the .ban command that banned the character.
banreason
The reason for the ban.
active
Boolean 0 or 1 controlling if the ban is currently active or not.