public function actionNewUser()
{
$session = \Yii::$app->session;
$newUser = $session->get('newUser');
$db = new \SQLite3('flair');
$tablename = "userAccounts";
$alreadyExists = ProfileController::getUsername(0, $newUser["username"]);
if ($alreadyExists) {
$session->set("alreadyExists", true);
return $this->redirect('@web/index.php/account');
}
//CREATE TABLE userAccounts (ID INTEGER PRIMARY KEY AUTOINCREMENT, username VARCHAR(30), password VARCHAR(20));
$db->exec("INSERT INTO {$tablename}\n\t\t(username, password)\n\t\tVALUES ('{$newUser["username"]}', '{$newUser["password"]}')");
$db->close();
unset($db);
return $this->redirect('@web/index.php/login/from-account');
}
