チェンジセット 83: trunk/install/php/index.php
- コミット日時:
- 2008/12/30 22:12:46 (16 年前)
- ファイル:
凡例:
- 変更無し
- 追加
- 削除
- 更新
- コピー
- 移動
trunk/install/php/index.php
r70 r83 13 13 オプション 14 14 mode:"new"を指定すると、新番組(第1話)のみの表示となる。 15 now:YmdHi形式で日付を指定するとその日からの番組表が表示される。 15 16 16 17 DCC-JPL Japan/foltia project … … 32 33 }//end if login 33 34 34 $now = date("YmdHi"); 35 35 $now = getgetnumform(date); 36 if(($now < 200001010000 ) || ($now > 209912342353 )){ 37 $now = date("YmdHi"); 38 } 36 39 function printtitle(){ 37 40 … … 64 67 WHERE foltia_tvrecord.tid = foltia_program.tid 65 68 AND foltia_program.tid = foltia_subtitle.tid 66 AND foltia_subtitle.enddatetime >= '$now' 67 ORDER BY \"startdatetime\" ASC 69 AND foltia_subtitle.enddatetime >= '$now' 70 ORDER BY \"startdatetime\" ASC 71 LIMIT 1000 68 72 "; 69 73 $reservedrssametid = m_query($con, $query, "DBクエリに失敗しました"); … … 112 116 LEFT OUTER JOIN foltia_station on (foltia_subtitle.stationid = foltia_station.stationid ) 113 117 WHERE foltia_tvrecord.stationid = 0 AND 114 foltia_subtitle.enddatetime >= '$now' ORDER BY \"startdatetime\" ASC 118 foltia_subtitle.enddatetime >= '$now' ORDER BY \"startdatetime\" ASC 119 LIMIT 1000 115 120 "; 116 121 … … 145 150 WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid 146 151 AND foltia_subtitle.enddatetime >= '$now' AND foltia_subtitle.countno = '1' 147 ORDER BY foltia_subtitle.startdatetime ASC 152 ORDER BY foltia_subtitle.startdatetime ASC 153 LIMIT 1000 148 154 "; 149 155 $rs = m_query($con, $query, "DBクエリに失敗しました"); … … 166 172 WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid 167 173 AND foltia_subtitle.enddatetime >= '$now' 168 ORDER BY foltia_subtitle.startdatetime ASC 174 ORDER BY foltia_subtitle.startdatetime ASC 175 LIMIT 1000 169 176 "; 170 177 $rs = m_query($con, $query, "DBクエリに失敗しました");
