setQuery("SELECT max(time) FROM #__sb_messages where thread=$rs->thread");
$latestPostTime=$database->loadResult();
//get the latest post itself
$result="";
$database->setQuery("SELECT a.id,a.name,a.catid,b.name as catname from #__sb_messages as a LEFT JOIN #__sb_categories as b on a.catid=b.id where a.time=$latestPostTime");
$database->loadObject($result);
$latestPostId=$result->id;
$latestPostName=$result->name;
$latestPostCatid=$result->catid;
$catname=$result->catname;
$database->setQuery("SELECT count(*) from #__sb_messages where time>'$querytime' and thread=$rs->thread");
$numberOfPosts=$database->loadResult();
$k= 1- $k;
echo "";
echo ''.htmlspecialchars(stripslashes($rs->subject)).'
'._GEN_FORUM.' : '.$catname.' | ';
echo ''.$numberOfPosts.' | ';
echo "".htmlspecialchars($latestPostName)." | ";
echo "".date(_DATETIME,$latestPostTime)." | ";
echo "
";
}
}
else {
echo "| "._NO_TIMEFRAME_POSTS." |
";
}
echo "
";
?>