<?php

require_once ("/srv/server/wwwbiz/lib/sql.inc.php");
require_once ("/srv/server/wwwbiz/lib/config.inc.php");
require_once ("/srv/server/wwwbiz/lib/usenext.inc.php");
require_once ("/srv/server/wwwbiz/lib/time.inc.php");
require_once ("/srv/server/wwwbiz/lib/caching.inc.php");

#  array_push($ResultArray, "$LINK#!?#-.>#$DESC#!?#-.>#$DATE#!?#-.>#$CATG\n");  #########################

######################

# GenerateResults( $SearchQuery )
# _UsenextResults ( $SearchQuery)
# _CrackResults( $SearchQuery )
# _SerialResults( $SearchQuery )
# _SongtextResults( $SearchQuery )
# _TorrentResults( $SearchQuery )
# _EmuleResults( $SearchQuery )
# _NewsResults( $SearchQuery )
# _SoftwareResults( $SearchQuery )
# _SubtitleResults( $SearchQuery )


function _SubtitleResults( $SearchQuery ){
	
	# suchwort in kleinbuchstaben und ohne leerzeichen am anfang
	$SearchQueryOrg		= urlencode(trim(strtolower($SearchQuery)));	
	$UrlGrabbingArray	= array();

	$maxresults			= MAXRESULTS;
	$page				= $_SESSION['PAGE'];
	
	if ( $page == 0 ) {	
		$from	= $maxresults;
		$start  = 0;
	} elseif ( $page == 1 ){						# limit 60|120|180|240|320|
		$from	= ( $maxresults + $maxresults + 1 );
		$start	= $maxresults + 1;					# 0-60;60-120;120-180;
	} elseif ( $page > 1 ){							# limit 60|120|180|240|320|
		$from	= ( $page * $maxresults ) + $page;
		$start	= $from - ($maxresults + $page);	# 0-60;60-120;120-180;
	};

	# http://www.opensubtitles.org/fr/search2/sublanguageid-fre/moviename-matrix
	# $SubTitleGrabbingUrl = "http://www.opensubtitles.org/en/search/sublanguageid-all/perpage-$from/moviename-$SearchQueryOrg/simplexml";
	$SubTitleGrabbingUrl = "http://www.opensubtitles.org/fr/search/sublanguageid-fre/perpage-$from/moviename-$SearchQueryOrg/simplexml";
	$DATE = GetSQlDateEn();

	####################
	###### Read Cache
	####################
	
	# nur $SearchQueryOrg würde bei deutscher suche auch englische results anzeigen, wenn ein cache vorliegt!
	$ResultArray	= ReadCache( WEBCACHESUBTITLE, $SearchQueryOrg . $_SESSION['LANG'] . $page );	

	if ( is_array($ResultArray) ){ 
		return $ResultArray;
	} else {
		$ResultArray = array();
	};
	
	####################
	###### Read Cache Ende
	####################
	
	$rawFeed	= file_get_contents($SubTitleGrabbingUrl);
	
	# diese if anweisung sorgt dafür, dass wenn der remote server hängt, die zoozle seite trotzdem angezeigt wird
	if ( strlen($rawFeed) > 100) {
		
		$counter	= 0;
		$xml		= new SimpleXmlElement($rawFeed);

		foreach ( $xml->results->subtitle as $item ){     
	
			$LINK	= "http://www.opensubtitles.org" . $item->detail;
			$DESC	= $item->movie;
			$CATG	= "fr";
			
			# strlen($DESC) > 2 && : wenn dateibeschreibung passt und sich der counter im rahmen der anzuzeigenden ergebnisse pro seite bewegt
			if ( ( $counter >= $start && $counter <= $from ) ) {
				array_push($ResultArray, "$LINK#!?#-.>#$DESC#!?#-.>#$DATE#!?#-.>#$CATG\n");
			};

			$counter++;
		
		}; # foreach ($xml->results->subtitle as $item ){    

	}; # if ( strlen($rawFeed) > 100) {

	
	return $ResultArray;

}; # function _SubtitleResults(){



