More online users list
Imran Offline
Member
***
Posts: 204
Joined: Apr 2010
Post: #2
RE: More online users list
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']."");
	");


[Image: logo.png]

[Image: twitter.png]
10-23-2010 02:56 AM
Visit this user's website Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Messages In This Thread
More online users list - 1master1 - 10-22-2010, 02:13 AM
RE: More online users list - Imran - 10-23-2010 02:56 AM
RE: More online users list - 1master1 - 10-23-2010, 03:27 AM
RE: More online users list - Imran - 10-23-2010, 05:17 AM
RE: More online users list - 1master1 - 10-23-2010, 09:43 AM
RE: More online users list - 1master1 - 10-26-2010, 09:27 PM
RE: More online users list - ZiNgA BuRgA - 10-26-2010, 10:31 PM
RE: More online users list - 1master1 - 10-26-2010, 11:49 PM
RE: More online users list - Midori - 06-07-2014, 04:02 PM

 Standard Tools
Forum Jump: