patch to assist scheduling unique (new) movies

[tom@…]

I run a terabyte server which I use to store edited movies. The server is accessable to mythtv via nfs. This the "Utilities/setup | Setup | Media setup | Videos settings | General settings" and "directory which holds videos" (mounted as '/VideoLib?'). Currently, I have 300+ movies in that directory. I found two issues with the stock behavior of "Manage recordings | Schedule recordings | Search lists | Movies" which made the scheduling rather tedious:

1) by nature, the schedule is organized by date + time + title. This causes replications I had to weed my way through, I found that I would duplicate recording of the same movie twice as I forgot that I had already scheduled an earlier showing.

2) Once I got up around 80 or so movies in /VideoLib? I started to schedule movies that I already had on the video server. Once I had gone through the list of movies and scheduled them for recording, I would then have to tediously check for duplicates.

This patch does two things:

A) it changes the display of the movie list so that it is sorted by: title + unique. B) it also removes titles which currently exist within the /VideoLib? (current copies on the Video Library).

I did this by modifying the proglist.cpp so that an additional choice was added to the popup menu: "Unique". By selecting "Unique", a new mysql command is issued to do the "unique" and "left join" to present me with the desired listing. This has made the scheduling of new movies so much easier and I would like to see this added to upcoming releases of MythTV so I won't have to re-patch?

Regards,

TomW

Sorry about putting the patch in this message, but the "attach file" doesn't seem to work. it is a dead-end menu!!!!!!!!!

======================= begin patch ===================================== diff -Nur orig/mythtv-0.18.1/libs/libmythtv/proglist.cpp mythtv-0.18.1/libs/libmythtv/proglist.cpp --- orig/mythtv-0.18.1/libs/libmythtv/proglist.cpp 2005-05-11 15:24:37.000000000 -0400 +++ mythtv-0.18.1/libs/libmythtv/proglist.cpp 2005-08-23 07:29:10.000000000 -0400 @@ -1312,6 +1312,8 @@

viewTextList << tr("At least 3 stars"); viewList << "0.5"; viewTextList << tr("At least 2 stars");

+ viewList << "Unique"; + viewTextList << tr("Unique");

curView = 0;

} else if (type == plTime)

@@ -1470,11 +1472,29 @@

} else if (type == plMovies) list movies {

• where = QString("WHERE channel.visible = 1 "
• " AND program.endtime > %1 "
• " AND program.category_type = 'movie' "
• " AND program.stars >= '\%2' ")
• .arg(startstr).arg(qphrase);

+ if (qphrase != "Unique") { + where = QString("WHERE channel.visible = 1 " + " AND program.endtime > %1 " + " AND program.category_type = 'movie' " + " AND program.stars >= '\%2' ") + .arg(startstr).arg(qphrase); + } else { list only by unique show names. + where = QString("WHERE channel.visible = 1" + " AND program.endtime > %1 " + " AND program.category_type = 'movie'" + " GROUP BY program.title " + " ORDER BY program.title ASC ") + .arg(startstr); + where = QString("LEFT JOIN videometadata ON" + " program.title = videometadata.title" + " WHERE channel.visible = 1" + " AND program.endtime > %1" + " AND program.category_type = 'movie'" + " AND videometadata.title IS NULL" + " GROUP BY program.title" + " ORDER BY program.title ASC ") + .arg(startstr); + }

} else if (type == plTime) list by time {

============================= snip ==================================