(GPLv2)
or write to the Free Software Foundation, Inc., 51 Franklin Street,
Fifth Floor, Boston, MA02110-1301, USA.
********************************************************************************/
if (stristr(htmlentities($_SERVER['PHP_SELF']), "block_forum_lateral.php")) {
die("
Error: This file cannot be opened directly! |
");
}
require_once("pages/forum/inc_functions.php");
global $dblink,$siteConfig;
$myrank = $myRank();
$result = $dblink->get_list("SELECT p.id,p.lastchild,p.name,DATE_FORMAT(d.date,'".$siteConfig['timestamp']."') as date,d.author,(SELECT COUNT(*) FROM memht_forum_posts WHERE id=p.id OR parent=p.id) AS pstnum FROM memht_forum_posts AS p JOIN memht_forum_forums AS f JOIN memht_forum_posts AS d ON p.forum=f.id AND p.lastchild=d.id WHERE f.auth_view<=$myrank AND f.auth_read<=$myrank ORDER BY p.lastchild DESC LIMIT 20");
foreach ($result as $row) {
$bid = intval($row['id']);
$blastchild = intval($row['lastchild']);
$btitle = outCode($row['name'],0);
$bdate = $row['date'];
$bauthor = outCode($row['author']);
$pstnum = intval($row['pstnum']);
$link = "index.php?page=forum&op=viewThread&id=$bid&title=".mem_urlencode($btitle);
if ($pstnum>10) { $link .= "&pg=".ceil($pstnum/10); }
if ($bid!=$blastchild) { $link .= "#post{$blastchild}"; }
echo "\n";
}
?>