realmlist

Back-to:Auth

The `realmlist` table

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

Structure

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

int(10)

unsigned

PRI

NO


Auto increment


name

varchar(32)

signed

UNI

NO

Trinity



address

varchar(255)

signed


NO

127.0.0.1



localAddressvarchar(255)signed
NO127.0.0.1

port

smallint(5)

unsigned


NO

8085



icon

tinyint(3)

unsigned


NO

0



flag

tinyint(3)

unsigned


NO

2


Updates population status or realm status

timezone

tinyint(3)

unsigned


NO

0



allowedSecurityLevel

tinyint(3)

unsigned


NO

0



population

float

unsigned


NO

0



gamebuild

int(10)

unsigned


NO

12340



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 worldserver.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 (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

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

0xFMedium

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

29CN9
30Test Server 2

31

CN10

32CTC

33

CNC

34

CN1/4

35

CN/2/6/9

36

CN3/7

37

Russian Tournament

38CN5/8
39CN11
40CN12
41CN13
42CN14
43CN15
44CN16
45CN17
46CN18
47CN19
48CN20
49Brazil
50Italian
51Hyrule
52QA2 Test
53
54
55Recommended Realm
56Test
57Recommended Realm
58
59Future Test

allowedSecurityLevel

The minimum account gmlevel required for accounts to log in to this realm. Changing this value will automatically update the visible in-game realm list, but the Worldserver must be restarted for it to truly take effect.

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