If users dont correct logout, Dashboard table is wrong in number of users.
This SQL is correct to file:include/blocks.inc.php - line 378
SELECT distinct (u.userid), max (s.lastaccess), u.autologout FROM users u LEFT JOIN sessions s ON s.userid=u.userid group by u.userid,u.autologout;
This SQL is correct to file:include/blocks.inc.php - line 378
SELECT distinct (u.userid), max (s.lastaccess), u.autologout FROM users u LEFT JOIN sessions s ON s.userid=u.userid group by u.userid,u.autologout;
Comment