Thanks 
Where I can find banned IP list?
Where I can find banned IP list?
You can find it in your webserver's logs (error code 403), or you can use code such as:
Code:
$ra = getIP();
$fname = $_SERVER['SERVER_NAME'];
$sql = "INSERT INTO log_faucets (ip, fname)
VALUES
('$ra', '$fname')";
mysql_query($sql, $link);
$fname = $_SERVER['SERVER_NAME'];
$sql = "INSERT INTO log_faucets (ip, fname)
VALUES
('$ra', '$fname')";
mysql_query($sql, $link);
in IF statement (when cheked, is user legal, listing posted in first post), and logs with banned IPs will be accumulated in database table 'log_faucets'. Sure, you must create this table before:
Code:
CREATE TABLE IF NOT EXISTS `log_faucets` (
`ip` varchar(50) NOT NULL,
`fname` varchar(100) NOT NULL,
`DT` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
`ip` varchar(50) NOT NULL,
`fname` varchar(100) NOT NULL,
`DT` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Where 'ip' - banned ip
'fname' - faucet's name (if you use some faucets)
'DT' - datetime of impression
And later you can use this list in .htaccess or check IP in future impressions for preventive ban.