= '.$_SESSION['authright'].' AND `show` > 0 AND `show` <= UNIX_TIMESTAMP() AND news_id != '.$tn_id.' AND archiv != 1 AND (endtime IS NULL OR endtime > UNIX_TIMESTAMP()) ORDER BY news_time DESC LIMIT 0,5'; $erg = db_query($abf); while ($row = db_fetch_object($erg)) { if ($row->news_kat == 'css') { $kat = 'CS:Source'; } elseif ($row->news_kat == 'wc3') { $kat = 'Warcraft 3'; } elseif ($row->news_kat == 'cs') { $kat = 'Counterstrike'; } else { $kat = $row->news_kat; } $k0m = db_query("SELECT COUNT(ID) FROM `prefix_koms` WHERE uid = ".$row->news_id." AND cat = 'NEWS'"); $k0m = db_result($k0m,0); echo '
'.$kat.' '.$row->datum.' '.((strlen($row->news_title)<30) ? $row->news_title : substr($row->news_title,0,27).'...').' '.$k0m.' Kommentare
'; } ?>