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: }
|