');
$topmember = @mysql_query("SELECT m.id, m.members_display_name, g.g_title, CASE WHEN pp_thumb_photo ='' THEN 'generic_thumb.png' ELSE pp_thumb_photo END AS pp_thumb_photo
FROM ibf_sessions s
JOIN ibf_members m ON (s.member_id=m.id)
JOIN ibf_groups g ON (s.member_group=g.g_id)
JOIN ibf_profile_portal pp ON (pp.pp_member_id = m.id)
WHERE s.running_time > 0
AND g.g_title='administrators';");
while ($topmemrow = mysql_fetch_array($topmember) ) {
printf(" \n\n
%s
| "
, $topmemrow['id'], $topmemrow['pp_thumb_photo'], $topmemrow['members_display_name']
);
}
print('');
?>
Online Members
');
$topmember = @mysql_query("SELECT m.id, m.members_display_name, g.g_title, pp.pp_thumb_photo
FROM ibf_sessions s
JOIN ibf_members m ON (s.member_id=m.id)
JOIN ibf_groups g ON (s.member_group=g.g_id)
JOIN ibf_profile_portal pp ON (pp.pp_member_id = m.id)
WHERE s.running_time > 0
AND g.g_title='members';");
while ($topmemrow = mysql_fetch_array($topmember) ) {
printf(" \n\n
%s
| "
, $topmemrow['id'], $topmemrow['pp_thumb_photo'], $topmemrow['members_display_name']
);