From: Joey Schulze <joey@infodrom.org>
Date: Wed, 2 Jul 2008 13:52:59 +0000 (+0000)
Subject: Re-insert the row into online if it has been removed.
X-Git-Url: https://git.infodrom.org/?p=infodrom.org%2Fwww.zeitungsliste.de;a=commitdiff_plain;h=216549ba55adcf8094b8532203858d8f82cbf82e

Re-insert the row into online if it has been removed.
Maybe the session should be expired instead?
---

diff --git a/lib/session.inc b/lib/session.inc
index c8293f1..27a8cda 100644
--- a/lib/session.inc
+++ b/lib/session.inc
@@ -100,7 +100,11 @@ function session_init()
       session_invalidate('login.html?from=session');
 
     $query = sprintf('UPDATE online SET activity = now() WHERE uid = %d', $_SESSION['uid']);
-    db_query($query);
+    $sth = db_query($query);
+    if (pg_affected_rows($sth) < 1) {
+      $query = sprintf('INSERT INTO online (uid,activity) VALUES (%d,now())', $_SESSION['uid']);
+      $sth = db_query($query);
+    }
 
     if ($_SESSION["lastupdate"] < time() - 60) {
       session_update();