Realmlist 548: Difference between revisions
No edit summary |
No edit summary |
||
(One intermediate revision by the same user not shown) | |||
Line 3: | Line 3: | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
{{Back-to:Auth_18414}} | |||
The realmlist table | The realmlist table |
Latest revision as of 14:21, 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.