postcounts from optimize.php

Bug #115328 reported by mmxbass
2
Affects Status Importance Assigned to Milestone
||board
Confirmed
Low
Unassigned

Bug Description

The retrieval of postcounts from optimize.php is overly simplistic.

Note the SQL code used for the normal retrieval of threads in bulk.

SELECT `threads`.*, (IFNULL(`t2`.`lastpostdate`,0)+`threads`.`lastpostdate`), (`threads`.`status` &2 ) FROM `threads` LEFT JOIN `threads`=`t2` ON `threads`.`link` = `t2`.`id` WHERE `threads`.`forum`='$forumID' ORDER BY (`threads`.`status` &2 ) DESC, `(IFNULL(``t2``.``lastpostdate``,0)+``threads``.``lastpostdate``)` DESC LIMIT $offset , $tpp");

mmxbass (mmxbass)
Changed in 2board:
importance: Undecided → Low
status: Unconfirmed → Confirmed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.