DB:Auth:account banned 548

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
bandate	int(10)	unsigned		NO
unbandate	int(10)	unsigned		NO
bannedby	varchar(50)	unsigned		NO
banreason	varchar(255)	unsigned		NO
active	tinyint(5)	unsigned		NO	-1

DB Structure

CREATE TABLE `sf_auth`.`Untitled`  (
  `id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Account id',
  `bandate` int UNSIGNED NOT NULL DEFAULT 0,
  `unbandate` int UNSIGNED NOT NULL DEFAULT 0,
  `bannedby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `banreason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `active` tinyint UNSIGNED NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`, `bandate`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Ban List' ROW_FORMAT = Dynamic;
;

Description of the fields

id

The 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 GM character's name who banned that account. If banned from the console, then it will be empty (until improved).

banreason

The reason for the ban.

active

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