Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Coding Corner
You last visited: Today at 11:26

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files

Discussion on [Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files within the SRO Coding Corner forum part of the Silkroad Online category.

Reply
 
Old   #1
 
3lyka's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
[Guide]Srevolution Guide Mssql\Mssql Server Manager\Server Files\SVN Files

First you need MSSQL Server + MSSQL Manager Serve + Server Filesr


Download Link :
-



-Server Files -


After installing go to SQL Configuration Manager



Look if both are start




SQL server Browser is usually in "stop"
Look how to start it





Then click start

P.S RESTART Both !!



Now go to MSSQL Manager Studio



Click Connect

Now look at screens and be sure if you have all configuration like this:








Now we need to create database






Create "silk" database




Now go back to "sa" user




Now we need create tables for "silk" database





Now go Open silk.sql with NotePad and copy all



Now back to Mssql Manager Studio and paste all





Now we Have all tables for work



Now we need change "server" and "users" tables


Open "server" table and change all lines how in screen





Now open "users" table and change all lines how in screen




Password is "21232F297A57A5A743894A0E4A801FC3" in game its mean "admin"


Editing Server Files


Open Game Server Settings (\Gameserver\Settings)

It should be like this:

Quote:
[SREVOLUTION_DATABASE]
connectionstring=Data Source=You-PC\SQLEXPRESS;Initial Catalog=silk;User Id=sa;Password=1234;MultipleActiveResultSets=True;
Settings_IP .ini

Quote:
[SERVER_CONFIG]
ip=127.0.0.1
Settings_rate.ini

Quote:
[GOLD RATES]
Goldrate=1
[DROP RATES]
Droprate=1
[EXP RATES]
Xprate=1
[SP RATES]
Sprate=1
[SEAL RATES]
Sealrate=1
[SERVER_CONFIG]
ip=127.0.0.1
Here you can check your Name of SQLEXPRES



Like you see my is LEX-PC\SQLEXPRESS just copy\past your name


Now Open Login Game Settings folder and open Database.txt

Quote:
[SREVOLUTION_DATABASE]
connectionstring=Data Source=Your-PC\SQLEXPRESS;Initial Catalog=silk;User Id=sa;Password=1234;MultipleActiveResultSets=True;


Now Run Game and Login Servers

In Game you can login with user "test" and pw "admin"


Client and Loader


Client 2 parts:




Loader:








Big Thx to:
Srevolution Team and to chea77er for leaking server files and to Miki_Maus for contributing the related client.

Have a fun
3lyka is offline  
Thanks
100 Users
Old 10/30/2010, 23:04   #2
 
elite*gold: 0
Join Date: Dec 2007
Posts: 1,326
Received Thanks: 539
good job, keep up the good work
[GM] is offline  
Thanks
1 User
Old 10/30/2010, 23:09   #3
 
* White *'s Avatar
 
elite*gold: 0
Join Date: Oct 2010
Posts: 717
Received Thanks: 330
nice guide.finaly.can you add how to update if need?


Thank you a lot.now i understand how its work...
* White * is offline  
Old 10/30/2010, 23:14   #4
 
3lyka's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
Quote:
Originally Posted by White&Black View Post
nice guide.finaly.can you add how to update if need?
You need Microsoft Visual C# 2010 Express

And i dont think u need download it just for compile

I upload now the lest version and i will post it
3lyka is offline  
Old 10/30/2010, 23:24   #5
 
madutz1's Avatar
 
elite*gold: 0
Join Date: Nov 2008
Posts: 372
Received Thanks: 31
I get This error .. Please help me :P





If u can to help me with Team Viewer5 .. i can give you id and password on pm ?
madutz1 is offline  
Old 10/30/2010, 23:27   #6
 
3lyka's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
madutz1

Read again about SQL server Browser and all settings in mssql manager should be like in screens
3lyka is offline  
Old 10/30/2010, 23:34   #7
 
elite*gold: 0
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 443
Can u make good karakterler?
for GM Char
Thx!
rushcrush is offline  
Old 10/30/2010, 23:36   #8
 
elite*gold: 0
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 443
Quote:
Originally Posted by madutz1 View Post
I get This error .. Please help me :P





If u can to help me with Team Viewer5 .. i can give you id and password on pm ?
u have to write this
SREVOLUTION_DATABASE]
connectionstring=Data Source=Your-PC\SQLEXPRESS;Initial Catalog=silk;User Id=sa;Password=1234;MultipleActiveResultSets=True;
Not This
SREVOLUTION_DATABASE]
connectionstring=Data Source=Your-PC\SQLEXPRESS;Initial Catalog=silk;User Id=sa;Password=123456;MultipleActiveResultSets=Tru e;
Under stand?!
rushcrush is offline  
Old 10/30/2010, 23:42   #9
 
