function imagepicker_has_grouplist in Image Picker 7

Same name and namespace in other branches

1. 5.2 imagepicker.module \imagepicker_has_grouplist()
2. 5 imagepicker.module \imagepicker_has_grouplist()
3. 6.2 imagepicker.functions.inc \imagepicker_has_grouplist()

3 calls to imagepicker_has_grouplist()

imagepicker_browse_admin_form in ./imagepicker.functions.inc

_imagepicker_browse in ./imagepicker.functions.inc

_imagepicker_browse_admin in ./imagepicker.functions.inc

File

./imagepicker.functions.inc, line 1441

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

Code

function imagepicker_has_grouplist($account = FALSE) {
  if ($account) {
    $user = $account;
  }
  else {
    global $user;
  }
  $query = db_select('imagepicker_user_groups', 'g');
  $query
    ->addExpression('COUNT(DISTINCT g.gid)', 'ct');
  $query
    ->join('imagepicker_group_images', 'i', 'g.gid = i.gid');
  $query
    ->condition('g.uid', $user->uid);
  $row = $query
    ->execute()
    ->fetchObject();
  return $row->ct;
}