<?php

# 5 keywords für die startseiten DE
define('IndexDeTenBittorrentKeywords', "SELECT DISTINCT `DESC` FROM `torrentEN` WHERE `DATE` = CURDATE() AND `CATG` = 'de' AND CHAR_LENGTH(`DESC`) > 1 LIMIT 30");
define('IndexDeTenEmuleKeywords', "SELECT DISTINCT `DESC` FROM `emule7` WHERE `DATE` = CURDATE() AND `CATG` = 'de' AND CHAR_LENGTH(`DESC`) > 1 LIMIT 30");


# 5 keywords für die startseiten EN
define('IndexEnTenBittorrentKeywords', "SELECT DISTINCT `DESC` FROM `torrentEN` WHERE `DATE` = CURDATE() AND `CATG` = 'en' AND CHAR_LENGTH(`DESC`) > 1 LIMIT 10");
define('IndexEnTenEmuleKeywords', "SELECT DISTINCT `DESC` FROM `emule7` WHERE `DATE` = CURDATE() AND `CATG` = 'en' AND CHAR_LENGTH(`DESC`) > 1 LIMIT 30");


#####################################################################

# 10 keywords für H1 für de index
define('IndexDeH1Keywords',"SELECT DISTINCT `DESC` FROM `torrent7` WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= `DATE` AND `CATG` = 'de' AND CHAR_LENGTH(`DESC`) > 1 ORDER BY `DESC` DESC LIMIT 10");
define('IndexEnH1Keywords',"SELECT DISTINCT `DESC` FROM `torrent7` WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= `DATE` AND `CATG` = 'en' AND CHAR_LENGTH(`DESC`) > 1 ORDER BY `DESC` DESC LIMIT 10");

define('IndexDeH1KeywordsBoth',"SELECT DISTINCT `DESC` FROM `torrent7` WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= `DATE` AND `CATG` = 'de' AND CHAR_LENGTH(`DESC`) > 1 ORDER BY `DESC` DESC LIMIT 5");
define('IndexEnH1KeywordsBoth',"SELECT DISTINCT `DESC` FROM `torrent7` WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= `DATE` AND `CATG` = 'en' AND CHAR_LENGTH(`DESC`) > 1 ORDER BY `DESC` DESC LIMIT 5");


###################
#### SQL SERVER
###################

### datenbank spezifische sachen
define('EMULE_TABLE', 'emule7');
define('SONGTEXT_TABLE', 'songtext7');
define('SERIALS_TABLE', 'serials7');
define('TORRENT_TABLE', 'torrentEN');
define('EMULE_NEWS', 'emule7');
define('TORRENT_NEWS', 'torrentEN');
define('RAPIDSHARE_TABLE', 'ENG');


# für den zoozle server
#define('MYSQL_ZOOZLE_HOST', '192.168.39.6'); 
define('MYSQL_ZOOZLE_HOST', 'localhost'); 
define('MYSQL_ZOOZLE_USER', 'root'); 

define('MYSQL_ZOOZLE_DATABASE', 'zoozle'); 


define('MYSQL_ZOOZLE_REMOTEHOST', '192.168.39.1');	
#define('MYSQL_ZOOZLE_REMOTEHOST', '77.247.178.21'); 
define('MYSQL_ZOOZLE_REMOTEUSER', 'zoozleorg'); 

define('MYSQL_ZOOZLE_REMOTEDATABASE', 'zoozle'); 

define('MYSQL_SH_REMOTEHOST', '192.168.39.1');		 
#define('MYSQL_SH_REMOTEHOST', '77.247.178.21'); 
define('MYSQL_SH_REMOTEUSER', 'sharehunt'); 

define('MYSQL_SH_REMOTEDATABASE', 'sharehunt'); 


define('MYSQL_ADS_HOST', 'localhost'); 
define('MYSQL_ADS_USER', 'root'); 

define('MYSQL_ADS_DATABASE', 'softwareads'); 



# verbinde dich zum zoozle mysql server 
function connectToAdsServer(){

	# erst lokalen nehmen
	$DBH = mysql_connect(MYSQL_ADS_HOST, MYSQL_ADS_USER, MYSQL_ADS_PASS);# or die ("".mysql_error);
		
	mysql_select_db(MYSQL_ADS_DATABASE, $DBH) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error());
	return $DBH;

}; # function connectToAdsServer(){



function doSQLQueryAds( $sql_query ) { 

	$db_handle	= connectToAdsServer();
	$results	= mysql_query($sql_query , $db_handle );
	mysql_close($db_handle);
	return $results;

}; # function doSQLQueryAds( $sql_query ) { 