function _EmuleResults( $SearchQuery ){

	$maxresults		= MAXRESULTS;
	$relevance		= RELEVANCE;
	$tbl			= EMULE_TABLE;

	$language		= $_SESSION['LANG'];
	$page			= $_SESSION['PAGE'];

	
	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 {
	};

/*
	if ( $page == 0 ) {					# limit 0, 30;
		$from = 0;						
	} elseif ( $page >= 1 ){			# limit 31|62|93|122||,30
		$from = ( ( $page * $maxresults ) + $page ); 
	} else {
	};
*/

	$SearchQuery	= strtolower($SearchQuery);
	$ResultArray	= array();

/*
	# SQL Querys Predefined
	define('EmuleResultsNotNull', "SELECT DISTINCT `DESC`, `LINK`, `DATE` , `CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE ( MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ) OR (`DESC` like (\"%$SearchQuery%\")) ORDER BY RANG DESC, DATE DESC LIMIT $from, $maxresults");

	define('EmuleResultsIsNull',"SELECT DISTINCT `DESC`, `LINK`, `DATE` ,`CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE ( MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ) OR (`DESC` like (\"%$SearchQuery%\")) ORDER BY RANG DESC, DATE DESC LIMIT $maxresults" );


	define('EmuleResultsNotNullLang', "SELECT DISTINCT `DESC`, `LINK`, `DATE` , `CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE ( MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ) OR (`DESC` like (\"%$SearchQuery%\")) AND (`CATG`) LIKE ('$language') ORDER BY RANG DESC, DATE DESC LIMIT $from, $maxresults");

	define('EmuleResultsIsNullLang', "SELECT DISTINCT `DESC`, `LINK`, `DATE` ,`CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE ( MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ) OR (`DESC` like (\"%$SearchQuery%\")) AND (`CATG`) LIKE ('$language') ORDER BY RANG DESC, DATE DESC LIMIT $maxresults");
*/


	# short querys
	define('EmuleResultsNotNull', "SELECT * FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") LIMIT $from, $maxresults");
	define('EmuleResultsIsNull',"SELECT * FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") LIMIT $maxresults" );
	define('EmuleResultsNotNullLang', "SELECT * FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND `CATG` = '$language' LIMIT $from, $maxresults");
	define('EmuleResultsIsNullLang', "SELECT * FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND `CATG` = '$language' LIMIT $maxresults");


	if ( !strcasecmp($language, "") == 0 ) {
		
		if ( is_numeric( $page ) && ( $page > 0 ) ) {
			$SqlQuery	= EmuleResultsNotNullLang;
		
		} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
			$SqlQuery = EmuleResultsIsNullLang;
		
		};
	
	} else { 

		if ( is_numeric( $page ) && ( $page > 0 ) ) {
			$SqlQuery = EmuleResultsNotNull;
		} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
			$SqlQuery = EmuleResultsIsNull;
		};

	}; # if ( !strcasecmp($language, "") == 0 ) {

	####################
	###### Read Cache
	####################

	$ResultArray = ReadCache( WEBCACHEEMULE, $SqlQuery );

	# bekomme ich einen integer zurück, somit greift dann das caching nicht
	# if ( ( is_array($ResultArray) ) && ( $ResultArray != -1 ) ){ 
	
	if ( is_array($ResultArray) ){ 
		return $ResultArray;
	} else {
		$ResultArray = array();
	};

	####################
	###### Read Cache Ende
	####################


	$MySqlArray = doSQLQueryZoozle( $SqlQuery );

	if ( $MySqlArray ) {

		while( $sql_results = mysql_fetch_array($MySqlArray)) {

			$LINK = $sql_results["LINK"];
			$DATE = $sql_results["DATE"];
			$CATG = $sql_results["CATG"];
			#$RANK = $sql_results["RANG"];
			#$RANK = substr($RANK, 0, 5);
			$DESC = iconv("UTF-8", "ISO-8859-1", $sql_results["DESC"] );

			if ( strlen($sql_results["DESC"]) > ( strlen($DESC) + 3) ){
				$DESC = $sql_results["DESC"];
			};

			array_push($ResultArray, "$LINK#!?#-.>#$DESC#!?#-.>#$DATE#!?#-.>#$CATG\n");

		}; # while( $sql_results = mysql_fetch_array($results)) { }

    } else {
		
		echo "Konnte die MySQL-Abfrage nicht verarbeiten / Could execute mysql query <br />\n";
		echo "MySQL-Antwort: " . mysql_error();
	#	die();

	};  # if ( $MySqlArray ) {

	return $ResultArray;

}; # function _EmuleResults( $SearchQuery ){





