rollback >.<

[Nizjni]

hello there's exp lose in my server
after relog = rollback + exp lose

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go



ALTER PROCEDURE [dbo].[UpdatePlayer]

@Level int,
@Specialty int,
@Contribute int,
@Exp int,
@GRole int,
@Strength int,
@Health int,
@Intelligence int,
@Wisdom int,
@Dexterity int,
@CurHP int,
@CurMP int,
@PUPoint int,
@SUPoint int,
@Killed int,
@Map int,
@X int,
@Y int,
@Z int,
@Rage int,
@PID int

AS

IF(@CurHP > 62000) 
BEGIN
UPDATE Player SET [Level] = @Level, [Specialty] = @Specialty, [Contribute] = @Contribute, [Exp] = @Exp, [GRole] = @GRole, [Strength] = @Strength, [Health] = @Health, [Intelligence] = @Intelligence, [Wisdom] = @Wisdom, [Dexterity] = @Dexterity, [CurHP] = 32000, [CurMP] = @CurMP, [PUPoint] = @PUPoint, [SUPoint] = @SUPoint, [Killed] = @Killed, [Map] = @Map, [X] = @X, [Y] = @Y, [Z] = @Z, [Rage] = @Rage WHERE [PID] = @PID
END
ELSE
BEGIN
UPDATE Player SET [Level] = @Level, [Specialty] = @Specialty, [Contribute] = @Contribute, [Exp] = @Exp, [GRole] = @GRole, [Strength] = @Strength, [Health] = @Health, [Intelligence] = @Intelligence, [Wisdom] = @Wisdom, [Dexterity] = @Dexterity, [CurHP] = @CurHP, [CurMP] = @CurMP, [PUPoint] = @PUPoint, [SUPoint] = @SUPoint, [Killed] = @Killed, [Map] = @Map, [X] = @X, [Y] = @Y, [Z] = @Z, [Rage] = @Rage WHERE [PID] = @PID
END 

update player alrdy hexed
anyone know? ;/

[MentaL]

[Darn]

IF(@CurHP > 62000)  // 62k hp? should be 32k or not ?

take a look in this
http://forum.ragezone.com/f389/guide...hp-bug-912682/

[Nizjni]

alrdy made it 32k too
but my server is low rate not high rate:D so i dont need updateplayer

maybe because sirlvl stored?
i forget to add it but will fix rollback?

[Bound]

alrdy made it 32k too
but my server is low rate not high rate:D so i dont need updateplayer

maybe because sirlvl stored?
i forget to add it but will fix rollback?

sirlvl may fix it , have a try