automatically delete spam comments in wordpress

automatically delete spam comments in wordpress

WordPress Spam comments is big issue. I am getting daily 5k spam comments daily. we automated task of  deleting spam comments automatically. Daily going to comments dashboard and deleting spam comments is really boring task. WordPress Akismat wordpress plugin does good job of finding spam comments.

automatically delete spam comments in wordpress
automatically delete spam comments in wordpress

 

How to automatically delete spam comments in wordpress?

I am using Akismat wordpress plugin for my all wordpress blogs. It does good job of finding spam comments. Due to spam comments. comment-meta table becoming big and causing mysql resource issues. So cleaning comments table became necessary. so we used following hook in wordpress theme code.

view source
print?
01function auto_delete_spam_comments() {
02$in_progress = (bool) get_site_option( 'spamcomment_delete_in_progress' );
03if ( ! $in_progress ) {
04global $wpdb;
05update_site_option( 'spamcomment_delete_in_progress', '1' );
06// 4980
07$next = (int) get_site_option( 'spamcomments_delete_next_blog' );
08if ( empty( $next ) ) {
09$next = 1;
10}
11 
12if ( $next > 3000 ) {
13return;
14}
15switch_to_blog( $next );
16 
17$spams = $wpdb->get_col( "SELECT comment_id FROM {$wpdb->comments} WHERE comment_approved = 'spam' LIMIT 10" );
18if ( empty( $spams ) ) {
19$next++;
20update_site_option( 'spamcomments_delete_next_blog', $next );
21} else {
22foreach ( $spams as $spam ) {
23wp_delete_comment( $spam, true );
24$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->commentmeta} WHERE comment_id = %d", $spam ) );
25}
26}
27// reclaim disk space
28$wpdb->query( "OPTIMIZE TABLE {$wpdb->comments}" );
29$wpdb->query( "OPTIMIZE TABLE {$wpdb->commentmeta}" );
30restore_current_blog();
31delete_site_option( 'spamcomment_delete_in_progress' );
32}
33}
34register_shutdown_function( 'auto_delete_spam_comments' );

Notes:
The number of blogs is hardcoded (3000)
Add above code in functions.php file.

If you want WordPress to automatically empty my spam comments after 1 day. Just add this to wp-config.php. Following code will automatically Empty Your WordPress Trash

view source
print?
1/**
2 * Delete Spam Comments.
3 */
4define( 'EMPTY_TRASH_DAYS', 1 );

To disable trash set the number of days to zero. Note that WordPress will not ask for confirmation when someone clicks on “Delete Permanently”.

view source
print?
1define( 'EMPTY_TRASH_DAYS', 0 ); // Zero days

If you want more information Automatically empty wordpress Trash comments and posts and How to make empty wordpress trash automatically

Published by

Purab

I am Purab from India, Software development is my profession and teaching is my passion. Programmers blog dedicated to the JAVA, Python, PHP, DevOps and Opensource Frameworks. Purab's Github Repo Youtube Chanel Video Tutorials Connect to on LinkedIn

Leave a Reply

Your email address will not be published.