[mythtv] [PATCH] mythweb Profile Groups

[Jason Schloer]

This is just a quick patch to give the recording profiles more
meaningful names. It also weeds out the unused groups based on whether
they have a videocodec defined. Should be applied to the
program_details.php in the main web directory, not the themes. 

--- program_detail.php  25 Aug 2003 05:31:22 -0000      1.4
+++ program_detail.php  26 Sep 2003 14:55:49 -0000
@@ -70,7 +70,7 @@

 // Load the recording profiles
        $Profiles = array();
-       $profileresult = mysql_query("select id, name from
recordingprofiles");
+       $profileresult = mysql_query('SELECT recordingprofiles.id AS id,
concat( profilegroups.name,  \':\', recordingprofiles.name ) AS name
FROM recordingprofiles INNER  JOIN profilegroups ON
recordingprofiles.profilegroup = profilegroups.id WHERE NOT
isnull(recordingprofiles.videocodec)');
        while ($row = mysql_fetch_assoc($profileresult)){
                $Profiles[] = $row;
        }



Jason Schloer