Personal Finance Advice

[...] I implemented the Top Commenters plugin, although I had to make a few changes to it to make sure that it worked the way that I want it to. It will not show anybody who hasn’t posted at least twice, and it will not show trackbacks. That way, the list will stay a bit more relevant. If you provide a website address, then you will get a link to it from my sidebar if you appear on the list. Let me know if you notice anything acting funny. Related Posts:No related posts [...]

How I added my features…
I added into the ns_options array:

“minimum_posts” => 2, //Make this 1 for all commenters, or higher to require more posts first

My $commenters result set is gotten through htis SQL query:

SELECT COUNT(comment_author) AS comment_comments, comment_author
FROM $wpdb->comments
WHERE $reset_sql
AND comment_author NOT IN($ns_options[filter_users])
AND comment_author != ”
AND comment_type != ‘pingback’
GROUP BY comment_author
HAVING COUNT(comment_author) >= $ns_options[minimum_posts]
ORDER BY comment_comments DESC LIMIT $ns_options[limit]

Plugin updated to 1.01 (see change log).

Thanks for the mention and the additional info Blaine.

Neat plugin.

I added some indexes to WordPress to make the plugin run faster. In SQL:
ALTER TABLE `wp_comments` ADD INDEX (comment_author(32));
ALTER TABLE `wp_comments` ADD INDEX (comment_type);