}else{ //build category from available groups $group = new category( array(XmlEmitter::ATR.'title'=>'Group' , XmlEmitter::ATR.'description'=>'Select a Group' , XmlEmitter::ATR.'sd_img'=>"$WebServer/$MythRokuDir/images/tab-detach.png" , XmlEmitter::ATR.'hd_img'=>"$WebServer/$MythRokuDir/images/tab-detach.png" , 'categoryLeaf'=>array() ) ); $menu = array(); $results = array(); $rec_cat = Recorded::find_by_sql( "select distinct playgroup from recorded where basename like '%.mp4'" ); foreach ( $rec_cat as $value ) { $results[] = ucwords(str_replace('-', ' ', $value->playgroup)); } $vid_genre = VideoCategory::find_by_sql( 'select distinct vc.category from videocategory vc join videometadata v on v.category = vc.intid' ); foreach ( $vid_genre as $value ) { $results[] = ucwords(str_replace('-', ' ', $value->category)); } asort($results); $results = array_unique($results); foreach ( $results as $value ) { $parms = array('Group'=>rawurlencode($value)); $menu[] = new categoryLeaf( array(XmlEmitter::ATR.'title'=>$value , XmlEmitter::ATR.'feed'=>"$WebServer/$MythRokuDir/mythtv_group_xml.php?".http_build_query($parms))
}else{ // build category from available genres $genre = new category( array(XmlEmitter::ATR.'title'=>'Genre' , XmlEmitter::ATR.'description'=>'Select a Genre' , XmlEmitter::ATR.'sd_img'=>"$WebServer/$MythRokuDir/images/bookmark-5.png" , XmlEmitter::ATR.'hd_img'=>"$WebServer/$MythRokuDir/images/bookmark-5.png" , 'categoryLeaf'=>array() ) ); $menu = array(); $results = array(); $rec_cat = Recorded::find_by_sql( "select distinct category from recorded where basename like '%.mp4'" ); foreach ( $rec_cat as $value ) { $results[] = ucwords(str_replace('-', ' ', $value->category)); } $vid_genre = VideoMetadata::find_by_sql( "select (case when g.genre is null then 'Default' else g.genre end) as genre from videometadata v left join videometadatagenre a on a.idvideo = v.intid left join videogenre g on g.intid = a.idgenre"); foreach ( $vid_genre as $value ) { $results[] = ucwords(str_replace('-', ' ', $value->genre)); } asort($results); $results = array_unique($results); foreach ( $results as $value ) { $parms = array('Genre'=>rawurlencode($value)); $menu[] = new categoryLeaf( array(XmlEmitter::ATR.'title'=>$value , XmlEmitter::ATR.'feed'=>"$WebServer/$MythRokuDir/mythtv_genre_xml.php?".http_build_query($parms))