realmlist

<-Back-to:Auth

The `realmlist` table

This table sets up information on all available realms. Each row controls a different realm.

Table Structure

Description of the fields

id

The realm ID. This number is unique for every realm and it MUST correlate with the RealmID configuration value in worldserver.conf.

Value must be >=0. If the value does not meet the condition the SQL will fail on realmlist_chk_1.

name

The name of the realm. This will appear in the realm selection list as well as in the character selection screen.

address

The public (WAN) or LAN IP address of the world server. Use 127.0.0.1 in this field if only you is connecting to the server (and it runs on the same machine as your client). This is the address that clients will use to connect to the worldserver.

Alternatively you can use a domain name like example.com.

localAddress

Usually 127.0.0.1 for local or simple installations.

When a client connects, if the client address is within the same subnet as localAddress (according to localSubnetMask), this client will be served localAddress to connect to the worldserver, instead of address. This can be useful e.g. for resolving issues caused by local network clients having their connections routed outwards and back into your network, such as poor NAT implementations not handling port forwarding for non-external connections.

localSubnetMask

Subnet mask in 255.255.255.0-like format. Works in tandem with localAddress.

port

The port that the world server is running on. If all world servers are on the same machine, they will all need to use a different port.

icon

The icon of the realm.

flag

Realmflag of this realm.

timezone

The realm timezone, it will be displayed in the tabs of the realmlist.

allowedSecurityLevel

The minimum account gmlevel required for accounts to log in to this realm. Changing this value will automatically update the visible in-game realm list, but the Worldserver must be restarted for it to truly take effect.

population

This field is automatically updated at regular intervals and will have the current population. The formula to calculate the value in this field is: playerCount / maxPlayerCount * 2. In the realm list in-game, the thresholds for low, medium, and high population are 0.5, 1.0, and 2.0 respectively.

gamebuild

Accepted Client version for the realm.