[SOLVED] ip banning

[fullyloaded]

hi

i was wondering if anyone can tell me of a place to get a ip banning script that will save the ips to a text file or to the database and also have it so i can add the ip from a text box thanks

[emehrkay]

its not hard to do.

 

just create a table called banned_ips

you need fields for id, ip and date_added

 

create a function that will run on every page load to check that table for the current user's ip

 

function checkIpBan($ip){

$query = "SELECT COUNT(id) AS number FROM banned_ips WHERE ip = '". $ip ."'";

$result = mysql_query($query); //you can add the ordie cluase here if you want

$num = mysql_num_rows($result);

if($num > 0){

header("Location: banned.php");

}

}

 

that should do it for you

[HoTDaWg]

or u can also have a status column in ur mysql database and once u want to block a user itll insert the word, "banned" in the database. That way, if the user goes ona different computer he cant even log in to his account.

[fullyloaded]

cool thanks a lot you guys