$op = (isset($_GET['op'])) ? inCode($_GET['op']) : "" ;
$id = (isset($_GET['id'])) ? intval($_GET['id']) : 0 ;
$title = (isset($_GET['title'])) ? mem_urldecode(inCode($_GET['title'])) : "" ;
$dw = (isset($_POST['dw'])) ? inCode($_POST['dw']) : "" ;
$rank = (isset($_GET['rank'])) ? intval($_GET['rank']) : 1 ;
$fileid = (isset($_GET['fileid'])) ? inCode($_GET['fileid']) : 0 ;
$ok = (isset($_GET['ok'])) ? inCode($_GET['ok']) : false ;
$pg = (isset($_GET['pg'])) ? intval($_GET['pg']) : 1 ;
$ofsppg = 20; //Items per page
$ofsbgn = ($pg*$ofsppg)-$ofsppg;

function catList($ofsbgn,$ofsppg,$pg) {
	global $dblink,$siteConfig,$tzNOW;
	
	if ($result = $dblink->get_list("SELECT * FROM memht_download_categorie WHERE parent=0 ORDER BY nome")) {
		foreach ($result as $row) {
			$cid = intval($row['id']);
			$cparent = intval($row['parent']);
			$cname = outCode($row['nome']);
			$cdesc = outCode($row['descrizione']);
			
			//Show subcategories
			openTable("<a href='index.php?page=download&op=category&id=$cid&title=".mem_urlencode($cname)."' title='$cname'>$cname</a>");
				echo "<table width='100%' border='0' cellspacing='0' cellpadding='2'>\n";
					if ($cdesc!="") { echo "<tr><td colspan='2' class='box'>$cdesc</td></tr>\n"; }
					$a = 0;
					$sresult = $dblink->get_list("SELECT * FROM memht_download_categorie WHERE parent=$cid ORDER BY nome");
					foreach ($sresult as $srow) {
						$sid = intval($srow['id']);
						$sname = outCode($srow['nome']);
						
						$sfiles = "<span class='info'>(".$dblink->get_num("SELECT id FROM memht_download WHERE cat='$sid'").")</span>";
							
						if (($a%2)==0) { echo "<tr>"; }
						echo "<td width='50%' valign='top'><img src='images/bullet_paper.gif' border='0' alt='Bullet'> <a href='index.php?page=download&op=category&id=$sid&title=".mem_urlencode($sname)."' title='$sname'><b>$sname</b></a> $sfiles</td>";
						if (($a++%2)!=0) { echo "</tr>\n"; }
					}
				echo "</table>\n";
				
				//Show files
				if ($fresult = $dblink->get_list("SELECT *,DATE_FORMAT(data, '".$siteConfig['timestamp']."') as data FROM memht_download WHERE cat=$cid AND enabled=1 ORDER BY id DESC LIMIT $ofsbgn,$ofsppg")) {
					echo "<table width='100%' border='0' cellspacing='0' cellpadding='2' style='margin-top:5px;'>\n";
					$a = 0;
					foreach ($fresult as $frow) {
						$fid = intval($frow['id']);
						$fname = outCode($frow['nome']);
						$fauthor = outCode($frow['autore']);
						$fversion = outCode($frow['version']);
						$fdate = outCode($frow['data']);
						$fsize = strSize(intval($frow['dimensione']));
						$fdownloaded = intval($frow['scaricato']);
						$permission = intval($frow['flag']);
						$group = intval($frow['pgroup']);
						
						if ($fversion=="") { $fversion = "-"; }
						$row = $dblink->get_row("SELECT name FROM memht_groups WHERE id=$group");
						$gname = outCode($row['name']);
						switch ($permission) {
							 case 0: $fpermission = _PUBLIC_; break;
							 case 1: $fpermission = _REGISTERED_; break;
							 case 2: $fpermission = _GROUP_." ($gname)"; break;
						}
						
						$info = "";
						if ($fdownloaded>=200) { $info .= " <img src='images/pop.gif' title='"._POP_."' border='0' alt='Pop'>"; } //Pop 200 downloads
						if ($dblink->get_num("SELECT id FROM memht_download WHERE id=$fid AND (data + INTERVAL 7 DAY) > $tzNOW")>0) {
							$info .= " <img src='images/new.gif' title='"._NEW_."' border='0' alt='New'>"; //New 7 days
						}
						
						if (($a%2)==0) { echo "<tr>\n"; }
						
							echo "<td width='50%' valign='top'>\n";
								echo "<div class='box' style='padding:2px; margin:0;'>\n";
									echo "<div><img src='images/download.gif' border='0' alt='"._DOWNLOAD_."'> <a href='index.php?page=download&op=getFile&id=$fid&title=".mem_urlencode($fname)."' title='$fname'><b><span class='tpl_comments_title'>$fname</span></b></a>$info</div>\n";
									echo "<div style='padding:2px;'></div>\n";
									echo "<div><b>"._AUTHOR_.":</b> $fauthor</div>\n";
									echo "<div><b>"._VERSION_.":</b> $fversion</div>\n";
									echo "<div><b>"._DATE_.":</b> $fdate</div>\n";
									echo "<div><b>"._SIZE_.":</b> $fsize</div>\n";
									echo "<div><b>"._DOWNLOADED_.":</b> $fdownloaded "._TIMES_."</div>\n";
									echo "<div><b>"._PERMISSION_.":</b> $fpermission</div>\n";
								echo "</div>\n";
							echo "</td>\n";
						if (($a++%2)!=0) { echo "</tr>\n"; }
					}
?>