Menu

#10 Incorrect showcat pagination - solved

open
nobody
None
5
2009-07-02
2009-06-28
iberan
No

Fixing uncorrect pagination in showcat.php (change $row_count to $threads_per_page in DB query).

Change this:

$database->setQuery("SELECT a. * , MAX( b.time ) AS lastpost FROM #__mb_messages AS a LEFT JOIN #__mb_messages AS b ON b.thread = a.thread WHERE a.parent = '0' AND a.catid = $catid AND a.hold = '0' GROUP BY id ORDER BY ordering DESC , lastpost DESC LIMIT $offset,$row_count");

to:

$database->setQuery("SELECT a. * , MAX( b.time ) AS lastpost FROM #__mb_messages AS a LEFT JOIN #__mb_messages AS b ON b.thread = a.thread WHERE a.parent = '0' AND a.catid = $catid AND a.hold = '0' GROUP BY id ORDER BY ordering DESC , lastpost DESC LIMIT $offset,$threads_per_page");

Discussion

  • iberan

    iberan - 2009-06-28
    • summary: showcat pagination --> Uncorrect showcat pagination - solved
     
  • iberan

    iberan - 2009-07-02
    • summary: Uncorrect showcat pagination - solved --> Incorrect showcat pagination - solved
     

Log in to post a comment.

MongoDB Logo MongoDB