character_banned

Back-to:Auth

The `character_banned` table

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(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

bandate

int(10)

unsigned

PRI

NO

0

 

 

unbandate

int(10)

unsigned

 

NO

0

 

 

bannedby

varchar(50)

signed

 

NO

 

 

 

banreason

varchar(255)

signed

 

NO

 

 

 

active

tinyint(3)

unsigned

 

NO

1

 

 

Description of the fields

guid

The character guid. See characters.guid.

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 current date means, in effect, a permanent ban.

bannedby

The character with the rights to the .ban command that banned the character.

banreason

The reason for the ban.

active

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