AzerothCore
Pages :

account_banned

<-Back-to:Auth

The `account_banned` table

This table lists all of the accounts that have been banned along with the date when (or if) the ban will expire.

Table 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) SIGNED NO
banreason VARCHAR(255) SIGNED NO
active TINYINT UNSIGNED NO 1

Description of the fields

id

The account ID. See account.id.

bandate

The date when the account was banned, in Unix time.

unbandate

The date when the account will be automatically unbanned, in Unix time. A value less than the current date means, in effect, a permanent ban.

bannedby

The GM character's name who banned that account. If banned from the console, then it will be empty (until improved).

banreason

The reason for the ban.

active

Boolean 0 or 1 controlling if the ban is currently active or not.