Просмотр поста

$new = mysql_query("SELECT `id`, `preg`,`name`, `datereg` FROM `users` WHERE `preg` = 1 ORDER BY `datereg` DESC LIMIT 2");
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `users`"), 0);
$online = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `lastdate` > '" . (time() - 300) . "'"), 0);
$offline = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `lastdate` < '" . (time() - 300) . "'"), 0);
$total_man = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `sex` = 'm'"), 0);
$total_women = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `sex` = 'zh'"), 0);

$list = '';
while (($luzer = mysql_fetch_assoc($new)) !== false)
$list[] = '<a href="'.$set['homeurl'].'/users/profile.php?user='.$luzer['id'].'">'.$luzer['name'].'</a>';

echo 'New:&#160;'.functions::display_menu($list, '&#160;|&#160;').'<br>';
echo 'total:&#160;'. $total.'<br>';
echo 'Online:&#160;'.$online.'<br>';
echo 'Offline:&#160;'.$offline.'<br>';
echo 'Man:&#160;'.$total_man.'<br>';
echo 'Women:&#160;'.$total_women.'<br>';