Silkroad Database Files Definition

Silkroad Database Files Definition 4,6/5 1317votes

Particular countries can have different legal definition of the “literary work” as the subject of copyright and different court's interpretation practices. Some countries protect almost every written work, while other countries protect distinctively artistic or scientific texts and databases only. Extent of creativeness.

Silkroad Database Files Definition

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. 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.

Silkroad Database Files Definition

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 all Server Files you need from here.

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!!). 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 '--------------------------------------------------------------------------- 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). 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. 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. 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. 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. 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. 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 Luxor Amun Rising Hd Serial Terra. ). 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. --------------------------------------------------------------------------- [Guide]How to Make GM Acc Working 100%! (already written in the top post!).

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: 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). 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).

Try common passwords. If the admin secured the account with a password (a likely situation), try common username/password combinations. Some hackers publicly post lists of passwords they’ve cracked while using auditing tools. Try some different username and password combinations. • A reputable site with collected password lists is • Trying passwords by hand can be time-consuming, but there’s no harm in giving it a shot before breaking out the big guns. Use a password auditing tool.

You can use a variety of tools to try thousands of dictionary words and letter/number/symbol combinations by brute force until the password is cracked. • Tools like DBPwAudit (for Oracle, MySQL, MS-SQL and DB2) and Access Passview (for MS Access) are popular password auditing tools that can be run against most databases.

You can also search Google for newer password auditing tools specifically for your database. For instance, a search for password audit tool oracle db if you’re hacking an Oracle database. • If you have an account on the server that hosts the database, you can run a hash cracker like John the Ripper against the database’s password file. The location of the hash file is different depending on the database. • Only download from sites that you can trust. Research tools extensively before using them.

Find an exploit to run. Sectools.org has been cataloging security tools (including exploits) for over ten years. Their tools are reputable and used by system administrators all over the world for security testing.

Browse their “Exploitation” database (or find another trustworthy site) to find tools or text files that help you exploit security holes in databases. • Another site with exploits is www.exploit-db.com. Go to their website and click the Search link, then search for the type of database you want to hack (for example, “oracle”).

Type the Captcha code in the provided square and search. • Be sure you research all exploits you plan to try so you know what to do in case of potential issues.