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]

accountID varchar(10),
[Only registered and activated users can see links]
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON

[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

SET LOCK_TIMEOUT 1000
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]

[Only registered and activated users can see links]

[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
GOTO ON_ERROR
END

[Only registered and activated users can see links]

[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
GOTO ON_ERROR
END

[Only registered and activated users can see links]
FROM dbo.AccountCharacter WHERE Id = accountID

[Only registered and activated users can see links]

[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
GOTO ON_ERROR
END

[Only registered and activated users can see links]

[Only registered and activated users can see links]

[Only registered and activated users can see links]

[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
ELSE
[Only registered and activated users can see links]

[Only registered and activated users can see links]
GOTO ON_ERROR

[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

BEGIN TRANSACTION

[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]

[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]


ON_TRN_ERROR:
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]

ROLLBACK TRAN
END
ELSE
COMMIT TRAN

ON_ERROR:
[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
END

[Only registered and activated users can see links]

SET NOCOUNT OFF
SET XACT_ABORT OFF
END