vb.org Archive
Page 8 of 8 « First 67 8
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   [cinq's vbArticles v1.0 Hack] - The development process (https://vborg.vbsupport.ru/showthread.php?t=69906)

cinq 01-11-2005 02:14 PM
Hack has been released here

Thanks for all the help rendered everyone :D

sabret00the 01-15-2005 07:55 PM
Quote:
Originally Posted by sabret00the
wow, it is, i haven't ever rewritten the code i was giving along time ago for sorting pagenav but the code i have is 30 lines long :shock:

please share the knowledge :o
did the 3 line version of this never surface in this thread?

cinq 01-16-2005 12:44 PM
Unfortunately nope.
I would be interested to know too.

rake 01-16-2005 01:49 PM
Quote:
Originally Posted by cinq
Unfortunately nope.
I would be interested to know too.
This is the proper way to do pagination. It's from one of my scripts, and the original code is taken right out of vbulletin. All you need to edit are the two queries, the template that is called, and the fields you want to sort by.

PHP Code:
    // globalize variables
    globalize($_REQUEST, array(
        'pagenumber' => INT, // pagenumber
        'perpage' => INT, // results per page
        'sortfield' => STR, // field by which to sort results
        'sortorder' => STR, // order in which to sort
    ));

    if ($sortfield == '') {
        $sortfield = 'name';
    }

    if ($sortorder == '') {
        $sortorder = 'asc';
    }



    switch ($sortfield)
    {
        case 'name':
            $sqlsort = 'name';
            break;
        case 'id':
            $sqlsort = 'id';
            break;
        default:
            $sqlsort = 'name';
            $sortfield = 'name';
    }


    if ($sortorder != 'asc')
    {
        $sortorder = 'desc';
        $oppositesort = 'asc';
    }
    else
    {
        // $sortorder = 'ASC';
        $oppositesort = 'desc';
    }


    $sorturl = "$_SERVER[PHP_SELF]?$session[sessionurl]";


    eval('$sortarrow[' . $sortfield . '] = "' . fetch_template('forumdisplay_sortarrow') . '";');



    $dscount = $DB_site->query_first("
        SELECT COUNT(*) AS count FROM site_garment
    ");
    $dscount = $dscount['count'];

    // set defaults
    sanitize_pageresults($dscount, $pagenumber, $perpage, 100, 20);

    $limitlower = ($pagenumber - 1) * $perpage+1;
    $limitupper = ($pagenumber) * $perpage;
    $counter = 0;

    if ($limitupper > $dscount)
    {
        $limitupper = $dscount;
        if ($limitlower > $dscount)
        {
            $limitlower = $dscount-$perpage;
        }
    }
    if ($limitlower <= 0)
    {
        $limitlower = 1;
    }


    $spheres = $DB_site->query("SELECT * FROM site_garment ORDER BY $sqlsort $sortorder LIMIT ". ($limitlower-1) . ", $perpage");

    $counter = 0;
    $resultbits = '';
    while ($grid = $DB_site->fetch_array($spheres) AND $counter++ < $perpage)
    {

        $grid[bonuses] = nl2br($grid[bonuses]);
        eval('$dresspheres .= "' . fetch_template('site_ffx2_dsp_grid') . '";');



    }  // end while
    $pagenav = construct_page_nav($dscount, "$_SERVER[PHP_SELF]?$session[sessionurl]", "&amp;pp=$perpage&order=$sortorder&amp;sort=$sortfield"); 

cinq 01-17-2005 11:52 AM
Thanks again Alex, appreciate it :)
I will try your code when time permits.


All times are GMT. The time now is 02:05 AM.
Page 8 of 8 « First 67 8
Show 40 post(s) from this thread on one page

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.01216 seconds
  • Memory Usage 1,755KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete