Changeset 780 for trunk

Timestamp:

Jan 26, 2023 5:18:34 PM (16 months ago)

Author:

anonymous

Message:

Avoid error if last_access_datetime is older than 1970

File:

• trunk/lib/Auth_SQL.inc.php (modified) (2 diffs)

trunk/lib/Auth_SQL.inc.php

@@ -344 +344 @@
             $db->query(sprintf(
                 "UPDATE %s SET
-                    seconds_online = seconds_online + ABS(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(last_access_datetime)),
+                    seconds_online = seconds_online + IFNULL(ABS(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(last_access_datetime)), 0),
                     last_login_datetime = '%s 00:00:00'
                     WHERE %s = '%s'
@@ -700 +700 @@
             $db->query("
                 UPDATE " . $this->_params['db_table'] . " SET
-                seconds_online = seconds_online + ABS(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(last_access_datetime)) + 1,
+                seconds_online = seconds_online + IFNULL(ABS(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(last_access_datetime)), 0) + 1,
                 last_access_datetime = '" . $this->get('last_access_datetime') . "'
                 WHERE " . $this->_params['db_primary_key'] . " = '" . $this->get('user_id') . "'