vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   vb's pagination (https://vborg.vbsupport.ru/showthread.php?t=61714)

AN-net 02-18-2004 10:34 PM
vb's pagination
 
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:
PHP 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 02-18-2004 10:43 PM
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 02-18-2004 11:18 PM
Try adding $perpage=10; before the call to construct_page_nav()

AN-net 02-19-2004 12:26 AM
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 08-21-2005 11:30 PM
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 08-22-2005 12:07 AM
This thread is almost a year old, I think An-net solved the issue. ;)


All times are GMT. The time now is 07:37 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01880 seconds
  • Memory Usage 1,757KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete