function _advuser_dbquery_users_to_notify in Advanced User 5

Same name and namespace in other branches

1. 5.2 advuser.module \_advuser_dbquery_users_to_notify()
2. 6.3 advuser.module \_advuser_dbquery_users_to_notify()
3. 6.2 advuser.module \_advuser_dbquery_users_to_notify()
4. 7.3 advuser.module \_advuser_dbquery_users_to_notify()

2 calls to _advuser_dbquery_users_to_notify()

advuser_user_insert in ./advuser.module

Handle user insertion (new users) TODO: DRY (don't repeat yourself!)

advuser_user_update in ./advuser.module

Handle user edit TODO: DRY (don't repeat yourself!)

File

./advuser.module, line 820

Code

function _advuser_dbquery_users_to_notify($roles) {
  $role_where = _advuser_get_roles_query_fragment($roles);
  return db_query('SELECT u.mail, u.name FROM {users} u LEFT JOIN {users_roles} ur on u.uid = ur.uid WHERE 0 ' . $role_where);
}