phpBB.de

Code: Alles auswählen

$template->assign_block_vars('last_seen_row',

Code: Alles auswählen

//
// last seen hack
//
$sql = "SELECT username, user_id, user_lastvisit FROM " . USERS_TABLE . " WHERE user_id > 0 AND username <> 'Anonymous' ORDER BY user_lastvisit DESC LIMIT " . $CFG['last_seen'];
if (!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, 'Could not query last seen information', '', __LINE__, __FILE__, $sql);
}
$number_last_seen = $db->sql_numrows($result);
$last_seen_row = array();
while ($row = $db->sql_fetchrow($result))
{
	$last_seen_row[] = $row;
}
for ($i = 0; $i < $number_last_seen; $i++)
{
	$template->assign_block_vars('last_seen_row', array(
		'U_LSEEN_LINK'     => append_sid("profile.$phpEx?mode=viewprofile&u=".$last_seen_row[$i]['user_id']),
		'L_LSEEN_USERNAME' => $last_seen_row[$i]['username'],
		'L_LSEEN_TIME'     => date("m.d.y H:i", $last_seen_row[$i]['user_lastvisit']))
	);
}
//
// END: last seen hack
//

Code: Alles auswählen

 message_die(GENERAL_ERROR, 'Could not query last seen information', '', __LINE__, __FILE__, $sql);

Code: Alles auswählen

$sql = "SELECT username, user_id, user_lastvisit FROM " . USERS_TABLE . " WHERE user_id > 0 AND username <> 'Anonymous' ORDER BY user_lastvisit DESC LIMIT 0,5";

Code: Alles auswählen

                <td><img src="templates/fiappleblue/images/tb12_r.gif" width="10" height="12" alt=