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\" LIKE 'M%%' AND foltia_program.tid = foltia_subtitle.tid AND foltia_program.tid = $tid ORDER BY \"enddatetime\" DESC limit $max offset 0 "; $titlequery = " SELECT foltia_program.tid,foltia_program.title FROM foltia_program WHERE foltia_program.tid = ? "; // $titlers = m_query($con, $query, "DBクエリに失敗しました"); $titlers = sql_query($con, $query, "DBクエリに失敗しました",array($tid)); $rowdata = $titlers->fetch(); $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\" LIKE 'M%%' AND foltia_program.tid = foltia_subtitle.tid ORDER BY \"enddatetime\" DESC offset 0 limit ? "; $rsstitle = "新規録画"; }//if $header = " DCC-JPL Japan/foltia project http://www.dcc-jpl.com/soft/foltia/ フォルティアが未読処理をお助けしちゃいます foltia video podcast :$rsstitle:Folcast フォルティアが未読処理をお助けしちゃいます ja foltia $rsstitle:Folcast foltia@dcc-jpl.com Technology "; $header = mb_convert_encoding($header,"UTF-8", "EUC-JP"); print $header; // $rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました",array($max)); $rowdata = $rs->fetch(); if (! $rowdata) { //die_exit("No items"); }else{ do { //$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"; if (file_exists("$recfolderpath/$tid.localized/mp4/$mp4filename")) { $mp4filestat = stat("$recfolderpath/$tid.localized/mp4/$mp4filename"); $mp4filesize = $mp4filestat[7]; } else { $mp4filesize = 0; } 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 ; } while ($rowdata = $rs->fetch()); //do }//if ?>