<?php

// Clear the Akismet logs hourly
function custom_akismet_schedule_hourly_cron() {

	// Use wp_next_scheduled to check if the event is already scheduled
	$timestamp = wp_next_scheduled( 'custom_akismet_hourly_cron' );

	//If $timestamp == false schedule daily backups since it hasn't been done previously
	if( $timestamp == false ){
		//Schedule the event for right now, then to repeat daily using the hook 'wi_create_daily_backup'
		wp_schedule_event( time(), 'hourly', 'custom_akismet_hourly_cron' );
	}

	add_action( 'custom_akismet_hourly_cron', 'custom_akismet_delete_comments_now' );

}
add_action( 'init', 'custom_akismet_schedule_hourly_cron' );

function custom_akismet_submit_spam_comment( $comment_ID = 0, $reason ) {

	if( $comment_ID ) {
		wp_delete_comment( $comment_ID, true );
	}

}
add_action( 'akismet_submit_spam_comment', 'custom_akismet_submit_spam_comment', 10, 2 );

function custom_akismet_delete_comment_interval( $interval = 15 ) {

	$interval = 1;
	return $interval;

}
add_filter( 'akismet_delete_comment_interval', 'custom_akismet_delete_comment_interval' );
add_filter( 'akismet_delete_commentmeta_interval', 'custom_akismet_delete_comment_interval' );

function custom_akismet_delete_comments_now() {

	global $wpdb;

	$delete_limit = apply_filters( 'akismet_delete_comment_limit', defined( 'AKISMET_DELETE_LIMIT' ) ? AKISMET_DELETE_LIMIT : 10000 );
	$delete_limit = max( 1, intval( $delete_limit ) );

	$delete_interval = apply_filters( 'akismet_delete_comment_interval', 15 );
	$delete_interval = max( 1, intval( $delete_interval ) );

	while ( $comment_ids = $wpdb->get_col( $wpdb->prepare( "SELECT comment_id FROM {$wpdb->comments} WHERE DATE_SUB(NOW(), INTERVAL %d HOUR) > comment_date_gmt AND comment_approved = 'spam' LIMIT %d", $delete_interval, $delete_limit ) ) ) {
		if ( empty( $comment_ids ) )
			return;

		$wpdb->queries = array();

		foreach ( $comment_ids as $comment_id ) {
			do_action( 'delete_comment', $comment_id );
		}

		$comma_comment_ids = implode( ', ', array_map('intval', $comment_ids) );

		$wpdb->query("DELETE FROM {$wpdb->comments} WHERE comment_id IN ( $comma_comment_ids )");
		$wpdb->query("DELETE FROM {$wpdb->commentmeta} WHERE comment_id IN ( $comma_comment_ids )");

		clean_comment_cache( $comment_ids );
	}

	if ( apply_filters( 'akismet_optimize_table', ( mt_rand(1, 5000) == 11), $wpdb->comments ) ) // lucky number
		$wpdb->query("OPTIMIZE TABLE {$wpdb->comments}");

}

?>