function _TorrentResults( $SearchQuery ){

	$maxresults		= MAXRESULTS;
	$relevance		= RELEVANCE;
	$tbl			= TORRENT_TABLE;
	$torrent_life	= TORRENT_LIFETIME_NORMAL;

	$language		= $_SESSION['LANG'];
	$page			= $_SESSION['PAGE'];
	
	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();

/*
	# SQL Querys Predefined

	define('TorrentResultsNotNull', "SELECT DISTINCT `DESC`, `LINK`, `DATE` , `CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE DATE_SUB(CURDATE(),INTERVAL $torrent_life DAY) <= `DATE` AND ( MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ) OR (`DESC` like (\"%$SearchQuery%\")) ORDER BY RANG DESC, DATE DESC, CATG DESC LIMIT $from, $maxresults");

	define('TorrentResultsIsNull',"SELECT DISTINCT `DESC`, `LINK`, `DATE` ,`CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE DATE_SUB(CURDATE(),INTERVAL $torrent_life DAY) <= `DATE` AND ( MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ) OR (`DESC` like (\"%$SearchQuery%\")) ORDER BY RANG DESC, DATE DESC, CATG DESC LIMIT $maxresults" );

	define('TorrentResultsNotNullLang', "SELECT DISTINCT `DESC`, `LINK`, `DATE` , `CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE DATE_SUB(CURDATE(),INTERVAL $torrent_life DAY) <= `DATE` AND ( MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ) OR (`DESC` like (\"%$SearchQuery%\")) AND (`CATG`) LIKE ('$language') ORDER BY RANG DESC, DATE DESC, CATG DESC LIMIT $from, $maxresults");

	define('TorrentResultsIsNullLang', "SELECT DISTINCT `DESC`, `LINK`, `DATE` ,`CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE DATE_SUB(CURDATE(),INTERVAL $torrent_life DAY) <= `DATE` AND ( MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ) OR (`DESC` like (\"%$SearchQuery%\")) AND (`CATG`) LIKE ('$language') ORDER BY RANG DESC, DATE DESC, CATG DESC LIMIT $maxresults");
*/

	# SQL short Querys Predefined
	define('TorrentResultsNotNull', "SELECT * FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") LIMIT $from, $maxresults");
	define('TorrentResultsIsNull',"SELECT * FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") LIMIT $maxresults" );
	define('TorrentResultsNotNullLang', "SELECT * FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND `CATG` = '$language' LIMIT $from, $maxresults");
	define('TorrentResultsIsNullLang', "SELECT * FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND `CATG` = '$language' LIMIT $maxresults");


	if ( !strcasecmp($language, "") == 0 ) {
		
		if ( is_numeric( $page ) && ( $page > 0 ) ) {
			$SqlQuery = TorrentResultsNotNullLang;
		} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
			$SqlQuery = TorrentResultsIsNullLang;
		};
	
	} else { 

		if ( is_numeric( $page ) && ( $page > 0 ) ) {
			$SqlQuery = TorrentResultsNotNull;
		} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
			$SqlQuery = TorrentResultsIsNull;
		};

	}; # if ( !strcasecmp($language, "") == 0 ) {


	####################
	###### Read Cache
	####################

	$ResultArray = ReadCache( WEBCACHETORRENT, $SqlQuery );

	# bekomme ich einen integer zurück, somit greift dann das caching nicht
	# if ( ( is_array($ResultArray) ) && ( $ResultArray != -1 ) ){ 
	
	if ( is_array($ResultArray) ){ 
		return $ResultArray;
	} else {
		$ResultArray = array();
	};

	####################
	###### Read Cache Ende
	####################

	$MySqlArray = doSQLQueryZoozle( $SqlQuery );

	if ( $MySqlArray ) {

		while( $sql_results = mysql_fetch_array($MySqlArray)) {

			$LINK = $sql_results["LINK"];
			$DATE = $sql_results["DATE"];
			$CATG = $sql_results["CATG"];
			#$RANK = $sql_results["RANG"];
			#$RANK = substr($RANK, 0, 5);
			$DESC = iconv("UTF-8", "ISO-8859-1", $sql_results["DESC"] );

			if ( strlen($sql_results["DESC"]) > ( strlen($DESC) + 3) ){
				$DESC = $sql_results["DESC"];
			};

			array_push($ResultArray, "$LINK#!?#-.>#$DESC#!?#-.>#$DATE#!?#-.>#$CATG\n");

		}; # while( $sql_results = mysql_fetch_array($results)) { }

    } else {
		
		echo "Konnte die MySQL-Abfrage nicht verarbeiten / Could execute mysql query <br />\n";
		echo "MySQL-Antwort: " . mysql_error();
	#	die();

	};  # if ( $MySqlArray ) {

	return $ResultArray;

}; # function _TorrentResults( $SearchQuery ){




