--GoatCheez

CREATE PROCEDURE UPDATE_CHARBAN
@nRet		smallint OUTPUT, 
@CharID		char(21)
AS

DECLARE @BanCount int, @IpAddress char(50), @TodaysDate datetime, @ExistCount tinyint

SET @TodaysDate = CURRENT_TIMESTAMP
SET @BanCount = 0
SET @ExistCount = 0

SELECT @IpAddress = strClientIP FROM CURRENTUSER WHERE strCharID = @CharID

SELECT @ExistCount = COUNT (*) FROM IP_BAN WHERE IP = @IpAddress

IF @ExistCount < 1
BEGIN
	INSERT INTO IP_BAN (IP,BanCount,IPBanCount,LastBanDate) VALUES (@IpAddress, 0, 0, @TodaysDate)
END
ELSE	
BEGIN
	SELECT @BanCount = BanCount FROM IP_BAN WHERE IP = @IpAddress
	SET @BanCount = @BanCount + 1
	UPDATE IP_BAN SET BanCount = @BanCount, LastBanDate = @TodaysDate WHERE IP = @IpAddress
END

IF @@ERROR <> 0
BEGIN	 
	ROLLBACK TRAN 
	SET @nRet =  1
	RETURN
END

COMMIT TRAN
SET @nRet =  0
GO