Command 548 - Revision history

Admin: Add missing table entry

2021-08-09T01:16:09Z

Add missing table entry

← Older revision		Revision as of 20:16, 8 August 2021
Line 39:		Line 39:
	\|signed		\|signed
	\|		\|
	\|		\|YES
	\|		\|
	\|		\|

Admin: Derp

2021-08-09T01:12:52Z

Derp

← Older revision		Revision as of 20:12, 8 August 2021
Line 47:		Line 47:
	{\| border="1"<br>		{\| border="1"<br>
	<pre style="color: red">		<pre style="color: red">

	~~</pre>~~
	CREATE TABLE `command` (		CREATE TABLE `command` (
	`name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',		`name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
Line 60:		Line 58:
	ROW_FORMAT=FIXED		ROW_FORMAT=FIXED
	;		;
			</pre>

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

Admin: Update structure and add DB structure.

2021-08-09T01:12:26Z

Update structure and add DB structure.

← Older revision		Revision as of 20:12, 8 August 2021
Line 6:		Line 6:
	<big>'''The `command` table'''</big>		<big>'''The `command` table'''</big>

	This table ~~holds the security levels for~~ the ~~various commands~~.		Holds help and permission information for commands. This table does NOT create new commands. It only sets / overrides the permission and provides a help text.


Line 27:		Line 27:
	\|		\|
	\|-		\|-
	\|[[#~~security~~\|~~security~~]]		\|[[#permission\|permission]]
	\|~~tinyint~~(3)		\|smallint(5)
	\|unsigned		\|unsigned
	\|		\|
Line 43:		Line 43:
	\|		\|
	\|}		\|}
			<br> <big>'''DB Structure'''</big>
			<br>
			{\| border="1"<br>
			<pre style="color: red">

			</pre>
			CREATE TABLE `command` (
			`name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
			`permission` SMALLINT NOT NULL DEFAULT '0',
			`help` LONGTEXT NULL COLLATE 'utf8_general_ci',
			PRIMARY KEY (`name`) USING BTREE
			)
			COMMENT='Chat System'
			COLLATE='utf8_general_ci'
			ENGINE=MyISAM
			ROW_FORMAT=FIXED
			;
	<br> <big>'''Description of the fields'''</big>		<br> <big>'''Description of the fields'''</big>

Line 50:		Line 66:
	Name of the command.		Name of the command.

	===~~security~~===		===permission===

	The ~~minimum security level~~ required to use the command ~~(1-4 (Player~~-~~GM))~~.		The permission required to use the command. Corresponds with rbac_permissions.id in the auth-database.

	===help===		===help===

	The in-game syntax for proper use of the command.		The in-game syntax for proper use of the command.

Admin: Add content

2021-08-09T01:09:59Z

Add content

New page

{| align="right"
| __TOC__
|}
{{Back-to:World_18414}}

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

This table holds the security levels for the various commands.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Comment'''
|-
|[[#name|name]]
|varchar(50)
|signed
|PRI
|NO
|
|
|-
|[[#security|security]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|-
|[[#help|help]]
|longtext
|signed
|
|
|
|
|}

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

===name===

Name of the command.

===security===

The minimum security level required to use the command (1-4 (Player-GM)).

===help===

The in-game syntax for proper use of the command.