Silkroad Private Servers

[GUIDE]Setup a server without errors [1x GameServer][Files reuploaded]]

Due to the HUGE amount of threads regarding to server file's problems, I created this guide. It can easily be done in less than 1-2 hours(maybe less than 1 hour) if you have a bit of knowledge about how these stuff work.

About the guide:
It is just for the servers that run 1 Gameserver.
It is based on Windows 7.(You can also use it on Windows Server 2008)


***Things you'll need***:
At least 4GB of ram . (More = better)
A decent processor. The files can be ran on a Core 2 Duo processor for example, but the loading time is HUGE!



***Things you'll have to download***:
Server files without Data folder
Data folder - part. 1
Data folder - part. 2
Data folder - part. 3
Data folder - part. 4
Data folder - part. 5
Other files (as Database, Certification, SMC, ODBC Reg. entries and more) Link updated ! ~Thanks to ahmed4ever2u


MSSQL - Download it depends on your Windows version (to find out if it is 32bit or 64bit go to Start-> Right Click on My Computer and Proprietes - SCREEN):
MSSQL 2005 (32 bit)
MSSQL 2005 Server Management Studio(32 bit)
MSSQL 2005 (64 bit)
MSSQL 2005 Server Management Studio(64 bit)

FileZilla Server

========server files====================
Part1 :
Multi: Multiupload.com - upload your files to multiple file hosting sites!
Deposit: Deposit Files

Part2 :
Multi: Multiupload.com - upload your files to multiple file hosting sites!
Deposit: Deposit Files

Part3 :
Multi: Multiupload.com - upload your files to multiple file hosting sites!
Deposit: Deposit Files

More Uploads:
server files:
1-Blitzkrieq_Bin_Data.part01.rar

2-Blitzkrieq_Bin_Data.part02.rar
3-Blitzkrieq_Bin_Data.part03.rar
4-Blitzkrieq_Bin_Data.part04.rar
5-Blitzkrieq_Bin_Data.part04.rar
6-Blitzkrieq_Bin_Data.part06.rar
7-Blitzkrieq_Bin_Data.part07.rar
8-http://www.mediafire.com/?s3en26i3tc37in7

or despoit files

1-Multiupload.nl - upload your files to multiple file hosting sites!
2-Multiupload.nl - upload your files to multiple file hosting sites!
3-Multiupload.nl - upload your files to multiple file hosting sites!
end of server files

SQL
Microsoft SQL Server 2005
>> SQL Server 2005 - 32 bit (x86)
link:http://download.microsoft.com/downlo.../SQLEXPR32.EXE
SQL Server 2005 Managament Studio 32 bit (x86)
link:http://download.microsoft.com/downlo...005_SSMSEE.msi
SQL Server 2005 - 64 bit (x64)
link:http://download.microsoft.com/downlo...96/SQLEXPR.EXE
SQL Server 2005 Managament Studio 64bit (x64)
link:http://download.microsoft.com/downlo...SSMSEE_x64.msi
========Database dumps================
Link : Blitzkrieq_Package_11.09.2011_1.rar

========Changeset obt 247 - 249==========
Link : Multiupload.com - upload your files to multiple file hosting sites!

========Xtrap update files===============
Link : Multiupload.com - upload your files to multiple file hosting sites!

=======Billing asp scripts=================
Link : Multiupload.com - upload your files to multiple file hosting sites!

=======Drew's custom cert===============
Link : Multiupload.com - upload your files to multiple file hosting sites! (you have to modify settings, try doing it on your own)

=======Latest SMC (update removed)=======
Multiupload.com - upload your files to multiple file hosting sites!


TORRENT (3 blitzkrieq_bin_package parts): http://www.mediafire.com/?at01xryelmpbtt9
 
__________________________________________________

So, lets start with the MSSQL setup:









Now, MSSQL Server Management Studio Express:






Now lets create the databases and restore them:
1. Start SQL Server Management Studio Express


2. Create the databases: 



3. Restore the databases:
3.1 Create a folder where you'll keep the databases. (E.g. : Database)
3.2 Create 2 folders inside "Database folder": SRO_LDF_Files and SRO_MDF_Files . It will look something like this:


