[Help] Change Reset 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] 

   @accountID      varchar(10),
   @name         varchar(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 FROM Character WHERE Name = @name

   SELECT @resultLowCount = @@rowcount, @ERRORCheck =  @ERROR

   IF @resultLowCount = 0 
   BEGIN
      SET @result   = 0x02         
      GOTO ON_ERROR                  
   END

   IF @ERRORCheck  <> 0 GOTO 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 WHERE Id = @accountID       

   SELECT @resultLowCount = @@rowcount, @ERRORCheck =  @ERROR

   IF @resultLowCount = 0 
   BEGIN
      SET @result   = 0x02         
      GOTO ON_ERROR                  
   END

   IF @ERRORCheck  <> 0 GOTO ON_ERROR

   SET @moveCnt =  0

   SET @SQLStmt = 'UPDATE AccountCharacter  '

   IF ( @g1 = @name )
      SET @SQLStmt = @SQLStmt + ' SET  '
   ELSE IF ( @g2 = @name )
      SET @SQLStmt = @SQLStmt + ' SET  '
   ELSE IF ( @g3 = @name )
      SET @SQLStmt = @SQLStmt + ' SET  '
   ELSE IF ( @g4 = @name )
      SET @SQLStmt = @SQLStmt + ' SET  '
   ELSE IF ( @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 =  ''' + @accountID    + ''''            
   SET @SQLStmt2 = 'UPDATE Character '
   SET @SQLStmt2 = @SQLStmt2 + 'SET  '
   SET @SQLStmt2 = @SQLStmt2 + 'CtlCode = ' + CONVERT(VARCHAR, @Ctl1_Code & 127)
   SET @SQLStmt2 = @SQLStmt2 + ' WHERE Name = ''' +  @name + ''''

   BEGIN TRANSACTION 

   EXEC @SQLStmt)
   SELECT @resultLowCount = @@rowcount,  @ERRORCheck =  @ERROR
   IF  @resultLowCount = 0  GOTO ON_TRN_ERROR
   IF  @ERRORCheck  <> 0 GOTO ON_TRN_ERROR

   EXEC @SQLStmt2)
   SELECT @resultLowCount = @@rowcount,  @ERRORCheck =  @ERROR
   IF  @resultLowCount = 0  GOTO ON_TRN_ERROR
   IF  @ERRORCheck  <> 0 GOTO 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

[MentaL]

[FishnZone]

It doesn't seem like the function you are looking for... more like as character account transfer.
How do you do your reset? by command or website functionally?
The reset function as far as I know only reset your character level to 1, so there is no used function needed by SQL.
That means all you need to do is go to your query that reset your character level and modifies points also.