diff --git a/.gitignore b/.gitignore new file mode 100644 index 0000000..2de0e7c --- /dev/null +++ b/.gitignore @@ -0,0 +1 @@ +ffmpeg2pass-0.* diff --git a/cron2.php b/cron2.php index c557db4..41d8faa 100755 --- a/cron2.php +++ b/cron2.php @@ -69,7 +69,7 @@ print "[" . json_encode($aData) . "]\n"; $mType = 2; - $encode = "/usr/local/bin/ffmpeg -i \"/usr/tuve/assets/UbixCube.gif\" -i \"/media/incoming/" . $qData['file'] . "\" -vf \"scale=w=800:h=450:force_original_aspect_ratio=1,pad=800:450:(ow-iw)/2:(oh-ih)/2\" -tune stillimage -ar 44100 -ac 2 -ab 128k -t $mDuration -r 0.5 -f flv -y \"/media/tmp/" . $qData['file'] . ".flv\""; + $encode = "/usr/local/bin/ffmpeg -i \"/usr/tuve/assets/UbixCube.gif\" -i \"/media/incoming/" . $qData['file'] . "\" -vf \"scale=w=800:h=450:force_original_aspect_ratio=1,pad=800:450:(ow-iw)/2:(oh-ih)/2:white\" -tune stillimage -c:a mp3 -ar 44100 -ac 2 -ab 128k -t $mDuration -r 0.5 -f flv -y \"/media/tmp/" . $qData['file'] . ".flv\""; print "[" . $encode . "]"; $res = system($encode, $retVal); if ($retVal == 1) diff --git a/fix_artist.php b/fix_artist.php new file mode 100755 index 0000000..1c4b15d --- /dev/null +++ b/fix_artist.php @@ -0,0 +1,20 @@ + + * + * $Id$ + */ + +include ("include/config.php"); + +$query = "SELECT file,artist FROM videos_pending ORDER by vid desc"; +$result = $db->query($query); + +$i = 0; + +while ($qData = $result->fetch_assoc()) { + print $i++ . ","; + $query = "UPDATE videos SET artist=\"" . $qData['artist'] . "\" WHERE file=\"" . $qData['file'] . ".flv\""; + $db->query($query); +} +?>