Making your own MMORPG "RoHan" Guide

Making your own rohan private server is not so hard. Simply follow the steps below.
Let's start.

Step 1. You need to download the files below.

Microsoft SQL Server 2008 R2 (You need to pick one base on your computer)
*64 Bit (SQLEXPRWT_x64_ENU.exe / 247.5 MB) Download
*32 Bit (SQLEXPRWT_x86_ENU.exe / 235.5 MB) Download

(How to install SQL Server 2008 R2? Kindly follow this link)

*Rohan Server Files (261 MB) Download
*Rohan Database Files (4 MB) Download
*Rohan Full Client (0.00 KB) Unavailable
*Rohan Registry (1.03 KB) Download
*Xampp (71 MB) Download

Step 2. Extract Rohan Database Files and put it to your C:\ directory.
Step 3. Restore Rohan Database Files.

If you don't know how to restore Database Files, please follow the video below.

Run this query below after restoring your database files.
UPDATE RohanUser.dbo.TServer set Server_IP = "127.0.0.1"
Change 127.0.0.1 to your IP Address, and hit F5 to execute the query.

Step 4.Extract Rohan Server Files and move it to your C;\ directory, in my case my rohan full directory is on "C:\RoHan\" better to copy this one to avoid errors.

Step 5. Editing your registry files.
*Follow the video below.

Step 6. Running your servers.
*On your Rohan directory which is on "C:\Rohan\" navigate to Fairy folder.

*You need to run "DBServerT.exe" first, you can find it on "DBServer" folder. you need to wait until dbservert.exe loads all database settings before running the "LogServer.exe".

*Run "LogServer.exe", you can find it on "LogServer" folder.
*Run "MapID.exe", you can find it on "MapID" folder.
*Run "AIServer.exe", you can find it on "AIServer" folder.

Step 7. Setting up your RohanAuth.

*Extract Xampp and put it to your C:\ directory. Which means, xampp will be place on "C:\Xampp" directory.

*Navigate to C:\Xampp\htdocs\RohanAuth and edit ServerList5.php
Replace 127.0.0.1 to your IP Address.

*Navigate to C:\Xampp\htdocs\RohanAuth\ and edit dbconn.php
Change servername,uid,pw values with yours.

Step 8. Start XAMPP, just simple navigate to your xampp directory and run xampp-control.exe and start Apache.

Step 9. Register new account.

*Open SQL Server 2008 R2 Management studio.
*Run the query  below.
INSERT INTO RohanUser.dbo.TUser (login_id,login_pw,grade) VALUES ('yourusername','yourmd5password',250)

Replace yourusername to your username
Replace yourmd5password to your password, you need to encrypt your password to MD5 Hash, you can simply go to this Page  and encrypt your password.
Example : my username is "Admin" and password is "User" my query will be like this.

For GM Account
INSERT INTO RohanUser.dbo.TUser (login_id,login_pw,grade) VALUES ('Admin','ee11cbb19052e40b07aac0ca060c23ee',250)

For Normal Account
INSERT INTO RohanUser.dbo.TUser (login_id,login_pw,grade) VALUES ('Admin','ee11cbb19052e40b07aac0ca060c23ee',249)

Note : Grade 250 is Admin/GM Account, Grade 249 is a normal account.

Step 10. Running the game.

*Open notepad and the line below.

@echo off
Start Rohanclient.exe "https://127.0.0.1/"

and save as Start.bat. Make sure the "Save as type" is on "All Files (*.*)"

Copy your Start.bat to your RohanFolder and run.

Step 11. Play the Game!

Enjoy!!