On Fri, 5 Oct 2001 14:12:46 -0400, Prottoss wrote:
>What would be the most effective way to create blocking of users by
>ip using
>mysql. In such as way that the "blocking system" allows for masks
>such as
>24.127.89.*
>24.*.*.*
>etc...
>
>So far the what I've come up with is either breaking the i
Interesting. After hlaf a minute an idea came to my brain.
create table blocked( from_ip bigint unsigned, to_ip bigint unsigned);
=from_ip and $REMOTE_ADDR<=to_ip;"));
?>
Hope this helps.
$REMOTE_ADDR have to be integer => use ip2long().
For single IP the ints in the row are equivalent. from_ip
What would be the most effective way to create blocking of users by ip using
mysql. In such as way that the "blocking system" allows for masks such as
24.127.89.*
24.*.*.*
etc...
So far the what I've come up with is either breaking the ip into 4 INTs and
then running an SQL query to check if t
3 matches
Mail list logo