NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'realmlist' table.
This table holds information for the realms.
Table Notes
This table uses the 'MyISAM' DB Engine
The Field definitions follow:
Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
---|---|---|---|---|---|---|
id | int(11) unsigned | NO | PRI | NULL | 'auto_increment' | The realm ID. |
name | varchar(32) | NO | UNI | {Blank String} | The name of the realm. | |
address | varchar(32) | NO | '127.0.0.1' | The public IP address of the world server. | ||
localAddress | varchar(255) | NO | '127.0.0.1' | The local IP address of the world server. | ||
localSubnetMask | varchar(255) | NO | '255.255.255.0' | The subnet mask used for the local network. | ||
port | int(11) | NO | '8085' | The port that the world server is running on. | ||
icon | tinyint(3) unsigned | NO | '0' | The icon of the realm. | ||
realmflags | tinyint(3) unsigned | NO | '2' | Supported masks for the realm. | ||
timezone | tinyint(3) unsigned | NO | '0' | The realm timezone. | ||
allowedSecurityLevel | tinyint(3) unsigned | NO | '0' | Minimum account [See account.gmlevel] required for accounts to log in. | ||
population | float unsigned | NO | '0' | Show the current population. | ||
realmbuilds | varchar(64) | NO | {Blank String} | The accepted client builds that the realm will accept. |
Description of the fields
id int(11) unsigned
The realm ID. This number is unique for every realm and it MUST correlate with the RealmID configuration value in mangosd.conf.
name varchar(32)
The name of the realm. This will appear in the realm selection list as well as in the character selection screen.
address varchar(32)
The public IP address of the world server. 127.0.0.1 works for LAN play only.
localAddress varchar(255)
The local IP address of the world server. 127.0.0.1 works for LAN play only.
localSubnetMask varchar(255)
The subnet mask used for the local network. By default this is 255.255.255.0
port int(11)
The port that the world server is running on. Default is 8085. If you will run more than one world server on the same machine, e.g. develop and production, they will all need to use a different port.
icon tinyint(3) unsigned
The icon of the realm.
Icon | Meaning |
---|---|
0 | Normal |
1 | PvP |
4 | Normal |
6 | RP |
8 | RP PvP |
realmflags tinyint(3) unsigned
Supported masks for the realm, based on the table below.
Value | Meaning |
---|---|
0x1 | Invalid - Do Not show in Realm List |
0x2 | Offline - Set by mangosd |
0x4 | Show version and build in Realm List |
0x20 | New Players - New Players Only |
0x40 | Recommended - sets the recommended option |
timezone tinyint(3) unsigned
The realm timezone, it will be displayed in the tabs of the realmlist.
TimezoneId | 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 tinyint(3) unsigned
The minimum account [See account.gmlevel] required for accounts to log in to this realm. Normally 0 - that means normal players allowed on this realm. Just useful if you make a GM-only developement realm.
Changing this value will automatically update the visible in-game realm list, but the realm server must be restarted for it to take effect.
population float unsigned
This field shows the current population and is automatically updated at regular intervals and will . The formula to calculate the value in this field is:
playerCount / maxPlayerCount * 2
Population | Displayed Population Level |
---|---|
0.5 | Low |
1.0 | Medium |
2.0 | High |
realmbuilds varchar(64)
The accepted client builds that the realm will accept. (You can see this version at the clients left lower corner when starting.)
The format is version No. {space} version No. (i.e. space separated)
xxxx xxxx xxxx
Acceptable values are:
Core | Build Number(s) | Version Number |
---|---|---|
MangosZero | 5875 6005 6141 | Vanila 1.12.x |
MangosOne | 8606 | TBC 2.4.3 |
MangosTwo | 12340 | WOTLK 3.3.5a |
MangosThree | 15595 | Cataclysm 4.3.4 |
MangosFour | 18414 | Mists of Pandaria 5.4.8 |
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now