//make a function to show the video
function showVideo($id,$series,$master) {
$date_untilQ = mysql_query("SELECT DATE_FORMAT(DATE_ADD(work_date,INTERVAL 30 DAY),'%m%/%d%/%Y') as diff_in_days FROM PP_seminars WHERE id='$id'");
$date_until = mysql_result($date_untilQ,0);
$info = mysql_fetch_assoc(mysql_query("SELECT title,is_free FROM PP_seminars WHERE id = '$id'"));
$title = $info['title'];
echo "
";
}
//is there a series?
if (count($series) > 1) {
echo "This video is part of a series. You can use the below dropdown to switch videos: ";
echo "
";
}
//show the video player
echo '
';
}
else {
echo "The video is not yet ready for viewing. Please check back later";
}
}
$seminar_id = $master = mysql_real_escape_string($_GET['id']);
//get the date of today in relation to the date of seminar
$date_diffQ = mysql_query("SELECT CEIL((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(work_date)) / 86400) as diff_in_days FROM PP_seminars WHERE id='$seminar_id';");
$date_diff = mysql_result($date_diffQ,0);
$series = Array();
//figure out if this is part of a series
$query = mysql_query("SELECT slave FROM PP_series JOIN PP_seminars ON PP_series.slave = PP_seminars.id WHERE master = '$seminar_id' ORDER BY work_date");
if (mysql_num_rows($query) > 0) {
while ($seriesID = mysql_fetch_assoc($query)) {
array_push($series,$seriesID['slave']);
}
}
if ( $date_diff < 10000) {
//get the slave id to display
$sid = mysql_real_escape_string($_GET['sid']);
//change id to slave id
if (strlen($sid) > 1) $seminar_id = $sid;
showVideo($seminar_id,$series,$master);
}
else {
$title = mysql_result(mysql_query("SELECT title FROM PP_seminars WHERE id = '$seminar_id'"),0);
echo "
Webinar Title: $title
";
echo "This video is no longer avaialble for viewing";
}
?>