Account banned 548 - Revision history

Augustomendes4426: Augustomendes4426 moved page DB:Auth:account banned 548 to Account banned 548: Removing prefix to match with world and to come characters wiki

2025-06-14T15:51:47Z

Augustomendes4426 moved page DB:Auth:account banned 548 to Account banned 548: Removing prefix to match with world and to come characters wiki

← Older revision	Revision as of 10:51, 14 June 2025
(No difference)

Admin: Final

2023-08-03T02:00:00Z

Final

← Older revision		Revision as of 21:00, 2 August 2023
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~~.

Admin at 01:54, 3 August 2023

2023-08-03T01:54:15Z

← Older revision		Revision as of 20:54, 2 August 2023
Line 1:		Line 1:
	~~placeholder~~		{\| align="right"
			\|-
			\| __TOC__
			\|}
			{{Back-to:Auth_18414}}


			<big>'''The `account_banned` table'''</big>

			This table holds banned users


			<big>'''Structure'''</big>
			{\| border="1"
			\|'''Field'''
			\|'''Type'''
			\|'''Attributes'''
			\|'''Key'''
			\|'''Null'''
			\|'''Default'''
			\|'''Extra'''
			\|'''Comment'''
			\|-
			\|[[#id\|id]]
			\|int(10)
			\|unsigned
			\|PRI
			\|NO
			\|
			\|
			\|
			\|-
			\|[[#bandate\|bandate]]
			\|int(10)
			\|unsigned
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|[[#unbandate\|unbandate]]
			\|int(10)
			\|unsigned
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|[[#bannedby\|bannedby]]
			\|varchar(50)
			\|unsigned
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|[[#banreason\|banreason]]
			\|varchar(255)
			\|unsigned
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|[[#active\|active]]
			\|tinyint(5)
			\|unsigned
			\|
			\|NO
			\|<nowiki>-1</nowiki>
			\|
			\|
			\|}
			<br> <big>'''DB Structure'''</big>
			<br>
			{\| border="1"<br>
			<pre style="color: red">
			CREATE TABLE `account_banned` (
			`id` INT NOT NULL,
			`gmlevel` TINYINT NOT NULL,
			`RealmID` INT NOT NULL DEFAULT -1,
			PRIMARY KEY (`id`, `RealmID`) USING BTREE
			)
			COLLATE='utf8_general_ci'
			ENGINE=InnoDB
			;
			</pre>

			<big>'''Description of the fields'''</big>

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

			==== gmlevel ====
			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.

			==== RealmID ====
			The Realm ID.

Admin: Created page with "placeholder"

2023-08-02T23:41:28Z

Created page with "placeholder"

New page

placeholder