<?php
# 5 keywords f�r die startseiten DE
define('IndexDeTenBittorrentKeywords', "SELECT DISTINCT `DESC` FROM `torrentEN` WHERE `DATE` = DATE_SUB(CURDATE(),INTERVAL 1 DAY ) AND `CATG` = 'de' AND CHAR_LENGTH(`DESC`) > 1 LIMIT 30");
define('IndexDeTenEmuleKeywords', "SELECT DISTINCT `DESC` FROM `emule7` WHERE `DATE` = DATE_SUB(CURDATE(),INTERVAL 1 DAY ) 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` = DATE_SUB(CURDATE(),INTERVAL 0 DAY ) AND `CATG` = 'en' AND CHAR_LENGTH(`DESC`) > 1 LIMIT 10");
define('IndexEnTenEmuleKeywords', "SELECT DISTINCT `DESC` FROM `emule7` WHERE `DATE` = DATE_SUB(CURDATE(),INTERVAL 0 DAY ) 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 `torrentEN` 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 `torrentEN` 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 `torrentEN` 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 `torrentEN` 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(){
*/
?>