All pastes #676538 Raw Edit

Anonymous

public text v1 · immutable
#676538 ·published 2007-08-31 04:34 UTC
rendered paste body
<?php
echo('<TABLE BORDER=0>');
$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(" <TD ALIGN=CENTER>\n<a href='index.php?showuser=%s'>\n<BR><IMG SRC='uploads/%s' border='0' ><br>%s<BR></TD>"
, $topmemrow['id'], $topmemrow['pp_thumb_photo'], $topmemrow['members_display_name']
);



}
print('</TABLE>');
                                ?>
<br>
Online Members
<?php
echo('<marquee><TABLE BORDER=0>');
$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(" <TD ALIGN=CENTER>\n<a href='index.php?showuser=%s'>\n<BR><IMG SRC='uploads/%s' border='0' ><br>%s<BR></TD>"
, $topmemrow['id'], $topmemrow['pp_thumb_photo'], $topmemrow['members_display_name']
);