You are here

function og_list_users_sql in Organic groups 5.3

Same name and namespace in other branches
  1. 5.8 og.module \og_list_users_sql()
  2. 5 og.module \og_list_users_sql()
  3. 5.2 og.module \og_list_users_sql()
  4. 5.7 og.module \og_list_users_sql()
  5. 6.2 og.module \og_list_users_sql()
  6. 6 og.module \og_list_users_sql()
8 calls to og_list_users_sql()
og_broadcast_form in ./og.module
Admins may broadcast messages to all their members.
og_broadcast_form_submit in ./og.module
og_handler_field_count in ./og_views.inc
Views handler to display the number subscriptions
og_list_users_faces_page in ./og.module
og_list_users_page in ./og.module

... See full list

File

./og.module, line 890

Code

function og_list_users_sql($min_is_active = 1, $min_is_admin = 0, $orderby = 'u.name ASC') {
  return "SELECT u.uid, u.name, u.mail, u.picture, ou.* FROM {og_uid} ou INNER JOIN {users} u ON ou.uid = u.uid WHERE ou.nid = %d AND u.status > 0 AND ou.is_active >= {$min_is_active} AND ou.is_admin >= {$min_is_admin} ORDER BY {$orderby}";
}