")==FALSE && strstr($tmpowsQuery,"* ")==FALSE) { if(strstr($owsQuery," ")==FALSE) { $tmpowsQuery="\\\"".trim($owsQuery)."\\\""; $owsQuery=$tmpowsQuery; } else { $tmpowsQuery="+\\\"".trim($owsQuery); $owsQuery=str_replace(" ","\\\" +\\\"",$tmpowsQuery); $owsQuery.="\\\""; } } return $owsQuery; } function DrawPages($page,$results,$resultsperpage,$query) { $lbound=0; $rbound=0; if($page<0) $page=0; if($page-10<0) $lbound=0; else $lbound=$page-10; if($page+10>$results/$resultsperpage) $rbound=$results/$resultsperpage; else $rbound=$page+10; for($i=$lbound;$i<$rbound;$i++) { if($i!=$page) printf("%d\r\n",urlencode($query),$i,$i+1); else printf("%d ",$i+1); } } function microtime_float() { list($usec, $sec) = explode(" ", microtime()); return ((float)$usec + (float)$sec); } function fSearch($search,$page,$server,$user,$pass,$database,$log,$ResultsPerPage) { $my_search=mysql_escape_string($search); $db = mysql_connect($server, $user, $pass); if ($db == FALSE) die ("Error 1 [mysql_connect()]: Can't connect to mysql server"); mysql_select_db($database, $db) or die ("Error 2 [mysql_select_db()]"); if($page=="") $page=0; $start = microtime_float(); $query = "select max(match(html,description,hostname,page) against(\"".owssize($my_search)."\" in boolean mode)) from pagelist where match(html,description,hostname,page) against(\"".owssize($my_search)."\" in boolean mode)" ; $result = mysql_query($query, $db); $row = mysql_fetch_array($result); $minword=$row[0]; if($minword==0) $minword=1; $query = "select count(*) from pagelist where match(html,description,hostname,page) against(\"".owssize($my_search)."\" in boolean mode) >=".(int)abs($minword); $result = mysql_query($query, $db); $row = mysql_fetch_array($result); $resultsfound=$row[0]; if( $page>$resultsfound/$ResultsPerPage) $page=(int)abs($resultsfound/$ResultsPerPage); $query = "select hostname,page,description,match(html,description,hostname,page) against(\"".owssize($my_search)."\") + match(description) against(\"".owssize($my_search)."\") as relevancy,match(html,description,hostname,page) against(\"".owssize($my_search)."\" in boolean mode) as wrdcount,idpage,rank, LEFT(html, 400),level from pagelist where match(html,description,hostname,page) against(\"".owssize($my_search)."\" in boolean mode) >=".(int)abs($minword)." order by wrdcount DESC,relevancy DESC,rank DESC limit ".($page*$ResultsPerPage).",".$ResultsPerPage ; $result = mysql_query($query, $db); $nRes= mysql_num_rows($result); $endtime = abs(number_format(microtime_float()-$start,3)); ?>
Query: - results found in seconds
".$words[$i]."", $mText); $mText=$new_text; } ?>
">
...
Relevancy: - Word found: - Level: - Rank: ">Text cache


"; DrawPages($page,$resultsfound,$ResultsPerPage,htmlspecialchars($search)); echo "

"; $ip=getenv("REMOTE_ADDR"); if($log==1) { $var=fopen("query.log","a"); if($var!=NULL) { $tm=strftime ("%A %d %B %Y %H:%M"); $log= "$tm\t\t$ip\t\t$search\r\n"; fwrite($var,$log); fclose($var); } } else if($log=2) { $query = "INSERT INTO querylist (query,results,date,time,ipaddr) VALUES('$my_search',$resultsfound,curdate(),curtime(),'$ip')"; $result = mysql_query($query, $db); } mysql_close($db); } ?>