3.3 Now manually create these files in the corresponding folder:
***You have to change the settings of your folder. It must show the extension of the files.

Go to Organize -> Folder and Search option -> View -> Uncheck "Hide extensions for known file types"***

In MDF Molder:

Quote:
SRO_VT_ACCOUNT_Data.MDF
SRO_VT_SHARD_INIT_Data.MDF
Log_DB.MDF
In LDF Folder:
Quote:
SRO_VT_ACCOUNT_Log.LDF
SRO_VT_SHARD_INIT_Log.LDF
Log_DB_Log.LDF
It will look something like this:


4 Now Database restoring:
4.1 SRO_VT_ACCOUNT
4.2 SRO_VT_SHARD_INIT
4.3 Log_DB
We are done !!Now lets set the ODBC(I added in the "Files" archive some register entries, you can use them but I will show you how to setup them manually):
  SRO_VT_ACCOUNT
Repeat these 6 steps for the other 2 DBs (SRO_VT_SHARD_INIT and Log_DB)
The databases already have all the fixes they need.

Now we'll create the GM account and set the privileged IP !
First we will start with GM account:
In the MSSQL Server Management Studio, go to SRO_VT_ACCOUNT and open the TB_User table.
JID: Keep it clean, it will generate automatically.
StrUserID: The ID you want. (e.g. : testaccount)
Password: You need a MD5 hash code. Go to: MD5 - Online generator md5 hash and hash your password. For example: the password "test1" will give you this md5 hash code "5a105e8b9d40e1329780d62ea2265d8a" . Copy that code and write into your password box.
GMrank: Set it to 1
Sec_primary: Set it to 1
Sec_content: Set it to 1  
Now the privileged IP:
Go to Start-> Search for "Run" and enter it. Inside write "cmd". Inside write IPconfig. Now search for the IPv4 Adress, like in this picture:



Now that you found out your IP, go to: SRO_VT_ACCOUNT -> _PrivilegedIP
Write your IP like this:
  In order to start the server properly (with one GameServer) you'll have to close Alexandria map. How you do that? Pretty simple.

Go to -> SRO_VT_SHARD_INIT -> Search for "_RefRegionBindAssocServer" and Open it.

So, lets make it simple: 1= Open/ 0=Close.
That means you'll have to set "0" to: 

CHINA 1
TQ 1
West_China 1
Oasis_Kingdom 1
Thief Village 1
Roc 1
Eu 1
Am 1
Ca 1
SD 0
KingsValley 0
Pharaoh 0
DELTA 0
TEMPLE 0
FORT_JA_AREA 1
FORT_DW_AREA 0
FORT_HT_AREA 1
FORT_CT_AREA 0
FORT_SK_AREA 0
FORT_BJ_AREA 1
FORT_HM_AREA 1
FORT_ER_AREA 1
ARENA_OCCUPY 1
ARENA_FLAG 1
ARENA_SCORE 1
SIEGE_DUNGEON 1
ARENA_GNGWC 0
GOD_TOGUI 1
GOD_WRECK_IN 1
GOD_FLAME 1
GOD_WRECK_OUT 1
EVENT_GHOST 0
JUPITER 0
PRISON 0
GM_EVENT 0

Now IIS and FTP server.

We'll start with IIS setup and configuration.
Go to: Control panel -> Program and Features -> (on the upper left corner) Turn Windows features on or off.



Now go to: Start-> and search for IIS (Internet Information Service Manager)
Now explore the website directory:


Now in that folder add the files from (IIS Files) folder.
ow edit DBConnect.asp like this:

Quote:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=YOURPCNAME\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=your password;"
DBConnA.Open strConnectA

%>
Now go to:


Enable it:

Also, go to:

Modify the port from 80 to 8080:
Now start it:



And you can test if it is working like this:
.yourIP

FTP server:You downloaded earlier FileZilla Server.

Lets install it:







Now, modify this IP if you have a static IP. I don't have one so I'll use my localhost IP and also set a password.



