SetServer ( $host, $port );
$cl->SetConnectTimeout ( 3 );
$cl->SetArrayResult ( true );
$cl->SetWeights ( array ( 100, 1 ) );
$cl->SetMatchMode ( $mode );
$cl->SetFilter ( $filter, $filtervals );
$cl->SetGroupBy ( $groupby, SPH_GROUPBY_ATTR, $groupsort );
//$cl->SetSortMode ( SPH_SORT_EXTENDED, $sortby );
//$cl->SetSortMode ( SPH_SORT_ATTR_DESC );
$cl->SetGroupDistinct ( $distinct );
$cl->SetSelect ( $select );
$cl->SetLimits ( ( $page * $limit ), $limit, ( $limit>1000 ) ? $limit : 1000 );
$cl->SetRankingMode ( $ranker );
$res = $cl->Query ( $q, $index );
if ( $res===false )
{
print "Query failed: " . $cl->GetLastError() . ".\n";
} else {
if ( $cl->GetLastWarning() ) {
print "WARNING: " . $cl->GetLastWarning() . "\n\n";
};
if ( is_array($res["matches"]) )
{
$n = 1;
foreach ( $res["matches"] as $docinfo )
{
//print "$n. doc_id=$docinfo[id], weight=$docinfo[weight]";
array_push($docids, $docinfo[id]);
}
}
}
$ResultArray = array();
if (count($docids) <= 0 ){
return $ResultArray; // gib leeres array zurück
};
$SqlQuery = SqlQuerySearchSphinx($docids);
$MySqlArray = doSQLQuery( $SqlQuery );
if ( $MySqlArray ) {
while( $sql_results = mysql_fetch_array($MySqlArray)) {
$DESC = $sql_results["DESC"];
$ID = $sql_results["ID"];
$DATE = $sql_results["DATE"];
$CATG = $sql_results["CATG"];
$LINK = $sql_results["LINK"];
$TORRENT = $sql_results["TORRENT"];
$LEECHER = $sql_results["LEECHER"];
$SEEDER = $sql_results["SEEDER"];
$HASH = $sql_results["HASH"];
array_push($ResultArray, "$DESC#####$DATE#####$ID#####$CATG#####$LINK#####$TORRENT#####$LEECHER#####$SEEDER#####$HASH\n");
}; # while( $sql_results = mysql_fetch_array($results)) { }
}; // if ( $MySqlArray ) {
return $ResultArray;
}; # function GenerateResultsSphinx( $SearchQuery, $page, $maxresults ){
function GenerateNewDirectoryResults( $Date, $page, $maxresults ){
$relevance = RELEVANCE;
$tbl = TORRENT_EN_TABLE;
if ( $page == 0 ) { # limit 0, 30;
$from = 0;
} elseif ( $page == 1 ){ # limit 31|62|93|122||,30
$from = ( $maxresults + $page );
} elseif ( $page > 1 ){ # limit 31|62|93|122||,30
$from = ( ( $page * $maxresults ) + $page );
} else {
};
$SearchQuery = strtolower($SearchQuery);
$ResultArray = array();
# short querys
define('ResultsNotNull', "SELECT DISTINCT `DESC` FROM $tbl WHERE `DATE` = \"$Date\" ORDER BY `DESC` DESC LIMIT $from, $maxresults;");
define('ResultsIsNull',"SELECT DISTINCT `DESC` FROM $tbl WHERE `DATE` = \"$Date\" ORDER BY `DESC` DESC LIMIT $maxresults;" );
if ( is_numeric( $page ) && ( $page > 0 ) ) {
$SqlQuery = ResultsNotNull;
} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
$SqlQuery = ResultsIsNull;
};
//echo $SqlQuery;
$MySqlArray = doSQLQuery( $SqlQuery );
if ( $MySqlArray ) {
while( $sql_results = mysql_fetch_array($MySqlArray)) {
$description = $sql_results["DESC"];
//echo "$relevance
";
array_push($ResultArray, "$description\n");
}; # while( $sql_results = mysql_fetch_array($results)) { }
} else {
echo "Konnte die MySQL-Abfrage nicht verarbeiten / Could execute mysql query
\n";
echo "MySQL-Antwort: GenerateDirectoryResults " . mysql_error($MySqlArray);
die();
}; # if ( $MySqlArray ) {
return $ResultArray;
}; # function GenerateNewDirectoryResults( $date, $page, $maxresults ){
function GenerateDirectoryResults( $SearchQuery, $page, $maxresults ){
$relevance = RELEVANCE;
$tbl = TORRENT_EN_TABLE;
if ( $page == 0 ) { # limit 0, 30;
$from = 0;
} elseif ( $page == 1 ){ # limit 31|62|93|122||,30
$from = ( $maxresults + $page );
} elseif ( $page > 1 ){ # limit 31|62|93|122||,30
$from = ( ( $page * $maxresults ) + $page );
} else {
};
$SearchQuery = strtolower($SearchQuery);
$ResultArray = array();
# short querys
define('ResultsNotNull', "SELECT DISTINCT `DESC` FROM $tbl WHERE `DESC` LIKE(\"$SearchQuery%\") ORDER BY `DESC` DESC LIMIT $from, $maxresults;");
define('ResultsIsNull',"SELECT DISTINCT `DESC` FROM $tbl WHERE `DESC` LIKE(\"$SearchQuery%\") ORDER BY `DESC` DESC LIMIT $maxresults;" );
if ( is_numeric( $page ) && ( $page > 0 ) ) {
$SqlQuery = ResultsNotNull;
} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
$SqlQuery = ResultsIsNull;
};
//echo $SqlQuery;
$MySqlArray = doSQLQuery( $SqlQuery );
if ( $MySqlArray ) {
while( $sql_results = mysql_fetch_array($MySqlArray)) {
$description = $sql_results["DESC"];
//echo "$relevance
";
array_push($ResultArray, "$description\n");
}; # while( $sql_results = mysql_fetch_array($results)) { }
} else {
echo "Konnte die MySQL-Abfrage nicht verarbeiten / Could execute mysql query
\n";
echo "MySQL-Antwort: GenerateDirectoryResults " . mysql_error($MySqlArray);
die();
}; # if ( $MySqlArray ) {
return $ResultArray;
}; # function GenerateDirectoryResults( $SearchQuery, $page, $maxresults ){
function GenerateResults( $SearchQuery, $page, $maxresults ){
$relevance = RELEVANCE;
$tbl = TORRENT_EN_TABLE;
if ( $page == 0 ) { # limit 0, 30;
$from = 0;
} elseif ( $page == 1 ){ # limit 31|62|93|122||,30
$from = ( $maxresults + $page );
} elseif ( $page > 1 ){ # limit 31|62|93|122||,30
$from = ( ( $page * $maxresults ) + $page );
} else {
};
$SearchQuery = strtolower($SearchQuery);
$ResultArray = array();
# short querys
define('ResultsNotNull', "SELECT *,MATCH(`DESC`) AGAINST(\"$SearchQuery\") AS relevance FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") ORDER by relevance DESC LIMIT $from, $maxresults;");
define('ResultsIsNull',"SELECT *,MATCH(`DESC`) AGAINST(\"$SearchQuery\") AS relevance FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") ORDER by relevance DESC LIMIT $maxresults;" );
if ( is_numeric( $page ) && ( $page > 0 ) ) {
$SqlQuery = ResultsNotNull;
} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
$SqlQuery = ResultsIsNull;
};
//echo $SqlQuery;
$MySqlArray = doSQLQuery( $SqlQuery );
if ( $MySqlArray ) {
$last_desc = "";
$results_tmp = "";
$count = 0;
while( $sql_results = mysql_fetch_array($MySqlArray)) {
$DESC = $sql_results["DESC"];
$DATE = $sql_results["DATE"];
$ID = $sql_results["ID"];
if ( strcasecmp($results_tmp, $DESC) == 0 ) {
echo "both entries same";
trim($ResultArray[$count-1]);
$ResultArray[$count-1] = $ResultArray[$count-1] . ",$ID\n";
} else {
array_push($ResultArray, "$DESC#####$DATE#####$ID\n");
};
$last_desc = $DESC;
$count++;
}; # while( $sql_results = mysql_fetch_array($results)) { }
} else {
echo "Konnte die MySQL-Abfrage nicht verarbeiten / Could execute mysql query
\n";
echo "MySQL-Antwort: GenerateResults " . mysql_error($MySqlArray);
die();
}; # if ( $MySqlArray ) {
## print_r($ResultArray);
return $ResultArray;
}; # function GenerateResults( $SearchQuery, $page ){
?>