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.
I love the Comic Sans.
Tutorial is flawless.
Didn't know what was going on at all!
Thank you! I needed this so much!
Tutorial is flawless.
Didn't know what was going on at all!
Thank you! I needed this so much!
Originally Posted by Organized Chaos
i love my mom
Originally Posted by Stellar Spark
i love my mom
How cute :3 honestly lel
Want to get on skype quick m9?
I don't wanna act like I have known about this but , I've been doing this with my source and AS3 for like a week 
Originally Posted by Prince Zuko
I don't wanna act like I have known about this but , I've been doing this with my source and AS3 for like a week
Originally Posted by Kithio
well this is extremely easy
Nice tutorial tho m8
How to test multiple redis source?
1) Swap dump.rdb with source .rdb
2) Load redis server
Or if you too lazy to swap, set each source to a different database (redis server has 16 selectable databases by default). It's as simple as changing a single number in the source.
Sorry, couldn't help myself with this shameless plug. Learning how to work with redis is a worthwhile endeavor. 10 million times better than sql.
1) Swap dump.rdb with source .rdb
2) Load redis server
Or if you too lazy to swap, set each source to a different database (redis server has 16 selectable databases by default). It's as simple as changing a single number in the source.
Sorry, couldn't help myself with this shameless plug. Learning how to work with redis is a worthwhile endeavor. 10 million times better than sql.
The fuck is this?
It's imported.
Edit: Fixed. It just took a couple tries.
Edit 2: The tables are there, but still get server.exe error. Set everything in the database.
Edit 3: I'm stupid. Thanks for the tut.
Originally Posted by sacredmike
The fuck is this?
It's imported.
Originally Posted by sebastianfra12
Wrong password...?
Originally Posted by sacredmike
I fixed it.
where can i download a brain
Originally Posted by TheReafg1000
where can i download a brain
This thread is closed for replies.
