public function getOne($id)
{
$query = new MysqlQuery('SELECT groups.id
, groups.name
FROM groups
WHERE groups.id = $1');
$query->addParam($id);
return $query->query()->fetchOne();
}
public function isValidUser($username, $password)
{
$query = new MysqlQuery('SELECT id
, firstname
, lastname
, salt
, password
FROM users
WHERE username = $1');
$query->addParam($username);
$result = $query->query();
if ($result->numRows() == 1) {
$user = $result->fetchOne();
if ($this->bcrypt($password, $user['salt']) == $user['password']) {
$user['groups'] = $this->getUserGroups($user['id']);
return $user;
} else {
return false;
}
} else {
return false;
}
}
