account_banned
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) | NO | |||||
| banreason | varchar(255) | NO | |||||
| active | tinyint | unsigned | NO | 1 | |||
Description of fields
id
references account.id
bandate
Unix timestamp when the account was banned.
unbandate
Unix timestamp when the account will be automatically unbanned. If unbandate is equal to bandate this is a permanent ban.
bannedby
The name of the character executing the .ban command.
banreason
The reason for the ban.
active
Controls if the ban is currently active or not.
- 0: ban expired
- 1: ban is active
