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++;
$name = $row->name;
echo'
';
}
?>