Private Server: Silkroad Online

Commonly Used Skill Params
Hello

Today i'll share some commonly used skill params. This prolly very old and useless to you, but feel free to play with 'em as you like ;)

DESC	PARAM	VALUE 1	VALUE 2	VALUE 3	VALUE 4
duration	1685418593	-1875767296
hp/mp recovery	1751474540	11728	100	11728	100
phy/mag dmg	6582901	1000	1000
critical	25458	68	0
phy/mag abs	1868849522	15	100	0
phy/mag def	1684366960	12564	20104	0
parry rate	25970	0	1500
attack rate	26738	0	1500
str	1937011305	29696	0
int	1768846441	29696	0
speed	1752396901	500
curse block	1919246700	25145280	100	12
curse treat	1919246708	63	500
hp/mp reincarnation rate	1769105251	1000	1000
damage return	1684891506	50	35	35	150
lucky %	1819632491	10
alchemy probability %	1634493301	20

time service	1667396966	1851946342

A little explanation of values:

hp/mp recovery: VALUE 1, VALUE 3: amount of hp/mp, VALUE 2, VALUE 4: percentage

phy/mag dmg: VALUE 1, VALUE 2: percentage

phy/mag abs: VALUE 2: absorb percentage

phy/mag def: VALUE 1: Phy def, VALUE 2: Mag def

parry rate: VALUE 1: point, VALUE 2: percentage

attack rate: VALUE 1: point, VALUE 2: percentage

str: VALUE 1: point, VALUE 2: percentage

int: VALUE 1: point, VALUE 2: percentage

speed: VALUE 1: percentage

curse block: VALUE 2: probability percentage, VALUE 3: curse level

curse treat: VALUE 2: curse dmg point

hp/mp reincarnation: VALUE 1: hp percentage, VALUE 2: mp percentage

damage return: VALUE 2: phy dmg return probability, VALUE 3: mag dmg return probability, VALUE 4: range (150 = 15meters)

lucky: VALUE 1: percentage

alchemy probability: VALUE 1: percentage

Some Notes:

Each skill must have all values marked in RED, even if it's a zero.

For "duration", it's in milliseconds, and -1875767296 means 30 days.

For STR and INT, you cannot have more than 32768, might mess up your stats, best highest value would be 29696.

"time service" usually used when the skill triggered from an item, or skill that you wanna add in _TimedJob table. If you wanna make an active clickable skill, you won't need time service values.

For example, if you make a skill line like this:

1    44126    1233    SKILL_BLABLABLA_01    xxx    SKILL_BLABLABLA    0    1    1    0    0    0    0    0    5000    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    3    0    0    255    255    0    0    0    0    0    255    255    255    255    item\etc\skill_blablabla_icon.ddj    SN_SKILL_BLABLABLA    xxx    SN_SKILL_BLABLABLA_TT_DESC    xxx    0    0    3    1667396966    1851946342    1685418593    -1875767296    1751474540    11728    100    11728    100    1868849522    15    1000    0    1684366960    12564    20104    0    25970    0    1500    26738    0    1500    1752396901    500    1919246700    25145280    100    12    1769105251    1000    1000    6582901    1000    1000    25458    75    0    1937011305    29696    0    1768846441    29696    0    0    0    0    0    0

Witchy Moo
Ragezone

