$navbits += $dl->build_cat_nav($cleancatid);
$result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "dl_cats WHERE " . $catexclude . " `parent` = " . $cleancatid . " ORDER BY " . $dl->order);
if ($db->num_rows($result) > 0) {
while ($sub = $db->fetch_array($result)) {
if ($dl->hidesubcatssub == 0) {
$subcats = $dl->grab_subcats_by_name_client($sub['id']);
} else {
$subcats = '';
}
$files = vb_number_format($sub['files']);
exec_switch_bg();
eval('$dsubbits .= "' . fetch_template('downloads_cat_subbit') . '";');
}
eval('$dsubcats .= "' . fetch_template('downloads_cat_subs') . '";');
}
$filesexclude = $dl->exclude_files();
$temp = $db->query_first("SELECT COUNT(*) as files FROM " . TABLE_PREFIX . "dl_files WHERE " . $filesexclude . " `category` = " . $cleancatid);
if ($temp['files'] == 0 and $db->num_rows($result) == 0) {
eval(print_standard_redirect('ecdownloads_msg_no_files_in_cat', true, true));
}
$db->free_result($result);
$sortfield = $vbulletin->input->clean_gpc('r', 'sortfield', TYPE_STR);
$sortfields = array('name', 'date', 'downloads', 'last', 'rating', 'comments');
if (!in_array($sortfield, $sortfields)) {
$sortfield = 'date';
}
$pagenumber = $vbulletin->input->clean_gpc('r', 'pagenumber', TYPE_UINT);
sanitize_pageresults($temp['files'], $pagenumber, $dl->perpage, $dl->perpage, $dl->perpage);
$limit = ($pagenumber - 1) * $dl->perpage;
$navigation = construct_page_nav($pagenumber, $dl->perpage, $temp['files'], "downloads.php?" . $vbulletin->session->vars['sessionurl'] . "do=cat&id={$cleancatid}", "" . (!empty($sortfield) ? "&sort={$sortfield}" : ""));
if ($sortfield == 'name') {
