Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I'm using the following code in my function.php to display the top commenters in my theme:

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>".get_avatar($result->comment_author_email, 30).' <p>'.(($result->comment_author_url) ? "<a href='".$result->comment_author_url."'>" : "").$result->comment_author.(($result->comment_author_url) ? "</a>" : "")." (".$result->comments_count.")</p></li>";
}
$output .= "</ul>";

echo $output;

}

It works fine, but I'd like to exclude myself, aka the admin/author. Is this possible at all? If so, how would I do that? In what way would I have to modify the code above?

Thanks a lot in advance! :)

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

Extend the WHERE clause:

WHERE
    comment_author_email != "" 
    AND comment_author_email != "YOUR_MAIL_ADDRESS" 
    AND comment_type = "" 
    AND comment_approved = 1
share|improve this answer
    
Perfect! Thank you so much! –  japanworm Nov 20 '11 at 13:58
add comment

comment_author_email is fine but as far as I'm concerned I prefer using user id :

AND user_id!="1" 

It should do the job !

share|improve this answer
1  
User ID 1 is not necessary an admin; it doesn't even have to exist. –  toscho Apr 12 '13 at 11:18
    
you're right :/ –  JMau Apr 19 '13 at 20:01
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.