query("SELECT salt FROM user WHERE name='$username';");
while($salt_array = $salt_db->fetchArray(SQLITE3_NUM)){
foreach($salt_array as $firstelement){
$salt=$firstelement;
}
}
$password = "$salt"."$passwort";
$hash_password = md5($password);
for($i=0;$i<15000;$i++)
$hash_password = md5($hash_password);
$real_password_db = $db_check->query("SELECT password FROM user WHERE name='$username';");
while($real_password_array = $real_password_db->fetchArray(SQLITE3_NUM)){
foreach($real_password_array as $secondelement){
$real_password=$secondelement;
}
}
/*___Einloggen___*/
if ($real_password == $hash_password) {
$_SESSION["login"] = true;
$_SESSION["username"] = "$username";
/*___Datenbankabfrage: Spruch___*/
$zufall = mt_rand(1,52);
$db = new SQLite3("../database/jg.db");
$zufall = SQLite3::escapeString("$zufall");
$ergebnis = $db->query("SELECT * FROM sprueche where id=$zufall;");
while($row=$ergebnis->fetchArray()){
$spruch = $row["spruch"];
}
echo"
Login: Random Quote.
Zitat Nummer #$zufall
$spruch
Fortschritt:
";
header("Refresh: 7; /");
} else {
header("Location: login.php?failure=1");
}
?>