Not a member yet? Register for your free account!


Go Back   elitepvpers > Silkroad Online > SRO Coding Corner
You last visited: Today at 09:06

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

 

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

This is a discussion on [Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files within the SRO Coding Corner forum part of the Silkroad Online category; First you need MSSQL Server + MSSQL Manager Serve + Server Files r Download Link : - -Server Files - ...

Reply
 
Thread Tools
Old   #1
 
Join Date: Feb 2008
Posts: 648
Received Thanks: 318
[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

__________________


Last edited by 3lyka; 12/25/2010 at 12:30.
3lyka is offline  
Thanks
100 Users
✗EpicSoul✗ (08/03/2011), * White * (10/30/2010), *]°ReddoX°[* (04/01/2011), ahmed4ever2u (11/26/2010), Air0x (11/09/2010), alexalex2131 (12/26/2011), amer elhorya (11/02/2010), archer09 (10/31/2010), Arco. (09/07/2011), azrail1297 (01/24/2011), baddarkness (11/04/2010), barteczek (04/05/2011), BestOnWorld (03/21/2012), bubx (10/31/2010), Burton_1993 (10/31/2010), carra (10/31/2010), cosmin_cezar (12/05/2010), cybernatus (11/01/2010), dangermetal (08/06/2011), diego0717 (04/12/2011), djmaster35 (10/31/2010), Dr.Abdelfattah (10/31/2010), dragas69 (12/18/2010), dragonabgs (12/28/2010), elkasaby (11/13/2010), eLO21 (11/18/2010), ensar00 (10/31/2010), epic_833 (02/12/2011), eslamradwan (12/20/2010), fraekazoide (10/31/2010), Fred_Vollpfosten (07/02/2011), gandras16 (11/14/2010), Ghost in Flames (10/31/2010), giniyat202 (02/13/2011), Glider (07/19/2011), goodweed2 (12/28/2010), gxxx (11/27/2010), HappyBeaR (01/26/2011), hyper_secured (12/27/2010), idohadar (07/05/2011), IncredibleOnez (03/18/2011), iTzKingZ (11/16/2010), jacobo94 (11/22/2010), Joni7654 (11/02/2010), JungleRules (01/24/2011), jVardin (01/02/2011), kroko125 (11/22/2010), kurZzen (10/30/2010), LastThief (10/31/2010), LastTim3 (01/10/2011), LegendM (12/12/2010), lmaozor (11/02/2010), lucavash (12/22/2010), LuuiSinhO (04/04/2011), madutz1 (10/30/2010), MarkovHUN (03/26/2011), martynas123boxter (02/03/2013), meeliana2010 (02/25/2011), MesselyQc (11/22/2010), milan1 (10/31/2010), mita6kin (06/18/2011), MyFreedom (11/01/2011), namacthu (12/04/2010), natic (10/31/2010), Ninja1337 (10/31/2010), ÑõÑ_Ŝŧóp (10/31/2010), nubcandy (10/31/2010), o0² (11/02/2010), ogzcntrk (02/02/2012), p1ter (11/02/2010), PaToTa (01/23/2011), patrik96 (11/26/2010), Phobos2k3 (04/12/2011), radziu12323 (01/01/2011), Rageaholic (12/19/2010), rushcrush (10/30/2010), sanaseviyorm (11/01/2010), savloro (01/07/2011), ShymonString (11/01/2010), smoron (11/13/2010), SnowStyle™ (11/02/2010), soulsimbol (02/14/2011), speederzz (10/31/2010), TheOxide (11/27/2010), TheT0XiC (12/08/2010), thezort (09/13/2011), thienphuongtc (11/18/2010), Tone98 (12/05/2010), Toonami2010 (12/25/2010), Tyl1er (11/09/2010), undo87 (12/22/2010), viky909 (12/12/2010), vnzla (10/30/2010), waefenjin (01/10/2011), xero5ever (11/23/2010), xkaganx (05/02/2012), xnukex77 (10/31/2010), [GM] (11/01/2010), _BalzeR_ (10/31/2010), _Emil_ (10/31/2010)
Old   #2
 
Join Date: Dec 2007
Posts: 1,323
Received Thanks: 536
good job, keep up the good work
[GM] is offline  
Thanks
1 User
doener (03/02/2011)
Old   #3
 
Join Date: Oct 2010
Posts: 715
Received Thanks: 319
nice guide.finaly.can you add how to update if need?


Thank you a lot.now i understand how its work...

Last edited by * White *; 10/30/2010 at 23:23.
* White * is offline  
Old   #4
 
Join Date: Feb 2008
Posts: 648
Received Thanks: 318
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   #5
 
Join Date: Nov 2008
Posts: 349
Received Thanks: 29
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 ?

Last edited by madutz1; 10/30/2010 at 23:26.
madutz1 is offline  
Old   #6
 
Join Date: Feb 2008
Posts: 648
Received Thanks: 318
madutz1

Read again about SQL server Browser and all settings in mssql manager should be like in screens
3lyka is offline  
Old   #7
 
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 437
Can u make good karakterler?
for GM Char
Thx!
rushcrush is offline  
Old   #8
 
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 437
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   #9
 
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 437
i need GM Comd lol
rushcrush is offline  
Thanks
1 User
dragonabgs (12/28/2010)
Old   #10
 
Join Date: Feb 2008
Posts: 648
Received Thanks: 318
Add some Settings about "sa" user
You can see line "Now go back to "sa" user" about this
3lyka is offline  
Thanks
1 User
Reyn123 (01/11/2011)
Reply

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Guide] Setup MSSQL for Personal PServers KaliKid Shaiya PServer Guides & Releases 14 05/17/2012 17:28
Hilfee!!!! Prob mit Server files Und Db MSSQL Fashiion Flyff PServer - Discussions / Questions 1 10/23/2010 08:50
[GUIDE]ASP.NET error for MSSQL 20005 5oonigga Cabal Guides & Templates 0 10/02/2010 04:17
How i find mssql server Torneo Kal Online 3 08/28/2010 11:20
Sql Server 200 /MSSQL 200 ? BlackManta Dekaron Private Server 2 08/26/2009 21:43



All times are GMT +1. The time now is 09:06.


Powered by vBulletin®
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.