[Plugin: custom tables] Pagination ends with page 6

  • rainermonk

    (@rainermonk)


    13 years, 10 months ago

    hi, first of all thanks for this great plugin, second my question.

    i have got a table with 26 pages (5 entries a page in table view). below the table you can find the pagination. It looks like the following:

    Page: 1 2 3 4 5 6 … 21 22 23 24 25 26

    the problem is, that the pagination will end at page number 6. you can´t jump to number 7. even on page 6, the pagination will not change. so you can´t go to page number 7 (nor can i go to page 8, 9, 10 and so on).

    is there any solution to this problem like having a “next” button or something like that on page 6? or perhaps i just missed something in the table-settings?

    last not least, i have an other table with the same problem there.

    anyway thanks for your help,
    rainer

    http://wordpress.org/extend/plugins/custom-tables/

Viewing 1 replies (of 1 total)
  • Thread Starter rainermonk

    (@rainermonk)

    13 years, 9 months ago

    well as far as i understand php, the pagination is controlled via show_table.php in this code section. anyway i am still not sure how to implement some kind of a back and forward button/menu to solve the problem. any help highly appreciated. greetings, rainer

    $qry = $wpdb->get_row("SELECT count(id) asanzFROM“.$wpdb->prefix.”wct”.$id.”WHEREstatus`=’active'”.$zusatz);
    $menge = ceil($qry->anz / $limit);

    if ($menge > ‘1’ AND $this->settings[‘hidepagenumbers’] != ‘1’) {
    $url = $this->generate_pagelink(“/[&?]+wctstart=[0-9]*/”,””);
    $out .= “<tr><td colspan=\””.($colspan != ” ? $colspan : ‘500’).”\” class=\”wct”.$css.”-pagefield\”><div class=’tablenav-pages’><center><b>”.__(‘Page’, ‘wct’).”:</b> “;
    for ($x=1;$x <= $menge;$x++) {
    $l = ($limit * ($x – 1)) + 1;
    if($_GET[‘wctstart’] == $l OR ($l == ‘1’ AND $_GET[‘wctstart’] == ”)) { $out .= $x.” “; }
    else { $out .= “<a href=\””.$url.”wctstart=”.$l.”\”>”.$x.”</a> “; }

    if ($menge > $pages) {
    if ($x == floor ($pages / 2)) {
    $x = $menge – floor($pages / 2);
    $out .= “… “;
    }
    }
    }
    if ($table->dl != ‘0’) {
    $out .= ”   <b>”.__(‘Download’,’wct’).”:</b>”;
    $qrr = $wpdb->get_row(“SELECT secret FROM ".$wpdb->prefix."wct_list WHERE id='”.$id.”‘ LIMIT 1;”);
    if ($table->dl == ‘1’ OR $table->dl == ‘3’) {
    $out .= “<a target=\”_blank\” href=\””.plugins_url(‘custom-tables/dl.php’).”?i=”.$id.”&l=”.$qrr->secret.”&t=excel&r=”.base64_encode($dlids).”\”><img style=\”position:relative;top:7px;margin-top:-5px;\” src=\””.plugins_url(‘custom-tables/img/excel.png’).”\” border=\”0\” alt=\”Excel\” height=\”25\” /></a>”;
    }
    if ($table->dl == ‘2’ OR $table->dl == ‘3’) {
    $out .=”<a target=\”_blank\” href=\””.plugins_url(‘custom-tables/dl.php’).”?i=”.$id.”&l=”.$qrr->secret.”&t=csv&r=”.base64_encode($dlids).”\”><img style=\”position:relative;top:7px;margin-top:-5px;\” src=\””.plugins_url(‘custom-tables/img/csv.gif’).”\” border=\”0\” alt=\”CSV\” height=\”25\” /></a>”;
    }
    }
    $out .= “</center></div></td></tr>”;
    }
    else {
    $out .= “<tr><td colspan=\””.($colspan != ” ? $colspan : ‘500’).”\” class=\”wct”.$css.”-pagefield\”><center>”;
    if ($table->dl != ‘0’) {
    $out .= ”   <b>”.__(‘Download’,’wct’).”:</b>”;
    $qrr = $wpdb->get_row(“SELECT secret FROM ".$wpdb->prefix."wct_list WHERE id='”.$id.”‘ LIMIT 1;”);
    if ($table->dl == ‘1’ OR $table->dl == ‘3’) {
    $out .= “<a target=\”_blank\” href=\””.plugins_url(‘custom-tables/dl.php’).”?i=”.$id.”&l=”.$qrr->secret.”&t=excel&r=”.base64_encode($dlids).”\”><img style=\”position:relative;top:7px;margin-top:-5px;\” src=\””.plugins_url(‘custom-tables/img/excel.png’).”\” border=\”0\” alt=\”Excel\” height=\”25\” /></a>”;
    }
    if ($table->dl == ‘2’ OR $table->dl == ‘3’) {
    $out .=”<a target=\”_blank\” href=\””.plugins_url(‘custom-tables/dl.php’).”?i=”.$id.”&l=”.$qrr->secret.”&t=csv&r=”.base64_encode($dlids).”\”><img style=\”position:relative;top:7px;margin-top:-5px;\” src=\””.plugins_url(‘custom-tables/img/csv.gif’).”\” border=\”0\” alt=\”CSV\” height=\”25\” /></a>”;
    }
    }
    $out .= “</center></td></tr>”;
    }

    $out .= “</table>\n\n<div style=\”visibility:hidden;display:none;\”>Custom Tables Plugin 05a1a29bdcae7b12229e651a9fd48b11</div>\n\n”;`

Viewing 1 replies (of 1 total)

The topic ‘[Plugin: custom tables] Pagination ends with page 6’ is closed to new replies.