public static function getUser($login)
{
self::setUpConnection();
$select = self::$db->select();
$sampleUser = new DatabaseUser();
if (!is_null($login)) {
$data = $select->From($sampleUser->getTableName())->Where('login = ?', $login)->query()->fetch();
if ($data) {
$user = new DatabaseUser();
$user->setData($data);
return $user;
}
}
}
public function isAllowed($target, $action)
{
parent::verifyType($target, "string");
parent::verifyType($action, "string");
$result = $this->doFunction("f_isAuthorized", array("'" . $this->user->getEmail() . "'", "'" . $target . "'", "'" . $action . "'"));
return $result > 0;
}
public function getUser($login)
{
if (empty($login)) {
return new AnonymousUser();
}
$sql = sprintf("SELECT * FROM `%s` WHERE (`%s`=? or `%s`=?)", $this->getTable('user'), $this->getField('user_userid'), $this->getField('user_email'));
$result = $this->connection->query($sql, array($login, $login));
if ($row = $result->fetch()) {
$user = new DatabaseUser($this);
$user->setUserID($row[$this->getField('user_userid')]);
$user->setEmail($row[$this->getField('user_email')]);
if (isset($row[$this->getField('user_fullname')])) {
$user->setFullName($row[$this->getField('user_fullname')]);
}
if (isset($row[$this->getField('user_firstname')])) {
$user->setFirstName($row[$this->getField('user_firstname')]) ;
}
if (isset($row[$this->getField('user_lastname')])) {
$user->setLastName($row[$this->getField('user_lastname')]) ;
}
return $user;
} else {
return false;
}
}
/**
* Retrieves the message corresponding to a give id.
*
* @param {integer/string} id The message code.
* @return {string} The message corresponding to the provided
* id if it exists, "Message: <id>" otherwise.
*/
public function getMessage($id)
{
parent::verifyTypes($id, array("integer", "string"));
$id = intval($id);
$table = DataAccessConfig::messageData();
$values = array($table->messageText);
$target = array($table->messageId => $id);
$result = $this->selectRows($table->tableName, $values, $target);
if (count($result) != 1) {
return "Message ID: " . $id;
}
return $result[0][$table->messageText];
}
private function usernameExists($email)
{
parent::verifyType($email, "string");
$table = DataAccessConfig::userData();
$values = array($table->userId);
$target = array($table->email => "'" . $email . "'");
$result = $this->selectRows($table->tableName, $values, $target);
return count($result) == 1;
}
/**
* change password
*
* @param unknown_type $pass
*/
public function changePassword($pass)
{
$this->_user->password = $this->_encryptPassword($pass);
$this->_user->save();
}
