チェンジセット 111: trunk/install/php

差分発生行の前後
無視リスト:
コミット日時:
2010/08/17 01:12:56 (14 年前)
コミッタ:
sorshi
ログメッセージ:

・放送波からのEPG番組表取得に対応。
・foltia_epgテーブル構成変更
・folcast.phpがSQLiteでまったく動作していなかったのを修正

ファイル:

凡例:

変更無し
追加
削除
更新
コピー
移動
  • trunk/install/php/folcast.php

    r102 r111  
    5252SELECT  foltia_program.tid,foltia_program.title, 
    5353foltia_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    
    54 ORDER BY \"enddatetime\" DESC  
    55 limit  $max offset 0  
    56        "; 
     54ORDER BY enddatetime DESC  
     55 limit ? offset 0  
     56"; 
    5757 
    5858$titlequery = " 
     
    6363//      $titlers = m_query($con, $query, "DBクエリに失敗しました"); 
    6464        $titlers = sql_query($con, $query, "DBクエリに失敗しました",array($tid)); 
     65//      $titlers = sql_query($con, $titlequery, "DBクエリに失敗しました",array($tid)); 
    6566        $rowdata = $titlers->fetch(); 
    6667        $rsstitle = $rowdata[1]; 
     
    6970$query = " 
    7071SELECT  foltia_program.tid,foltia_program.title, 
    71 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  
    72 offset 0 limit  ?  
     72foltia_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  
     73limit  ? offset 0  
    7374        "; 
     75 
     76 
     77 
    7478        $rsstitle = "新規録画"; 
    7579}//if 
  • trunk/install/php/viewepg.php

    r94 r111  
    6767 
    6868$yesterday = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday -1 , $startyear)); 
     69$dayyesterday = date ("m/d(D)",mktime($starthour , 0 , 0, $startmonth , $startday -1 , $startyear)); 
    6970$today0400 = date ("YmdHi",mktime(4 , 0 , 0, $startmonth , $startday  , $startyear)); 
     71$today0800 = date ("YmdHi",mktime(8 , 0 , 0, $startmonth , $startday  , $startyear)); 
    7072$today1200 = date ("YmdHi",mktime(12 , 0 , 0, $startmonth , $startday , $startyear)); 
     73$today1600 = date ("YmdHi",mktime(16 , 0 , 0, $startmonth , $startday , $startyear)); 
    7174$today2000 = date ("YmdHi",mktime(20 , 0 , 0, $startmonth , $startday , $startyear)); 
     75$today2359 = date ("YmdHi",mktime(23 , 59 , 0, $startmonth , $startday , $startyear)); 
    7276$day1after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +1 , $startyear)); 
    73 $day1 = date ("m/d",mktime($starthour , 0 , 0, $startmonth , $startday +1 , $startyear)); 
     77$day1 = date ("m/d(D)",mktime($starthour , 0 , 0, $startmonth , $startday +1 , $startyear)); 
    7478$day2after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +2 , $startyear)); 
    75 $day2 = date ("m/d",mktime($starthour , 0 , 0, $startmonth , $startday +2 , $startyear)); 
     79$day2 = date ("m/d(D)",mktime($starthour , 0 , 0, $startmonth , $startday +2 , $startyear)); 
    7680$day3after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +3 , $startyear)); 
    77 $day3 = date ("m/d",mktime($starthour , 0 , 0, $startmonth , $startday +3 , $startyear)); 
     81$day3 = date ("m/d(D)",mktime($starthour , 0 , 0, $startmonth , $startday +3 , $startyear)); 
    7882$day4after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +4 , $startyear)); 
    79 $day4 = date ("m/d",mktime($starthour , 0 , 0, $startmonth , $startday +4 , $startyear)); 
     83$day4 = date ("m/d(D)",mktime($starthour , 0 , 0, $startmonth , $startday +4 , $startyear)); 
    8084$day5after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +5 , $startyear)); 
    81 $day5 = date ("m/d",mktime($starthour , 0 , 0, $startmonth , $startday +5 , $startyear)); 
     85$day5 = date ("m/d(D)",mktime($starthour , 0 , 0, $startmonth , $startday +5 , $startyear)); 
    8286$day6after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +6 , $startyear)); 
    83 $day6 = date ("m/d",mktime($starthour , 0 , 0, $startmonth , $startday +6 , $startyear)); 
     87$day6 = date ("m/d(D)",mktime($starthour , 0 , 0, $startmonth , $startday +6 , $startyear)); 
    8488$day7after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +7 , $startyear)); 
    85 $day7 = date ("m/d",mktime($starthour , 0 , 0, $startmonth , $startday +7 , $startyear)); 
     89$day7 = date ("m/d(D)",mktime($starthour , 0 , 0, $startmonth , $startday +7 , $startyear)); 
    8690 
    8791 
     
    115119 
    116120 
    117 print "←<A HREF=\"./viewepg.php?p=$page&start=$yesterday\">前の日</A> <A HREF=\"./viewepg.php\">現在</A> 当日(<A HREF=\"./viewepg.php?p=$page&start=$today0400\">4:00</A> <A HREF=\"./viewepg.php?p=$page&start=$today1200\">12:00</A> <A HREF=\"./viewepg.php?p=$page&start=$today2000\">20:00</A>) <A HREF=\"./viewepg.php?p=$page&start=$day1after\">次の日</A> <A HREF=\"./viewepg.php?p=$page&start=$day2after\">$day2</A> <A HREF=\"./viewepg.php?p=$page&start=$day3after\">$day3</A> <A HREF=\"./viewepg.php?p=$page&start=$day4after\">$day4</A> <A HREF=\"./viewepg.php?p=$page&start=$day5after\">$day5</A> <A HREF=\"./viewepg.php?p=$page&start=$day6after\">$day6</A> <A HREF=\"./viewepg.php?p=$page&start=$day7after\">$day7</A>→<BR>\n"; 
     121print "←<A HREF=\"./viewepg.php?p=$page&start=$yesterday\">$dayyesterday(前日)</A> <A HREF=\"./viewepg.php\">現在</A> 当日(<A HREF=\"./viewepg.php?p=$page&start=$today0400\">4:00</A> <A HREF=\"./viewepg.php?p=$page&start=$today0800\">8:00</A> <A HREF=\"./viewepg.php?p=$page&start=$today1200\">12:00</A> <A HREF=\"./viewepg.php?p=$page&start=$today1600\">16:00</A> <A HREF=\"./viewepg.php?p=$page&start=$today2000\">20:00</A> <A HREF=\"./viewepg.php?p=$page&start=$today2359\">24:00</A>) <A HREF=\"./viewepg.php?p=$page&start=$day1after\">$day1(翌日)</A> <A HREF=\"./viewepg.php?p=$page&start=$day2after\">$day2</A> <A HREF=\"./viewepg.php?p=$page&start=$day3after\">$day3</A> <A HREF=\"./viewepg.php?p=$page&start=$day4after\">$day4</A> <A HREF=\"./viewepg.php?p=$page&start=$day5after\">$day5</A> <A HREF=\"./viewepg.php?p=$page&start=$day6after\">$day6</A> <A HREF=\"./viewepg.php?p=$page&start=$day7after\">$day7</A>→<BR>\n"; 
    118122 
    119123 
     
    127131 
    128132print " $page / $pages (放送局) "; 
     133for ($i=1;$i<=$pages;$i++){ 
     134        print "<a href = \"./viewepg.php?p=$i&start=$start\">$i</a>・"; 
     135} 
     136 
    129137 
    130138if ($page < $pages){ 
    131139        $nextpage = $page + 1; 
    132         print "<a href = \"./viewepg.php?p=$nextpage&start=$start\">→</A>"; 
     140        print "<a href = \"./viewepg.php?p=$nextpage&start=$start\">→</a>"; 
    133141} 
    134142} 
     
    158166        SELECT ontvcode  
    159167        FROM foltia_station  
    160         WHERE \"ontvcode\" LIKE '%ontvjapan%'  
     168        WHERE \"ontvcode\" LIKE '%ontvjapan%'  
    161169        ORDER BY stationid ASC , stationrecch  
    162170        LIMIT ? OFFSET ? 
track feed