DB Save(RollBackProtection)

[Chale001]

Hello,
I was searching for the hex address I have to modify in order to decrease the amount of time needed for the DBsvr to save, I have searched but found nothing...
Would be thankful.

 

[strik3r2k5]

dont have it here but if you have IDA, check the function CPlayer::Tick. there it is.

 

[David Emad]

modify in ur SQL Player.dbo and put new value into it called : CurHT Int do the same with CurMT

----
S.P:

CREATE PROCEDURE [dbo].[CreatePlayer]


@uid int, @name varchar(14), @class tinyint, @Strength tinyint, @Health tinyint, @Intelligence tinyint, @Wisdom tinyint, @dexterity tinyint, @curht int, @curmt int, @Map tinyint,
@x int,
@y int,
@z int, @face tinyint, @Hair tinyint
AS


INSERT INTO Player ( [UID], [Name], [Class], [Strength], Health, Intelligence, Wisdom, Dexterity, [CurHT], [CurMT], [Map], [X], [Y], [Z], [Face], [Hair])
VALUES ( @uid @name @class @Strength, @Health @Intelligence @Wisdom, @dexterity @curht @curmt, 0, 256171, 256020, 16410, @face, @Hair)

---------
DB hex:

UPDATE Player SET [Level] = %d, [Specialty] = %d, [Contribute] = %d, [Exp] = %I64d, [GRole] = %d, [Strength] = %d, [Health] = %d, [Intelligence] = %d, [Wisdom] = %d, [Dexterity] = %d, [CurHP] = %d, [CurMP] = %d, [PUPoint] = %d, [SUPoint] = %d, [Killed] = %d, [Map] = %d, [X] = %d, [Y] = %d, [Z] = %d, [Rage] = %d WHERE [PID] = %d


Replace this with:


UPDATE Player SET [Level] = %d, [Specialty] = %d, [Contribute] = %d, [Exp] = %I64d, [GRole] = %d, [Strength] = %d, [Health] = %d, [Intelligence] = %d, [Wisdom] = %d, [Dexterity] = %d, [CurHT] = %d, [CurMT] = %d, [PUPoint] = %d, [SUPoint] = %d, [Killed] = %d, [Map] = %d, [X] = %d, [Y] = %d, [Z] = %d, [Rage] = %d WHERE [PID] = %d

i dont know if u are searching for it. but tried to help

 

[Chale001]

CPlayer::Tick Adr 0x00452620
That's the function address and IDA ss,
Which value should be modified?
Thanks in advance =)

 

[strik3r2k5]

modify in ur SQL Player.dbo and put new value into it called : CurHT Int do the same with CurMT

----
S.P:

CREATE PROCEDURE [dbo].[CreatePlayer]


@uid int, @name varchar(14), @class tinyint, @Strength tinyint, @Health tinyint, @Intelligence tinyint, @Wisdom tinyint, @dexterity tinyint, @curht int, @curmt int, @Map tinyint,
@x int,
@y int,
@z int, @face tinyint, @Hair tinyint
AS


INSERT INTO Player ( [UID], [Name], [Class], [Strength], Health, Intelligence, Wisdom, Dexterity, [CurHT], [CurMT], [Map], [X], [Y], [Z], [Face], [Hair])
VALUES ( @uid @name @class @Strength, @Health @Intelligence @Wisdom, @dexterity @curht @curmt, 0, 256171, 256020, 16410, @face, @Hair)

---------
DB hex:

UPDATE Player SET [Level] = %d, [Specialty] = %d, [Contribute] = %d, [Exp] = %I64d, [GRole] = %d, [Strength] = %d, [Health] = %d, [Intelligence] = %d, [Wisdom] = %d, [Dexterity] = %d, [CurHP] = %d, [CurMP] = %d, [PUPoint] = %d, [SUPoint] = %d, [Killed] = %d, [Map] = %d, [X] = %d, [Y] = %d, [Z] = %d, [Rage] = %d WHERE [PID] = %d


Replace this with:


UPDATE Player SET [Level] = %d, [Specialty] = %d, [Contribute] = %d, [Exp] = %I64d, [GRole] = %d, [Strength] = %d, [Health] = %d, [Intelligence] = %d, [Wisdom] = %d, [Dexterity] = %d, [CurHT] = %d, [CurMT] = %d, [PUPoint] = %d, [SUPoint] = %d, [Killed] = %d, [Map] = %d, [X] = %d, [Y] = %d, [Z] = %d, [Rage] = %d WHERE [PID] = %d

i dont know if u are searching for it. but tried to help

this is something totally different..

anyways.
0x452696
in Pseudo C it's this
if ( *(_DWORD *)(v14 + 1440) >= 0x258u )
sub_4586A0(v14, 0);

in asm
cmp dword ptr [ecx+5A0h], 258h

the 258 is 600 which is 10 minutes.

 

[BeshoyFD]

Solve Rollback, Update db ever 1minut
offset 52690 -> 81 B9 A0 05 00 00 58 02 00 00 [TO] 81 B9 A0 05 00 00 3C 00 00 00

 

[meme50]

thx alot dragon
this hex for DBServer.exe or MainSever.exe !

 

[ItsTaP]

@meme50 its for DBServer.exe friend


Kind Regards,
ItsTaP

 

[meme50]

thank you tap

 

[BeshoyFD]

meme50 its for DBServer.exe friend


Kind Regards,
ItsTaP

actually its for mainsvrt.exe

 

[PercyGloryKal]

Mainsvrt or dbserver ?

 

[TranX1337]

hell... for auth... idiots!

 

[BeshoyFD]

hhhhhhhhhh thats so funny
anyway its for mainsvrt.exe

mainsvrt is do count down for database updates then send the socket to dbsvrt to do the updates
so to decrease count down for player table to solve rollback
you have to hex mainsvrt with the offset i gave

 

[meme50]

thank you dragon you are the best^^

 

[Matynator]

Memory->Set(0x00452696,"\x78\x00",1); // Database save every minute

same thing same purpose..