[mythtv-users] DVB EPG kills Manual Schedule

[Stuart Auchterlonie]

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

-------------- next part --------------
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.