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]
@[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