function _SongtextResults( $SearchQuery ){

	$maxresults		= MAXRESULTS;
	$relevance		= RELEVANCE;
	$tbl			= SONGTEXT_TABLE;

	$language		= $_SESSION['LANG'];
	$page			= $_SESSION['PAGE'];
	
	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();

/*
	# SQL Querys Predefined
	define('SongtextResultsNotNull', "SELECT DISTINCT `DESC`, `LINK`, `DATE` , `CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE  MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ORDER BY RANG DESC, DATE DESC LIMIT $from, $maxresults");

	define('SongtextResultsIsNull',"SELECT DISTINCT `DESC`, `LINK`, `DATE` ,`CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ORDER BY RANG DESC, DATE DESC LIMIT $maxresults" );
*/


	# SQL Querys Predefined
	define('SongtextResultsNotNull', "SELECT * FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") LIMIT $from, $maxresults");
	define('SongtextResultsIsNull',"SELECT * FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") LIMIT $maxresults" );



	if ( is_numeric( $page ) && ( $page > 0 ) ) {
		$SqlQuery = SongtextResultsNotNull;
	} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
		$SqlQuery = SongtextResultsIsNull;
	};

	####################
	###### Read Cache
	####################

	$ResultArray = ReadCache( WEBCACHESONGTEXT, $SqlQuery );

	# bekomme ich einen integer zurück, somit greift dann das caching nicht
	# if ( ( is_array($ResultArray) ) && ( $ResultArray != -1 ) ){ 
	
	if ( is_array($ResultArray) ){ 
		return $ResultArray;
	} else {
		$ResultArray = array();
	};

	####################
	###### Read Cache Ende
	####################
	

	$MySqlArray = doSQLQueryZoozle( $SqlQuery );

	if ( $MySqlArray ) {

		while( $sql_results = mysql_fetch_array($MySqlArray)) {

			$LINK = $sql_results["LINK"];
			$DATE = $sql_results["DATE"];
			$CATG = $sql_results["CATG"];
			#$RANK = $sql_results["RANG"];
			#$RANK = substr($RANK, 0, 5);
			$DESC = iconv("UTF-8", "ISO-8859-1", $sql_results["DESC"] );

			if ( strlen($sql_results["DESC"]) > ( strlen($DESC) + 3) ){
				$DESC = $sql_results["DESC"];
			};

			array_push($ResultArray, "$LINK#!?#-.>#$DESC#!?#-.>#$DATE#!?#-.>#$CATG\n");

		}; # while( $sql_results = mysql_fetch_array($results)) { }

    } else {
		
		echo "Konnte die MySQL-Abfrage nicht verarbeiten / Could execute mysql query <br />\n";
		echo "MySQL-Antwort: " . mysql_error();
	#	die();

	};  # if ( $MySqlArray ) {

	return $ResultArray;

}; # function _SongtextResults( $SearchQuery ){




function _SerialResults( $SearchQuery ){

	$maxresults		= MAXRESULTS;
	$relevance		= RELEVANCE;
	$tbl			= SERIALS_TABLE;

	$language		= $_SESSION['LANG'];
	$page			= $_SESSION['PAGE'];
	
	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();

/*
	# SQL Querys Predefined
	define('SerialResultsNotNull', "SELECT DISTINCT `DESC`, `LINK`, `DATE` , `CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE  MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ORDER BY RANG DESC, DATE DESC LIMIT $from, $maxresults");

	define('SerialResultsIsNull',"SELECT DISTINCT `DESC`, `LINK`, `DATE` ,`CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ORDER BY RANG DESC, DATE DESC LIMIT $maxresults" );
*/

	# SQL Querys Predefined
	define('SerialResultsNotNull', "SELECT * FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") LIMIT $from, $maxresults");
	define('SerialResultsIsNull',"SELECT * FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") LIMIT $maxresults" );


	if ( is_numeric( $page ) && ( $page > 0 ) ) {
		$SqlQuery = SerialResultsNotNull;
	} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
		$SqlQuery = SerialResultsIsNull;
	};

	####################
	###### Read Cache
	####################

	$ResultArray = ReadCache( WEBCACHESERIALS, $SqlQuery );

	# bekomme ich einen integer zurück, somit greift dann das caching nicht
	# if ( ( is_array($ResultArray) ) && ( $ResultArray != -1 ) ){ 
	
	if ( is_array($ResultArray) ){ 
		return $ResultArray;
	} else {
		$ResultArray = array();
	};

	####################
	###### Read Cache Ende
	####################
	

	$MySqlArray = doSQLQueryZoozle( $SqlQuery );

	if ( $MySqlArray ) {

		while( $sql_results = mysql_fetch_array($MySqlArray)) {

			$LINK = $sql_results["LINK"];
			$DATE = $sql_results["DATE"];
			$CATG = $sql_results["CATG"];
			#$RANK = $sql_results["RANG"];
			#$RANK = substr($RANK, 0, 5);
			$DESC = iconv("UTF-8", "ISO-8859-1", $sql_results["DESC"] );

			if ( strlen($sql_results["DESC"]) > ( strlen($DESC) + 3) ){
				$DESC = $sql_results["DESC"];
			};

			array_push($ResultArray, "$LINK#!?#-.>#$DESC#!?#-.>#$DATE#!?#-.>#$CATG\n");

		}; # while( $sql_results = mysql_fetch_array($results)) { }

    } else {
		
		echo "Konnte die MySQL-Abfrage nicht verarbeiten / Could execute mysql query <br />\n";
		echo "MySQL-Antwort: " . mysql_error();
	#	die();

	};  # if ( $MySqlArray ) {


	return $ResultArray;

}; # function _SerialResults( $SearchQuery ){




