[mythtv] episode number feature?

[Guillaume ml Membré]

thanks
Guillaume

On 1/19/07, Cameron Banta <cbanta2 at gmail.com> wrote:
>
>
> 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
>
>
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>
>
>