function breadcrumb($id, $getfrom = "F")
{
$sep = "<span class='bcsep'>";
$sep .= " · ";
$sep .= "</span>";
if ($getfrom == "P") {
$sql = "SELECT forum_id, subject FROM posts WHERE id = " . $id;
$result = mysql_query($sql) or die(mysql_error() . "<br />" . $sql);
$row = mysql_fetch_array($result);
$id = $row['forum_id'];
$topic = $row['subject'];
}
$row = getForum($id);
$bc = "<a href='frm_index.php'>Home</a>{$sep}";
switch ($getfrom) {
case "P":
$bc .= "<a href='frm_view_forum.php?f={$id}'>" . $row['name'] . "</a>{$sep}" . $topic;
break;
case "F":
$bc .= $row['name'];
break;
default:
}
return "<h4 class='breadcrumb'>" . $bc . "</h4>";
}
<?php
require_once 'db.member.inc.php';
require_once 'frm_functions.inc.php';
require_once 'frm_http.inc.php';
if (!isset($_GET['f'])) {
redirect('frm_index.php');
}
require_once 'frm_header.inc.php';
$forumid = $_GET['f'];
$forum = getForum($forumid);
echo breadcrumb($forumid, "F");
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
$limit = $admin['pageLimit']['value'];
if ($limit == "") {
$limit = 25;
}
$start = ($page - 1) * $admin['pageLimit']['value'];
$sql = "CREATE TEMPORARY TABLE tmp ( " . "topic_id INT(11) NOT NULL DEFAULT 0, " . "postdate datetime NOT NULL default '0000-00-00 00:00:00');";
mysql_query($sql) or die(mysql_error() . "<br />" . $sql);
$sql = "LOCK TABLES forum_users READ, forum_posts READ;";
mysql_query($sql) or die(mysql_error() . "<br />" . $sql);
$sql = "INSERT INTO tmp SELECT topic_id, MAX(date_posted) " . "FROM forum_posts " . "WHERE forum_id = {$forumid} " . "AND topic_id > 0 " . "GROUP BY topic_id;";
mysql_query($sql) or die(mysql_error() . "<br />" . $sql);
$sql = "UNLOCK TABLES";
mysql_query($sql) or die(mysql_error() . "<br />" . $sql);
// die('stop');
