Purging all spam older than 3 days...";
foreach($all_blogs as $i) {
$table = "wp_" . $i . "_comments";
// Print a header
echo "Blog No. $i
";
// Count how many spams there are (wasteful but fun)
$q1 = "SELECT COUNT(comment_ID) AS allspam FROM $table WHERE comment_date < DATE_SUB(NOW(), INTERVAL 3 DAY) AND comment_approved LIKE 'spam'";
$rsl = query($q1);
$spams = mysql_result($rsl,0,'allspam');
echo "";
echo "- Found $spams spam posts meeting criteria...
";
if(!$spams) {
echo "- No sense in continuing...
";
} else {
// Delete 'em!
echo "- Deleting them...
";
$query = "DELETE FROM $table WHERE comment_date < DATE_SUB(NOW(), INTERVAL 3 DAY) AND comment_approved LIKE 'spam'";
query($query) or die(mysql_error());
// Optimize the table!
echo "- Optimizing table...
";
// I use a custom query, but you could just as easily
// Use the SQL command 'OPTIMIZE TABLE $table' here
optimize($table);
}
echo "
";
}
?>