WordPress 1.5 Plugin – Top Comment List

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

...

[Continue Reading at SavingAdvice.com]

This entry was posted in Website. Bookmark the permalink.

4 Responses to WordPress 1.5 Plugin – Top Comment List

  1. Pingback: Run to Win » Top Commenters

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

  3. Nate says:

    Plugin updated to 1.01 (see change log).

    Thanks for the mention and the additional info Blaine.

  4. Bryan says:

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

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>