AzerothCore 中文

本页面只读。您可以查看源文件，但不能更改它。如果您觉得这是系统错误，请联系管理员。
====== realmlist 表 ======
----
[[数据库:auth数据库:首页|<-返回:Auth 数据库]]

该表设置所有可用 realms 的信息。每一行控制一个不同的 realm。

**表结构**
^Field^Type^Attributes^Key^Null^Default^extra^Comment^
|[[#id|id]]|INT|UNSIGNED|PRI|NO| |AUTO_INCREMENT| |
|[[#name|name]]|VARCHAR(32)|SIGNED|UNI|NO|''| | |
|[[#address|address]]|VARCHAR(255)|SIGNED| |NO|127.0.0.1| | |
|[[#localAddress|localAddress]]|VARCHAR(255)|SIGNED| |NO|127.0.0.1| | |
|[[#localSubnetMask|localSubnetMask]]|VARCHAR(255)|SIGNED| |NO|255.255.255.0| | |
|[[#port|port]]|SMALLINT|UNSIGNED| |NO|8085| | |
|[[#icon|icon]]|TINYINT|UNSIGNED| |NO|0| | |
|[[#flag|flag]]|TINYINT|UNSIGNED| |NO|2| | |
|[[#timezone|timezone]]|TINYINT|UNSIGNED| |NO|0| | |
|[[#allowedSecurityLevel|allowedSecurityLevel]]|TINYINT|UNSIGNED| |NO|0| | |
|[[#population|population]]|FLOAT|SIGNED| |NO|0| | |
|[[#[gamebuild][12]|[gamebuild][12]]]|INT|UNSIGNED| |NO|12340| | |
===== 字段说明 =====


==== 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).

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

==== localAddress ====

Mostly 127.0.0.1
==== localSubnetMask ====

==== 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
==== flag ====

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
==== 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
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
==== allowedSecurityLevel ====
帐户登录到此 realm 所需的最低帐户 gm 级别。更改此值将自动更新可见的游戏内 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.

==== gamebuild ====

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