diff options
| author | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-06-17 15:18:03 +0000 |
|---|---|---|
| committer | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-06-17 15:18:03 +0000 |
| commit | 01e94d67317be183b74fa97bd3d15ee99ab27d69 (patch) | |
| tree | ab0b8c8e4a6fa804f4171fcc42f5add9cf72eb13 /frontends/php/include/blocks.inc.php | |
| parent | 717eb6f9ed27471f3213d188d29bd267ff726a0f (diff) | |
- [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
Diffstat (limited to 'frontends/php/include/blocks.inc.php')
| -rw-r--r-- | frontends/php/include/blocks.inc.php | 7 |
1 files changed, 5 insertions, 2 deletions
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)){ |