rem: sql += "EMAIL LIKE '%" + keywords + "%' "; 
add: sql += "USER_EMAIL LIKE '%" + keywords + "%' "; 
context: function searchUsers(show,sort,order,keywords) {   // construct the sql-clause for manual subnodeRelation   var sql = "";   if (show == "1")      sql += "WHERE ISBLOCKED=1 ";   else if (show == "2")      sql += "WHERE ISTRUSTED=1 ";   else if (show == "3")      sql += "WHERE ISSYSADMIN=1 ";   if (keywords) {      // additional keywords are given, so we're using them      if (keywords.charAt(0) == "@") {         // searching for email-addresses         sql += sql.length > 0 ? "AND " : "WHERE ";         sql += "EMAIL LIKE '%" + keywords + "%' ";      } else {         // doing normal keyword-search         var kArray = keywords.split(" ");         for (var i in kArray) {            var k = kArray[i];            sql += sql.length > 0 ? "AND " : "WHERE ";            sql += "USERNAME LIKE '%" + k + "%' ";         }      }   }   if (!sort || sort == "0")      sql += "ORDER BY LASTVISIT ";   else if (sort == "1")      sql += "ORDER BY REGISTERED ";   else if (sort == "2")      sql += "ORDER BY USERNAME ";   if (!order || order == "0")      sql += "desc ";   else if (order == "1")      sql += "asc ";   // now do the actual search with a manual subnodeRelation   this.users.subnodeRelation = sql;   return;}
meta: 993	/local1/tlutelli/issta_data/temp/all_js/javascript/2006_temp/2006/993/e5a4ca395a67e069208aacedc83707ddb359984d/objectFunctions.js/buggy/code/SysMgr/objectFunctions.js