- Joined
- Jul 27, 2008
- Messages
- 889
- Reaction score
- 58
Hello all , Today i will show you how to create a successful server for risk your life part 2 .. first of call you need to download all required stuff . Check below for download section . I don't include at here so please scroll down if you want to download the server files.
------------------------[ MSSQL 2000 ]--
Note : Before start create database you must make a new folder it's call C:/Server/DB before proceed restore process ..
Create a New Database, name it AdminTool. Keep making new ones using the same names as they are files. Continue along with (CASE SENSITIVE, use exactly as put here):
CharDelHistory
Part2_Zodiac
pay_gamemyth
RYLBillingDB_LOG
youxiCard
youxiuser
Follow RYL1 Server Guide steps to restore the databases, replacing the names with the appropriate ones listed here.
Then you need to add data sources, ODBC...not sure why, but it's what RYL1 server guide said to do....just name them appropriately using the username sa and password the one you entered upon install of MSSQL 2000.
------------------------[ MSSQL 2005 ]--
This is the version that I have, and I will explain how to add/restore databases.
By now, I assume you have logged in and you see a folder called 'Databases'. Click the + sign next to it, and you should see a list of databases currently on your server. On the databses folder name...
Right-Click -> New Database
Name it AdminTool. Then click ok.
Right-Click -> New Database
Name it CharDelHistory. Then click ok.
Right-Click -> New Database
Name it Part2_Zodiac. Then click ok.
Right-Click -> New Database
Name it pay_gamemyth. Then click ok.
Right-Click -> New Database
Name it RYLBillingDB_LOG. Then click ok.
Right-Click -> New Database
Name it youxiCard. Then click ok.
Right-Click -> New Database
Name it youxiuser. Then click ok.
There should be a total of 7 new databases created now.
Now on the AdminTool database, Right-Click -> Tasks -> Restore -> Database.
Where it says 'From Device:', make sure it is checked, or selected if you will. From there click the button with the '...'. Then, a window should come up. Click 'Add'. On the botom of the screen that popped up, click on 'Files of Type', and make sure it says All Files(*), or you will not be able to see your database backups to restore. Navigate yourself through there to your folder where you saved the serverfiles to. Inside the Server Files folder, go to the comdatabase folder and select the file named 'AdminTool'. Then click 'Ok'. Click 'Ok' again, and you should be at the screen you started at, except there is a file in thelist. Check the file that appeared, then on the left, click 'Options'. The first checkbox that says 'Overwrite the existing database', should be checked. After it is, go ahead and click 'Ok' on the bottom right. It should take a couple seconds, but that is how you will get all the info in all of the databases we created. Just keep doing it for each individual database, matching it up with the correct name for the restore database.
------------------------[ Setting up Server Files ]--
Now, unless you understand Japanese (Taiwan or w.e the language is), I suggest you get an english translation of the Server Setup. Download it here:
Now, go back to your Server files directory (the one we extracted earlier to the desktop) and replace that exe with the one in the server files directory. It's now english and much easier to read =P
Now, double click the server setup, and a screen should popup, in nice english.
Login Tab:
Least Version: put in 1600, or whatever version you want
Patch Address: Your IP
Auth Tab:
ServerType: YouxiLandAuth
Server Group: 0=0
DB Agent Address: Your IP
Leave all checkboxes unchecked.
Click 'DataSource Config':
DB Type: MSSQL
DB Address: Your IP
DB Name: youxiuser
DB Username: sa
DB Password: Your Password
Click 'ok'.
Click 'AdminTool Config':
DB Type: MSSQL
DB Address: Your IP
DB Name: AdminTool
DB Username: sa
DB Password: Your Password
Click 'ok'.
Game Tab
Zone Count should be 3, so click 'Add' until it goes up to three.
Zone: 0=Default
Current selection: make it Zone Count 1.
Server Group: 0=0
Server Zone: Zone8 (Caernarvon)
DB Agent Address: Your IP
LogServer Address: Your IP
ChatServer Address: Your IP
Exp Rate: any # you wish, mines at 500
Drop Rate: any # you wish, mines at 500
Min Fame: 0
Max Fame: any # you wish, mines at 90000
Limit User Number (BattleGround): Any # you wish, mine is at 50
Repeat those steps for each zone under the Game tab, except on the server Zone select, change zone count 2 to Zone 12 (Almighty Ground) and zone count 3 to Zone 14 (Prison)
Agent Tab
Server Group: 5=5
Nation: 0=Test
Server Type: Part2
BillingType: GamaBilling
Version: Your version that you want, mine is 1602
Sum Check: Since mine is 1602, my checksum is 0x414CA637, but you need to get a different one if you are using a diff version.
Patch Address: Your IP
UID Server Address: Your IP
Click 'Game DB Config':
DB Type: MSSQL
DB Address: Your IP
DB Name: Part2_Zodiac
DB Username: sa
DB Password: Your Password
Click 'ok'.
Server Group: 0
Battle Ground: 0
Keeper Tab
Check 'Free Mode'
Server Type: GamaBilling
HanUnitedBillingAddress: Your IP
Click 'Keeper DB Config':
DB Type: MSSQL
DB Address: Your IP
DB Name: pay_gamemyth
DB User: sa
DB Password: Your Password
Click 'ok'.
Log And Chat Tab
Click 'Log DB Config':
DB Type: MSSQL
DB Address: Your IP
DB Name: youxiCard
DB User: sa
DB Password: Your Password
Click 'ok'.
Under Chat Server:
Server Group: TEST
Server Channel: CH1
Agent Server Address: Your IP
Click 'AdminTool DB Config':
DB Type: MSSQL
DB Address: Your IP
DB Name: AdminTool
DB User: sa
DB Password: Your Password
Click 'ok'.
Click Menu -> Save Config
Exit.
------------------------[ Setting up GameServer.exe ]--
As mentioned before, a way to start every map on its own server is this. Go to your 'Release' folder. Copy RylGameServer.exe twice. You should have 2 copies of it in that directory now. Rename one of them to 'RylGameserver2.exe', then the other one to 'RylGameServer3.exe'. There should be an icon in that folder called 'map12', Right-Click -> Properties. Under 'Traget, change 'RylGameServer.exe' to 'RylGameServer2.exe'. Click 'Ok'. There should be an icon in that folder called 'map14', Right-Click -> Properties. Under 'Traget, change 'RylGameServer.exe' to 'RylGameServer3.exe'. Click 'Ok'.
------------------------[ Setting up Server Configs ]--
Navigate to the 'Release\Script\Server' directory. There, you will find several files. From what I know is this: Any usernames entered into the 'account/txt' file, that means they are banned.
Open 'ServerGroup.txt' in NotePad. Create 7 lines worth of names. Ex:
TEST
File -> Save
Assuming you have entered all values in correctly, and you have no firewall up, ports are forwarded, your SQL server is setup correctly, you should be able to start up all your servers in the release folder. I have found that starting them up in a certain order will prov better in the way they connect with eachother. Go to your 'Release' folder and do this starting order:
RylLoginServer.exe
RylUIDServer.exe
RylDBAgentServer.exe
RylAuthServer.exe
RylChatServer.exe
Then proceed to double clicking your map8, map12, and map14 icons. You should see a total of 8 icons in your toolbar.
(Note: In my experience, RylUIDServer.exe does not lke to start up right away. Keep trying until you get the icon to show up in your sys tray.
Last step, on your tray, you should seee your LoginServer icon first. Right click it, and the second arrow up, select the option in there. (Sorry, don't know how to read little squares lol.) That means it is allowing people to conect to the login server, and it is now ready to be logged in.
Your Server is now able to be logged in to!
------------------------[ Creating User Accounts ]--
Open up Enterprise Manager, or MSSQL Server Manage Tool, and naviagate yourself to the youxiuser database. Click on Tables, and on the table called 'usertbl' Right Click -> Open Table (For 2005) or Right-Click -> Return All Rows (For 2000). A new screen will show up. Click on the field called 'account' and put in your desired account name, and click on the field called 'passwd' and enter your desired password. It should automatically save after closing the window. That is how you create a login. =)
(Note: You cannot edit the UID, as it is an Auto Increment field)
-----------------------------------------------------------------------------------------------------
Create GM Account
-----------------------------------------------------------------------------------------------------
Navigate to Database>Youxiuser>Tables>UserTBL> Look for account that you want to create gm account + Copy it
Then navigate to Database>Part2_Zodiac>Tables>Adminlist > Edit (UID) + Admin Level 1 (GM Support) or Admin Level 2 (Operator Level 1) or Admin Level 3 (Operator Level 2) or Admin Level 5 (Developer @ Admin)
Note : There is no Admin Level 4 if im not wrong except level 1,2,3 and 5
-----------------------------------------------------------------------------------------------------
FIX SERVER ERROR IN (LAN MODE)
-----------------------------------------------------------------------------------------------------
Navigate in MSSQL Server
Database > Youxiuser > Store Procedure > SP_SearchUserAccount .. Replace With this
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[sp_SearchUserAccount]
@UID int,
@account varchar(20)
AS
set nocount on
if @UID is not null
begin
select uid,account
from youxiuser.dbo.usertbl
where uid=@UID
end
else
begin
select uid,account
from youxiuser.dbo.usertbl
where account=@account
end
=======================================================================
Download Links
=======================================================================
Server Files + MCF Editor (Newbie editor) :
RYL2 Armageddon Server Files :
Max Level 125 (v2240) [Link Update] :
ROW Server Files :
NO Sound (RYL2 Only) :
RYL Coderz :
RYL AutoUpdate @ Patch Creator :
RYLUS GameGuard Server (Link Update) :
Dark And Light Patch Texture (Link Update) :
Clean Database v2240 [Link Updated] :
Compiler (1753-2240)(All Editor except chemical) [Link Updated] :
Kalpyloso Site (Link Update) :
SQL 2000 :
SQL 2005 :
SQL 2008 :
Note : I Will Keep This Post Up To Date .. Coming Soon RYL2 Server Tutorial Videos
=======================================================================
Original Guide By : D3MON .. Edited by : woodclaw
=======================================================================
------------------------[ MSSQL 2000 ]--
Note : Before start create database you must make a new folder it's call C:/Server/DB before proceed restore process ..
Create a New Database, name it AdminTool. Keep making new ones using the same names as they are files. Continue along with (CASE SENSITIVE, use exactly as put here):
CharDelHistory
Part2_Zodiac
pay_gamemyth
RYLBillingDB_LOG
youxiCard
youxiuser
Follow RYL1 Server Guide steps to restore the databases, replacing the names with the appropriate ones listed here.
Then you need to add data sources, ODBC...not sure why, but it's what RYL1 server guide said to do....just name them appropriately using the username sa and password the one you entered upon install of MSSQL 2000.
------------------------[ MSSQL 2005 ]--
This is the version that I have, and I will explain how to add/restore databases.
By now, I assume you have logged in and you see a folder called 'Databases'. Click the + sign next to it, and you should see a list of databases currently on your server. On the databses folder name...
Right-Click -> New Database
Name it AdminTool. Then click ok.
Right-Click -> New Database
Name it CharDelHistory. Then click ok.
Right-Click -> New Database
Name it Part2_Zodiac. Then click ok.
Right-Click -> New Database
Name it pay_gamemyth. Then click ok.
Right-Click -> New Database
Name it RYLBillingDB_LOG. Then click ok.
Right-Click -> New Database
Name it youxiCard. Then click ok.
Right-Click -> New Database
Name it youxiuser. Then click ok.
There should be a total of 7 new databases created now.
Now on the AdminTool database, Right-Click -> Tasks -> Restore -> Database.
Where it says 'From Device:', make sure it is checked, or selected if you will. From there click the button with the '...'. Then, a window should come up. Click 'Add'. On the botom of the screen that popped up, click on 'Files of Type', and make sure it says All Files(*), or you will not be able to see your database backups to restore. Navigate yourself through there to your folder where you saved the serverfiles to. Inside the Server Files folder, go to the comdatabase folder and select the file named 'AdminTool'. Then click 'Ok'. Click 'Ok' again, and you should be at the screen you started at, except there is a file in thelist. Check the file that appeared, then on the left, click 'Options'. The first checkbox that says 'Overwrite the existing database', should be checked. After it is, go ahead and click 'Ok' on the bottom right. It should take a couple seconds, but that is how you will get all the info in all of the databases we created. Just keep doing it for each individual database, matching it up with the correct name for the restore database.
------------------------[ Setting up Server Files ]--
Now, unless you understand Japanese (Taiwan or w.e the language is), I suggest you get an english translation of the Server Setup. Download it here:
Now, go back to your Server files directory (the one we extracted earlier to the desktop) and replace that exe with the one in the server files directory. It's now english and much easier to read =P
Now, double click the server setup, and a screen should popup, in nice english.
Login Tab:
Least Version: put in 1600, or whatever version you want
Patch Address: Your IP
Auth Tab:
ServerType: YouxiLandAuth
Server Group: 0=0
DB Agent Address: Your IP
Leave all checkboxes unchecked.
Click 'DataSource Config':
DB Type: MSSQL
DB Address: Your IP
DB Name: youxiuser
DB Username: sa
DB Password: Your Password
Click 'ok'.
Click 'AdminTool Config':
DB Type: MSSQL
DB Address: Your IP
DB Name: AdminTool
DB Username: sa
DB Password: Your Password
Click 'ok'.
Game Tab
Zone Count should be 3, so click 'Add' until it goes up to three.
Zone: 0=Default
Current selection: make it Zone Count 1.
Server Group: 0=0
Server Zone: Zone8 (Caernarvon)
DB Agent Address: Your IP
LogServer Address: Your IP
ChatServer Address: Your IP
Exp Rate: any # you wish, mines at 500
Drop Rate: any # you wish, mines at 500
Min Fame: 0
Max Fame: any # you wish, mines at 90000
Limit User Number (BattleGround): Any # you wish, mine is at 50
Repeat those steps for each zone under the Game tab, except on the server Zone select, change zone count 2 to Zone 12 (Almighty Ground) and zone count 3 to Zone 14 (Prison)
Agent Tab
Server Group: 5=5
Nation: 0=Test
Server Type: Part2
BillingType: GamaBilling
Version: Your version that you want, mine is 1602
Sum Check: Since mine is 1602, my checksum is 0x414CA637, but you need to get a different one if you are using a diff version.
Patch Address: Your IP
UID Server Address: Your IP
Click 'Game DB Config':
DB Type: MSSQL
DB Address: Your IP
DB Name: Part2_Zodiac
DB Username: sa
DB Password: Your Password
Click 'ok'.
Server Group: 0
Battle Ground: 0
Keeper Tab
Check 'Free Mode'
Server Type: GamaBilling
HanUnitedBillingAddress: Your IP
Click 'Keeper DB Config':
DB Type: MSSQL
DB Address: Your IP
DB Name: pay_gamemyth
DB User: sa
DB Password: Your Password
Click 'ok'.
Log And Chat Tab
Click 'Log DB Config':
DB Type: MSSQL
DB Address: Your IP
DB Name: youxiCard
DB User: sa
DB Password: Your Password
Click 'ok'.
Under Chat Server:
Server Group: TEST
Server Channel: CH1
Agent Server Address: Your IP
Click 'AdminTool DB Config':
DB Type: MSSQL
DB Address: Your IP
DB Name: AdminTool
DB User: sa
DB Password: Your Password
Click 'ok'.
Click Menu -> Save Config
Exit.
------------------------[ Setting up GameServer.exe ]--
As mentioned before, a way to start every map on its own server is this. Go to your 'Release' folder. Copy RylGameServer.exe twice. You should have 2 copies of it in that directory now. Rename one of them to 'RylGameserver2.exe', then the other one to 'RylGameServer3.exe'. There should be an icon in that folder called 'map12', Right-Click -> Properties. Under 'Traget, change 'RylGameServer.exe' to 'RylGameServer2.exe'. Click 'Ok'. There should be an icon in that folder called 'map14', Right-Click -> Properties. Under 'Traget, change 'RylGameServer.exe' to 'RylGameServer3.exe'. Click 'Ok'.
------------------------[ Setting up Server Configs ]--
Navigate to the 'Release\Script\Server' directory. There, you will find several files. From what I know is this: Any usernames entered into the 'account/txt' file, that means they are banned.
Open 'ServerGroup.txt' in NotePad. Create 7 lines worth of names. Ex:
TEST
File -> Save
Assuming you have entered all values in correctly, and you have no firewall up, ports are forwarded, your SQL server is setup correctly, you should be able to start up all your servers in the release folder. I have found that starting them up in a certain order will prov better in the way they connect with eachother. Go to your 'Release' folder and do this starting order:
RylLoginServer.exe
RylUIDServer.exe
RylDBAgentServer.exe
RylAuthServer.exe
RylChatServer.exe
Then proceed to double clicking your map8, map12, and map14 icons. You should see a total of 8 icons in your toolbar.
(Note: In my experience, RylUIDServer.exe does not lke to start up right away. Keep trying until you get the icon to show up in your sys tray.
Last step, on your tray, you should seee your LoginServer icon first. Right click it, and the second arrow up, select the option in there. (Sorry, don't know how to read little squares lol.) That means it is allowing people to conect to the login server, and it is now ready to be logged in.
Your Server is now able to be logged in to!
------------------------[ Creating User Accounts ]--
Open up Enterprise Manager, or MSSQL Server Manage Tool, and naviagate yourself to the youxiuser database. Click on Tables, and on the table called 'usertbl' Right Click -> Open Table (For 2005) or Right-Click -> Return All Rows (For 2000). A new screen will show up. Click on the field called 'account' and put in your desired account name, and click on the field called 'passwd' and enter your desired password. It should automatically save after closing the window. That is how you create a login. =)
(Note: You cannot edit the UID, as it is an Auto Increment field)
-----------------------------------------------------------------------------------------------------
Create GM Account
-----------------------------------------------------------------------------------------------------
Navigate to Database>Youxiuser>Tables>UserTBL> Look for account that you want to create gm account + Copy it
Then navigate to Database>Part2_Zodiac>Tables>Adminlist > Edit (UID) + Admin Level 1 (GM Support) or Admin Level 2 (Operator Level 1) or Admin Level 3 (Operator Level 2) or Admin Level 5 (Developer @ Admin)
Note : There is no Admin Level 4 if im not wrong except level 1,2,3 and 5
-----------------------------------------------------------------------------------------------------
FIX SERVER ERROR IN (LAN MODE)
-----------------------------------------------------------------------------------------------------
Navigate in MSSQL Server
Database > Youxiuser > Store Procedure > SP_SearchUserAccount .. Replace With this
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[sp_SearchUserAccount]
@UID int,
@account varchar(20)
AS
set nocount on
if @UID is not null
begin
select uid,account
from youxiuser.dbo.usertbl
where uid=@UID
end
else
begin
select uid,account
from youxiuser.dbo.usertbl
where account=@account
end
=======================================================================
Download Links
=======================================================================
Server Files + MCF Editor (Newbie editor) :
To view the content, you need to sign in or register
RYL2 Armageddon Server Files :
To view the content, you need to sign in or register
Max Level 125 (v2240) [Link Update] :
To view the content, you need to sign in or register
ROW Server Files :
To view the content, you need to sign in or register
NO Sound (RYL2 Only) :
To view the content, you need to sign in or register
RYL Coderz :
To view the content, you need to sign in or register
RYL AutoUpdate @ Patch Creator :
To view the content, you need to sign in or register
RYLUS GameGuard Server (Link Update) :
To view the content, you need to sign in or register
Dark And Light Patch Texture (Link Update) :
To view the content, you need to sign in or register
Clean Database v2240 [Link Updated] :
To view the content, you need to sign in or register
Compiler (1753-2240)(All Editor except chemical) [Link Updated] :
To view the content, you need to sign in or register
Kalpyloso Site (Link Update) :
To view the content, you need to sign in or register
SQL 2000 :
To view the content, you need to sign in or register
SQL 2005 :
To view the content, you need to sign in or register
SQL 2008 :
To view the content, you need to sign in or register
Note : I Will Keep This Post Up To Date .. Coming Soon RYL2 Server Tutorial Videos
=======================================================================
Original Guide By : D3MON .. Edited by : woodclaw
=======================================================================
Last edited:
) .. its mel ol
