Realmlist 548: Difference between revisions
No edit summary |
(WIP) |
||
Line 1: | Line 1: | ||
<big>PLACEHOLDER</big> | <big>PLACEHOLDER</big> | ||
<h1>Missing Data</h1> | <h1>Missing Data</h1> | ||
The realmlist table | |||
This table holds information about all available realms (servers) in the system. | |||
{| border="1" | |||
|- | |||
| '''Field''' | |||
| '''Type''' | |||
| '''Attributes''' | |||
| '''Key''' | |||
| '''Null''' | |||
| '''Default''' | |||
| '''Extra''' | |||
| '''Comment''' | |||
|- | |||
| [[#id|id]] | |||
| int | |||
| unsigned | |||
| PRI | |||
| NO | |||
| | |||
| auto_increment | |||
| | |||
|- | |||
| [[#name|name]] | |||
| varchar(32) | |||
| | |||
| UNI | |||
| NO | |||
| '' | |||
| | |||
| | |||
|- | |||
| [[#address|address]] | |||
| varchar(255) | |||
| | |||
| | |||
| NO | |||
| 127.0.0.1 | |||
| | |||
| | |||
|- | |||
| [[#localAddress|localAddress]] | |||
| varchar(255) | |||
| | |||
| | |||
| NO | |||
| 127.0.0.1 | |||
| | |||
| | |||
|- | |||
| [[#localSubnetMask|localSubnetMask]] | |||
| varchar(255) | |||
| | |||
| | |||
| NO | |||
| 255.255.255.0 | |||
| | |||
| | |||
|- | |||
| [[#port|port]] | |||
| smallint | |||
| unsigned | |||
| | |||
| NO | |||
| 8085 | |||
| | |||
| | |||
|- | |||
| [[#icon|icon]] | |||
| tinyint | |||
| unsigned | |||
| | |||
| NO | |||
| 0 | |||
| | |||
| | |||
|- | |||
| [[#flag|flag]] | |||
| tinyint | |||
| unsigned | |||
| | |||
| NO | |||
| 2 | |||
| | |||
| | |||
|- | |||
| [[#timezone|timezone]] | |||
| tinyint | |||
| unsigned | |||
| | |||
| NO | |||
| 0 | |||
| | |||
| | |||
|- | |||
| [[#allowedSecurityLevel|allowedSecurityLevel]] | |||
| tinyint | |||
| unsigned | |||
| | |||
| NO | |||
| 0 | |||
| | |||
| | |||
|- | |||
| [[#population|population]] | |||
| float | |||
| unsigned | |||
| | |||
| NO | |||
| 0 | |||
| | |||
| | |||
|- | |||
| [[#gamebuild|gamebuild]] | |||
| int | |||
| unsigned | |||
| | |||
| NO | |||
| 18414 | |||
| | |||
| | |||
|} | |||
<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. Default is 18414. |
Revision as of 11:30, 14 June 2025
PLACEHOLDER
Missing Data
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. Default is 18414.