/
selectcaptureimage.php
executable file
·158 lines (130 loc) · 4.8 KB
/
selectcaptureimage.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
<?php
/*
Anime recording system foltia
http://www.dcc-jpl.com/soft/foltia/
目的
blogツール、スターライトブレイカー用キャプ選択画面サンプル
引数
pid:PID
mplayer -ss 00:00:10 -vo jpeg:outdir=/home/foltia/php/tv/691.localized/img/6/ -vf crop=702:468:6:6,scale=160:120,pp=lb -ao null -sstep 14 -v 3 /home/foltia/php/tv/691-6-20060216-0130.m2p
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(pid);
if ($pid == "") {
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>
<script src="http://images.apple.com/main/js/ac_quicktime.js" language="JavaScript" type="text/javascript"></script>
</head>
<body BGCOLOR="#ffffff" TEXT="#494949" LINK="#0047ff" VLINK="#000000" ALINK="#c6edff" >
<div align="center">
<?php
printhtmlpageheader();
if ($pid == "") {
print "画像がありません。<br></body></html>";
exit;
}
$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.m2pfilename ,
foltia_subtitle.pspfilename
FROM foltia_subtitle , foltia_program ,foltia_station
WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid
AND foltia_subtitle.pid = ?
";
$rs = sql_query($con, $query, "DBクエリに失敗しました",array($pid));
$rowdata = $rs->fetch();
if (! $rowdata) {
$query = "
SELECT
foltia_program.tid,
foltia_program.tid,
foltia_program.title,
foltia_subtitle.countno,
foltia_subtitle.subtitle,
foltia_subtitle.startdatetime ,
foltia_subtitle.lengthmin ,
foltia_subtitle.pid ,
foltia_subtitle.m2pfilename ,
foltia_subtitle.pspfilename
FROM foltia_subtitle , foltia_program
WHERE foltia_program.tid = foltia_subtitle.tid
AND foltia_subtitle.pid = ?
";
$rs = sql_query($con, $query, "DBクエリに失敗しました",array($pid));
$rowdata = $rs->fetch();
if (! $rowdata) {
print " <p align=\"left\"><font color=\"#494949\" size=\"6\">キャプチャ画像</font></p>
<hr size=\"4\">
<p align=\"left\">
録画記録がありません。<br></body></html>";
exit ;
}
$rowdata[1] = "";
}//end if (! $rowdata)
print " <p align=\"left\"><font color=\"#494949\" size=\"6\">キャプチャ画像</font></p>
<hr size=\"4\">
<p align=\"left\">";
print "<a href = \"http://cal.syoboi.jp/tid/$rowdata[0]/\" target=\"_blank\">";
print htmlspecialchars($rowdata[2]) . "</a> " ;
print htmlspecialchars($rowdata[3]) . " ";
$tid = $rowdata[0];
if ($tid > 0){
print "<a href = \"http://cal.syoboi.jp/tid/$tid/time#$pid\" target=\"_blank\">";
print htmlspecialchars($rowdata[4]) . "</a> ";
}else{
print htmlspecialchars($rowdata[4]) . " ";
}
print htmlspecialchars($rowdata[1]) . " ";
print htmlspecialchars($rowdata[6]) . "分 ";
print htmlspecialchars(foldate2print($rowdata[5]));
$mp4filename = $rowdata[9];
$serverfqdn = getserverfqdn();
print " 再生:<A HREF=\"$httpmediamappath/$tid.localized/mp4/$mp4filename\" target=\"_blank\">$mp4filename</A> / <script language=\"JavaScript\" type=\"text/javascript\">QT_WriteOBJECT_XHTML('http://g.hatena.ne.jp/images/podcasting.gif','16','16','','controller','FALSE','href','http://$serverfqdn/$httpmediamappath/$tid.localized/mp4/$mp4filename','target','QuickTimePlayer','type','video/mp4');</script> / <a href=\"./mp4player.php?p=$pid\" target=\"_blank\">Player</a><br>";
$m2pfilename = $rowdata[8];
list($tid,$countno,$date,$time)= split ("-", $m2pfilename );
// $tid = ereg_replace("[^0-9]", "", $tid);
$tid = $rowdata[0];
$countno = $rowdata[3] ;
$path = ereg_replace("\.m2p$|\.m2t$", "", $m2pfilename);
$serveruri = getserverfqdn ();
exec ("ls $recfolderpath/$tid.localized/img/$path/", $tids);
//$timecount = 1;
foreach($tids as $filetid) {
if (file_exists("./sb-edit.php") ) {
print "<a href=\"./sb-edit.php?pid=$pid&f=$filetid\"><img src='http://$serveruri$httpmediamappath/$tid.localized/img/$path/$filetid' alt='$tid:$countno:$filetid'></a>\n";
}else{
print "<img src='http://$serveruri$httpmediamappath/$tid.localized/img/$path/$filetid' alt='$tid:$countno:$filetid'>\n";
}
}//foreach
// タイトル一覧 ここまで
?>
</body>
</html>