Realmlist 548: Difference between revisions

From Project Skyfire
Jump to navigation Jump to search
No edit summary
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
<big>PLACEHOLDER</big>
{| align="right"
<h1>Missing Data</h1>
|-
| __TOC__
|}
{{Back-to:Auth_18414}}
 
 
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.

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.