Fixing the Leaked server files Vol.2

[DarkestxHour]

Originally Posted by 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

from the looks of it it's just an SQL for adding silks to account

[kevin_owner]

@crayu nice one could be usefull

@MAFIA001 that's probably just some of the static data which the server needs but those are just static stuff the hard part are the stored procedures which has logic in it which we just don't know

[CraYu]

@DarkestxHour yes its from Bill DB, im sure some guy sell this BR Server files that esro use.Because Panya a Golf MMO was leaked too so....

[Davincibg]

I thought that in the previous "breaktrough" the ref problem was fixed :?

[DarkestxHour]

I think Joymax realized what they created and just don't wanna share it let's hope at least eSro makes it somewhere cuz i got a slight feeling they actually bought those server files

[kevin_owner]

The fix some guys found was noping stuff in the asm code xD

and hwat I did was deleted columns till it worked. but the ref isn't the problem right now the problem is getting the client started

[DarkestxHour]

Originally Posted by kevin_owner

The fix some guys found was noping stuff in the asm code xD

and hwat I did was deleted columns till it worked. but the ref isn't the problem right now the problem is getting the client started

lol

althought i think that deleting the whole function that is getting/sending the ref doesn't count as a fix XD

[kevin_owner]

Well it was more like testing what the files do if you delete some things. so you just skip the whole loading part and the gameserver says that everything loaded so you know what you need to launch the client. and it didn't change anything so you probably need to fully fix the cert, global, gateway and farm? or whatever those other things where and then focus on the gameserver.

[Davincibg]

Originally Posted by kevin_owner

The fix some guys found was noping stuff in the asm code xD

and hwat I did was deleted columns till it worked. but the ref isn't the problem right now the problem is getting the client started

No there was one with a working ref

[kevin_owner]

Ah oke well those ref's aren't the big problem those are just the static data which you can extract from the text files in the client. (at least a lot I guess)
the real program are the stored procedures and launching the client

[BoneyM]

hm, I tried to connect with rsro client, it still asks me to download a fresh client from an official page.

[melkorz123]

You need to disable client's updating, maybe making it a much more updated version, i mean if its 1.111 and you put 9.999 it will not check for updates since that is the most updated one for sure. I can change the version if you need to

[lorveth]

Originally Posted by melkorz123

You need to disable client's updating, maybe making it a much more updated version, i mean if its 1.111 and you put 9.999 it will not check for updates since that is the most updated one for sure. I can change the version if you need to

Then it will give you error, that you have the wrong client number.

Anyway, I found something in the config file of the pk2, the client may read it, may not.
Config/option.txt

//StartProcess = "CPSLoadingMission"
StartProcess = "CPSVersionCheck"

Whats about:

//StartProcess = "CPSLoadingMission"
//StartProcess = "CPSVersionCheck" ?
So it shouldnt read the version number, or Im wrong?

[melkorz123]

Originally Posted by KingLi :P

Then it will give you error, that you have the wrong client number.

Anyway, I found something in the config file of the pk2, the client may read it, may not.
Config/option.txt

//StartProcess = "CPSLoadingMission"
StartProcess = "CPSVersionCheck"

Whats about:

//StartProcess = "CPSLoadingMission"
//StartProcess = "CPSVersionCheck" ?
So it shouldnt read the version number, or Im wrong?

You are right, that would fix it I guess, is the calling the executable follows to run the version checking.

Well up to version stuff I know how to run the server and make it work and stuff but I am not working on pk2 anymore

[BoneyM]

If server files version <= client version, client will give Invalid version error.
If server files version > client version, client will ask to Download new client from official page.

yeah I'm noob in pk2 editing too