[Openautomation-svn] SF.net SVN: openautomation:[464] tools/rsslog/rsslog.php

[<ma...@us...>]

Revision: 464
          http://openautomation.svn.sourceforge.net/openautomation/?rev=464&view=rev
Author:   mayerch
Date:     2011-10-22 19:10:59 +0000 (Sat, 22 Oct 2011)
Log Message:
-----------
Fix timezone troubles. 
(On a German WireGate the sent back dates were two hours off...)

Modified Paths:
--------------
    tools/rsslog/rsslog.php

Modified: tools/rsslog/rsslog.php
===================================================================
--- tools/rsslog/rsslog.php	2011-10-22 16:33:02 UTC (rev 463)
+++ tools/rsslog/rsslog.php	2011-10-22 19:10:59 UTC (rev 464)
@@ -48,6 +48,7 @@
     $row = sqlite_fetch_array($result, SQLITE_ASSOC ); 
     echo '<tr>';
     echo '<td>' . date( DATE_RFC822, $row['t'] ) . '</td>';
+    echo '<td>' . $row['t'] . '</td>';
     echo '<td>' . $row['content'] . '</td>';
     echo "</tr>\n";
   }
@@ -119,7 +120,8 @@
   // store a new log line
   $q = 'INSERT INTO Logs(content, t) VALUES( ' .
        "  '" . sqlite_escape_string( $content ) . "'," .
-       "  datetime('now','localtime')" .
+//       "  datetime('now','localtime')" .
+       "  datetime('now')" .
        ')';
   
   $ok = sqlite_exec($db, $q, $error);
@@ -131,14 +133,16 @@
 // return a handle to all the data
 function retrieve( $db, $filter )
 {
-  $q = "SELECT content, strftime('%s', t, 'localtime') AS t FROM Logs";
+//  $q = "SELECT content, strftime('%s', t, 'localtime') AS t FROM Logs";
+  $q = "SELECT content, strftime('%s', t) AS t FROM Logs";
   return sqlite_query( $db, $q, SQLITE_ASSOC );
 }
 
 // delete all log lines older than the timestamp
 function delete( $db, $timestamp )
 {
-  $q = "DELETE from Logs WHERE t < datetime($timestamp, 'unixepoch', 'localtime')";
+  //$q = "DELETE from Logs WHERE t < datetime($timestamp, 'unixepoch', 'localtime')";
+  $q = "DELETE from Logs WHERE t < datetime($timestamp, 'unixepoch')";
   $ok = sqlite_exec($db, $q, $error);
   
   if (!$ok)

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.