0 ){ //件数指定があればなにもしない }else{ $max = 45; } $tid = getgetnumform(tid); if (($tid >= 0 ) && ($tid != "")){ $query = " SELECT foltia_program.tid,foltia_program.title, foltia_subtitle.countno , foltia_subtitle.subtitle , foltia_subtitle.startdatetime, foltia_subtitle.pspfilename,foltia_subtitle.lengthmin,foltia_subtitle.enddatetime FROM foltia_subtitle , foltia_program WHERE \"pspfilename\" ~~ 'M4V%%' AND foltia_program.tid = foltia_subtitle.tid AND foltia_program.tid = $tid ORDER BY \"enddatetime\" DESC offset 0 limit $max "; $titlequery = " SELECT foltia_program.tid,foltia_program.title FROM foltia_program WHERE foltia_program.tid = $tid "; $titlers = m_query($con, $query, "DBクエリに失敗しました"); $rowdata = pg_fetch_row($titlers, 0); $rsstitle = $rowdata[1]; }else{ $query = " SELECT foltia_program.tid,foltia_program.title, foltia_subtitle.countno , foltia_subtitle.subtitle , foltia_subtitle.startdatetime, foltia_subtitle.pspfilename,foltia_subtitle.lengthmin,foltia_subtitle.enddatetime FROM foltia_subtitle , foltia_program WHERE \"pspfilename\" ~~ 'M4V%%' AND foltia_program.tid = foltia_subtitle.tid ORDER BY \"enddatetime\" DESC offset 0 limit $max "; $rsstitle = "新規録画"; }//if $header = " DCC-JPL Japan/foltia project http://www.dcc-jpl.com/soft/foltia/ フォルティアが未読処理をお助けしちゃいます foltia video podcast :Folcast ($rsstitle) フォルティアが未読処理をお助けしちゃいます ja foltia Folcast ($rsstitle) foltia@dcc-jpl.com Technology "; $header = mb_convert_encoding($header,"UTF-8", "EUC-JP"); print $header; $rs = m_query($con, $query, "DBクエリに失敗しました"); $maxrows = pg_num_rows($rs); if ($maxrows == 0) { //die_exit("No items"); }else{ for ($row = 0; $row < $maxrows; $row++) { $rowdata = pg_fetch_row($rs, $row); //$title = mb_convert_encoding($rowdata[1],"UTF-8", "EUC-JP"); $tid = $rowdata[0]; $title = $rowdata[1]; $title = htmlspecialchars($title); $countno = $rowdata[2]; if ($countno > 0 ){ $countprint = "第".$countno."回"; }else{ $countprint=""; } $subtitle = $rowdata[3]; $subtitle = htmlspecialchars($subtitle); $onairdate = $rowdata[4]; $day = substr($onairdate,0,4)."/".substr($onairdate,4,2)."/".substr($onairdate,6,2); $time = substr($onairdate,8,2).":".substr($onairdate,10,2); $onairdate = "$day $time"; $starttimerfc822 = foldate2rfc822($rowdata[4]); $mp4filename = $rowdata[5]; $mp4uri = "http://". getserverfqdn() .$httpmediamappath ."/$tid.localized/mp4/$mp4filename"; $mp4thmname = $rowdata[5]; $mp4thmname = ereg_replace(".MP4", ".THM", $mp4thmname); $mp4thmnameuri = "http://". getserverfqdn() . $httpmediamappath ."/$tid.localized/mp4/$mp4thmname"; $mp4filestat = stat("$recfolderpath/$tid.localized/mp4/$mp4filename"); $mp4filesize = $mp4filestat[7]; if ($rowdata[0] == 0 ){//EPG録画 $showntitle = "$title $subtitle"; }else{ $showntitle = "$title $countprint"; } $item =" foltia $title $countprint $subtitle $title $countprint $subtitle $title $countprint $subtitle $mp4thmnameuri $starttimerfc822 no foltia,Folcast,DCC-JPL Japan,$title,$subtitle "; $item = mb_convert_encoding($item,"UTF-8", "EUC-JP"); print $item ; }//for }//if ?>