if (isset($DERECORD)) { derecord($DERECORD); header("Location: index.php"); } /* Fetching the necessary info from the database and put them in 'unique' global vars (DB_NAME) */ if (isset($EDIT)) { $query = "SELECT *,DATE_FORMAT(start,\"%Y %m %d %H:%i\"), " . "DATE_FORMAT(stop,\"%Y %m %d %H:%i\") FROM program " . "WHERE pid='" . addslashes($EDIT) . "'"; $result = $sql->query($query); while ($blah = $sql->fetch_array($result)) { $DB_PID = $blah[0]; // PID is the program ID $DB_SID = $blah[1]; // SID is the station ID $DB_STATION = getstation($DB_SID); $DB_PNAME = $blah[2]; /* We'll have to split on a ' ' cause SQL gives us back %y %m %d %H:%i (year month day hour:minute) */ list($DB_STARTYEAR, $DB_STARTMONTH, $DB_STARTDAY, $DB_START) = split(" ", $blah[7]); list($DB_STOPYEAR, $DB_STOPMONTH, $DB_STOPDAY, $DB_STOP) = split(" ", $blah[8]); } // end looping through results } // end if isset EDIT if (isset($ADDSTART)) { $sql->query("UPDATE program SET start=start + INTERVAL 1 minute " . "WHERE pid='" . addslashes($ADDSTART) . "'"); header("Location: index.php"); exit; }
<?php // $Id: show.php,v 1.1 2002/02/09 17:45:19 waldb Exp $ // $Author: waldb $ include "lib/functions.php"; print_header_open(); $show_station = getstation($station); print_title("Program Listing for {$show_station}"); print_header_close(); if (isset($RECORD)) { if (isset($FLAG)) { record($RECORD, $FLAG); } else { record($RECORD, 0); // function in functions.php } } if (isset($FORCERECORD)) { record($FORCERECORD, 2); } if (isset($DERECORD)) { derecord($DERECORD); } ?> <center> <table border=1><tr bgcolor="#006666"><td><center> <font color="#FFFFFF">Program Listing for <?php //$station = getstation($station); if (!$station) {
if ($sql->results($result)) { ?> <table border=1><tr bgcolor="#006666"><td><center><font color="#FFFFFF">recorded programs</font></center></td></tr><tr bgcolor="#E0E0E0"><td> <table border=1 width=100%> <tr> <td>Station</td> <td>Program Name</td> <td>Start</td> <td>Stop</td> <td>Edit</td> </tr> <?php $query = "SELECT *,DATE_FORMAT(start,'%H:%i %d/%m'), " . "DATE_FORMAT(stop,'%H:%i %d/%m') FROM program " . "WHERE (flag='0' or flag='1' or flag='2' or flag='3') " . "AND record='1' ORDER BY start"; $result = $sql->query($query); while ($blah = $sql->fetch_array($result)) { $station = getstation($blah[1]); // We need a name not a number ;-) print "\n\t\t<tr><td>{$station}</td>\n\t\t \t<td>{$blah['2']}</td>\n\t <td>{$blah['7']}</td>\n\t\t\t<td>{$blah['8']}</td>"; # if ($blah[6] == 0) { print "\n\t\t\t\t<td>\n\t\t\t\t<a href=force.php?ADDSTART={$blah['0']}>+1 start</a>\n\t\t\t\t<a href=force.php?DELSTART={$blah['0']}>-1 start</a><br>\n\t\t\t\t<a href=force.php?ADDSTOP={$blah['0']}>+1 end</a>\n\t\t\t\t<a href=force.php?DELSTOP={$blah['0']}>-1 end</a>\n\t\t\t\t</td>\n\t\t\t\t<td><a href=force.php?EDIT={$blah['0']}>edit</a></td>\n\t\t\t\t<td><a href=force.php?DERECORD={$blah['0']}>delete</a></td>"; # } else { # print " # <td><a href=force.php?EDIT=$blah[0]>edit</a></td> # <td><a href=force.php?DELETE=$blah[0]>delete</a></td>"; # } print "</tr>"; } ?> </table> </table> <?php
function record($id, $flag) { global $sql; $result = $sql->query("SELECT start,stop FROM program " . "WHERE pid='" . addslashes($id) . "'"); while ($blah = $sql->fetch_array($result)) { $start = $blah["start"]; $stop = $blah["stop"]; } // end of grabbing start/stop $result = $sql->query("SELECT * FROM program WHERE record='1' " . "AND ((start <= '" . addslashes($start) . "' AND " . "'" . addslashes($start) . "' <= stop) OR " . "(start <= '" . addslashes($stop) . "' AND " . "'" . addslashes($stop) . "' <= stop))"); $num_rows = $sql->num_rows($result); if ($num_rows == 0) { $query = "UPDATE program SET record='1', flag='" . addslashes($flag) . "' " . "WHERE pid='" . addslashes($id) . "'"; $sql->query($query); } else { while ($blah = $sql->fetch_array($result)) { $station = getstation($blah[1]); print "<b>{$blah['2']} on {$station} @ {$blah['3']} is conflicting, not recorded.</b><br>"; } } // end if num_rows = 0 }