Silkroad Database Files Definition

17.08.2019
Posted by 

Grant permissions to the user-defined database roles. Assigning Permissions. Most permission statements have the format: AUTHORIZATION PERMISSION ON SECURABLE::NAME TO PRINCIPAL. AUTHORIZATION must be GRANT, REVOKE or DENY. PERMISSION is listed in the chart referenced. Database (DB): A database is a collection of information that is organized so that it can be easily accessed, managed and updated. Quite simply the best place to go to find drugs. It's hard to get to, but once you're there, every single drug imaginable is available for you to order. LSD, DMT, shrooms, ketamine, heroine, cocaine, marijuana, all only a couple of clicks away!

Please Read First my ReadMe.txt in attachemnt ()
--------------------------------------------------------------------------------------
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
---------------------------------------------------------------------------
Download allServer Files you need from here
Server Files
{
Part 1 :
Part 2 :
Part 3 :

password is 'fortheworstcommunityever'.
}
Database Dumps
{
Clean Database Working with MSSQL 2005
}
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)
(applications by pushedx aka Drew, ini configuration by Dr.Abdelfattah)
}
Latest SMC Build
{
}

---------------------------------------------------------------------------
You can get MSSQL 2008 express edition from official Microsoft website
(http://www.microsoft.com/sqlserver/e...s/express.aspx) same as SSMS
---------------------------------------------------------------------------
So, let's start. Save all that files in a 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 (needed for some mssql servers!!) :
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.
Simple Explain About Certification :
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_NAMESQLEXPRESS', 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).
Arrange :
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
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

---------------------------------------------------------------------------
(already done in the cleaned databases...)
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 (not needed in some times)
- 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
- Every GameServer could handel 50K spawned objects Only .
}

---------------------------------------------------------------------------
Common Problems (and solve)
---------------------------------------------------------------------------
[Guide] Patching Media.pk2 ip address using XVI32
Written by Chern0byl
So, since some people had problems patching Media.pk2 using pk2 tools and media patchers, i decided to make a guide to explain, how to do it 'manually' using only hex editor.
So, first of all, you will need some hex editor (i would preffer XVI32 for such thing to do). You can get it here :
After you are done downloading, extract it to a some folder, and run xvi32.exe, open your media.pk2 file, and preff Ctrl + F (search), select Text string as search option, and type in the current ip address, or hostname which media contains. After it finds the text string, just rewrite it with whichever ip/hostname you need. After you are done, you might get in situation when your hostname/ip is not same length as old one (smaller). If so, you will have to set remaining symbols to null. Following screen shot shows how to do it.
After you are done, just save your Media.

---------------------------------------------------------------------------
searched in youtube


---
------------------------------------------------------------------
Cracking GameServer to fix rates
Writed By
So, some people might have problems even at such basic stuff as cracking a experience limit.
Gameserver reads rates as (real rate * 1000), it means, if you set rates to
35000, experience gain coefficent will be 35x. By default, gameserver forbidds making them more than 250 (2.5 x), but it's easy to crack.
So, open your SR_GameServer executable using OllyDBG, and patch the following addresses with following assembly codes.
Individual experience ratio
0042714C F6C4 50 TEST AH,42

Party experience ratio
004271F5 F6C4 42 TEST AH,42

Item drop rate
004272A0 F6C4 42 TEST AH,42

Gold drop amount rate
00427349 F6C4 42 TEST AH,42

HWLAN (berserker) gain factor
004273CA . F6C4 44 TEST AH,42

Bypass creation of huge .dmp files (less lags)
00964060 81EC 6C060000 SUB ESP,66C
change command to
jmp 009642FD

To do it, follow this screenshots. Open the file using OllyDBG (F3)
Double-click the line you were jumped to, and...
Do same for all addresses.---------------------------------------------------------------------
Database
Use this query to clean out old data from SRO_VT_ACCOUNT tables. (If you Don't use cleaned Database)
USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans]

---------------------------------------------------------------------------
If you need to create your own GM account:
1. You need a md5 hasher. (can google it)
2. Go to TB_Users table
3. Fill the form like this:
JID: Fills automatically
StrUserID: Username
password: password
status: can leave blank
GMRank: Set this to 1 (Server Dev) 2 (content administrator) 3 (content user) 4 (content marketer) 5 (content monitor) 6 (Content GM) 7 (content GM Leader)
sec_primary - set it to 1 (3 is normal user)
sec_content - set it to 1 (3 is normal user)
4. You can fill in the other neccesary fields like email, adress so on, but they're not really neccesary.

