Reset system function

[aliyevsaid2017]

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]

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] 

 @[Somente membros podem ver os links. ]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 = @[Somente membros podem ver os links. ]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 =  ''' + @[Somente membros podem ver os links. ]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