[HELP] Check_Pet_Timer

[Bacкa]

Can someone explain to me how this query works.

ALTER Proc [dbo].[usp_Check_Pet_Timer]

@D int

AS

SET NOCOUNT ON

DECLARE @Time datetime
DECLARE @ID int
DECLARE @ int
DECLARE @t int
DECLARE @ smallint
DECLARE @UID bigint

SELECT @ID=UserUID FROM PS_GameData.dbo.Chars WHERE CharID @D

IF EXISTS(SELECT ItemUID FROM PS_GameData.dbo.CharItems WHERE [Type] IN (120,150) AND CharID @D)
BEGIN
SELECT * INTO #TempTable FROM PS_GameData.dbo.CharItems WHERE ([Type]=120 or [Type]=150) AND CharID @D
SET @ =(SELECT COUNT(ItemUID) FROM #TempTable)
SET @t = 1
WHILE @ @t)
BEGIN
SET @UID =(SELECT TOP 1 ItemUID FROM #TempTable)
SET @ = (SELECT [Range] FROM PS_GameDefs.dbo.Items WHERE ItemID=(SELECT ItemID FROM #TempTable WHERE ItemUID @UID))
SET @Time = (SELECT Maketime FROM #TempTable WHERE ItemUID @UID)
IF(GETDATE() > DATEADD(DD, @ @Time) AND @ > 0)
BEGIN
DELETE FROM PS_GameData.dbo.CharItems WHERE CharID @D AND ([Type]=120 or [Type]=150) AND ItemUID @UID
END
DELETE FROM #TempTable WHERE ItemUID @UID
SET @t @t+1
END
END

IF EXISTS(SELECT ItemUID FROM PS_GameData.dbo.UserStoredItems WHERE [Type] IN (120,150) AND UserUID @ID)
BEGIN
SELECT * INTO #TempTableWH FROM PS_GameData.dbo.UserStoredItems WHERE ([Type]=120 or [Type]=150) AND UserUID @ID
SET @=(SELECT COUNT(ItemUID) FROM #TempTableWH)
SET @t=1
WHILE @ @t)
BEGIN
SET @UID=(SELECT TOP 1 ItemUID FROM #TempTableWH)
SET @= (SELECT [Range] FROM PS_GameDefs.dbo.Items WHERE ItemID=(SELECT ItemID FROM #TempTableWH WHERE ItemUID @UID))
SET @Time= (SELECT Maketime FROM #TempTableWH WHERE ItemUID @UID)
IF(GETDATE() > DATEADD(DD, @ @Time) AND @ > 0)
BEGIN
DELETE FROM PS_GameData.dbo.UserStoredItems WHERE ([Type]=120 or [Type]=150) AND UserUID @ID AND ItemUID @UID
END
DELETE FROM #TempTableWH WHERE ItemUID @UID
SET @t @t+1
END
END
SET NOCOUNT OFF

I'm using. The count of days works, however the item is not deleted.

[[ADMIN]Phreak]

Originally Posted by Bacкa

DECLARE [MENTION=429056]create[/MENTION]Time datetime
DECLARE [MENTION=2805776]UserU[/MENTION]ID int	
DECLARE [MENTION=4041608]LCN[/MENTION]t int
DECLARE [MENTION=1496863]Timer[/MENTION] smallint
DECLARE [MENTION=1134588]item[/MENTION]UID bigint

Please take some time and clear the code from the Mention part. It's kinda annoying and people won't be able to help you as much.

[Bacкa]

Originally Posted by [ADMIN]Phreak

Please take some time and clear the code from the Mention part. It's kinda annoying and people won't be able to help you as much.

Ready!

[[DEV]Wan]

Originally Posted by [ADMIN]Phreak

Please take some time and clear the code from the Mention part. It's kinda annoying and people won't be able to help you as much.

Dude you need to respect post of people wtf

[[ADMIN]Phreak]

Originally Posted by [DEV]Wan

Dude you need to respect post of people wtf

Get lost man..

[Bacкa]

anyone who can help?

[Fixed33]

No one has helped?