[mythtv-users] mythepisode - mythweb unofficial addon

[Chad Oppliger]

On Sun, Aug 15, 2010 at 9:07 AM, Chris Kapp <chris.kapp at gmail.com> wrote:
>
>
> 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")
>

Thanks for the feedback and update Chris.  I will update the code.
Since my db was so small I wasn't running into the loading problem.

Chad