having category like '$select';
EOF;
//build feed for this specific group
error_log("selecting Group: $select", 0);
$conditions = array('conditions' => array('basename like ? AND playgroup like ?', '%.mp4', $select));
$rquery = array(
'select'=>'recorded.*
, ifnull(
nullif(recorded.originalairdate,0)
, makedate( (select airdate from recordedprogram where recordedprogram.chanid=recorded.chanid and recordedprogram.starttime=recorded.starttime),1 )
) as airdate'
);
$record = Recorded::all( array_merge($rquery, $conditions) );
error_log("COUNT of RECORDED: ".count($record), 0);
$video = VideoMetadata::find_by_sql( $SQL );
error_log("COUNT of VIDEOMETADATA: ".count($video), 0);
$items = array();
$shows = array_values(array_merge($record, $video));
foreach($shows as $item => $show ){
$items[] = new item($show);
}
//usort($items, 'items_title_date_compare');
usort($items, 'items_title_episode_compare');
if(count($items)){
$feed = new feed(
case 'Today': $interval = '-1 DAY';break;
case 'Week': $interval = '-7 DAY';break;
case 'Month': $interval = '-1 MONTH';break;
case 'Year': $interval = '-1 YEAR';break;
case 'All': $interval = '-100 YEAR';break;
default:
break;
}
if(useUTC())
$intervalQry = "starttime between adddate(utc_timestamp(), interval $interval) and utc_timestamp() ";
else
$intervalQry = "starttime between adddate(now(), interval $interval) and now() ";
$conditions = array('conditions' => array("basename like ? AND $intervalQry", '%.mp4'));
$record = Recorded::all( $conditions );
error_log("COUNT of RECORDED: ".count($record), 0);
$vselect = array('select' => '*, case releasedate when (releasedate is null) then insertdate else releasedate end as starttime');
$conditions = array('conditions' => array("filename like ? AND host > ? HAVING $intervalQry", '%.m%4%', ''));
$video = VideoMetadata::all( array_merge($vselect, $conditions) );
error_log("COUNT of VIDEOMETADATA: ".count($video), 0);
$items = array();
$shows = array_values(array_merge($record, $video));
usort($shows, 'shows_date_compare');
foreach($shows as $item => $show ){
$items[] = new item($show);
}
if(count($items)){
<?php
//get the local info from the settings file
require_once 'settings.php';
if (isset($_GET['basename']))
{
$basefname = $_GET['basename'];
$conditions = array('conditions' => array('basename = ? ', $basefname));
$recordings = Recorded::all($conditions);
if(count($recordings) != 1) {
error_log( "There are " . count($recordings) . " items with the basename: $basefname", 0 );
}else{
$recording = $recordings[0];
error_log( "here we delete $recording->basename from the database.", 0 );
$recording->delete();
$fname = $recording->storagegroups->dirname . strtok($recording->basename, ".");
foreach(glob($fname . "*") as $file){
error_log( "here we delete $file from the filesystem.", 0 );
unlink($file);
}
}
}else{
error_log("the 'basename' was not passed to this routine!", 0);
}
?>
