root/trunk/install/php/folcast.php

<?php
/*
 Anime recording system foltia
 http://www.dcc-jpl.com/soft/foltia/

folcast.php

目的
foltia video podcast(folcast)用RSSを出力します。

オプション
tid:タイトルID
　省略時は新規録画全部
max:表示上限
　省略時は45件

 DCC-JPL Japan/foltia project

*/

header('Content-Type: application/rss+xml');


  include("./foltialib.php");
$con = m_connect();

$now = date("YmdHi");   
$nowrfc822 =  date("r");

$max = getgetnumform(max);

if ($max > 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\" ~~ 'M%%'  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\" ~~ 'M%%'  AND foltia_program.tid = foltia_subtitle.tid ORDER BY \"enddatetime\" DESC 
offset 0 limit  $max 
    ";
    $rsstitle = "新規録画";
}//if

$header = "<?xml version=\"1.0\" encoding=\"UTF-8\"?> 
<rss xmlns:itunes=\"http://www.itunes.com/DTDs/Podcast-1.0.dtd\" version=\"2.0\"> 
    <channel> 
        <title>Folcast ($rsstitle)</title> 
        <itunes:author>DCC-JPL Japan/foltia project</itunes:author> 
        <link>http://www.dcc-jpl.com/soft/foltia/</link> 
        <description>フォルティアが未読処理をお助けしちゃいます</description> 
        <itunes:subtitle>foltia video podcast :Folcast ($rsstitle)</itunes:subtitle> 
        <itunes:summary>フォルティアが未読処理をお助けしちゃいます</itunes:summary> 
        <language>ja</language>
        <copyright>foltia</copyright> 
        <itunes:owner> 
            <itunes:name>Folcast ($rsstitle)</itunes:name> 
            <itunes:email>foltia@dcc-jpl.com</itunes:email> 
        </itunes:owner>          
        <category>Technology</category> 
        <itunes:category text=\"Technology\"></itunes:category> 

";
$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";

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 ="    <item> 
          <title>$showntitle</title> 
          <itunes:author>foltia</itunes:author> 
          <description>$title $countprint $subtitle</description> 
          <itunes:subtitle>$title $countprint $subtitle</itunes:subtitle> 
          <itunes:summary>$title $countprint $subtitle</itunes:summary> 
          <enclosure url=\"$mp4uri\" length=\"$mp4filesize\" type=\"video/mov\" /> 
          <guid isPermaLink=\"true\">$mp4thmnameuri</guid>
          <pubDate>$starttimerfc822</pubDate> 
          <itunes:explicit>no</itunes:explicit>
          <itunes:keywords>foltia,Folcast,DCC-JPL Japan,$title,$subtitle</itunes:keywords>  
          <itunes:image href=\"$mp4thmnameuri\" />
        </item> 
";

$item = mb_convert_encoding($item,"UTF-8", "EUC-JP");
print $item ;

}//for

}//if
        ?>
    
    </channel> 
</rss> 
tmlspecialchars(pg_field_name($rs, $col));
                    echo("<th abbr=\"$f_name\">$f_name</th>\n");
                }
            ?>
        </tr>
    </thead>
    <tbody>
        <?php
            /* テーブルのデータを出力 */
            for ($row = 0; $row < $maxrows; $row++) { /* 行に対応 */
                echo("<tr>\n");
                /* pg_fetch_row で一行取り出す */
                $rowdata = pg_fetch_row($rs, $row);
                /* １列目にリンクを張る */
                echo("<td><a href=\"edit.php?q_code=" .
                     urlencode($rowdata[0]) . "\">" .
                     htmlspecialchars($rowdata[1]) . "</a></td>\n");
                for ($col = 2; $col < $maxcols; $col++) { /* 列に対応 */
                    echo("<td>".htmlspecialchars($rowdata[$col])."<br></td>\n");
                }
                echo("</tr>\n");
            }
        ?>
    </tbody>
