#10 Incorrect showcat pagination - solved

[iberan]

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");