Now, go to Edit-> Users, and now add your FTP account like I did in the picture:



Now, set your FTP password and then go to "Shared Folders":
 
Now, lets create a folder for the FTP server where we'll store the files (You can create it wherever you want!) and browse it as the picture shows you: Now, set the permissions: Now you are done with the FTP setup.
Now, lets begin with the server files setup.

Extract all the archives in one folder, as you wish. Keep them somewhere you can find them very fast.

We will start with Certification:
Go to the Certification folder that I gave you in the "Files archive" and then open the "ini" folder.

You have to modify just 3 files in order to start your Certification.

1. Open srGlobalService.ini and you'll see this inside.

Quote:
[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=Database Server Name;DSN=SRO_VT_ACCOUNT;UID=user;PWD=password;DATA BASE=SRO_VT_ACCOUNT
global_manager_node_id=697
SERVER = YOURPCNAME\SQLEXPRESS
UID = sa
PWD = password that you set on the MSSQL installation

2. Open srNodeType.ini and you'll see this inside.
Quote:
[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=192.168.1.100
nip=192.168.1.100
machine_manager_node_id=699
wip= YOUR IP (Static ip or local IP - 192.168.x.x)
nip= YOUR IP (Static ip or local IP - 192.168.x.x)

3. Open srShard.ini and you'll see this:
Quote:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=Database server name;DSN=SRO_VT_SHARD_INIT;UID=user;PWD=password;D ATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=Database server name;DSN=Log_DB;UID=user;PWD=password;DATABASE=Log _DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
SERVER =YOURPCNAME\SQLEXPRESS
UID = sa
PWD = password that you set on the MSSQL installation
capacity = Slots of your server

Now go back to Certification folder and run " 1 - compile.bat " and it will show you something like this:



Now run "3 - CustomCertificationServer.bat" and your certification is ready to go.






Now, take the server.cfg that I gave you in the "Files" archive and overwrite it on your server files folder.
Open it and modify as I'll show you:
Common {
debug_option_debugger_present{
DEBUG_OPTION_ASSERT_SHOW_MESSAGEBOX_OKCANCEL,
DEBUG_OPTION_ASSERT_ADVANCE_BREAK,
DEBUG_OPTION_ASSERT_CANCEL_EXIT
}
debug_option_stand_alone{
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}
netengine_debug_option_debugger_present{
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}
netengine_debug_option_stand_alone{
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}

}

////////////////////////////////////////////////////////////////////////////////////////////
GlobalManager {
Certification "192.168.1.100", 32000
LoginFailureTolerance 3
IBUVFailureTolerance 3
LoginFailureBlockTimeMin 0
IBUVFailureBlockTimeMin 0
AutomatedPunisher "AutomatedPunisher"
LoginPunishmentGuide "Blocked for 10 minutes due to incorrect password entered 3 times"
LoginPunishmentDescription "Blocked for 10 minutes due to incorrect password entered 3 times"
IBUVPunishmentGuide "Blocked for 10 minutes due to incorrect code entered 3 times"
IBUVPunishmentDescription "Blocked for 10 minutes due to incorrect code entered 3 times"
}

GatewayServer {
LastFullVersion_SR_Client 130
Certification "192.168.1.100", 15880
IBUVQueueReserveCount 20000
IBUVQueuePrepareRatio 0.10
IBUVFailureIPTolerance 0
IBUVStringSize 1
IBUVCharacterSet "ABCDEF1234567890"
}

DownloadServer {
Certification "192.168.1.100", 15880
}
FarmManager {
Certification "192.168.1.100", 15880
}

AgentServer {
Certification "192.168.1.100", 15882 //no global manager running lol
//traffic_filter_activity "service_off"
//MaxUser 5000
//SockTCPCount 15000
MaxConnectionsPerServer "5000"
MaxConnectionsPer1_OServer "5000"
}

MachineManager {
Certification "192.168.1.100", 15880
CERTIFICATION_IP_BIND "192.168.1.100"
}

SR_GameServer {
Certification "192.168.1.100", 15882
SockTCPCount "5000"
ExpRatio "35000"
ExpRatioParty "35000"
DropItemRatio "5000"
DropGoldAmountCoef "15000"
HwanGainFactor "250"
ShowFormulaDetail "1"

//WINTER_EVENT_2009 EVENT_ON
//EUBUSINESS_EVENT EVENT_ON
//GOLDEN_PIG_FEBRUARY_EVENT EVENT_ON
//THANKS_GIVING_EVENT EVENT_ON
//LIBERATION_EVENT EVENT_ON
LOCALE LOCALE_VIETNAM

//#ifdef OPEN_MARKET_SYSTEM
SET_FEE_RATE "0,5,5,5"
SELL_FEE_RATE "0,10,10,10"
//#endif OPEN_MARKET_SYSTEM
//RE FTW

DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL "OFF"
ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED "OFF"


}

SR_ShardManager {
Certification "192.168.1.100", 15882
BILLING_SERVER_URL "http://192.168.1.100:8080/"
CREST_FTP_URL "ftp://id : password@127.0.0.1/SRO_CREST/"
ChristmasEvent2007 1
SERVER_EVENT_SYSTEM ON
LOCALE LOCALE_VIETNAM
FlagEvent 1

HourForMeterRateLevelFirst 22
HourForMeterRateLevelSecond 23

BattleArenaRandom 1
BattleArenaParty 1
BattleArenaGuild 1
BattleArenaJob 1
ArenaMatchOccupy 1
ArenaMatchFlag 1
ArenaMatchPoint 1
} Modify the IP (192.168.1.100) to YOUR IP (Static or local) . To do that in the easy way press CTRL+H in notepad.

ExpRatio, ExpRatioParty, DropItemRatio, DropGoldAmountCoef, HwanGainFactor(how fast you'll gain berserk) you can modify them as you want.

Now go to the bottom of the server.cfg at the SR_ShardManager and you'll find there the CREST_FTP_URL . Modify the ID with "crest" and password with the password you set earlier for the FTP account. Now go to your FTP folder that you earlier created and inside it create a folder "SRO_CREST" . Also, in the "SRO_CREST" folder , copy the files that you'll find into "Blitzkrieq_Bin_Data -> Crest"

In order to start the server, go to "Files" archive and take the cracked AgentServer and overwrite it with the existing one in "Blitzkrieq_Bin_Data" .

Also, go to SMC folder and edit ServiceManager.cfg as I'll show you:


Quote:
/*
*/

SMC {
DivisionManager "your IP",15880
}

ModulePatch
{
SrcPath ".\Patch_Internal"
DestPath ".\Patch_Internal_Comp"
}
Now you're done !



You can start the server now.

Do it in this way:

1. Certification
2. Global Manager
3. Machine Manager
4. SMC (Use the account that you created earlier in the Database)
5. GatewayServer
6. DownloadServer
7. FarmManager
8. AgentServer
9. SR_ShardManager
10. SR_GameServer

Because you used "no Xtrap patch" you'll be able to start the client with edx loader. The port is "15779"


I'll fix the errors in the guide, so if you see one, tell me. Also, if you have any problems, post here and don't make any other threads about those problems.

As I said, if you setup the server following the guide step by step, you won't get any errors.

Also, if the guide needs anything else, lemme know so I can add them.

Credits for the guide:
Not too many credits, just to Cernobyl for releasing the files. If I didn't mentioned somebody here, I'm sorry from the bottom of my heart


 

6 التعليقات:

Hi i have problem with SR_GameServer when i try to lunch him he closed ..

Try taking him for dinner instead of lunch.

I've done everything , but when i go to FTP folder & SRO_CREST folder i don't find any files inside

when i try to Start Services in SMC , the Shard services keeps OFF "2 subservices of shard cannot be Turned on " --> "sr_shardmanager and sr_gameserver"
and server is Check because of this problem

it's good topic really but i think i come late the links need to updated :( :( can u update links for programs and thx

This comment has been removed by a blog administrator.

Hello,
We have updated the links you can check now
thanks for your report
Regards

Post a Comment