public function logintry($postdata)
{
$inputname = $postdata['inputname'];
$inputpass = $postdata['inputpass'];
$user = new User();
$user->findByName($inputname);
if ($user->getPassword() === hash('sha256', $inputpass)) {
Session::create('user', $user->getName());
} else {
echo 0;
}
}
public function save(User $user)
{
$query = "SELECT * FROM users WHERE username = ?";
$this->db->query($query, [$user->getUsername()]);
$result = $this->db->row();
if ($result) {
echo 'The username already taken!';
die;
}
$query = "\n INSERT INTO users (username, email, cash, roleId, password)\n VALUES (?, ?, ?, ?, ?)\n ";
$params = [$user->getUsername(), $user->getEmail(), floatval($user->getCash()), $user->getRole(), $user->getPassword()];
if ($user->getId()) {
$query = "UPDATE players SET username = ?, password = ? WHERE id = ?";
$params[] = $user->getId();
}
$this->db->query($query, $params);
return $this->db->rows() > 0;
}
public static function registerUser(User $user)
{
$db = Database::getInstance();
$query = $db->prepare('INSERT INTO users (firstname, lastname, username, password, email) VALUES (?, ?, ?, ?, ?)');
$query->execute([$user->getFirstName(), $user->getLastName(), $user->getUsername(), $user->getPassword(), $user->getEmail()]);
$affected = $query->rowCount();
if ($affected == 1) {
redirect(\route\Route::get("index")->generate());
} else {
?>
<script>
document.getElementById("failedRegister").innerHTML =
"User already exists.";
</script>
<?php
}
}
public function getPassword()
{
$this->_load();
return parent::getPassword();
}
private static function insert(User $model)
{
$db = Database::getInstance('app');
$query = "INSERT INTO users (username,email,password,role_id,f_name,l_name,gender,date_of_birth,registered_at) VALUES (:username, :email, :password, :role_id, :f_name, :l_name, :gender, :date_of_birth, :registered_at);";
$result = $db->prepare($query);
$result->execute([':username' => $model->getUsername(), ':email' => $model->getEmail(), ':password' => $model->getPassword(), ':role_id' => $model->getRole_id(), ':f_name' => $model->getF_name(), ':l_name' => $model->getL_name(), ':gender' => $model->getGender(), ':date_of_birth' => $model->getDate_of_birth(), ':registered_at' => $model->getRegistered_at()]);
$model->setId($db->lastId());
}
private static function insert(User $model)
{
$db = Database::getInstance('app');
$query = "INSERT INTO user (username,password,registerDate,emailVerified,email,createdAt,updatedAt) VALUES (:username, :password, :registerDate, :emailVerified, :email, :createdAt, :updatedAt);";
$result = $db->prepare($query);
$result->execute([':username' => $model->getUsername(), ':password' => $model->getPassword(), ':registerDate' => $model->getRegisterDate(), ':emailVerified' => $model->getEmailVerified(), ':email' => $model->getEmail(), ':createdAt' => $model->getCreatedAt(), ':updatedAt' => $model->getUpdatedAt()]);
$model->setId($db->lastId());
}
