".$lang['nash4600']),1);?>
()
()~]*[']?[A-z0-9+. -*<>()~]*\042?$/",$keywords)>0||preg_match("/^[a-z0-9_.-]+@[a-z0-9_-]+\.([a-z0-9_.]+)*[a-z0-9_.]$/",$keywords)>0) { $keywords = preg_replace(array('/\045/'),array('percent'),$keywords); $keywords = trim($keywords); $keywords = stripslashes($keywords); if ($setts['boolean_operator']=="AND") $keywords = preg_replace(array('/\s/'),array(' AND '),$keywords); else if ($setts['boolean_operator']=="OR") $keywords = preg_replace(array('/\s/'),array(' OR '),$keywords); else if ($setts['boolean_operator']=="NOT") $keywords = preg_replace(array('/\s/'),array(' NOT '),$keywords); } else { $keywords = ""; } $problema = FALSE; if (preg_match("/(select|insert|delete|drop).*(from|into)/is",$keywords)) $problema = TRUE; if ($problema==TRUE) { echo ""; exit(); } if (preg_match("/\sAND\s/i",$keywords,$matches)>0) { $burst = $matches[0]; $terms = explode($burst,$keywords); $boolean = TRUE; $split = "AND"; } else if (preg_match("/\sOR\s/i",$keywords,$matches)>0) { $burst = $matches[0]; $terms = explode($burst,$keywords); $boolean = TRUE; $split = "OR"; } else if (preg_match("/\sNOT\s/i",$keywords,$matches)>0) { $burst = $matches[0]; $terms = explode($burst,$keywords); $boolean = TRUE; $split = "NOT"; } if ($boolean==TRUE&&$split=="OR") $query = "SELECT * FROM nash_help_topics WHERE MATCH(content) AGAINST ('".((trim($terms[0])!="")?$terms[0]." ":"").((trim($terms[1])!="")?$terms[1]." ":"").((trim($terms[2])!="")?$terms[2]." ":"").((trim($terms[3])!="")?$terms[3]." ":"").((trim($terms[4])!="")?$terms[4]." ":"").((trim($terms[5])!="")?$terms[5]:"")."' IN BOOLEAN MODE)"; else if ($boolean==TRUE&&$split=="AND") $query = "SELECT * FROM nash_help_topics WHERE MATCH(content) AGAINST ('".((trim($terms[0])!="")?"+".$terms[0]." ":"").((trim($terms[1])!="")?"+".$terms[1]." ":"").((trim($terms[2])!="")?"+".$terms[2]." ":"").((trim($terms[3])!="")?"+".$terms[3]." ":"").((trim($terms[4])!="")?"+".$terms[4]." ":"").((trim($terms[5])!="")?"+".$terms[5]:"")."' IN BOOLEAN MODE)"; else if ($boolean==TRUE&&$split=="NOT") $query = "SELECT * FROM nash_help_topics WHERE MATCH(content) AGAINST ('".((trim($terms[0])!="")?"-".$terms[0]." ":"").((trim($terms[1])!="")?"-".$terms[1]." ":"").((trim($terms[2])!="")?"-".$terms[2]." ":"").((trim($terms[3])!="")?"-".$terms[3]." ":"").((trim($terms[4])!="")?"-".$terms[4]." ":"").((trim($terms[5])!="")?"-".$terms[5]:"")."' IN BOOLEAN MODE)"; else $query = "SELECT * FROM nash_help_topics WHERE MATCH(content) AGAINST ('".$keywords."' IN BOOLEAN MODE)"; $limit = ((int)$_REQUEST['limit']==0)?((!$s_nb_items_per_page)?$setts['nbRecordsPerLoad']:$s_nb_items_per_page):(int)$_REQUEST['limit']; $curPageNumber = ((int)$_REQUEST['curPageNumber']==0)?1:(int)$_REQUEST['curPageNumber']; $start = ((int)$_REQUEST['curPageNumber']==0)?(int)$_REQUEST['start']:(($curPageNumber-1)*$limit); $additionalVars = "&searchhelp=".$_REQUEST['searchhelp']; $totalResults = getSqlNumber("user",$query); if ($totalResults>0) { $resultsQuery = getSqlResults("user",$query." LIMIT ".$start.",".$limit); //echo $query." LIMIT ".$start.",".$limit; //debugger!?>
"":