--GoatCheez
CREATE PROCEDURE UPDATE_CHARBAN
@nRet		smallint OUTPUT, 
@CharID		char(21),
AS
DECLARE @BanCount int, @IpAddress char(50), @TodaysDate date
SET @TodaysDate = CURRENT_TIMESTAMP
SET @BanCount = 0
SELECT @IpAddress=strClientIP FROM CURRENTUSER WHERE strCharID=@CharID
SELECT @BanCount=



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


COMMIT TRAN
SET @nRet =  0
GO