function imagepicker_check_orphans in Image Picker 7

Same name and namespace in other branches

1. 6.2 imagepicker.admin.inc \imagepicker_check_orphans()

3 calls to imagepicker_check_orphans()

imagepicker_admin_orphans_do in ./imagepicker.admin.inc

imagepicker_admin_orphans_form in ./imagepicker.admin.inc

imagepicker_settings_page in ./imagepicker.admin.inc

Menu callback; presents the settings form for imagepicker

File

./imagepicker.admin.inc, line 1175

@author Bob Hutchinson http://drupal.org/user/52366 @copyright GNU GPL

Code

function imagepicker_check_orphans($dir) {
  $output = array();
  $numericdirlist = file_scan_directory($dir, "/.*/", array(
    'recurse' => FALSE,
  ));
  foreach ($numericdirlist as $k => $v) {
    if (is_numeric($numericdirlist[$k]->filename)) {
      $numericdir = $numericdirlist[$k]->filename;
      $query = db_select('users', 'u');
      $query
        ->fields('u', array(
        'uid',
      ));
      $query
        ->condition('u.uid', $numericdir);
      $row = $query
        ->execute()
        ->fetchAssoc();
      if (!$row) {
        $query = db_select('imagepicker');
        $query
          ->addExpression('COUNT(img_id)', 'ct');
        $query
          ->condition('uid', $numericdir);
        $row2 = $query
          ->execute()
          ->fetchAssoc();
        if ($row2) {
          if ($row2['ct'] > 0) {
            $output[] = $numericdir;
          }
        }
      }
    }
  }
  if (count($output)) {
    return $output;
  }
  return FALSE;
}