<?php


#####################################################################


# 5 keywords für die startseiten DE
define('IndexDeTenBittorrentKeywords', "SELECT DISTINCT `DESC` FROM `torrent7` WHERE `DATE` = CURDATE() AND `CATG` = 'fr' AND CHAR_LENGTH(`DESC`) > 1 LIMIT 50");
define('IndexDeTenEmuleKeywords', "SELECT DISTINCT `DESC` FROM `emule7` WHERE `DATE` = CURDATE() AND `CATG` = 'fr' AND CHAR_LENGTH(`DESC`) > 1 LIMIT 50");


# 5 keywords für die startseiten EN
define('IndexEnTenBittorrentKeywords', "SELECT DISTINCT `DESC` FROM `torrent7` WHERE `DATE` = CURDATE() AND `CATG` = 'fr' AND CHAR_LENGTH(`DESC`) > 1 LIMIT 50");
define('IndexEnTenEmuleKeywords', "SELECT DISTINCT `DESC` FROM `emule7` WHERE `DATE` = CURDATE() AND `CATG` = 'fr' AND CHAR_LENGTH(`DESC`) > 1 LIMIT 50");


#####################################################################


# SELECT DISTINCT `KEYW`,`HITS`,`DATE` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 10

	# SELECT DISTINCT * FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 30
	# 1 SELECT DISTINCT `KEYW` FROM `keywords_de` WHERE DATE_SUB(CURDATE(),INTERVAL 10 DAY) <= `DATE` ORDER BY HITS DESC LIMIT 10
    # SELECT * FROM `keywords_de` WHERE `KEYW` LIKE('%gary D Trance 7%') ORDER BY HITS DESC


# 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` = 'fr' AND CHAR_LENGTH(`DESC`) > 1 ORDER BY `DESC` DESC LIMIT 30");
define('IndexEnH1Keywords',"SELECT DISTINCT `DESC` FROM `torrent7` WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= `DATE` AND `CATG` = 'fr' AND CHAR_LENGTH(`DESC`) > 1 ORDER BY `DESC` DESC LIMIT 30");

define('IndexDeH1KeywordsBoth',"SELECT DISTINCT `DESC` FROM `torrent7` WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= `DATE` AND `CATG` = 'fr' AND CHAR_LENGTH(`DESC`) > 1 ORDER BY `DESC` DESC LIMIT 35");
define('IndexEnH1KeywordsBoth',"SELECT DISTINCT `DESC` FROM `torrent7` WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= `DATE` AND `CATG` = 'fr' AND CHAR_LENGTH(`DESC`) > 1 ORDER BY `DESC` DESC LIMIT 35");

# CHAR_LENGTH()
#####################################################################

# 10 keywords für H1 für de newsarchive eines monats




# 10 keywords für H1 für de news eines tages



###################
#### SQL SERVER
###################

### datenbank spezifische sachen
define('EMULE_TABLE', 'emule7');
define('SONGTEXT_TABLE', 'songtext7');
define('SERIALS_TABLE', 'serials7');
define('TORRENT_TABLE', 'torrent7');
define('EMULE_NEWS', 'emule7');
define('TORRENT_NEWS', 'torrent7');


/*
# für den zoozle server
define('MYSQL_ZOOZLE_HOST', 'localhost'); 
define('MYSQL_ZOOZLE_USER', 'zoozle'); 

define('MYSQL_ZOOZLE_DATABASE', 'zoozle'); 
*/


# zoozle sql server
define('MYSQL_ZOOZLE_REMOTEHOST', '77.247.178.21'); 
define('MYSQL_ZOOZLE_REMOTEUSER', 'zoozlebiz'); 

define('MYSQL_ZOOZLE_REMOTEDATABASE', 'zoozle'); 



# verbinde dich zum zoozle mysql server 
function connectToZoozleServer(){

	##lokal# $DBH = mysql_pconnect(MYSQL_ZOOZLE_HOST, MYSQL_ZOOZLE_USER, MYSQL_ZOOZLE_PASS) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error());
	
	$DBH = mysql_connect(MYSQL_ZOOZLE_REMOTEHOST, MYSQL_ZOOZLE_REMOTEUSER,MYSQL_ZOOZLE_REMOTEPASS ) or die;
	mysql_select_db(MYSQL_ZOOZLE_REMOTEDATABASE, $DBH) OR die ("Konnte Datenbank nicht benutzen, Fehlermeldung: ".mysql_error());

	return $DBH;

}; # function connectToZoozleServer(){



# verbinde dich zum zoozle keywords mysql server 
function connectToZoozleKeywordsServer(){

	$DBH = mysql_connect(MYSQL_ZOOZLE_REMOTEHOST, MYSQL_ZOOZLE_REMOTEUSER,MYSQL_ZOOZLE_REMOTEPASS ) or die;
	mysql_select_db(MYSQL_ZOOZLE_REMOTEDATABASE, $DBH) OR die ("Konnte Datenbank nicht benutzen, Fehlermeldung: ".mysql_error());

	# $DBH = mysql_pconnect(MYSQL_ZOOZLEKEYWORDS_HOST, MYSQL_ZOOZLEKEYWORDS_USER, MYSQL_ZOOZLEKEYWORDS_PASS) OR die ("Keine Verbindung zur Datenbank. Fehlermeldung: ".mysql_error());
	#$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_ZOOZLEKEYWORDS_DATABASE, $DBH) OR die ("Konnte Datenbank nicht benutzen, Fehlermeldung: ".mysql_error());

	return $DBH;

}; # function connectToZoozleKeywordsServer(){



function doSQLQueryZoozle( $sql_query ) { 

	$db_handle	= connectToZoozleServer();
	$results	= mysql_query($sql_query , $db_handle );
	mysql_close($db_handle);
	return $results;

}; # function doSQLQueryZoozle( $sql_query ) { 



function doSQLQueryKeywords( $sql_query ) { 

	$db_handle	= connectToZoozleKeywordsServer();
	$results	= mysql_query($sql_query , $db_handle );
	mysql_close($db_handle);
	return $results;

}; # function doSQLQueryZoozle( $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');
*/


?>