Alberto Carozzo - WordPress: patch anti spam

//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//
// File WP_delSPAM.php
//
// Deletes all SPAM comments from wp262_comments table
//
//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

// Include default settigns and connection to database
include 'common.h'; (una mia personale libreria per definire le costanti $ DB_SERVER, $ DB_USER, $ DB_PASS)

$ SPAM='spam';

$ con = mysql_connect($ DB_SERVER, $ DB_USER, $ DB_PASS);
if (!$ con) {
  echo mysql_error();
  exit;
}
if (!mysql_select_db($ DB_NAME,$ con)) {
  echo mysql_error();
  mysql_close($ con);
  exit;
}

$ query = 'DELETE FROM wp262_comments WHERE comment_approved = $ SPAM';
mysql_query($ query,$ con);
mysql_close($ con);
echo('Fatto');

function wp_new_comment( $ commentdata ) {
  $ commentdata = apply_filters('preprocess_comment', $ commentdata);

  $ commentdata['comment_post_ID'] = (int) $ commentdata['comment_post_ID'];
  $ commentdata['user_ID'] = (int) $ commentdata['user_ID'];

  $ commentdata['comment_author_IP'] = preg_replace( '/[^0-9a-fA-F:., ]/', '',$ _SERVER['REMOTE_ADDR'] );
  $ commentdata['comment_agent'] = $ _SERVER['HTTP_USER_AGENT'];

  $ commentdata['comment_date'] = current_time('mysql');
  $ commentdata['comment_date_gmt'] = current_time('mysql', 1);

  $ commentdata = wp_filter_comment($ commentdata);

  $ commentdata['comment_approved'] = wp_allow_comment($ commentdata);

  /* Inizio Vecchio codice
  $ comment_ID = wp_insert_comment($ commentdata);

  do_action('comment_post', $ comment_ID, $ commentdata['comment_approved']);

  if ( 'spam' !== $ commentdata['comment_approved'] ) { // If it's spam save it silently for later crunching
    if ( '0' == $ commentdata['comment_approved'] )
      wp_notify_moderator($ comment_ID);

      $ post = &get_post($ commentdata['comment_post_ID']); // Don't notify if it's your own comment

  if ( get_option('comments_notify') && $ commentdata['comment_approved'] && $ post->post_author != $ commentdata['user_ID'] )
    wp_notify_postauthor($ comment_ID, $ commentdata['comment_type']);
  }
  Fine Vecchio codice */

  /* Inizio Nuovo Codice */
  if ($ commentdata['comment_approved'] == 'spam'){
    $ comment_ID=-1;
  } else {
    $ comment_ID = wp_insert_comment($ commentdata);
    do_action('comment_post', $ comment_ID, $ commentdata['comment_approved']);
    if ( 'spam' !== $ commentdata['comment_approved'] ) { // If it's spam save it silently for later crunching
      if ( '0' == $ commentdata['comment_approved'] )
        wp_notify_moderator($ comment_ID);
        $ post = &get_post($ commentdata['comment_post_ID']); // Don't notify if it's your own comment
    if ( get_option('comments_notify') && $ commentdata['comment_approved'] && $ post->post_author != $ commentdata['user_ID'] )
      wp_notify_postauthor($ comment_ID, $ commentdata['comment_type']);
    }
  }
  /* Fine Nuovo Codice */

  return $ comment_ID;
}