function og_list_users_sql in Organic groups 5.2

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.3 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_email_form in ./og.module

Admins may broadcast email to all their subscribers

og_email_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 847

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}";
}