From 3bf282acc1e88a4e9b24f27de192a94d7175792c Mon Sep 17 00:00:00 2001 From: x2003bruneau Date: Fri, 1 Dec 2006 21:26:42 +0000 Subject: [PATCH] Fix timestamps in logger view git-svn-id: svn+ssh://murphy/home/svn/platal/branches/platal-0.9.12@1219 839d8a87-29fc-0310-9880-83ba4fa771e5 --- modules/admin.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/modules/admin.php b/modules/admin.php index b0ac1ef..3bac937 100644 --- a/modules/admin.php +++ b/modules/admin.php @@ -258,7 +258,7 @@ class AdminModule extends PLModule $page->assign('session', $a = $res->fetchOneAssoc()); - $res = XDB::iterator('SELECT a.text, e.data, UNIX_TIMESTAMP(e.stamp) AS stamp + $res = XDB::iterator('SELECT a.text, e.data, e.stamp FROM logger.events AS e LEFT JOIN logger.actions AS a ON e.action=a.id WHERE e.session={?}', $arg); @@ -308,7 +308,7 @@ class AdminModule extends PLModule // get the requested sessions $where = $this->_makeWhere($year, $month, $day, $loguid); - $select = "SELECT s.id, UNIX_TIMESTAMP(s.start) as start, s.uid, + $select = "SELECT s.id, s.start, s.uid, a.alias as username FROM logger.sessions AS s LEFT JOIN aliases AS a ON (a.id = s.uid AND a.type='a_vie') @@ -521,7 +521,7 @@ class AdminModule extends PLModule } } - $res = XDB::query("SELECT UNIX_TIMESTAMP(start), host + $res = XDB::query("SELECT start, host FROM logger.sessions WHERE uid={?} AND suid=0 ORDER BY start DESC -- 2.1.4