hi peter,<br><br>i've just installed pdatranscode.pl onto my mythbox (so i can convert stuff for the psp) and i noticed a small problem (which i just verified with the latest version (1.20) i saw online).<br><br>the options
<br><pre>-lavcopts aglobal=1:vglobal=1:vcodec=mpeg4:vbitrate=300=aac<br><br>should read:<br>-lavcopts aglobal=1:vglobal=1:vcodec=mpeg4:vbitrate=300;acodec=aac<br></pre><br>i've not tested the output as its transcoding atm, however when i made that small change, the lavcopts could be parsed without error.. :-)
<br><br>anyways, hth<br>regs<br>Ryszard.<br><br><div><span class="gmail_quote">On 12/12/06, <b class="gmail_sendername">Peter Watkins</b> <<a href="mailto:peterw@tux.org">peterw@tux.org</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Folks,<br><br>I've just uploaded a new version of my "pdatranscode.pl" script that now<br>includes code for handling the MySQL updates needed to set up a User Job.<br>Setting up pdatranscode.pl to run as a User Job now can be as easy as running
<br> pdatranscode.pl --install-job-number 1<br><br>I've updated the wiki with more info<br> <a href="http://www.mythtv.org/wiki/index.php/Transcoding_for_the_PDA">http://www.mythtv.org/wiki/index.php/Transcoding_for_the_PDA
</a><br>and the script, as usual, is here:<br> <a href="http://www.tux.org/~peterw/linux/pdatranscode.pl.txt">http://www.tux.org/~peterw/linux/pdatranscode.pl.txt</a><br><br>I'd appreciate any pointers for my mysqlQuote() function -- I deliberately chose
<br>to write my own instead of relying on DBI in order to reduce external dependencies,<br>and I would not be surprised if there's something wrong with my logic.<br><br>-Peter<br><br>Sample "install" usage:<br>
<br># pdatranscode --install-job-number 1 --install-job-name "PDA Transcode (normal)"<br><br>will install as UserJob number 1, "PDA Transcode (normal)" the following command:<br> /usr/local/bin/pdatranscode --file %FILE% --title "%TITLE%" --subtitle "%SUBTITLE%" --description "%DESCRIPTION%"
<br><br>by issuing the following SQL query to "/usr/bin/mysql -h <a href="http://127.0.0.1">127.0.0.1</a> -u mythtv -p >/tmp/pdatranscode-install-5286795/mysql.out":<br> use mythconverg;<br> # First, we retrieve what's currently in the database,
<br> # just in case something goes awry.<br> SELECT * FROM settings WHERE value='UserJob1';<br> SELECT * FROM settings WHERE value='UserJobDesc1';<br> SELECT * FROM settings WHERE value='JobAllowUserJob1';
<br> UPDATE settings SET data='/usr/local/bin/pdatranscode --file %FILE% --title "%TITLE%" --subtitle "%SUBTITLE%" --description<br>"%DESCRIPTION%"' WHERE value='UserJob1';<br>
UPDATE settings SET data='PDA Transcode (normal)' WHERE value='UserJobDesc1';<br> UPDATE settings SET data='1' WHERE value='JobAllowUserJob1';<br> # Now see what's in the database after the UPDATE statements
<br> SELECT * FROM settings WHERE value='UserJob1';<br> SELECT * FROM settings WHERE value='UserJobDesc1';<br> SELECT * FROM settings WHERE value='JobAllowUserJob1';<br><br>Interrupt (press Control-C) to abort, or press Return to continue.
<br>Enter password:<br>It appears that the database update was successful.<br>See /tmp/pdatranscode-install-5286795/mysql.out for MySQL output.<br><br>Please note: you likely need to restart mythbackend to effect any changes.
<br><br><br><br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br><br><br><br></blockquote></div><br>