exposing the dark side of adoption
Register Log in

User list

public

0 AND n.type = "uprofile" ORDER BY u.access DESC'; $sql2 = 'SELECT COUNT(u.uid) as count FROM {node} n INNER JOIN {bio} b ON n.nid = b.nid INNER JOIN {content_type_uprofile} up ON n.nid = up.nid AND n.vid = up.vid INNER JOIN {users} u ON u.uid = b.uid WHERE u.status = 1 AND u.login <> 0 AND n.type = "uprofile"'; $result = pager_query($sql, 20, 0, $sql2); print '

'; while ($data = db_fetch_object($result)) { print '
'; if($data->picture != ''){ print '
'; } print '
'; print ''; print '
' . $data->status . '
'; } print '

'; print theme('pager', NULL, 20);?>

by Admin on Tuesday, 25 August 2009