function imagepicker_admin_groups_list in Image Picker 5.2

Same name and namespace in other branches

1. 6.2 imagepicker.admin.inc \imagepicker_admin_groups_list()
2. 7 imagepicker.admin.inc \imagepicker_admin_groups_list()

1 call to imagepicker_admin_groups_list()

imagepicker_admin_groups in ./imagepicker.module

File

./imagepicker.module, line 1564

Enables permitted roles to upload images for insertion into configured nodes.

Code

function imagepicker_admin_groups_list() {
  $how_many = variable_get('imagepicker_rows_per_page', 25);
  $header = array(
    array(
      'data' => t('Group Name'),
      'field' => 'g.group_name',
    ),
    array(
      'data' => t('User Name'),
      'field' => 'u.name',
    ),
    array(
      'data' => t('Status'),
      'field' => 'g.public',
    ),
    array(
      'data' => t('Images'),
      'field' => 'ct',
    ),
    array(
      'data' => t('Actions'),
      'colspan' => 2,
    ),
  );
  $sql = "SELECT g.gid, g.uid, g.group_name, g.group_description, g.state, g.public, COUNT(i.img_id) AS ct, u.name\n    FROM {imagepicker_user_groups} g LEFT JOIN {imagepicker_group_images} i USING(gid), {users} u\n    WHERE g.uid=u.uid\n    GROUP BY g.gid" . tablesort_sql($header);
  $result = db_query($sql);
  $rowcount = 0;
  while ($row = db_fetch_array($result)) {
    $row_data = array(
      $row['group_name'],
      l($row['name'], 'admin/settings/imagepicker/groups/user/' . $row['uid']),
      $row['public'] ? t('Public') : t('Private'),
      $row['ct'] ? l(format_plural($row['ct'], '1 image', '@count images'), 'admin/settings/imagepicker/groups/user/' . $row['uid'] . '/browse/' . $row['gid']) : t('No images'),
      l(t('Edit'), 'admin/settings/imagepicker/groups/user/' . $row['uid'] . '/edit/' . $row['gid']),
      l(t('Delete'), 'admin/settings/imagepicker/groups/user/' . $row['uid'] . '/delete/' . $row['gid']),
    );
    $rows[] = $row_data;
    $rowcount++;
  }
  if (count($rows)) {
    $content .= '<div>' . theme('table', $header, $rows) . theme('pager', NULL, $how_many) . "</div>";
  }
  else {
    $content = '<div class="messages">' . t('No groups found.') . '</div>';
  }
  return $content;
}