vb's pagination

[AN-net]

im trying to use vb's pagination but it isnt working
i keep getting division of by zero on line 1611 in includes/functions.php.
this is the code:

$limit=2;
$query_count= $DB_site->query("SELECT * FROM gallery WHERE gallery_id='$id'");
$totalrows= $DB_site->num_rows($query_count);
if(empty($page)){
$page=1;
}
sanitize_pageresults($totalrows, $page, $limit,100);
$limitlower = ($page - 1) * $limit+1;
$limitupper = ($page) * $limit;
if ($limitupper > $totalrows)
{
$limitupper = $totalrows;
if ($limitlower > $totalrows)
{
$limitlower = $totalrows-$limit;
}
}
if ($limitlower <= 0)
{
$limitlower = 1;
}
$fgall= $DB_site->query("SELECT gallery_index.gallery_views,gallery.* FROM gallery,gallery_index WHERE gallery_index.gallery_id='$id' AND gallery.gallery_id='$id' LIMIT " . ($limitlower-1) . ",$limit $type $order");
$imagesnum=$DB_site->num_rows($fgall);
if($imagesnum==0){
$DB_site->query("UPDATE gallery_index SET gallery_views=gallery_views+1 WHERE gallery_id='$id'");
$fgalnav=$DB_site->query("SELECT gallery_index.gallery_name FROM gallery_index WHERE gallery_index.gallery_id='$id'");
$galnav=$DB_site->fetch_array($fgalnav);
$navbits = array();
$navbits["#"] = "Gallery";
$navbits["gallery.php?view=index"] = "Gallery Index";
$navbits[''] = $galnav[gallery_name];

$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
mysql_free_result($fgalnav);
eval('print_output("' . fetch_template('gallery_gal_none') . '");');
}
else{
while($gallery= $DB_site->fetch_array($fgall))
{
if($gallery[image_totalvotes]==0){
$rating=0;
}
else{
$calcrating= $gallery[image_totalrating]/$gallery[image_totalvotes];
$rating= round($calcrating);
}
$galleryimagedate=date("m/d/Y - g:i A",$gallery[image_date]);
if($galoption[gallerybit]==1){
eval('$gallerybits .= "' . fetch_template('gallery_gal_lvl1alt') . '";');
}
else{
eval('$gallerybits .= "' . fetch_template('gallery_gal_lvl1') . '";');
}
}
mysql_free_result($fgall);
$DB_site->query("UPDATE gallery_index SET gallery_views=gallery_views+1 WHERE gallery_id='$id'");
$fgalnav=$DB_site->query("SELECT gallery_index.gallery_name FROM gallery_index WHERE gallery_index.gallery_id='$id'");
$galnav=$DB_site->fetch_array($fgalnav);
$navbits = array();
$navbits["#"] = "Gallery";
$navbits["gallery.php?view=index"] = "Gallery Index";
$navbits[''] = $galnav[gallery_name];

$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
$pagenav = construct_page_nav($totalrows, "gallery.php?view=gal&amp;id=$id", "&amp;pp=$limit");
mysql_free_result($fgalnav);
if(in_array($bbuserinfo['usergroupid'], array(4,5,6)))
{
eval('$submitgal .= "' . fetch_template('gallery_subbutton') . '";');
}
eval('print_output("' . fetch_template('gallery_gal') . '");');

can anyone help?
it show the lil page nav page with "Page of 0"

[Andreas]

Hmm ... would be interesting to know which line is line 1611 ;)

Anyway, I don't see a division in that code so it must come from a function being called.

[VBDev]

Try adding $perpage=10; before the call to construct_page_nav()

[AN-net]

ok got it working but its not display all the pages possbily, there is 4 pages possible but it only shows "Page of 4" "1" "2" ">" "last>>"
each "blahblah" represents another box

[Space Goat]

You also need to define $pagenumber before you call construct_page_nav(). Set it to the current page number the user gave to you in their GET request.

I had the same issue, and this solved it.

[Guest190829]

This thread is almost a year old, I think An-net solved the issue. ;)