<?
include_once('db.php');
$result = dbQuery("SELECT * FROM content WHERE trailer_filename = '' AND photos = 0 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.'/';
        $trailer = uniqid().'.mp4';
        $q = "$ffmpeg_path -i \"".$video_path."/$subdir".$row[filename]."\" -ss $trailerFrom -t $trailerDuration $ffmpeg_command \"$video_path/$subdir".$trailer."\"";
        echo "Encoding... ".$row[orig_filename]." -> ".$trailer."\n";
        echo "Command: ".$q."\n";
        shell_exec($q);
        shell_exec("$mp4box_path -inter 500 \"$video_path/$subdir"."$trailer\"");
        if(file_exists($video_path."/$subdir".$trailer) && filesize($video_path."/$subdir".$trailer) > 0) {
                dbReconnect();
                dbQuery("UPDATE content SET trailer_filename = '$trailer' WHERE record_num = '$rrow[id]'");
        }
}
echo "\n----------------------\nEncoding Complete - $counter videos converted";
?>