Fixing the Leaked server files Vol.2

[lorveth]

Did you tryed "05" instead of 5?
Because, I hope you know, the client counts the version number +1000.

[DarkestxHour]

what version are these leaked files anyway?

[kevin_owner]

the old ones probably the same as ecsro, swsro, sjsro or whatever all that **** is called

but there are some things which might be a sign for euro's

[HaGsTeR]

Originally Posted by kevin_owner

the old ones probably the same as ecsro, swsro, sjsro or whatever all that **** is called

but there are some things which might be a sign for euro's

well stallnet got implemented at the same time as euro
pservers such as Ecsro swsro blablabla has stallnet

[DarkestxHour]

Originally Posted by kevin_owner

the old ones probably the same as ecsro, swsro, sjsro or whatever all that **** is called

but there are some things which might be a sign for euro's

so there is a chance that ecsro and others just fixed these leaked server files?

[lorveth]

Originally Posted by DarkestxHour

so there is a chance that ecsro and others just fixed these leaked server files?

they are using csro open beta files

[DarkestxHour]

PUA.Packed.Armadillo-1 wtf?

[melkorz123]

SMC accounts are just normal accounts, which you login with account id, password and SNumber, which used to be QQ or something. It works on 15880 port, also the plugins on the leaked sl.rar aren't working, you will need original ones

Anyway you are missing all databases' procedures, even if you get to fix this stuff you won't be able to make anything ingame..

SMC stuff is on sr_accountdb

[kevin_owner]

The smc is just a management tool which you can program by yourself so that isn't required to run the server

[BoneyM]

@silkbotter I was meaning "no, stored procedures isn't complete".

@KingLi it's same thing if I use 5 or 05, 6 or 06, at last I get same result

[melkorz123]

Originally Posted by kevin_owner

The smc is just a management tool which you can program by yourself so that isn't required to run the server

You are right.

@Threadstarter if you have any other doubt just ask

[lorveth]

Originally Posted by BoneyM

@silkbotter I was meaning "no, stored procedures isn't complete".

@KingLi it's same thing if I use 5 or 05, 6 or 06, at last I get same result

Hmm, use other ports, because Ive got at my last try:
Patch error or something like that<--this error with wrong client version number^^
Example: you use wrong version number on swsro or zszc, then you get an error with some patch thingy, that one Ive got too.

[CraYu]

I found something interesting in a DB from other MMO

 Spoiler

CREATE PROCEDURE [dbo].[UP_NT_MB_SILKACCOUNT_UPD]

@pi_strUserID VARCHAR(50),
@pi_intBRCookieAmt MONEY,
@pi_intCookieNumber BIGINT,
@pi_strIPAddr VARCHAR(50)=NULL, --IP Address
@pi_strPayMethod INT, --(9:free cookie)

@pi_strPGCode VARCHAR(15),
@po_strErrMsg VARCHAR(256) OUTPUT,
@po_intRetVal INT OUTPUT
AS

DECLARE @v_intJID INT
DECLARE @v_intCntRow INT
DECLARE @v_intRemainSilk INT
DECLARE @v_intCnt INT

SET @pi_intBRCookieAmt = ISNULL(@pi_intBRCookieAmt,0)
SET @po_strErrMsg = ''OK''
SET @po_intRetVal = 0

IF ISNULL(@pi_strIPAddr,'''') = '''' BEGIN
SET @pi_strIPAddr = ''0.0.0.0''
END

SELECT @v_intJID = JID
FROM BRACCOUNTDB.BR_AccountDB.dbo.TB_User
WHERE strUserID = @pi_strUserID

IF @@ROWCOUNT <> 1 OR @@ERROR <> 0 BEGIN
SET @po_strErrMsg = ''Black Rogue Account search Error''
SET @po_intRetVal = 1058
RETURN
END

SELECT @v_intCntRow = COUNT(*)
FROM BRACCOUNTDB.BR_AccountDB.dbo.SK_Silk
WHERE JID = @v_intJID

IF @v_intCntRow = 1 BEGIN
UPDATE BRACCOUNTDB.BR_AccountDB.dbo.SK_Silk
SET SILK_OWN = SILK_OWN + @pi_intBRCookieAmt
WHERE JID = @v_intJID

IF @@ERROR <> 0 BEGIN
SET @po_strErrMsg = ''Black Rogue Account search Error''
SET @po_intRetVal = 1059
END
END
ELSE IF @v_intCntRow = 0 BEGIN
INSERT INTO BRACCOUNTDB.BR_AccountDB.dbo.SK_Silk(JID, SILK_OWN, SILK_GIFT, SILK_POINT)
VALUES (@v_intJID, @pi_intBRCookieAmt, 0, 0)

IF @@ROWCOUNT <> 1 OR @@ERROR <> 0 BEGIN
SET @po_strErrMsg = ''Black Rogue Account search Error''
SET @po_intRetVal = 1060
END
END
ELSE BEGIN
SET @po_strErrMsg = ''SILK Account cnt Error(MORE THAN 1)''
SET @po_intRetVal = 1061
END

SELECT @v_intRemainSilk = SILK_OWN
FROM BRACCOUNTDB.BR_AccountDB.dbo.SK_Silk
WHERE JID = @v_intJID

IF @po_intRetVal = 0 BEGIN --SILK_DB APPLICATE SUCCEED
INSERT INTO BRACCOUNTDB.BR_AccountDB.dbo.SK_SilkBuyList(USERJI D, SILK_TYPE, SILK_REASON, SILK_OFFSET, SILK_REMAIN,
ID, BUYQUANTITY, ORDERNUMBER, PGCOMPANY, PAYMETHOD,
PGUNIQUENO, AUTHNUMBER, AUTHDATE, SUBJID, SRID,
SLIPPAPER, MNGID, IP, REGDATE)
VALUES(@v_intJID, 0, 0, @pi_intBRCookieAmt, @v_intRemainSilk,
0, 1, CAST(@pi_intCookieNumber AS VARCHAR), 0, @pi_strPayMethod,
@pi_strPGCode, '''', GETDATE(), @v_intJID, '''',
'''', '''', @pi_strIPAddr, GETDATE())

END
ELSE BEGIN --SILK_DB APPLICATE FAIL
SELECT @v_intCnt = COUNT(*)
FROM TCOOKIECHARGE_ERRLOG
WHERE COOKIENO = @pi_intCookieNumber

IF @v_intCnt = 0 BEGIN
INSERT INTO TCOOKIECHARGE_ERRLOG(USERID, COOKIEAMT, COOKIENO, IPADDR, USESTATE,
COOKIETYPE, REGDATE, ERRMSG, ERRCODE, PGCODE)
VALUES(@pi_strUserID, @pi_intBRCookieAmt, @pi_intCookieNumber, @pi_strIPAddr, 0,
9, GETDATE(), @po_strErrMsg, @po_intRetVal, @pi_strPGCode )
END
END

RETURN

[MAFIA001]

What about media.pk2? there in server_dep\silkroad\textdata\ you can see all Ref files like refabilitybyitemoptleveldata.txt,refaccesspermissi onofshop.txt,refconditiontobuyscrapitem.txt..maybe from this data possible to restore db..
what you think?

[CraYu]

lol that´s what i found is a small part from ini3 Black Rogue