Geeklog Forums

function phpblock_whos_new2()
{
    global $_CONF,$_TABLES;

    // Set the number of new members to show
    $numToShow = 5;

    $result = DB_query("SELECT uid,username,photo FROM {$_TABLES['users']} ORDER BY regdate DESC limit $numToShow");

    $nrows = DB_numRows($result);
    for ($i = 1; $i <= $nrows; $i++) {
        $A = DB_fetchArray($result);
        $retval .= '<a href="' . $_CONF['site_url'] . '/users.php?mode=profile&uid=' . $A['uid'] . '">' . $A['username'] .
 '</a>';
        if (!empty($A['photo']) AND $_CONF['allow_user_photo'] == 1) {
            $retval .= ' <a href="' . $_CONF['site_url'] . '/users.php?mode=profile&uid=' . $A['uid'] . '"><img src="
' . $_CONF['layout_url'] . '/images/smallcamera.gif" border="0"></a>';
        }
        $retval .= '<br>';
    }
    //Get Total Number of Members
    $result = DB_query("Select count(email) FROM {$_TABLES['users']}");
    $B = DB_fetchArray($result);
    $retval .= '<center><BR><B>' . $B['count(email)'] . ' members at NEOHM</b></center>';
    return $retval;
}