On Fri, Nov 04, 2005 at 01:41:10PM -0800, Bruce Markey wrote:
>
> >Can someone comment on why a manually schedule recording
> >overwrites the underlying program information in the guide?
>
> The DELETE that clears out the old entries while updating should
> have a clause for WHERE... "AND program.manualid = 0 ".
>
Makes sense. Patch attached.
If feedback is good I'll open a ticket for the patch.
Stuart
Index: mythtv/libs/libmythtv/eithelper.cpp
===================================================================
--- mythtv.orig/libs/libmythtv/eithelper.cpp 2005-11-07 10:50:17.000000000
+0000
+++ mythtv/libs/libmythtv/eithelper.cpp 2005-11-07 11:33:28.000000000 +0000
@@ -203,7 +203,8 @@
"FROM program "
"WHERE chanid=:CHANID AND "
" ( ( starttime>=:STIME AND starttime<:ETIME ) AND NOT "
- " ( starttime=:STIME AND endtime=:ETIME AND title=:TITLE ) );");
+ " ( starttime=:STIME AND endtime=:ETIME AND title=:TITLE ) AND "
+ " manualid=0 );");
query.bindValue(":CHANID", chanid);
query.bindValue(":STIME", event.StartTime.
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
