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

2025-06-14T15:52:23Z

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

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

Admin at 02:41, 3 August 2023

2023-08-03T02:41:57Z

← Older revision		Revision as of 21:41, 2 August 2023
Line 63:		Line 63:
	\|		\|
	\|NO		\|NO
	\|		\|<nowiki>no reason</nowiki>
	\|		\|
	\|		\|

Admin: Final

2023-08-03T02:40:43Z

Final

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


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

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


			<big>'''Structure'''</big>
			{\| border="1"
			\|'''Field'''
			\|'''Type'''
			\|'''Attributes'''
			\|'''Key'''
			\|'''Null'''
			\|'''Default'''
			\|'''Extra'''
			\|'''Comment'''
			\|-
			\|[[#ip\|ip]]
			\|varchar(15)
			\|
			\|
			\|NO
			\|<nowiki>127.0.0.1</nowiki>
			\|
			\|
			\|-
			\|[[#bandate\|bandate]]
			\|int
			\|unsigned
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|[[#unbandate\|unbandate]]
			\|int
			\|unsigned
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|[[#bannedby\|bannedby]]
			\|varchar(50)
			\|unsigned
			\|
			\|NO
			\|<nowiki>[Console]</nowiki>
			\|
			\|
			\|-
			\|[[#banreason\|banreason]]
			\|varchar(255)
			\|unsigned
			\|
			\|NO
			\|
			\|
			\|
			\|-
			\|}
			<br> <big>'''DB Structure'''</big>
			<br>
			{\| border="1"<br>
			<pre style="color: red">
			CREATE TABLE `ip_banned` (
			`ip` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '127.0.0.1',
			`bandate` int UNSIGNED NOT NULL,
			`unbandate` int UNSIGNED NOT NULL,
			`bannedby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[Console]',
			`banreason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'no reason',
			PRIMARY KEY (`ip`, `bandate`) USING BTREE
			) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Banned IPs' ROW_FORMAT = Dynamic;
			;
			</pre>

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

			==== ip ====

			The ip address.

			==== bandate====

			The date when the ip was banned, in Unix time.

			==== unbandate====

			The date when the ip 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 ip. If banned from the console, then it will be empty (until improved).

			==== banreason ====

			The reason for the ban.

Admin: placeholder

2023-08-02T23:42:54Z

placeholder

New page

placeholder

Ip banned 548 - Revision history

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

Admin at 02:41, 3 August 2023

Admin: Final

Admin: placeholder