') OR (') ;
$qpa = $this->addIlikeCondition ($qpa, 'description') ;
$qpa = db_construct_qpa ($qpa,
- ') ORDER BY doc_groups.groupname, doc_data.docid') ;
+ ')) ORDER BY doc_groups.groupname, doc_data.docid') ;
}
return $qpa;
}
}
} else {
$qpa = db_construct_qpa ($qpa,
- 'SELECT news_bytes.summary, news_bytes.post_date, news_bytes.forum_id, users.realname FROM news_bytes, users WHERE (group_id=$1 AND is_approved <> 4 AND news_bytes.submitted_by = users.user_id AND ((',
+ 'SELECT news_bytes.summary, news_bytes.post_date, news_bytes.forum_id, users.realname FROM news_bytes, users WHERE group_id=$1 AND is_approved <> 4 AND news_bytes.submitted_by = users.user_id AND ((',
array ($this->groupId)) ;
$qpa = $this->addIlikeCondition ($qpa, 'summary') ;
$qpa = db_construct_qpa ($qpa,
') OR (') ;
$qpa = $this->addIlikeCondition ($qpa, 'details') ;
$qpa = db_construct_qpa ($qpa,
- ') ORDER BY post_date DESC') ;
+ ')) ORDER BY post_date DESC') ;
}
return $qpa ;
}
if (isset ($LUSER)) {
$qpa = db_construct_qpa ($qpa,
'OR g.group_id in (SELECT ug.group_id FROM user_group ug WHERE ug.user_id = $1 AND ug.group_id = g.group_id) ',
- $LUSER->getID()) ;
+ array ($LUSER->getID())) ;
}
$qpa = db_construct_qpa ($qpa,
') AND (vectors @@ q AND ') ;
if (isset ($LUSER)) {
$qpa = db_construct_qpa ($qpa,
'OR g.group_id in (SELECT ug.group_id FROM user_group ug WHERE ug.user_id = $1 AND ug.group_id = g.group_id) ',
- $LUSER->getID()) ;
+ array ($LUSER->getID())) ;
}
$qpa = db_construct_qpa ($qpa,
') AND (') ;
if (isset ($LUSER)) {
$qpa = db_construct_qpa ($qpa,
'OR g.group_id in (SELECT ug.group_id FROM user_group ug WHERE ug.user_id = $1 AND ug.group_id = g.group_id) ',
- $LUSER->getID()) ;
+ array($LUSER->getID())) ;
}
$qpa = db_construct_qpa ($qpa,
') AND ((') ;
}
$qpa = db_construct_qpa ($qpa,
$fieldName.' ~* $1',
- $regexs[$i]) ;
+ array ($regexs[$i])) ;
}
}
return $qpa;
}
$qpa = db_construct_qpa ($qpa,
'lower ('.$fieldName.') LIKE $1',
- $wordArgs[$i]) ;
+ array ('%'.$wordArgs[$i].'%')) ;
}
return $qpa ;
}
') OR (') ;
$qpa = $this->addIlikeCondition ($qpa, 'details') ;
$qpa = db_construct_qpa ($qpa,
- ') ORDER BY project_group_list.project_name, project_task.project_task_id') ;
+ ')) ORDER BY project_group_list.project_name, project_task.project_task_id') ;
}
return $qpa ;
}
}
} else {
$qpa = db_construct_qpa ($qpa,
- 'SELECT DISTINCT artifact.artifact_id, artifact.group_artifact_id, artifact.summary, artifact.open_date, users.realname, artifact_group_list.name FROM artifact LEFT OUTER JOIN artifact_message USING (artifact_id), users, artifact_group_list WHERE users.user_id = artifact.submitted_by AND artifact_group_list.group_artifact_id = artifact.group_artifact_id AND artifact_group_list.group_id = $1',
+ 'SELECT DISTINCT artifact.artifact_id, artifact.group_artifact_id, artifact.summary, artifact.open_date, users.realname, artifact_group_list.name FROM artifact LEFT OUTER JOIN artifact_message USING (artifact_id), users, artifact_group_list WHERE users.user_id = artifact.submitted_by AND artifact_group_list.group_artifact_id = artifact.group_artifact_id AND artifact_group_list.group_id = $1 ',
array ($this->groupId)) ;
if ($this->sections != SEARCH__ALL_SECTIONS) {
$qpa = db_construct_qpa ($qpa,
$qpa = $this->addIlikeCondition ($qpa, 'artifact.summary') ;
$qpa = db_construct_qpa ($qpa,
') OR (') ;
- $qpa = $this->addIlikeCondition ($qpa, 'artifact.message_body') ;
+ $qpa = $this->addIlikeCondition ($qpa, 'artifact_message.body') ;
$qpa = db_construct_qpa ($qpa,
- ') ORDER BY artifact_group_list.name, artifact.artifact_id') ;
+ ')) ORDER BY artifact_group_list.name, artifact.artifact_id') ;
}
return $qpa ;
}
}
function getInstructionsForRW ($project) {
- if (session_logged_in()) {
+ if (session_loggedin()) {
$u =& user_get_object(user_getid()) ;
$d = $u->getUnixName() ;
$b = _('<p><b>Developer GIT Access via SSH</b></p><p>Only project developers can access the GIT tree via this method. SSH must be installed on your client machine. Enter your site password when prompted.</p>');
}
function getInstructionsForRW ($project) {
- if (session_logged_in()) {
+ if (session_loggedin()) {
$u =& user_get_object(user_getid()) ;
$d = $u->getUnixName() ;
$b = _('<p><b>Developer Mercurial Access via SSH</b></p><p>Only project developers can access the Mercurial tree via this method. SSH must be installed on your client machine. Enter your site password when prompted.</p>');