remove images from wordpress db which no longer exist

remove-wp-db-images.php

<?php

// Only run the code if we are in the admin
if ( is_admin() ) :

class WordPressdeleteMissingImages {

	// Action/Filter Hooks
	function __construct() {
		add_action( 'admin_menu', array( &$this, 'add_page' ) );
		add_action( 'admin_init', array( &$this, 'admin_init' ) );
	}

	function admin_init() {
		if ( array_key_exists( 'delete-missing-images', $_GET ) ) {
			$imgs = get_posts("post_type=attachment&numberposts=-1");

			foreach($imgs as $img){
				$file = get_attached_file($img->ID);

				if(!file_exists($file)){
					wp_delete_post( $img->ID, false );
				}
			}			

			wp_redirect( admin_url() . '?missing-images-deleted' );
			exit();
		}
		else if ( array_key_exists( 'missing-images-deleted', $_GET ) )
			add_action( 'admin_notices', array( &$this, 'ok_notice' ) );
	}

	// admin_notices action hook operations
	// Inform the user that the dirty work is done
	function ok_notice() {
		echo '<div id="message" class="updated fade"><p><strong>Missing Images deleted.</strong></p></div>';
	}

	// admin_menu action hook operations
	// Add the delete menu item
	function add_page() {
		global $submenu;
		if ( current_user_can( 'level_10' ) && function_exists( 'add_management_page' ) )
			$submenu['upload.php'][667] = array( 'delete Missing Images', 'manage_options' , admin_url() . '?delete-missing-images' ); 
	}
}


$WordPressdeleteMissingImages = new WordPressdeleteMissingImages();

endif;