Skip to content
Schmoozerd edited this page Apr 14, 2013 · 1 revision

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.

Structure

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

Category: Realm database tables: Realm database tables

Clone this wiki locally