---------------------------------------------------------------------------
This will clean up Log database instantly :
USE [SRO_VT_LOG]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]

Use this to prune all old character data from shard :
//..basically you need to delete these manually. (If you don't use cleaned databases)

---------------------------------------------------------------------------------------
Simple registration page for official server files (php)
Download
-----------------------------------------------------------------------------------------
green/red/black books :
chernobyl write :
So, since vsro has such a 'nice' thing like green/red/black books, i've made a simple solution for this, temporary, through.
So, You have to open your GlobalManager.exe, and search for this HEX code
7570646174652054425F555345522073657420416363506C61 7954696D65
Which means
update TB_USER set AccPlayTime
Now just change AccPlayTime part to a some another name, for example, OnlineTime. After you are done, save the file, and open sql server management studio, open SRO_VT_ACCOUNT database, TB_User table, set all AccPlayTime field values to 0, and create a new column named 'OnlineTime' (int).
Simple as that, but not the best solution. Users will have to relogin in order to be able to gain experience once green book appears (it will just reset).
You can use nearly any hex editor for this. I'd preffer Hex Workshop, or XVI32. ---------------------------------------------------------------------------
Silkroad Database Files Definition[Guide]How to Make GM Acc Working 100%! (already written in the top post !)


First:Open MMSQL>>>>SRO_VT_ACCOUNT>>>>Right Click on it>>>> Choose New Query>>>>Write This
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans]

DONT FORGET TO MAKE SMC ACC
LIKE THIS
Open TB_User>>>
do like this
PHP Code:
JID:leave it
StrUserID:Username of SMC
Password:go to any MD5 Site and wirte any word you want then you will get the MD5 Code....go to Password table and put it
Sec_primary:1
sec_content:1


Close MSSQL after you done from this part!
---------------------------------------------------------------------------
Second:Access
After your Close the MSSQL>>>>Go open (SMC with the user we just made in TB_User)(but ofc you have to open the others .exe so your can open SMC)>>>>Choose Security>>>Choose User Security>>>>Right Click on the Write Page in SMC>>>>Click on Add User>>>>User Property will Appear(it will be like this)
UserID=Username
Password=your Acc Password
Retype Password=Just type your password again
Name=you can write any name you want
SSNumber=write in the first table(1) and the 2nd table write(1)
Organiztion=write anything you want
Role=write anything you want
PrimarySecurityGroup=Choose Content GM
ContentSecurityGroup=Choose Content GM
Granted IP Adress=abit Complex


if you using Hamachi ip then you going write it in Granted IP Adress
if you using 192.168.x.x then you going write it in Granted IP Adress
we done From this Part
---------------------------------------------------------------------------
Three:
After you done from Second Part
go open MSSQL>>>TB_User>>>>you going find the acc we just created>>>>Look what you going do
Status:1
GMrank:1
Sec_Primary:Change it from 6 to 1
Sec_Content:Change it From 6 to 1

Silkroad Database Files Definition In Hindi

After you done from TB_User>>>Open _PrivilegedIP>>>put the IP you write in Granted IP Adress
it would be like this
IP1:192
IP2:168
IP3:x
IP4:x
IP5:192
IP6:168
IP7:x
IP8:x

or the ip you put at Granted IP Adress

