<?php 	

	//Setting page numbers
	if (empty($p_currentpage)) {$currentpage = 1;} else {$currentpage=$p_currentpage;}
	if (!empty($p_pagelength)) {$pagelength = $p_pagelength;}
	else{//added by sithes on 07-04-10 4.30pm 
		$pagelength = $db->DbGetField("select tblsettingvalue.settingvalue  from tblsettingvalue 
		left join tblsetting on tblsettingvalue.settingid = tblsetting.settingid
		where tblsetting.parameter = 'frontend_pagelength' ");
	}
	
	if ($p_pagesubmit == " < ") {$currentpage = $p_currentpage - 1;}
	if ($p_pagesubmit == "<<") {$currentpage = 1;}
	if ($p_pagesubmit == " > ") {$currentpage = $p_currentpage + 1;}
	if ($p_pagesubmit == ">>") {$currentpage = -1;}
	if ($p_pagesubmit == "Go") {$currentpage = $p_currentpageenter;}
	
	
	//Build Query
	//if (!empty($wheredata)) {$wheredata = " where $wheredata";}
	
	$totalrows = (int)$db->DbGetField($sqlQueryCount);
	$totalpages = ceil($totalrows / $pagelength);
	if (($currentpage > $totalpages) || ($currentpage == -1)) {$currentpage = $totalpages;}
	if ($totalrows == 0 || $currentpage == 0) {$currentpage = 1;}
	
	if (!empty($sqlOrderBy)) {$sqlQuery .= " order by " . $sqlOrderBy;}
	
	$sqlQuery = $sqlQuery . " Limit " . ($currentpage-1) * $pagelength . ", $pagelength";

		$displaypage=$lan['PAGE'];
		$displayshow=$lan['SHOW'];
		$perpage=$lan['PER PAGE'];
		$displaytrecords = $lan['TOTAL RECORDS'];
		$of=$lan['OF'];
		$go=$lan['GO'];

	$pageValues[] = array(
		"DISPLAYPAGE"=>$displaypage,
		"DISPLAYSHOW"=>$displayshow,
		"TOTALRECORDS"=>$displaytrecords,
		"PERPAGE"=>$perpage,
		"OF"=>$of,
		"GO"=>$go,
		"CURRENTPAGE"=>$currentpage,
		"TOTALPAGES"=>$totalpages,
		"TOTALROWS"=>$totalrows,
		"PAGELENGTH"=>$pagelength,
		"SKINS"=>$GLOBALS['skins'],
	);
	
	$pageContents = $etamineParser->Parse($GLOBALS['common'] . "pageno.html", $pageValues);
?>