Items with Time

[Bacкa]

I would like to know if there is a way to by time in some type items, helmet, weapons etc so that the time expires and the item disappears.

[Spectral#1]

USE [PS_gameData]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create TRIGGER [dbo].[itemdelete]
ON [dbo].[chars]
after update
as
IF (UPDATE(leavedate))
begin

SET NOCOUNT ON;

DECLARE @D INT = (SELECT CharID FROM inserted)


DELETE PS_GameData.dbo.CharItems WHERE CharID = @D AND (ItemID = 0) AND DATEDIFF(DAY, Maketime, GETDATE()) >= 1

END

------------------

deletes the item after 1 day. change 1 to watever number you want. or change the day to minute year month etc. Simple script.

[Bacкa]

Originally Posted by Spectral#1

USE [PS_gameData]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create TRIGGER [dbo].[itemdelete]
ON [dbo].[chars]
after update
as
IF (UPDATE(leavedate))
begin

SET NOCOUNT ON;

DECLARE @D INT = (SELECT CharID FROM inserted)


DELETE PS_GameData.dbo.CharItems WHERE CharID = @D AND (ItemID = 0) AND DATEDIFF(DAY, Maketime, GETDATE()) >= 1

END

------------------

deletes the item after 1 day. change 1 to watever number you want. or change the day to minute year month etc. Simple script.

Tanks.

and if he uses the item and after that he puts in the deposit, the time of the item will count anyway?

[Spectral#1]

The items time counts from its creation no matter where it goes. the script i provided will only delete it from the character though. You must add userstoreditems if you want it to delete from WH. Make it untradable. Or else youll have to add all the other spots too, GH, market, etc.

[Bacкa]

has some items that the script does not remove.
(ItemID = 77001)

[Spectral#1]

then you are writing its ID wrong

[Bacкa]

149	1	77001	5096685863069351936	77	1	0	0	400	227	118	133	228	119	134	00101100040034002570	1	2017-10-29 17:03:10.000	X	False

DELETE PS_GameData.dbo.CharItems WHERE CharID = ChariD AND (ItemID = 77001) AND DATEDIFF(MINUTE, Maketime, GETDATE()) >= 1

[SnickQ]

The problem may it be here

WHERE CharID = ChariD

Your CharID is not declared

[Bacкa]

Originally Posted by SnickQ

The problem may it be here

WHERE CharID = ChariD

Your CharID is not declared

Yes I also noticed this but since it was removing other items I didn't mind moving, (Item ID = 77001) They too are not removing item type 150/120

[SnickQ]

Becouse this part (if have declare):

 WHERE CharID = ChariD AND (ItemID = 77001) AND DATEDIFF(MINUTE, Maketime, GETDATE()) >= 1

Remove every item from your bag with id 77001 and MakeTime "equal&more" - 1 minute.

I do not have access to sql now but try add "ItemUID log" when item 77001 is create and then remove from UID or add MakeType some letters like "Z" and then remove 'Z' + 1 minute?

[Spectral#1]

WHERE CharID = @D

[Bacкa]

I can, but items like fantasy and pets are not deleting