Newest Downloads';
$erg = db_query("SELECT prefix_downloads.cat,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%Y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by prefix_downloads.id DESC LIMIT 0,5");
$i = 0;
while ($row = db_fetch_object($erg)) {
$i++;
$user = $row->name;
echo'
';
}
echo '
Top Downloads';
$a = 0;
$erg = db_query("SELECT prefix_downloads.cat,hits,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%Y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by hits DESC LIMIT 0,5");
while ($row = db_fetch_object($erg)) {
$a++;
if(strlen($row->name) > $laenge ){
$row->name = substr($row->name, 0, $laenge ).'...';
}
echo'
';
}
?>