Realmlist

From OregonCore Wiki
Jump to: navigation, search

Back to realm database list of tables.


The `realmlist` table

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

Schema Last Modified: Rev 592 - Schema Verified: Rev 665


Structure

Field Type Attributes Key Null Default Extra Comment
id int(11) unsigned PRI NO NULL Auto_increment
name varchar(32) utf8_general_ci NO NULL
address varchar(32) utf8_general_ci NO 127.0.0.1
port int(11) signed NO 8085
icon tinyint(3) unsigned NO 0
realmflags tinyint(3) unsigned NO 2
timezone tinyint(3) unsigned NO 0
allowedSecurityLevel tinyint(3) unsigned NO 0
population float unsigned NO 0
realmbuilds varchar(64) utf8_general_ci NO 8606


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 oregoncore.conf.

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 IP address of the world server. DO NOT use localhost or 127.0.0.1 in this field as this will cause a loop.

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.

Icon Type
0 Normal
1 PvP
4 Normal
6 RP
8 RP PvP


realmflags

This is a bitmask, with the following properties available:

Flag Description
1 Invalid - Not shown in Realm List
2 Offline - Set by oregon-realm
4 Show version and build
32 New Players
64 Recommended


Some properties may not behave as expected in the 2.4.3 client due to the fact that they use features from later client builds (32 might not have the desired effect, for example).

The flags are ANDed together. For example, if you set a realm to Recommended (64), and if the realm is Offline (2) - the value of realmflags will be 66.

timezone

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

timezone displayed name
1 Development
2 United States
3 Oceanic
4 Latin America
5 Tournament
6 Korea
7 Tournament
8 English
9 German
10 French
11 Spanish
12 Russian
13 Tournament
14 Taiwan
15 Tournament
16 China
17 CN1
18 CN2
19 CN3
20 CN4
21 CN5
22 CN6
23 CN7
24 CN8
25 Tournament
26 Test Server
27 Tournament
28 QA Server
29 CN9


allowedSecurityLevel

The minimum account gmlevel required for accounts to log in to this realm.

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.

realmbuilds

The client builds that can successfully connect and function with this realm.