Bilan à mi mars du Portail

            //Get the last post from each forum
            $database->setQuery("SELECT MAX(time) from #__sb_messages WHERE catid='$singlerow->id' and hold='0' AND moved!='1'");
            $lastPosttime=$database->loadResult();
            $lastPosttime=(int)$lastPosttime;

  /*//////////////// Start selecting messages, prepare them for threading, etc... /////////////////*/
  $page = (int)$page;
  $page = $page<1?1:$page;
  $offset = ($page-1)*$threads_per_page;
  $row_count=$page*$threads_per_page;
  $database->setQuery("Select count(*) FROM #__sb_messages WHERE parent = '0' AND catid= '$catid' AND hold = '0' ");
  $total=(int)$database->loadResult();
  $database->setQuery("SELECT a. * , MAX( b.time )  AS lastpost FROM  #__sb_messages  AS a LEFT  JOIN #__sb_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");
 
  foreach ($database->loadObjectList() as $message) {
      $threadids[]=$message->id;
      $messages[$message->parent][]=$message;
      $last_reply[$message->id] = $message;
      $hits[$message->id]=$message->hits;
  }

    if (count($threadids) > 0) {
      $idstr = @join("','",$threadids);
     $database->setQuery("SELECT id,parent,thread,catid,subject,name,time,topic_emoticon,locked,ordering, moved FROM #__sb_messages WHERE thread IN ('$idstr') AND id NOT IN ('$idstr') and hold=0");
   foreach ($database->loadObjectList() as $message)
      {
        $messages[$message->parent][]=$message;
        $thread_counts[$message->thread]++;
        $last_reply[$message->thread]=$last_reply[$message->thread]->time<$message->time?$message:$last_reply[$message->thread];
      }
  }
  //get number of pending messages
  $database->setQuery("select count(*) from #__sb_messages where catid='$catid' and hold=1");
  $numPending=$database->loadResult();