Show Top Commenters On WordPress Blog
/** | |
* Show Top Commenters On WordPress Blog By http://goo.gl/ht6fZo | |
*/ | |
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 = " | |
"; foreach($results as $result) { $output .= " | |
".$result->comment_author." | |
"; } $output .= " | |
"; echo $output; } | |
Now Add the below code anywhere you want to show the top commenters list. | |
<?php top_comment_authors(); ?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment