Posted on: 11/08/04 04:50pm
By: mrb42
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; }
Posted on: 12/22/05 03:54pm
By: 1000ideen