Recent Forum Posts
2 AND
p.post_id = t.topic_last_post_id AND
p.poster_id = u.user_id
ORDER BY p.post_id DESC LIMIT $topicnumber";
$result = mysql_query($query) or die("Query failed");
print "
";
mysql_free_result($result);
$query = "SELECT *
FROM $table_attachments a
WHERE mimetype LIKE 'image%'
ORDER BY a.filetime desc
LIMIT 6";
//echo $query;
$result = mysql_query($query) or die("Query failed");
echo "
";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$filebase = $row[physical_filename];
// concat the directory and file extension
$file = "forum/files/" . $filebase;
$new_height = 80;
$thumbPrefix = "forum_thumbs/" . $filebase;
$thumbfile = makeThumb($file,$thumbPrefix,$new_height);
//echo "
";
//'echo "| $row[physical_filename] | ";
echo "";
echo "
";
//echo "
\n";
}
mysql_free_result($result);
$query = "SELECT s.session_user_id, s.session_time,u.username, u.user_id
FROM $table_sessions s, $table_users u
WHERE session_user_id = user_id and
(UNIX_TIMESTAMP() - s.session_time) < (5 * 60)";
$result = mysql_query($query) or die("Query failed");
$anonymous = 0;
$online_count = 0;
$who_is_online = "";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
if ($row[username_clean] != 'anonymous') {
$who_is_online .= $row['username'] . ', ';
$online_count ++;
}
else
{
$anonymous ++;
$online_count++;
}
//echo "
";
//echo "\n";
}
if ($anonymous > 0) {
$who_is_online .= 'guests(' . $anonymous . ')';
}
if ($online_count > 0) {
echo '
Who is online - ';
echo $who_is_online;
echo '
';
}
mysql_free_result($result);
mysql_close($link);
?>