</table>
        <?php
        return $maxrows;
    }

    /* 指定したコードのデータを表示 */
    function m_viewdata($con, $code) {
        /* コードに該当するデータを検索 */
        $query = "
select p.code
      ,p.name
      ,p.email
      ,p.pseudonym
      ,s.name as job
      ,p.profile
      ,to_char(p.editdate, 'YYYY/MM/DD HH24:MI:SS') as editdate
  from inet_profile p left join inet_job s on p.job = s.code
 where p.code = $code";
        $rs = m_query($con, $query, "個人情報の取得に失敗しました。");
        if (pg_num_rows($rs) == 0) {
            echo("<p class=\"msg\">データが存在しません</p>\n");
            return FALSE;
        }
        
        /* フィールド数 */
        $maxcols = pg_num_fields($rs);
        /* 先頭行 */
        $rowdata = pg_fetch_row($rs, 0);
        ?>
<table class="view" summary="データベース上のデータを表示" border="1">
    <tr>
        <td class="name"><?= htmlspecialchars(pg_field_name($rs, 1)) ?></td>
        <td><a href="edit.php?q_code=<?= $rowdata[0] ?>"
             ><?= htmlspecialchars($rowdata[1]) ?></a></td>
    </tr>
    <?php for ($col = 2; $col < $maxcols; $col++) { ?>
    <tr>
        <td class="name"><?= htmlspecialchars(pg_field_name($rs, $col)) ?></td>
        <td><?= htmlspecialchars($rowdata[$col]) ?></td>
    </tr>
    <?php } ?>
</table>
        <?php
        /* クエリーを解放 */
        pg_free_result($rs);
        
        return TRUE;
    }
    

function printhtmlpageheader(){

$serveruri = getserveruri();

print "<p align='left'><font color='#494949'><A HREF = 'http://www.dcc-jpl.com/soft/foltia/' target=\"_blank\">foltia</A>　| <A HREF = './index.php'>放映予定</A> | <A HREF = './index.php?mode=new'>新番組</A> | <A HREF = './listreserve.php'>予約一覧</A> | <A HREF = './titlelist.php'>番組一覧</A> | <A HREF = './viewepg.php'>番組表</A> | 録画一覧(<A HREF = './showplaylist.php'>録画順</A>・<A HREF = './showplaylist.php?list=title'>番組順</A>・<A HREF = './showplaylist.php?list=raw'>全</A>) | <A HREF = './showlib.php'>録画ライブラリ</A> |  <A HREF = './folcast.php'>Folcast(RSS)</A>[<a href=\"itpc://$serveruri/folcast.php\">iTunesにFolcastを登録</a>] |</font></p>\n";

}


function renderepgstation($con,$stationname,$start){ //戻り値　なし　EPGの局表示

$now = date("YmdHi");
$today = date("Ymd");   
$tomorrow = date ("Ymd",mktime(0, 0, 0, date("m")  , date("d")+1, date("Y")));
//$today = "20051013";   
//$tomorrow = "20051014";
//$epgstart = $today . "2000";
$epgstart = $start ;
//$epgend = $tomorrow . "0400";
$epgend = calcendtime($start , (8*60));
$query = "
SELECT startdatetime , enddatetime , lengthmin , epgtitle , epgdesc , epgcategory  ,ontvchannel  ,epgid 
FROM foltia_epg 
WHERE foltia_epg.ontvchannel = '$stationname' AND 
enddatetime  > $epgstart  AND 
startdatetime  < $epgend  
ORDER BY foltia_epg.startdatetime  ASC
    ";
    $rs = m_query($con, $query, "DBクエリに失敗しました");
    $maxrows = pg_num_rows($rs);
if ($maxrows == 0) {
        print("番組データがありません<BR>");            
}else{
print "<table width=\"100%\"  border=\"0\">\n";
//print "<ul><!-- ($maxrows) $query -->\n";

for ($row = 0; $row < $maxrows; $row++) { 
     
$rowdata = pg_fetch_row($rs, $row);

$printstarttime = substr($rowdata[0],8,2) . ":" .  substr($rowdata[0],10,2);
$tdclass = "t".substr($rowdata[0],8,2) .  substr($rowdata[0],10,2);
$title = htmlspecialchars($rowdata[3]);
$title = z2h($title);
$desc = htmlspecialchars($rowdata[4]);
$desc = z2h($desc);
$height =  htmlspecialchars($rowdata[2]) * 3;
$epgid =  htmlspecialchars($rowdata[7]);

print"
      <tr>
        <td height = \"$height\" >$printstarttime  <A HREF=\"./reserveepg.php?epgid=$epgid\">$title</A> $desc <!-- $rowdata[0] - $rowdata[1] --></td>
      </tr>
";
/*print"<li style=\"height:" . $height ."px;\" class=\"$tdclass\">
$printstarttime  <A HREF=\"./reserveepg.php?epgid=$epgid\">$title</A> $desc($rowdata[0] - $rowdata[1])
</li>\n";
*/
}//for
//print "</ul>\n";
print "</table>\n";

}//if
}//end function

