well to change duration of item i think run this
Code:
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_PeriodItemSelect] Script Date: 10/31/2010 20:08:35 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
/****** Object: Stored Procedure dbo.WZ_PeriodItemSelect Script Date: 28.11.2008 19:52:26 ******/
ALTER PROCEDURE [dbo].[WZ_PeriodItemSelect]
@memb_guid int, @CharName varchar(10)
AS
BEGIN
BEGIN TRANSACTION
SET NOCOUNT ON
DECLARE @icount int
DECLARE @ExpireDate datetime
DECLARE @ItemCode int
DECLARE @ItemEffect1 int
DECLARE @ItemEffect2 int
DECLARE @iLeftTime int
SET @icount = 0
SET @iLeftTime = 0
SELECT @icount = count(*) FROM T_PeriodItem_Info WHERE memb_guid = @memb_guid AND memb__char = @CharName
IF @icount = 0
BEGIN
SELECT 0
END
ELSE IF @icount <> 1
BEGIN
SELECT -1
END
ELSE
BEGIN
SELECT @ItemCode = ItemCode,@ItemEffect1 = ItemEffect1,@ItemEffect2 = ItemEffect2 @ExpireDate = ExpireDate FROM T_PeriodItem_Info WHERE memb__char = @CharName
SET @iLeftTime = datediff(minute,getdate() @ExpireDate)
IF @iLeftTime > 0
BEGIN
SELECT memb_guid,
ItemCode,
ItemEffect1,
ItemEffect2,
OptionType,
UseTime,
@iLeftTime FROM T_PeriodItem_Info where memb__char = @CharName
END
ELSE
BEGIN
UPDATE T_PeriodItem_Info SET UseTime = 0 WHERE memb__char = @CharName
SELECT -2
END
END
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
END
SET NOCOUNT OFF
UPDATE T_PeriodItem_Info SET UseTime = 0 WHERE memb__char = @CharName
change UseTime = 0 to 10070 seconds and test.
not sure if this is gonna work but we will find a way out.
you can learn more about it :
http://www.karaszi.com/SQLServer/inf...#DtInSqlServer
https://social.msdn.microsoft.com/Fo...um=transactsql
