get_count("rowid","iworks_submissions",$SELWHERE.$seemature.$wheresearch);
if(!$_REQUEST['page']) $_REQUEST['page'] = 1;
$page = $_REQUEST['page'];
if(!$page) $page=1;
$pages=ceil($totalpages/$maxpages);
if($pages>1) $showingpages = makepagelink("browse.fpd?cat=$_REQUEST[cat]&atype=$_REQUEST[atype]&limit=$_REQUEST[limit]&offset=$_REQUEST[offset]&search=$_REQUEST[search]", $page, $pages);
if(!$pages || $pages == 1) $showingpages="[1]";
//Goes to next page.
if($go == "Next") {
if($_REQUEST['page'] != $pages) {
$_REQUEST['page'] = $_REQUEST['page'] + 1;
} else {
$_REQUEST['page'] = $pages;
}
header("LOCATION: browse.fpd?cat=$_REQUEST[cat]&atype=$_REQUEST[atype]&limit=$_REQUEST[limit]&page=$_REQUEST[page]&search=$_REQUEST[search]");
exit();
}
//Goes to last page.
if($go == "Previous") {
if($_REQUEST['page'] != 0) {
$_REQUEST['page'] = $_REQUEST['page'] - 1;
} else {
$_REQUEST['page'] = 0;
}
header("LOCATION: browse.fpd?cat=$_REQUEST[cat]&atype=$_REQUEST[atype]&limit=$_REQUEST[limit]&page=$_REQUEST[page]&search=$_REQUEST[search]");
exit();
}
//Start the thumbnails listing...
$thumbnails.="";
$i=1;
if($seemature && !$WHERE) $WHERE="WHERE";
$result = $sql->query("SELECT * FROM iworks_submissions $WHERE $seemature $wheresearch ORDER BY date DESC LIMIT ".($maxpages*($page-1)).",".$maxpages);
while ($row = $sql->fetch_array($result)) {
$thisdate = XBdate($config['today'],$row['date']);
eval ("\$thumbnails .= \"".gettemplate("gallery_thumbnails")."\";");
if($i == 5){
$thumbnails.="
";
$i=0;
}
$i++;
}
$sql->free_result($result);
$thumbnails.="
";
require ("my.query.fpd");
eval("dooutput(\"".gettemplate("browse")."\");");
?>