Bruce Markey wrote:
Dan Wilga wrote:
As we all know, movie channels like to show the same film over and over. As it stands, Myth's Movies listing is huge, because is shows the same films many times. Finding movies I'd like to record takes a really long time, because of all the duplicates.
It's also huge because there are a lot of different titles. Showing each title once would shorten the list for a few days in the future but would barely have any impact in the first couple hours of this time sorted list. If you are looking ahead to a certain time frame to see what you might watch then, there would be valid choices missing. Also, say you have both HBO and HBOP 3 hours delayed. At 8:45 you spot a movie you'd like to see that is on HBO from 7-9 and is about to end. It wouldn't show you that it's on again in about an hour from 10-12 on HBOP.
What I'd like to be able to do is see all upcoming movies, but not list the same title more than once. Ideally, when I click on a title, I would be able to see all upcoming showings of that movie, and choose which one to record.
I can think of several reasons not to do this by default but this should give you what you describe. The attached would have been a one liner but it's two so that it also addresses the HBO example above.
I can't see any way to do this with either the Movies or Advanced listings. Am I missing something, or is it not currently possible?
Don't over look the HOME and END keys to filter by stars. This is probably a much more effective chop the list down to just things you might actually watch.
-- bjm
------------------------------------------------------------------------
Index: libs/libmythtv/proglist.cpp
===================================================================
RCS file: /var/lib/mythcvs/mythtv/libs/libmythtv/proglist.cpp,v
retrieving revision 1.57
diff -u -r1.57 proglist.cpp
--- libs/libmythtv/proglist.cpp 6 Mar 2005 17:00:13 -0000 1.57
+++ libs/libmythtv/proglist.cpp 27 Mar 2005 15:05:48 -0000
@@ -1407,9 +1407,10 @@
else if (type == plMovies) // list movies
{
where = QString("WHERE channel.visible = 1 "
- " AND program.endtime > %1 "
+ " AND program.starttime > %1 "
" AND program.category_type = 'movie' "
- " AND program.stars >= '\%2' ")
+ " AND program.stars >= '\%2' "
+ "GROUP BY program.title ")
.arg(startstr).arg(qphrase);
}
else if (type == plTime) // list by time
------------------------------------------------------------------------
I just submitted a patch to the dev list which uses the 1/2 keys to switch between the normal "All" view and a "Unique" view. This works for Movies, Categories and Channels.
Not being a SQL expert, the above example was very usefull. Thanks Bruce.
John
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
