2 Realms on the same list

[deathomen]

Well, i was going to pull the one from Emupedia as it was a really nice guide for me, but its a bit outta date now so im going to create my own using his as a reference. The post i'm taking info from was posted on emupedia by iamgod344

Step 1:
Make a copy of your server folder and paste it somewhere on your machine.

Step 2:
Rename your second copy and move it back to the same location your first server is located.

eg.

C:\Ascent Server\
C:\Ascent Server 2\

Step 3:
Backup your database.

Step 4:
Create 5 new databases using the names below.

<realm1 name>char
<realm1 name>world
<realm2 name>char
<realm2 name>world
logon

Step 5:
In the logon database, move the following tables from your original database.

Accounts
Ipbans

Step 6:
In the <realm1 name>char database, move the following table from your original database.

Account data
Account forced permissions
Arenateams
Auctions
Characters
Characters insert queue
Charters
Corpses
Gm tickets
Groups
Guild bankitems
Guild banklogs
Guild banktabs
Guild checkpoints
Guild data
Guild logs
Guild ranks
Guilds
Instances
Mailbox
Playercooldownitems
Playercooldownsecurity
Playeritems
Playeritems external
Playeritems insert queue
Playerpets
Playerpetspells
Playersummonspells
Questlog
Server settings
Social
Tutorials

Step 7:
Do the same thing with <realm2 name>char that you did in step 5, but this time you need to empty all the tables.

Step 8:
In the <realm1 name>world database, move the remaining tables from your original database.

Step 9:
In the <realm2 name>world database, import whatever database you like. NCDB, ACDB, NDB, or whatever you like.

Step 10:
Setup your config files like the ones below.

Ascent-World.conf (realm 1)

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Database Section
#
#   Database.Host      - The hostname that the database is located on
#   Database.Username  - The username used for the mysql connection
#   Database.Password  - The password used for the mysql connection
#   Database.Name      - The database name
#   Database.Port      - Port that MySQL listens on. Usually 3306.
#   Database.Type      - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = SQLite (MySQL is stable, others are not)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<WorldDatabase Hostname = "host" Username = "username" Password = "password" Name = "<realm1name>world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "host" Username = "username" Password = "password" Name = "<realm1 name>char" Port = "3306" Type = "1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Listen Config
#
#    Host
#        This is the address that the server will listen on.
#        To listen on all addresses, set it to 0.0.0.0
#        Default: 127.0.0.1 (localhost)
#
#    WorldServerPort
#        This is the port that the world server listens on.
#        It has to be the same as what is specified in the
#        realms table in the LogonDatabase.
#        Default: 8129
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Listen Host = "0.0.0.0"
        WorldServerPort = "8129">

Ascent-Realms.conf (realm 1)

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Realm Section
#
#    Name:
#        The name of the realm.
#    
#    Address:
#        The address (and port) of that realm.
#
#    Icon:
#        The type of realm (PVP, Normal, RPPVP, RP)
#
#    Colour:
#        Realm colour in realm list display.
#
#    TimeZone:
#        Time zone the realm is in.
#
#    Population:
#        (0 = low, 1 = medium, 2 = high)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Realm1 Name = "<realm 1 name>"
        Address = "<server realmlist>:8129"
        Icon = "PVP"
        Colour = "1"
        Population = "1.0"
        TimeZone = "1">

Ascent-World.conf (realm 2)

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Database Section
#
#   Database.Host      - The hostname that the database is located on
#   Database.Username  - The username used for the mysql connection
#   Database.Password  - The password used for the mysql connection
#   Database.Name      - The database name
#   Database.Port      - Port that MySQL listens on. Usually 3306.
#   Database.Type      - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = SQLite (MySQL is stable, others are not)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<WorldDatabase Hostname = "localhost" Username = "username" Password = "password" Name = "<realm2 name>world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "username" Password = "password" Name = "<realm2 name>character" Port = "3306" Type = "1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Listen Config
#
#    Host
#        This is the address that the server will listen on.
#        To listen on all addresses, set it to 0.0.0.0
#        Default: 127.0.0.1 (localhost)
#
#    WorldServerPort
#        This is the port that the world server listens on.
#        It has to be the same as what is specified in the
#        realms table in the LogonDatabase.
#        Default: 8129
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Listen Host = "0.0.0.0"
        WorldServerPort = "8130">

Ascent-Realms.conf (realm 2)

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Realm Section
#
#    Name:
#        The name of the realm.
#    
#    Address:
#        The address (and port) of that realm.
#
#    Icon:
#        The type of realm (PVP, Normal, RPPVP, RP)
#
#    Colour:
#        Realm colour in realm list display.
#
#    TimeZone:
#        Time zone the realm is in.
#
#    Population:
#        (0 = low, 1 = medium, 2 = high)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Realm1 Name = "<Realm2 Name>"
        Address = "<server realmlist>:8130"
        Icon = "PVP"
        Colour = "1"
        Population = "1.0"
        TimeZone = "1">

