[mythtv] [PATCH] Mythweb Delete Channels

[Eric Hokanson]

Skipped content of type multipart/alternative-------------- next part --------------
diff -ur mythweb-cvs\settings_channels.php mythweb\settings_channels.php
--- mythweb-cvs\settings_channels.php	Tue May 25 21:42:54 2004
+++ mythweb\settings_channels.php	Tue May 25 22:01:38 2004
@@ -15,8 +15,13 @@
         // Figure out the chanid, or leave
             if (!preg_match('/^channum_(\\d+)$/', $key, $match)) continue;
             list($match, $chanid) = $match;
-        // First, grab values that can be empty
-            $query = 'UPDATE channel SET freqid='.escape($_POST['freqid_'.$chanid])      .','
+        // First, delete any unwanted channels
+            if ($_POST['delete_'.$chanid] == "true") {
+                $query = 'DELETE FROM channel';
+            }
+            else {
+            // Not deleting so grab values that can be empty
+                $query = 'UPDATE channel SET freqid='.escape($_POST['freqid_'.$chanid])      .','
                                      .'finetune='.escape($_POST['finetune_'.$chanid])    .','
                                  .'videofilters='.escape($_POST['videofilters_'.$chanid]).','
                                    .'brightness='.escape($_POST['brightness_'.$chanid])  .','
@@ -26,13 +31,14 @@
                                   .'recpriority='.escape($_POST['recpriority_'.$chanid]) .','
                                   .'commfree='.escape((isset($_POST['commfree_'.$chanid]) && $_POST['commfree_'.$chanid] == "on") ? 1 : 0) .','
                                   .'visible='.escape((isset($_POST['visible_'.$chanid]) && $_POST['visible_'.$chanid] == "on") ? 1 : 0);
-        // next, the fields that need to have a value, so we won't change them if they were emptied
-            if ($_POST['channum_'.$chanid])
-                $query .= ',channum='.escape($_POST['channum_'.$chanid]);
-            if ($_POST['callsign_'.$chanid])
-                $query .= ',callsign='.escape($_POST['callsign_'.$chanid]);
-            if ($_POST['name_'.$chanid])
-                $query .= ',name='.escape($_POST['name_'.$chanid]);
+            // next, the fields that need to have a value, so we won't change them if they were emptied
+                if ($_POST['channum_'.$chanid])
+                    $query .= ',channum='.escape($_POST['channum_'.$chanid]);
+                if ($_POST['callsign_'.$chanid])
+                    $query .= ',callsign='.escape($_POST['callsign_'.$chanid]);
+                if ($_POST['name_'.$chanid])
+                    $query .= ',name='.escape($_POST['name_'.$chanid]);
+            }
         // Submit the query
             $result = mysql_query($query.' WHERE chanid='.escape($chanid))
                 or trigger_error('SQL Error: '.mysql_error(), FATAL);
diff -ur mythweb-cvs\themes\Default\settings_channels.php mythweb\themes\Default\settings_channels.php
--- mythweb-cvs\themes\Default\settings_channels.php	Tue May 25 21:42:54 2004
+++ mythweb\themes\Default\settings_channels.php	Tue May 25 22:07:57 2004
@@ -20,6 +20,7 @@
 
 <table width="100%" border="0" cellpadding="4" cellspacing="2" class="list small">
 <tr class="menu" align="center">
+    <td width="4%">delete</td>
     <td width="4%">sourceid</td>
     <td width="5%">channum</td>
     <td width="12%">callsign</td>
@@ -27,16 +28,17 @@
     <td width="5%">freqid</td>
     <td width="5%">finetune</td>
     <td width="5%">videofilters</td>
-    <td width="8%">brightness</td>
-    <td width="8%">contrast</td>
-    <td width="8%">colour</td>
-    <td width="8%">hue</td>
+    <td width="7%">brightness</td>
+    <td width="7%">contrast</td>
+    <td width="7%">colour</td>
+    <td width="7%">hue</td>
     <td width="5%">recpriority</td>
     <td width="5%">commfree</td>
     <td width="5%">visible</td>
 </tr><?php
         foreach ($Channels as $channel) {
 ?><tr class="settings" align="center">
+    <td><input type="checkbox" name="delete_<?php echo $channel['chanid']?>" id="delete_<?php echo $channel['chanid']?>" value="true"></td>
     <td><?php echo htmlentities($channel['sourceid'])?></td>
     <td><input type="text" size="3" name="channum_<?php echo $channel['chanid']?>" id="channum_<?php echo $channel['chanid']?>" value="<?php echo htmlentities($channel['channum'])?>"></td>
     <td><input type="text" size="15" name="callsign_<?php echo $channel['chanid']?>" id="callsign_<?php echo $channel['chanid']?>" value="<?php echo htmlentities($channel['callsign'])?>"></td>