function _CrackResults( $SearchQuery ){

	$CrackGoto = CRACKSEARCH;
	$CrackGoto .= "=" . $SearchQuery;

	if ( strcasecmp( $_SESSION['LANG'] , "de") == 0 ) {
		$HintText = "Für $SearchQuery - Crack Downloads klicke bitte den Link -->> ";
	} elseif ( strcasecmp( $_SESSION['LANG'] , "en") == 0 ) {
		$HintText = "Please click the link for $SearchQuery - Crack Downloads -->> ";
	} elseif ( strcasecmp( $_SESSION['LANG'] , "") == 0 ) {
		$HintText = "Please click the link for $SearchQuery - Crack Downloads / Für $SearchQuery - Crack Downloads klicke bitte den Link -->> ";
	} else {
		$HintText = "Please click the link for $SearchQuery - Crack Downloads -->> ";
	};

	
	echo <<<END
		<script language="JavaScript">
			window.location="$CrackGoto";
		</script>
		<noscript>
			<br><b><center>$HintText <a href="$CrackGoto" rel="nofollow" target="_blank">$SearchQuery - Crack Downloads</a></center></b>
		</noscript>
END;
	

}; # function _CrackResults(){




function _UsenextResults( $SearchQuery ){
	
	# todo: zu alte caches automatisch löschen -> siehe den normalen news
	# mit limit from page=0 ergebnis 0 bis 30, und bei page 1 dann von 31 bis 62 usw

	$UsenextMaxAdLinkCount	= USENEXTMAXADLINKCOUNT;
	$UsenextMaxAdWordLength	= USENEXTADWORDSLENGTH;
	$UsenextRefererLink		= USENEXTADLINK;

	$maxresults				= MAXRESULTS;
	
	$SearchQueryOrg			= trim(strtolower($SearchQuery));	# suchwort in kleinbuchstaben und ohne leerzeichen am anfang
	$ResultArray			= array();
	
	if ( strcasecmp( $_SESSION['LANG'] , "de") == 0 ) {
		$lang = "de";
		$DATE = GetCurrentNumberDate();
	} elseif ( strcasecmp( $_SESSION['LANG'] , "en") == 0 ) {
		$lang = "en";
		$DATE = GetSQlDateEn();
	} elseif ( strcasecmp( $_SESSION['LANG'] , "") == 0 ) {
		$lang = "";
		$DATE = GetSQlDateEn();
	} else {
		$lang = "fr";
		#$DATE = GetSQlDateEn();
		$DATE = GetCurrentNumberDate();
	};

	####################
	###### Read Cache
	####################

	$ResultArray = ReadCache( WEBCACHEUSENEXT, $SearchQueryOrg );

	if ( is_array($ResultArray) ){ 
		return $ResultArray;
	} else {
		$ResultArray = array();
	};
	
	####################
	###### Read Cache Ende
	####################

	# DEBUG: 
	# echo "Cache Miss because <br>";

	$results		= queryUsenetServer( $SearchQueryOrg );

/*
	$ArrayFileType	= array(	"0"	=>	"iso",
								"1"	=>	"rar",
								"2"	=>	"zip",
								"3"	=>	"ace",
								"4"	=>	"bin" );

	$RandFileType		= rand(0, 4);
	$Query				= str_replace("%20", " ", $SearchQueryOrg );
	$RandFileLenght		= rand(470540046, 2870540046);					# zwischen 470 - 2,8 GB
	$RandFileLenght		= str_replace("-", "", $RandFileLenght );
*/
	
	$SearchQuery		= ucfirst($SearchQueryOrg);
	$fnt				= $SearchQuery;

	array_push($ResultArray, "$fnt#!?#-.>#$fnt#!?#-.>#$DATE#!?#-.>#$lang\n");
	$count = 0;

	foreach ( preg_split("/usenext:\?t=+[\w]+[\.]/", $results ) as $string) {
		list( $lenght, $name, $type ) = explode(',', $string);

		if ( preg_match("/[\w]/", $name)){
			# echo "$lenght,$name,$type;";
			# $nt = "$name.$type";
			$nt = "$name";
			array_push($ResultArray, "$nt#!?#-.>#$nt#!?#-.>#$DATE#!?#-.>#$lang\n");
		}; # if ( preg_match("/[\w]/", $name)){
		
	}; # foreach 

	return $ResultArray;

}; # function _UsenextResults( $SearchQuery){