hope you understand this part ^^
Now all you going do is Close MSSQL and Restart your Server >>>then you can Log on Game with the GM Acc
this Guide Credit to me(iam same one who posted it there at epvp)
Hope so it helpfull for you guys---------------------------------------------------------------------------
FTP Server (filezilla) (for security reason don't setup open ftp like for guild/union pic in the machine which host server files)
Link:
----------------------------------------------------------------------
Microsoft SQL Server 2005
>> SQL Server 2005 - 32 bit (x86)
>>>> http://download.microsoft.com/downlo.../SQLEXPR32.EXE
>> SQL Server 2005 Managament Studio 32 bit (x86)
>>>> http://download.microsoft.com/downlo...005_SSMSEE.msi
>> SQL Server 2005 - 64 bit (x64)
>>>> http://download.microsoft.com/downlo...96/SQLEXPR.EXE
>> SQL Server 2005 Managament Studio 64bit (x64)
>>>> http://download.microsoft.com/downlo...SSMSEE_x64.msi
I suggest to use google search instead of using those .. !!!
---------------------------------------------------------------------------
To support ur iis server to open php scripts
---------------------------------------------------------------------------
Full problems FiX here (for 2 aka 3 machines)
--------------------------------------------------------------------------
Make ur server without hamachi if u have static ip
---------------------------------------------------------------------------
Add Stater Items for Chars :
> Databases > SRO_VT_SHARD_INIT > Programmability > Stored Procedures > _AddNewChar.dbo
Right click it, click 'Modify'
to add start items to your inventory scroll to the bottom
add lines like this :
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,12
ITEM_CH_SWORD_11_SET_B_RARE means Fight nova sword, obviously.... 1 means amount, 12 means plussvalue
like this :
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CODE',(Amount),(Plusvalue)
mine looks like this

---------------------------------------------------------------------------
This is very useful

---------------------------------------------------------------------------
New Items Useful to Run Your Server
non xtrap agent/sro_client by chernobyl
Download :
---------------------------------------------------------------------------
And full working Clean Databases works on SQL 2005 by Artuuro
Download :
---------------------------------------------------------------------------
Some Basic Security Guides you need to read before run your server for Public :
Ddos
Basic Security Guide
This guide security is secret !!
Basic Security guide too
---------------------------------------------------------------------------
Basic Experience about creating Server (Guide) :
.
Silk Roaddrugs
Quite simply the best place to go to find drugs. It's hard to get to, but once you're there, every single drug imaginable is available for you to order. LSD, DMT, shrooms, ketamine, heroine, cocaine, marijuana, all only a couple of clicks away!
The site uses virtual currency called bitcoins, which are as untraceable as money can get.
It's been called the amazon.com of drugs, but that's an understatement!
Just look up silk road(anonymous marketplace) and prepare to be amazed.
'Dude, I just ordered an 1/8th of shrooms off of Silk Road for 4.5 bitcoins!'
'Sweet, brah! I just got 5 tabs of acid for a little under 10 bitcoins!'
'Most triumphant, my brother.'
Get a Silk Road mug for your guy Rihanna.
silkroadunknown
best free mmorpg ever made, corrupted by turks and gold farm bots that ruin the game economy see bush. created by joymax
Dude WoW nerds dont have shit on silkroad.
turk: SLM!
player: fuck off turk
Get a silkroad mug for your boyfriend Paul.
Silk Roadunknown
A 'silk road' refers to a vagina that has been thoroughly aroused and is very moist. Can be the cause of natural secretions, added lubricant, or a mix of the two. Can also refer to an anus/rectum that has been thoroughly lubricated.
Mike said he fingered her for a half hour and even used lube so she would have a nicesilk road.
Get a Silk Road mug for your buddy Riley.
Silk Roadunknown
A continuous, uninterrupted line of cum. Usually made by shooting a huge load in a single squirt.
1. 'She made me cum so hard last night, I made a 12 inch Silk Road on her ass.'
2. 'Wanna see who can make a longer Silk Road?'
'Nah man that's p gay'
Get a Silk Road mug for your guy Riley.

Trending RN - September 12, 2019

  • 1. G.I. butt wipe
  • 2. Doorknocker
  • 3. Dick me down shorts
  • 4. Cox Knot
  • 5. Champagne Papi
  • 6. lip-sing
  • 7. Thats that on that
  • 8. kidneys
  • 9. rbomb
  • 10. v plates
  • 11. lipsin
  • 12. paper tiger
  • 13. Trypophobia
  • 14. Sugardick
  • 15. cheeched
  • 16. eeffoc
  • 17. 22.3 years
  • 18. belfie
  • 19. Happy 9/11
  • 20. hwaddaow
  • 21. Tolito Surprise
  • 22. frog punch
  • 23. Mike “Manson” Waters
  • 24. Bush Did 9/11
  • 25. sahtain
  • 26. The Pikachu
  • 27. 2319
  • 28. 71
  • 29. ADL
  • 30. Neocon
◀ Punk Goes Pop Volume Two Zippered
Compensation 10th Edition By Milkovich Newman And Gerhart Plumbing ▶