From 01e94d67317be183b74fa97bd3d15ee99ab27d69 Mon Sep 17 00:00:00 2001 From: artem Date: Tue, 17 Jun 2008 15:18:03 +0000 Subject: - [DEV-175] improvements to showed users last login time (Artem) - [DEV-178] more fixes to permission scheme (Artem) git-svn-id: svn://svn.zabbix.com/trunk@5776 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- frontends/php/include/blocks.inc.php | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'frontends/php/include/blocks.inc.php') diff --git a/frontends/php/include/blocks.inc.php b/frontends/php/include/blocks.inc.php index b0c45a24..e8ce905c 100644 --- a/frontends/php/include/blocks.inc.php +++ b/frontends/php/include/blocks.inc.php @@ -374,11 +374,14 @@ function make_status_of_zbx(){ $table->AddRow(array(S_NUMBER_OF_ALERTS,$status['alerts_count'],' - '));*/ //Log Out 10min - $sql = 'SELECT DISTINCT u.userid, s.lastaccess, u.autologout '. + $sql = 'SELECT DISTINCT u.userid, MAX(s.lastaccess) as lastaccess, u.autologout '. ' FROM users u '. - ' LEFT JOIN sessions s ON s.userid=u.userid'; + ' LEFT JOIN sessions s ON s.userid=u.userid'. + ' WHERE '.DBin_node('u.userid'). + ' GROUP BY u.userid,u.autologout'; $db_users = DBSelect($sql); + $usr_cnt = 0; $online_cnt = 0; while($user=DBFetch($db_users)){ -- cgit