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

    $f = 0;
    $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 == $maxftopics)  break;
                if(fintern($get['kid']))
        {
          $lp = cnt($db['f_posts'], " WHERE sid = '".$get['id']."'");


          $lposter = _fetch(db("SELECT reg,nick,email subid FROM ".$db['f_posts']." WHERE sid = '".$get['id']."' ORDER BY date ASC LIMIT 1"));
          if ( $lp < 1 ) $alp = rawautor($get['t_reg'], '', $get['t_nick'], $get['t_email']);
          else $alp = rawautor($lposter['reg'], '', $lposter['nick'], $lposter['email']);



          $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><tr><td><b>Von :</b></td><td>'.$alp.'</td></tr>\')" onmouseout="DZCP.hideInfo()"';
          if ( $f != 0 ) $ftopics .= '<tr><td class="navFtopicsContent" colspan="3" align="center"><center><img src="../inc/_templates_/dzcp-addons.de/img/img_43.png" width="95%" height="1" style="color:#C0C0C0; background: #C0C0C0;" alt=""/></center></td></tr>';
          $ftopics .= show("menu/forum_topics", array("id" => $get['id'],
                                                      "pagenr" => $page,
                                                      "p" => $lp +1,
                                                      "titel" => cut(re($get['topic']),$lftopics),
                                                      "autor" => $alp,
                                                      "info" => $info,
                                                      "kid" => $get['kid']));
          $f++;
        }
      }
  return empty($ftopics) ? '' : '<table class="navContent" cellspacing="0">'.$ftopics.'</table>';
}
?>