query("SELECT id FROM user WHERE name='$name';");
$name_id_ar = $name_id_db->fetchArray(SQLITE3_NUM);
if(empty($name_id_ar)){
if($_SESSION["login"]){
header("Refresh: 0; /" . $_SESSION[username] . "/" . $_GET["name"] . "/" . $_GET["folder"] . ""); //rewrite the URL to include the username
// echo "Eingeloggt! Zeige deine Ordner beginnend mit '$_GET[name]' !
";
// $_GET["folder"] = "" . $_GET["name"] . "/" . $_GET["folder"] . "";
// $_GET["name"] = $_SESSION["username"];
// select();
exit;
} else {
get_404();
}
} else {
include("select.php");
// select($db);
exit;
}
}
}
echo "loged in as: " . $_SESSION["username"];
$safe_name=SQLite3::escapeString("$_SESSION[username]");
$db = new SQLite3("../database/sqlite.db");
$invite_db = $db->query("SELECT invites FROM user WHERE name='$safe_name';");
$invite_ar = $invite_db->fetchArray(SQLITE3_NUM);
$invite = $invite_ar[0];
echo "
";
echo "You have currently $invite invites.
";
select($db);