Not a member yet? Register for your free account!


Go Back   elitepvpers > Silkroad Online > SRO Coding Corner
You last visited: Today at 16:44

  • Did you know? elitepvpers has its own image host, epvpimg.com.

 

[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 : - [Only registered and ...

Reply
 
Thread Tools
Old 10-30-2010, 22:58   #1
Senior Member
 
Join Date: Feb 2008
Posts: 647
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 :
-
[Only registered and activated users can see links. ]


-Server Files - [Only registered and activated users can see links. ]


After installing go to SQL Configuration Manager

[You must register and activate your account in order to view images. ]

Look if both are start

[You must register and activate your account in order to view images. ]


SQL server Browser is usually in "stop"
Look how to start it
[You must register and activate your account in order to view images. ]
[You must register and activate your account in order to view images. ]



Then click start

P.S RESTART Both !!

[You must register and activate your account in order to view images. ]

Now go to MSSQL Manager Studio

[You must register and activate your account in order to view images. ]

Click Connect

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

[You must register and activate your account in order to view images. ]
[You must register and activate your account in order to view images. ]
[You must register and activate your account in order to view images. ]
[You must register and activate your account in order to view images. ]
[You must register and activate your account in order to view images. ]


Now we need to create database


[You must register and activate your account in order to view images. ]



Create "silk" database


[You must register and activate your account in order to view images. ]

Now go back to "sa" user

[You must register and activate your account in order to view images. ]


Now we need create tables for "silk" database


[You must register and activate your account in order to view images. ]


Now go Open silk.sql with NotePad and copy all

[You must register and activate your account in order to view images. ]

Now back to Mssql Manager Studio and paste all

[You must register and activate your account in order to view images. ]



Now we Have all tables for work

[You must register and activate your account in order to view images. ]

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


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

[You must register and activate your account in order to view images. ]
[You must register and activate your account in order to view images. ]


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

[You must register and activate your account in order to view images. ]
[You must register and activate your account in order to view images. ]

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

[You must register and activate your account in order to view images. ]

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:

[Only registered and activated users can see links. ]
[Only registered and activated users can see links. ]

Loader:

[You must register and activate your account in order to view images. ]






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 10-30-2010, 23:04   #2
Tig Ol' Bitties ♥
 
Join Date: Dec 2007
Posts: 1,323
Received Thanks: 535
good job, keep up the good work
[GM] is offline  
Thanks
1 User
doener (03-02-2011)
Old 10-30-2010, 23:09   #3
Lithuanian
 
Join Date: Oct 2010
Posts: 706
Received Thanks: 313
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 10-30-2010, 23:14   #4
Senior Member
 
Join Date: Feb 2008
Posts: 647
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 10-30-2010, 23:24   #5
Dont give a shit !
 
Join Date: Nov 2008
Posts: 339
Received Thanks: 27
I get This error .. Please help me :P

[You must register and activate your account in order to view images. ]
[You must register and activate your account in order to view images. ]
[You must register and activate your account in order to view images. ]

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 10-30-2010, 23:27   #6
Senior Member
 
Join Date: Feb 2008
Posts: 647
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 10-30-2010, 23:34   #7
Banned
 
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 434
Can u make good karakterler?
for GM Char
Thx!
rushcrush is offline  
Old 10-30-2010, 23:36   #8
Banned
 
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 434
Quote:
Originally Posted by madutz1 View Post
I get This error .. Please help me :P

[You must register and activate your account in order to view images. ]
[You must register and activate your account in order to view images. ]
[You must register and activate your account in order to view images. ]

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
Banned
 
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 434
i need GM Comd lol
rushcrush is offline  
Thanks
1 User
dragonabgs (12-28-2010)
Old 10-30-2010, 23:44   #10
Senior Member
 
Join Date: Feb 2008
Posts: 647
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 +2. The time now is 16:44.


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