/*create table (phpmyadmin or mysql), key is necessary for the 4.1.x syntax
CREATE TABLE `spam_ips` (
`ip` TINYTEXT NOT NULL ,
`count` INT NOT NULL ,
PRIMARY KEY ( ip( 15 ) )
) TYPE = MYISAM
ALTER TABLE `spam_ips` ADD `banned` TINYINT( 1 ) ;
*/
$spam_user="db_user";
$spam_pass="db_pass";
$spam_host="localhost";
$spam_db="db_name";
$spam_table="spam_ips";
$htaccess_file='/home/your_userdir/public_html/blog/.htaccess';
if (strpos($REQUEST_URI,'disp=stats')) {
//log their IPs
$link = mysql_connect($spam_host,$spam_user,$spam_pass)
or die("Keine Verbindung möglich: " . mysql_error('cn'));
mysql_select_db($spam_db) or die('db');
/* ausführen einer SQL Anfrage */
/* With mysql >= 4.1.0 you can insert ... ON DUPLICATE KEY update
If you specify the ON DUPLICATE KEY update clause (new in mysql 4.1.0), and a row is inserted that would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an update of the old row is performed.
*/
//these are the basic queries, if you use mysql v.4.1.x you should simply use teh first query instead of the if-else construct
$mysql4_1_x_query="INSERT INTO `".$spam_table."` (ip,count) VALUES ('".$_SERVER['REMOTE_ADDR']."',1)
ON DUPLICATE KEY UPDATE count=count+1";
$selquery="SELECT `ip`, `count` FROM `".$spam_table."` WHERE `ip` = '".$_SERVER['REMOTE_ADDR']."'";
$insquery = "INSERT INTO `".$spam_table."` SET `ip` = '".$_SERVER['REMOTE_ADDR']."', `count` = 1";
$updquery = "UPDATE `".$spam_table."` SET count=count+1 WHERE ip='".$_SERVER['REMOTE_ADDR']."';";
$result = mysql_query($selquery) or die('qr');
// here is the code to update .htaccess
$line = mysql_fetch_array($result, MYSQL_ASSOC);
//var_dump($line);
if ($line['banned']==NULL && $line['count']>2){
if (is_writable($htaccess_file)){//echo 'banned';
$filehnd=fopen ($htaccess_file,'a');
fwrite($filehnd,'Deny from '.$line['ip']."\n");
fclose($filehnd);
$updquery = "UPDATE `".$spam_table."` SET banned=1 WHERE ip='".$_SERVER['REMOTE_ADDR']."';";
mysql_query($updquery) or die('qru');
}
else{echo 'file not writeable ';}
}
if (mysql_num_rows($result)>0){
$result = mysql_query($updquery) or die('qru');
}
else{
$result = mysql_query($insquery) or die('qri');
}
//mysql_free_result($result);
die ('die, spammers!');
}
// show spamips, if requested via disp=spammers
if (strpos($REQUEST_URI,'disp=spammers')) {
$link = mysql_connect($spam_host,$spam_user,$spam_pass)
or die("no conn");
mysql_select_db($spam_db) or die('oops'.mysql_error());
$selquery="SELECT `ip`, `count`, `banned` FROM `spam_ips` ORDER BY `count` DESC";
$result = mysql_query($selquery) or die('outch');
/* Ausgabe der Ergebnisse in HTML */
echo "<table border=\"1\" width=\"100%\">\n".
'<tr><th>ip</th><th>count</th><th>banned</th></tr>';
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
//var_dump($line);
echo '<tr><td>'.$line['ip'].'</td><td>'.$line['count'].'</td><td>'.$line['banned'].'</td></tr>';
$denystring.='Deny from '.$line['ip'].'<br>';
}
echo '</table>';
echo 'These are the spammers IPs <br>';
echo 'For your .htaccess:<br>'.$denystring;
die ();
}
/**
* First thing: Do the minimal initializations required for b2evo:
*/
Home
Search
Usergroups
Register
Log in
Les perles du chat
New Development Blog Coming Soon...
