How to host 2 realms on the same machine.

[Wheeze201]

1. Make a folder somewhere named realm2 or something. And copy your old emulator in there.
2. Delete your logonserve.exe and your logonserver.conf
3. Make a 2 new SQL databases using navicat or whatever you use. ( I'll be using world2 and character 1 as examples )
4. Name 1 of them world2 ( or whatever you wish ) and the second databse character1 ( or whatever you wish )
5. Execute the SQL's you originally executed on your older DB's.
6. Go to your realm2 emulator then open the world config file.

Then change this:

<WorldDatabase Hostname = "5.115.136.232" Username = "root" Password = "root" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "5.115.136.232" Username = "root" Password = "root" Name ="logon" Port = "3306" Type = "1">

to this:

<WorldDatabase Hostname = "5.115.136.232" Username = "root" Password = "root" Name = "world2" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "5.115.136.232" Username = "root" Password = "root" Name = "character1" Port = "3306" Type = "1">

Now boot up your original server normally and then boot up the world.exe in your new emulator folder. And you should be all set.

So whats happening here is that the second emulator connects to the original logonserver.exe for accounts but connects to the character1 DB for characters. Therefore you can use 1 account and create unique characters on both realms.

[ranso]

good guide but repost +Rep tho

[Bunster]

Good guide, first time i seen it :P

[Wheeze201]

The other guide didn't cover the database details.
So i made a guide on my own

[skello]

1. Make a folder somewhere named realm2 or something. And copy your old emulator in there.
2. Delete your logonserve.exe and your logonserver.conf
3. Make a 2 new SQL databases using navicat or whatever you use. ( I'll be using world2 and character 1 as examples )
4. Name 1 of them world2 ( or whatever you wish ) and the second databse character1 ( or whatever you wish )
5. Execute the SQL's you originally executed on your older DB's.
6. Go to your realm2 emulator then open the world config file.

Then change this:

<WorldDatabase Hostname = "5.115.136.232" Username = "root" Password = "root" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "5.115.136.232" Username = "root" Password = "root" Name ="logon" Port = "3306" Type = "1">

to this:

<WorldDatabase Hostname = "5.115.136.232" Username = "root" Password = "root" Name = "world2" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "5.115.136.232" Username = "root" Password = "root" Name = "character1" Port = "3306" Type = "1">

Now boot up your original server normally and then boot up the world.exe in your new emulator folder. And you should be all set.

So whats happening here is that the second emulator connects to the original logonserver.exe for accounts but connects to the character1 DB for characters. Therefore you can use 1 account and create unique characters on both realms.

I tryed this and it worked apart from when i log on to server and go onto the realm the char are the same on both realms.
so then i added back ogon and now it works but there is a but......
when people join my server it only add on 2 1 of them any 1 got any idea how to get this workin??
or how to change my account creation page to the acout go into both data baces?

[skello]

when you does this thow the char stay there how do i make to so that each realm has new char on them??

[antidoffen]

tell me if u know it xD

[Jackie Moon]

Repost from a contribution in ascent guides

HIS NAME IS VOLTILE

[zetsobu]

thanx for this

[skello]

i need help my servers link up when i use this way help plz how can i run 2 realms

[Dweebert]

i need help my servers link up when i use this way help plz how can i run 2 realms

I use Navicat for my DB viewer. What I figured out is:
When you create a new connection for your database, you use that connection for all added realms. You make a Database called world and one called logon or whatever names you decide to use. Then create more databases in that same connection with names like world1 and logon1. You can keep creating added databases like world3 and logon 3.. all you have to do then is link eack database name to the corrosponding config files.\

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

<LogonDatabase Hostname = "localhost"
               Username = "root"
               Password = "root"
               Name     = "logon1"
               Port     = "3306"
               Type     = "1">

<WorldDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "logon" Port = "3306" Type = "1">

<WorldDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "world1" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "logon1" Port = "3306" Type = "1">

Although You really only need one logon DB unless you need different logon databases or configurations.. I spent a good part of yesterday trying to figure this out. If you make a new connection along with the existing connection you already have and name the databases the same they over write each other.. Hope I explained this well enough to help anyone that doesnt understand databases and how they work..

[09SMalone]

Good guide... worked for me. And that's saying something XD

[jackmobile]

The other guide didn't cover the database details.
So i made a guide on my own

i have seen this exact same guide the exact same words an everything on ac-web

[NaKsos]

very thx!!!!

[Mitron]

this didnt help me much :P cuz i got problems creatung new DBs so can anyone explain very detailed for me how to do using heidiSQL ?????? PLZZZZ