Ticket #829: mythtv-0.18.1-patch

File mythtv-0.18.1-patch, 1.9 KB (added by tom@…, 20 years ago)

patch to schedule from unique lists movies minus those already in video libary

Line 
1diff -Nur orig/mythtv-0.18.1/libs/libmythtv/proglist.cpp mythtv-0.18.1/libs/libmythtv/proglist.cpp
2--- orig/mythtv-0.18.1/libs/libmythtv/proglist.cpp 2005-05-11 15:24:37.000000000 -0400
3+++ mythtv-0.18.1/libs/libmythtv/proglist.cpp 2005-08-23 07:29:10.000000000 -0400
4@@ -1312,6 +1312,8 @@
5 viewTextList << tr("At least 3 stars");
6 viewList << "0.5";
7 viewTextList << tr("At least 2 stars");
8+ viewList << "Unique";
9+ viewTextList << tr("Unique");
10 curView = 0;
11 }
12 else if (type == plTime)
13@@ -1470,11 +1472,29 @@
14 }
15 else if (type == plMovies) // list movies
16 {
17- where = QString("WHERE channel.visible = 1 "
18- " AND program.endtime > %1 "
19- " AND program.category_type = 'movie' "
20- " AND program.stars >= '\%2' ")
21- .arg(startstr).arg(qphrase);
22+ if (qphrase != "Unique") {
23+ where = QString("WHERE channel.visible = 1 "
24+ " AND program.endtime > %1 "
25+ " AND program.category_type = 'movie' "
26+ " AND program.stars >= '\%2' ")
27+ .arg(startstr).arg(qphrase);
28+ } else { // list only by unique show names.
29+// where = QString("WHERE channel.visible = 1"
30+// " AND program.endtime > %1 "
31+// " AND program.category_type = 'movie'"
32+// " GROUP BY program.title "
33+// " ORDER BY program.title ASC ")
34+// .arg(startstr);
35+ where = QString("LEFT JOIN videometadata ON"
36+ " program.title = videometadata.title"
37+ " WHERE channel.visible = 1"
38+ " AND program.endtime > %1"
39+ " AND program.category_type = 'movie'"
40+ " AND videometadata.title IS NULL"
41+ " GROUP BY program.title"
42+ " ORDER BY program.title ASC ")
43+ .arg(startstr);
44+ }
45 }
46 else if (type == plTime) // list by time
47 {