Index: trunk/install/php/index.php =================================================================== --- trunk/install/php/index.php (リビジョン 70) +++ trunk/install/php/index.php (リビジョン 83) @@ -13,4 +13,5 @@ オプション mode:"new"を指定すると、新番組(第1話)のみの表示となる。 +now:YmdHi形式で日付を指定するとその日からの番組表が表示される。 DCC-JPL Japan/foltia project @@ -32,6 +33,8 @@ }//end if login -$now = date("YmdHi"); - +$now = getgetnumform(date); +if(($now < 200001010000 ) || ($now > 209912342353 )){ + $now = date("YmdHi"); +} function printtitle(){ @@ -64,6 +67,7 @@ WHERE foltia_tvrecord.tid = foltia_program.tid AND foltia_program.tid = foltia_subtitle.tid -AND foltia_subtitle.enddatetime >= '$now' - ORDER BY \"startdatetime\" ASC +AND foltia_subtitle.enddatetime >= '$now' +ORDER BY \"startdatetime\" ASC +LIMIT 1000 "; $reservedrssametid = m_query($con, $query, "DBクエリに失敗しました"); @@ -112,5 +116,6 @@ LEFT OUTER JOIN foltia_station on (foltia_subtitle.stationid = foltia_station.stationid ) WHERE foltia_tvrecord.stationid = 0 AND -foltia_subtitle.enddatetime >= '$now' ORDER BY \"startdatetime\" ASC +foltia_subtitle.enddatetime >= '$now' ORDER BY \"startdatetime\" ASC +LIMIT 1000 "; @@ -145,5 +150,6 @@ WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid AND foltia_subtitle.enddatetime >= '$now' AND foltia_subtitle.countno = '1' -ORDER BY foltia_subtitle.startdatetime ASC +ORDER BY foltia_subtitle.startdatetime ASC +LIMIT 1000 "; $rs = m_query($con, $query, "DBクエリに失敗しました"); @@ -166,5 +172,6 @@ WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid AND foltia_subtitle.enddatetime >= '$now' -ORDER BY foltia_subtitle.startdatetime ASC +ORDER BY foltia_subtitle.startdatetime ASC +LIMIT 1000 "; $rs = m_query($con, $query, "DBクエリに失敗しました");