Admin: Created page with "{| align="right" | TOC |} {{Back-to:Auth}} '''The `account_banned` table''' This table lists all of the accounts that have been banned along with the date whe..."

2013-01-21T21:35:33Z

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..."

New page

{| 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 when (or if) the ban will expire.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#id|id]]
|int(10)
|unsigned
|PRI
|NO
|0
|
|Account id
|-
|[[#bandate|bandate]]
|int(10)
|signed
|PRI
|NO
|0
|
|
|-
|[[#unbandate|unbandate]]
|int(10)
|unsigned
|
|NO
|0
|
|
|-
|[[#bannedby|bannedby]]
|varchar(50)
|signed
|
|NO
|
|
|
|-
|[[#banreason|banreason]]
|varchar(255)
|signed
|
|NO
|
|
|
|-
|[[#active|active]]
|tinyint(3)
|signed
|
|NO
|1
|
|
|}

<big>'''Description of the fields'''</big>

==== id ====
The account ID. See [[DB:Auth:account#id|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 character with the rights to the .ban command that banned the account.

==== banreason ====
The reason for the ban.

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

[[Category: Auth database tables]]

DB:Auth:account banned - Revision history

Admin: Created page with "{| align="right" | __TOC__ |} {{Back-to:Auth}} '''The `account_banned` table''' This table lists all of the accounts that have been banned along with the date whe..."

Admin: Created page with "{| align="right" | TOC |} {{Back-to:Auth}} '''The `account_banned` table''' This table lists all of the accounts that have been banned along with the date whe..."