More online users list

[Imran]

You want to make a limit of users ? If yes, You have to use query something like this query;

PHP Code:

1 2 3 4 5 6 7 8

$query = $db->query(" SELECT u.* FROM ".TABLE_PREFIX."users u LEFT JOIN ".TABLE_PREFIX."usergroups g ON (g.gid=u.usergroup) WHERE u.lastactive > $stime ORDER BY u.lastactive DESC LIMIT ".$mybb->settings['how_many_users'].""); ");

---