目录

account_banned 表


<-返回:Auth 数据库

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

表结构

FieldTypeAttributesKeyNullDefaultextraComment
idINTUNSIGNEDPRINO0 Account id
bandateINTUNSIGNEDPRINO0
unbandateINTUNSIGNED NO0
bannedbyVARCHAR(50)SIGNED NO
banreasonVARCHAR(255)SIGNED NO
activeTINYINTUNSIGNED NO1

字段说明


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.