Home › Forum › MultiPlayer Game Hacks & Cheats › Realm of the Mad God Hacks & Cheats › Realm of the Mad God Private Servers › Realm of the Mad God Private Servers Tutorials/Source Code › Devs, want to test with multiple sources?
Devs, want to test with multiple sources?
Devs, want to test with multiple sources?
Just a little something that I wanted to point out to help out some of the honest devs who want to try to work with multiple different sources at once with different database structures.
This tutorial assumes that you have a fair knowledge on how to set up server sources and that you know the basics of editing a server.
You will need:
- XAMPP
- Microsoft Visual Studio (I use 2013 Ultimate)
- Multiple sources with different database structs
- A brain
Alright. I'll quickly go over which sources that devs may seem interested in.
CreepyLava/Kithio's AS3 source
Phoenix 1.9.2
Club559's MMOE leak
All these sources have different structs. But as a regular p-server dev, you don't want to go through the trouble of reimporting struct.sql every single time you want to test on a different source, right?
The answer to this is fairly simple.
Every currently released source uses a MySQL database. This database is stored in your localhost connection. The problem is, if you try to test on Phoenix 1.9.2 right after importing a struct from the CreepyLava source, you'll get so many complaints from server.exe. This is because every single server source has a database named "rotmg". Which means that we can't have two or more "rotmg" databases!
You could use HeidiSQL and workbench for this... but workbench is clunky. It's preferred that you switch over to XAMPP for this. This tutorial process can be repeated as many times as one likes for the problem they encounter, but it'll be focusing around the three aforementioned sources on one computer.
1.) Open up XAMPP control panel and wait for it to load in.
2.) Start up the MySQL service as well as the Apache service. Wait for both their statuses to become green.
3.) On the row of buttons lined up with "MySQL", click on [Admin]. This should open up a webpage in your preferred web browser.
4.) On the menu to the left of the webpage, click "New". This should show some options to the right of it.
5.) Make a memorable and identifiable name. Change the setting to the right from "Collation" to "utf8_general_ci". Then click [Create].
6.) Repeat steps 3 to 5 until you have enough databases for each of your server sources. Remember, 1 database per server.
7.) Time to add the meat in. Double click your first database and then click the "SQL" tab.
Okay... what the heck am I supposed to do here?
It's fairly simple. Every struct.sql for a database is in reality a MySQL query. A query tells the server what to do. In this case, a server struct.sql would tell the server to create tables and columns for our database.
8.) Take a struct.sql from your first source and copy it all. Paste it into the big code box and hit "Go".
9.) If you did it right, you should get a nice green bubble that says "MySQL returned ZERO" or something similar. You have successfully imported the struct at this point.
10.) Repeat steps 7 and 8 for each other server database you have. Make sure you have the proper struct.sql files for each one!
11.) At this point, you've set up a unique, working database for each source you have. Your server.exe's are still configured to look for an "rotmg" database, so let's fix that. Open up the server.sln of your first source.
For most servers, you'll find it in db/Database.cs
Remember to rebuild!
In Kithi's AS3 source, you'll find it in server/server.cfg
12.) Run server.exe AND wServer.exe of each of the sources to confirm whether they work or not. Take it a step further by creating an account on each server and checking to see if you can enter nexus.
Once you've done all these twelve easy steps, you can now test on multiple sources to your heart's content!
Tutorial by me.
This tutorial assumes that you have a fair knowledge on how to set up server sources and that you know the basics of editing a server.
You will need:
- XAMPP
- Microsoft Visual Studio (I use 2013 Ultimate)
- Multiple sources with different database structs
- A brain
Alright. I'll quickly go over which sources that devs may seem interested in.
CreepyLava/Kithio's AS3 source
Phoenix 1.9.2
Club559's MMOE leak
All these sources have different structs. But as a regular p-server dev, you don't want to go through the trouble of reimporting struct.sql every single time you want to test on a different source, right?
The answer to this is fairly simple.
Every currently released source uses a MySQL database. This database is stored in your localhost connection. The problem is, if you try to test on Phoenix 1.9.2 right after importing a struct from the CreepyLava source, you'll get so many complaints from server.exe. This is because every single server source has a database named "rotmg". Which means that we can't have two or more "rotmg" databases!
You could use HeidiSQL and workbench for this... but workbench is clunky. It's preferred that you switch over to XAMPP for this. This tutorial process can be repeated as many times as one likes for the problem they encounter, but it'll be focusing around the three aforementioned sources on one computer.
1.) Open up XAMPP control panel and wait for it to load in.
2.) Start up the MySQL service as well as the Apache service. Wait for both their statuses to become green.
3.) On the row of buttons lined up with "MySQL", click on [Admin]. This should open up a webpage in your preferred web browser.
4.) On the menu to the left of the webpage, click "New". This should show some options to the right of it.
5.) Make a memorable and identifiable name. Change the setting to the right from "Collation" to "utf8_general_ci". Then click [Create].
6.) Repeat steps 3 to 5 until you have enough databases for each of your server sources. Remember, 1 database per server.
7.) Time to add the meat in. Double click your first database and then click the "SQL" tab.
Okay... what the heck am I supposed to do here?
It's fairly simple. Every struct.sql for a database is in reality a MySQL query. A query tells the server what to do. In this case, a server struct.sql would tell the server to create tables and columns for our database.
8.) Take a struct.sql from your first source and copy it all. Paste it into the big code box and hit "Go".
9.) If you did it right, you should get a nice green bubble that says "MySQL returned ZERO" or something similar. You have successfully imported the struct at this point.
10.) Repeat steps 7 and 8 for each other server database you have. Make sure you have the proper struct.sql files for each one!
11.) At this point, you've set up a unique, working database for each source you have. Your server.exe's are still configured to look for an "rotmg" database, so let's fix that. Open up the server.sln of your first source.
For most servers, you'll find it in db/Database.cs
Remember to rebuild!
In Kithi's AS3 source, you'll find it in server/server.cfg
12.) Run server.exe AND wServer.exe of each of the sources to confirm whether they work or not. Take it a step further by creating an account on each server and checking to see if you can enter nexus.
Once you've done all these twelve easy steps, you can now test on multiple sources to your heart's content!
Tutorial by me.
Similar Threads
- Need Help with multiple offsets in Source Code [Visual Basic 2010 Express ]By joshel in Visual Basic Programming4Last post
- 20Last post
- 6Last post
Originally Posted by Organized Chaos
