diff options
| -rw-r--r-- | database.sql | 3 | ||||
| -rw-r--r-- | src/accounts.php | 3 |
2 files changed, 5 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 4840f22..5585a93 100644 --- a/database.sql +++ b/database.sql @@ -3,7 +3,8 @@ CREATE TABLE IF NOT EXISTS users ( username TEXT NOT NULL UNIQUE, password TEXT, secret_key TEXT NOT NULL, - joined_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP + joined_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP, + last_active_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP ); CREATE TABLE IF NOT EXISTS connections ( diff --git a/src/accounts.php b/src/accounts.php index 1580fa5..87c8ef0 100644 --- a/src/accounts.php +++ b/src/accounts.php @@ -38,6 +38,9 @@ function authorize_user(bool $required = false): bool if ($row = $stmt->fetch()) { $_SESSION["user_id"] = $row["id"]; $_SESSION["user_name"] = $row["username"]; + + $stmt = $db->prepare("UPDATE users SET last_active_at = UTC_TIMESTAMP WHERE id = ?"); + $stmt->execute([$row["id"]]); } else { session_regenerate_id(); session_unset(); |