rendered paste body<?php/********************************************************************************* RADIUM SYSTEMS LTDA** Component C-Publisher* Authors: Gustavo B. Oliveira* Date: 23/05/2002* Description: Search result page** CVS Status* $Id: search_engine.php,v 1.11 2006/10/23 13:10:34 handrus Exp $**********************************************************************************///Cleaning the search parameter$l_strSearch = strip_tags($l_strSearch);if ( $l_strSearch == '' || $l_strSearch == NULL ) { header("Location: search_error.php"); exit;}if (($l_intBuscaLib == NULL)&&($l_intBuscaEvt == NULL)&&($l_intBuscaPess == NULL)&&($l_intBuscaPub == NULL)&&($l_intBuscaFor == NULL)&&($l_intBuscaPR == NULL)) { header("Location: search_error.php"); exit;}//Ok to includeunset ($checkpermission);$checkpermission = 0; // Initialization of variablesinclude_once("incCPub/comuns.inc");/*if (!$f_iLogged) { loginGuest($_SERVER['REQUEST_URI']); exit;}*///Including archievesinclude_once('packSearch/classSearch.cd');include_once('packLib/classLibDoc.cd');include_once('packEvent/classEvent.cd');include_once("packForumRadium/classForMsg.cd");include_once("packForumRadium/classForMsg.cd");if (!$f_iLogged) { // Se não estiver logado, atribui as permissões padrão $f_arrData["usrcod"] = 0; $f_arrData["groups"] = DEFAULT_COMMUNITY;}//Create a Data Access Abstract Layer$l_objDataAccessServices = new DataAccessServices();//Receiving the Connection to the Database$l_objConnection = $l_objDataAccessServices->OpenDataServices();//Creating the object$l_objSearch = new Search($l_objConnection);unset($l_arrSearchEngine);$l_intCount = 0;unset($l_output);//********** Search Newsif ($l_intBuscaPub == 1) { $l_arrSearchEngine = $l_objSearch->SearchEngine($l_strSearch, $f_arrData['community']); while ( $l_intCount < count($l_arrSearchEngine) ){ $l_outputNews .= '<tr>'; $l_outputNews .= '<td class="BuscaText5" valign="top">'.$l_arrSearchEngine[$l_intCount]["data"].'</td>'; $l_outputNews .= '</tr>'; $l_outputNews .= '<tr>'; $l_outputNews .= '<td valign="top"><a class="BuscaLink3" href="search_page.php?l_intNewCod='.$l_arrSearchEngine[$l_intCount]["codigo"].'">'.$l_arrSearchEngine[$l_intCount]["titulo"].'</a></td>'; $l_outputNews .= '</tr><tr><td> </td></tr>'; $l_intCount++; } $counter_news = $l_intCount;}//********** Search Eventif ($l_intBuscaEvt == 1) { $l_objEvent = new Event($l_objConnection); $l_arrSearchEngine = $l_objEvent->frontSearch($l_strSearch, $f_arrData['community']); $l_intAux = 0; while ( $l_arrEvt = $l_arrSearchEngine->next() ) { $l_outputEvt .= '<tr>'; $l_outputEvt .= '<td colspan="2" class="BuscaLink3"> <a class="BuscaLink3" href="/event/pages/vieweventf.php?l_intEvtCod='.$l_arrEvt["evtcod"].'">'.$l_arrEvt["evttit"].'</a></td>'; $l_outputEvt .= "<td colspan='2'><pre>".var_dump($l_arrEvt).'</pre></td>'; $l_outputEvt .= '</tr>'; $l_outputEvt .= '<tr><td colspan="2"> </td></tr>'; $l_intAux++; } $l_intCount += $l_intAux; $counter_evt = $l_intAux;}//********** Search Usersif ($l_intBuscaPess == 1) { $l_objSearch1 = new Search($l_objConnection); $l_arrUser = $l_objSearch1->searchUser($l_strSearch, $f_arrData['community']); $l_intAux = 0; while ( $l_intAux < count($l_arrUser) ) { $l_outputPeople .= '<tr>'; $l_outputPeople .= '<td valign="top"><a class="BuscaLink3" href=\'javascript:popup2("/register/pages/impdig.php?l_intUsrCod='.$l_arrUser[$l_intAux]["codigo"].'&pop=1", "ImpDig", "392", "600", "0", "0", "yes");\'>'.$l_arrUser[$l_intAux]["titulo"].'</a></td>'; $l_outputPeople .= '</tr>'; $l_intAux++; } $l_intCount += $l_intAux; $counter_people = $l_intAux;}//********** Search Library Docsif ($l_intBuscaLib == 1) { $l_intAux = 0; $l_objDoc = new LibDoc($l_objConnection); $l_objRecordSet = $l_objDoc->frontSearch($l_strSearch, $g_arrUsrData["usrcod"], $g_arrUsrData["groups"], "0", $f_arrData['community']); while ($l_arrRow = $l_objRecordSet->next()) { $find = 1; $l_outputDoc .= '<tr><td><table width="100%"><tr><td align="left" class="BuscaLink3"><a class="BuscaLink3" href="javascript:viewdoc('.$l_arrRow["doccod"].');">'.$l_arrRow["doctitle"].'</a><br><br></td></tr></table></td></tr>'; $l_intAux++; } $l_intCount += $l_intAux; $counter_docs = $l_intAux;}//********* Search Forum$l_objForMsg = new ForMsg($l_objConnection);if ($l_intBuscaFor == 1) { //Forum $l_intAux = 0; $l_arrSubject = $l_objForMsg->SearchEngine($l_strSearch, null, null, IS_FOR_FORUM, $f_arrData['community']); $l_intAux = count($l_arrSubject['assunto']); for($i = 0; $i < $l_intAux; $i++) { $assunto = $l_arrSubject['descricao'][$i]; $l_outputForum .= '<tr> <td align="left" class="BuscaLink3"> <a class="BuscaLink3" href="/forum/pages/forummsg.php?l_intFocCod='.$l_arrSubject['categoria'][$i]."&l_intFosCod=".$l_arrSubject['subcat'][$i]."&l_intFasCod=".$l_arrSubject['assunto'][$i].'">'.$assunto.'</a><br> </td> </tr>'; } $l_intCount += $l_intAux; $counter_forum = $l_intAux;}//********* Search Faq//include_once("incReg/permission.inc");//if ($f_isLogged)//{if ($l_intBuscaPR == 1) { //Faq $l_intAux = 0; $l_arrSubject = $l_objForMsg->SearchEngine($l_strSearch, null, null, IS_FOR_FAQ, $f_arrData['community']); $l_intAux = count($l_arrSubject['assunto']); for($i = 0; $i < $l_intAux; $i++) { $pergunta = $l_arrSubject['descricao'][$i]; $l_outputFaq .= '<tr> <td align="left" class="BuscaLink3"> <a class="BuscaLink3" href="/faq/pages/forummsg.php?l_intFocCod='.$l_arrSubject['categoria'][$i]."&l_intFosCod=".$l_arrSubject['subcat'][$i]."&l_intFasCod=".$l_arrSubject['assunto'][$i].'">'.$pergunta.'</a><br> </td> </tr>'; } $l_intCount += $l_intAux; $counter_faq = $l_intAux;}//}//Closing the connection$l_objDataAccessServices->CloseDataServices($l_objConnection);// Header of communityif (isset($f_arrData['community'])) { $header = "header_".$f_arrData['community']; $header = "ltCPub/".$$header; include($header);}else { //include("ltCPub/header_pre_login.php"); include("incCPub/page_header.inc");}//include('ltCPub/basic_page_header.php');?><script language="javascript">function viewdoc(cod) { window.open("/lib/pages/viewdoc.php?l_intDocCod="+cod, "viewdoc", "directories=no,height=480,width=540,hotkeys=no,location=no,menubar=no,resizable=no,scrollbars=yes,status=no,toolbar=no,copyhistory=no");}function showdoc(cod) { window.open("/lib/pages/download.php?l_intDocCod="+cod+"&l_intView=1", "showdoc", "directories=no,height=480,width=540,hotkeys=no,location=no,menubar=no,resizable=no,scrollbars=yes,status=no,toolbar=no,copyhistory=no");}function addfav(cod) { window.open("/lib/pages/insfav.php?l_intDocCod="+cod, "addfav", "directories=no,height=480,width=540,hotkeys=no,location=no,menubar=no,resizable=no,scrollbars=yes,status=no,toolbar=no,copyhistory=no");}</script><table width="100%" border="0" cellspacing="0" cellpadding="5"> <tr> <td width="12"> </td> <td width="743"> </td> </tr> <td width="12"> </td> <td> <table bgcolor="<?php echo MAIN_COLOR; ?>" width="100%" cellpadding="0" cellspacing="0" border="0"> <tr> <td colspan="3" bgcolor="#ffffff" class="BuscaText5"><b>Resultados da Busca por:</b> <font class="BuscaText3"><?php echo $l_strSearch; ?></font></td> </tr> <tr> <td width="100%"> <table bgcolor="<?php echo MAIN_COLOR; ?>" width="100%" cellpadding="0" cellspacing="0" border="0"> <tr><td> </td></tr> <tr> <td><font class="BuscaText5"><?php echo LABEL_SEARCH_RESULT; ?></font><font class="BuscaText2"><?php echo $l_intCount; ?></font></td> </tr> <tr> <td width="100%"> </td> </tr> <tr> <td width="100%"> <table bgcolor="#FFFFFF" width="80%" cellpadding="0" cellspacing="5" border="0"> <tr> <?php if ($l_intBuscaLib == 1) { ?> <td align="left" class="BuscaText2"><?php if($counter_docs > 0){ ?><a href="#documentos" class="BuscaLink3">Documentos</a><?php }else{ ?>Documentos<?php } echo ": ".$counter_docs; ?></td> <?php } ?> <?php if ($l_intBuscaEvt == 1) { ?> <td align="left" class="BuscaText2"><?php if($counter_evt > 0){ ?><a href="#eventos" class="BuscaLink3">Eventos</a><?php }else{ ?>Eventos<?php } echo ": ".$counter_evt; ?></td> <?php } ?> <?php if ($l_intBuscaPess == 1) { ?> <td align="left" class="BuscaText2"><?php if($counter_people > 0){ ?><a href="#pessoas" class="BuscaLink3">Pessoas</a><?php }else{ ?>Pessoas<?php } echo ": ".$counter_people; ?></td> <?php } ?> <?php if ($l_intBuscaPub == 1) { ?> <td align="left" class="BuscaText2"><?php if($counter_news > 0){ ?><a href="#noticias" class="BuscaLink3">Notícias</a><?php }else{ ?>Notícias<?php } echo ": ".$counter_news; ?></td> <?php } ?> <?php if ($l_intBuscaFor == 1) { ?> <td align="left" class="BuscaText2"><?php if($counter_forum > 0){ ?><a href="#forum" class="BuscaLink3">Fórum</a><?php }else{ ?>Fórum<?php } echo ": ".$counter_forum; ?></td> <?php } ?> <?php if ($l_intBuscaPR == 1) { ?> <td align="left" class="BuscaText2"><?php if($counter_faq > 0){ ?><a href="#faq" class="BuscaLink3">P&R</a><?php }else{ ?>P&R<?php } echo ": ".$counter_faq; ?></td> <?php } ?> </tr> </table> </td> </tr> <tr> <!-- Begin Documentos --> <?php if($l_outputDoc != '') { ?> <tr><td> </td></tr> <tr> <td width="100%" align="left" valign="top"> <table width="100%" cellpadding="3" cellspacing="3" style="border: 1px solid #669966;" border="0"> <tr> <td bgcolor="<?php echo CPUB_CSS_COLOR_8; ?>" valign="top" class="BuscaText6"><a name="documentos">Documentos</a></td> </tr> <tr> <td width="100%" valign="top"> <table width="100%" cellpadding="3" cellspacing="3" border="0" style="border: 1px solid #669966;"> <?php echo $l_outputDoc; ?> </table> </td> </tr> </table> </td> </tr> <?php } ?> <!-- End Documentos --> <!-- Begin Eventos --> <?php if($l_outputEvt != '') { ?> <tr><td> </td></tr> <tr> <td width="100%" align="left" valign="top"> <table width="100%" cellpadding="2" cellspacing="2" border="0" style="border: 1px solid #669966;"> <tr bgcolor="<?php echo CPUB_CSS_COLOR_8;?>"> <td width="100%" align='left' valign='top' class='BuscaText6'><a name='eventos' class='BuscaText6'>Eventos</a></td> </tr> <tr> <td width="100%" valign="top"> <table width="100%" cellpadding="2" cellspacing="0" border="0" style="border: 1px solid #669966;"> <?php echo $l_outputEvt; ?> </table> </td> </tr> </table> </td> </tr> <?php } ?> <!-- End Eventos --> <!-- Begin Pessoas --> <?php if($l_outputPeople != '') { ?> <tr><td><br> <br><br></td></tr> <tr> <td width="100%" align="left" valign="top"> <table width="100%" cellpadding="3" cellspacing="3" border="0" style="border: 1px solid #669966;"> <tr> <td bgcolor="<?php echo CPUB_CSS_COLOR_8; ?>" valign="top" class="BuscaText6"><a name="pessoas">Pessoas</a></td> </tr> <tr> <td width="100%" valign="top"> <table width="100%" cellpadding="2" cellspacing="0" border="0" style="border: 1px solid #669966;"> <?php echo $l_outputPeople; ?> </table> </td> </tr> </table> </td> </tr> <?php } ?> <!-- End Pessoas --> <!-- Begin Conteudos --> <?php if($l_outputNews != '') { ?> <tr><td><br> <br><br></td></tr> <tr> <td width="100%" align="left" valign="top"> <table width="100%" cellpadding="3" cellspacing="3" border="0" style="border: 1px solid #669966;"> <tr> <td bgcolor="<?php echo CPUB_CSS_COLOR_8; ?>" valign="top" class="BuscaText6"><a name="noticias">Notícias</a></td> </tr> <tr> <td width="100%" valign="top"> <table width="100%" cellpadding="3" cellspacing="3" border="0" style="border: 1px solid #669966;"> <?php echo $l_outputNews; ?> </table> </td> </tr> </table> </td> </tr> <?php } ?> <!-- End Conteudos --> <!-- Begin Fórum --> <?php if($l_outputForum != '') { ?> <tr><td><br> <br><br></td></tr> <tr> <td width="100%" align="left" valign="top"> <table width="100%" cellpadding="3" cellspacing="3" border="0" style="border: 1px solid #669966;"> <tr> <td bgcolor="<?php echo CPUB_CSS_COLOR_8; ?>" valign="top" class="BuscaText6"><a name="forum">Fórum</a></td> </tr> <tr> <td width="100%" valign="top"> <table width="100%" cellpadding="3" cellspacing="3" border="0" style="border: 1px solid #669966;"> <?php echo $l_outputForum; ?> </table> </td> </tr> </table> </td> </tr> <?php } ?> <!-- End Fórum --> <!-- Begin Faq --> <?php if($l_outputFaq != '') { ?> <tr><td><br> <br><br></td></tr> <tr> <td width="100%" align="left" valign="top"> <table width="100%" cellpadding="3" cellspacing="3" border="0" style="border: 1px solid #669966;"> <tr> <td bgcolor="<?php echo CPUB_CSS_COLOR_8; ?>" valign="top" class="BuscaText6"><a name="faq">P&R</a></td> </tr> <tr> <td width="100%" valign="top"> <table width="100%" cellpadding="3" cellspacing="3" border="0" style="border: 1px solid #669966;"> <?php echo $l_outputFaq; ?> </table> </td> </tr> </table> </td> </tr> <?php } ?> <!-- End Faq --> </table> </td> </tr> <tr><td> </td></tr> </table></td></tr></table><!-- Closing headers tables --><?phpinclude('ltCPub/basic_page_footer.php');include("ltRA/footerfront.php");?>