<?
include_once('db.php'); 
$result = dbQuery("SELECT * FROM content WHERE mobile = '' AND embed = ''",false);
foreach($result as $row) { 
	$first = $row[filename][0];
	$second = $row[filename][1]; 
	$third = $row[filename][2];
	$forth = $row[filename][3]; 
	$fifth = $row[filename][4]; 	
	@mkdir($video_path.'/'.$first); 
	@mkdir($video_path.'/'.$first.'/'.$second); 
	@mkdir($video_path.'/'.$first.'/'.$second.'/'.$third); 
	@mkdir($video_path.'/'.$first.'/'.$second.'/'.$third.'/'.$forth);
	@mkdir($video_path.'/'.$first.'/'.$second.'/'.$third.'/'.$forth.'/'.$fifth);
	@mkdir($thumb_path.'/'.$first); 
	@mkdir($thumb_path.'/'.$first.'/'.$second); 
	@mkdir($thumb_path.'/'.$first.'/'.$second.'/'.$third); 
	@mkdir($thumb_path.'/'.$first.'/'.$second.'/'.$third.'/'.$forth);
	@mkdir($thumb_path.'/'.$first.'/'.$second.'/'.$third.'/'.$forth.'/'.$fifth);
	$subdir = $first.'/'.$second.'/'.$third.'/'.$forth.'/'.$fifth.'/'; 
	$mobFile = uniqid().'.mp4'; 
	$q = "$ffmpeg_path -i \"".$video_path."/".$subdir.$row[filename]."\" $ffmpeg_mobile_command \"$video_path/$subdir"."$mobFile\""; 
	echo "Encoding... ".$row[filename]." -> ".$mobFile."\n";
	echo "Command: ".$q."\n";
	shell_exec($q);
	shell_exec("$mp4box_path -inter 500 \"$video_path/$subdir"."$mobFile\"");  
	if(file_exists($video_path."/$subdir".$mobFile) && filesize($video_path."/$subdir".$mobFile) > 0) {
		dbReconnect();
		dbQuery("UPDATE content SET mobile = '$mobFile' WHERE record_num = '$row[record_num]'");
	}
}
echo "\n----------------------\nEncoding Complete - $counter videos converted"; 
?>