account_access
This table holds security access level for any realm in realmlist table.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| AccountID | int | unsigned | PRI | NO | |||
| SecurityLevel | tinyint | unsigned | NO | ||||
| RealmID | int | signed | PRI | NO | -1 | ||
| Comment | varchar(255) | YES | NULL | ||||
Description of fields
AccountID
references account.id
SecurityLevel
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.
| ID | Name | Comment |
|---|---|---|
| 0 | SEC_PLAYER | |
| 1 | SEC_MODERATOR | |
| 2 | SEC_GAMEMASTER | |
| 3 | SEC_ADMINISTRATOR | |
| 4 | ❌ SEC_CONSOLE | not available to accounts |
RealmID
The realm id.
-1 applies the rights to all realms.
Comment
This field is for any comment you want to make. It is arbitrary text.