[HELP] Check_Pet_Timer

09/09/2018 20:57 Bacкa#1
Can someone explain to me how this query works.

ALTER Proc [dbo].[usp_Check_Pet_Timer]

@[Only registered and activated users can see links. Click Here To Register...]D int

AS

SET NOCOUNT ON

DECLARE @[Only registered and activated users can see links. Click Here To Register...]Time datetime
DECLARE @[Only registered and activated users can see links. Click Here To Register...]ID int
DECLARE @[Only registered and activated users can see links. Click Here To Register...] int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]t int
DECLARE @[Only registered and activated users can see links. Click Here To Register...] smallint
DECLARE @[Only registered and activated users can see links. Click Here To Register...]UID bigint

SELECT @[Only registered and activated users can see links. Click Here To Register...]ID=UserUID FROM PS_GameData.dbo.Chars WHERE CharID @[Only registered and activated users can see links. Click Here To Register...]D

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

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

I'm using. The count of days works, however the item is not deleted.
09/10/2018 00:47 [ADMIN]Phreak#2
Quote:
Originally Posted by Bacкa View Post
HTML Code:
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.
09/10/2018 05:14 Bacкa#3
Quote:
Originally Posted by [ADMIN]Phreak View Post
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!
09/11/2018 02:46 [DEV]Wan#4
Quote:
Originally Posted by [ADMIN]Phreak View Post
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
09/11/2018 15:20 [ADMIN]Phreak#5
Quote:
Originally Posted by [DEV]Wan View Post
Dude you need to respect post of people wtf
Get lost man..
09/28/2018 05:10 Bacкa#6
anyone who can help?
11/17/2018 16:23 Fixed33#7
No one has helped?