| 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 | | //旧仕様ココまで |
|---|