Posted on: 12/05/03 04:01pm
By: pernas
function phpblock_5latest() { global $_CONF; $list = ""; $quer = mysql_query ("SELECT uid,lastlogin FROM gl_userinfo ORDER BY lastlogin DESC limit 5"); while ($line = mysql_fetch_array($quer)){ $uidsql= mysql_query ("SELECT username FROM gl_users WHERE uid=$line[uid]"); $uidresult = DB_fetchArray($uidsql); $lastlogin = mysql_query ("SELECT lastlogin FROM gl_userinfo WHERE uid=$line[uid]"); /* $lastlogin = DB_getItem (gl_userinfo, 'lastlogin', "uid = $line[uid]"); */ $lasttime = COM_getUserDateTimeFormat ($lastlogin); $list = $list.'<a href="'.$_CONF["site_url"].'/users.php?mode=profile&uid='.$line["uid"].'" title="'.$line["lastlogin"].'">'.$uidresul t[username]; $list = $list.'</a><br>'; } return $list; }