" . $_LANG['globalsystemname'] . " > " . $_LANG['downloadstitle'] . "";
$pageicon = "images/downloads_big.gif";
initialiseClientArea($pagetitle, $pageicon, $breadcrumbnav);
$dlcats = array( );
$action = $whmcs->get_req_var('action');
if( isset($catid) && !is_numeric($catid) )
{
redir();
}
if( isset($id) && !is_numeric($id) )
{
redir();
}
$proddlrestrict = !$CONFIG['DownloadsIncludeProductLinked'] ? " AND productdownload=''" : '';
$smartyvalues['seofriendlyurls'] = $CONFIG['SEOFriendlyUrls'];
$usingsupportmodule = false;
if( $CONFIG['SupportModule'] )
{
if( !isValidforPath($CONFIG['SupportModule']) )
{
exit( "Invalid Support Module" );
}
$supportmodulepath = 'modules/support/' . $CONFIG['SupportModule'] . "/downloads.php";
if( file_exists($supportmodulepath) )
{
$usingsupportmodule = true;
$templatefile = '';
require($supportmodulepath);
outputClientArea($templatefile);
exit();
}
}
if( $action == 'displaycat' || $action == 'displayarticle' )
{
$result = select_query('tbldownloadcats', '', array( 'id' => $catid ));
$data = mysql_fetch_array($result);
$catid = $data['id'];
if( !$catid )
{
redirSystemURL('', "downloads.php");
}
$catparentid = $data['parentid'];
$catname = $data['name'];
if( $CONFIG['SEOFriendlyUrls'] )
{
$catbreadcrumbnav = " > " . $catname . "";
}
else
{
$catbreadcrumbnav = " > " . $catname . "";
}
while( $catparentid != '0' )
{
$result = select_query('tbldownloadcats', '', array( 'id' => $catparentid ));
$data = mysql_fetch_array($result);
$cattempid = $data['id'];
$catparentid = $data['parentid'];
$catname = $data['name'];
if( $CONFIG['SEOFriendlyUrls'] )
{
$catbreadcrumbnav = " > " . $catname . "" . $catbreadcrumbnav;
}
else
{
$catbreadcrumbnav = " > " . $catname . "" . $catbreadcrumbnav;
}
}
$breadcrumbnav .= $catbreadcrumbnav;
}
if( $action == 'search' )
{
$breadcrumbnav .= " > Search";
}
$smarty->assign('breadcrumbnav', $breadcrumbnav);
if( $action == 'displaycat' )
{
$templatefile = 'downloadscat';
$i = 1;
for( $result = select_query('tbldownloadcats', '', array( 'parentid' => $catid, 'hidden' => '' ), 'name', 'ASC'); $data = mysql_fetch_array($result); $i++ )
{
$idkb = $data['id'];
$dlcats[$i] = array( 'id' => $idkb, 'name' => $data['name'], 'urlfriendlyname' => getModRewriteFriendlyString($data['name']), 'description' => $data['description'] );
$idnumbers = array( );
$idnumbers[] = $idkb;
dlgetcatids($idkb);
$queryreport = '';
foreach( $idnumbers as $idnumber )
{
$queryreport .= " OR category='" . $idnumber . "'";
}
$queryreport = substr($queryreport, 4);
$dlcats[$i]['numarticles'] = get_query_val('tbldownloads', "COUNT(*)", "(" . $queryreport . ") AND hidden=''" . $proddlrestrict);
}
$smarty->assign('dlcats', $dlcats);
$result = select_query('tbldownloads', '', "category=" . $catid . " AND hidden=''" . $proddlrestrict, 'title', 'ASC');
$downloads = createdownloadsarray($result);
$smarty->assign('downloads', $downloads);
}
else
{
if( $action == 'search' )
{
check_token();
if( !trim($search) )
{
redir();
}
$templatefile = 'downloadscat';
$result = select_query('tbldownloads', "tbldownloads.*", "(title like '%" . db_escape_string($search) . "%' OR tbldownloads.description like '%" . db_escape_string($search) . "%') AND tbldownloads.hidden='' AND tbldownloadcats.hidden=''" . $proddlrestrict, 'title', 'ASC', '', "tbldownloadcats ON tbldownloadcats.id=tbldownloads.category");
$downloads = createdownloadsarray($result);
$smarty->assign('search', $search);
$smarty->assign('downloads', $downloads);
}
else
{
$templatefile = 'downloads';
$i = 1;
for( $result = select_query('tbldownloadcats', '', array( 'parentid' => '0', 'hidden' => '' ), 'name', 'ASC'); $data = mysql_fetch_array($result); $i++ )
{
$idkb = $data['id'];
$dlcats[$i] = array( 'id' => $idkb, 'name' => $data['name'], 'urlfriendlyname' => getModRewriteFriendlyString($data['name']), 'description' => $data['description'] );
$idnumbers = array( );
$idnumbers[] = $idkb;
dlgetcatids($idkb);
$queryreport = '';
foreach( $idnumbers as $idnumber )
{
$queryreport .= " OR category='" . $idnumber . "'";
}
$queryreport = substr($queryreport, 4);
$dlcats[$i]['numarticles'] = get_query_val('tbldownloads', "COUNT(*)", "(" . $queryreport . ") AND hidden=''" . $proddlrestrict);
}
$smarty->assign('dlcats', $dlcats);
$result = select_query('tbldownloads', "tbldownloads.*", "tbldownloadcats.hidden='' AND tbldownloads.hidden=''" . $proddlrestrict, 'downloads', 'DESC', '0,5', "tbldownloadcats ON tbldownloadcats.id=tbldownloads.category");
$downloads = createdownloadsarray($result);
$smarty->assign('mostdownloads', $downloads);
}
}
outputClientArea($templatefile);
function dlGetCatIds($catid)
{
global $idnumbers;
$result = select_query('tbldownloadcats', 'id', array( 'parentid' => $catid, 'hidden' => '' ));
while( $data = mysql_fetch_array($result) )
{
$cid = $data[0];
$idnumbers[] = $cid;
dlGetCatIds($cid);
}
}
function formatFileSize($val, $digits = 3)
{
$factor = 1024;
$symbols = array( '', 'k', 'M', 'G', 'T', 'P', 'E', 'Z', 'Y' );
for( $i = 0; $i < count($symbols) - 1 && $factor <= $val; $i++ )
{
$val /= $factor;
}
$p = strpos($val, ".");
if( $p !== false && $digits < $p )
{
$val = round($val);
}
else
{
if( $p !== false )
{
$val = round($val, $digits - $p);
}
}
return round($val, $digits) . " " . $symbols[$i] . 'B';
}
function createDownloadsArray($result)
{
global $CONFIG;
global $downloads_dir;
$downloads = array( );
while( $data = mysql_fetch_array($result) )
{
$id = $data['id'];
$category = $data['category'];
$type = $data['type'];
$ttitle = $data['title'];
$description = $data['description'];
$filename = $data['location'];
$numdownloads = $data['downloads'];
$clientsonly = $data['clientsonly'];
$filesize = @filesize($downloads_dir . $filename);
$filesize = formatfilesize($filesize);
$filenameArr = explode(".", $filename);
$fileext = end($filenameArr);
if( $fileext == 'doc' )
{
$type = 'doc';
}
if( $fileext == 'gif' || $fileext == 'jpg' || $fileext == 'jpeg' || $fileext == 'png' )
{
$type = 'picture';
}
if( $fileext == 'txt' )
{
$type = 'txt';
}
if( $fileext == 'zip' )
{
$type = 'zip';
}
$type = "![\"\"](\"images/")
";
$downloads[] = array( 'type' => $type, 'title' => $ttitle, 'urlfriendlytitle' => getModRewriteFriendlyString($ttitle), 'description' => $description, 'downloads' => $numdownloads, 'filesize' => $filesize, 'clientsonly' => $clientsonly, 'link' => $CONFIG['SystemURL'] . "/dl.php?type=d&id=" . $id );
}
return $downloads;
}