Reset system function

Please help me edit reset system. my now reset system is when character is reset stats stays and no point adds. but i want change to when reset stats will standart and add +500 point.


MY [WZ_CharMoveReset]

Código:

---

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_CharMoveReset]    Script Date: 04/19/2019 03:54:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_CharMoveReset]

@[Only registered and activated users can see links. Click Here To Register...]ID                varchar(10),
        @Namevarchar(10)
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE        @Result                        tinyint       
DECLARE        @ResultLowCount                int
DECLARE        @Class                                tinyint
DECLARE        @Ctl1_Code                        tinyint
DECLARE        @SQLEXEC                        varchar(1000)
DECLARE        @ErrorCheck                        INT
DECLARE        @g1                                varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10)
DECLARE        @MoveCnt                        tinyint               
DECLARE        @ChangeMoveCnt                tinyint               
DECLARE        @SqlStmt                        VARCHAR(700)               
DECLARE        @SqlStmt2                        VARCHAR(700)               

SET LOCK_TIMEOUT        1000
SET @Result = 0x00
SET @ErrorCheck = 0x00

SELECT @Class = Class, @Ctl1_Code = CtlCode FROMCharacterWHEREName = @Name

SELECT @ResultLowCount = @@rowcount, @ErrorCheck = @@error

IF @ResultLowCount = 0
BEGIN
SET @Result        = 0x02
GOTO ON_ERROR                                               
END

IF @ErrorCheck  <> 0GOTO ON_ERROR

IF  ( (@Ctl1_Code & 127 ) > 0 )
BEGIN
SET @Result        = 0x03
GOTO ON_ERROR                                               
END

SELECT  @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5, @MoveCnt = MoveCnt
FROM dbo.AccountCharacter WHEREId = @[Only registered and activated users can see links. Click Here To Register...]ID               

SELECT @ResultLowCount = @@rowcount, @ErrorCheck = @@error

IF @ResultLowCount = 0
BEGIN
SET @Result        = 0x02
GOTO ON_ERROR                                               
END

IF @ErrorCheck  <> 0GOTO ON_ERROR

SET @MoveCnt =  0

SET @SqlStmt = 'UPDATE AccountCharacter  '

IF ( @g1 = @Name )
SET @SqlStmt = @SqlStmt + ' SET  '
ELSEIF ( @g2 = @Name )
SET @SqlStmt = @SqlStmt + ' SET  '
ELSEIF ( @g3 = @Name )
SET @SqlStmt = @SqlStmt + ' SET  '
ELSEIF ( @g4 = @Name )
SET @SqlStmt = @SqlStmt + ' SET  '
ELSEIF ( @g5 = @Name )
SET @SqlStmt = @SqlStmt + ' SET  '
ELSE
SET @Result        = 0x05

IF ( @Result <> 0 )
GOTO ON_ERROR

SET @SqlStmt = @SqlStmt + ' MoveCnt =  ' + CONVERT(VARCHAR, @MoveCnt )                                       
SET @SqlStmt = @SqlStmt + ' WHERE Id =  ''' + @[Only registered and activated users can see links. Click Here To Register...]ID        + ''''
SET @SqlStmt2 = 'UPDATE Character '
SET @SqlStmt2 = @SqlStmt2 + 'SET  '
SET @SqlStmt2 = @SqlStmt2 + 'CtlCode = ' + CONVERT(VARCHAR, @Ctl1_Code & 127)
SET @SqlStmt2 = @SqlStmt2 + ' WHERE Name = ''' +  @Name + ''''

BEGINTRANSACTION

        EXEC(@SqlStmt)
SELECT @ResultLowCount = @@rowcount,  @ErrorCheck = @@error
IF  @ResultLowCount = 0GOTO ON_TRN_ERROR
IF  @ErrorCheck  <> 0GOTO ON_TRN_ERROR

        EXEC(@SqlStmt2)
SELECT @ResultLowCount = @@rowcount,  @ErrorCheck = @@error
IF  @ResultLowCount = 0GOTO ON_TRN_ERROR
IF  @ErrorCheck  <> 0GOTO ON_TRN_ERROR


ON_TRN_ERROR:
IF ( @Result  <> 0 ) OR (@ErrorCheck <> 0)
BEGIN
IF @Result = 0
SET @Result = 0x09

ROLLBACK TRAN
END
ELSE
COMMIT TRAN

ON_ERROR:
IF @ErrorCheck <> 0
BEGIN
SET @Result = 0x09
END

SELECT @Result

SET NOCOUNT OFF
SET XACT_ABORT OFF
END

---