WordPress Comment Moderation Made Easier
Do you use WordPress’s standard comment moderation, rather than some fancypants (and probably easier) plugin?
I do, since I’m deathly afraid of missing even one usefull reader tidbit, and sometimes having a page with 10,000 comments can be unwieldly (and crash browsers).
Well, here’s a helpful tip if the comments are just piling up and driving you crazy. Basically, by adding the bolded code to your wp-admin/moderate.php file, you can limit the comment moderation screen to just the most recent n comments, in this case, one hundred at a time. Oh so very useful. My 10,000 comments are now done, and I am a happy blogger once again.
$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE
comment_approved = '0' ORDER BY `comment_date` ASC LIMIT 0 , 100");
Visit the InsideGoogle blog.