Archive for December, 2006

I've just bought a pretty good ATA-SATA combo USB rack. It's a very convenient solution if you wanna carry your stuff around and need a universal solution for all your HDDs. I thought it'd be useful to compile a list of the racks I know about, so here they are:

• HDIU350PS (I haven't found its manufacturer)
• Conceptronic CHD3SIU
• Sino UAZK-F11
• DataTec DS350PS
• Fantec DB-35US-1

I don't have any experiences with them, so you should read their reviews.

The comment counters of my articles have been messed up. I've noticed this thing several months ago and it's probably related to WordPress updates. I set the counters manually within phpMyAdmin for the first time it happened, but I got pretty pissed off when it already happened later so I decided to fix this mess. I've googled around for the solution and found a pretty good script to solve the problem which was a bit buggy and incomplete, so I fixed it.

Here you are:

<?php

if (!file_exists('../wp-config.php')) {
    die('There doesn\'t seem to be a wp-config.php file. Double check ' .
        'that you updated wp-config-sample.php with the proper database ' .
        'connection information and renamed it to wp-config.php.');
}

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

$posts_table = $table_prefix . 'posts';
$comments_table = $table_prefix . 'comments';

print 'Updating comment counters...<br>';

$query = 'SELECT count(comment_id) AS comment_count, comment_post_id ' .
         "FROM $comments_table GROUP BY comment_post_id";

$comments = $wpdb->get_results($query);

$where = '';
$first = true;

if ($comments) {
    foreach ($comments as $comment) {
        $id = $comment->comment_post_id;
        $count = $comment->comment_count;

        $query = "UPDATE $posts_table SET comment_count = $count WHERE ID = $id";
        $wpdb->query($query);

        if (!$first) {
            $where .= 'AND ';
        }
        $where .= "ID != $id ";
        $first = false;
    }
}
print count($comments) . ' articles has comments.  Their comment ' .
      'counters have been explicitly set.<br>';

$query = "UPDATE $posts_table set comment_count = 0 WHERE $where";
$results = $wpdb->get_results($query);
print count($results) . ' comment counters needed to be zeroed of the ' .
      'articles which doesn\'t have any comments.<br>All done!<br>';

?>

You can fetch it here. Just copy it to your "wp-admin" directory and point your browser to its URL.