youtube-mp3-converter - wwwroot - ajax - SOURCE CODE

<?php

require_once( "../lib/config.inc.php" );
require_once( "../lib/connection.inc.php");
require_once( "../lib/state.inc.php");
require_once( "../lib/functions.inc.php");
// http://www.nookiestar.com/mp3/ajax/state.php?language=DE&video_id={video_id}

$config 	= new Config();
$conn 		= new Connection();
$state 		= new State();
$function 		= new Functions();

$conn->db( $config->sql_dbname() );
$table 		= $config->sql_tablename();

$language	= $function->secureString($_GET['language']);
$video_id	= $function->secureString($_GET['video_id']);

$SqlQuery 	= "SELECT video_title,mp3_id,mp3_ready,mp3_error FROM $table WHERE video_id = '$video_id' LIMIT 1;";
$MySqlArray = $conn->doSQLQuery( $SqlQuery );

if ( $MySqlArray ) {
	while( $sql_results = mysql_fetch_array($MySqlArray)) {
		$mp3_id 	= $sql_results["mp3_id"];
		$mp3_ready 	= $sql_results["mp3_ready"];
		$mp3_error 	= $sql_results["mp3_error"];		
		$mp3_title 	= $sql_results["video_title"];		
	}; # while( $sql_results = mysql_fetch_array($results)) { }
}

//echo "mp3_id=$mp3_id mp3_ready=$mp3_ready mp3_error=$mp3_error<br/>";

if ( $mp3_ready == "1" && strlen($mp3_id) == 32 && $mp3_error == "0" ){
	$mp3_download_uri = $config->mp3_download_uri();
	echo "<h4>". $state->stateHandler("ready",$language) . ' ---> <strong><b><a href="'.$mp3_download_uri.$mp3_id."&mp3_title=".$mp3_title.'" rel="nofollow">MP3 Downloaden</a></b></strong></h4>';
	//echo "Download here www.downloadcontent.com/mp3.download.php?dl";
} elseif ( $mp3_ready == "0" && $mp3_error == "0" && strlen($mp3_id) != 32){
	//echo "Video wird grad umgewandelt.";
	echo $state->stateHandler("working",$language);
} elseif ( $mp3_ready == "0" && strlen($mp3_error) > 5 && strlen($mp3_id) != 32){
	//echo "Es trat ein Fehler auf: $mp3_error";
	echo $state->stateHandler("error",$language) . $mp3_error;
}

exit(0);

/*
if ( strpos($mp3_ready,'1') !== false && strlen($mp3_id) == 32 ){
	$mp3_download_uri = $config->mp3_download_uri();

... [truncated, 13 more lines] ...

<?php

require_once( "../lib/config.inc.php" );
require_once( "../lib/connection.inc.php");
require_once( "../lib/state.inc.php");
require_once( "../lib/functions.inc.php");
// http://www.nookiestar.com/mp3/ajax/state.php?language=DE&video_id={video_id}

$config 	= new Config();
$conn 		= new Connection();
$state 		= new State();
$function 	= new Functions();

$conn->db( $config->sql_dbname() );
$table 		= $config->sql_tablename();
$temp		= $config->ajax_state_temp_path();

$language	= $function->secureString(strtolower($_REQUEST['language']));
$video_id	= $function->secureString($_REQUEST['video_id']);
$mp3_download_uri = $config->mp3_download_uri();

// check if state ready: Start
if (file_exists("$temp/$video_id.$language")){
	echo file_get_contents("$temp/$video_id.$language");
	exit(0);
}

$SqlQuery 	= "SELECT video_title,mp3_id,mp3_ready,mp3_error FROM $table WHERE video_id = '$video_id' LIMIT 1;";
$MySqlArray = $conn->doSQLQuery( $SqlQuery );

if ( $MySqlArray ) {
	while( $sql_results = mysql_fetch_array($MySqlArray)) {
		$mp3_id 	= $sql_results["mp3_id"];
		$mp3_ready 	= $sql_results["mp3_ready"];
		$mp3_error 	= $sql_results["mp3_error"];		
		$mp3_title 	= $sql_results["video_title"];		
	}; # while( $sql_results = mysql_fetch_array($results)) { }
}

//echo "mp3_id=$mp3_id mp3_ready=$mp3_ready mp3_error=$mp3_error<br/>";
if ( $mp3_ready == "1" && strlen($mp3_id) == 32 && $mp3_error == "0" ){	
	$retVal = "<h4 style=\"font-size: 16px;\">". $state->stateHandler("ready",$language) . ' ---> <strong><b><a href="'.$mp3_download_uri.$mp3_id."&mp3_title=".$mp3_title.'" rel="nofollow">MP3 Download</a></b></strong></h4>';
	file_put_contents("$temp/$video_id.$language", $retVal, LOCK_EX);
	echo $retVal;
	//echo "Download here www.downloadcontent.com/mp3.download.php?dl";
} elseif ( $mp3_ready == "0" && $mp3_error == "0" && strlen($mp3_id) != 32){
	//echo "Video wird grad umgewandelt.";
	echo $state->stateHandler("working",$language);
} elseif ( $mp3_ready == "0" && strlen($mp3_error) > 5 && strlen($mp3_id) != 32){
	//echo "Es trat ein Fehler auf: $mp3_error";

... [truncated, 7 more lines] ...

<?php
require_once ('/home/wwwyoutube/lib/suggest/common.php');
require_once ('/home/wwwyoutube/lib/suggest/functions.php');

$indexes 	= 'songtext';

$arr =array();
$q = trim($_GET['term']);
$stmt = $ln_sph->prepare("SELECT * FROM $indexes WHERE MATCH(:match) LIMIT 0,10");


$aq = explode(' ',$q);
if(strlen($aq[count($aq)-1])<3){
	$query = $q;
}else{
	$query = $q.'*';
}
$stmt->bindValue(':match', $query,PDO::PARAM_STR);
$stmt->execute();

foreach($stmt->fetchAll() as $r){
	$arr[] = array('id' => utf8_encode($r['title']),'label' =>utf8_encode( $r['title']));
}

echo json_encode($arr);
exit();

<?php

require_once ('/home/wwwyoutube/lib/suggest/common.php');
require_once ('/home/wwwyoutube/lib/suggest/functions.php');

$indexes 	= 'songtext';
$arr 		= array();
$q 			= trim($_GET['term']);
$stmt 		= $ln_sph->prepare("SELECT * FROM $indexes WHERE MATCH(:match) LIMIT 0,10 OPTION ranker=sph04");


$aq = explode(' ',$q);
if(strlen($aq[count($aq)-1])<3){
	$query = $q;
}else{
	$query = $q.'*';
}
$stmt->bindValue(':match', $query,PDO::PARAM_STR);
$stmt->execute();

$docs = array();
$title = "";
$stmsnp = $ln_sph->prepare("CALL SNIPPETS(:doc,$indexes,:query)");
$stmsnp->bindValue(':query',$query,PDO::PARAM_STR);
$stmsnp->bindParam(':doc',$title,PDO::PARAM_STR);

foreach($stmt->fetchAll() as $r){
	$title = $r['title'];
	$stmsnp->execute();
	$r = $stmsnp->fetch();
	$arr[] = array('id' => utf8_encode($r['snippet']),'label' =>utf8_encode( $r['snippet']));
}


echo json_encode($arr);
exit();