// // ------------------------------------------------------------------------- // // Original Author: James Knickelbein // Author Website : http://www.journeymilwaukee.com // License Type : GPL: See /manual/LICENSES/GPL.txt // ------------------------------------------------------------------------- // include_once("header.php"); $bcoosConfig['title'] .= " - "._MI_MYDOWNLOADS_NAME; if ($bcoosConfig['startpage'] == "mydownloads") { $xoopsOption['show_rblock'] = 1; include_once(XOOPS_ROOT_PATH."/header.php"); make_cblock(); echo "
"; } else { $xoopsOption['show_rblock'] = 0; include_once(XOOPS_ROOT_PATH."/header.php"); } $mytree = new XoopsTree($db->prefix("mydownloads_cat"), "cid", "pid"); $result = $db->query("SELECT cid, title, imgurl FROM ".$db->prefix("mydownloads_cat")." WHERE pid=0 ORDER BY title") or die("Error"); OpenTable(); mainheader(); echo "
"; $count = 0; while ($myrow = $db->fetchArray($result)) { $title = $myts->makeTboxData4Show($myrow['title']); $totaldownload = getTotalItems($myrow['cid'], 1); echo ""; } $count++; if ($count == 2) { echo ""; $count = 0; } } echo "
"; if ( !empty($myrow['imgurl']) && $myrow['imgurl'] != "http://" ) { echo "$title
"; } echo "$title ($totaldownload)
"; // get child category objects $arr = array(); $arr = $mytree->getFirstChild($myrow['cid'], "title"); $space = 0; $chcount = 0; foreach($arr as $ele) { $chtitle = $myts->makeTboxData4Show($ele['title']); if ($chcount > 5) { echo "..."; break; } if ($space>0) { echo ", "; } echo "".$chtitle.""; $space++; $chcount++; } if ($count < 1) { echo "
"; list($numrows) = $db->fetchRow($db->query("SELECT COUNT(*) FROM ".$db->prefix("mydownloads_downloads")." WHERE status>0")); echo "

"; printf(_THEREARE, $numrows); echo "
"; if ($mydownloadsConfig['rss_enable'] == 1) { echo "
"; } CloseTable(); echo "
"; OpenTable(); echo "

"._LATESTLISTINGS."

"; showNew($mytree); echo "
"; CloseTable(); include_once(XOOPS_ROOT_PATH."/modules/mydownloads/footer.php"); //---------------------------------------------------------------------------------------// /** * Shows the Latest Listings on the front page * * @param type $var description * @return type description */ function showNew($mytree) { global $myts, $db, $bcoosConfig, $xoopsModule, $mydownloadsConfig; $sql = " SELECT lid, cid, title, url, homepage, version, size, platform, logourl, status, date, hits, rating, votes, comments, description FROM ".$db->prefix("mydownloads_downloads")." WHERE status>0 ORDER BY date DESC"; $result = $db->query($sql, $mydownloadsConfig['newdownloads'], 0); while (list($lid, $cid, $dtitle, $url, $homepage, $version, $size, $platform, $logourl, $status, $time, $hits, $rating, $votes, $comments, $description)=$db->fetchRow($result)) { $rating = number_format($rating, 2); $dtitle = $myts->makeTboxData4Show($dtitle); $url = $myts->makeTboxData4Show($url); $homepage = $myts->makeTboxData4Show($homepage); $version = $myts->makeTboxData4Show($version); $size = $myts->makeTboxData4Show($size); $platform = $myts->makeTboxData4Show($platform); $logourl = $myts->makeTboxData4Show($logourl); $datetime = formatTimestamp($time, "s"); $description = $myts->makeTareaData4Show($description, 1, 1, 1); include("include/dlformat.php"); } } ?>