[TUT] Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Express)

[playforfun]

Before I want to teach everyone on set-up. I want to thanks to this forum, and everyones nice guides(because they started their first guide), and the person who start emulating RXJH server(don't know who it is haha) and (of course) Mgame who make this game(without them, I don't think RXJH, Yulgang, SOF or whatsoever will exist )

Since I have too many free times, and I have finish move my private server database to my new Server Box, now I can try messing up my PC

[WARNING]: Make sure you do have Administrative Power for your Windows Account and login to the account that have administrative power. If you don't have, ask your computer's administrator, or set-up your ownself an administrative account.
Without it, you will have a big trouble time later on

[NOTE]: Windows Vista or Server 2008(Longhorn) user, make sure you run the server/installation with using administration.
To run it as administration, right click the program you want to run and choose "Run as Administration". This will solve the problem that are same as above warning.

Before we start, make sure you have the following items:
1. RXJH Server

You must be registered to see links

(alot of bugs, skill bug and most of the database are incomplete)

You must be registered to see links

(fixes the gems and stone and some minor bugs

You must be registered to see links

(most of skill are working(Healer skills working but not Archer's Buff), EXP can more than 2.1bil values but still not sure why it will show negative % in the EXP bar(maybe 32bit problem))
-Download either one you prefer(but I recommended 4.0 because many bugs fixes )

2. Client Launcher(See below: Setting Client and Launcher section)

3. Game Client Version 17100
-

You must be registered to see links

- Modified with some 20% English text(Mediafire):

You must be registered to see links

You must be registered to see links

You must be registered to see links

You must be registered to see links

You must be registered to see links

Note1: download all the parts, then open the part 1 and extract it using WinRAR or any RAR extractor(7zip) and place them in a folder(in this case RXJH, Yulgang or SOF folder or any name you like)
Note2: the modfied version has been removed the original Mgame launcher(since we not going to use it)

4. Microsoft SQL

You must be registered to see links

2000 Full Version

You must be registered to see links

and

You must be registered to see links

(required both)
-Download either one you prefer(except 2K full version )

5. AppLocale(If you don't wish to install East Asian Language but don't want to see garbage word) or your Windows XP CD(for installing East Asian Language and change to Chinese PRC)

6. WAMP, XAMPP, LAMP, or any webserver you like to use(as long as it have MSSQL plugin and php) for your RXJH Registration Web

7. Registration web files(if you wish to use nice way instead of query SQL for the registration account )

After you have them on your hand.

1. Firstly, unpack/unzip/extract the RXJH server and place them in the place that easily for you to access(I will use root drive(C:\) in this guide )

2. Now let us start install M$SQL server
--For MSSQL 2K(Evaluation and Full Version)--
1. Place the CD and wait for autorun menu appear(if it doesn't appear, goto My Computer>Right click your CDROM drive and select Open>Run the autorun program(icon got a PC with 2 diskettes))
2. You may see the menu, click "SQL Server Components"(or press ALT+C) after that it will bring next screen and click "Install Database Server"(or press ALT+S)
[Picture 1]

Note:The above pictures may vary depending what version you're using.
3. In the installer. The first page will have "Welcome to the Microsoft SQL Server Installation Wizard", just click Next.
4. In the 2nd page(title: Computer Name), select "Local Computer" and click Next
5. In the 3rd page(title: Installation Selection), select "Create a new instance of SQL Server, or install Client Tools" and click Next
6. In the 4th page(title: User Information), just type your name and company(put anything you like, doesn't have to be real) and click Next
7. In the 5th page(title: Software License Agreement), click Yes(or if you wish to read the License Agreement first, you may do so otherwise click Yes )
8. In the 6th page(title: Installation Definition), this is the most interesting part, there are 3 selections
-Client Tools Only << Install SQL Management Enterprise only(if you have existing server and just wish to do Query only)
-Server and Client Tools << Install SQL Server, SQL Management Enterprise and all sorts of things(full install)
-Connectivity Only << Install ODBC and network library only
From now, select "Server and Client Tools" and click Next(unless you know what you're doing you may choose other option;P)
9. In the 7th page(title: Instance Name), make sure you check the "Default" and click Next.
Note: you may also key in different name for your Server Instance Name, but you have to uncheck "Default" first
10. In the 8th page(title: Setup Type), select typical and click Next.
Note: You may change the installation destination folder if your root drive(usually C:\) out of space)
11. In the 9th page(title: Services Accounts), just follow the pictures (refer picture 2 and 3)
[Picture 2]

[Picture 3]

12. In the 10th page(title: Authentication Mode), make sure you choose "Mixed Mode(Windows Authentication and SQL Server Authentication)" and enter the password for your SA account(never ever blank it)(refer picture 4)
[Picture 4]

13. In the 11th page(title: Start Copying Files), just click Next for start installation(wait for a few seconds if not minutes ), after that click Finish
14. Now we have to do is to check the SQL server running or not. Goto Start>Programs>Microsoft SQL Server>Service Manager
a. Just click the [Play Button] Start/Continue
b. If you receive "The Service did not start due to a logon failure." continue follow it to fix the problem. If it is working and running, just skip to part 15
c. Goto Control Panel>Administrative Tools>Services
d. In the left side choose "Services(Local)" and at the right side find "MSSQLSERVER" then double click it and follow the pictures(refer picture 5)
[Picture 5]

e. Right click "MSSQLSERVER" and click Start and it should be start the service now
15. Next is to restore RXJH SQL database to your first SQL server. Goto Start>Programs>Microsoft SQL Server>Enterprise Manager
16. In the SQL Server Enterprise Management screen, your first thing need to do are configure your Enterprise Manager always use SA account for login to the SQL database. Just follow the picture on how to do it(refer picture 6)
[Picture 6]

17. Expand your SQL Server(usually are (LOCAL) or (127.0.0.1) or your PC/Server name/IP address plus end with (Windows NT) until "Databases" folder
18. Right click "Databases" and choose "New Database..."
19. In "Database Properties" page, key in the database name called "rxjhaccount" and click OK
20. Do the same step 18 till 19 for adding new database as database name "rxjhgame" and "rxjhweb"
21. You will have "rxjhaccount", "rxjhgame", and "rxjhweb" databases in your Databases folder(refer picture 7)
[Picture 7]

22. Right click "rxjhaccount" and goto All Tasks>Restore Database...
23. In the "Restore database" page, click "From device" then click "Select Device"
24. Then in the "Choose Restore Devices" page, click "Disk" and click "Add"
25. Then in the "Choose Restore Destination" page, click "..." and browse to RXJH Server folder that just now you did unpack/unzip/extract. Inside have a folder called "database" or "原始数据"(chinese word:"database"), and open the rxjhaccount
26. Open it and you will back to "Choose Restore Destination" then click OK, after you will back to "Choose Restore Devices" click OK, then you will back to "Restore database" screen", click [Option] tab
27. Check the "Force restore over existing database" and make sure you also put a valid path to save the database. Follow the pictures if you don't know how (refer picture 8)
[Picture 8]

-Note: Make a folder called "db" or anything you prefer in your Hard Disk if you don't wish your root drive messy with all database files around the conner.
28. Do the same step 22 till 27 for restoring "rxjhgame" and "rxjhweb" database
29. Now you have successfully complete the SQL database setting. Please refer to Setting Up RXJH Server at below

--For MSSQL 2K5 Express--
1. Place the CD or open the setup files that you have downloaded from Microsoft website
2. Follow the on screen to finish the installation.
3. For the Registration Information, just fill your name and company(doesn't have to be true)
4. At feature Selection screen, change the Installation Path(if your root drive doesn't have enough space ) or leave it as default
5. After that in the next screen(title: Authentication Mode) choose "Mixed Mode(Windows Authentication and SQL Server Authentication" and key in the password for "SA" account(Never ever leave blank)
6. In the next screen(title: Error and Usage Report Settings) just uncheck those two, unless you wish M$ know what are you doing to your SQL server
7. In the next screen, just click Install and wait it finish installation(usually this will takes few seconds if not minutes)
8. After that install the SQL Server Management Studio Express that you have downloaded from Microsoft website
9. Just follow the on screen and you will finish installation in no time(note: if you wish to change the Destination path, you may change it).
10. First we need to do are restoring the database
11. Goto Start>Programs>Microsoft SQL Server 2005>Microsoft SQL Server Management Studio Express
12. In the "Connect to Server" screen.
-Change the Authentication to SQL Server Authentication
-For login, use "sa" without quote
-For password, use the password that you did for SQL installation
-Check "Remember Password" if you don't wish to always prompt password
-Click Connect
13. After you have login your SQL Server, right click Databases from left side and click [Restore Database...]
14. In Restore Database, just follow the picture(refer picture 2k5_1)
[Picture 2k5_1]

15. Change the "files of type" to [All Files(*)], then browse to RXJH Server folder that just now you did unpack/unzip/extract. Inside have a folder called "database" or "原始数据"(chinese word:"database"), and open the rxjhaccount
16. After open it, you will back to "Specify Backup" screen, then click OK, and you will back "Restore Database" screen.
17. Check the "rxjhaccount" from "Select the backup sets to restore" then at left side goto [Option]
18. Check the "Overwrite existing database" and make sure you also put a valid path to save the database. Follow the pictures if you don't know how (refer picture 2k5_2)
[Picture 2k5_2]

Will be continue...

 

[playforfun]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

Continue...

3. Setting Up ODBC Connector
1. Goto Start>Setting>Control Panel>Administrative Tools, open Data Sources(ODBC) or use Run>type odbcad32.exe and enter
2. In "ODBC Data Source Administrator" screen, goto System DSN and click "Add"
3. In "Create New Data Source" page, select "SQL Server"(usually are at the end of the list) from the list, and click Finish.
4. In "Create a New Data Source to SQL Server" page, the Name you put it as "rxjhaccount", for the description blank it, and the Server, you may put your PC/Server name or IP address or (local) then click Next(refer picture 9)
[Picture 9]

Note: For SQL 2k5 EXPRESS, you can only use PC/Server name or . or (local) follow by \SQLEXPRESS. IP name doesn't work here.
Example: ServerName\SQLEXPRESS or .\SQLEXPRESS or (local)\SQLEXPRESS
5. In the next page, select "With SQL Server authentication using a login ID and password entered by the user.", check the "Connect to SQL Server to obtain default settings for the additional configuration options" and key in the Login ID as "sa"(without quote) and password that just now you did for the SQL installation, and click Next
6. In the next page, check "Change the default database to" and choose "rxjhaccount" from the list and click Next
7. In the next page, check "Change the language of SQL Server system message to" and choose "Simplified Chinese" from the list and click Finish
8. You may click "Test Data Source..." to check either it is success connect and receive data, otherwise click OK.
9. Do the same step from step 3 till step 8 for adding "rxjhgame" and "rxjhweb" ODBC connector
10. After you have added them you may close the ODBC thingy


4. Setting Up RXJH Server
1. Goto your RXJH folder that you've unpacked/unzipped/extracted
2. First thing you need to do are editing the config files.
3. Edit serverlogin.ini(use any text editor to open them as you like)

[SERVER]
PORT = 1300 <<Use 1300 otherwise if you wish to use other port

[ODBC]
ACCOUNT_DSN = rxjhaccount <<Same as ODBC connector
ACCOUNT_UID = sa
ACCOUNT_PWD = <<Your SA account password>>

4. Next edit servergame.ini(use any text editor to open them as you like)

[SERVER]
;Code ID for your registration when you purchase the RXJH server
;Note: You don't need it, just leave it as blank
CODE = <<leave it as blank>>

;Server.inf must same here, therefore you can't modify it
SEVERNAME = TEST <<<Change to anything as you like 

;Allowable total items that should be in the server, so that the server won't overflow CPU usage
MAPITEM=2000 <<<This will make sure your server carries these amount of item on the floor(if you have lag on your server, try reduce it)

[ODBC]
;Account RXJH SQL database
ACCOUNT_DSN = rxjhaccount <<Same as ODBC connector
ACCOUNT_UID = sa
ACCOUNT_PWD = <<Change to your SA password>>

;Game RXJH SQL database
CHAR_DSN = rxjhgame <<Same as ODBC connector
CHAR_UID = sa
CHAR_PWD = <<Change to your SA password>>

;Cash Web RXJH SQL database
WEB_DSN  = rxjhweb <<Same as ODBC connector
WEB_UID  = sa
WEB_PWD  = <<Change to your SA password>>

[GAME]
;Welcome message for your server
WELCOMEINFO = Welcome to Yulgang Private <<Your Server login welcome message, shouldn't be too long(there is a certain length I've forgot :P)

;Item drop rate by n/80000
GOLD_NOVELITY = 70000 <<Item drop rate, not money drop rate

[GM]
;GM account characters. Maximum 5 GMs allow
NUMBER=2 <<<Total GMs that servers needs to knows, max are 5
;GM1 account ID
ID0=gm01 <<<place your account to turn into GM account

;GM2 account ID
ID1=gm02 <<<same as ID0 but for different account, and depending how many number you have set for GM


[OPTION]
;EXP Rate (1-10000)
ADD_EXP = 500 <<<EXP Rate, from 1 to 10000, don't over it, if not the server will complain about it

;KI Rate (1-10000)
ADD_FIGHT_EXP = 1000 <<<KI Rate, from 1 to 10000, don't over it, if not the server will complain about it

;Money Rate (1-10000)
ADD_MONEY = 1000 <<<Money Rate, from 1 to 10000, don't over it, if not the server will complain about it

;Cash Web address
WEBSHOP_ADDR = 127.0.0.1 <<<Place your cash web shop address here

5. After that, goto logindata folder from RXJH Server folder, and edit the logindata

数量 = 1 <<Change this number for how many channel you want to open
测试服务器 - 数量 - 1 <<Server setting, server name can't be change but there is a trick, I will tell this in other section
Channel-1 - 127.0.0.1 - 1 - 13000 <<Channel setting, channelname - IP - number - port, eg. Channel-1 - 127.0.0.1 - 1 - 13000
测试服务器-2 - 127.0.0.1 - 2 - 13001 <<Same as above
测试服务器-3 - 127.0.0.1 - 3 - 13002 <<Same as above
测试服务器-4 - 127.0.0.1 - 4 - 13003 <<Same as above
测试服务器-5 - 127.0.0.1 - 5 - 13004 <<Same as above
测试服务器-6 - 127.0.0.1 - 6 - 13005 <<Same as above
测试服务器-7 - 127.0.0.1 - 7 - 13006 <<Same as above
测试服务器-8 - 127.0.0.1 - 8 - 13007 <<Same as above
测试服务器-9 - 127.0.0.1 - 9 - 13008 <<Same as above
VIP专线 - 127.0.0.1 - 10 - 13009  <<Same as above
//Above of the IP is for localhost, for using external IP use WAN IP, make sure open the port as well
//Server name can't be change, you can only use "测试服务器"

Note: You doesn't have to change the other channel if you're just only enable few channels

6. Now, open ServerLogin, click the [Play] button at top left to run the server and then open GameServer and also click the [Play] button at top left(refer picture 10)
[Picture 10 - Success running]

7. Congratulation, your server is running, next we will do the Launcher and prepare to login to your server for the first time

5. Setting Client and Launcher
Make sure you have the launcher and game client
For setting up the launcher please refer to http://forum.ragezone.com/showthread.php?t=430906
After you have make your client and launcher, you may try go in the game and try randomly type an ID and password to make sure is it working or not(if you receive "This Account has not been Register" then you're success, if not then you have did set wrong the IP address for the server config and launcher config)


6. Creating game Account
There are few ways you can make accounts, either by using RXJH registration web files or do query SQL for registration
From now I will teach using SQL Query for make account, if you wish to use registration web files, try find the forum
--For MSSQL 2K--
1. Start>Programs>Microsoft SQL Server>Query Analyzer
2. Login your sa account
3. Follow the pictures(refer picture 11)
[Picture 11]

4. In the right side, you may see 1st row with FLD_ID, FLD_PASSWORD until FLD_RXPOINTX and second row with *
5. At row *, fill in your Account ID in FLD_ID, Account Password in FLD_PASSWORD, and Gender in FLD_SEX then close it, this will create your first account
Note: for the gender, 0 or 2 are Female while 1 are Male, not sure why there are 2 gender values for female, but usually both are working.
6. Now try go login your account and you may able to create your characters and go into game.

--For MSSQL 2K5 EXPRESS--
1. Start>Programs>Microsoft SQL Server 2005>SQL Server Management Studio Express
2. Login your sa account
3. Follow the pictures(refer picture 2k5_3)
[Picture 2k5_3]

4. In the right side, you may see 1st row with FLD_ID, FLD_PASSWORD until FLD_RXPOINTX and second row with *
5. At row *, fill in your Account ID in FLD_ID, Account Password in FLD_PASSWORD, and Gender in FLD_SEX
6. Then next you click other rows and then click the CTRL+R or click [!] Execute Button to save the tables, this will create your first account
Note: for the gender, 0 or 2 are Female while 1 are Male, not sure why there are 2 gender values for female, but usually both are working.
7. Try login your account and will be able to login

Alternative way to add account using SQL:
Open SQL Query Analyzer(2K) or SQL Server Management Express(2K5)
Go open your rxjhaccount database and
Do SQL:

--Type them in your DB
--Change [USERNAME] to your Game account ID you wanted to create
--Change [PASSWORD] to the password for your new create account ID
--For [GENDER]:
--0 or 2 means female while 1 are male
--both 0 or 2 are works(not sure why have 2 gender for female)
INSERT INTO TBL_ACCOUNT (FLD_ID,FLD_PASSWORD, FLD_SEX)
VALUES('USERNAME', 'PASSWORD', 'GENDER');

Then press F5(or click Run Execute) to insert them to your table

FAQ
Q1: How to change Server name?
A: To change it:
1. Open server.inf
2. At the second line you will see 测试服务器 - 数量 - 1 or for no Chinese

 

[Garvorious]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

I cant download the RJXv170000 thing. Could you upload it to Mediafire/Rapidshare please?

 

[playforfun]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

I cant download the RJXv170000 thing. Could you upload it to Mediafire/Rapidshare please?

Guides updated with new links to download the game client
Check them up, enjoy

 

[jemelm]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

nice guide!!!!!!!!

 

[hamradio]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

Thanks for
nice Guide

 

[shaikat11]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

err i saw a virus in 4.0 download link up ther? I use Avira AntiVir PE Classic , it detected trojans and html crud? anyone get errors like that?

 

[playforfun]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

err i saw a virus in 4.0 download link up ther? I use Avira AntiVir PE Classic , it detected trojans and html crud? anyone get errors like that?

Erm, it isn't virus... That is false report. Many people in this forum also say that this isn't a virus, it just it detect wrongly.
Actually I use them almost 1 month without any problem on my Server box, and my server still smooth and healthy

Anyway, good luck to play it if you have the confident on using it

 

[AdvancedAngel]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

Okay, I'm not sure if I did this all right. But most likely I didn't because when i launch the client my server is not green its red how do I fix this? Also I can't locate the Gameserver I only found the Loginserver so where can I find it?

 

[playforfun]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

Okay, I'm not sure if I did this all right. But most likely I didn't because when i launch the client my server is not green its red how do I fix this? Also I can't locate the Gameserver I only found the Loginserver so where can I find it?

Either GameServer or ServerGame(or just 2.1 if you're using 2.1 server or 3.6 if 3.6 server)
Try use the server name changing method to fix the server maintenance(server in red word) problem

 

[sonbui]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

can anyone help me
i cant put any ability points or learn any skills
so i cant do promo and cant use skills T_T

 

[syndikt]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

nvm game deleted

 

[meekou]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

help!!

why can't i create a character, i can't even see the character model, when you click the hair color nothing happen....
when i name my chara and check the availabilty, the name is available but when i click the ok, the name is already used, then it register in the sql database...


what seems to be the problem... my server? or my client?, wrong database?

 

[sonbui]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

help!!

why can't i create a character, i can't even see the character model, when you click the hair color nothing happen....
when i name my chara and check the availabilty, the name is available but when i click the ok, the name is already used, then it register in the sql database...


what seems to be the problem... my server? or my client?, wrong database?

why wont u play the new private server

 

[meekou]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

why wont u play the new private server

ohhh?...
i'm using the 4.0 with 5.0 database server,
is there a latest server than 4.0?..

 

[sonbui]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

i cant click on the picture 2,3,4 x.x
it loads up a error page

 

[patrat]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

same as old guide wit updated files LOL

 

[ramiia]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

look at the client, im stuck in the character selection...so therefor i cant create nor select a character, whats wrong? also look at the loginserver and gameserver window is everything alright?

 

[lee1352300]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

look at the client, im stuck in the character selection...so therefor i cant create nor select a character, whats wrong? also look at the loginserver and gameserver window is everything alright?

you may need the 17000 ver client

 

[ramiia]

Re: [Guide]Guide on Set-up RXJH 2.1, 3.6 and 4.0 server + SQL server(2K and 2K5 Expre

ah i forgot to removed this post, i have the server up and running only problem now is...most of the files are in chinese, i would love to get the latest english patch and if possible the latest client that enables you to do all quests