[mythtv] [PATCH] MythWeb

[Jeff Nuckles]

This is the first patch I've ever attempted, so i hope
ive done this correctly.

The patch changes the search results page and the
recorded page so that they display episode titles. It
also modifies the "Return To Listings" link on the
recording settings page so that it takes you back to
the listings at the day and time of the program you
were recording and not the current day and time. Much
more convenient for recording thing in sequence and
you can still always use the "listings" link at the
top if you really need to go back to the current day
and time.


Index: recorded.php
===================================================================
RCS file: /var/lib/cvs/mythweb/recorded.php,v
retrieving revision 1.4
diff -c -r1.4 recorded.php
*** recorded.php	12 Apr 2003 14:55:54 -0000	1.4
--- recorded.php	2 May 2003 19:36:57 -0000
***************
*** 66,72 ****
         $prog_length[$t] = ($prog_end - $prog_begin);
 // Get the difference and dump results in array
         print "<TD BGCOLOR=\"$list_fg_colour\">" .
my_time($prog_length[$t]) . "</TD>";
  
!        print "<TD BGCOLOR=\"$list_fg_colour\">" .
$recs[$t][2]  . "</TD>";
         print "<TD BGCOLOR=\"$list_fg_colour\">" .
getLargeFiles($recs[$t][9],$recs[$t][10]) ."</TD>";
         print "<TD><input type=\"submit\"
name=\"deletebutton\" value=\"Delete\"></TD></form>";
         print "</TR>\n";
--- 66,73 ----
         $prog_length[$t] = ($prog_end - $prog_begin);
 // Get the difference and dump results in array
         print "<TD BGCOLOR=\"$list_fg_colour\">" .
my_time($prog_length[$t]) . "</TD>";
  
+        print "<TD BGCOLOR=\"$list_fg_colour\"><B>" .
$recs[$t][1] . "</B><BR>";
+        print $recs[$t][2]  . "</TD>";
         print "<TD BGCOLOR=\"$list_fg_colour\">" .
getLargeFiles($recs[$t][9],$recs[$t][10]) ."</TD>";
         print "<TD><input type=\"submit\"
name=\"deletebutton\" value=\"Delete\"></TD></form>";
         print "</TR>\n";
Index: search.php
===================================================================
RCS file: /var/lib/cvs/mythweb/search.php,v
retrieving revision 1.7
diff -c -r1.7 search.php
*** search.php	30 Mar 2003 19:34:08 -0000	1.7
--- search.php	2 May 2003 19:36:57 -0000
***************
*** 157,163 ****
  if(strlen($theQuery) > 0)
  {
  	$searchingSomething = FALSE;
! 	$queryString = "select channel.channum, starttime,
endtime, title, program.chanid, channel.callsign from
program,channel ";
  
  	//
  	//	Figure out which columns to query
--- 157,163 ----
  if(strlen($theQuery) > 0)
  {
  	$searchingSomething = FALSE;
! 	$queryString = "select channel.channum, starttime,
endtime, title, program.chanid, channel.callsign,
program.subtitle from program,channel ";
  
  	//
  	//	Figure out which columns to query
***************
*** 271,276 ****
--- 271,279 ----
  			print("<TD BGCOLOR=\"$list_fg_colour\">");
  			print("Program");
  			print("</TD>");
+ 			print("<TD BGCOLOR=\"$list_fg_colour\">");
+ 			print("Episode Title");
+ 			print("</TD>");
  			print("</TR>");
  			while($searchRow = mysql_fetch_row($searchQuery))
  			{
***************
*** 293,298 ****
--- 296,305 ----
  
  				print("<TD BGCOLOR=\"$list_fg_colour\">");
  				print("<A
HREF=\"main.php?mode=single&channel=$searchRow[4]&starttime=$searchRow[1]&endtime=$searchRow[2]&refoffset=0\">$searchRow[3]</A>");
+ 				print("</TD>");
+ 
+ 				print("<TD BGCOLOR=\"$list_fg_colour\">");
+ 				print($searchRow[6]);
  				print("</TD>");
  
  				print("</TR>");
Index: single.php
===================================================================
RCS file: /var/lib/cvs/mythweb/single.php,v
retrieving revision 1.8
diff -c -r1.8 single.php
*** single.php	30 Mar 2003 19:34:08 -0000	1.8
--- single.php	2 May 2003 19:36:58 -0000
***************
*** 200,205 ****
--- 200,206 ----
  	print("<CENTER>");
  	print("<FORM ACTION=\"main.php\" METHOD=\"GET\">");
  	print("<INPUT TYPE=\"HIDDEN\" NAME=\"mode\"
VALUE=\"listings\">");
+ 	print("<INPUT TYPE=\"HIDDEN\" NAME=\"date\"
VALUE=\"". $theStartTime ."\">");
  	print("<INPUT TYPE=\"HIDDEN\" NAME=\"timeoffset\"
VALUE=\"$theRefOffset\">");
  	print("<INPUT TYPE=\"SUBMIT\" NAME=\"back\"
VALUE=\"Return To Listings\">");
  	print("</CENTER>");


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com