Wordpress 1.5 Plugin – Top Comment List

Posted by pfadvice
December 3, 2005

We now have the wordpress plugin available to add to your site if you’d like to encourage your visitors to leave comments to your posts: Show top Commentators WordPress Plugin. The plugin places a list of the people who leave the most comments on your website into your sidebar. Some of the features:

Reset Period: You can choose how often you want the list to reset. If you choose monthly, only comments from the current month will be counted towards a visitors comment count or if you choose weekly, only the comments for that week will be counted.

List Number: You can determine the number of names you want to appear on your list.

Name Filter: You can filter out any names you don’t want to appear on the list such as your own.

URL Filter: You can filter out any website URLs that you don’t want to appear on the list.

Link Option: You can choose to have the names on the list link to the person’s website or not.

Feel free to give it a try and spread the word to others that use wordpress. If you decide to use it or have any questions about it, feel free to Email Us. Enjoy!

Information and Links

Join the fray by commenting, tracking what others have to say, or linking to it from your blog.

Information: December 3rd, 2005; 4 Responses

Feeds and Links: Blog Feed; Comment Feed; Del.icio.us; Digg; Technorati

Categories: Website

Similar Posts: New Site Additions; Articles Wanted: Get Paid to Promote Your Blog; Lots of Link Love; ch-ch-ch-changes; Better Way To Convert ING Referrals; My Money Forest Interview; Do You Have A Reward Debit Card?; Clean Your Air Conditioner Filter – Daily Financial Challenge; BlackListed!; Bribing Your Way To A Better Page Rank

Reader Comments

Comment Number:: 1
Written by:: Run to Win » Top Commenters
Posted on:: December 3, 2005 at 12:10 pm

[...] 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 [...]

Comment Number:: 2
Written by:: Blaine Moore (Run to Win)
Posted on:: December 3, 2005 at 12:16 pm

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]

Comment Number:: 3
Written by:: Nate
Posted on:: December 4, 2005 at 2:12 am

Plugin updated to 1.01 (see change log).

Thanks for the mention and the additional info Blaine.

Comment Number:: 4
Written by:: Bryan
Posted on:: April 4, 2007 at 3:44 pm

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);