该表设置所有可用 realms 的信息。每一行控制一个不同的 realm。
表结构
| Field | Type | Attributes | Key | Null | Default | extra | Comment |
|---|---|---|---|---|---|---|---|
| id | INT | UNSIGNED | PRI | NO | AUTO_INCREMENT | ||
| name | VARCHAR(32) | SIGNED | UNI | NO | '' | ||
| address | VARCHAR(255) | SIGNED | NO | 127.0.0.1 | |||
| localAddress | VARCHAR(255) | SIGNED | NO | 127.0.0.1 | |||
| localSubnetMask | VARCHAR(255) | SIGNED | 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 | SIGNED | NO | 0 | |||
| [gamebuild][12] | INT | UNSIGNED | NO | 12340 |
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.
The name of the realm. This will appear in the realm selection list as well as in the character selection screen.
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).
Alternatively you can use a domain name like example.com.
Mostly 127.0.0.1
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.
The icon of the realm.
Icon Type 0 Normal 1 PvP 4 Normal 6 RP 8 RP PvP
Realmflag of this realm.
Flag Hex value Description 0 0x0 None 1 0x1 Invalid 2 0x2 Offline 4 0x4 SpecifyBuild 8 0x8 Medium 16 0xF Medium 32 0x10 New Players 64 0x20 Recommended 128 0x40 Full
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 29 CN9 30 Test Server 2 31 CN10 32 CTC 33 CNC 34 CN1/4 35 CN/2/6/9 36 CN3/7 37 Russian Tournament 38 CN5/8 39 CN11 40 CN12 41 CN13 42 CN14 43 CN15 44 CN16 45 CN17 46 CN18 47 CN19 48 CN20 49 Brazil 50 Italian 51 Hyrule 52 QA2 Test 53 54 55 Recommended Realm 56 Test 57 Recommended Realm 58 59 Future Test
帐户登录到此 realm 所需的最低帐户 gm 级别。更改此值将自动更新可见的游戏内 realm 列表，但必须重新启动世界服务器才能真正生效。
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.
Accepted Client version for the realm.
Build Version Client Patch 5875 1.12.1 6005 1.12.2 8606 2.4.3 9947 3.1.3 10146 3.2.0 10505 3.2.2a 10571 3.3.0 11159 3.3.0a 11403 3.3.2 11623 3.3.3 11723 3.3.3a 12340 3.3.5a