function imagepicker_admin_users_list in Image Picker 6.2

Same name and namespace in other branches

1. 5.2 imagepicker.module \imagepicker_admin_users_list()
2. 7 imagepicker.admin.inc \imagepicker_admin_users_list()

Administration functions

1 call to imagepicker_admin_users_list()

imagepicker_admin_images in ./imagepicker.admin.inc

File

./imagepicker.admin.inc, line 767

admin settings functions

Code

function imagepicker_admin_users_list($dir, $label = '') {
  $how_many = variable_get('imagepicker_rows_per_page', 25);
  $header = array(
    array(
      'data' => t('Name'),
      'field' => 'u.name',
    ),
    t('Images'),
    variable_get('imagepicker_groups_enabled', 1) ? t('Groups') : '',
    variable_get('imagepicker_quota_enable', 1) ? t('Quotas') : '',
    t('Used'),
  );
  $cols = 5;
  $rowcount = 0;
  $rows = '';
  $countsql = "SELECT COUNT(DISTINCT u.uid) FROM {imagepicker} i JOIN {users} u ON i.uid=u.uid WHERE u.status=1";
  $sql = "SELECT DISTINCT u.uid, u.name FROM {imagepicker} i JOIN {users} u ON  i.uid=u.uid WHERE u.status=1";
  $sql .= tablesort_sql($header);
  $result = pager_query($sql, $how_many, 0, $countsql);
  while ($row = db_fetch_array($result)) {
    $account = user_load(array(
      'uid' => $row['uid'],
    ));
    $allcount = _imagepicker_user_has_img($account);
    $groupcount = _imagepicker_user_has_groups('all', $account);
    $usedbytesprint = _imagepicker_bkmg(imagepicker_get_all_bytes($account) + 1);
    $quota = 0;
    if (variable_get('imagepicker_quota_enable', 1)) {
      if (variable_get('imagepicker_quota_byrole', 0)) {
        $roleid = variable_get('imagepicker_quota_role', 2);
        if (imagepicker_user_has_role($roleid, $account) && $account->uid > 1) {
          $quota = variable_get('imagepicker_quota_default', 0);
        }
      }
      else {
        $quota = isset($account->imagepicker_quota) ? $account->imagepicker_quota : variable_get('imagepicker_quota_default', 0);
      }
    }
    $row_data = array(
      check_plain($row['name']),
      $allcount ? $allcount . ' ' . l(t('images'), IMAGEPICKER_ADMIN_PATH . '/images/user/' . $row['uid'] . '/browse') : t('No images'),
      variable_get('imagepicker_groups_enabled', 1) ? $groupcount ? $groupcount . ' ' . l(t('groups'), IMAGEPICKER_ADMIN_PATH . '/groups/user/' . $row['uid'] . '/browse') : t('No groups') : '',
      variable_get('imagepicker_quota_enable', 1) ? l(imagepicker_get_quota_list($quota + 1), IMAGEPICKER_ADMIN_PATH . '/images/user/' . $row['uid'] . '/quota') : '',
      $usedbytesprint,
    );
    $rows[] = $row_data;
    $rowcount++;
  }
  return theme('imagepicker_list', $header, $rows, $how_many, t('No users found.'), '', '', $label, $cols);
}