kill-orphaned-wordpress-images.php

<?php

// removes orphaned images
// as in no attachment record.

require __DIR__ . '/wp-load.php';

ob_implicit_flush( true );
set_time_limit( 0 );
/** @var \wpdb */
global $wpdb;

$files = glob( 'wp-content/uploads/*/*/*' );
if ( $files ) {

	foreach ( $files as $file ) {
		if ( is_dir( $file ) ) {
			continue;
		}

		$post_name = $wpdb->esc_like( preg_replace( '@-\d+x\d+[^.]*\.@', '.', $file ) );

		$res = $wpdb->get_results( $q = "select * from $wpdb->posts where (post_name like '%$post_name' or guid like '%$post_name') AND post_type = 'attachment'" );

		if ( ! $res ) {
			echo 'Unlinking ', $file, '<br>', PHP_EOL;
			unlink( $file );
		}
	}
}