function calcendtime($start,$lengthmin){//戻り値　終了時刻(Ex:200510170130) 
$startyear =   substr($start,0,4);
$startmonth =   substr($start,4,2);
$startday =   substr($start,6,2);
$starthour =   substr($start,8,2);
$startmin =   substr($start,10,2);
//int mktime ( [int hour [, int minute [, int second [, int month [, int day [, int year [, int is_dst]]]]]]] )
$endtime = date ("YmdHi",mktime($starthour  , $startmin + $lengthmin , 0, $startmonth  , $startday, $startyear));

return ($endtime );
}//end function


function z2h($string){ //戻り値　半角化した文字
    $stringh = mb_convert_kana($string, "a", "EUC-JP");
 return ($stringh );
}

function foldate2rfc822($start){//戻り値　RFC822スタイルの時刻表記
    $startyear =   substr($start,0,4);
    $startmonth =   substr($start,4,2);
    $startday =   substr($start,6,2);
    $starthour =   substr($start,8,2);
    $startmin =   substr($start,10,2);

    $rfc822 = date ("r",mktime($starthour  , $startmin , 0, $startmonth  , $startday, $startyear));
    
    return ($rfc822);
}//end sub

function foldate2print($start){//戻り値　日本語風時刻表記
    $startyear =   substr($start,0,4);
    $startmonth =   substr($start,4,2);
    $startday =   substr($start,6,2);
    $starthour =   substr($start,8,2);
    $startmin =   substr($start,10,2);

    $printabledate = date ("Y/m/d H:i",mktime($starthour  , $startmin , 0, $startmonth  , $startday, $startyear));    
    return ($printabledate);
}//end sub

function getserveruri(){//戻り値　サーバアドレス Ex.www.dcc-jpl.com:8800/soft/foltia/

//リンクURI組み立て
$sv6 = $_SERVER['SCRIPT_NAME'];///dameNews/sarasorjyu/archives.php
$sv8 = $_SERVER['SERVER_NAME'];//sync.dcc-jpl.com
$sv9 = $_SERVER['SERVER_PORT'];
if ($sv9 == 80){
    $port = "";
}else{
    $port = ":$sv9";
}
$a = split("/", $sv6);
array_pop($a);

$scriptpath = implode("/", $a);

$serveruri = "$sv8$port$scriptpath";
return ($serveruri );
}//end sub


function getserverfqdn(){//戻り値　サーバアドレス Ex.www.dcc-jpl.com:8800

//リンクURI組み立て
$sv6 = $_SERVER['SCRIPT_NAME'];///dameNews/sarasorjyu/archives.php
$sv8 = $_SERVER['SERVER_NAME'];//sync.dcc-jpl.com
$sv9 = $_SERVER['SERVER_PORT'];
if ($sv9 == 80){
    $port = "";
}else{
    $port = ":$sv9";
}
$a = split("/", $sv6);
array_pop($a);

$scriptpath = implode("/", $a);

$serveruri = "$sv8$port";
return ($serveruri );
}//end sub


function printdiskusage(){//戻り値　なし

global $recfolderpath,$recfolderpath;

    exec ( "df -h  $recfolderpath | grep $recfolderpath", $hdfreearea);
    $freearea = preg_split ("/[\s,]+/", $hdfreearea[0]);

    exec ( "ps ax | grep ffmpeg", $encoding);
    exec ( "ps ax | grep faac", $processlock);

print "
<div style=\"width:100%;border:1px solid black;text-align:left;\"><span style=\"float:right;\">$freearea[3]</span>
<div style=\"width:$freearea[4];border:1px solid black;background:white;\">$freearea[2]/$freearea[1]($freearea[4])</div>
</div>
";

//    print "$freearea[1]<br>$freearea[2]<br>$freearea[3]<br>$freearea[4]<br>$hdfreearea[0]<br>$encoding[0]<br>$processlock[0]</p>\n";
    print "$encoding[0]<br>$processlock[0]</p>\n";

/*
<div style="width:100%;border:1px solid black;text-align:left;"><span style="float:right;">170GB</span>
<div style="width:86%;border:1px solid black;background:white;">1.1TB/1.3TB(87%)</div>
</div>
*/

}//end sub










































?>