Upcoming Schedule | Past Streaming
include "common.php"; /*if (!$_SESSION['logged'] ){ header("location: login.php?require=true"); exit; }*/ ?>$date_set = date("Y-m-d 00:00:00"); $sql = "SELECT * FROM channel_schedules t1 INNER JOIN channel_sched_reservations t2 ON t1.channel_sched_reservation_id = t2.channel_sched_reservation_id WHERE ( (( t1.status = 2 OR t1.status = -1 OR t1.status = 0 ) OR t1.main_sched = 0) AND t1.main_sched = 0) AND t1.canalavist = 'T' AND t1.date_start > '$date_set' ORDER by t1.date_start, t1.date_end "; //echo $sql; $res = mysql_query($sql) or die(mysql_error()); if ( mysql_num_rows ($res) == 0 ){ ?>
No upcoming event
} while ($rows = mysql_fetch_assoc($res)){ $style =""; $text = ""; $b = false; /*if ( $rows['status'] == -1 || $rows['status'] == 2 ){ //$style="border-style:solid;border-color:green;width:770"; //$text = "Broadcasting...
";
//$b = true;
} */
//get if there are subschedules that aren't broadcasted
$sql = "SELECT * FROM channel_schedules WHERE main_sched = '" . $rows['channel_schedule_id'] ."' AND (status = 2 OR status = -1 OR status = 0) AND canalavist ='T' ";
$res3 = mysql_query($sql) or die(mysql_error());
if ( mysql_num_rows($res3) > 0 OR ($rows['status'] == 2 OR $rows['status'] == -1 OR $rows['status'] == 9 OR $rows['status'] == 0) OR 1 == 1) {
//get sub schedules
$sql = "SELECT * FROM channel_schedules WHERE main_sched = '" . $rows['channel_schedule_id'] ."'";
$res2 = mysql_query($sql) or die(mysql_error());
?>
![]() |
|
|

