[HowTo] Enabling Timebans on servers

Hey
F�r mich hat der timeban nie funktioniert, also hab ich ein kleinen code gemacht der mir die user aus dem TUSERPROTECTED rausl�scht, wo die durantion �berschritten wurde. Eintr�ge ohne durantion(NULL) werden ignoriert.

Einfach in die tlogin funktion in tglobal das nach "SET @dwPremiumID = 0 " das einf�gen:

Code:

DELETE FROM [TUSERPROTECTED] WHERE Not DATEADD(day,dwDuration,startTime) > GETDATE() and not dwDuration is NULL

Viel spass
Mfg

---english
Hey
Cause the timaban function never worked for me, i have a little snippet of code for you:

Code:

DELETE FROM [TUSERPROTECTED] WHERE Not DATEADD(day,dwDuration,startTime) > GETDATE() and not dwDuration is NULL

Just paste it after the last Set in the first block ("SET @dwPremiumID = 0 " ) and it deletes all bans where the dwduration is not NULL
Have fun

Good, this is my timeban code ;)

Code:

SELECT TOP 1 @startTime = startTime, @dwDuration = dwDuration, @bEternal = bEternal 
	FROM TUSERPROTECTED 
	WHERE dwUserID = @dwUserID 
	AND DATEADD( DAY, dwDuration, startTime) >= GETDATE()

	SELECT dwUserID FROM TUSERPROTECTED  WHERE dwUserID = @dwUserID  AND DATEADD( DAY, dwDuration, startTime) >= GETDATE()
	IF (@@ROWCOUNT > 0)
	BEGIN
		RETURN 7
	END

	
/*BAN IP OR BAN ETERNAL*/
	SELECT dwUserID FROM TUSERPROTECTED  WHERE @szLoginIP = IP AND DATEADD( DAY, dwDuration, startTime) >= GETDATE()
	IF (@@ROWCOUNT > 0)
	BEGIN
		RETURN 7
	END

	SELECT dwUserID FROM TUSERPROTECTED 	WHERE dwUserID = @dwUserID AND	dwDuration = 0	
	IF (@@ROWCOUNT > 0)
	BEGIN
		RETURN 7
	END

	SELECT dwUserID FROM TUSERPROTECTED 	WHERE @szLoginIP = IP AND dwDuration = 0	
	IF (@@ROWCOUNT > 0)
	BEGIN
		RETURN 7
	END
/*BAN IP AND BAN ETERNAL*/

	SELECT TOP 1 @startTime = startTime, @dwDuration = dwDuration, @bEternal = bEternal 
	FROM TUSERPROTECTED 
	WHERE dwUserID = @dwUserID 
	AND DATEADD( DAY, dwDuration, startTime) >= GETDATE()

	SELECT dwUserID FROM TUSERPROTECTED  WHERE dwUserID = @dwUserID  AND DATEADD( DAY, dwDuration, startTime) >= GETDATE()
	IF @@ROWCOUNT > 0
	BEGIN
		RETURN 7
	END

	SELECT dwUserID FROM TUSERPROTECTED  WHERE @szLoginIP = IP  AND DATEADD( DAY, dwDuration, startTime) >= GETDATE()
	IF @@ROWCOUNT > 0
	BEGIN
		RETURN 7
	END