Smart AI (DB Scripting) reference: Difference between revisions
Jump to navigation
Jump to search
(→link) |
Cheapgamer (talk | contribs) No edit summary |
||
Line 1: | Line 1: | ||
{| align="right" | {| align="right" | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
{{Back-to:Auth}} | |||
<big>'''The `account_access` table'''</big> | |||
This table | This table holds security access level for any realm in [[DB:Auth:realmlist|realmlist]] table. | ||
<big>'''Structure'''</big> | |||
{| border="1" | {| border="1" | ||
|'''Field''' | |||
|'''Type''' | |||
|'''Attributes''' | |||
| '''Field''' | |'''Key''' | ||
|'''Null''' | |||
| '''Type''' | |'''Default''' | ||
|'''Extra''' | |||
| '''Attributes''' | |'''Comment''' | ||
| '''Key''' | |||
| '''Null''' | |||
| '''Default''' | |||
| '''Extra''' | |||
| '''Comment''' | |||
|- | |- | ||
|[[#id|id]] | |||
| [[# | |int(10) | ||
|unsigned | |||
| int(10) | |PRI | ||
|NO | |||
| | |||
| | | | ||
| | | | ||
| | | | ||
|- | |- | ||
|[[#gmlevel|gmlevel]] | |||
|tinyint(3) | |||
|unsigned | |||
| [[# | |||
| | |||
| unsigned | |||
| | | | ||
|NO | |||
| NO | |||
| | | | ||
| | | | ||
| | | | ||
|- | |- | ||
|[[#RealmID|RealmID]] | |||
| [[# | |int(11) | ||
|signed | |||
| int( | |PRI | ||
|NO | |||
| | |<nowiki>-1</nowiki> | ||
| | | | ||
| | | | ||
|} | |} | ||
<big>'''Description of the fields'''</big> | |||
==== id ==== | ==== id ==== | ||
The [[DB:Auth:account#id|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 SF|command]] table in each realm. | |||
== | |||
==== RealmID ==== | |||
The [[DB:Auth:realmlist#id|Realm ID]]. | |||
[[Category: | [[Category: SkyFire Auth database tables]] |
Revision as of 00:57, 6 July 2012
Back to auth database list of tables.
The `account_access` table
This table holds security access level for any realm in realmlist table.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
id | int(10) | unsigned | PRI | NO | |||
gmlevel | tinyint(3) | unsigned | NO | ||||
RealmID | int(11) | signed | PRI | NO | -1 |
Description of the fields
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.