Forum Preview

08/12/03 07:13am

Status: offline

pernas

Forum User

Newbie

Registered: 15/11/03

Posts: 7

Hi!

I just wanted to give you this block that shows the site "5 last logged in" users with date and time.

Thanks to everyone (Squatty for his session-block) which helped me with this.

Regards,
Per

PHP Formatted Code
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,photo FROM gl_users WHERE uid=$line[uid]");
$uidresult= DB_fetchArray($uidsql);
$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="'.$lasttime[0].'">'.$uidresult[username
];

if($uidresult[photo]!=""){
$list=$list.' <img src="'.$_CONF['layout_url'].'/images/smallcamera.gif" border="0" alt="">';
}
$list=$list.'</a><br>';
}
return$list;
}

30/12/03 04:57pm

Striker

Anonymous

Really nice idea for a block, decided to add it to my site, but noticed there were some problems.

Here's some better code that doesnt guess table names, hides invisible users, and doesnt show 'Anonymous'

PHP Formatted Code
function phpblock_5latest()
{
global$_CONF,$_TABLES;
$list="";
$quer=mysql_query("SELECT u.uid,u.lastlogin,p.showonline FROM {$_TABLES['userinfo']} AS u, {$_TABLES['userprefs']} AS p WHERE u.uid = p.uid AND u.uid != '1' AND p.showonline = '1' ORDER BY lastlogin DESC limit 5");

while($line=mysql_fetch_array($quer)){
$uidsql=mysql_query("SELECT username,photo FROM {$_TABLES['users']} WHERE uid=$line[uid]");
$uidresult= DB_fetchArray($uidsql);
$lastlogin= DB_getItem ($_TABLES['userinfo'],'lastlogin',"uid = $line[uid]");
$lasttime= COM_getUserDateTimeFormat ($lastlogin);

$list=$list.'<a href="'.$_CONF["site_url"].'/users.php?mode=profile&uid='.$line["uid"].'" title="'.$lasttime[0].'">'.$uidresult[username];

if($uidresult[photo]!=""){
$list=$list.' <img src="'.$_CONF['layout_url'].'/images/smallcamera.gif" border="0" alt="">';
}
$list=$list.'</a><br>';
}

return$list;
}

pernas

Striker

geKow

pernas

arthur

jetshack

ScurvyDawg