Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: Reset system MU IGC Season 10 files  (Visto 733 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline bakumu Posteado: April 19, 2019, 10:15:07 AM

  • 0 puntos por ventas
  • *
  • Rank: Principiante
  • Posts: 8
  • Gracias recibida: 2
  • az
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]
Code: [Select]
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




















Offline bakumu #1 Posteado: April 19, 2019, 10:57:12 AM | Modificado: April 19, 2019, 10:58:43 AM by bakumu

  • 0 puntos por ventas
  • *
  • Rank: Principiante
  • Posts: 8
  • Gracias recibida: 2
  • az

Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
6 Replies
1838 Views
Last post May 21, 2017, 01:42:42 PM
by pichuxdd
4 Replies
1715 Views
Last post July 14, 2017, 10:35:34 PM
by Dexign
6 Replies
2295 Views
Last post October 30, 2018, 10:00:39 AM
by Cloud
0 Replies
489 Views
Last post December 21, 2019, 07:31:39 AM
by respo
1 Replies
511 Views
Last post January 11, 2021, 12:45:59 PM
by ccqwe123