如何清理WordPress未使用图片和全自动入库操作

<?php // WordPress 图片清理
require('./wp-load.php');
 
global $wpdb;
 
// 指定年月
$year = "2024/09"; // 修改为你想要的年份/月份
 
// 获取上传目录
$upload_dir = wp_upload_dir();
$year_dir = $upload_dir['basedir'] . '/' . $year;
 
// 检查目录是否存在
if (is_dir($year_dir)) {
    $urls = [];
    $images = glob($year_dir . '/*.{jpg,jpeg,png,gif}', GLOB_BRACE);// 获取目的所有图片
    foreach ($images as $image_path) {
        $file_url = str_replace($upload_dir['basedir'] , $upload_dir['baseurl'], $image_path);
        $exists = $wpdb->get_var( $wpdb->prepare("SELECT EXISTS(SELECT 1 FROM {$wpdb->posts} WHERE guid = %s AND post_type = 'attachment')", $file_url) );
        if ($exists == 0) {// 未入库的图片
            $urls[] = $file_url;
        }
    }
    //print_r($urls);
    if(!empty($urls)){
        $dels = [];
        foreach ($urls as $url) {
            $path = str_replace($upload_dir['baseurl'] , $upload_dir['basedir'], $url);
            $ID = $wpdb->get_var( $wpdb->prepare("SELECT ID FROM {$wpdb->posts} WHERE post_content LIKE %s AND post_type = 'post'", '%'.$wpdb->esc_like($url).'%') );
            if ($ID) {// 被使用的图片重新入库
                // 获取文件名和文件类型
                $filename = basename($path);
                $filetype = wp_check_filetype($filename, null);
                // 插入到 posts 表
                $attachment = array(
                	'guid'           => $url, 
                	'post_mime_type' => $filetype['type'],
                	'post_title'     => str_replace('-', ' ', preg_replace( '/(-d+)?.[^.]+$/', '', basename( $filename ) )),
                	'post_content'   => '',
                	'post_status'    => 'inherit',
                	'post_type'      => 'attachment',
                );
                $media_id = wp_insert_attachment($attachment, $path, $ID);
                update_attached_file( $media_id, str_replace($upload_dir['baseurl'].'/','',$url) );
                // 生成附件的元数据
                require_once(ABSPATH . 'wp-admin/includes/image.php');
                $file_path = get_attached_file($media_id);
                wp_generate_attachment_metadata( $media_id, $file_path );
                echo "成功导入图片：$media_id / $urln";
            }else{//删除未使用的图片
                $dels[] = $url;
                @unlink($path);
            }
        }
        echo "nn";
        print_r($dels);
    }
} else {
    echo "目录不存在：{$year_dir}";
}