I've made another "Who's New" block. It displays all new members in an ordered list starting with the newest member.
Text Formatted Code
function phpblock_whosnew() {
global $_CONF,$_TABLES,$_DB_table_prefix;
$retval='<p><center><i>Newest first</i></center></p>';
// Set the number of new members to show
$numToShow = 7;
$result = DB_query("SELECT uid,username,photo FROM `".$_DB_table_prefix."users` ORDER BY regdate DESC limit $numToShow");
$nrows = DB_numRows($result);
for ($i = 1; $i <= $nrows; $i++) {
$A = DB_fetchArray($result);
if (!empty($A['photo']) && $_CONF['allow_user_photo'] == 1) {
$retval .= '<ol compact start='.$i.'><li><a href="' . $_CONF['site_url'] . '/users.php?mode=profile&uid=' . $A['uid'] . '">' .$A['username']
.'</a> <a href="' . $_CONF['site_url'] . '/users.php?mode=profile&uid=' . $A['uid'] . '"><img src="' . $_CONF['layout_url']
. '/images/smallcamera.gif" border="0"></a></li></ol>';
}
elseif (empty($A['photo']) || $_CONF['allow_uer_photo'] == 0) {
$retval .= '<ol compact start='.$i.'><li><a href="' . $_CONF['site_url'] . '/users.php?mode=profile&uid=' . $A['uid'] . '">' .$A['username'] .'</a></li></ol>';
}
}
return $retval;
}