pSRO Server files including Database

[alex62]

Edit:

use this site:

[rom55]

OMGGG ....

[Jahte]

Lol... why cant we test server in thise way : haros start it, we patch media.pk2 and try to connect =\

[babbe0]

The tutorial is now partially translated.

SQL server 2000

Start a SQL server 2000 . Start the setup and select the "SQL Server 2000 Components" ! Choose "Install Database Server" and click the next button ! Select "Local Computer" and click next ! Select "Create a new instance of SQL Server,or install Client Tools" and click again on next . Write the name and your company name! (Example: name :Silkroad ! Company : Silkroadonline)
Click Yes ! Select "Server und Clients tools" and click next . Choose the Default on the top and click next . Select "Typical' and click next .
Select "the same account for each service" . "Auto start SQL Server service" and then "Use the Local System account" , click on "Mixed Mode" and enter the password (pass: Silkroadonline) and click next .
Then let it load (I dont know if it's called loading exactly ) . After that restart your PC, even if there is no message that tells you to do it.


ODBC

Open ODBC.




Go to the "System DSN". Click add. On the bottom and left click "SQL server" . Click quit ?? (I dont think so). Set the name to "silkroadonline". Set the reason to "silkroadonline". Select "local" as moderator (not sure if it's moderator). Click next 2 times. In that moment change the table to that one on the bottom. Next. On "veri kaynagina" go on. (basariyla sinandi/tamamlandi derse, Successfully finished) Then click on ok.

How to make a server folder

Open the sl.rar . Open the certificate file. Open IPs. When IPs is opened, you can see all IP numbers. Change them all to your IP number. (To find out your IP start cmd and write "ipconfig".) Open sgl (probably SQL?) after that. Change the IPs to your IP there too. Places called "dsn" will become "odbcdeki" (I think that means your database name, silkroadonline). Uid becomes the created account for the database. Pwd becomes your selected password. Database becomes the account.


Sorry for any mistakes, I just translated it (took me 40 mins -.-)

[PhoBoVien]

so this work?

[ShooTTheNooB]

if anyone could please add me on xfire or msn i cannot even get past like 10% in this tut, its nicely done but the whole SQL thing my msn is and my xfire is gabethesk8er if u could pls add me and help me out if uve gotten far into this tutorial

[IMOS]

Originally Posted by jolle

The Screenshots are OLD! Not from the new Files

The files in here have no SQL files still...

[audi0slave]

Doesnt WORK

[BF59]

Originally Posted by IMOS

The files in here have no SQL files still...

check japan files , they are sql file...

or go back learn sql..

[Jahte]

odbcyi acıyoruz.(denetim masası-->yonetimsel araclar-->ceri kaynakları(ODBC)) açın.sistem dsn yerine gelin.ekle diin.en asagıda SQL serverı seçin.son diin.adı kısmına silkroadonline yazın.açıklama kısmına silkroadonline yazın.sunucuyu (local) seçin.ileri diin.gene ileri diin.yukardaki varsayılan veritabanını asagıdaki ile degistir kısmını isaretleyip databasemiz olan account u işaretleyin.ileri diin.son diin.veri kaynagını sına diin.basarıyla sınandı derse olmustur.ondan sonra tamam diin.

I think we shold create odbc like silkroadonline, and yazın.sunucuyu, diin.yukardaki diin.basarıyla, olmustur.ondan .... but i dont know turkish.. just seems so.

[coiutz]

so anybody got it to work or not..and if not what is missing or what needs to do
edit:when i dll the srogame it shows me that it got trojan pcclient ... btw scanned with nod32...it doesn't let it be saved on my pc

[-Chernobyl]

Originally Posted by coiutz

so anybody got it to work or not..and if not what is missing or what needs to do
edit:when i dll the srogame it shows me that it got trojan pcclient ... btw scanned with nod32...it doesn't let it be saved on my pc

I'll tell you whats missing.
1. A working Database. Not the SREMU database that is trying to be passed off here. The Emulator database will not work with the SL.rar, which are real server files
These database files don't contain the Reference tables needed for the server to run

2. The correct client. 1.091 will only work with the Chinese server, not Jsro server files that are a later version of Silkroad.

I don't believe the Turk that is trying to pass off the database actually has the JSRO database. Only time will tell.

[coiutz]

that sucks... i mean we almost got it and...we are also so far away from getting it....I wonder how much time will pass untill we all can make prv servers..-.-

[alecz24]

coiutz..u never know when private servers will appear..best example:Cabal Online:3-4 months ago it was IMPOSSIBLE to make a cabal private server-even estSOFT sayd it was really hard for them to remake the servers when they moved them from USA to EUROPE.even thoe they said that...in june over 5 Cabal private servers were opened in just 2 days.no one was expecting cabal private servers so soon with soo small ammont of bug-and i really mean small.lets hope the story will repeat itself again with sro this time

[CunK]

notify request server certification 2008-08-29 15:23:46 796
notify Add ServerNotify : (1) - Certification 2008-08-29 15:23:47 531
notify Add ServerNotify : (698) - GatewayServer 2008-08-29 15:23:47 562
notify Add ServerNotify : (699) - MachineManager 2008-08-29 15:23:47 562
notify Add ServerNotify : (700) - DownloadServer 2008-08-29 15:23:47 562
notify Add ServerNotify : (701) - MachineManager 2008-08-29 15:23:47 562
notify Add ServerNotify : (702) - DownloadServer 2008-08-29 15:23:47 562
notify Add ServerNotify : (703) - MachineManager 2008-08-29 15:23:47 562
notify Add ServerNotify : (704) - FarmManager 2008-08-29 15:23:47 562
notify successfully server certificated 2008-08-29 15:23:47 562
notify server cord established : 1 (............:32000) 2008-08-29 15:23:47 562
notify Successfully DB Initialized! 2008-08-29 15:23:47 609
fatal Can't connect to account DB 2008-08-29 15:24:11 156
fatal cannot occupy db session : select * from SK_SilkChange_BY_Web 2008-08-29 15:24:11 156
fatal cannot occupy db session : update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 64 2008-08-29 15:24:11 156
fatal cannot occupy db session : select * from SK_SilkChange_BY_Web 2008-08-29 15:24:16 781
fatal cannot occupy db session : select * from SK_SilkChange_BY_Web 2008-08-29 15:24:21 781
fatal cannot occupy db session : update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 64 2008-08-29 15:24:21 796
fatal cannot occupy db session : select * from SK_SilkChange_BY_Web 2008-08-29 15:24:26 781
notify server cord closed : 1 2008-08-29 15:24:27 171
fatal cannot occupy db session : select * from SK_SilkChange_BY_Web 2008-08-29 15:24:31 781
fatal cannot occupy db session : update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 64 2008-08-29 15:24:31 781

Help me!