Realmlist 548

From Project Skyfire
Revision as of 14:21, 14 June 2025 by Augustomendes4426 (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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.