DB:Auth:account banned 548: Difference between revisions

From Project Skyfire
Jump to navigation Jump to search
No edit summary
(Final)
 
Line 8: Line 8:
<big>'''The `account_banned` table'''</big>
<big>'''The `account_banned` table'''</big>


This table holds banned users
This table lists all of the accounts that have been banned along with the date when (or if) the ban will expire.




Line 80: Line 80:
{| border="1"<br>
{| border="1"<br>
<pre style="color: red">
<pre style="color: red">
CREATE TABLE `account_banned` (
CREATE TABLE `sf_auth`.`Untitled`  (
`id` INT NOT NULL,
  `id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Account id',
`gmlevel` TINYINT NOT NULL,
  `bandate` int UNSIGNED NOT NULL DEFAULT 0,
`RealmID` INT NOT NULL DEFAULT -1,
  `unbandate` int UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`, `RealmID`) USING BTREE
  `bannedby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
)
  `banreason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
COLLATE='utf8_general_ci'
  `active` tinyint UNSIGNED NOT NULL DEFAULT 1,
ENGINE=InnoDB
  PRIMARY KEY (`id`, `bandate`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Ban List' ROW_FORMAT = Dynamic;
;
;
</pre>
</pre>
Line 94: Line 95:


==== id ====
==== id ====
The account ID.
The account ID.


==== gmlevel ====
==== bandate====
The account security level. Different levels have access to different commands. The individual level required for a command is defined in the command table in each realm.
 
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 ====


==== RealmID ====
Boolean 0 or 1 controlling if the ban is currently active or not.
The Realm ID.

Latest revision as of 21:00, 2 August 2023

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.

Retrieved from "https://wiki.projectskyfire.org/index.php?title=DB:Auth:account_banned_548&oldid=957"