Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-26-2004, 09:55 AM
AlienSector AlienSector is offline
 
Join Date: Oct 2004
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Help with vBulletins Pagination

Before making this post, I searched around and came across the following code (modified to fit my data) and I am not exactly sure where to place it to make it function as it needs to.

Coding Snippet: https://vborg.vbsupport.ru/showthrea...ght=pagination


Code:
$rescount= $DB_site->query_first("SELECT COUNT(*) AS id FROM resources WHERE isstuck='no'"); 
            $perpage= 6; 
            if(empty($page)) 
            { 
                $page= 1; 
            } 
            $start= (($page * $perpage) - $perpage); 
            $pagenavigation = construct_page_nav($rescount[id], "resources.php?", "pp=$perpage");

I am trying to make it so that the data I am pulling from the database below is paginated accordingly, though it does not seem to be working as it should be (or as I had thought). While the limit function above does work and show only 6 of the 7 entries, no links are presented on the page for me to get to the next.

Code:
$getresources = $DB_site->query("SELECT * FROM resources WHERE type='vbulletin' AND isstuck='no' ORDER BY id DESC LIMIT $start,$perpage");
	while($resource = $DB_site->fetch_array($getresources))
	{

		eval('$resources .= "' . fetch_template('index_resourcedata') . '";');

	}

eval('print_output("' . fetch_template('index_resourcedisplay') . '");');
Any help is appreciated as I would like to get this working as soon as possible .
Reply With Quote
  #2  
Old 10-26-2004, 08:24 PM
AlienSector AlienSector is offline
 
Join Date: Oct 2004
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The navigation bar is showing now, though the links in the navigation bar are not working as they should, nor is it set on the correct page, though the coding has been changed since it didn't work with the above either:

Code:
$rescount= $DB_site->query_first("SELECT COUNT(*) AS id FROM resources WHERE isstuck='no' AND softwaretype='vbulletin'"); 
            $perpage= 2; 
            if(empty($page)) 
            { 
                $page= 1; 
            } 
            $pagenumber = $page+1; 
            if ($pagenumber < 1) 
            { 
                $pagenumber = 1; 
            } 
            else if ($pagenumber > $rescount['id']) 
            { 
                $pagenumber = $rescount['id']; 
            }
            $start= (($page * $perpage) - $perpage); 
            $pagenav = construct_page_nav($rescount[id], "resources.php?", "pp=$perpage");
The below attachment is what the pagenav bar looks like and the page it is starting on with the above.
Attached Images
File Type: gif pagebar.gif (674 Bytes, 0 views)
Reply With Quote
  #3  
Old 10-27-2004, 04:12 PM
AlienSector AlienSector is offline
 
Join Date: Oct 2004
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am not sure what else there is to do, nothing seems to be working and I have checked online.php, memberlist.php and so forth and I can't seem to get it to work correctly. While it displays the correct number of pages as it should, it always seems to start on the wrong page and the links never work.

I would appreciate any help that could be offered and would be more than happy to give credit where credit is due once the hack/modification is completed.
Reply With Quote
  #4  
Old 10-28-2004, 05:53 PM
AlienSector AlienSector is offline
 
Join Date: Oct 2004
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by AlienSector
I am not sure what else there is to do, nothing seems to be working and I have checked online.php, memberlist.php and so forth and I can't seem to get it to work correctly. While it displays the correct number of pages as it should, it always seems to start on the wrong page and the links never work.

I would appreciate any help that could be offered and would be more than happy to give credit where credit is due once the hack/modification is completed.
Still looking for a bit of assistence of anyone can lend it .
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:40 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04408 seconds
  • Memory Usage 2,208KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (1)postbit_attachment
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • postbit_attachment
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete