From 504ccd57eb8c8b078663d4319a58a579dd5d17c3 Mon Sep 17 00:00:00 2001 From: x2003bruneau Date: Fri, 1 Dec 2006 21:28:30 +0000 Subject: [PATCH] Backport git-svn-id: svn+ssh://murphy/home/svn/platal/trunk@1220 839d8a87-29fc-0310-9880-83ba4fa771e5 --- modules/admin.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/modules/admin.php b/modules/admin.php index 9090df0..1d4d502 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') -- 2.1.4