[HowTo] Enabling Timebans on servers

[AllCowsAreBurgers]

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:

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:

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

[julianjl]

Good, this is my timeban 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