";
foreach($res2 as $r2){
if ( in_array($r2->catid,$allowed_forums)){
if($show){
$url = sefRelToAbs('index.php?option=com_simpleboard&Itemid='.$Itemid.'&func=view&catid='.$r2->catid.'&id='.$r2->id).'#'.$r2->id;
echo '';
$ressubject = $r2->subject;
$ressubject = preg_replace( "/$searchword/i", '' . $searchword . '', $ressubject );
echo "| ".$ressubject.' | '.date(_DATETIME , $r2->time).' | ';
echo ""._RESULTS_TITLE." | ";
echo "
";
}
$i++;
$k=1-$k;
}
}
echo "
";
}
$sql3 = "select a.mesid, a.message, b.catid from #__sb_messages_text as a left join #__sb_messages as b on a.mesid=b.id where ".$messagestr." order by b.time DESC";
$database->setQuery($sql3);
$res3 = $database->loadObjectList();
$count3 = count($res3);
if($count3<>0){
if($show){
if($count==0){
if($count2==0){
echo "';
foreach ($res4 as $r4){
if($show){
$url = sefRelToAbs('index.php?option=com_simpleboard&Itemid='.$Itemid.'&func=view&catid='.$r4->catid.'&id='.$r4->id).'#'.$r4->id;
echo '';
$ressubject = $r4->subject;
//eliminate some possible show stoppers; mf#2733
$searchword = str_replace ("(","\(",$searchword);
$searchword = str_replace (")","\)",$searchword);
$ressubject = preg_replace( "/$searchword/i", '' . $searchword . '', $ressubject );
echo '| '.$ressubject.' | '.date(_DATETIME , $r4->time).' | ';
echo ''._RESULTS_CONTENT.' | ';
echo "
";
}
$i++;
$k=1-$k;
}
echo "
";
}
}
}
}
return $i;
}//if (!$usersearch)
else
{
//search on username...
//get userid from the tables
$database->setQuery("SELECT id FROM #__users WHERE username='".$searchword."'");
$searchuid=$database->loadResult();
$database->setQuery("SELECT b.id, b.parent, b.thread, b.catid, b.name,b.subject, b.time FROM #__sb_messages AS b LEFT JOIN #__sb_users AS u ON b.userid = u.userid WHERE u.userid=$searchuid ORDER by b.time DESC");
//$database->setQuery("SELECT select a.id, a.parent, a.thread, a.catid, a.name, a.subject FROM #__sb_messages AS a JOIN #__sb_users AS u ON a.userid = u.userid WHERE u.userid=$searchuid");
$res=$database->loadObjectList();
$count=count($res);
$tabclass = array("sectiontableentry1", "sectiontableentry2");
$k = 0;
$i=0;
$cellspacing=1;
if($count<>0){
if($show){
echo "";
foreach($res as $r){
if ( in_array($r2->catid,$allowed_forums)){
if($show){
$url = sefRelToAbs('index.php?option=com_simpleboard&Itemid='.$Itemid.'&func=view&catid='.$r->catid.'&id='.$r->id).'#'.$r->id;
echo '';
echo '| '.$r->subject.' | '.date(_DATETIME , $r->time).' | ';
echo ''._RESULTS_USERNAME.' | ';
echo "
";
}
$i++;
$k=1-$k;
}
}
echo "
";
}
return $i;
}//end else
}//end function search
}
?>