Temporary solution for green/red/black book

[Chern0byl]

So, since vsro has such a "nice" thing like green/red/black books, i've made a simple solution for this, temporary, through.

So, You have to open your GlobalManager.exe, and search for this HEX code

7570646174652054425F555345522073657420416363506C617954696D65

Which means

update TB_USER set AccPlayTime

Now just change AccPlayTime part to a some another name, for example, OnlineTime. After you are done, save the file, and open sql server management studio, open SRO_VT_ACCOUNT database, TB_User table, set all AccPlayTime field values to 0, and create a new column named "OnlineTime" (int).

Simple as that, but not the best solution. Users will have to relogin in order to be able to gain experience once green book appears (it will just reset).

You can use nearly any hex editor for this. I'd preffer Hex Workshop, or XVI32.

 

[NoNStop]

Re: [Tutorial] Temporary solution for green/red/black book

oh good idea, thanks

 

[rogan12]

Re: [Tutorial] Temporary solution for green/red/black book

Thank you for this. Now testing, but you are right, not funny if you are in the middle of something, and need to logout. But this is better then nothing.

regards
rogan12

 

[Y@$$ER LOTFY]

Re: [Tutorial] Temporary solution for green/red/black book

Thanks Chirnobyl

 

[rogan12]

Re: [Tutorial] Temporary solution for green/red/black book

The server starts fine now, only the client hangs during loading of X-trap.
Must be something with the new collum i created then.

You don't tell if it should be int, or whatever, allow null or not.

regards
rogan12

 

[Chern0byl]

Re: [Tutorial] Temporary solution for green/red/black book

It should be int.

 

[rogan12]

Re: [Tutorial] Temporary solution for green/red/black book

Started it all over again, and still the same problem. X-trap hanging. Didn't had that problem before hexing global manager and adding that collum.

weird.....

Anyone else having problems after doing this ?

 

[Nah001]

Re: [Tutorial] Temporary solution for green/red/black book

client hangs during loading of X-trap.
Because Silkroad.dat that u have is connecting to >xtrap update server 123.30.200.70 and its down off today,you can check in firewall logs if not believe
you need silkroad.dat from Synx i'ts working atm


this if you can encode u can see the ip 123.30.200.6 update xtrap server edit this in silkroad.dat

660970B4E849D93EE63C6D9849CFED62CBFA91FB2C16EABFBFB6ACFCBB61A163A3200BB3E32873D8393323E3D4104B38282A1FA80D51B4121660FCF8DFB2BCB40F7D04245246E456F726430D8B1E255D3D358890
//Brought to you by Synx

just edit this in ur... u can open .dat with notepad

 

[rogan12]

Re: [Tutorial] Temporary solution for green/red/black book

Could you post a link for silkroad.dat Synx ?

It doesn't work either, still x-trap loading error.

regards
rogan12

 

[Kill4u]

Re: [Tutorial] Temporary solution for green/red/black book

Started it all over again, and still the same problem. X-trap hanging. Didn't had that problem before hexing global manager and adding that collum.

weird.....

Anyone else having problems after doing this ?

It is X-trap related error in general nothing to do with server files even official server (D-SRO/B-SRO) doesnt work..
It is a new problem with xtrap servers perhaps i have no idea

 

[s2k]

Re: [Tutorial] Temporary solution for green/red/black book

are you sure you are using the AgentServer with Xtrap and not the cracked one?

 

[rogan12]

Re: [Tutorial] Temporary solution for green/red/black book

Yes i know.
Seems like someone doesn't like the idea that we can connect to our servers.
I kind of expected something like that.
A solution could be a bypass of x-trap.

@s2k
Yes i'm sure, i use the untouched one that was part of the serverfiles.

regards
rogan12

 

[s2k]

Re: [Tutorial] Temporary solution for green/red/black book

well i tried and for me it is working normally. using SRO11 client, bloody media.pk2 and this silkload.dat
(with hamachi)

playing magic pop local:

 

[Chern0byl]

Re: [Tutorial] Temporary solution for green/red/black book

Yes i know.
Seems like someone doesn't like the idea that we can connect to our servers.
I kind of expected something like that.
A solution could be a bypass of x-trap.

@s2k
Yes i'm sure, i use the untouched one that was part of the serverfiles.

regards
rogan12

I will release cracked server/client Xtrap soon.

 

[siema]

Re: [Tutorial] Temporary solution for green/red/black book

hmmm... what about to add in SQL Server Agent "job" which will auto-restart "AccPlayTime" ?

UPDATE TB_USER
SET AccPlayTime='0'

or

UPDATE TB_USER
SET AccPlayTime='0'
WHERE AccPlayTime<10670

Chern0byl what do you think?

 

[Y@$$ER LOTFY]

Re: [Tutorial] Temporary solution for green/red/black book

when i edit things using xiv32 hex editor, it doesn't run after this got "Not valid windows 32 app" error message

 

[ger580]

Re: [Tutorial] Temporary solution for green/red/black book

I tested this

ALTER TABLE dbo.TB_User
ADD OnlineTime varchar(int);

And This

ALTER TABLE dbo.TB_User
ADD OnlineTime (int);


But doesnt work where is my Fail? (im not a mssql Pro)

 

[ekizde]

Re: [Tutorial] Temporary solution for green/red/black book

I tested this

ALTER TABLE dbo.TB_User
ADD OnlineTime varchar(int);

And This

ALTER TABLE dbo.TB_User
ADD OnlineTime (int);


But doesnt work where is my Fail? (im not a mssql Pro)

i didnt get the server files work for me, but if is about time, u should to choose datetime as data type.

 

[FantasyDesign]

Re: [Tutorial] Temporary solution for green/red/black book

Try this:

update TB_USER set AccPlayTime='0'
ALTER TABLE dbo.TB_User
ALTER COLUMN OnlineTime int

 

[ger580]

Re: [Tutorial] Temporary solution for green/red/black book

@ekizde & FantasyDesign

Doesn't work