x-MU.net форум

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_PeriodItemInsert]    Script Date: 01/29/2016 12:34:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_PeriodItemInsert]

@userGuid      int,
@CharacterName   varchar(10),
@ItemCode      int,
@OptiOnType      tinyint,
@EffectType1      tinyint,
@EffectType2      tinyint,
@TotalUsePeriod   int,
@ExpireDate      varchar(20)
AS
BEGIN
DECLARE  @ErrorCode int
DECLARE  @periodItemIndex int

SET  @ErrorCode = 0
SET  @periodItemIndex = 0

SET XACT_ABORT ON
SET NOCOUNT ON

BEGIN TRANSACTION

SELECT   @periodItemIndex = PeriodIndex FROM T_PeriodItem_Info WHERE UserGuid =  @userGuid AND CharacterName =  @CharacterName AND OptionType =  @OptiOnType AND UsedInfo = 1

--IF (  @periodItemIndex != 0 )
--BEGIN
--   UPDATE T_PeriodItem_Info SET UsedInfo = 0 WHERE UserGuid =  @userGuid AND CharacterName =  @CharacterName AND OptionType =  @OptiOnType AND UsedInfo = 1
--END

INSERT INTO T_PeriodItem_Info (UserGuid, CharacterName, ItemCode, OptionType, EffectType1, EffectType2, LeftTime, BuyDate, ExpireDate, UsedInfo) VALUES
(  @userGuid,  @CharacterName, @ItemCode,  @OptiOnType,  @EffectType1,  @EffectType2, @TotalUsePeriod, GETDATE(),  @ExpireDate, 1 )
IF(   @ERROR <> 0 )
BEGIN
SET  @ErrorCode = 2
END

IF (  @ErrorCode  <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

SELECT  @ErrorCode

SET NOCOUNT OFF
SET XACT_ABORT OFF
END

USE [MuOnline]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[WZ_PeriodItemInsertEx]
@userGuid         int,
@CharacterName      varchar(10),
@ItemType         tinyint,
@ItemCode         int,
@EffectCategory      tinyint,
@EffectType1      tinyint,
@EffectType2      tinyint,
@serial            bigint,
@Duration         int,
@BuyDate         bigint,
@ExpireDate         bigint
AS
BEGIN
DECLARE  @ErrorCode int
DECLARE  @periodItemIndex int

SET  @ErrorCode = 0
SET  @periodItemIndex = 0

SET XACT_ABORT ON
SET NOCOUNT ON

BEGIN TRANSACTION

SELECT   @periodItemIndex = PeriodIndex FROM PeriodItemEx WHERE UserGuid =  @userGuid AND Name =  @CharacterName AND ItemCode = @ItemCode AND ItemType = @ItemType AND OptionType =  @EffectCategory AND ItemType != 2

IF (  @periodItemIndex != 0 )
BEGIN
DELETE FROM PeriodItemEx WHERE UserGuid =  @userGuid AND Name =  @CharacterName AND ItemCode = @ItemCode AND ItemType = @ItemType AND OptionType =  @EffectCategory
END

INSERT INTO PeriodItemEx (UserGuid, Name, ItemType, ItemCode, EffectType1, EffectType2, OptionType, SerialCode, Duration, BuyDateConvert, ExpireDateConvert) VALUES
(  @userGuid,  @CharacterName, @ItemType, @ItemCode,  @EffectType1,  @EffectType2,  @EffectCategory,  @serial,  @Duration, @BuyDate,  @ExpireDate)
IF(   @@ERROR <> 0 )
BEGIN
SET  @ErrorCode = 2
END

IF (  @ErrorCode  <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

SELECT  @ErrorCode

SET NOCOUNT OFF
SET XACT_ABORT OFF
END