function _SoftwareResults( $SearchQuery ){
	
	# suchwort in kleinbuchstaben und ohne leerzeichen am anfang
	$SearchQueryOrg	= urlencode(trim(strtolower($SearchQuery)));	
	
	####################
	###### Read Cache
	####################

	$ResultArray	= ReadCache( WEBCACHESOFTWARE, $SearchQueryOrg );	# later: look at subtitle search

	if ( is_array($ResultArray) ){ 
		return $ResultArray;
	} else {
		$ResultArray = array();
	};
	
	####################
	###### Read Cache Ende
	####################
	
	require_once("/srv/server/wwwbiz/lib/http.inc.php");

#	$url			= 'http://85.17.52.96/zoozleX200.php?s=' . $SearchQuery;
#	$obj			= new HTTPRequest($url);
#	$ResultString	= $obj->DownloadToString();


	$timeout	= 3;
	$old		= ini_set('default_socket_timeout', $timeout);
	$file		= fopen("http://85.17.52.96/zoozleX200.php?s=$SearchQuery", 'r');
	ini_set('default_socket_timeout', $old);
	stream_set_timeout($file, $timeout);
	stream_set_blocking($file, 0);

	while (!feof($file)) {
		$ResultString .= fread($file, 2048);
	}; # while (!feof($fh)) {

	fclose($file);

	$raw_content	= explode(';', $ResultString);
	$count			= 0;

	foreach ( $raw_content as $raw) {

		$list	= explode(',', $raw);
		$desc	= $list[1];
		$id		= $list[0];

		array_push($ResultArray, "http://softwarebackups.org/index.php?target=desc&progid=$id#!?#-.>#$desc#!?#-.>#today#!?#-.>#\n");
		
	}; # foreach ( $raw_content as $raw) {

	

/*
	$timeout	= 3;
	$old		= ini_set('default_socket_timeout', $timeout);
	$file		= fopen("http://85.17.52.96/zoozle200.php?s=$SearchQuery", 'r');
	ini_set('default_socket_timeout', $old);
	stream_set_timeout($file, $timeout);
	stream_set_blocking($file, 0);

	while (!feof($file)) {
		$ResultString .= fread($file, 2048);
	}; # while (!feof($fh)) {

	fclose($file);
*/

/*
	#	$url			= 'http://85.17.52.96/zoozle200.php?s=' . $SearchQuery;	

	$raw_content	= explode('"', $ResultString);
	$count			= 0;

	foreach ( $raw_content as $raw) {

		if ( $count < 210 ){

			if ( eregi("(http)", $raw) ){
				$url = $raw;
			};

			if ( eregi("(</a>)", $raw) ){
				$desc = str_ireplace("</a>","", $raw);
				$desc = str_ireplace("<br>","", $raw);
				$desc = str_ireplace(">","", $raw);
				# echo "DEBUG: URL=$url ------> DESC=$desc <br> ";
				array_push($ResultArray, "$url#!?#-.>#$desc#!?#-.>#today#!?#-.>#\n");
			};

		}; # if ( $count < 110 ){

	}; # foreach ( $raw_content as $raw) {

*/
	return $ResultArray;

}; # function _SoftwareResults(){




