Realmlist 548: Difference between revisions
(WIP) |
No edit summary |
||
Line 1: | Line 1: | ||
{| align="right" | |||
|- | |||
| __TOC__ | |||
|} | |||
{{Back-to:Auth_18414}} | |||
The realmlist table | The realmlist table | ||
Line 127: | Line 131: | ||
<br> <big>'''Description of the fields'''</big> | <br> <big>'''Description of the fields'''</big> | ||
==== id ==== | |||
The unique realm ID. Primary key, auto-incremented. | |||
==== name ==== | |||
The name of the realm/server. Must be unique. | |||
==== address ==== | |||
The external IP address or hostname clients use to connect to the realm. Default is 127.0.0.1. | |||
==== localAddress ==== | |||
The local IP address or hostname for internal connections. Default is 127.0.0.1. | |||
==== localSubnetMask ==== | |||
The subnet mask for the local network. Default is 255.255.255.0. | |||
==== port ==== | |||
The port number the realm listens on. Default is 8085. | |||
==== icon ==== | |||
A numeric value representing the realm icon (used by the client to display the realm type). | |||
==== flag ==== | |||
A numeric value representing the realm flag (used by the client to display the realm status/type). | |||
==== | ==== timezone ==== | ||
A numeric value representing the realm's timezone. | |||
==== | ==== allowedSecurityLevel ==== | ||
The minimum security level required to access the realm. | |||
==== | ==== population ==== | ||
A floating-point value representing the current population of the realm (used for display purposes). | |||
==== | ==== gamebuild ==== | ||
The client build number required to connect to the realm. |
Revision as of 14:20, 14 June 2025
Back to auth database list of tables.
The realmlist table
This table holds information about all available realms (servers) in the system.
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
id | int | unsigned | PRI | NO | auto_increment | ||
name | varchar(32) | UNI | NO | ||||
address | varchar(255) | NO | 127.0.0.1 | ||||
localAddress | varchar(255) | NO | 127.0.0.1 | ||||
localSubnetMask | varchar(255) | NO | 255.255.255.0 | ||||
port | smallint | unsigned | NO | 8085 | |||
icon | tinyint | unsigned | NO | 0 | |||
flag | tinyint | unsigned | NO | 2 | |||
timezone | tinyint | unsigned | NO | 0 | |||
allowedSecurityLevel | tinyint | unsigned | NO | 0 | |||
population | float | unsigned | NO | 0 | |||
gamebuild | int | unsigned | NO | 18414 |
Description of the fields
id
The unique realm ID. Primary key, auto-incremented.
name
The name of the realm/server. Must be unique.
address
The external IP address or hostname clients use to connect to the realm. Default is 127.0.0.1.
localAddress
The local IP address or hostname for internal connections. Default is 127.0.0.1.
localSubnetMask
The subnet mask for the local network. Default is 255.255.255.0.
port
The port number the realm listens on. Default is 8085.
icon
A numeric value representing the realm icon (used by the client to display the realm type).
flag
A numeric value representing the realm flag (used by the client to display the realm status/type).
timezone
A numeric value representing the realm's timezone.
allowedSecurityLevel
The minimum security level required to access the realm.
population
A floating-point value representing the current population of the realm (used for display purposes).
gamebuild
The client build number required to connect to the realm.