realmlist Table¶
Registered realms served by this auth server (name, address, type, security level).
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
id |
int(11) unsigned | PRI | NO | auto_increment | |
name |
varchar(32) | UNI | NO | '' | |
address |
varchar(32) | NO | '127.0.0.1' | ||
localAddress |
varchar(255) | NO | '127.0.0.1' | ||
localSubnetMask |
varchar(255) | NO | '255.255.255.0' | ||
port |
int(11) | 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 | ||
gamebuild_min |
int(11) unsigned | NO | 0 | ||
gamebuild_max |
int(11) unsigned | NO | 0 | ||
flag |
tinyint(3) unsigned | NO | 2 | ||
realmbuilds |
varchar(64) | NO | '' |
Field Breakdown¶
id- Primary Key. Realm id clients select.name- Unique. Displayed realm name.address- Public address clients connect to (host or IP).localAddress- Address handed to clients inside the local network.localSubnetMask- Subnet mask deciding which clients count as local (dotted format).port- World server port (default 8085).icon- Realm type: 0 normal, 1 PvP, 4 normal variant (REALM_TYPE_NORMAL2), 6 RP, 8 RPPvP. The custom FFA-PvP mode (16) is stored as 1 in this column.realmflags- Bitmask: 1 invalid (realm hidden from clients), 2 offline, 4 specify build (show version next to name), 8 unknown (REALM_FLAG_UNK1), 16 unknown (REALM_FLAG_UNK2), 32 new players, 64 recommended, 128 full (defined but not set by core). Only 2, 4, 32 and 64 may be set in DB; realmd shows realms as offline dynamically when the client build is unsupported or the realm is locked.timezone- Realm timezone grouping for the realm list sort.allowedSecurityLevel- Minimum account security required to enter this realm (realms above the account level show as locked).population- Population level float shown as low/medium/high. Updated by mangosd.gamebuild_min- Accepted client build range. Not read by core.gamebuild_max- Accepted client build range. Not read by core.flag- Additional display flag byte. Not read by core.realmbuilds- Space-separated list of accepted build numbers, rewritten by mangosd at startup (e.g.5875 6005).