From 55c5c9ca935a9077a1fd4003e93a10c5144a6bce Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Mon, 21 Apr 2025 22:53:09 +0500 Subject: feat: log user's last activity --- src/accounts.php | 3 +++ 1 file changed, 3 insertions(+) (limited to 'src') 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(); -- cgit v1.2.3