Here are the steps : 1. First make a copy of your mangos (or your mangos directory), so in the end you’ll get two mangos directory, in this example i was using my own compiled version 4617 (my latest version which is available for download for everyone is 4602) 2. Now you’ll need to create a new realmd id as shown on below image, and you can use below sql query if you’re using my 4602 release but if you’re using lower version, there are two option for you to choose : 1. Upgrade or 2. Adjust the column name accordingly
The above query will automatically assign REALMD ID 2 as it’s ID Number if you didn’t touch anything before in realmd table, and another thing to note is use different value for the WORLD Server PORT (in this example i’m using 8086 3. After finished with the above process, now of course you’ll need to create new Mangos Database first for your second realmd, and to do this we need to create a new database and then import the Mangos-UDB.sql file (if you’re using my 4602 release) or adjust it as necessary if you’re using another release, see below image for the example : 3.1 Creating New Mangos Database
or type mysqladmin -u root -p create database-name … if you can’t see the command used on above image 3.2 Importing Mangos DB
After finished creating new database for your second database, now you’ll need to import the fully working database from before into your newly created mangos database (if you’re using my 4602 release, the [Only registered and activated users can see links. ] name was called mangos-udb.sql and can be found in reaper-eazy-mangos folder) 4. Now you just need to go inside your second mangos directory which is created at step #1 and then open mangosd.conf inside that directory and search for this line : RealmID = 1
and replace it with : RealmID = 2
and then search for : GameType = 1
replace it with : GameType = 0
and now search for : WorldDatabaseInfo = “127.0.0.1;3306;mangos;mangos;mangos”
and replace it with : WorldDatabaseInfo = “127.0.0.1;3306;root;yourpassword;yoursecondmangosdatabasename”
lastly search for : WorldServerPort = 8085
and replace it with : WorldServerPort = 8086
The above step was done because the previous mangos user doesn’t have the privilege to touch that new database name so we need to use root that has global privilege (this is the most quickest and dirtiest way) :P
As a side note, it’d be better for you to create new username for your second database and grant privilege to it for better [Only registered and activated users can see links. ] (it’s not good to use root account) 5. Run the realmd.exe from any of your mangos directory (the first directory which was there before, or the new mangos directory which is created for this purpose), and then run mangosd.exe from the first directory and the second directory
So that result in three new process created … 1 realmd.exe, and 2 mangosd.exe from different directory 6. Now login with your previous username or create a new username and if you’ve done all of the above steps correctly you’ll see two realmd that you can use as shown on below image : 6.1 Realmd Selection Screen 6.2 The first Database With all the characters from before (i think you already saw my character for each screenshot used lol) 6.3 The Second Realmd which is used for this guide
That’s it … i hope you can understand the above explanation … and just like before, if i missed anything just let me know about it
ascent is a sh!t... on ascent almost every hack is working with wpe and ce. not too much hacks working on mangos (i know only one hack that is working on mangos and that is the no cooldown hack... i tested it ).
we love MaNGOS
Last edited by banviktor; 06-18-2008 at 06:43 AM.
just posting to have 10 posts so can send private msgs
Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Rep Power: 2
Reputation: 1
Posts: 12
Join Date: Sep 2007
Location: New York
07-16-2008
I seen this same guide on another site, not sure if you jacked it from someone else or if they jacked it but yea i seen this on another site. Either way its a good guide.
ey can anyone help me? i got a problem everything works clean but i want to make 2 realms use same database cus i have an internet server and a LAN server i want to use same things how?!
make 2 realm on 1 server
... i reeally nead that
... on ascent almost every hack is working with wpe and ce. not too much hacks working on mangos (i know only one hack that is working on mangos and that is the no cooldown hack... i tested it 
