\n";
$result = dbquery("SELECT * FROM ".DB_DOWNLOAD_CATS." WHERE ".groupaccess('download_cat_access')." ORDER BY download_cat_name");
$rows = dbrows($result);
if ($rows) {
$counter = 0; $columns = 2;
echo "\n\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) { echo "
\n\n"; }
$num = dbcount("(download_cat)", DB_DOWNLOADS, "download_cat='".$data['download_cat_id']."'");
echo "".$data['download_cat_name']." ($num)";
if ($data['download_cat_description'] != "") { echo "
\n".$data['download_cat_description'].""; }
echo " | \n" ;
$counter++;
}
echo "
\n
\n";
} else {
echo "
\n".$locale['430']."
\n
\n";
}
echo "";
closetable();
} else {
$res = 0;
$result = dbquery("SELECT * FROM ".DB_DOWNLOAD_CATS." WHERE download_cat_id='".$_GET['cat_id']."'");
if (dbrows($result) != 0) {
$cdata = dbarray($result);
if (checkgroup($cdata['download_cat_access'])) {
$res = 1;
add_to_title($locale['global_201'].$cdata['download_cat_name']);
opentable($locale['400'].": ".$cdata['download_cat_name']);
echo "";
$rows = dbcount("(*)", DB_DOWNLOADS, "download_cat='".$_GET['cat_id']."'");
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($rows != 0) {
$result = dbquery("SELECT * FROM ".DB_DOWNLOADS." WHERE download_cat='".$_GET['cat_id']."' ORDER BY ".$cdata['download_cat_sorting']." LIMIT ".$_GET['rowstart'].",15");
$numrows = dbrows($result); $i = 1;
while ($data = dbarray($result)) {
if ($data['download_datestamp'] + 604800 > time() + ($settings['timeoffset'] * 3600)) {
$new = " ".$locale['410']."";
} else {
$new = "";
}
echo "\n";
echo "\n| ".$data['download_title']." $new | \n
\n";
if ($data['download_description']) { echo "\n| ".nl2br(stripslashes($data['download_description']))." | \n
\n"; }
echo "\n| ".$locale['411']." ".$data['download_license']." | \n".$locale['412']." ".$data['download_os']." | \n";
echo "".$locale['413']." ".$data['download_version']." | \n
\n\n| ".$locale['414']." ".showdate("shortdate", $data['download_datestamp'])." | \n";
echo "".$locale['415']." ".$data['download_count']." | \n".$locale['416']." (".$data['download_filesize'].") | \n
\n";
echo "
\n";
if ($i != $numrows) { echo "\n"; $i++; }
}
closetable();
if ($rows > 15) { echo "\n".makepagenav($_GET['rowstart'], 15, $rows, 3, FUSION_SELF."?cat_id=".$_GET['cat_id']."&")."\n
\n"; }
} else {
echo "".$locale['431']."
\n";
echo "";
closetable();
}
}
}
if ($res == 0) { redirect(FUSION_SELF); }
}
require_once THEMES."templates/footer.php";
?>