$countsql = DB_query($sql);
list($maxrows) = DB_fetchArray($countsql);
$numpages = ceil($maxrows / $show);
$p->set_var('block_header', COM_startBlock(sprintf(_MD_LISTINGHEADING, $maxrows)));
$p->set_var('block_footer', COM_endBlock());
$count = 0;
if ($nrows > 0) {
// Display the categories - Top Level (plus #files) with links to sub categories
for ($i = 1; $i <= $nrows; $i++) {
$myrow = DB_fetchArray($result);
$secGroup = DB_getItem($_TABLES['groups'], "grp_name", "grp_id='{$myrow['grp_access']}'");
if (SEC_inGroup($secGroup)) {
$p->set_var('cid', $myrow['cid']);
$p->set_var('category_name', $myts->makeTboxData4Show($myrow['title']));
if ($mydownloads_useshots && $myrow['imgurl'] && $myrow['imgurl'] != "http://") {
$imgurl = $myts->makeTboxData4Edit($myrow['imgurl']);
$category_image_link = '<a href="' . $_CONF[site_url] . '/filemgmt/viewcat.php?cid=' . $myrow['cid'] . '">' . '<img src="' . $filemgmt_SnapCatURL . $imgurl . '" width="' . $mydownloads_shotwidth . '" style="border:none;" alt=""' . XHTML . '></a>';
$p->set_var('category_link', $category_image_link);
} else {
$p->set_var('category_link', '');
}
$downloadsWaitingSubmission = getTotalItems($myrow['cid'], 0);
$p->set_var('num_files', getTotalItems($myrow['cid'], 1));
if ($downloadsWaitingSubmission > 0) {
$p->set_var('files_waiting_submission', '(' . getTotalItems($myrow['cid'], 0) . ')');
} else {
$p->set_var('files_waiting_submission', '');
}
// get child category objects
$subcategories = '';
$arr = array();
