public function login()
{
extract($_REQUEST);
$data = DB::query("select * from users \n\t\t\twhere email = '" . $email . "' and pass = '******' \n\t\t\tor username = '******' and pass = '******'", 1);
DB::write('update users set lastlogin_ts = ' . time() . ' where id = ' . $data['id']);
$json = 0;
if ($data) {
$json = 1;
AuthController::add_session($data);
}
return array('result' => $json);
}
public function index($instanceId)
{
$user = AuthController::auth();
$scoreRepo = new ScoreRepository();
$scores = $scoreRepo->getScoreByInstanceId($instanceId);
$instanceRepo = new InstanceRepository();
$instance = $instanceRepo->get($instanceId);
usort($scores, function ($a, $b) {
if ($a->score == $b->score) {
return 0;
}
return $a->score < $b->score ? 1 : -1;
});
$this->view('score.php', ['user' => $user, 'scores' => $scores, 'instance' => $instance]);
}
public function upsert()
{
$user = AuthController::auth();
if ($this->isValid($_POST)) {
$instanceRepo = new InstanceRepository();
$pdo = Connection::connect();
$pdo->beginTransaction();
try {
if ($_POST['id'] != "") {
$instance = $instanceRepo->get($_POST['id']);
$instance->name = $_POST['name'];
$instance->description = $_POST['description'];
$instanceRepo->update($instance);
$_SESSION['success'] = ['Successfully update an instance.'];
} else {
$instance = new Instance();
$instance->id = $this->generateId();
$instance->password = $this->generatePassword();
$instance->userId = $user->id;
$instance->name = $_POST['name'];
$instance->description = $_POST['description'];
$instanceRepo->insert($instance);
$_SESSION['success'] = ['Successfully add an instance.'];
}
$pdo->commit();
} catch (\Exception $e) {
$pdo->rollBack();
unset($_SESSION['success']);
}
header('Location: /');
} else {
if ($_POST['id'] != "") {
header('Location: /instance/edit?id=' . $_POST['id']);
} else {
header('Location: /instance/edit');
}
}
}
