From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/ip_banned.md | 115 +++++++++++++++++++++++++++++++++++++++++++++++++----- 1 file changed, 106 insertions(+), 9 deletions(-) (limited to 'docs/ip_banned.md') diff --git a/docs/ip_banned.md b/docs/ip_banned.md index 6534e49..ee9a459 100644 --- a/docs/ip_banned.md +++ b/docs/ip_banned.md @@ -1,9 +1,106 @@ -[Database Structure](Database-Structure) > [Auth-Database](Auth-Database) > [ip_banned](ip_banned) - -Column | Type | Description ---- | --- | --- -Ip | varchar(15) | -Bandate | int(10) unsigned | -Unbandate | int(10) unsigned | -Bannedby | varchar(50) | -Banreason | varchar(255) | +# ip\_banned + +`Back-to:Auth` + +**The \`ip\_banned\` table** + +This table contains all of the banned IPs and the date when (or if) the ban will expire. + +**Structure** + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

ip

varchar(15)

signed

PRI

NO

127.0.0.1

 

 

bandate

int(10)

unsigned

 

NO

 

 

 

unbandate

int(10)

unsigned

 

NO

 

 

 

bannedby

varchar(50)

signed

 

NO

Console

 

 

banreason

varchar(255)

signed

 

NO

no reason

 

 

+ +**Description of the fields** + +### ip + +The IP address that is banned. + +### bandate + +The date when the IP was first banned, in Unix time. + +### unbandate + +The date when the IP will be unbanned in Unix time. Any date that is set lower than the current date basically classifies as a permanent ban as it will never auto expire. + +### bannedby + +The name of the character that banned the IP. The character should belong to an account with the rights to the .ban command in-game. + +### banreason + +The reason given for the IP ban. -- cgit