Support » Plugin: Football Pool » How Do I Paginate The Rankings?

  • Resolved ephi4real


    Hi Antoine,
    Thanks for the great plugin. I have 2 questions:

    I would like to paginate the rankings to show about 80 or 100 entries per page. How can I achieve this?
    Right now I have about 400 entries showing on the ranking page and I don’t want to restrict the number of rankings that are displayed.

    My second problem is that I would like to show the all the predictions for a particular match on one page, with pagination enabled. This is because my Prediction Form is shown on a Per match basis and I would like users to see what other users have predicted once predictions have closed.

    Thanks for your help.

Viewing 14 replies - 1 through 14 (of 14 total)
  • Plugin Author AntoineH


    There is no built in support for this in the plugin, so it would require some programming on your side.

    The ranking page uses the print_pool_ranking function in the Football_Pool_Pool class. If you extend this function with a $page parameter you can restrict the users that are displayed: start with user at position ( ( $page - 1 ) * $pagesize ).

    This is not an optimal approach, because the function still retrieves the complete ranking from the database, but I don’t think this will be a problem (data sets are not that large). If you also want to optimize, then pass the $page parameter on to the get_pool_ranking function which ‘feeds’ the print_pool_ranking and rewrite the SQL with a LIMIT.

    Same goes for the predictions per match (show_predictions_for_match in Football_Pool_Statistics class), you can alter the SQL function with a LIMIT and pass the $page as a parameter.

    Okay, thanks. I’ll try it out. It would be really great if you added this feature to the next version.


    Did you ever work on this? If so, could you share your code please?

    Plugin Author AntoineH


    The help page has an example for the pagination code that you can use in the functions.php file of your theme or in an own plugin.

    Thanks. I took a look and put that in my funcions.php but nothing happens.

    After digging in, I saw that version 2.3.8 had the filters set, but version 2.4.2 lost the filters.

    Should I be calling a different filter tag?

    Which one?


    Plugin Author AntoineH


    You can use the footballpool_ranking_page_html filter in the new version. I will update the example in the help file.

    Any chance you have the example? I haven’t been able to figure it out.


    Plugin Author AntoineH


    // add a simple pagination to the ranking page
    add_filter( 'footballpool_ranking_array', 'fp_pagination' );
    add_filter( 'footballpool_ranking_page_html', 'fp_pagination_html', null, 2 );
    // and, with the same functions, add a simple pagination to the statistics page (view=matchpredictions)
    add_filter( 'footballpool_statistics_matchpredictions', 'fp_pagination' );
    add_filter( 'footballpool_statistics_matchpredictions_html', 'fp_pagination_html', null, 2 ); 
    function fp_pagination( $items ) {
        $pagination = new Football_Pool_Pagination( count( $items ) );
        $pagination->page_param = 'fp_page';
        $pagination->set_page_size( 10 );
        $offset = ( ( $pagination->current_page - 1 ) * $pagination->get_page_size() );
        $length = $pagination->get_page_size();
        return array_slice( $items, $offset, $length );
    function fp_pagination_html( $html, $items ) {
        $pagination = new Football_Pool_Pagination( count( $items ), true );
        $pagination->page_param = 'fp_page';
        $pagination->set_page_size( 10 );
        return $html . $pagination->show( 'return' );

    Thanks but unfortunately that did not work.

    See screenshot:

    The pagination shows but the following pages don’t work.

    Any idea?

    Plugin Author AntoineH


    It says ‘0 items’. Strange.
    I use the same code in my install and it works as expected. What version of the plugin do you use?

    The latest – 2.4.2

    same bug for me…. the page display 10 user but in the slector in bottom of page is displayed : 1 page /0 and can not go to next page !

    Plugin Author AntoineH


    I found the problem. Something I already fixed in my dev install, that’s why it worked on my laptop.
    Change line 89 of file pages/class-football-pool-ranking-page.php to:

    return apply_filters( 'footballpool_ranking_page_html', $output, $ranking );


    is that example for the pagination code is only available for the ranking page ? what about the ranking shortcode ?

    @sillery4ever : i notice that u did’nt use the example code in your web site (joli travail), isn’t working ?

    Thanks ?

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘How Do I Paginate The Rankings?’ is closed to new replies.