<?php

require_once "/server/wwwroot/www.torrentrage.com/lib/config.inc.php";

### datenbank spezifische sachen
define('TORRENT_EN_TABLE', 'torrentrage');
define('TORRENT_TORRENTRAGE_TABLE', 'torrentrage');


# für den PR server
define('MYSQL_PR_HOST', 'localhost'); 
define('MYSQL_PR_USER', 'root'); 
define('MYSQL_PR_PASS', ''); 
define('MYSQL_PR_DATABASE', 'torrentrage'); 
define('MYSQL_TORRENTRAGE_DATABASE', 'torrentrage'); 


function SqlQuerySearchSphinx($ids){
		// SELECT * FROM torrentrage WHERE `ID` IN ("5550005","9851125","271018")
		$tbl 		= TORRENT_TORRENTRAGE_TABLE;
		
		if (count($ids) <= 0 ){
			$maxresults = MAXRESULTS;
			return "SELECT * FROM $tbl LIMIT $maxresults;";
		};		
		
		$string		= "SELECT * FROM $tbl WHERE";
		for ($i=0;$i<=count($ids) - 1;$i++){
			if ($i>0){
				$string .= "\"$ids[$i]\",";
			} elseif($i<=0){
				$string .= " `ID` IN (\"$ids[$i]\",";
			};
		};
		$string = substr($string,0,(strlen($string)-1));
		$string .=");";
		
		return $string;
		
}; # function SqlQuerySearchSphinx($ids){


# build the sql query for getting all the restlichen new directory entries per category
function doQueryForAllResultCountNewDirectory($date){
		
		# $NewsLimitResults	= "SELECT DISTINCT TRIM(`categorys`) FROM pornragestreams;";
		$tbl 	= TORRENT_EN_TABLE;
		return "SELECT count(*) AS COUNT FROM $tbl WHERE `date` = \"$date\" LIMIT 1;";
		
}; # function doQueryForAllResultCountNewDirectory($date){


# build the sql query for getting all the restlichen directory entries per category
function doQueryForAllResultCountDirectory($SearchQuery){
		
		# $NewsLimitResults	= "SELECT DISTINCT TRIM(`categorys`) FROM pornragestreams;";
		$tbl 	= TORRENT_EN_TABLE;
		return "SELECT count(*) AS COUNT FROM $tbl WHERE `DESC` LIKE(\"$SearchQuery%\") LIMIT 1;";
		
}; # function doQueryForAllResultCountDirectory($SearchQuery){

function _buildQueryTop1000(){

	$today 	= date("Y-m-d");
	$tbl 	= TORRENT_EN_TABLE;
	$count	= TOP1000NEWS;
	return "SELECT `DESC`,`ID` FROM $tbl WHERE `DATE` = \"$today\" AND CHAR_LENGTH(`DESC`) >= 3 ORDER BY RAND() LIMIT $count;";
	
}; // function _buildQueryStartpageNews(){


# build the sql query for getting all the restlichen directory entries per category
function doQueryForAllResultCount($SearchQuery){
		
		$tbl 		= TORRENT_TORRENTRAGE_TABLE;
		return "SELECT count(*) AS COUNT FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$SearchQuery\") LIMIT 1;";
		
}; # function doQueryForAllResultCount($SearchQuery){


function _buildQueryGetDonwloadRelatedTorrents($Filename){

	$tbl 		= TORRENT_EN_TABLE;
	$maxresults = RELATEDTORRENTSONDETAILPAGE;
	return "SELECT *,MATCH(`DESC`) AGAINST(\"$Filename\") AS relevance FROM $tbl WHERE MATCH(`DESC`) AGAINST(\"$Filename\") ORDER BY RAND() DESC LIMIT $maxresults;";
	
}; // function _buildQueryGetDonwloadRelatedTorrents($Filename){


function _buildQueryGetDonwloadLink($ID){

	$tbl 	= TORRENT_TORRENTRAGE_TABLE;
	return "SELECT `LINK`,`TORRENT`,`CATG`,`INFRIGMENT` FROM $tbl WHERE `ID` = \"$ID\" LIMIT 1;";
	
}; // function _buildQueryGetDonwloadLink($ID){


function _buildQueryLatestNews($today){

	$tbl 	= TORRENT_TORRENTRAGE_TABLE;
	$count	= LATESTPAGENEWS;
	return "SELECT `DESC`,`ID` FROM $tbl WHERE `DATE` = \"$today\" AND CHAR_LENGTH(`DESC`) >= 3 ORDER BY `DESC` ASC LIMIT $count;";
	
}; // function _buildQueryLatestNews(){


function _buildQueryStartpageNews(){

	$today 	= date("Y-m-d");
	$tbl 	= TORRENT_TORRENTRAGE_TABLE;
	$count	= STARTPAGENEWS;
	return "SELECT `DESC`,`ID` FROM $tbl WHERE `DATE` = \"$today\" AND CHAR_LENGTH(`DESC`) >= 3 ORDER BY RAND() LIMIT $count;";
	
}; // function _buildQueryStartpageNews(){


function doSQLQuery( $sql_query ){ 

	//echo $sql_query;
	
	$db_handle	= connectToServer();
	$results	= mysql_query($sql_query , $db_handle );
	mysql_close($db_handle);
	return $results;

}; # function doSQLQuery( $sql_query ){ 


function connectToServer(){

	$DBH = mysql_connect(MYSQL_PR_HOST, MYSQL_PR_USER, MYSQL_PR_PASS);
	mysql_select_db(MYSQL_PR_DATABASE, $DBH) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error());
	return $DBH;

}; # function connectToServer(){


function doSQLQueryTR( $sql_query ){ 

	//echo $sql_query;
	
	$db_handle	= connectToTorrentrageServer();
	$results	= mysql_query($sql_query , $db_handle );
	mysql_close($db_handle);
	return $results;

}; # function doSQLQueryTR( $sql_query ){


function connectToTorrentrageServer(){

	$DBH = mysql_connect(MYSQL_PR_HOST, MYSQL_PR_USER, MYSQL_PR_PASS);
	mysql_select_db(MYSQL_TORRENTRAGE_DATABASE, $DBH) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error());
	return $DBH;

}; # function connectToServer(){


?>