character_banned
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) | NO | |||||
| banreason | varchar(255) | NO | |||||
| active | tinyint | unsigned | NO | 1 | |||
Description of fields
guid
The guid of the character.
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 bandate means, in effect, a permanent ban.
bannedby
The character name with the rights to the .ban command that banned the character.
banreason
The reason for the ban.
active
Boolean controlling if the ban is currently active or not.
- 0: expired
- 1: active