//Lastforum
$query = "SELECT a.id, a.name, a.rep, a.erst, c.erst as last, c.id as pid, c.time
FROM prefix_topics a
LEFT JOIN prefix_forums b ON b.id = a.fid
LEFT JOIN prefix_posts c ON c.id = a.last_post_id
WHERE (b.view >= ".$_SESSION['authright']." OR b.reply >= ".$_SESSION['authright']." OR b.start >= ".$_SESSION['authright'].")
ORDER BY c.time DESC
LIMIT 0,10";
$class = array('Cnorm','Cmite');
$lastforum = '<table width="95%">';
$lastforum .= '<tr class="Chead" align="center"><th>Thema</th><th width="120">letzter Beitrag</th><th width="50">Beiträge</th></tr>';
$resultID = db_query($query);
while ($row = db_fetch_assoc($resultID)) {
$row['date'] = date('d.m.y - H:i',$row['time']);
$row['page'] = ceil ( ($row['rep']+1) / $allgAr['Fpanz'] );
$lastforum .= '<tr class="'.$class[0].'"><td valign="top"><b> » </b><a href="?forum-showposts-'.$row['id'].'-p'.$row['page'].'#'.$row['pid'].'"">'.((strlen($row['name'])<30) ? $row['name'] : substr($row['name'],0,27).'...').'<br /><span class="smalfont"> von '.$row['erst'].'</span></a></td><td>'.$row['last'].'<br /><span class="smalfont">'.$row['date'].'</td><td align="center">'.($row['rep']+1).'</td></tr>';
$class = array_reverse($class);
}
$lastforum .= '</table>';
//Lastforumende