DB Save(RollBackProtection)

Results 1 to 15 of 15
  1. #1
    Proficient Member Chale001 is offline
    MemberRank
    Dec 2012 Join Date
    187Posts

    DB Save(RollBackProtection)

    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.


  2. #2

    Re: DB Save(RollBackProtection)

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

  3. #3
    Account Upgraded | Title Enabled! David Emad is offline
    MemberRank
    Oct 2013 Join Date
    VipeRLocation
    230Posts

    Re: DB Save(RollBackProtection)

    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

  4. #4
    Proficient Member Chale001 is offline
    MemberRank
    Dec 2012 Join Date
    187Posts

    Re: DB Save(RollBackProtection)

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

  5. #5

    Re: DB Save(RollBackProtection)

    Quote Originally Posted by David Emad View Post
    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.

  6. #6
    Developer BeshoyFD is offline
    MemberRank
    Jul 2008 Join Date
    In World :)Location
    702Posts

    Re: DB Save(RollBackProtection)

    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

  7. #7
    Account Upgraded | Title Enabled! meme50 is offline
    MemberRank
    Oct 2011 Join Date
    617Posts

    Re: DB Save(RollBackProtection)

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

  8. #8
    Fusion Kal Reloaded V2 ItsTaP is offline
    MemberRank
    Feb 2013 Join Date
    UkraineLocation
    402Posts

    Re: DB Save(RollBackProtection)

    @meme50 its for DBServer.exe friend :)


    Kind Regards,
    ItsTaP

  9. #9
    Account Upgraded | Title Enabled! meme50 is offline
    MemberRank
    Oct 2011 Join Date
    617Posts

    Re: DB Save(RollBackProtection)

    thank you tap

  10. #10
    Developer BeshoyFD is offline
    MemberRank
    Jul 2008 Join Date
    In World :)Location
    702Posts

    Re: DB Save(RollBackProtection)

    Quote Originally Posted by ItsTaP View Post
    @meme50 its for DBServer.exe friend :)


    Kind Regards,
    ItsTaP
    actually its for mainsvrt.exe :D

  11. #11
    Member PercyGloryKal is offline
    MemberRank
    May 2014 Join Date
    In the worldLocation
    60Posts

    Re: DB Save(RollBackProtection)

    Mainsvrt or dbserver ? :p

  12. #12
    off@kal. - on@gw2/d3 :) TranX1337 is offline
    MemberRank
    May 2009 Join Date
    GermanyLocation
    776Posts

    Re: DB Save(RollBackProtection)

    hell... for auth... idiots!

  13. #13
    Developer BeshoyFD is offline
    MemberRank
    Jul 2008 Join Date
    In World :)Location
    702Posts

    Re: DB Save(RollBackProtection)

    hhhhhhhhhh thats so funny :D
    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

  14. #14
    Account Upgraded | Title Enabled! meme50 is offline
    MemberRank
    Oct 2011 Join Date
    617Posts

    Re: DB Save(RollBackProtection)

    thank you dragon you are the best^^

  15. #15
    Modeler / C++ Coder Matynator is offline
    DeveloperRank
    Feb 2008 Join Date
    NetherlandsLocation
    577Posts

    Re: DB Save(RollBackProtection)

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

    :) same thing same purpose..



Advertisement