Alle Themen im Freiheitforum'; echo '

'; echo 'Neues Thema'; echo '

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; //page definiert die Seite fuer die Anzeige von 20 Beitraegen $p = (isset($_GET['page'])) ? intval($_GET['page']) : 0; $limit = " LIMIT ". $p*25 . " , 25"; $qulm = "SELECT COUNT(b.id) AS counter, t.text,t.id,b.name,b.timestamp FROM ff_thema AS t LEFT JOIN (SELECT * FROM ff_beitrag ORDER BY timestamp DESC) AS b ON b.thema_id = t.id WHERE b.status < 2 GROUP BY t.id ORDER BY b.timestamp DESC"; $result = mysql_query($qulm.$limit) or trigger_error(mysql_error()); while($row = mysql_fetch_array($result)){ foreach($row AS $key => $value) { $row[$key] = stripslashes($value); } $i++; if ($i % 2 == 0) { echo ''; } else { echo ''; } echo ''; echo ''; echo ''; echo ''; } echo '

	Thema	Letzte Antwort
'; if ($_COOKIE["last"] < strtotime($row['timestamp']) && $row['counter'] > 9) { echo ''; } else if ($_COOKIE["last"] < strtotime($row['timestamp'])) { echo ''; } else if ($row['counter'] > 9) { echo ''; } else { echo ''; } echo '	' . htmlspecialchars($row['text']) . '	' . nl2br( $row['name']) . ' (' . date('d.m.Y H:i', strtotime($row['timestamp'])) . ')

'; //Symbolerklaerung echo '

'; echo '

neuer Beitrag seit deinem letzten Besuch | '; echo '

Thema mit mehr als 10 Beiträgen'; echo '

'; //listenseitennavigation $tresult = mysql_query("SELECT COUNT(*) FROM `ff_thema`") or trigger_error(mysql_error()); $threads = mysql_fetch_row($tresult); $j = 0; $m = ceil($threads[0]/25); echo '

Seite'; while ($j < $m) { if(($j == 0) || ($j-1 == $p) || ($j == $p) || ($j+1 == $p) || ($j+1 == $m)) { echo ($j > 0) ? ' | ' : ' '; echo ($j == $p) ? '' : ''; echo $j+1; echo ($j == $p) ? '' : ''; } elseif(($j-2 == $p) || ($j+2 == $p)) { echo ' | ...'; } $j++; } echo '

'; include('footer.php'); ?>