SysMgr.searchSites (show, sort, order, keywords)
function manipulates the sites-collection

Sourcecode in SysMgr/objectFunctions.js:
1:   function searchSites(show, sort, order, keywords) {
2:      // construct the sql-clause for manual subnodeRelation
3:      var sql = "";
4:      if (show == "1")
5:         sql += "WHERE SITE_ISONLINE=1 AND SITE_ISBLOCKED=0 ";
6:      else if (show == "2")
7:         sql += "WHERE SITE_ISONLINE=0 AND SITE_ISBLOCKED=0 ";
8:      else if (show == "3")
9:         sql += "WHERE SITE_ISBLOCKED=1 ";
10:     else if (show == "4")
11:        sql += "WHERE SITE_ISTRUSTED=1 ";
12:     if (keywords) {
13:        // additional keywords are given, so we're using them
14:        var kArray = stripTags(keywords).split(" ");
15:        for (var i in kArray) {
16:           var k = kArray[i];
17:           sql += sql.length > 0 ? "AND " : "WHERE ";
18:           sql += "(SITE_ALIAS LIKE '%" + k + "%' OR SITE_TITLE LIKE '%" + k + "%' OR SITE_TAGLINE LIKE '%" + k + "%') ";
19:        }
20:     }
21:     if (!sort || sort == "0")
22:        sql += "ORDER BY SITE_LASTUPDATE ";
23:     else if (sort == "1")
24:        sql += "ORDER BY SITE_CREATETIME ";
25:     else if (sort == "2")
26:        sql += "ORDER BY SITE_ALIAS ";
27:     else if (sort == "3")
28:        sql += "ORDER BY SITE_TITLE ";
29:     if (!order || order == "0")
30:        sql += "desc ";
31:     else if (order == "1")
32:        sql += "asc ";
33:  
34:     // now do the actual search with a manual subnodeRelation
35:     this.sites.subnodeRelation = sql;
36:     return;
37:  }