List top commentators

Top commentators listing blogs always get higher number of comments, and every month i am keeping my readers updated with the best blogs which have the top commentators list. Adding the first block of PHP code to the functions.php of your wordpress theme will let you call the function in the bellow block of code anywhere in your theme to display the top five commentators.

 

 

function top_comment_authors($amount = 5){
global $wpdb;
$results = $wpdb->get_results('
SELECT
COUNT(comment_author_email) AS comments_count, comment_author_email, comment_author, comment_author_url
FROM
'.$wpdb->comments.'
WHERE
comment_author_email != "" AND comment_type = "" AND comment_approved = 1
GROUP BY
comment_author_email
ORDER BY
comments_count DESC, comment_author ASC
LIMIT '.$amount
);
$output = "<ul>";
foreach($results as $result){
$output .= "<li>".$result->comment_author."</li>";
}
$output .= "</ul>";
echo $output;
}


<?
top_comment_authors();
?>

Leave a comment