rveitch
11/11/2015 - 8:14 PM

WP Fast Spam Removal

WP Fast Spam Removal

<?php
/* Fast Spam Removal */
global $wpdb;

$spam_comments_id_arr = $wpdb->get_col( "SELECT comment_id FROM {$wpdb->comments} WHERE comment_approved='spam' OR comment_approved='trash'" ) ;
if ( !empty( $spam_comments_id_arr ) ) {
  $spam_comments_ids = implode( ', ', array_map('intval', $spam_comments_id_arr) );

  $wpdb->query("DELETE FROM {$wpdb->comments} WHERE comment_id IN ( $spam_comments_ids )");
  $wpdb->query("DELETE FROM {$wpdb->commentmeta} WHERE comment_id IN ( $spam_comments_ids )");

  $wpdb->query( "OPTIMIZE TABLE $wpdb->comments" );
  $wpdb->query( "OPTIMIZE TABLE $wpdb->commentmeta" );
}
echo 'complete';