[mythtv] [PATCH]change made in dbver 1024 not reflected in channelsettings.cpp

[Kenneth Aafløy]

På Wed, 21 Jan 2004 10:10:17 -0500, skrev Steve Brown 
<sbrown at cortland.com>:

> This fixes a problem populating the satellite combo box when
> editing/adding a dvb channel. It's against the current cvs.
>
> This was my first chance to exercise the dvb code since last October.
> What a difference!
>
> Great work Kenneth, et.al.

Thanks!

I'm sure this trivial change was included in the patch (satellite editor):

Kenneth

Index: channelsettings.cpp
===================================================================
RCS file: /var/lib/mythcvs/mythtv/libs/libmythtv/channelsettings.cpp,v
retrieving revision 1.4
diff -u -r1.4 channelsettings.cpp
--- channelsettings.cpp 3 Jan 2004 02:58:03 -0000       1.4
+++ channelsettings.cpp 21 Jan 2004 16:36:45 -0000
@@ -227,8 +227,10 @@
      {
          clearSelections();
          QSqlQuery query = db->exec(QString(
-            "SELECT dvb_sat.name,dvb_sat.satid FROM dvb_sat,channel"
-            " WHERE dvb_sat.sourceid=channel.sourceid AND 
channel.chanid='%1'")
+            "SELECT dvb_sat.name,dvb_sat.satid FROM 
dvb_sat,channel,cardinput"
+            " WHERE dvb_sat.cardid=cardinput.cardid"
+            " AND cardinput.sourceid=channel.sourceid"
+            " AND channel.chanid='%1'")
              .arg(id.getValue()));
          if (!query.isActive())
              MythContext::DBError("DvbSatellite::fillSelections", query);