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

コミット日時:

2010/08/17 01:12:56 (14 年前)

コミッタ:

sorshi

ログメッセージ:

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

ファイル:

• trunk/install/php/folcast.php (更新) (3 diffs)
• trunk/install/php/viewepg.php (更新) (4 diffs)

trunk/install/php/folcast.php

@@ -52 +52 @@
-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   
-\"enddatetime\"
-limit  $max
-       
+enddatetime
+ limit ?
+
-
-$titlequery = "
@@ -63 +63 @@
-//      $titlers = m_query($con, $query, "DBクエリに失敗しました");
-        $titlers = sql_query($con, $query, "DBクエリに失敗しました",array($tid));
+//      $titlers = sql_query($con, $titlequery, "DBクエリに失敗しました",array($tid));
-        $rowdata = $titlers->fetch();
-        $rsstitle = $rowdata[1];
@@ -69 +70 @@
-$query = "
-SELECT  foltia_program.tid,foltia_program.title,
-\"enddatetime\"
-offset 0 limit  ?
+enddatetime
+limit  ? offset 0
-        ";
+
+
+
-        $rsstitle = "新規録画";
-}//if

trunk/install/php/viewepg.php

@@ -67 +67 @@
-
-$yesterday = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday -1 , $startyear));
+$dayyesterday = date ("m/d(D)",mktime($starthour , 0 , 0, $startmonth , $startday -1 , $startyear));
-$today0400 = date ("YmdHi",mktime(4 , 0 , 0, $startmonth , $startday  , $startyear));
+$today0800 = date ("YmdHi",mktime(8 , 0 , 0, $startmonth , $startday  , $startyear));
-$today1200 = date ("YmdHi",mktime(12 , 0 , 0, $startmonth , $startday , $startyear));
+$today1600 = date ("YmdHi",mktime(16 , 0 , 0, $startmonth , $startday , $startyear));
-$today2000 = date ("YmdHi",mktime(20 , 0 , 0, $startmonth , $startday , $startyear));
+$today2359 = date ("YmdHi",mktime(23 , 59 , 0, $startmonth , $startday , $startyear));
-$day1after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +1 , $startyear));
-
+(D)
-$day2after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +2 , $startyear));
-
+(D)
-$day3after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +3 , $startyear));
-
+(D)
-$day4after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +4 , $startyear));
-
+(D)
-$day5after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +5 , $startyear));
-
+(D)
-$day6after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +6 , $startyear));
-
+(D)
-$day7after = date ("YmdHi",mktime($starthour , 0 , 0, $startmonth , $startday +7 , $startyear));
-
+(D)
-
-
@@ -115 +119 @@
-
-
-前の日</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\">次の日
+$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(翌日)
-
-
@@ -127 +131 @@
-
-print " $page / $pages (放送局) ";
+for ($i=1;$i<=$pages;$i++){
+        print "<a href = \"./viewepg.php?p=$i&start=$start\">$i</a>・";
+}
+
-
-if ($page < $pages){
-        $nextpage = $page + 1;
-A
+a
-}
-}
@@ -158 +166 @@
-        SELECT ontvcode 
-        FROM foltia_station 
- 
+
-        ORDER BY stationid ASC , stationrecch 
-        LIMIT ? OFFSET ?