Realmlist 548

From Project Skyfire
Revision as of 11:30, 14 June 2025 by Augustomendes4426 (talk | contribs) (WIP)
Jump to navigation Jump to search

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.