Ip banned

From OregonCore Wiki
Jump to: navigation, search

Back to realm database list of tables.


The `ip_banned` table

This table contains all of the banned IPs and the date when (or if) the ban will expire.

Schema Last Modified: TC1-1828 - Schema Verified: Rev 665


Structure

Field Type Attributes Key Null Default Extra Comment
ip varchar(32) utf8_general_ci PRI NO 127.0.0.1
bandate int(11) signed NO NULL
unbandate int(11) signed NO NULL
bannedby varchar(50) utf8_general_ci NO [Console]
banreason varchar(50) utf8_general_ci 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.