# verbinde dich zum zoozle mysql server 
function connectToZoozleServer(){

	#$DBH = mysql_connect(MYSQL_ZOOZLE_REMOTEHOST, MYSQL_ZOOZLE_REMOTEUSER,MYSQL_ZOOZLE_REMOTEPASS ); # hier auskommentier bedeutet er soll nur den lokalen server benutzen
	$DBH = mysql_connect(MYSQL_ZOOZLE_HOST, MYSQL_ZOOZLE_USER, MYSQL_ZOOZLE_PASS);# or die ("".mysql_error);
	mysql_select_db(MYSQL_ZOOZLE_DATABASE, $DBH) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error());
	return $DBH;

	$load		= sys_getloadavg();
	### $load_sql	= file_get_contents("/home/wwwroot/sql_load.txt");

	if ( $load[0] < 17 ){

		# erst lokalen nehmen
		$DBH = mysql_connect(MYSQL_ZOOZLE_HOST, MYSQL_ZOOZLE_USER, MYSQL_ZOOZLE_PASS);# or die ("".mysql_error);
	#	$pos = strpos($DBH,"Resource");
	#
	#	if ($pos === false) {
	#		echo "lokaler Mysql Server nicht gefunden, connecte zu remote Sql Server\n";
	#		$DBH = mysql_connect(MYSQL_ZOOZLE_REMOTEHOST, MYSQL_ZOOZLE_REMOTEUSER,MYSQL_ZOOZLE_REMOTEPASS ) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error()); # hier auskommentier bedeutet er soll nur den lokalen server benutzen
	#	}

	#} elseif ( $load[0] > 10 && $load_sql <= 25 ) {
	} elseif ( $load[0] > 17 ) {


		# ab load 7 remote nehmen
		$DBH = mysql_connect(MYSQL_ZOOZLE_REMOTEHOST, MYSQL_ZOOZLE_REMOTEUSER,MYSQL_ZOOZLE_REMOTEPASS ); # hier auskommentier bedeutet er soll nur den lokalen server benutzen
	#	$pos = strpos($DBH,"Resource");
	#
	#	if ($pos === false) {
	#		# echo "Remote Mysql Server nicht gefunden, connecte zu lokalem Sql Server\n";
	#		$DBH = mysql_connect(MYSQL_ZOOZLE_HOST, MYSQL_ZOOZLE_USER, MYSQL_ZOOZLE_PASS) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error());
	#	}
	
	} else {

		# erst lokalen nehmen
		$DBH = mysql_connect(MYSQL_ZOOZLE_HOST, MYSQL_ZOOZLE_USER, MYSQL_ZOOZLE_PASS);# or die ("".mysql_error);
	#	$pos = strpos($DBH,"Resource");
	#
	#	if ($pos === false) {
	#		# echo "Remote Mysql Server nicht gefunden, connecte zu lokalem Sql Server\n";
	#		$DBH = mysql_connect(MYSQL_ZOOZLE_REMOTEHOST, MYSQL_ZOOZLE_REMOTEUSER,MYSQL_ZOOZLE_REMOTEPASS ) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error()); # hier auskommentier bedeutet er soll nur den lokalen server benutzen
	#	}

	}

	mysql_select_db(MYSQL_ZOOZLE_DATABASE, $DBH) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error());
	return $DBH;

}; # function connectToZoozleServer(){



function doSQLQueryZoozle( $sql_query ) { 

	$db_handle	= connectToZoozleServer();
	$results	= mysql_query($sql_query , $db_handle );
	mysql_close($db_handle);
	return $results;

}; # function doSQLQueryZoozle( $sql_query ) { 




# verbinde dich zum SH mysql server 
function connectto(){
	

	$DBH = mysql_connect(MYSQL_ZOOZLE_HOST, MYSQL_ZOOZLE_USER, MYSQL_ZOOZLE_PASS);
	mysql_select_db(MYSQL_SH_REMOTEDATABASE, $DBH) OR die ("Konnte Datenbank nicht benutzen, Fehlermeldung: ".mysql_error());
	return $DBH;

	$load		= sys_getloadavg();
	$load_sql	= file_get_contents("/home/wwwroot/sql_load.txt");

	if ( $load[0] < 10 ){

		# erst lokalen nehmen
		$DBH = mysql_connect(MYSQL_ZOOZLE_HOST, MYSQL_ZOOZLE_USER, MYSQL_ZOOZLE_PASS);
	#	$pos = strpos($DBH,"Resource");
	#
	#	if ($pos === false) {
	#		# echo "Remote Mysql Server nicht gefunden, connecte zu lokalem Sql Server\n";
	#		$DBH = mysql_connect(MYSQL_SH_REMOTEHOST, MYSQL_SH_REMOTEUSER, MYSQL_SH_REMOTEPASS ) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error()); # hier auskommentier bedeutet er soll nur den lokalen server benutzen
	#	}

	} elseif ( $load[0] > 10 && $load_sql <= 25 ) {

		# ab load 7 remote nehmen
		$DBH = mysql_connect(MYSQL_SH_REMOTEHOST, MYSQL_SH_REMOTEUSER, MYSQL_SH_REMOTEPASS ); # hier auskommentier bedeutet er soll nur den lokalen server benutzen
	#	$pos = strpos($DBH,"Resource");
	#
	#	if ($pos === false) {
	#		# echo "Remote Mysql Server nicht gefunden, connecte zu lokalem Sql Server\n";
	#		$DBH = mysql_connect(MYSQL_ZOOZLE_HOST, MYSQL_ZOOZLE_USER, MYSQL_ZOOZLE_PASS) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error());
	#	}
	
	} else {

		# erst lokalen nehmen
		$DBH = mysql_connect(MYSQL_ZOOZLE_HOST, MYSQL_ZOOZLE_USER, MYSQL_ZOOZLE_PASS);
	#	$pos = strpos($DBH,"Resource");
	#
	#	if ($pos === false) {
	#		# echo "Remote Mysql Server nicht gefunden, connecte zu lokalem Sql Server\n";
	#		$DBH = mysql_connect(MYSQL_SH_REMOTEHOST, MYSQL_SH_REMOTEUSER, MYSQL_SH_REMOTEPASS ) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error()); # hier auskommentier bedeutet er soll nur den lokalen server benutzen
	#	}

	}

	mysql_select_db(MYSQL_SH_REMOTEDATABASE, $DBH) OR die ("Konnte Datenbank nicht benutzen, Fehlermeldung: ".mysql_error());
	return $DBH;

}; # function connectToSharehuntServer(){