elite*gold: 0
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 443
i need GM Comd lol
rushcrush is offline  
Thanks
1 User
Old 10/30/2010, 23:44   #10
 
3lyka's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
Add some Settings about "sa" user
You can see line "Now go back to "sa" user" about this
3lyka is offline  
Thanks
1 User
Old 10/30/2010, 23:50   #11
 
* White *'s Avatar
 
elite*gold: 0
Join Date: Oct 2010
Posts: 717
Received Thanks: 330
how to update my server to yours?
* White * is offline  
Old 10/30/2010, 23:52   #12
 
3lyka's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
Quote:
Originally Posted by White&Black View Post
how to update my server to yours?
In the first post with link mssql + mssql manager you can see server files
3lyka is offline  
Old 10/30/2010, 23:55   #13
 
madutz1's Avatar
 
elite*gold: 0
Join Date: Nov 2008
Posts: 372
Received Thanks: 31
man .. now i have other problem ..
This -->
madutz1 is offline  
Old 10/30/2010, 23:58   #14
 
* White *'s Avatar
 
elite*gold: 0
Join Date: Oct 2010
Posts: 717
Received Thanks: 330
I need to replace my files to your files.thats all?
* White * is offline  
Old 10/30/2010, 23:59   #15
 
3lyka's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
madutz1

when you lauch game with ur loader put only Redirect Gateway Server

White&Black

Yes
3lyka is offline  
Thanks
1 User
Reply


Similar Threads Similar Threads
[Guide] Setup MSSQL for Personal PServers
05/17/2012 - Shaiya PServer Guides & Releases - 14 Replies
So I know there have been quite a few people having issues setting up mssql correctly to host their own private servers. I decided to post a video tut on how to set it up correctly for local use. This was done on Windows XP 32-bit and works on other OS as well. *Note* This configuration is based on personal home use, not for public servers. I do not condone the use of illegal public servers, you will have to figure out those settings yourself. ...
Hilfee!!!! Prob mit Server files Und Db MSSQL
10/23/2010 - Flyff Private Server - 1 Replies
Also ich weis nicht wie Ich die offi Files richtig einstellen Und ein fügen solll Und bei der DB Kann ich nix Machen muss mich einloggen und weiss nicht wie Ich bitte um schnelle Antwort Kann Auch Skype oda TW?? Pls Pls Antwort Gruß Fashiion
[GUIDE]ASP.NET error for MSSQL 20005
10/02/2010 - Cabal Guides & Templates - 0 Replies
After a couple hours i have figured out how to correct the ASP.NET. I don't know if anyone else is having a problem with it.... This is what you do, Click the start Icon. in the search box type in "intermgr" a screen like this should open http://i814.photobucket.com/albums/zz64/xvvhitecl oudx/inetmgr.jpg
How i find mssql server
08/28/2010 - Kal Online - 3 Replies
Mssql server funzt bei mir nicht das 2000 gar nicht mehr zum installieren das 2005-2008 kann man nirgends in der scheisse bei google downloaden ... hilfe bitte
Sql Server 200 /MSSQL 200 ?
08/26/2009 - Dekaron Private Server - 2 Replies
Hi where i can get Sql Server 2000 or MSSQL 2000 ? have any one a download link for me ?



All times are GMT +2. The time now is 11:26.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.