= %d AND u.uid != 0 and u.access>0 GROUP BY u.uid, u.name, u.created ORDER BY max(ur.rid ) DESC, u.created DESC', time() - 1209600 ); $total_users = db_num_rows($users); print '
The latest Buffers to join InTheBuff.co.uk are :-
Supporters
';
$supps='';
$nsups='';
$scol=0;
$ncol=0;
while ($uid = db_fetch_object($users))
{
$thisuser=user_load(array('uid' => $uid->uid));
$issupporter= db_query('SELECT rid from users_roles WHERE ( ( uid='.$thisuser->uid.' ) and ( rid=5 ) )');
//first work out what we put in the box
//is the person looking a subscriber
if (in_array('manualsub',$user->roles))
{
//have they got a picture
if ($thisuser->picture && file_exists($thisuser->picture))
{
$picture = file_create_url($thisuser->picture);
$boxfill='
'.theme('username',$thisuser);
}
else
{
$boxfill='
'.theme('username',$thisuser);
}
}
else
{
//not a supporter lets put an ad
$boxfill="uid.'&amount=7'>Subscribe now and
see the photos
not adverts
".cj_type().'
'.theme('username',$thisuser);
}
//now create 2 lots supporters and non-supporters
if (db_num_rows($issupporter)>0)
{
if ($scol==0)
{
$supps.="";
}
$supps.=' ";
$scol=0;
}
}
else
{
if ($ncol==0)
{
$nsups.="'.$boxfill.' ';
$scol++;
if ($scol==2)
{
$supps.="";
}
$nsups.=" ";
$ncol=0;
}
}
//if () {
}
print '".$boxfill.' ';
$ncol++;
if ($ncol==3)
{
$nsups.="
| ';} print ' |
| ";} if ($ncol==1){print " | ";} print ' |