Mathieu's log

The plugin “Did you pass Maths?” that I am using to prevent spam had an annoying bug: rejected posts still incremented the comment count. So I have made a little program to update my database with correct number of comments.

Here it is.

<?php

require('www/journal/wp-config.php');

mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
mysql_select_db(DB_NAME);

function get_real_nb_comm($post_id) {
    $sql = "SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = $post_id";
    $query = mysql_query($sql);
    $row = mysql_fetch_row($query);
    return $row[0];
}

function set_nb_comm($post_id, $nb) {
    $sql = "UPDATE wp_posts SET comment_count = $nb WHERE ID = $post_id";
    mysql_query($sql);
}

$sql = 'SELECT ID FROM wp_posts ORDER BY ID';
$query = mysql_query($sql);

while($row = mysql_fetch_row($query)) {
    set_nb_comm($row[0], get_real_nb_comm($row[0]));
}

?>

This entry was posted on Friday, September 8th, 2006 at 9:04 am and is filed under General, In English. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.