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