*/
include "./foltialib.php";
$con = m_connect();
if ($useenvironmentpolicy == 1) {
if (!isset($_SERVER['PHP_AUTH_USER'])) {
header("WWW-Authenticate: Basic realm=\"foltia\"");
header("HTTP/1.0 401 Unauthorized");
redirectlogin();
exit;
} else {
login($con, $_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW']);
}
}
//end if login
$pid = getgetnumform(p);
$file = getgetform(f);
if ($pid != "") {
$query = "\nSELECT \n title,\n countno,\n subtitle,\n foltia_subtitle.tid,\n PSPfilename \nFROM foltia_subtitle, foltia_program \nWHERE pid = ? AND foltia_subtitle.tid = foltia_program.tid";
$rs = sql_query($con, $query, "DBクエリに失敗しました", array($pid));
$rowdata = $rs->fetch();
//$title = htmlspecialchars(mb_convert_encoding($rowdata[0], "UTF-8"));
$title = htmlspecialchars($rowdata[0]);
if ($rowdata[1] == "") {
$countno = "";
} else {
$countno = "第" . htmlspecialchars($rowdata[1]) . "話";
}
//$subtitle = htmlspecialchars(mb_convert_encoding($rowdata[2], "UTF-8"));
$subtitle = htmlspecialchars($rowdata[2]);
$tid = htmlspecialchars($rowdata[3]);
$filename = htmlspecialchars($rowdata[4]);
}
//ereg
}
//foreach
print "\t</tbody>\n</table>\n</FORM>\n";
echo '<p align="left">';
echo '$datas=' . count($datas) . ' ';
echo '$nodata=' . count($nodata, COUNT_RECURSIVE) . ' ';
echo '$mp4_exists=' . count($mp4_exists) . '<br />';
echo '</p>';
page_display($list, $p, $p2, $lim, count($m2pfiles), "");
print "</body>\n</html>\n";
exit;
} else {
if ($list == 'mp4') {
$head = getgetform('head');
if (!$head) {
$head = 300;
}
exec("ls -1t {$recfolderpath}/*.localized/mp4/*.MP4", $mp4files);
$lim = $head;
page_display($list, $p, $p2, $lim, count($mp4files), "");
$mp4filesP = array_chunk($mp4files, $lim);
$datas = array();
$nodata = array();
$mp4_exists = array();
foreach ($mp4filesP[$p - 1] as $pathfName) {
//echo "<pre>$pathfName</pre>";
$fNametmp = explode('/', $pathfName);
$fName = array_pop($fNametmp);
if ($fName == '.' || $fName == '..') {
//end if login
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html lang="ja">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="Content-Style-Type" content="text/css">
<link rel="stylesheet" type="text/css" href="graytable.css">
<title>foltia:EPG予約:$epgid</title>
</head>
<body BGCOLOR="#ffffff" TEXT="#494949" LINK="#0047ff" VLINK="#000000" ALINK="#c6edff" >
<?php
printhtmlpageheader();
$word = getgetform('word');
$word = trim($word);
$nowdate = date('YmdHi');
$strdate = date('YmdHi', strtotime('-1 week'));
$enddate = date('YmdHi', strtotime('+1 week'));
if ($word != '') {
$numsql = 'count(*)';
$selsql = '*';
//$query = "
// SELECT
// %COL%
// FROM foltia_epg
// LEFT JOIN foltia_station ON foltia_epg.ontvchannel = foltia_station.ontvcode
// WHERE (startdatetime >= ?
// AND enddatetime <= ?)
// AND (startdatetime < enddatetime)
<p align="left">
<font color="#494949" size="6">
番組手動予約
</font>
</p>
<hr size="4">
<?php
//値取得
$startdate = getgetnumform(startdate);
$starttime = getgetnumform(starttime);
if ($startdate == "" || $starttime == "") {
print "<p align=\"left\">全項目手動指定で予約します。</p>\n";
} else {
$lengthmin = getgetnumform(lengthmin);
$recstid = getgetnumform(recstid);
$pname = getgetform(pname);
//$usedigital = getgetnumform(usedigital);
// 確認
$startdatetime = "{$startdate}" . "{$starttime}";
if (foldatevalidation($startdatetime)) {
//print "valid";
} else {
$errflag = 1;
$errmsg = "日付が不正です。";
}
if ($lengthmin < 361) {
//valid
} else {
$errflag = 2;
$errmsg = "録画時間は360分で区切ってください。";
}
}
// end if
$reservedrssametid->closeCursor();
// 録画番組検索
$query = "\n\tSELECT\n\t foltia_program.tid,stationname, foltia_program.title,\n\t foltia_subtitle.countno, foltia_subtitle.subtitle,\n\t foltia_subtitle.startdatetime as x, foltia_subtitle.lengthmin,\n\t foltia_tvrecord.bitrate, foltia_subtitle.pid\n\tFROM foltia_subtitle , foltia_program ,foltia_station ,foltia_tvrecord\n\t WHERE foltia_tvrecord.tid = foltia_program.tid\n\t AND foltia_tvrecord.stationid = foltia_station .stationid\n\t AND foltia_program.tid = foltia_subtitle.tid\n\t AND foltia_station.stationid = foltia_subtitle.stationid\n\t AND foltia_subtitle.enddatetime >= ? \n\tUNION\n\tSELECT\n\t foltia_program.tid, stationname, foltia_program.title,\n\t foltia_subtitle.countno, foltia_subtitle.subtitle,\n\t foltia_subtitle.startdatetime, foltia_subtitle.lengthmin,\n\t foltia_tvrecord.bitrate, foltia_subtitle.pid\n\tFROM foltia_tvrecord\n\t LEFT OUTER JOIN foltia_subtitle on (foltia_tvrecord.tid = foltia_subtitle.tid )\n\t LEFT OUTER JOIN foltia_program on (foltia_tvrecord.tid = foltia_program.tid )\n\t LEFT OUTER JOIN foltia_station on (foltia_subtitle.stationid = foltia_station.stationid )\n\tWHERE foltia_tvrecord.stationid = 0\n\t AND foltia_subtitle.enddatetime >= ? ORDER BY x ASC\n";
$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 = "\n\t\tSELECT \n\t\t foltia_program.tid, stationname, foltia_program.title,\n\t\t foltia_subtitle.countno, foltia_subtitle.subtitle,\n\t\t foltia_subtitle.startdatetime, foltia_subtitle.lengthmin,\n\t\t foltia_subtitle.pid, foltia_subtitle.startoffset\n\t\tFROM foltia_subtitle, foltia_program, foltia_station \n\t\tWHERE foltia_program.tid = foltia_subtitle.tid\n\t\t AND foltia_station.stationid = foltia_subtitle.stationid \n\t\t AND foltia_subtitle.enddatetime >= ?\n\t\t AND foltia_subtitle.countno = '1' \n\t\tORDER BY foltia_subtitle.startdatetime ASC \n\t\tLIMIT 1000\n\t";
} else {
// レコード総数取得
$query = "\n\t\tSELECT\n\t\t COUNT(*) AS cnt \n\t\tFROM foltia_subtitle, foltia_program, foltia_station \n\t\tWHERE foltia_program.tid = foltia_subtitle.tid\n\t\t AND foltia_station.stationid = foltia_subtitle.stationid \n\t\t AND foltia_subtitle.enddatetime >= ? \n\t\tLIMIT 1000 \n\t";
$rs = sql_query($con, $query, "DBクエリに失敗しました", array($now));
$rowdata = $rs->fetch();
$dtcnt = htmlspecialchars($rowdata[0]);
// echo $dtcnt;
if (!$rowdata) {
die_exit("番組データがありません<BR>");
}
// endif
////////////////////////////////////////////////////////////
*/
include "./foltialib.php";
$con = m_connect();
if ($useenvironmentpolicy == 1) {
if (!isset($_SERVER['PHP_AUTH_USER'])) {
header("WWW-Authenticate: Basic realm=\"foltia\"");
header("HTTP/1.0 401 Unauthorized");
redirectlogin();
exit;
} else {
login($con, $_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW']);
}
}
//end if login
$pid = getgetform(pid);
$filename = getgetform(f);
if ($pid == "" || $filename == "") {
header("Status: 404 Not Found", TRUE, 404);
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html lang="ja">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="Content-Style-Type" content="text/css">
<link rel="stylesheet" type="text/css" href="graytable.css">
<title>Starlight Breaker -編集</title>
</head>
<body BGCOLOR="#ffffff" TEXT="#494949" LINK="#0047ff" VLINK="#000000" ALINK="#c6edff" >
<div align="center">
