SET @ip_address = '78.31.67.68'; -- Enter the IP address you want to check... |
1 year ago |
SET @ip_address = '78.31.67.68'; -- Enter the IP address you want to check... |
1 year ago |
SET @ip_address = '78.31.67.68'; -- Enter the IP address you want to check... |
1 year ago |
SET @ip_address = '78.31.67.68'; -- Enter the IP address you want to check... |
1 year ago |
SET @ip_address = '78.31.67.68'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '207.204.252.59'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '161.45.254.242'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '161.45.254.242'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '161.45.254.242'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '1.136.109.244'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '1.136.109.244'; /*Enter the IP address you want to check... |
2 years ago |
SET @ip_address = '1.136.109.244';
select case when count(*) > 0 then 'is... |
2 years ago |
SET @ip_address = '161.45.254.242';
select case when count(*) > 0 then 'is... |
2 years ago |
SET @var = 'Testing';
select case when count(*) > 0 then @var else 'not... |
2 years ago |
SET @var = 0;
select case when count(*) > 0 then @var else 'not blocked'... |
2 years ago |
select case when count(*) > 0 then 'is blocked' else 'not blocked' end
from... |
2 years ago |
DECLARE @TestVariable AS VARCHAR(100)
SET @TestVariable = 'One Planet One... |
2 years ago |
select case when count(*) > 0 then true else false end
from ipblocks
where... |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and ipb_address =... |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and... |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and ipb_address =... |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and ipb_address =... |
2 years ago |
select *, HEX(INET6_ATON(ipb_address))
from ipblocks
where ipb_user = 0
and... |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and ipb_address =... |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and ipb_address =... |
2 years ago |
select HEX(INET6_ATON('161.45.0.0')); |
2 years ago |
select HEX(INET6_ATON('161.45.0.0/16')); |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and ipb_address =... |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and ipb_address = '161.45.254.242'; |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and ipb_address = '1.136.109.244'; |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and ipb_address = '161.45.254.242'; |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then 'true' else 'false' end
from... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when count(*) = 1 then true else false end
from ipblocks
where... |
2 years ago |
select case when ipb_timestamp is null then false else true end
from... |
2 years ago |
select case when ipb_timestamp is null or ipb_timestamp = 0 then false else... |
2 years ago |
select case when ipb_timestamp is null then false else true end
from... |
2 years ago |
select case when ipb_timestamp is null then false else true end
from... |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and ipb_address = '203.94.130.78'; |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and ipb_address = '121.208.212.82'; |
2 years ago |
select case when 'No data available in table' then false else true end
from... |
2 years ago |
select case when null then false else true end
from ipblocks
where ipb_user... |
2 years ago |
select *
from ipblocks
where ipb_user = 0
and ipb_address = '121.208.212.82'; |
2 years ago |