Menu
New Sql Database Administrator jobs added daily. Experience in working with relational databases. Including database and file system engineering through database and file system administration. Welcome All Today I Will Share My Special - Sro China DB I Think All. And I don't love swsro system too:P. Guys i mast use Ecsro Files?
I know this wont be useful to most of the people here, but this is an updated guide for this thread by @zikor1337. Hopefully this thread be of help to those who still want to update the current game and not just open a server to get some instant cash.What you need to run a server?
- Your computer or a VPS (virtual private server)
- SQL Server
- Server files
- Silkroad Client
- Around 30 minutes to install everything
I ran a test server on my personal computer back in 2011 with 2gb of ram and probably core2duo processor for testing/learning purposes, only 1 region enabled (Jangan). So, use whatever you have, ask for server/hosting recommendation if you want too.
Download links
SQL Server
Microsoft SQL Server 2008 R2 RTM - Express with Management Tools
Microsoft® SQL Server® 2012 Express
Microsoft® SQL Server® 2014 Express
SQLEXPWT x86/x64
Server files // 'data' folder not included, I will explain why shortly
|| Files.fm
Server files // can be found at sroinfo.com
|| Files.fm
Certification
||
SMC
||
Clean Database //
|| Google Drive || Files.fm
Standalone billing server // credits goes to @florian0 for his
||
Default V(Vietnamese)SRO 188 Client
|| Google Drive || Files.fm
sro_client.exe no xtrap
||
IPInPut
||
Joymax PK2 toolsclient password/blowfish is 169841
||
PK2 Extractor
||
edxLoader 5
||
srPatcher_1.0.6
||
Microsoft SQL Server 2008 R2 RTM - Express with Management Tools
Microsoft® SQL Server® 2012 Express
Microsoft® SQL Server® 2014 Express
SQLEXPWT x86/x64
Server files // 'data' folder not included, I will explain why shortly
|| Files.fm
Server files // can be found at sroinfo.com
|| Files.fm
Certification
||
SMC
||
Clean Database //
|| Google Drive || Files.fm
Standalone billing server // credits goes to @florian0 for his
||
Default V(Vietnamese)SRO 188 Client
|| Google Drive || Files.fm
sro_client.exe no xtrap
||
IPInPut
||
Joymax PK2 toolsclient password/blowfish is 169841
||
PK2 Extractor
||
edxLoader 5
||
srPatcher_1.0.6
||
Scans
NOTE! AgentServerNoXtrap is heavily infected that my antivirus removes it instantly, try using MegaMax's agentserver or if I found a clean one I'll post it here. USE AT YOUR OWN RISK!
SQL Setup // you can see it on imgur
Gallery 1 | |
|
*once the above step is done open SQL Management Studio*
Database Restoration // I will do one only and you do the same on the rest
put your database on your C drive to access it quickly
Gallery 2 | |
|
Creating your GM account imgur
SRO_VT_ACCOUNT > TB_User > right click > edit rows
Gallery 3 | |
|
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:
Now that you found out your IP, go to: SRO_VT_ACCOUNT -> _PrivilegedIP
Write your IP like this:
Disable regions for low-end/old computers (and to skip mob disappearing issue which happens if monsters count is over 50,000)
SRO_VT_SHARD -> _RefRegionBindAssocServer
Gallery 4 | |
|
Extract the Data.pk2 and move the folder inside the Server Files
Gallery 5 | |
|
Configuration files setup (Certification, server.cfg, billing server)
Certification ini files
location Certificationini
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.
SERVER = YOURNAME-PCSQLEXPRESS
UID = sa
PWD = password that you set on the MSSQL installation
2. Open srNodeType.ini and you'll see this inside.
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:
SERVER = YOURNAME-PCSQLEXPRESS
UID = sa
PWD = password that you set on the MSSQL installation
capacity = Slots of your server
name= server name
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.
You have to modify just 3 files in order to start your Certification.
1. Open srGlobalService.ini and you'll see this inside.
SERVER = YOURNAME-PCSQLEXPRESS
UID = sa
PWD = password that you set on the MSSQL installation
2. Open srNodeType.ini and you'll see this inside.
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:
SERVER = YOURNAME-PCSQLEXPRESS
UID = sa
PWD = password that you set on the MSSQL installation
capacity = Slots of your server
name= server name
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.
MiniBillingServer
location Standalone Billing ServerSettings
This configuration is self explanatory and I honestly can't think of anything to write here, if you don't know what to this is talking about then change only my database information to yours, and run it as administrator.
server.cfg
location Server Filesserver.cfg
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 to replace all.
ExpRatio, ExpRatioParty, DropItemRatio, DropGoldAmountCoef, HwanGainFactor(how fast you'll gain berserk) you can modify them as you want.
BILLING_SERVER_URL 'http://127.0.0.1:8080/'
ExpRatio, ExpRatioParty, DropItemRatio, DropGoldAmountCoef, HwanGainFactor(how fast you'll gain berserk) you can modify them as you want.
BILLING_SERVER_URL 'http://127.0.0.1:8080/'
ServiceManager.cfg
location SMCServiceManager.cfg
192.168.1.100 to your ip
You're done configuring all the files and can now open the files
Files launching order
- MiniBillingServer (Run as Admin)
- Certification
- Global Manager
- Machine Manager
- GatewayServer
- DownloadServer
- FarmManager
- AgentServer
- SR_ShardManager
- SR_GameServer
- SMC // Use your GM account
#I didn't include the IIS setup (there is a standalone billing server)
#Filezilla is responsible for the guild/union image (not needed for test server, you can find the guide down below tho)
#I didn't include the scan for the Billing server, source can be found at
#I will probably update it to look nicer and add the missing stuff
#there is no need to explain how IpInput/edxloader works
#some missing download links will be added later on
Helpful threads/links
Page 1 of 1 | [ 8 posts ] |
|
Author | Message | ||
---|---|---|---|
| |||
Joined: Sep 2008 Posts: 3 Location: I've Got A BSObj Pugin SRO Error Help. |
| ||
Top |
| |||
Joined: Jul 2006 Posts: 7885 Location: At the apple store, Cause i'm an iAddict. |
| ||
Top |
| |||
Joined: Sep 2008 Posts: 3 Location: I've Got A BSObj Pugin SRO Error Help. |
| ||
Top |
| |||
Joined: Jul 2006 Posts: 7885 Location: At the apple store, Cause i'm an iAddict. |
| ||
Top |
| |||
Joined: Mar 2008 Posts: 817 Location: |
| ||
Top |
| |||
Joined: Feb 2008 Posts: 67 Location: France |
| ||
Top |
| |||
Joined: Feb 2008 Posts: 4049 Location: Magic |
| ||
Top |
| |||
Joined: Jan 2009 Posts: 7 Location: Behind the Monitor :D |
| ||
Top |
Page 1 of 1 | [ 8 posts ] |