query('OPTIMIZE TABLE '.\Podlove\Model\DownloadIntent::table_name());
// clear caches
\Podlove\Cache\TemplateCache::get_instance()->setup_purge();
// mark migration as done
delete_option('podlove_tracking_delete_head_requests');
}
\Podlove\AJAX\Ajax::respond_with_json(['todo' => $todo]);
};
// get user agent IDs to delete
$sql = '
SELECT
id
FROM
'.\Podlove\Model\UserAgent::table_name().' ua
WHERE
user_agent LIKE "libwww-perl/%"
OR user_agent LIKE "curl/%"
OR user_agent LIKE "PritTorrent/%"
';
$user_agent_ids = $wpdb->get_col($sql);
if (!count($user_agent_ids)) {
$send_response(0);
}
// delete
$sql = '
DELETE
FROM '.\Podlove\Model\DownloadIntent::table_name().'
WHERE user_agent_id IN ('.implode(',', $user_agent_ids).')
LIMIT 25000
';
$wpdb->query($sql);
$sql = '
DELETE
FROM '.\Podlove\Model\DownloadIntentClean::table_name().'
WHERE user_agent_id IN ('.implode(',', $user_agent_ids).')
LIMIT 25000
';
$wpdb->query($sql);
// see how much is left to delete
$sql = '
SELECT
COUNT(*)
FROM
'.\Podlove\Model\DownloadIntent::table_name().'
WHERE
user_agent_id IN ('.implode(',', $user_agent_ids).')
';
$send_response($wpdb->get_var($sql));
}
public static function show_admin_notice()
{
?>