From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/realmlist.md | 541 ++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 file changed, 525 insertions(+), 16 deletions(-) (limited to 'docs/realmlist.md') diff --git a/docs/realmlist.md b/docs/realmlist.md index bf8075a..cf21a74 100644 --- a/docs/realmlist.md +++ b/docs/realmlist.md @@ -1,16 +1,525 @@ -[Database Structure](Database-Structure) > [Auth-Database](Auth-Database) > [realmlist](realmlist) - -Column | Type | Description ---- | --- | --- -Id | int(10) unsigned | -Name | varchar(32) | -Address | varchar(255) | -LocalAddress | varchar(255) | -LocalSubnetMask | varchar(255) | -Port | smallint(5) unsigned | -Icon | tinyint(3) unsigned | -Flag | tinyint(3) unsigned | -Timezone | tinyint(3) unsigned | -AllowedSecurityLevel | tinyint(3) unsigned | -Population | float unsigned | -Gamebuild | int(10) unsigned | +# 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 | 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

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 | + +## Attachments: + +![](images/icons/bullet_blue.gif){width="8" height="8"} [1.jpg](attachments/2130016/73202494.jpg) (image/jpeg) + -- cgit