- [DEV-175] added last login time to users tab (Artem)

git-svn-id: svn://svn.zabbix.com/trunk@5760 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 14 insertions, 9 deletions

diff --git a/frontends/php/users.php b/frontends/php/users.php
index 6749fa36..99f10ec1 100644
--- a/frontends/php/users.php
+++ b/frontends/php/users.php
@@ -469,18 +469,23 @@ include_once "include/page_header.php";
 			while($db_user=DBfetch($db_users)){
 //Log Out 10min or Autologout time
 				$online_time = (($db_user['autologout'] == 0) || (ZBX_USER_ONLINE_TIME<$db_user['autologout']))?ZBX_USER_ONLINE_TIME:$db_user['autologout'];
-				$db_sessions = DBselect('SELECT count(*) as count, max(s.lastaccess) as lastaccess'.
+				$online=new CCol(S_NO,"disabled");
+				
+				$sql = 'SELECT s.lastaccess'.
 						' FROM sessions s, users u'.
 						' WHERE s.userid='.$db_user['userid'].
 							' AND s.userid=u.userid '.
-							' AND (s.lastaccess+'.$online_time.')>='.time());
-
-				$db_ses_cnt=DBfetch($db_sessions);
-
-				if($db_ses_cnt["count"]>0)
-					$online=new CCol(S_YES.' ('.date('r',$db_ses_cnt['lastaccess']).')',"enabled");
-				else
-					$online=new CCol(S_NO,"disabled");
+						' ORDER BY lastaccess DESC';
+
+				$db_sessions = DBselect($sql,1);
+				if($db_ses_cnt=DBfetch($db_sessions)){
+					if(($db_ses_cnt['lastaccess']+$online_time) >= time()){
+						$online=new CCol(S_YES.' ('.date('r',$db_ses_cnt['lastaccess']).')',"enabled");
+					}
+					else{
+						$online=new CCol(S_NO.' ('.date('r',$db_ses_cnt['lastaccess']).')',"disabled");
+					}
+				}	
 				
 				$user_groups = array();
 				$db_groups = DBselect('SELECT g.name '.