'".mysql_real_escape_string($_GET['date'])."' AND".$akapo;
if(isset($_GET['downloads']))
$sqlselect .= "`downloads` >".mysql_real_escape_string($_GET['downloads'])." AND".$akapo;
if(isset($_GET['rating']))
$sqlselect .= "`rating` >".mysql_real_escape_string($_GET['rating'])." AND".$akapo;
if(isset($_GET['comments']))
$sqlselect .= "`comments` >".mysql_real_escape_string($_GET['comments'])." AND".$akapo;
$sqlselect = substr($sqlselect, 0, strlen($sqlselect) - 5); //rimuove "AND\r\n"
}
if(isset($_GET['orderBy']) && isset($_GET['orderMode']))
$sqlselect .= "ORDER BY `".mysql_real_escape_string($_GET['orderBy'])."` ". mysql_real_escape_string($_GET['orderMode']);
elseif(isset($_GET['topRated']))
$sqlselect .= "ORDER BY `rating` ". mysql_real_escape_string($_GET['topRated']);
elseif(isset($_GET['topDown']))
$sqlselect .= "ORDER BY `downloads` ". mysql_real_escape_string($_GET['topDown']);
$pageNumber = isset($_GET['pag']) ? intval($_GET['pag']) : 1;
$sqlselect .= "
LIMIT " . (($pageNumber - 1) * $resPerPage) . ' , ' . ($pageNumber * $resPerPage + 1);
//print $sqlselect.'
';
$res = mysql_query($sqlselect) or die ("MySql Error3: ".mysql_error());
if (mysql_num_rows($res) == 0)
print "There are no $glbItems in this category, yet.
".$akapo;
else {
//add page navigation
$pageUrl = $_SERVER['PHP_SELF'];
parse_str($_SERVER['QUERY_STRING'], $queryStrings);
$pageNavigationHtml = '';
unset($queryStrings['pag']);
$queryString = null;
$i = 0;
foreach ($queryStrings as $key => $value) {
$queryString .= $key . '=' . $value . '&';
}
if ($pageNumber > 1) {
$newPag = $pageNumber - 1;
$pageNavigationHtml .= "< previous page";
}
else
$pageNavigationHtml .= 'previous page';
$pageNavigationHtml .= ' - ';
if (mysql_num_rows($res) > $resPerPage) {
$newPag = $pageNumber + 1;
$pageNavigationHtml .= "next page >";
}
else
$pageNavigationHtml .= 'next page';
$pageNavigationHtml .= '
';
print $pageNavigationHtml;
print "".$akapo;
$i = 0;
while ($row = @mysql_fetch_array($res)) {
if (++$i % ($resPerPage + 1) == 0)
break;
//foreach result, create and fill a new table row
$faceId = $row['id'];
$name = $row['name'];
$author = $row['author'];
$category = $row['category'];
$date = $row['date'];
$downloads = $row['downloads'];
$rating = $row['rating'];
$ratingInt = round($rating);
$ratingNum = $row['ratingnum'];
$comments = $row['comments'];
$thumbExtension = $row['thumbext'];
//$description = win_nl2br(htmlentities($row['Description']));
print "
$name
by $author
Downloads: $downloads
Rating:  (based on $ratingNum ratings)
Comments: $comments
Date: $date |
|
| |
";
}
print '
'.$akapo;
print $pageNavigationHtml;
}
includeFooter();
?>