Register for your free account! | Forgot your password?

Go Back   elitepvpers > Silkroad Online > SRO Coding Corner
You last visited: Today at 21:52

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

 

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

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 319
[Guide]Srevolution Guide Mssql\Mssql Server Manager\Server Files\SVN Files

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


Download Link :
-
Mssql Manager + Mssql Server


-Server Files -


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:




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



3lyka is offline  
Thanks
100 Users
Old   #2
 
elite*gold: 0
Join Date: Dec 2007
Posts: 1,323
Received Thanks: 539
good job, keep up the good work


[GM] is offline  
Thanks
1 User
Old   #3
 
elite*gold: 0
Join Date: Oct 2010
Posts: 715
Received Thanks: 328
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   #4
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 319
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
 
elite*gold: 0
Join Date: Nov 2008
Posts: 350
Received Thanks: 29
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 ?
madutz1 is offline  
Old   #6
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 319
madutz1

Read again about SQL server Browser and all settings in mssql manager should be like in screens
3lyka is offline  
Old   #7
 
elite*gold: 0
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 441
Can u make good karakterler?
for GM Char
Thx!
rushcrush is offline  
Old   #8
 
elite*gold: 0
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 441
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   #9
 
elite*gold: 0
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 441
i need GM Comd lol
rushcrush is offline  
Thanks
1 User
Old   #10
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 319
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   #11
 
elite*gold: 0
Join Date: Oct 2010
Posts: 715
Received Thanks: 328
how to update my server to yours?
* White * is offline  
Old   #12
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 319
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   #13
 
elite*gold: 0
Join Date: Nov 2008
Posts: 350
Received Thanks: 29
man .. now i have other problem ..
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.
madutz1 is offline  
Old   #14
 
elite*gold: 0
Join Date: Oct 2010
Posts: 715
Received Thanks: 328
I need to replace my files to your files.thats all?
* White * is offline  
Old   #15
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 319
madutz1

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

White&Black

Yes


3lyka is offline  
Thanks
1 User
Reply



« Previous Thread | Next Thread »

Similar Threads
[Guide] Setup MSSQL for Personal PServers
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...
14 Replies - Shaiya PServer Guides & Releases
Hilfee!!!! Prob mit Server files Und Db MSSQL
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...
1 Replies - Flyff PServer - Discussions / Questions
[GUIDE]ASP.NET error for MSSQL 20005
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...
0 Replies - Cabal Guides & Templates
How i find mssql server
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 ......
3 Replies - Kal Online
Sql Server 200 /MSSQL 200 ?
Hi where i can get Sql Server 2000 or MSSQL 2000 ? have any one a download link for me ?
2 Replies - Dekaron Private Server



All times are GMT +1. The time now is 21:52.


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

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.