Finding orphaned images and files

   [[!OrphanImages]]

/* OrphanImages snippet */

/* Modify the next line as necessary; the search is recursive, so it will cover the dir.
   specified, and all directories under it */

$imageDirectory = MODX_ASSETS_PATH . 'images';

require_once MODX_CORE_PATH . 'components/dirwalker/model/dirwalker/dirwalker.class.php';

/* Get all the files */
$dw = new DirWalker();
$dw->dirWalk($imageDirectory, true);
$files = $dw->getFiles();

/* Create Query */
$objects = array(
    $modx->getTableName('modResource') => 'content',
    $modx->getTableName('modChunk') => 'snippet',
    $modx->getTableName('modSnippet') => 'snippet',
    $modx->getTableName('modPlugin') => 'plugincode',
    $modx->getTableName('modTemplate') => 'content',
    $modx->getTableName('modTemplateVarResource') => 'value',
    $modx->getTableName('modTemplateVar') => 'default_text',
);

$string = '';
$s = array();
foreach($objects as $table => $fieldName) {
    $s[] =  "(SELECT $fieldName FROM $table WHERE $fieldName LIKE :s)";
}

$string = implode(' UNION ', $s);

/* Prepare Query and bind $s param */
$sql = $modx->prepare($string);
$sql->bindParam("s", $searchTerm);


/* Execute query once for each file */
$output = '';
foreach($files as $path => $searchTerm) {
    $searchTerm = "%" . $searchTerm . "%";
    $sql->execute();
    $count = $sql->rowCount();
    $msg = $count? 'IN USE ' : '<span style="color:red">ORPHAN </span>';
    $output .= "\n<br>" . $msg . $path . " Count: " . $count;
}
return $output;

foreach($files as $path => $searchTerm) {
    $searchTerm = "%" . $searchTerm . "%"; // add this line
    $sql->execute();
    $count = $sql->rowCount();
    $msg = $count? 'IN USE ' : '<span style="color:red">ORPHAN </span>';
    $output .= "\n<br>" . $msg . $path . " Count: " . $count;
}