youtube-mp3-converter - wwwroot - app - query - SOURCE CODE

<?php


class Config {
	
	private $sql_hostname ;
	private $sql_dbname ;
	private $sql_username ;
	private $sql_password ;
	
	private $sql_table_movies;
	private $sql_table_series;
	private $sql_table_comics;
	private $sql_table_porn;
	private $sql_table_music;
	
	private $sql_max_results;
	private $host_ip;
	private $wwwroot;
	private $previewtime;
	
	private $different_servers_enabled;
	private $query_host;
	private $query_hosts_wwwoot;
	private $query_hosts_ip;
	private $max_random_results;
	
	public function __construct() {
		
		$this->sql_hostname = "localhost"; 
		$this->sql_dbname = "youtube";
		$this->sql_password = "rouTer99";
		$this->sql_username = "root";
		
		$this->sql_table_movies = "movies"; 
		$this->sql_table_series = "series";
		$this->sql_table_comics = "comics";
		$this->sql_table_porn = "movies";
		$this->sql_table_music = "music";
		
		$this->max_random_results = 10;
		$this->sql_max_results 	= 100;
		$this->host_ip 			= "176.9.19.144/app/c"; // ip of server giving out the mp4 downloads/streams
		$this->wwwroot 			= "/home/wwwyoutube/app/c";
		$this->previewtime		= 600; // 10 minutes
		
		$this->query_servers_enabled		= 0; //
		$this->query_hosts					= "https:///search.php";
		$this->query_hosts_wwwoot			= "/media/kubuntu/TOSHIBA EXT/BuzzerStar/";
		$this->query_hosts_ip				= "";

... [truncated, 76 more lines] ...

<?php
require_once ( "config.inc.php" );

class Connection {

	private $_host;
	private $_login;
	private $_password;
	private $_socket;
	private $results;
	
	private $MYSQL_PR_HOST;
	private $MYSQL_PR_USER;
	private $MYSQL_PR_PASS;
	private $MYSQL_PR_DATABASE;
	private $DBH;
	private $db;

	public function db($dba){
		$this->db = $dba;
	}
	
	public function doSQLQuery( $sql_query ){ 
			
		mysql_select_db($this->db, $this->_socket) OR die ("Error connecting to DB on $this->db, $this->_socket . Error Message: ".mysql_error($this->_socket));
		mysql_query('set names utf8', $this->_socket);
		$results	= mysql_query($sql_query , $this->_socket);
		mysql_close($this->_socket);
		return $results;

	}
		
	public function __construct() {

		$config = new Config();
		$MYSQL_PR_HOST = $config->sql_hostname();
		$MYSQL_PR_USER = $config->sql_username();
		$MYSQL_PR_PASS = $config->sql_password();
				
		$DBH = mysql_connect($MYSQL_PR_HOST, $MYSQL_PR_USER, $MYSQL_PR_PASS);
		$this->_socket = $DBH;
		
	/*
		$config = new Config();
		$socket = socket_create(AF_INET, SOCK_STREAM, SOL_TCP);
		if ($socket === false) {
			echo "socket_create() failed: reason: " . socket_strerror(socket_last_error()) . "\n";
			echo "Query Server down - inform thecerial@gmail.com ";
		} else {
			echo "OK.\n";

... [truncated, 27 more lines] ...

<?php
require_once ( "config.inc.php" );

class Functions {

function containsString($yt_title,$sphinx_hit){
	
	$bad_words = explode(" ", $yt_title);
	$valid = false;
	
	foreach ($bad_words as $bad_word) {
		if (stripos($sphinx_hit, $bad_word) !== false) {
			$valid = true;
			break;
		}
	}

	if ($valid) {
		return 1;
	} else {
		return 0;
	}

} // function containsString($yt_title,$sphinx_hit){


/*
	Remove Bad charcters from String
*/
function secureString($del_badchar) {

	if ( strlen($del_badchar) > 256 ) {
		# l?sche alles nach dem 200sten zeichen bei ?berlangen eingaben
		$del_badchar = substr($del_badchar, 0, 256);		
	};

	$del_badchar 			= preg_replace("/[^a-z0-9\s+-]/i", " ", $del_badchar);
	
	$code_entities_match	= array(' ','--','&quot;','!','@','#','$','%','^','&','*','(',')','_','{','}','|',':','"','<','>','?','[',']','\\',';',"'",',','.','/','*','~','`','=','^');
	$code_entities_replace	= array(' ',' ','','','','','','','','','','','','','','','','','','','','','','','');
	$del_badchar			= str_replace($code_entities_match, $code_entities_replace, $del_badchar);

	$del_badchar			= addslashes($del_badchar);
	$del_badchar			= strip_tags($del_badchar);
	$del_badchar			= escapeshellcmd($del_badchar);

	return $del_badchar;
	
} # function secureString($del_badchar) {


... [truncated, 251 more lines] ...

<?php
require_once ( "config.inc.php" );
require_once ( "connection.inc.php" );
require_once ( "sphinxapi.inc.php" );

class Search {

	function SphinxSearch( $SearchQuery, $catg ){

		if ( !preg_match('/([\w+]|[\d+]|[^A-Za-z0-9]|[a-z]|[0-9]{2,})/i', $SearchQuery) || strlen($SearchQuery) <= 1 ){
		//	echo "SphinxSearch searchquery is null: $SearchQuery<br />";
			$ResultArray	= array();
			return $ResultArray;
		};
	
		$config 	= new Config();
		$maxresults = $config->sql_max_results();
		$db 		= $config->sql_dbname();
		$conn 		= new Connection( );
		$conn->db( $db );

		if ( strcasecmp($catg,"music")==0){
			$tbl 		= $config->sql_table_music();
			$index		= "music";
		} else if ( strcasecmp($catg,"movies")==0){
			$tbl 		= $config->sql_table_movies();
			$index		= "movies";
		} else if ( strcasecmp($catg,"porn")==0){
			$tbl 		= $config->sql_table_porn();
			$index		= "movies";
		} else if ( strcasecmp($catg,"series")==0){
			$tbl 		= $config->sql_table_series();
			$index		= "series";
		} else if ( strcasecmp($catg,"comics")==0){
			$tbl 		= $config->sql_table_comics();
			$index		= "comics";	
		} else if ( strcasecmp($catg,"kids")==0){
			$tbl 		= $config->sql_table_comics();
			$index		= "kids";
		} else if ( strcasecmp($catg,"anime")==0){
			$tbl 		= $config->sql_table_comics();
			$index		= "anime";		
		} else { // movies
			$tbl 		= $config->sql_table_movies();
			$index		= "movies";
		}

		//echo "DEBUG: SEarching for $SearchQuery in $catg (index: $index)<br>";

		$cl 		= new SphinxClient();

... [truncated, 176 more lines] ...

<?php

//
// $Id: sphinxapi.php 3802 2013-04-10 12:49:42Z tomat $
//

//
// Copyright (c) 2001-2013, Andrew Aksyonoff
// Copyright (c) 2008-2013, Sphinx Technologies Inc
// All rights reserved
//
// This program is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License. You should have
// received a copy of the GPL license along with this program; if you
// did not, you can find it at http://www.gnu.org/
//

/////////////////////////////////////////////////////////////////////////////
// PHP version of Sphinx searchd client (PHP API)
/////////////////////////////////////////////////////////////////////////////

/// known searchd commands
define ( "SEARCHD_COMMAND_SEARCH",		0 );
define ( "SEARCHD_COMMAND_EXCERPT",		1 );
define ( "SEARCHD_COMMAND_UPDATE",		2 );
define ( "SEARCHD_COMMAND_KEYWORDS",	3 );
define ( "SEARCHD_COMMAND_PERSIST",		4 );
define ( "SEARCHD_COMMAND_STATUS",		5 );
define ( "SEARCHD_COMMAND_FLUSHATTRS",	7 );

/// current client-side command implementation versions
define ( "VER_COMMAND_SEARCH",		0x11D );
define ( "VER_COMMAND_EXCERPT",		0x104 );
define ( "VER_COMMAND_UPDATE",		0x103 );
define ( "VER_COMMAND_KEYWORDS",	0x100 );
define ( "VER_COMMAND_STATUS",		0x100 );
define ( "VER_COMMAND_QUERY",		0x100 );
define ( "VER_COMMAND_FLUSHATTRS",	0x100 );

/// known searchd status codes
define ( "SEARCHD_OK",				0 );
define ( "SEARCHD_ERROR",			1 );
define ( "SEARCHD_RETRY",			2 );
define ( "SEARCHD_WARNING",			3 );

/// known match modes
define ( "SPH_MATCH_ALL",			0 );
define ( "SPH_MATCH_ANY",			1 );
define ( "SPH_MATCH_PHRASE",		2 );
define ( "SPH_MATCH_BOOLEAN",		3 );

... [truncated, 1761 more lines] ...

<?php

//
// $Id: test.php 2903 2011-08-04 13:30:49Z shodan $
//

require ( "sphinxapi.php" );

//////////////////////
// parse command line
//////////////////////

// for very old PHP versions, like at my home test server
if ( is_array($argv) && !isset($_SERVER["argv"]) )
	$_SERVER["argv"] = $argv;
unset ( $_SERVER["argv"][0] );

// build query
if ( !is_array($_SERVER["argv"]) || empty($_SERVER["argv"]) )
{
	print ( "Usage: php -f test.php [OPTIONS] query words\n\n" );
	print ( "Options are:\n" );
	print ( "-h, --host <HOST>\tconnect to searchd at host HOST\n" );
	print ( "-p, --port\t\tconnect to searchd at port PORT\n" );
	print ( "-i, --index <IDX>\tsearch through index(es) specified by IDX\n" );
	print ( "-s, --sortby <CLAUSE>\tsort matches by 'CLAUSE' in sort_extended mode\n" );
	print ( "-S, --sortexpr <EXPR>\tsort matches by 'EXPR' DESC in sort_expr mode\n" );
	print ( "-a, --any\t\tuse 'match any word' matching mode\n" );
	print ( "-b, --boolean\t\tuse 'boolean query' matching mode\n" );
	print ( "-e, --extended\t\tuse 'extended query' matching mode\n" );
	print ( "-ph,--phrase\t\tuse 'exact phrase' matching mode\n" );
	print ( "-f, --filter <ATTR>\tfilter by attribute 'ATTR' (default is 'group_id')\n" );
	print ( "-fr,--filterrange <ATTR> <MIN> <MAX>\n\t\t\tadd specified range filter\n" );
	print ( "-v, --value <VAL>\tadd VAL to allowed 'group_id' values list\n" );
	print ( "-g, --groupby <EXPR>\tgroup matches by 'EXPR'\n" );
	print ( "-gs,--groupsort <EXPR>\tsort groups by 'EXPR'\n" );
	print ( "-d, --distinct <ATTR>\tcount distinct values of 'ATTR''\n" );
	print ( "-l, --limit <COUNT>\tretrieve COUNT matches (default: 20)\n" );
	print ( "--select <EXPRLIST>\tuse 'EXPRLIST' as select-list (default: *)\n" );
	exit;
}

$args = array();
foreach ( $_SERVER["argv"] as $arg )
	$args[] = $arg;

$cl = new SphinxClient ();

$q = "";
$sql = "";

... [truncated, 119 more lines] ...