foltia:放映予定

209912342353 )){ $now = date("YmdHi"); } function printtitle(){ print " "; //ディスク空き容量によって背景色表示変更 warndiskfreearea(); print "foltia:放映予定 "; }//end function printtitle() //同一番組他局検索 $query = " SELECT foltia_program .tid, foltia_program .title, foltia_subtitle.countno, foltia_subtitle.subtitle, foltia_subtitle.startdatetime , foltia_subtitle.lengthmin , foltia_tvrecord.bitrate , foltia_subtitle.pid FROM foltia_subtitle , foltia_program ,foltia_tvrecord WHERE foltia_tvrecord.tid = foltia_program.tid AND foltia_program.tid = foltia_subtitle.tid AND foltia_subtitle.enddatetime >= ? ORDER BY \"startdatetime\" ASC LIMIT 1000 "; // $reservedrssametid = m_query($con, $query, "DBクエリに失敗しました"); $reservedrssametid = sql_query($con, $query, "DBクエリに失敗しました",array($now)); $rowdata = $reservedrssametid->fetch(); if ($rowdata) { do { $reservedpidsametid[] = $rowdata[7]; } while ($rowdata = $reservedrssametid->fetch()); $rowdata = ""; }else{ $reservedpidsametid = array(); }//end if $reservedrssametid->closeCursor(); //録画番組検索 $query = " SELECT foltia_program.tid, stationname, foltia_program.title, foltia_subtitle.countno, foltia_subtitle.subtitle, foltia_subtitle.startdatetime as x, foltia_subtitle.lengthmin, foltia_tvrecord.bitrate, foltia_subtitle.pid FROM foltia_subtitle , foltia_program ,foltia_station ,foltia_tvrecord WHERE foltia_tvrecord.tid = foltia_program.tid AND foltia_tvrecord.stationid = foltia_station .stationid AND foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid AND foltia_subtitle.enddatetime >= '$now' UNION SELECT foltia_program.tid, stationname, foltia_program.title, foltia_subtitle.countno, foltia_subtitle.subtitle, foltia_subtitle.startdatetime, foltia_subtitle.lengthmin, foltia_tvrecord.bitrate, foltia_subtitle.pid FROM foltia_tvrecord LEFT OUTER JOIN foltia_subtitle on (foltia_tvrecord.tid = foltia_subtitle.tid ) LEFT OUTER JOIN foltia_program on (foltia_tvrecord.tid = foltia_program.tid ) LEFT OUTER JOIN foltia_station on (foltia_subtitle.stationid = foltia_station.stationid ) WHERE foltia_tvrecord.stationid = 0 AND foltia_subtitle.enddatetime >= '$now' ORDER BY x ASC LIMIT 1000 "; //$reservedrs = m_query($con, $query, "DBクエリに失敗しました"); $query = " SELECT foltia_program.tid, stationname, foltia_program.title, foltia_subtitle.countno, foltia_subtitle.subtitle, foltia_subtitle.startdatetime as x, foltia_subtitle.lengthmin, foltia_tvrecord.bitrate, foltia_subtitle.pid FROM foltia_subtitle , foltia_program ,foltia_station ,foltia_tvrecord WHERE foltia_tvrecord.tid = foltia_program.tid AND foltia_tvrecord.stationid = foltia_station .stationid AND foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid AND foltia_subtitle.enddatetime >= ? UNION SELECT foltia_program.tid, stationname, foltia_program.title, foltia_subtitle.countno, foltia_subtitle.subtitle, foltia_subtitle.startdatetime, foltia_subtitle.lengthmin, foltia_tvrecord.bitrate, foltia_subtitle.pid FROM foltia_tvrecord LEFT OUTER JOIN foltia_subtitle on (foltia_tvrecord.tid = foltia_subtitle.tid ) LEFT OUTER JOIN foltia_program on (foltia_tvrecord.tid = foltia_program.tid ) LEFT OUTER JOIN foltia_station on (foltia_subtitle.stationid = foltia_station.stationid ) WHERE foltia_tvrecord.stationid = 0 AND foltia_subtitle.enddatetime >= ? ORDER BY x ASC LIMIT 1000 "; $reservedrs = sql_query($con, $query, "DBクエリに失敗しました",array($now,$now)); $rowdata = $reservedrs->fetch(); if ($rowdata) { do { $reservedpid[] = $rowdata[8]; } while ($rowdata = $reservedrs->fetch()); }else{ $reservedpid = array(); }//end if $mode = getgetform(mode); if ($mode == "new"){ //新番組表示モード $query = " SELECT foltia_program.tid, stationname, foltia_program.title, foltia_subtitle.countno, foltia_subtitle.subtitle, foltia_subtitle.startdatetime, foltia_subtitle.lengthmin, foltia_subtitle.pid, foltia_subtitle.startoffset FROM foltia_subtitle , foltia_program ,foltia_station 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 LIMIT 1000 "; $query = " SELECT foltia_program.tid, stationname, foltia_program.title, foltia_subtitle.countno, foltia_subtitle.subtitle, foltia_subtitle.startdatetime, foltia_subtitle.lengthmin, foltia_subtitle.pid, foltia_subtitle.startoffset FROM foltia_subtitle , foltia_program ,foltia_station WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid AND foltia_subtitle.enddatetime >= ? AND foltia_subtitle.countno = '1' ORDER BY foltia_subtitle.startdatetime ASC LIMIT 1000 "; }else{ $query = " SELECT foltia_program.tid, stationname, foltia_program.title, foltia_subtitle.countno, foltia_subtitle.subtitle, foltia_subtitle.startdatetime, foltia_subtitle.lengthmin, foltia_subtitle.pid, foltia_subtitle.startoffset FROM foltia_subtitle , foltia_program ,foltia_station 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 LIMIT 1000 "; $query = " SELECT foltia_program.tid, stationname, foltia_program.title, foltia_subtitle.countno, foltia_subtitle.subtitle, foltia_subtitle.startdatetime, foltia_subtitle.lengthmin, foltia_subtitle.pid, foltia_subtitle.startoffset FROM foltia_subtitle , foltia_program ,foltia_station WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid AND foltia_subtitle.enddatetime >= ? ORDER BY foltia_subtitle.startdatetime ASC LIMIT 1000 "; }//end if //$rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました",array($now)); $rowdata = $rs->fetch(); if (! $rowdata) { header("Status: 404 Not Found",TRUE,404); printtitle(); print "

\n"; printhtmlpageheader(); print "

\n"; die_exit("番組データがありません
"); }//endif printtitle(); ?>

放映番組リストを表示します。

columnCount(); ?> \n"); // TID print "\n"; // 放映局 echo("\n"); // タイトル print "\n"; // 話数 echo("\n"); // サブタイ if ($pid > 0 ){ print "\n"; }else{ print "\n"; } // 開始時刻(ズレ) echo("\n"); // 総尺 echo("\n"); echo("\n"); } while ($rowdata = $rs->fetch()); ?>

TID	放映局	タイトル	話数	サブタイトル	開始時刻(ズレ)	総尺
"; if ($tid == 0 ){ print "$tid"; }else{ print "$tid"; } print "	".htmlspecialchars($rowdata[1])."	"; if ($tid == 0 ){ print "$title"; }else{ print "$title"; } print "	".htmlspecialchars($rowdata[3])."	$subtitle	$subtitle	".htmlspecialchars(foldate2print($rowdata[5]))." (".htmlspecialchars($rowdata[8]).")	".htmlspecialchars($rowdata[6])."