function doSQL( $sql_query ) { 

	$db_handle	= connectto();
	$results	= mysql_query($sql_query , $db_handle );
	mysql_close($db_handle);
	return $results;

}; # function doSQLQuerySH( $sql_query ) { 


#######################################################
#######################################################
#######################################################
#######################################################


/*
buggy
define('IndexDeFirstRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 10,39');		# insgesamt 29 keywords, die ersten 10 sind schon h1
define('IndexDeSecondRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 40,69');
define('IndexDeThirdRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 70,99');
define('IndexDeFourthRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 99,128');
define('IndexDeFifthRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 99,128');
define('IndexDeSixthRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 129,158');
define('IndexDeSeventhRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 159,188');
define('IndexDeEightRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 189,218');
define('IndexDeNinethRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 219,248');
define('IndexDeTenthRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 249,278');
*/



#####################################################################


# die zehn most wanted auf der DE startseite
#  mysql> select * from table LIMIT 5,10;  # Zeilen 6-15 ausgeben
/*
define('IndexDeFirstRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 10,29');		# insgesamt 29 keywords, die ersten 10 sind schon h1
define('IndexDeSecondRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 40,29');
define('IndexDeThirdRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 70,29');
define('IndexDeFourthRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 99,29');
define('IndexDeFifthRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 128,29');
define('IndexDeSixthRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 157,29');
define('IndexDeSeventhRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 186,29');
define('IndexDeEightRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 215,29');
define('IndexDeNinethRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 244,29');
define('IndexDeTenthRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 273,29');

define('IndexEnFirstRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_en` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 10,29');		# insgesamt 29 keywords, die ersten 10 sind schon h1
define('IndexEnSecondRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_en` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 40,29');
define('IndexEnThirdRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_en` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 70,29');
define('IndexEnFourthRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_en` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 99,29');
define('IndexEnFifthRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_en` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 128,29');
define('IndexEnSixthRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_en` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 157,29');
define('IndexEnSeventhRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_en` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 186,29');
define('IndexEnEightRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_en` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 215,29');
define('IndexEnNinethRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_en` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 244,29');
define('IndexEnTenthRowWantedKeywords','SELECT DISTINCT `KEYW` FROM `keywords_en` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 273,29');
*/

/*
# verbinde dich zum zoozle mysql server 
function connectToZoozleServer(){

#	$DBH = mysql_connect(MYSQL_ZOOZLE_REMOTEHOST, MYSQL_ZOOZLE_REMOTEUSER, MYSQL_REMOTEZOOZLE_PASS);
#	mysql_select_db(MYSQL_ZOOZLE_REMOTEDATABASE, $DBH);
#	return $DBH;
	
##lokal# $DBH = mysql_connect(MYSQL_ZOOZLE_HOST, MYSQL_ZOOZLE_USER, MYSQL_ZOOZLE_PASS) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ");
### remote:  $DBH = mysql_connect(MYSQL_ZOOZLE_REMOTEHOST, MYSQL_ZOOZLE_REMOTEUSER,MYSQL_ZOOZLE_REMOTEPASS ) or die ("Keine Verbindung zur Datenbank. Fehlermeldung: ");
	
	$DBH = mysql_connect(MYSQL_ZOOZLE_REMOTEHOST, MYSQL_ZOOZLE_REMOTEUSER,MYSQL_ZOOZLE_REMOTEPASS ) or die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error());
	mysql_select_db(MYSQL_ZOOZLE_DATABASE, $DBH) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error());

	return $DBH;

#	$DBH = mysql_pconnect(MYSQL_ZOOZLE_HOST, MYSQL_ZOOZLE_USER, MYSQL_ZOOZLE_PASS) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error());
#	mysql_select_db(MYSQL_ZOOZLE_DATABASE, $DBH) OR die ("Konnte Datenbank nicht benutzen, Fehlermeldung: ".mysql_error());
#
#	return $DBH;

}; # function connectToZoozleServer(){
*/


?>