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]
[Only Registered and Activated Users Can See Links. Click Here To Register...]
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)
Code:
[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)
Code:
[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
Code:
数量 = 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]
[Only Registered and Activated Users Can See Links. Click Here To Register...]
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
[Only Registered and Activated Users Can See Links. Click Here To Register...]
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]
[Only Registered and Activated Users Can See Links. Click Here To Register...]
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]
[Only Registered and Activated Users Can See Links. Click Here To Register...]
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 :D
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:
Code:
--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 ²âÊÔ·þÎñÆ÷ - ÊýÁ¿ - 1 or something similar like this chinese1 - chinese2 - 1
3. Change the 测试服务器 or no chinese ²âÊÔ·þÎñÆ÷ or chinese1 to your preferred server name
4. Save it but don't close the server.inf
5. Run LoginServer and click [Play] and it will start running server
6. Run GameServer and click [Play] but this time will refuse to run(because it doesn't let you change the server name) but don't close it
7. Now go back to server.inf and undo back to 测试服务器 or for no Chinese ²âÊÔ·þÎñÆ÷ or chinese1 then save it.
8. Try go back to GameServer and click [Play], this will fool the server that you're having that chinese word server(actually it's mean Test Server)
9. Now you will have your successfully change it
Q2: Help! The channel keep shows Server Maintainence in the Channel selection screen
A: You can try use the trick above(Q1) this will fixes most of your problem
Q3: I'm using RXJH 4.0 but when I try to choose a channel, it stuck there! How to fix it?
A: This is actually a 4.0 version bug, try reboot the server plus make sure you also use the trick from (Q1)
Q4: How come my CPU usage overflow to 100%(single CPU) or 50%(Dual CPU) or 25%(Quad CPU) or etc... so suddenly after my character have reach certain level(such as level 100) or EXP over 2.1bil with using RXJH 2.1 and 3.6
A: This problem cause by the program that not design well to handle such 2.1bil values(since your EXP must be over that values already) and the server are code them in 32bit signed((2^32)/2=2.1bil, why divide? because you got sign values, which mean you will have from -2.1bil till +2.1bil)
Sometimes for RXJH 4.0, you will notice something like negative EXP bar when your total EXP reach 2.1bil
I'm not going to talk about any technical things about 32bit signed or unsigned, try goto Wikipedia to search for your answer :P
[Tips & Trick]
1. Makes every newly created character equipped with specify gold, ki or start with specify level:
Open SQL, create a trigger with these code
Code:
CREATE TRIGGER [song] ON [dbo].[TBL_Char]
after Insert
as
Update [TBL_Char] set [TBL_Char].FLD_FIGHT_EXP='Change to your specify ki point',FLD_MONEY='Change to your specify money',FLD_EXP='Change to your specify exp'
From Inserted
Where [TBL_Char].FLD_ID=inserted.FLD_ID
and [TBL_Char].FLD_NAME=inserted.FLD_NAME
update TBL_Char set FLD_MENOW=****FLD_X=613.6401,FLD_Y=365.9651
where FLD_MENOW='0'
Change the 'change to your specify ki point', 'change to your specify money' and 'change to your specify exp' to the values you want, and save the trigger, this will make your newly create character with having the setting you specified.
Note:Character level is depending FLD_EXP for set the level for the characters, you cannot change the level, because the server is count all the total EXP you have in your character and minus them with the EXP table to get the Level value.
2. To make your server public, edit the server.inf in folder, replace the IP to WAN IP, after that port forward these ports
1300 <<<Login Server
13000 to 13009 <<<Game Server channel port depend how many channel you have for open them, if you only have channel 1, then you just only open 1 port, and you doesn't have to open all of them.
9000 <<<Cash web shop port, for server using cash web shop, make sure you open this to allow client able to connect this port
80 <<<Your website port
How to port forward? Goto
[Only Registered and Activated Users Can See Links. Click Here To Register...] this website will teach you how to port forward your router/modem/behind firewall modem
Well...I hope that's all...Enjoy playing...
