rem: sql += "WHERE SITE_ISBLOCKED=1 "; 
add: sql += "where status = 'blocked' "; 
context: SysMgr.prototype.searchSites = function(show, sort, order, keywords) {   // construct the sql-clause for manual subnodeRelation   var sql = "";   if (show == "1")      sql += "WHERE SITE_ISONLINE=1 AND SITE_ISBLOCKED=0 ";   else if (show == "2")      sql += "WHERE SITE_ISONLINE=0 AND SITE_ISBLOCKED=0 ";   else if (show == "3")      sql += "WHERE SITE_ISBLOCKED=1 ";   else if (show == "4")      sql += "WHERE SITE_ISTRUSTED=1 ";   if (keywords) {      // additional keywords are given, so we're using them      var kArray = stripTags(keywords).split(" ");      for (var i in kArray) {         var k = kArray[i];         sql += sql.length > 0 ? "AND " : "WHERE ";         sql += "(SITE_ALIAS LIKE '%" + k + "%' OR SITE_TITLE LIKE '%" + k + "%') ";      }   }   if (!sort || sort == "0")      sql += "ORDER BY SITE_LASTUPDATE ";   else if (sort == "1")      sql += "ORDER BY SITE_CREATETIME ";   else if (sort == "2")      sql += "ORDER BY SITE_ALIAS ";   else if (sort == "3")      sql += "ORDER BY SITE_TITLE ";   if (!order || order == "0")      sql += "desc ";   else if (order == "1")      sql += "asc ";   // now do the actual search with a manual subnodeRelation   this.sites.subnodeRelation = sql;   return;};
meta: 993	/local1/tlutelli/issta_data/temp/all_js/javascript/2007_temp/2007/993/d274db390adc9b141e241911b7f449881ce0a0c5/SysMgr.js/clean/code/SysMgr/SysMgr.js