<?php
function ftopics()
{
global $db,$maxftopics,$lftopics,$maxfposts,$allowHover;

$f = 1;
$qry = db("SELECT s1.*,s2.id AS subid FROM ".$db['f_threads']." s1, ".$db['f_skats']." s2, ".$db['f_kats']." s3
WHERE s1.kid = s2.id AND s2.sid = s3.id ORDER BY s1.lp DESC LIMIT 100");
while($get = _fetch($qry))
{
if($f == $maxfposts) break;
if(fintern($get['kid']))
{
$lp = cnt($db['f_posts'], " WHERE sid = '".$get['id']."'");
$pagenr = ceil($lp/$maxfposts);

if($pagenr == 0) $page = 1;
else $page = $pagenr;

if($allowHover == 1)
$info = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>'.jsconvert(re($get['topic'])).'</td></tr><tr><td><b>'._forum_posts.':</b></td><td>'.$lp.'</td></tr><tr><td><b>'._forum_lpost.':</b></td><td>'.date("d.m.Y H:i", $get['lp'])._uhr.'</td></tr>\')" onmouseout="DZCP.hideInfo()"';

$ftopics .= show("menu/forum_topics", array("id" => $get['id'],
"pagenr" => $page,
"p" => $lp +1,
"titel" => cut(re($get['topic']),$lftopics),
"info" => $info,
"forumpostl" => $lp,
"kid" => $get['kid']));
$f++;
}
}
return empty($ftopics) ? '' : '<table class="navContent" cellspacing="0">'.$ftopics.'</table>';
}
?>