Step 11:
Since your running both realms on the same list, theres no need to start 2 logonservers. Setup your config file as shown below.

Ascent-Logonserver.conf

# LogonDatabase Section
#
#    These directives are the location of the `realms` and `accounts`
#    tables.
#
#    LogonDatabase.Host      - The hostname that the database is located on
#    LogonDatabase.Username  - The username used for the mysql connection
#    LogonDatabase.Password  - The password used for the mysql connection
#    LogonDatabase.Name      - The database name
#    LogonDatabase.Port      - Port that MySQL listens on. Usually 3306.
#    LogonDatabase.Type      - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = Oracle 10g
#

<LogonDatabase Hostname = "localhost"
               Username = "username"
               Password = "password"
               Name     = "logon"
               Port     = "3306"
               Type     = "1">

Step 12:
Now to startup your servers. Begin by first starting mysql if needed, then start the ascent-logonserver located in the server 1 folder. Next start ascent-world in the server 1 folder. Finally start ascent-world in the server 2 folder. when you login to the realm and check the realm list, you should have 2 realms listed there, both using the same accounts table, but completely different characters, items, ect.

Congratz! You have 2 realms now!!!

~death~

[orien30000]

first post!!!!! nice repack!!!!!!!!!!!!!!!1

[rajien2]

wow nice job well done +Rep+Rep

[deathomen]

thanks for the +rep hope other people find this as useful as you do.

~death~

[GMkyle]

you should make a download for a server with 2 realms, so if someone downloads it, they automatically have 2 realms, that they can custom theirselves. =]

[deathomen]

"Give a man a fish and he'll eat for a day, but teach a man to fish and he'll eat for a lifetime."

~death~

[Mr.Jebus Christ]

hm what if u just want 2 realms running of the same db
edit: +Rep x2

[deathomen]

if thats the case then theres no need to setup a second DB, just setup the second ascent-world.conf with the DB information just like the first ascent-world.conf.

it would look like this:

ascent-world.conf (realm 1)

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Database Section
#
#   Database.Host      - The hostname that the database is located on
#   Database.Username  - The username used for the mysql connection
#   Database.Password  - The password used for the mysql connection
#   Database.Name      - The database name
#   Database.Port      - Port that MySQL listens on. Usually 3306.
#   Database.Type      - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = SQLite (MySQL is stable, others are not)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<WorldDatabase Hostname = "host" Username = "username" Password = "password" Name = "worldDB" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "host" Username = "username" Password = "password" Name = "characterDB" Port = "3306" Type = "1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Listen Config
#
#    Host
#        This is the address that the server will listen on.
#        To listen on all addresses, set it to 0.0.0.0
#        Default: 127.0.0.1 (localhost)
#
#    WorldServerPort
#        This is the port that the world server listens on.
#        It has to be the same as what is specified in the
#        realms table in the LogonDatabase.
#        Default: 8129
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Listen Host = "0.0.0.0"
        WorldServerPort = "8129">

ascent-world.conf (realm 2)

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Database Section
#
#   Database.Host      - The hostname that the database is located on
#   Database.Username  - The username used for the mysql connection
#   Database.Password  - The password used for the mysql connection
#   Database.Name      - The database name
#   Database.Port      - Port that MySQL listens on. Usually 3306.
#   Database.Type      - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = SQLite (MySQL is stable, others are not)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<WorldDatabase Hostname = "host" Username = "username" Password = "password" Name = "worldDB" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "host" Username = "username" Password = "password" Name = "characterDB" Port = "3306" Type = "1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Listen Config
#
#    Host
#        This is the address that the server will listen on.
#        To listen on all addresses, set it to 0.0.0.0
#        Default: 127.0.0.1 (localhost)
#
#    WorldServerPort
#        This is the port that the world server listens on.
#        It has to be the same as what is specified in the
#        realms table in the LogonDatabase.
#        Default: 8129
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Listen Host = "0.0.0.0"
        WorldServerPort = "8130">

keep in mind that the WorldServerPort on ascent-world.conf 2 MUST be set to 8130, and that port MUST be forwarded on your router in order for anyone to connect.

[Nickfitt91]

Nice Guide, Keep it up mate!

[XxX_Josie_XxX]

You have reposted , Look on perryhiggins profile , he made this last year man i hate it when people repost

[Mr.Jebus Christ]

Look who is posting it a leecher and btw my server decided 2 dbs and now we got a problem all are characters we make on the first realm are on the other realm

[deathomen]

#1, this ISNT a repost because i wrote this all up myself...just because he has a guide that tells the same thing doesnt mean this a repost. if you compare them, has and mine a almost completely different and mine is much more detailed. if youd like ill show you the post on emupedia that i used as a reference for mine...

#2 if your creating characters on realm 1 and its carrying them to realm 2 then you didnt setup your configs right.