mirror of
https://gh.wpcy.net/https://github.com/buddypress/buddypress.git
synced 2026-06-01 06:04:04 +08:00
b267316e92
Backward compatibility with SPL-disabled installations is included. See #6853. git-svn-id: https://buddypress.svn.wordpress.org/trunk@10652 cdf35c40-ae34-48e0-9cc9-0c9da1808c22
53 lines
1.7 KiB
PHP
53 lines
1.7 KiB
PHP
<?php
|
|
/**
|
|
* Akismet support for BuddyPress' Activity Stream.
|
|
*
|
|
* @package BuddyPress
|
|
* @subpackage ActivityAkismet
|
|
* @since 1.6.0
|
|
*/
|
|
|
|
// Exit if accessed directly.
|
|
defined( 'ABSPATH' ) || exit;
|
|
|
|
if ( ! buddypress()->do_autoload ) {
|
|
require dirname( __FILE__ ) . '/classes/class-bp-akismet.php';
|
|
}
|
|
|
|
/**
|
|
* Delete old spam activity meta data.
|
|
*
|
|
* This is done as a clean-up mechanism, as _bp_akismet_submission meta can
|
|
* grow to be quite large.
|
|
*
|
|
* @since 1.6.0
|
|
*
|
|
* @global wpdb $wpdb WordPress database object.
|
|
*/
|
|
function bp_activity_akismet_delete_old_metadata() {
|
|
global $wpdb;
|
|
|
|
$bp = buddypress();
|
|
|
|
/**
|
|
* Filters the threshold for how many days old Akismet metadata needs to be before being automatically deleted.
|
|
*
|
|
* @since 1.6.0
|
|
*
|
|
* @param integer 15 How many days old metadata needs to be.
|
|
*/
|
|
$interval = apply_filters( 'bp_activity_akismet_delete_meta_interval', 15 );
|
|
|
|
// Enforce a minimum of 1 day.
|
|
$interval = max( 1, absint( $interval ) );
|
|
|
|
// _bp_akismet_submission meta values are large, so expire them after $interval days regardless of the activity status
|
|
$sql = $wpdb->prepare( "SELECT a.id FROM {$bp->activity->table_name} a LEFT JOIN {$bp->activity->table_name_meta} m ON a.id = m.activity_id WHERE m.meta_key = %s AND DATE_SUB(%s, INTERVAL {$interval} DAY) > a.date_recorded LIMIT 10000", '_bp_akismet_submission', current_time( 'mysql', 1 ) );
|
|
$activity_ids = $wpdb->get_col( $sql );
|
|
|
|
if ( ! empty( $activity_ids ) ) {
|
|
foreach ( $activity_ids as $activity_id )
|
|
bp_activity_delete_meta( $activity_id, '_bp_akismet_submission' );
|
|
}
|
|
}
|
|
add_action( 'bp_activity_akismet_delete_old_metadata', 'bp_activity_akismet_delete_old_metadata' );
|
