CREATE TABLE IPBAN([Account] [varchar](21) NULL, [IP] [char](15) NULL)

CREATE PROCEDURE IP_BAN
-- L0pht 23.03.2010 --
@Character char(21)
as
declare @L0pht varchar(21)
declare @ip varchar(50)
delete from IPBAN where Account = @L0pht
select @L0pht = strAccountID from ACCOUNT_CHAR where strcharid1 = @Character or strcharid2 = @Character or strcharid3 = @Character
select @ip = ip from tb_user where strAccountID = @L0pht
INSERT INTO IPBAN ( account, ip ) Values ( @L0pht,@ip )
update tb_user set strAuthority='255' where strAccountID = @L0pht
GO

--IP Ban - L0pht

update TB_USER set IP = 0 where IP = Null
declare @L0pht char(15)
declare @L0pht2 char(15)
declare @L0pht3 char(15)

select @L0pht= ip from tb_user where strAccountID = @AccountID
select @L0pht2= ip from IPBAN where Account = @AccountID
select @L0pht3= strauthority from tb_user where strAccountID = @AccountID
if (@L0pht = @L0pht2 or @L0pht3 = '255')
begin
Set @nRet = 4
RETURN
end

--IP Ban - L0pht

exec IP_BAN 'Karakter Adı'