[mythtv] episode number feature?

[Cameron Banta]

On 1/11/07, Guillaume Membré <guillaume.ml at gmail.com> wrote:
>
>
> could you send it or put somewhere on the web. I'm really interesting
> in this user job.


Here's the SQL:
---------
use mythconverg;
update recorded r  JOIN recordedprogram rp on r.programid = rp.programid
set r.subtitle = CONCAT(r.subtitle, " [", rp.syndicatedepisodenumber, "]")
where r.subtitle not like "%]" and rp.syndicatedepisodenumber <> ""
;
---------
You can run it from cron. Something like this will work: mysql mythconverg
-ppassword < /root/update_subtitles.sql

-Cameron
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20070118/d7a58afb/attachment.htm