Changed database schema again.

1 files changed, 10 insertions, 0 deletions

diff --git a/www/login.php b/www/login.php
index e9c7c93..ed73bdc 100644
--- a/www/login.php
+++ b/www/login.php
@@ -37,10 +37,20 @@ if($_SERVER['REQUEST_METHOD'] == 'POST') {
 /*___Login___*/
 	if ($real_password == $hash_password) {
 
+		if($db->exec("
+			BEGIN TRANSACTION;
+			INSERT INTO log (id, user, login) VALUES (NULL, (SELECT id FROM user WHERE name='$username'), (SELECT datetime()) );
+			COMMIT;
+		")){
+
 		$_SESSION["login"] = true;
 		$_SESSION["username"] = "$unsafe_username";
 
 		header("Refresh: 0; /");
+
+		} else {
+			header("Refresh: 0; login?reason=database");
+		}
 	} else {
 		header("Refresh: 0; login?reason=failure");
 	}