Actions

DB:Auth:account banned

From Project Skyfire

Revision as of 21:35, 21 January 2013 by Admin (talk | contribs) (Created page with "{| align="right" | __TOC__ |} {{Back-to:Auth}} <big>'''The `account_banned` table'''</big> This table lists all of the accounts that have been banned along with the date whe...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Back to auth database list of tables.

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.


Structure

Field Type Attributes Key Null Default Extra Comment
id int(10) unsigned PRI NO 0 Account id
bandate int(10) signed PRI NO 0
unbandate int(10) unsigned NO 0
bannedby varchar(50) signed NO
banreason varchar(255) signed NO
active tinyint(3) signed NO 1


Description of the fields

id[edit]

The account ID. See account.id.

bandate[edit]

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

unbandate[edit]

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[edit]

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

banreason[edit]

The reason for the ban.

active[edit]

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