[mythtv-users] mythepisode - mythweb unofficial addon

[Chris Kapp]

On Sat, Aug 14, 2010 at 12:11 PM, Andre <mythtv-list at dinkum.org.uk> wrote:

>
> On 13 Aug 2010, at 05:04, Chad Oppliger wrote:
>
> > I created a little add-on to mythweb that displays every television
> series ever aired(according to tvrage).  Each tv show has a link that when
> selected will display a list of every episode for the particular show and a
> status showing if you have a particular episode scheduled for recording or
> have recorded it in the past.  From the episode listing you can choose to
> create a tvwish list that will schedule recordings based off of the wish
> list when they become available.
>
> Nice feature addition, thanks.
>
> Sadly my myth database seems to think it hasn't recorded a lot of episodes
> that in fact it has, well at least I now know why it keeps recording the
> same CSI episodes over and over again!
>
> One small comment, would be much nicer to use if the initial TV Episodes
> page was some sort of summary page with the A-Z links rather than dropping
> straight into a page that takes a couple of minutes to render, longer than
> the php timeout for most people it seems.
>
> Great stuff.
>
> Andre
>
>
>
> >
> > mythepisode is something I created because I wanted to find out if I had
> seen every episode of "The King of Queens" and record them if not.  I wasn't
> going to put this out because I'm truly a hack when it comes to coding, but
> i figured someone might find it useful and make improvements to the code.
> >
> > I am running mythtv .22 and have only tested it with that version.  You
> can find the code and data files at
> > https://sites.google.com/site/mythepisode
> >
>
>
Thank you for the feature.

I've made a change that have significantly improved the speed on my system.
 Prior to the change, I couldn't get the main page to load past the b's.
 The following change allows me to see the whole page without having to
change my php timeouts and keeps all the green hi-lighting.

Edit:  /usr/share/mythtv/mythweb/modules/episode/show.php
change the line(45):  $recordings = mysql_query("SELECT title FROM
oldrecorded")
to read:  $recordings = mysql_query("SELECT distinct title FROM
oldrecorded")
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100815/2a4a99b7/attachment.htm>