AzerothCore
Pages :
Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.
ip_banned
The `ip_banned` table
This table contains all of the banned IPs and the date when (or if) the ban will expire.
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ip | VARCHAR(15) | SIGNED | PRI | NO | 127.0.0.1 | ||
| bandate | INT | UNSIGNED | PRI | NO | |||
| unbandate | INT | UNSIGNED | NO | ||||
| bannedby | VARCHAR(50) | SIGNED | NO | [Console] | |||
| banreason | VARCHAR(255) | SIGNED | NO | no reason |
Description of the fields
ip
The IP address that is banned.
bandate
The date when the IP was first banned, in Unix time.
unbandate
The date when the IP will be unbanned in Unix time. Any date that is set lower than the current date basically classifies as a permanent ban as it will never auto expire.
bannedby
The name of the character that banned the IP. The character should belong to an account with the rights to the .ban command in-game.
banreason
The reason given for the IP ban.