Season 2 Trickster Online Server/Client Files (503MB / 721MB)

[gryphie]

Re: Season 2 Trickster Online Server/Client Files

iostream

I did follow your steps in regards to this. Would you be able to post screen shots on these steps for us all please?

 

[iostream]

Re: Season 2 Trickster Online Server/Client Files

@iostream

I did follow your steps in regards to this. Would you be able to post screen shots on these steps for us all please?

What is your timezone?
My is GMT+7 (Thailand)

I can teamviewer and do the setup process while record video too.
(but I need early fresh+clean windows todo that so everyone can follow)

 

[gryphie]

Re: Season 2 Trickster Online Server/Client Files

iostream

Im GMT. And unfortunately its not a fresh copy of Windows 2008 r2. Its a dedicaited server.

It has MSSQL 2012 on it as well. But its running other software. If you want to PM me, feel free to.

 

[iostream]

Re: Season 2 Trickster Online Server/Client Files

@iostream

Im GMT. And unfortunately its not a fresh copy of Windows 2008 r2. Its a dedicaited server.

It has MSSQL 2012 on it as well. But its running other software. If you want to PM me, feel free to.

Okay PMed with my skype ID

 

[iceblade112]

Re: Season 2 Trickster Online Server/Client Files

These files require at least 7gb of RAM (actually, that's what everything running takes, including SQL + Windows).

Oh, and the worst part is that 7gb is on WS2003. You'll probably need 8gb dedicated to the server with 2008.

 

[hackerz10001]

Re: Season 2 Trickster Online Server/Client Files

These files require at least 7gb of RAM (actually, that's what everything running takes, including SQL + Windows).

Oh, and the worst part is that 7gb is on WS2003. You'll probably need 8gb dedicated to the server with 2008.

Actually you can easily cut corners on those files, at minimum you can do is 4 GB RAM with some minor optimizations. Won't be releasing that information since its actually a trade secret. But if you figure it out, then kudos to you.

 

[iostream]

Re: Season 2 Trickster Online Server/Client Files

Actually you can easily cut corners on those files, at minimum you can do is 4 GB RAM with some minor optimizations. Won't be releasing that information since its actually a trade secret. But if you figure it out, then kudos to you.

How? tell me ^^

 

[iceblade112]

Re: Season 2 Trickster Online Server/Client Files

Actually you can easily cut corners on those files, at minimum you can do is 4 GB RAM with some minor optimizations. Won't be releasing that information since its actually a trade secret. But if you figure it out, then kudos to you.

Lots of swap and making GameServer1 take all of the zones...
Bad idea, but okay.

 

[hackerz10001]

Re: Season 2 Trickster Online Server/Client Files

Lots of swap and making GameServer1 take all of the zones...
Bad idea, but okay.

Terrible way, my way is different.

 

[gryphie]

Re: Season 2 Trickster Online Server/Client Files

PyroSamurai

Any way of getting the Cash Shop working? Would be great to have it working so when you play your own game, you can play with what you want xD

 

[xjzragezone]

Re: Season 2 Trickster Online Server/Client Files

PyroSamurai

Any way of getting the Cash Shop working? Would be great to have it working so when you play your own game, you can play with what you want xD

Website is in the files. But There is no guide to use them.

 

[gryphie]

Re: Season 2 Trickster Online Server/Client Files

Website is in the files. But There is no guide to use them.

Yeah. I tried making a webserver for them, and then hexing the webserver address into the Client. But it doesnt load the points, as it sits as Cash Fail, and doesnt load the buy window up.

-----------EDIT

Also found out that the Master_Server wont allow me to pick up Equips off the ground. These are the error codes.

SQLState = 23000, NativeError = 2627;
SQLState = 01000 NativeError = 3621



2015-01-26 12:50:06 { ? = call uspm_item_insert_get_item_rare (101288868, 600000, 1, 1, 0, 1,10000, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) } :
szSqlState = 01000, pfNativeError = 3621 : [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.
ODBCRowNumber = 1, SSrvrLine = 22, SSrvrMsgState = 1, SSrvrSeverity = 0, SSrvrSrvname = *********\SQLEXPRESS

---

iostream

Just wondering if anyone can point out the issue. As this is stopping me from picking up any equips off the ground.

 

[iostream]

Re: Season 2 Trickster Online Server/Client Files

[STRIKE]it was my fault that had been remove MD5 password function..
you can re-enable it or do the following

cash fix..
gmg_account
edit uspn_get_user_authority_check stored procedures
look for this and add following code

set @account_pw = SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', LOWER(@account_pw))), 11, 16)

it should be like this...

select @acc_game_authcode = acc_game_authcode
, @acc_game_state = acc_game_state
, @acc_game_latest_ip = acc_game_latest_ip
, @account_pw = A.account_pw
from tbl_account_game as AG
inner join tbl_account as A on A.account_code = AG.account_code
where account_gid = @account_gid
and game_code = 1

set @account_pw = SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', LOWER(@account_pw))), 11, 16)

if (@@rowcount = 0)
begin
set @error = 101
set @error_msg = 'Not found account game info !!!'
end

since there a lot MD5 function use... more problem will come

better is to use original fn_MD5_encrypt.. and install xp_encrypt[/STRIKE]
Feb 28, 2015
you don't need to do that, if you download DB.7z in my short guide after Feb 5, 2015
any1 who do the setup be4 pls re download DB.7z and apply in your DB

 

[xjzragezone]

Re: Season 2 Trickster Online Server/Client Files

it was my fault that had been remove MD5 password function..
you can re-enable it or do the following

cash fix..
gmg_account
edit uspn_get_user_authority_check stored procedures
look for this and add following code


it should be like this...


since there a lot MD5 function use... more problem will come

better is to use original fn_MD5_encrypt.. and install xp_encrypt

You are the angel! Your information is useful!

 

[gryphie]

Re: Season 2 Trickster Online Server/Client Files

iostream

Did what you suggested with the cash fix. Unfortunately, it is still giving the "Cash Fail" on the client. Not entirely certain why.

 

[iceblade112]

Re: Season 2 Trickster Online Server/Client Files

iostream

Did what you suggested with the cash fix. Unfortunately, it is still giving the "Cash Fail" on the client. Not entirely certain why.

Cash is web-based.

 

[gryphie]

Re: Season 2 Trickster Online Server/Client Files

iceblade112

Yes. In which I am running a Webserver through IIS 7.5, set to the IP and port. c:

 

[iostream]

Re: Season 2 Trickster Online Server/Client Files

Cash is web-based.

client send md5 password to webshop..
since my stored procedures use plain text password
it'll cause problem..
solution is temp convert password and compare password from client..
@gryphie
you need to config sql user+password in some asp config webpage too.

​

 

[xjzragezone]

Re: Season 2 Trickster Online Server/Client Files

When I buy the item in the shop, something is wrong with the message like "error 3910: "[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction context in use by another session."

In the server file, there is some information printed out!

 

[iostream]

Re: Season 2 Trickster Online Server/Client Files

check inc/config.asp

use user + pass in step3(short guide)