Step 1. Obtain the server package from here and unrar it into a folder of your choice (such as I will be using C:/qrROServer/ for this how-to)
Step 2. Install MySQL (you can get the newest versions here). Make sure you remember your root password, because that is what we will use to configure the qrRO Server with.
Step 3. Install MySQL Control Center or, if you prefer, MySQL Query Browser so that you may run MySQL queries at your whim
Step 4. Open a command prompt and change to your MySQL directory, then change to the bin directory within the MySQL directory (usually, this is something like C:\Program Files\MySQL\MySQL Server x.y\bin\, where x.y is your MySQL version)
Step 4b. If you downloaded MySQL 5 or greater, you will have to do a extra step (no, it's not a bad thing you have version 5). Type in the following two commands, replacing my_password with your root password.
Command Prompt wrote:mysql.exe -uroot -pmy_password
Command Prompt wrote:SET PASSWORD FOR root@localhost = OLD_PASSWORD('my_password');
This makes MySQL 5 have a password that works with the qrRO Servers, which use the old MySQL 4 formatting (so you dont have to constantly upgrade).
Step 5. In the command prompt, type the command below, replacing my_password with your root password and replacing "C:/qrROServer/MySQL.sql" with the actual location of the MySQL.sql script that came with the server package.
Command Prompt wrote:mysql.exe -uroot -pmy_password < "C:/qrROServer/MySQL.sql"
This will create the ragnarok and log databases with the required tables you need to host the server. You can now close the command prompt.
Step 6. Navigate to the folder where you storing your server files (like I said, I'm using C:/qrROServer/ for this example), and then into the conf folder (you wont have to mess with anything else in this folder except the files in the conf directory).
Step 7. Open char_athena.conf and map_athena.conf in notepad (or wordpad, if you prefer). In each file, replace SERVER_USERNAME with the server username and SERVER_PASSWORD with the server password (this will be provided to you by me Codemaster). Replace SERVER_NAME with the name of your server (a bunch of acceptable names can be viewed here). Finally, replace IP_ADDRESS with your WAN IP address (which can be obtained by visiting this website). After you are done configuring the files, save them and close them.
Step 8. Open grf-files.txt. In this file, you will see the default locations of the data.grf, sdata.grf, and qdata.grf. If your Ragnarok Online installation location differs from the locations displayed here, change them to the proper ones, save the files, and close them.
Step 9. If you are not using a router, you can skip this step and move onto step 10; otherwise, keep reading. Open again the char_athena.conf and map_athena.conf files. In these two files, replace all instances of 127.0.0.1 with your LAN IP address (to see what that is, simply run ipconfig from the command-line - normally, a LAN IP is like 192.168.1.100 or 192.168.0.2). Now, open the subnet_athena.conf. In this file, replace 255.0.0.0 with your subnet mask (this can also be found via ipconfig or through your router's settings). Replace 127.0.0.1 again with your LAN IP address.
Step 10. Simply go back to the folder containing all of the server files (just go up a directory) and you should be able to simply run the start_server.bat file to have the server running!
Debugging: If for some reason, the server windows continue to blink open and close, they are crashing and there's a reason why. Try closing both of the infinitespawn programs and attempt to run the char-server.exe and map-sever.exe from the command-line to see what error(s) they reply with.
Updates:
2006/06/13 - 0.901 - Small bugfixes and various updates.
