Realmlist

Материал из YTDB DataBase

Версия от 15:57, 7 марта 2010; Neggod (Обсуждение | вклад)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

Содержание

Back to realm database list of tables.


The `realmlist` table

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


Structure

Field Type Null Key Default Extra
id int(11) unsigned NO PRI auto_increment
name varchar(32) NO UNI
address varchar(32) NO 127.0.0.1
port int(11) NO 8085
icon tinyint(3) unsigned NO 0
color tinyint(3) unsigned NO 2
timezone tinyint(3) unsigned NO 0
allowedSecurityLevel tinyint(3) unsigned NO 0
population float unsigned NO 0
realmbuilds varchar(64) NO 0


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 mangosd.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 IP address of the world server. 127.0.0.1 works but only for LAN play.

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

color

The color denoting how "full" you want the realm to be displayed as.

color effect
0Yellow (Normal)
1Red (Full)
2Grey (Offline)

timezone

The realm timezone, it will be displayed in the tabs of the realmlist.

timezone displayed name
1Development
2United States
3Oceanic
4Latin America
5Tournament
6Korea
7Tournament
8English
9German
10French
11Spanish
12Russian
13Tournament
14Taiwan
15Tournament
16China
17CN1
18CN2
19CN3
20CN4
21CN5
22CN6
23CN7
24CN8
25Tournament
26Test Server
27Tournament
28QA Server
29CN9

allowedSecurityLevel

The minimum account gmlevel required for accounts to log in to this 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.

population effect
0.5Low
1.0Medium
2.0High

realmbuilds

Added in rev. 9010. Allows realms with different client builds to be on the same realm list. Supports 1.12.1, 1.12.2, 2.4.3, 3.2.2a on the same realm list. Leave this blank.

Личные инструменты