Hey all, this is a guide I wrote to have two realms on the same server computer and the same realmlist for people to connect. The two servers (as said in the title) can have different databases, different rates, different spawns, characters, everything! all connected to the one realmlist and same accounts. In this guide I presume you have a server runing already, and know the basics of ports and stuff, and have your server public WITHOUT HAMACHI. This guide is for advanced users.
Step One:
- Copy your server files and put them in another folder (I will call it Server2 in this guide). Then delete the logonserver.exe and logonserver.conf files.
- Create a new database in Navicat or called "accounts" (no "" of course ).
- Go into your Server1 folder and open up logonserver.conf.
- Change:
CODE
<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "PASSWORD"
Name = "antrix"
Port = "3306"
Type = "1">
To:
CODE
<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "PASSWORD"
Name = "accounts"
Port = "3306"
Type = "1">
Step Two:
- Create a new database in Navicat (I'll call it Server2Database in this guide).
- Set up Server2Database with a new copy of the database.
- Right click on the "accounts" table in Navicat in and click Dump SQL File. Save this somewhere you remember.
- Go into the "Accounts" database you created in step one, and right click on it and click Execute Batch File and choose the file you dumped just before. This should add the "accounts" table with all your accounts into it.
- Delete the "accounts" table from Server1Database and Server2Database.
Step Three:
- Login to your router, and navigate to where you open ports.
- Open the port 8130.
- Go into your Server2 folder and open Ascent.conf.
- Change:
CODE
<WorldDatabase Hostname = "localhost" Username = "root" Password = "PASSWORD" Name = "Server1Database" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "PASSWORD" Name = "Server1Database" Port = "3306" Type = "1">
To:
CODE
<WorldDatabase Hostname = "localhost" Username = "root" Password = "PASSWORD" Name = "Server2Database" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "PASSWORD" Name = "Server2Database" Port = "3306" Type = "1">
.
Change:
CODE
<Listen Host = "0.0.0.0"
WorldServerPort = "8129">
To:
CODE
<Listen Host = "0.0.0.0"
WorldServerPort = "8130">
- Go into your Server2 folder and open Realms.conf.
- Change:
CODE
<Realm1 Name = "REALM1NAME"
Address = "PUBLICIP:8129"
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">
To:
CODE
<Realm1 Name = "REALM2NAME"
Address = "PUBLICIP:8130"
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">
Step Four:
- Go to Server1 folder and start logonserver.exe and ascent.exe
- Once they are both fully done loading, go into your Server2 folder and start ascent.exe
Congratulations! You now have 2 seperate realms!
You can configure all your rates and stuff for one realm, and not the other. So one realm can be high-rate, and one lower-rate.