public function __construct($xml){
if(useUTC())
$this->StartTime=gmdate('Y-m-d H:i:s');
else
$this->StartTime=date('Y-m-d H:i:s');
$this->EndTime=$this->StartTime;
$this->SubTitle='Information';
$this->ProgramId=$this->SubTitle;
$this->Category=$this->SubTitle;
parent::__construct($xml);
}
<?php
require_once 'settings.php';
include_once 'player_feed.php';
//const _DEBUG = 'true';
if(isset($_GET['New'])) {
$select = rawurldecode($_GET['New']);
//build feed for this specific genre
error_log("selecting New: $select", 0);
$interval = '1 week';
if(useUTC())
$intervalQry = "program.starttime BETWEEN utc_timestamp() AND adddate(utc_timestamp(), interval $interval) ";
else
$intervalQry = "program.starttime BETWEEN now() AND adddate(now(), interval $interval) ";
$conditions = array('conditions'=>"program.manualid=0 AND $intervalQry");
switch ( $select ) {
case 'Series': $conditions['conditions'].= " AND program.category_type='series' AND( (program.programid like '%001' AND program.previouslyshown=FALSE AND program.first=TRUE) OR (program.subtitle = 'Pilot' and program.first=TRUE) )"; break;
case 'Specials': $conditions['conditions'].= " AND program.category='Special' AND program.originalairdate> adddate(now(), interval -1 month) AND program.previouslyshown=FALSE AND( program.first=true OR program.last=true )"; break;
case 'Movies': $conditions['conditions'].= " AND program.category_type='movie' AND program.airdate>=year(now())-2 AND( program.first=true OR program.last=true )"; break;
case 'Sports': $conditions['conditions'].= " AND program.category LIKE '$NewSportsQueryType' AND program.PreviouslyShown=false AND( program.first=true OR program.last=true ) AND( program.originalairdate is null OR program.originalairdate> adddate(now(), interval -1 day) )"; break;
default:
break;
}
$conditions['conditions'].= " AND program.chanid in (select chanid from channel where visible=TRUE)";
$conditions['conditions'].= " ORDER BY program.starttime";
$conditions['conditions'].= " LIMIT $NewShowsQueryLimit";
function convert_datetime($str) {
//convert date formatted string to unix timestamp
return strtotime( useUTC() ? "$str UTC" : $str);
}