Setting up a server based on VSRO server files
So, since i got some free time, i can write this for everyone out there trying to get the server working without success for now. As you might already know, i've shared files i leaked from Vietnam Silkroad official servers to the community. So, here is what you will need for setting up a Silkroad server based on VSRO server files.
1. Windows XP/2003 Server/Windows 7/Windows 2008 Server/Windows 2008 Server r2 (one of those)
2. For handling 1000 players with all regions working, you will need 2 machines (you can run one as virtual)
3. One of the machines must have at least core i5 processor, and 6 - 8 GB of RAM, second might be slower a bit
4. Microsoft .NET framework 3.5+
5. Microsoft SQL Server 2000/2005/2008/2008 r2 (i will use 2k8 in this guide)
6. Microsoft SQL Server Management Studio (in 2000 it's integrated, for 2005 u need to download it, same as for 2008). SSMS 2005 wont work with mssql server 2008
7. A bit of knowledge how that stuff works

You can get MSSQL 2008 express edition from official Microsoft website

Well, since it's RageZone, i think, people got enough brain to set MSSQL server up.

Anyway, after installing mssql server, get those files i've also released

Server Files
Part1
Part2
Part3
Files was released on EPVP originally, and password is "fortheworstcommunityever".

Database Dumps

Changeset vsro obt v247-v249 (u wont need it, unless you are just interested in viewing it)

Xtrap update files

Billing ASP scripts

Custom certification server
from pushedx aka Drew Benton
config files from LegendaryDev

Latest SMC Build

So, let's start. Save all that files in a some folder on your hard disk, and extract them.

After you are done with setting up a mssql server, and restoring databases (i consider, database names will be SRO_VT_ACCOUNT, SRO_VT_SHARD, SRO_VT_SHARDLOG), you have to
create 3 ODBC sources (you can name then however you want, but i preffer to call them the same way as databases). Specify "SQL Server" as ODBC driver. Default language must be
English for all databases.
Also, you have to set ODBC default database names this way :

SRO_VT_ACCOUNT -> SRO_VT_ACCOUNT
SRO_VT_SHARD -> SRO_VT_SHARD
SRO_VT_SHARDLOG -> SRO_VT_SHARDLOG

It's pretty simple and understandable, because i use the same database names as ODBC.

Don't forget to edit _ShardService table, and change Shard ID to 64 in SRO_VT_ACCOUNT database.

After you are done with ODBC, you must configure your custom certification server to work with your database server. Just run 1 - Decompile file in it's folder,
it will decompile current packt.dat file, and save .ini files at "ini" folder. Open it, and you will see few files, which you have to replace with those
which you downloaded in another archive (from LegendaryDev). After you are done, open your "srGlobalService.ini", and configure it to work with your database
server. Don't forget, by default, mssql 2005 and 2008 does not bind on port 1433, they uses ODBC. So, you shouldn't put ",1433" after your server hostname (which
should look like "PC_NAME\SQLEXPRESS", or just "PC_NAME". Do same for "srShard.ini" file (also, you can edit some shard configuration there, like capacity).
Do not make server capacity more than 1000 for now (i will tell why a bit later). Then you will have to change the ip addresses for binding certification server. For
this, open srNoteType.ini, and change "wip" to your WAN ip, and "nip" to your local ip. After you are done with your common certification configs, run "2 - Compile.bat" file in order
to make a new "packt.dat" file (new one will be named "new_packt.dat"). After you are done with it, start third batch file ("3 - CustomCertificationServer.bat")

Now, if the certification window starts, and shows a message, that says server successfully bound on port 32000 (or any other, if you modifyed it), you are ready to begin configuring
server.cfg in your main server files folder. If it doesent, you should be done something wrong (it should be IP in 99% of cases).

Well, if you suceeded, open your server.cfg file in the main server files folder, and change all "Certification" ip addresses to your one. Take a look at SR_ShardManager and SR_GameServer configuration.
As you can see, there is a billing url at shard settings, which you will have to set up by installing a IIS server, and creating a website instance on some unused port running. Files you should put on your IIS website
are in the beginning of post (billing asp scripts). Also, don't forget to enable asp support in your IIS server, otwertise, it will not work (will give IIS core error, and wont work propertly).
You have to edit DBConnect.asp file with your MSSQL server security information. Don't forget to edit your billing server url in your server.cfg (it should be like "http://silkroad.net:1337/").
After you are done, you might try to start your server. Here is the sequence in which you should do it (might be different, but this one will work for sure).

1 - Custom certification server
2 - GlobalManager
3 - MachineManager
4 - DownloadServer
5 - GatewayServer
6 - FarmManager
7 - AgentServer
8 - SR_ShardManager
9 - SR_GameServer

If you got everything running fine, you might try to start the service. For doing it, you have to download SMC (also check the top of this post), create a new server developer account, and log in using SMC.
For doing it, open your SSMSE, go to SRO_VT_ACCOUNT database, open TB_User table, and a new row with your account infos there (password is encrypted with usual md5 function). For giving account a rights
to access through SMC, you will have to change it's "sec_primary" to 1, same as "sec_content". Also, for connecting to SMC you will have to add your IP address to official ip ranges list.
For doing it, you have to edit _PrivilegedIP table in SRO_VT_ACCOUNT database (by default, it uses reverse integer "encryption", but you can modify it to use normal IP ranges. You can do it using this query :

USE [SRO_VT_ACCOUNT]
GO
/****** Object:  Table [dbo].[_PrivilegedIP]    Script Date: 09/13/2011 08:35:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
drop table _PrivilegedIP
GO
CREATE TABLE [dbo].[_PrivilegedIP](
 [IP1] [tinyint] NOT NULL,
 [IP2] [tinyint] NOT NULL,
 [IP3] [tinyint] NOT NULL,
 [IP4] [tinyint] NOT NULL,
 [IP5] [tinyint] NOT NULL,
 [IP6] [tinyint] NOT NULL,
 [IP7] [tinyint] NOT NULL,
 [IP8] [tinyint] NOT NULL
) ON [PRIMARY]
GO

After it's done, just add your ip range like this : if your ip is 127.0.0.1, for example, add each part of it in one column.

127 0 0 1 127 0 0 5

This will add 4 ip addresses into allowable ip ranges (127.0.0.1 - 127.0.0.5).

After you are done, restart your GatewayServer, if it was running while you were doing it.

Now you will have to edit your client side (server division ip address is stored at Media.pk2), you have to edit it with XVI32, Hex Workshop, or some other hexadecimal editor.
Well, you can also use a software writen by other people, like "Media Patcher", etc.

Common problems are
{
- Wrong MSSQL server setup
- Wrong certification server configs
- Wrong database names
- Wrong ODBC setup
- Wrong IIS setup
- Wrong ip addresses/ports defined in server.cfg
}

Some info you should know
{
- One agent server supports only 1000 users
- You can't run 1 gameserver with ALL regions working (_RefRegionBindAssocServer table in SRO_VT_SHARD database; 0 = disabled, 1 = gs1, 2 = gs2, 3 = g3)
- You can run only 1 gameserver/any another module instance at a single physical/virtual machine
- I don't have any sources of server modules executables to provide, so, reversing is the way to go for fixing stuff
- For adding new gameserver/agentserver/any other instance nodes, you have to know some stuff about the way modules are being certificated/linked
- Certification server reads the first network adapter primary ip address
- Basic certification architecture
- Tons more
}

I will update this guide through time, as much as i can. There is tons of things to tell that you should know, but i'm just too lazy at the moment, so, you will have to wait for updates.

Chern0byl
Ragezone

Private Server

Pages

Skill Params Silkroad Online

Remove Euro Items Silkroad Online

Silkroad Online