$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();