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)) ); } $group->categoryLeaf = $menu;