187 | | <td><A HREF=\"$httpmediamappath/$tid.localized/mp4/$fName\" target=\"_blank\">$fName</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/$fName','target','QuickTimePlayer','type','video/mp4');</script> $caplink</td> |
---|
| 195 | <td><a href =\"$httpmediamappath/$tid.localized/mp4/$fName\" target=\"_blank\">$fName</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/$fName','target','QuickTimePlayer','type','video/mp4');</script> $caplink</td> |
---|
196 | | |
---|
197 | | //旧仕様 |
---|
198 | | /* |
---|
199 | | //ディレクトリからファイル一覧を取得 |
---|
200 | | exec ("ls $recfolderpath/$tid.localized/mp4/*.MP4", $mp4files); |
---|
201 | | |
---|
202 | | if (file_exists("./selectcaptureimage.php") ) { |
---|
203 | | $sbpluginexist = 1; |
---|
204 | | } |
---|
205 | | |
---|
206 | | $serverfqdn = getserverfqdn(); |
---|
207 | | |
---|
208 | | foreach($mp4files as $pathfName) { |
---|
209 | | $fName = ""; |
---|
210 | | $fNametmp = split("/",$pathfName); |
---|
211 | | $fName = array_pop($fNametmp); |
---|
212 | | if(($fName == ".") or ($fName == "..") ){ continue; } |
---|
213 | | |
---|
214 | | if (ereg(".MP4", $fName)){ |
---|
215 | | $thumbnail = $fName; |
---|
216 | | $thumbnail = ereg_replace(".MP4", ".THM", $thumbnail); |
---|
217 | | // $filesplit = split("-",$fName); |
---|
218 | | //print "<!-- FILENAME:$fName:$pathfName:$query -->\n"; |
---|
219 | | $query = ""; |
---|
220 | | |
---|
221 | | $query = " |
---|
222 | | SELECT |
---|
223 | | foltia_program.tid, |
---|
224 | | foltia_program.title, |
---|
225 | | foltia_subtitle.countno, |
---|
226 | | foltia_subtitle.subtitle, |
---|
227 | | foltia_subtitle.startdatetime , |
---|
228 | | foltia_subtitle.m2pfilename , |
---|
229 | | foltia_subtitle.pid |
---|
230 | | FROM foltia_subtitle , foltia_program |
---|
231 | | WHERE foltia_subtitle.pspfilename = '$fName' |
---|
232 | | AND foltia_program.tid = foltia_subtitle.tid |
---|
233 | | AND foltia_program.tid = $tid |
---|
234 | | "; |
---|
235 | | //print "<!-- FILENAME:$fName:$pathfName:$query -->\n"; |
---|
236 | | $rs = ""; |
---|
237 | | $rs = m_query($con, $query, "DBクエリに失敗しました"); |
---|
238 | | |
---|
239 | | if (pg_num_rows ($rs ) == 0){ |
---|
240 | | |
---|
241 | | $count = "[話数]"; |
---|
242 | | $subtitle = "[サブタイトル]"; |
---|
243 | | $onairdate = "[放映日]"; |
---|
244 | | $caplink = ""; |
---|
245 | | }else{ |
---|
246 | | |
---|
247 | | $rowdata = pg_fetch_row($rs, $row); |
---|
248 | | $title = $rowdata[1]; |
---|
249 | | |
---|
250 | | if ($rowdata[2]== "" ){ |
---|
251 | | $count = "[話数]"; |
---|
252 | | }else{ |
---|
253 | | $count = $rowdata[2]; |
---|
254 | | } |
---|
255 | | if ($rowdata[3]== "" ){ |
---|
256 | | $subtitle = "[サブタイトル]"; |
---|
257 | | }else{ |
---|
258 | | $subtitle = $rowdata[3]; |
---|
259 | | } |
---|
260 | | $onairdate = $rowdata[4]; |
---|
261 | | |
---|
262 | | $tid = htmlspecialchars($rowdata[0]); |
---|
263 | | $title = htmlspecialchars($title); |
---|
264 | | $count = htmlspecialchars($count); |
---|
265 | | $subtitle = htmlspecialchars($subtitle); |
---|
266 | | $onairdate = htmlspecialchars($onairdate); |
---|
267 | | |
---|
268 | | $day = substr($onairdate,0,4)."/".substr($onairdate,4,2)."/".substr($onairdate,6,2); |
---|
269 | | $time = substr($onairdate,8,2).":".substr($onairdate,10,2); |
---|
270 | | $onairdate = "$day $time"; |
---|
271 | | |
---|
272 | | //Starlight Breaker向け拡張 |
---|
273 | | //$debug_pg_num_rows = pg_num_rows ($rs ); |
---|
274 | | $caplink = ""; |
---|
275 | | |
---|
276 | | if (($sbpluginexist == 1) && (pg_num_rows ($rs ) > 0)){ |
---|
277 | | $capimgpath = htmlspecialchars(preg_replace("/.m2p/", "", $rowdata[5])); |
---|
278 | | if (file_exists("$recfolderpath/$tid.localized/img/$capimgpath") ){ |
---|
279 | | $caplink = " / <a href = \"./selectcaptureimage.php?pid=$rowdata[6]\">キャプ</a>"; |
---|
280 | | }else{ |
---|
281 | | $caplink = " / キャプなし"; |
---|
282 | | } |
---|
283 | | }else{ |
---|
284 | | $caplink = ""; |
---|
285 | | }//end if sb |
---|
286 | | |
---|
287 | | } //end if 検索件数が0のとき |
---|
288 | | //-- |
---|
289 | | print " |
---|
290 | | <tr> |
---|
291 | | <td rowspan=\"4\" width=\"170\"><A HREF=\"$httpmediamappath/$tid.localized/mp4/$fName\" target=\"_blank\"><IMG SRC = \"$httpmediamappath/$tid.localized/mp4/$thumbnail\" WIDTH = \"160\" HEIGHT = \"120\"></A></td> |
---|
292 | | <td>$count</td> |
---|
293 | | </tr> |
---|
294 | | <tr> |
---|
295 | | <td>$subtitle</td> |
---|
296 | | </tr> |
---|
297 | | <tr> |
---|
298 | | <td>$onairdate</td> |
---|
299 | | </tr> |
---|
300 | | <tr> |
---|
301 | | <td><A HREF=\"$httpmediamappath/$tid.localized/mp4/$fName\" target=\"_blank\">$fName</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/$fName','target','QuickTimePlayer','type','video/mp4');</script> $caplink</td> |
---|
302 | | </tr> |
---|
303 | | "; |
---|
304 | | |
---|
305 | | }//end if ereg m2p |
---|
306 | | }//end foreach |
---|
307 | | |
---|
308 | | */ |
---|
309 | | //旧仕様ココまで |
---|