here is the previous john cms 2.40 separate online online list for male and female users
require_once ("../incfiles/core.php");
require_once ("../incfiles/head.php");
echo '<div class="phdr">Whos online?</div>';
$onltime = $realtime - 5000;
$q = @mysql_query("select * from `users` where lastdate>='" . intval($onltime) . "' and sex1 ='man' and sex ='m';");
$count = mysql_num_rows($q);but how to change in in johncms 3.0
$onltime = $realtime - 300;
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `" . ($act == 'guest' ? 'cms_guests' : 'users') . "` WHERE `lastdate` > '$onltime'"), 0);
if ($total) {
$req = mysql_query("SELECT * FROM `" . ($act == 'guest' ? 'cms_guests' : 'users') . "` WHERE `lastdate` > '$onltime' ORDER BY " . ($act == 'guest' ? "`movings` DESC" : "`name` ASC") . " LIMIT $start,$kmess");
while ($res = mysql_fetch_assoc($req)) {