\n";
$form.="\t| \n";
$query="SELECT count(*) FROM $from WHERE $where";
if (!($res=@mysql_query($query))) {die(mysql_error().' on line: '.__LINE__);}
$totalrows=mysql_result($res,0,0);
$total_pages=ceil($totalrows/$results);
$dotsbefore=false;
$dotsafter=false;
$current_page = 0;
$myreturn = '';
for ($i=1;$i<=$total_pages;$i++) {
if (((($i-1)*$results)<=$offset) && ($offset<$i*$results)) {
$myreturn.="$i ";
$current_page = $i;
} elseif (($i-1+$radius)*$results<$offset) {
if (!$dotsbefore) {
$myreturn.="...";
$dotsbefore=true;
}
} elseif (($i-1-$radius)*$results>$offset) {
if (!$dotsafter) {
$myreturn.="...";
$dotsafter=true;
}
} else {
$href_params = array_merge($params, array('offset' => ($i-1) * $results, 'results' => $results));
$href = add_query_arg($href_params, $tpname);
$myreturn.= sprintf('%d ', esc_attr($href), esc_attr($i));
// $myreturn.="$i ";
}
}
if ( $offset != 0 ) {
//Subtract 2, page is 1-based index, results is 0-based, must compensate for 2 pages here
if ( (($current_page-2) * $results) < $results) {
$href_params = array_merge($params, array('offset' => 0, 'results' => $results));
$href = add_query_arg($href_params, $tpname);
// $prev ="\t\t« ";
} else {
$href_params = array_merge($params, array('offset' => ($current_page-2) * $results, 'results' => $results));
$href = add_query_arg($href_params, $tpname);
// $prev ="\t\t« ";
}
$prev = sprintf('« ', esc_attr($href));
} else {
$prev = '';
}
if ( $offset != (($total_pages-1)*$results) ) {
$href_params = array_merge($params, array('offset' => $current_page * $results, 'results' => $results));
$href = add_query_arg($href_params, $tpname);
$next = sprintf('» ', esc_attr($href));
// $next = "» \n";
} else {
$next = '';
}
if ( isset($_REQUEST['page_id']) && '' != $_REQUEST['page_id'] ) {
$form.="\t\t\n";
}
$form = $form . $prev . $myreturn . $next;
$form.="\t | \n";
$form.="\t\n";
$form.="\t\t\n";
while (list($k,$v)=each($params)) {
$form.="\t\t\n";
}
$form.="\t\t\n";
$form.="\t | \n";
$form.="
\n";
$form.="