Jump to content
  • We are looking for staff for the Wiki area!
    If interested please
    click here and select "Documentation Team"

  • realmlist


    antz
     Share

     NOTE:  This page is auto-generated from the MAGNET DBDocs module,
                 Any changes made directly to this page will be lost when it is regenerated.

    Description of the 'realmlist' table.

    This table holds information for the realms.

    Table Notes

    This table uses the 'MyISAM' DB Engine

    The Field definitions follow:

    Field Name Field Type Nullable Key Default Value Attributes Notes
    id int(11) unsigned NO PRI NULL 'auto_increment' The realm ID.
    name varchar(32) NO UNI {Blank String}   The name of the realm.
    address varchar(32) NO '127.0.0.1'   The public IP address of the world server.
    localAddress varchar(255) NO '127.0.0.1'   The local IP address of the world server.
    localSubnetMask varchar(255) NO '255.255.255.0'   The subnet mask used for the local network.
    port int(11) NO '8085'   The port that the world server is running on.
    icon tinyint(3) unsigned NO '0'   The icon of the realm.
    realmflags tinyint(3) unsigned NO '2'   Supported masks for the realm.
    timezone tinyint(3) unsigned NO '0'   The realm timezone.
    allowedSecurityLevel tinyint(3) unsigned NO '0'   Minimum account [See account.gmlevel] required for accounts to log in.
    population float unsigned NO '0'   Show the current population.
    realmbuilds varchar(64) NO {Blank String}   The accepted client builds that the realm will accept.

    Description of the fields

    id int(11) unsigned

    The realm ID. This number is unique for every realm and it MUST correlate with the RealmID configuration value in mangosd.conf.

    name varchar(32)

    The name of the realm. This will appear in the realm selection list as well as in the character selection screen.

    address varchar(32)

    The public IP address of the world server. 127.0.0.1 works for LAN play only.

    localAddress varchar(255)

    The local IP address of the world server. 127.0.0.1 works for LAN play only.

    localSubnetMask varchar(255)

    The subnet mask used for the local network. By default this is 255.255.255.0

    port int(11)

    The port that the world server is running on. Default is 8085. If you will run more than one world server on the same machine, e.g. develop and production, they will all need to use a different port.

    icon tinyint(3) unsigned

    The icon of the realm.

    Icon Meaning
    0 Normal
    1 PvP
    4 Normal
    6 RP
    8 RP PvP

    realmflags tinyint(3) unsigned

    Supported masks for the realm, based on the table below.

    Value Meaning
    0x1 Invalid - Do Not show in Realm List
    0x2 Offline - Set by mangosd
    0x4 Show version and build in Realm List
    0x20 New Players - New Players Only
    0x40 Recommended - sets the recommended option

    timezone tinyint(3) unsigned

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

    TimezoneId 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
    28 QA Server
    29 CN9

    allowedSecurityLevel tinyint(3) unsigned

    The minimum account [See account.gmlevel] required for accounts to log in to this realm. Normally 0 - that means normal players allowed on this realm. Just useful if you make a GM-only developement realm.
    Changing this value will automatically update the visible in-game realm list, but the realm server must be restarted for it to take effect.

    population float unsigned

    This field shows the current population and is automatically updated at regular intervals and will . The formula to calculate the value in this field is:

    playerCount / maxPlayerCount * 2
    

    Population Displayed Population Level
    0.5 Low
    1.0 Medium
    2.0 High

    realmbuilds varchar(64)

    The accepted client builds that the realm will accept. (You can see this version at the clients left lower corner when starting.)
    The format is version No. {space} version No. (i.e. space separated)

    xxxx xxxx xxxx
    

    Acceptable values are:
    Core Build Number(s) Version Number
    MangosZero 5875 6005 6141 Vanila 1.12.x
    MangosOne 8606 TBC 2.4.3
    MangosTwo 12340 WOTLK 3.3.5a
    MangosThree 15595 Cataclysm 4.3.4
    MangosFour 18414 Mists of Pandaria 5.4.8

    auto-generated by the getMaNGOS.eu MAGNET dbdocs module

    Edited by Antz

     Share


    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use