Daily cron script that will delete log entries that are "older" than a given timestamp.

delete-old-mycred-entries

/**
 * Delete Old Entries
 * Uses the daily myCRED cron job "mycred_cron_reset_key" to
 * delete entries that are older than a given time each day
 * @version 1.0
 */
function mycred_pro_delete_old_entries() {

	// The maximum age a log entry can have in seconds
	// Example 3 months
	$max_age   = ( 3 * MONTH_IN_SECONDS );
	$now       = current_time( 'timestamp' );

	// Times are stored as unix timestamps so we just deduct the seconds from now
	$timestamp = $now - $max_age;

	global $wpdb, $mycred;

	// Delete entries that are older than our $timestamp
	$wpdb->query( $wpdb->prepare( "DELETE FROM {$mycred->log_table} WHERE time < %d;", $timestamp ) );

}
add_action( 'mycred_cron_reset_key', 'mycred_pro_delete_old_entries' );