function _NewsResults( $SearchQuery ){

	# news werden erstmal nicht cachen

	$maxresults		= MAXRESULTS;
	$maxresults		= round($maxresults	/ 2);
	$relevance		= RELEVANCE;
	$tbl			= EMULE_TABLE;
	
	$language		= $_SESSION['LANG'];
	$page			= $_SESSION['PAGE'];
	

	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);

	# SQL Querys Predefined

	define('EmuleResultsNotNull', "SELECT DISTINCT `DESC`, `LINK`, `DATE` , `CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ORDER BY RANG DESC, DATE DESC LIMIT $from, $maxresults");

	define('EmuleResultsIsNull',"SELECT DISTINCT `DESC`, `LINK`, `DATE` ,`CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ORDER BY RANG DESC, DATE DESC LIMIT $maxresults" );


	define('EmuleResultsNotNullLang', "SELECT DISTINCT `DESC`, `LINK`, `DATE` , `CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' AND (`CATG`) LIKE ('$language') ORDER BY RANG DESC, DATE DESC LIMIT $from, $maxresults");

	define('EmuleResultsIsNullLang', "SELECT DISTINCT `DESC`, `LINK`, `DATE` ,`CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' AND (`CATG`) LIKE ('$language') ORDER BY RANG DESC, DATE DESC LIMIT $maxresults");


	if ( !strcasecmp($language, "") == 0 ) {
		
		if ( is_numeric( $page ) && ( $page > 0 ) ) {
			$SqlQuery = EmuleResultsNotNullLang;
		} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
			$SqlQuery = EmuleResultsIsNullLang;
		};
	
	} else { 

		if ( is_numeric( $page ) && ( $page > 0 ) ) {
			$SqlQuery = EmuleResultsNotNull;
		} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
			$SqlQuery = EmuleResultsIsNull;
		};

	}; # if ( !strcasecmp($language, "") == 0 ) {


	# echo "SQL=$SqlQuery<br>";

	$MySqlArray = doSQLQueryZoozle( $SqlQuery );

	if ( $MySqlArray ) {

		$ResultArray	= array();
		while( $sql_results = mysql_fetch_array($MySqlArray)) {

			$LINK = $sql_results["LINK"];
			$DATE = $sql_results["DATE"];
			$CATG = $sql_results["CATG"];
			#$RANK = $sql_results["RANG"];
			#$RANK = substr($RANK, 0, 5);

			$DESC = iconv("UTF-8", "ISO-8859-1", $sql_results["DESC"] );

			if ( strlen($sql_results["DESC"]) > ( strlen($DESC) + 3) ){
				$DESC = $sql_results["DESC"];
			};

			array_push($ResultArray, "$LINK#!?#-.>#eMule - $DESC#!?#-.>#$DATE#!?#-.>#$CATG\n");

		}; # while( $sql_results = mysql_fetch_array($results)) { }

    } else {
		
		echo "Konnte die MySQL-Abfrage nicht verarbeiten / Could execute mysql query <br />\n";
		echo "MySQL-Antwort: " . mysql_error();
	#	die();

	};  # if ( $MySqlArray ) {


	$tbl			= TORRENT_TABLE;
	$torrent_life	= TORRENT_LIFETIME_NORMAL;


	# SQL Querys Predefined

	define('TorrentResultsNotNull', "SELECT DISTINCT `DESC`, `LINK`, `DATE` , `CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE DATE_SUB(CURDATE(),INTERVAL $torrent_life DAY) <= `DATE` AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ORDER BY RANG DESC, DATE DESC LIMIT $from, $maxresults");

	define('TorrentResultsIsNull',"SELECT DISTINCT `DESC`, `LINK`, `DATE` ,`CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE DATE_SUB(CURDATE(),INTERVAL $torrent_life DAY) <= `DATE` AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' ORDER BY RANG DESC, DATE DESC LIMIT $maxresults" );


	define('TorrentResultsNotNullLang', "SELECT DISTINCT `DESC`, `LINK`, `DATE` , `CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE DATE_SUB(CURDATE(),INTERVAL $torrent_life DAY) <= `DATE` AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' AND (`CATG`) LIKE ('$language') ORDER BY RANG DESC, DATE DESC LIMIT $from, $maxresults");

	define('TorrentResultsIsNullLang', "SELECT DISTINCT `DESC`, `LINK`, `DATE` ,`CATG` , MATCH ( `DESC` ) AGAINST(\"$SearchQuery\") AS RANG FROM $tbl WHERE DATE_SUB(CURDATE(),INTERVAL $torrent_life DAY) <= `DATE` AND  MATCH(`DESC`) AGAINST(\"$SearchQuery\") AND MATCH(`DESC`) AGAINST(\"$SearchQuery\") >= '$relevance' AND (`CATG`) LIKE ('$language') ORDER BY RANG DESC, DATE DESC LIMIT $maxresults");


	if ( !strcasecmp($language, "") == 0 ) {
		
		if ( is_numeric( $page ) && ( $page > 0 ) ) {
			$SqlQuery = TorrentResultsNotNullLang;
		} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
			$SqlQuery = TorrentResultsIsNullLang;
		};
	
	} else { 

		if ( is_numeric( $page ) && ( $page > 0 ) ) {
			$SqlQuery = TorrentResultsNotNull;
		} elseif ( !is_numeric( $page ) || ( $page <= 0 ) || strlen($page) == 0 ) {
			$SqlQuery = TorrentResultsIsNull;
		};

	}; # if ( !strcasecmp($language, "") == 0 ) {


	$MySqlArray = doSQLQueryZoozle( $SqlQuery );

	if ( $MySqlArray ) {

		while( $sql_results = mysql_fetch_array($MySqlArray)) {

			$LINK = $sql_results["LINK"];
			$DATE = $sql_results["DATE"];
			$CATG = $sql_results["CATG"];
			#$RANK = $sql_results["RANG"];
			#$RANK = substr($RANK, 0, 5);
			$DESC = iconv("UTF-8", "ISO-8859-1", $sql_results["DESC"] );

			if ( strlen($sql_results["DESC"]) > ( strlen($DESC) + 3) ){
				$DESC = $sql_results["DESC"];
			};

			array_push($ResultArray, "$LINK#!?#-.>#Torrent - $DESC#!?#-.>#$DATE#!?#-.>#$CATG\n");

		}; # while( $sql_results = mysql_fetch_array($results)) { }

    } else {
		
		echo "Konnte die MySQL-Abfrage nicht verarbeiten / Could execute mysql query <br />\n";
		echo "MySQL-Antwort: " . mysql_error();
		die();

	};  # if ( $MySqlArray ) {

	return $ResultArray;

}; # function _NewsResults( $SearchQuery ){



