[SOLVED] Ban IPs

[steviez]

Hi,

 

I am trying to ban IP addresses on my site by putting all the banned IPs in to a database, When more than one IP is in the databae it wont work. Here is my code so far:

 

<?php
$bans = sql_row("SELECT * FROM bans");
if($bans['ip'] == $_SERVER['REMOTE_ADDR']){
$banned = true;
}

$smarty->assign("your_banned",$lang['banned']);
$smarty->assign("banned",$banned);
$smarty->assign("banned_ip",$banned_ip);
?>

 

Thanks in advance

[rajivgonsalves]

your code should be something like the following

 

<?php

$bans = sql_row("SELECT * FROM bans where ip='{$_SERVER['REMOTE_ADDR']}'");

if($bans['ip']){

$banned = true;

}

 

$smarty->assign("your_banned",$lang['banned']);

$smarty->assign("banned",$banned);

$smarty->assign("banned_ip",$banned_ip);

?>

[steviez]

Perfect, Thanks