feat: log user's last activity

1 files changed, 3 insertions, 0 deletions

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();