<? 
include_once('db.php'); 
if(file_exists('scripts/xml_running')) {
	exit("XML Import already running! If you are sure it is not, please delete admin/scripts/xml_running.");
}	
//check if there are any videos to encode
$rresult = mysql_query("SELECT * FROM xml_feeds ORDER BY record_num ASC") or die(mysql_error());
if(mysql_num_rows($rresult) < 1) {
	echo "No xml feeds to import!";
}

$arr = array();
file_put_contents('scripts/xml_running','true'); 
$result = mysql_query("SELECT * FROM xml_feeds ORDER BY record_num ASC");
$counter = 0;
while($row = mysql_fetch_array($result)) {
	if(stripos($row[url],'webmastercentral') !== false) {
		echo "WebmasterCentral Feed Detected!\n";
		echo "Processing...$row[url]...";
		$xml = simplexml_load_string(file_get_contents($row[url]));
		if($xml) {
			echo "Done!\n";
		} else {
			echo "Failed!\n";
		}
		foreach($xml->set as $i) {
			$arr[$counter][id] = (int) $i->id;
			$arr[$counter][title] = (string) $i->title;
			$arr[$counter][desc] = (string) $i->title;
			$arr[$counter][keywords] = (string) $i->title;
			$arr[$counter][flv] = (string) getWebmasterCentralVideo($arr[$counter][id]);
			$arr[$counter][feed] = $row[name]; 
			$arr[$counter][thumb] = (string) $i->thumbnail;
			$arr[$counter][external] = 'webmastercentral'.$i->id;
			$counter++;
		}
		grabXMLVideos($arr);
		unset($arr); 
	}
	elseif(stripos($row[url],'membercms.com') !== false) { 
		echo "AdultCentro Feed Detected!\n";
		echo "Processing...$row[url]...";
		$xml = simplexml_load_string(file_get_contents($row[url]));
		if($xml) {
			echo "Done!\n";
		} else {
			echo "Failed!\n";
		}
		
		$pageCurrent = (int) $xml->Digits->pageCurrent;
		$pageNext = (int) $xml->Digits->pageNext;
		$pageLast =  (int) $xml->Digits->pageLast;
		//print_r($xml);
		echo "Total Pages: $pastLast\n"; 	
		if(is_numeric($pageLast)) { 
			$pageLast = 5;
			for($z = 0; $z <= $pageLast; $z++) {
				$pagedUrl = $row[url].'&boxPager_cp='.$z;
				echo "Processing...$pagedUrl...";
				$xml = simplexml_load_string(file_get_contents($pagedUrl));
				if($xml) {
					echo "Done!\n";
				} else {
					echo "Failed!\n";
				}
				foreach($xml->Dvds->dvd as $i) { 
					$arr[$counter][id] = (int) $i->dvd_id;
					$arr[$counter][title] = (string) $i->descriptions->description->description_text;
					$arr[$counter][desc] = (string) $i->descriptions->description->description_text;
					unset($acKeywords);
					foreach($i->categories->category as $c) {
						$acKeywords[] = (string) $c->name;
					}
					$arr[$counter][keywords] = implode(", ",$acKeywords);
					$arr[$counter][flv] = getAdultCentroVideo($arr[$counter][id]); 
					$arr[$counter][feed] = $row[name]; 
					$arr[$counter][external] = 'adultcentro'.$arr[$counter][id];
					print_r($arr[$counter]);
					$counter++;
				}
				grabXMLVideos($arr);
				unset($arr); 
			}		
		}
	}
	else {
		echo "Standardized XML Feed Processing...\n";
		echo "Processing...$row[url]...";
		$xml = simplexml_load_string(file_get_contents($row[url]));
		if($xml) {
			echo "Done!\n";
		} else {
			echo "Failed!\n";
		}
		foreach($xml->video as $i) {
			foreach($i->clips->clip as $j) {
				$arr[$counter][id] = $i->id;
				$arr[$counter][title] = $i->title;
				$arr[$counter][desc] = $i->description;
				$arr[$counter][keywords] = $i->tags; 
				$arr[$counter][flv] = $i->clip_url.$j->flv;
				$arr[$counter][length] = $j->duration; 
				$arr[$counter][paysite] = $i->paysite; 
				$arr[$counter][feed] = $row[name]; 
				$arr[$counter][thumb] = $i->screen_url.$j->screens->screen;
				$counter++;
			}
		}
		grabXMLVideos($arr);
		unset($arr); 
	}
}
print_r($arr);




function grabXMLVideos($arr) {
	global $content_path;
	global $wget_path;
	foreach($arr as $i) {
		$title = $i[title];
		$desc = $i[desc]; 
		$keywords = $i[keywords];
		$flv = $i[flv]; 
		$length = $i[length];
		$paysite = $i[paysite]; 
		$feed = $i[feed].'|'.$i[id];
		$thumb = $i[thumb]; 
		if($row[hotlink] == 1) {
			$hotlinked = mysql_real_escape_string($flv);
		}
		else {
			if($i[external]) {
				$hotlinked = mysql_real_escape_string($i[external]); 
			}
			else {
				unset($hotlinked);
			}
		}
		if(eregi('.mp4',$i[flv])) {
			$filename = md5(microtime()).".mp4"; 
		} 
		else {
			if(stripos($i[external],'adultcentro') !== 'false') {
				$filename = md5(microtime()).".mp4"; 
			}
			else {
				$filename = md5(microtime()).".flv"; 
			}
		}
		$paysite = mysql_real_escape_string($paysite);
		$title = mysql_real_escape_string($title); 
		$keywords = mysql_real_escape_string($keywords);
		$desc = mysql_real_escape_string($desc); 
		$length = mysql_real_escape_string($length);
		$feed = mysql_real_escape_string($feed);
		$thumb = mysql_real_escape_string($thumb); 
		if(mysql_num_rows(mysql_query("SELECT record_num FROM content WHERE xml = '$feed'")) < 1) {
			shell_exec("$wget_path ".escapeshellarg(str_replace('\r','',$flv))." -O \"$content_path/$filename\"");
			$filesize = filesize($content_path."/".$filename); 
			if(file_exists($content_path."/".$filename) && $filesize > 0) {
				dbReconnect();
				if(mysql_num_rows(mysql_query("SELECT * FROM paysites WHERE name LIKE '$paysite'")) < 1) {
					mysql_query("INSERT INTO paysites (name) VALUES ('$paysite')");
					$paysiteid = mysql_insert_id();
				}
				else {
					$mresult = mysql_query("SELECT * FROM paysites WHERE name LIKE '$paysite'");
					$mrow = mysql_fetch_array($mresult);
					$paysiteid = $mrow[record_num];
				}
				
					$sql = "INSERT INTO content (title, filename, orig_filename, description, keywords, scheduled_date, date_added,  approved, hotlinked, paysite, xml) VALUES ('$title', '".$filename."', '$filename', '$desc','$keywords',  NOW(), NOW(), 0, '$hotlinked', '$paysiteid', '$feed')";
					mysql_query($sql) or die(mysql_error());
				}
				$vardump = print_r($i,true);
			echo "$feed does not exist, downloading $vardump\n";
		}
		else {
			echo "$feed exists, skipping\n";
		}
	} 
}


echo "\nFINISHED";
@unlink('scripts/xml_running'); 
exit(); 
?>