header(); if (isset($_POST['chcat'])) { $kat = $_POST['cat']; } else $kat = 'showallcats'; $limit = 20; $page = ( $menu->getA(1) == 'p' ? $menu->getE(1) : 1 ); if ($menu->getA(2) == 'p') { $kat = $menu->get(1); $page = ( $menu->getA(2) == 'p' ? $menu->getE(2) : 1 ); } $MPL = db_make_sites ($page , "WHERE ".($kat == 'showallcats'?'':"news_kat = BINARY '$kat' AND ")."news_recht >= ".$_SESSION['authright'] , $limit , '?narchiv'.($kat == 'showallcats'?'':'-'.$kat) , 'news' ); $anfang = ($page - 1) * $limit; echo '
Kategorie:

'; $abf = "SELECT a.news_title as title, a.news_id as id, DATE_FORMAT(a.news_time,'%d. %m. %Y') as datum, DATE_FORMAT(a.news_time,'%W') as dayofweek, a.news_kat as kate, b.name as username, b.id as uid, c.name as editor, c.id as eid FROM prefix_news as a LEFT JOIN prefix_user as b ON a.user_id = b.id LEFT JOIN prefix_user as c ON a.editor_id = c.id WHERE ".($kat == 'showallcats'?'':"a.news_kat = BINARY '$kat' AND ") .$_SESSION['authright']." <= a.news_recht ORDER BY news_time DESC LIMIT $anfang,$limit"; echo ''; $erg = db_query($abf); while ($row = db_fetch_object($erg)) { $k0m = db_query("SELECT COUNT(ID) FROM `prefix_koms` WHERE uid = ".$row->id." AND cat = 'NEWS'"); $komm = db_result($k0m,0); echo ' '; } echo "
DatumTitelAutornameKategorieKommentareDrucken
'.$row->datum.' '.$row->title.''.$row->username.''.((!empty($row->editor) AND $row->uid != $row->eid) ? " (Last edit: $row->editor)":'').' '.$row->kate.'

('.$komm.')

$MPL
"; $design->footer(); ?>