SysMgr.searchUsers (show, sort, order, keywords)
function manipulates the users-collection

Sourcecode in SysMgr/objectFunctions.js:
1:   function searchUsers(show, sort, order, keywords) {
2:      // construct the sql-clause for manual subnodeRelation
3:      var sql = "";
4:      if (show == "1")
5:         sql += "WHERE USER_ISBLOCKED=1 ";
6:      else if (show == "2")
7:         sql += "WHERE USER_ISTRUSTED=1 ";
8:      else if (show == "3")
9:         sql += "WHERE USER_ISSYSADMIN=1 ";
10:     if (keywords) {
11:        // additional keywords are given, so we're using them
12:        if (keywords.charAt(0) == "@") {
13:           // searching for email-addresses
14:           sql += sql.length > 0 ? "AND " : "WHERE ";
15:           sql += "USER_EMAIL LIKE '%" + keywords + "%' ";
16:        } else {
17:           // doing normal keyword-search
18:           var kArray = stripTags(keywords).split(" ");
19:           for (var i in kArray) {
20:              var k = kArray[i];
21:              sql += sql.length > 0 ? "AND " : "WHERE ";
22:              sql += "USER_NAME LIKE '%" + k + "%' ";
23:           }
24:        }
25:     }
26:     if (!sort || sort == "0")
27:        sql += "ORDER BY USER_LASTVISIT ";
28:     else if (sort == "1")
29:        sql += "ORDER BY USER_REGISTERED ";
30:     else if (sort == "2")
31:        sql += "ORDER BY USER_NAME ";
32:     if (!order || order == "0")
33:        sql += "desc ";
34:     else if (order == "1")
35:        sql += "asc ";
36:  
37:     // now do the actual search with a manual subnodeRelation
38:     this.users.subnodeRelation = sql;
39:     return;
40:  }