Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.xql 16 Feb 2005 22:21:30 -0000 1.2 +++ openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.xql 2 Nov 2005 20:30:22 -0000 1.3 @@ -1,38 +1,12 @@ - - - select first_names, last_name, user_id as p_user_id, email as db_email - from cc_users where user_id in ( - select grantee_id from acs_permissions where object_id = :object_id - and privilege = 'admin') and user_id <> :user_id - - - - - - select first_names, last_name, user_id as p_user_id, email as db_email - from cc_users where user_id <> :user_id - and (lower(first_names) like lower('%$user_name%') - or lower(last_name) like '%$user_name%') order by first_names, last_name - - - - - - select first_names, last_name, user_id as p_user_id, email as db_email - from cc_users where user_id <> :user_id - and lower(email) like lower('%$user_email%') order by email - - - select first_names, last_name, user_id as p_user_id, email as db_email from cc_users where user_id <> :user_id and ( - lower(first_names) like lower('%$user_name%') or lower(last_name) like lower('%$user_name%')) - and lower(email) like lower('%$user_email%') order by email + lower(first_names) like lower('%$keyword%') or lower(last_name) like lower('%$keyword%') or + lower(email) like lower('%$keyword%')) order by email