<?php printhtmlpageheader(); //タイトル取得 $query = "\nSELECT \nfoltia_program.tid,\nstationname,\nfoltia_program .title ,\nfoltia_tvrecord.bitrate ,\nfoltia_tvrecord.stationid \nFROM foltia_tvrecord , foltia_program , foltia_station \nWHERE foltia_tvrecord.tid = foltia_program.tid AND foltia_tvrecord.stationid = foltia_station .stationid AND foltia_tvrecord.tid = ? AND foltia_tvrecord.stationid = ? "; // $rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました", array($tid, $sid)); $rowdata = $rs->fetch(); if (!$rowdata) { die_exit("登録番組がありません<BR>"); } $tid = htmlspecialchars($rowdata[0]); $stationname = htmlspecialchars($rowdata[1]); $title = htmlspecialchars($rowdata[2]); $bitrate = htmlspecialchars($rowdata[3]); $stationid = htmlspecialchars($rowdata[4]); $delflag = getgetnumform(delflag); ?> <p align="left"><font color="#494949" size="6">予約解除</font></p> <hr size="4"> <?php if ($delflag == "1") { print "「" . $title . "」の自動録画予約を解除しました。 <br>\n"; //削除処理 if ($demomode || $protectmode) { //demomodeやprotectmodeならなにもしない } else { //キュー削除プログラムをキック $oserr = system("{$toolpath}/perl/addatq.pl {$tid} {$sid} DELETE"); //DB削除 $query = "\nDELETE \nFROM foltia_tvrecord \nWHERE foltia_tvrecord.tid = ? AND foltia_tvrecord.stationid = ? ";
?> <!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</title> </head> <?php ////////////////////////////////////////////////////////// // 1ページの表示レコード数 $lim = 1000; // クエリ取得 $p = getgetnumform(p); // ページ取得の計算 list($st, $p, $p2) = number_page($p, $lim); /////////////////////////////////////////////////////////// $now = date("YmdHi"); $query = "\n\tSELECT \n\t foltia_program.tid,\n\t foltia_program.title,\n foltia_tvrecord.tid AS rec\n\tFROM foltia_program \n LEFT JOIN foltia_tvrecord ON foltia_tvrecord.tid = foltia_program.tid\n\tGROUP BY foltia_program.tid\n\tORDER BY foltia_program.tid DESC\n\tLIMIT {$lim} OFFSET {$st}\n"; $rs = sql_query($con, $query, "DBクエリに失敗しました"); $rowdata = $rs->fetch(); if (!$rowdata) { die_exit("番組データがありません<BR>"); } $query2 = "\n\tSELECT COUNT(*) AS cnt FROM foltia_program \n"; $rs2 = sql_query($con, $query2, "DBクエリに失敗しました"); $rowdata2 = $rs2->fetch(); if (!$rowdata2) { die_exit("番組データがありません<BR>");
DCC-JPL Japan/foltia project */ 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]);
$day7 = date("m/d(D)", mktime($starthour, 0, 0, $beginmonth, $beginday + 7, $beginyear)); $day7 = weekDaysRep($day7); /////////////////////////////////////////////////////////////////// // 表示局選定 // $page = 1 $maxdisplay = getgetnumform("st"); if (!ctype_digit($maxdisplay)) { $maxdisplay = 8; } $query = "SELECT count(*) FROM foltia_station WHERE \"ontvcode\" LIKE '%ontvjapan%'"; $rs = sql_query($con, $query, "DBクエリに失敗しました"); $maxrows = $rs->fetchColumn(0); if ($maxrows > $maxdisplay) { $pages = ceil($maxrows / $maxdisplay); } $page = getgetnumform("p"); if ($page == "" || $page <= 0) { $page = 1; $offset = 0; } else { $page = ereg_replace("[^0-9]", "", $page); if ($page > $pages) { $page = $pages; } elseif ($page <= 0) { $page = 1; } $offset = $page * $maxdisplay - $maxdisplay; } ///////////////////////////////////////////////////////////////// //表示部分 $navigationbar = "\n\n[<A HREF=\"./viewepg.php\">現在</A>] |\n<A HREF=\"./viewepg.php?p={$page}&start={$yesterday}\">{$dayyesterday} [前日]</A> |\n当日(\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$today0400}&e={$endh}\">4:00</A> \n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$today0800}&e={$endh}\">8:00</A> \n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$today1200}&e={$endh}\">12:00</A> \n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$today1600}&e={$endh}\">16:00</A> \n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$today2000}&e={$endh}\">20:00</A> \n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$today2359}&e={$endh}\">24:00</A>) |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$tomorrow}&e={$endh}\">{$daytomorrow} [翌日]</A>\n<br>\n |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day0after}&e={$endh}\">{$day0}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day1after}&e={$endh}\">{$day1}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day2after}&e={$endh}\">{$day2}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day3after}&e={$endh}\">{$day3}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day4after}&e={$endh}\">{$day4}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day5after}&e={$endh}\">{$day5}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day6after}&e={$endh}\">{$day6}</A> |\n<A HREF=\"./viewepg.php?p={$page}&st={$maxdisplay}&start={$day7after}&e={$endh}\">{$day7}</A> | <BR>\n";
exit; } else { login($con, $_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW']); } } //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"> <?php $epgid = getgetnumform(epgid); if ($epgid == "") { print "\t<title>foltia:EPG予約:Error</title></head>\n"; die_exit("登録番組がありません<BR>"); } print "\t<title>foltia:EPG予約:{$epgid}</title>\n</head>\n"; $now = date("YmdHi"); // タイトル取得 $query = "\n SELECT\n epgid,\n startdatetime,\n enddatetime,\n lengthmin,\n ontvchannel,\n epgtitle,\n epgdesc,\n epgcategory,\n stationname,\n stationrecch,\n stationid\n FROM\n foltia_epg,\n foltia_station\n WHERE epgid = ?\n AND foltia_station.ontvcode = foltia_epg.ontvchannel\n"; // 4812 $rs = sql_query($con, $query, "DBクエリに失敗しました", array($epgid)); $rowdata = $rs->fetch(); if (!$rowdata) { die_exit("登録番組がありません<BR>"); } ?>
http://www.geocities.co.jp/SiliconValley-Cupertino/2647/tec.html */ 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(pid); if ($pid == "") { exit; } $query = "\nSELECT \nfoltia_program.tid,\nstationname,\nfoltia_program.title,\nfoltia_subtitle.countno,\nfoltia_subtitle.subtitle,\nfoltia_subtitle.startdatetime ,\nfoltia_subtitle.lengthmin , \nfoltia_subtitle.pid ,\nfoltia_subtitle.m2pfilename , \nfoltia_subtitle.pspfilename \nFROM foltia_subtitle , foltia_program ,foltia_station \nWHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid \n AND foltia_subtitle.pid = ? "; // $rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました", array($pid)); $rowdata = $rs->fetch(); if (!$rowdata) { print ""; exit; } else { $title = $rowdata[2]; $episode = $rowdata[3]; $subtitle = $rowdata[4]; $m2pfilename = $rowdata[8];
} if ($now > 200501010000.0) { } else { $now = date("YmdHi"); } $query = "\n\tSELECT\n\t foltia_program.tid,\n\t stationname,\n\t foltia_program.title,\n\t foltia_subtitle.countno,\n\t foltia_subtitle.subtitle,\n\t foltia_subtitle.startdatetime as x,\n\t foltia_subtitle.lengthmin,\n\t foltia_tvrecord.bitrate,\n\t foltia_subtitle.startoffset,\n\t foltia_subtitle.pid,\n\t foltia_subtitle.epgaddedby,\n\t foltia_tvrecord.digital\n\tFROM\n\t foltia_subtitle,\n\t foltia_program,\n\t foltia_station,\n\t foltia_tvrecord\n\tWHERE 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\t UNION\n\t SELECT\n\t foltia_program.tid,\n\t stationname,\n\t foltia_program.title,\n\t foltia_subtitle.countno,\n\t foltia_subtitle.subtitle,\n\t foltia_subtitle.startdatetime,\n\t foltia_subtitle.lengthmin,\n\t foltia_tvrecord.bitrate,\n\t foltia_subtitle.startoffset,\n\t foltia_subtitle.pid,\n\t foltia_subtitle.epgaddedby,\n\t foltia_tvrecord.digital\n\t FROM\n\t 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\t WHERE foltia_tvrecord.stationid = 0\n\t AND foltia_subtitle.enddatetime >= ? ORDER BY x ASC\n"; $rs = sql_query($con, $query, "DBクエリに失敗しました", array($now, $now)); //チューナー数 if (getgetnumform('r') != "") { $recunits = getgetnumform('r'); } elseif ($recunits == "") { $recunits = 4; } $overlapCheck = false; if (getgetnumform('o') != "") { $overlapCheck = getgetnumform('o'); if ($overlapCheck == 1) { $overlapCheck = true; } else { $overlapCheck = false; } } ?> <body BGCOLOR="#ffffff" TEXT="#494949" LINK="#0047ff" VLINK="#000000" ALINK="#c6edff" > <div align="center"> <?php printhtmlpageheader(); ?> <p align="left"><font color="#494949" size="6">予約一覧</font></p>
<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分で区切ってください。";
redirectlogin(); exit; } else { login($con,$_SERVER['PHP_AUTH_USER'],$_SERVER['PHP_AUTH_PW']); } }//end if login */ $now = date("YmdHi"); $nowrfc822 = date("r"); $max = getgetnumform(max); if ($max > 0) { //件数指定があればなにもしない } else { $max = 45; } $tid = getgetnumform(tid); if ($tid >= 0 && $tid != "") { $query = "\nSELECT foltia_program.tid,foltia_program.title,\nfoltia_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} \nORDER BY enddatetime DESC \n limit ? offset 0 \n"; $titlequery = "\nSELECT foltia_program.tid,foltia_program.title \nFROM foltia_program \nWHERE foltia_program.tid = ? \n"; // $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 = htmlspecialchars($rowdata[1]); } else { $query = "\nSELECT foltia_program.tid,foltia_program.title,\nfoltia_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 ORDER BY enddatetime DESC \nlimit ? offset 0 \n\t"; $rsstitle = "新規録画"; } //if $header = "<?xml version=\"1.0\" encoding=\"UTF-8\"?> \n<rss xmlns:itunes=\"http://www.itunes.com/DTDs/Podcast-1.0.dtd\" version=\"2.0\"> \n <channel> \n <title>{$rsstitle}:Folcast</title> \n <itunes:author>DCC-JPL Japan/foltia project</itunes:author> \n <link>http://www.dcc-jpl.com/soft/foltia/</link> \n <description>フォルティアが未読処理をお助けしちゃいます</description> \n <itunes:subtitle>foltia video podcast :{$rsstitle}:Folcast</itunes:subtitle> \n <itunes:summary>フォルティアが未読処理をお助けしちゃいます</itunes:summary> \n\t\t<language>ja</language>\n <copyright>foltia</copyright> \n <itunes:owner> \n <itunes:name>{$rsstitle}:Folcast</itunes:name> \n <itunes:email>foltia@dcc-jpl.com</itunes:email> \n </itunes:owner> \n <category>Technology</category> \n <itunes:category text=\"Technology\"></itunes:category> \n\n"; $header = mb_convert_encoding($header, "UTF-8");
</head> <?php $tid = getgetnumform(tid); if ($tid == "") { die_exit("番組が指定されていません<BR>"); } $station = getgetnumform(station); if ($station == "") { $station = 0; } $usedigital = getgetnumform(usedigital); if ($usedigital == "") { $usedigital = 0; } $bitrate = getgetnumform(bitrate); if ($bitrate == "") { $bitrate = 5; } $now = date("YmdHi"); //タイトル取得 $query = "select title from foltia_program where tid = ? "; // $rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました", array($tid)); $rowdata = $rs->fetch(); if (!$rowdata) { $title = "(未登録)"; } else { $title = htmlspecialchars($rowdata[0]); } ?>