WordPress Comment Moderation Made Easier

    July 27, 2006

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


Add to Del.icio.us | Digg | Yahoo! My Web | Furl

Bookmark WebProNews:

Nathan Weinberg writes the popular InsideGoogle blog, offering the latest news and insights about Google and search engines.

Visit the InsideGoogle blog.