function GenerateResults( $SearchQuery ){

	$Results = array();
	
	if ( strcasecmp($_SESSION['MAINCAT'], "emule") == 0 ) {
		$Results = _EmuleResults( $SearchQuery );

	} elseif ( strcasecmp($_SESSION['MAINCAT'], "torrent") == 0 || strcasecmp($_SESSION['MAINCAT'], "bittorrent") == 0 ) {	
		$Results = _TorrentResults( $SearchQuery );

	} elseif ( strcasecmp($_SESSION['MAINCAT'], "serial") == 0 || strcasecmp($_SESSION['MAINCAT'], "serials") == 0) { 
		$Results = _SerialResults( $SearchQuery );

	} elseif ( strcasecmp($_SESSION['MAINCAT'], "subtitle") == 0 || strcasecmp($_SESSION['MAINCAT'], "subtitles") == 0 || strcasecmp($_SESSION['MAINCAT'], "subtitel") == 0 || strcasecmp($_SESSION['MAINCAT'], "subtitels") == 0) { 
		$Results = _SubtitleResults( $SearchQuery );

	} elseif ( strcasecmp($_SESSION['MAINCAT'], "software") == 0 ) { 
		$Results = _SoftwareResults( $SearchQuery);
	
	} elseif ( strcasecmp($_SESSION['MAINCAT'], "cracks") == 0 || strcasecmp($_SESSION['MAINCAT'], "crack") == 0) { 
		$Results = _CrackResults( $SearchQuery );

	} elseif ( strcasecmp($_SESSION['MAINCAT'], "songtext") == 0 || strcasecmp($_SESSION['MAINCAT'], "songtexte") == 0) { 
		$Results = _SongtextResults( $SearchQuery );

	} elseif ( strcasecmp($_SESSION['MAINCAT'], "usenet") == 0 || strcasecmp($_SESSION['MAINCAT'], "usenext") == 0 ) {	
		$Results = _UsenextResults( $SearchQuery );	
	
	} elseif ( strcasecmp($_SESSION['MAINCAT'], "news") == 0 ) {		
		$Results = _NewsResults( $SearchQuery );

	} else {											
		$Results = _TorrentResults( $SearchQuery );

	};

	return $Results;
	
}; # function GenerateResults( $MainType ){


/*
function queryUsenetServer( $query ){
	
	# wandle " " in "+" um - ohne dem funzt usenext suche nicht !
	$query	= str_replace(" ", "+", $query);

	$url	= USENEXT . $query;	
	$obj	= new HTTPRequest($url);
	return $obj->DownloadToString();
	
}; # function QueryUsenetServer( $query ){}
*/


/*
		old: 
		$to				= ( $page * $maxresults ) - 1;
		$from			= (( $page * $maxresults ) - $maxresults ); 

	if ( $page == 0 ) {					# limit 0, 30;
		$from = 0;						
	} elseif ( $page == 1 ){			# limit 31, 30
		$from = $maxresults + 1;		
	} elseif ( $page >= 2 ) {			# limit 62|93|122||,30
		$from = ( ( $page * $maxresults ) + $page ); 
	} else {
	};

	
	*/




?>