/**
* Saves the current user-data into the database.
* Returns true on success, otherwise false.
*
* @return bool
*/
public function save()
{
$update = sprintf("\n UPDATE\n %sfaquserdata\n SET\n last_modified = '%s',\n display_name = '%s',\n email = '%s'\n WHERE\n user_id = %d", SQLPREFIX, date('YmdHis', $_SERVER['REQUEST_TIME']), $this->db->escapeString($this->data['display_name']), $this->db->escapeString($this->data['email']), $this->user_id);
$res = $this->db->query($update);
if (!$res) {
return false;
}
return true;
}
/**
* Checks the number of entries of given login name
*
* @param string $login Loginname
* @param array $optionslData Optional data
* @return integer
*/
public function checkLogin($login, array $optionalData = null)
{
$check = sprintf("\n SELECT\n login\n FROM\n %sfaquserlogin\n WHERE\n login = '******'", SQLPREFIX, $this->db->escapeString($login));
$check = $this->db->query($check);
$error = $this->db->error();
if (strlen($error) > 0) {
$this->errors[] = $error;
return 0;
}
return $this->db->numRows($check);
}
/**
* Creates the part for the WHERE clause
*
* @param string $searchTerm Search term
*
* @return string
*/
public function getMatchClause($searchTerm = '')
{
$keys = PMF_String::preg_split("/\\s+/", $searchTerm);
$numKeys = count($keys);
$numMatch = count($this->matchingColumns);
$where = '';
for ($i = 0; $i < $numKeys; $i++) {
if (strlen($where) != 0) {
$where = $where . " OR";
}
$where = $where . " (";
for ($j = 0; $j < $numMatch; $j++) {
if ($j != 0) {
$where = $where . " OR ";
}
$where = sprintf("%s%s LIKE '%%%s%%'", $where, $this->matchingColumns[$j], $this->dbHandle->escapeString($keys[$i]));
}
$where .= ")";
}
return $where;
}
/**
* sets the user's status and updates the database entry.
*
* @param string $status Status
* @return boolean
*/
public function setStatus($status)
{
// is status allowed?
$status = strtolower($status);
if (!in_array($status, array_keys($this->allowed_status))) {
$this->errors[] = self::ERROR_USER_INVALID_STATUS;
return false;
}
// update status
$this->status = $status;
$update = sprintf("\n UPDATE\n %sfaquser\n SET\n account_status = '%s'\n WHERE\n user_id = %d", SQLPREFIX, $this->db->escapeString($status), $this->user_id);
$res = $this->db->query($update);
if ($res) {
return true;
}
return false;
}