<?php

	include $_SERVER['DOCUMENT_ROOT']."/conf/conf_dir.php";

	$META_AUTHOR 				= "HEO YOUNG SAENG";
	$META_KEYWORD			= "HEO YOUNG SAENG,CI ENT";
	$META_DISCRIPTION		= "HEO YOUNG SAENG JAPAN OFFICIAL WEB SITE";
	$PAGE_TITLE					= "HEO YOUNG SAENG JAPAN OFFICAL WEB SITE | ホ・ヨンセン";

	$PAGE_GUBUN =	"4";

	include $_SERVER['DOCUMENT_ROOT']."/pages/inc_top.php";
	if($sessionLevel != 15){
			$userhitpage ="movie";
			$hitcount = Get_db("select hit from user_hit where name = '$userhitpage' and startDay = '$today'");
			if(!$hitcount){
				$queryhit = "INSERT INTO user_hit ( id, name, hit, startDay) VALUES ( '', '$userhitpage', '1', '$today')";
			}else{
				$queryhit = "update user_hit set hit = hit+1 where name='$userhitpage' and startDay = '$today'";
			}
			$hitresult = mysql_query($queryhit, $db_con);
	}
?>
<script>
function video_play(ttype,tmpUrl,video_title,dataOption,video_uploader,val,tval){
	if(ttype==1){
		document.getElementById("movLink").src =tmpUrl;
	}else{
		document.getElementById("movLink").src =tmpUrl+"?autoplay=1";
	}
	var shin_video_name = video_title.substring(0,28);

	document.getElementById('movieform'+val).className ="mov_list_thumb_on";
	for(var k=0;k < tval;k++){
		if(val != k){
			document.getElementById('movieform'+k).className ="mov_list_thumb_off";
		}
	}
}
</script>
<?
	// =============================================== Query
	$tableName = "movie";

	if(!$pageCount) $pageCount = 9;

	$show_one_page			= $pageCount;
	$show_view_page			= 10;

	$page     = ( $page ) ? $page : 1;
	$offset   = ($page-1)*$show_one_page;

	if($key_word) {
		$key_word = str_replace(" ","",$key_word);
		$where = "AND $key LIKE '%$key_word%'";
	}

	$order_by = ' ORDER BY reg_date DESC';
	$url_tail = "&tab=$tab&tabs=$tabs&key=$key&order_by=$order_by";

	$query_limit  = "limit $offset,$show_one_page";

	if($sessionLevel !='15'){
		$where .=" and is_secret='N' ";
	}

	//$where .=" and is_secret='N' ";
	if($MG==10){
		echo "<script>alert('準備中です.');history.back();</script>";
		$where .=" and general_setting ='1' ";
	}else{
		$where .=" and general_setting ='0' ";
	}

	$QUERY_TOTAL = "SELECT count(*) FROM photo_$tableName where original_no=0  $where $order_by";
	$QUERY_PAGE  = "SELECT * FROM photo_$tableName where original_no=0  $where $order_by $query_limit";

	$total_count  = get_db($QUERY_TOTAL);
	$Num = $total_count - $offset;
	$total_page   = ceil( $total_count / $show_one_page);
	$start_num    = $total_count - $offset;  //
	$viewlist     = ( !$total_count ) ? "" : Get_viewpage($page,$total_count,$show_one_page,$show_view_page,$url_tail);

	$result= mysql_query($QUERY_PAGE,$db_con);
	if(!$result) {
		error("DB_ERROR");
		exit;
	}
	$total = mysql_affected_rows();

	$res = Get_dbres("select * from photo_$tableName where original_no=0 $where order by start_date desc");
	$rowU = mysql_fetch_array($res);
	if($rowU[inputtype]==1){
		//$cURL = "./movieflv.html?fileUrl=".$rowU[contentUrl];
		$cURL="<video id='movLink' src='/files/muti/video/$rowU[contentUrl]' width='650' controls >このブラウザでは再生できません.</video>";
	}else{

		$cURL = "<iframe id='movLink' width='560' height='315' src='$rowU[contentUrl]' allowscriptaccess='always'  frameborder='0' allowTransparency='true' scrolling='no' allowfullscreen></iframe>";
	}
?>

 <div id="page_index">
  <a href="default.php">HOME</a> > MOVIE
 </div>

 <div id="sub_content_box">
		<div class="board_area4">
			<div class="mov_link"><?=$cURL?></div>
		</div>

  <ul class="gal_list_area">
    <li class="result">MOVIE LIST (全<?=$total_count?>件)</li>
  </ul>
 </div>

	 <div id="sub_content_box">
   <?

	if(!$total){

		echo "登録された情報がございませ";
	}else{
      $kk = 0;
      for($i=0; $i<$total; $i++) {

       $row = mysql_fetch_array($result);
       //$contents = explode("",$row[contents]);
       $regdate = substr($row[reg_date],0,10);
       $imgName = get_db("select file_name from files where module_no = '$row[no]' and module_name='$tableName' order by no");
       $Num = $total_count - $kk;
       //$doY = $kk%3;
       $subject	= stripslashes($row[subject]);
	   //$subject = utf8_cutstr($subject,'50','..');

       if($row[inputtype]==1){
        $contentsURL = "/files/muti/video/".$row[contentUrl];
       }else{
        $contentsURL = $row[contentUrl];
       }
    ?>
			<div id='img_312x390'>
				<p id="movieform<?=$i?>" class="mov_list_thumb_off" style="margin:0 7px 0; cursor:pointer;" onclick="video_play('<?=$row[inputtype]?>','<?=$contentsURL?>','','<?=$row[start_date]?>','<?=$row[user_name]?>','<?=$i?>',<?=$total?>)" mouserollover="">
				<img src="/files/muti/thump/<?=$imgName?>" width="312" height="170"/></p>
				<dl>
					<dt><b><?=$subject?></b><br><?=$row[start_date]?></dt>
				</dl>
			</div>
			<?
				//$kk++;
				//$Num--;
					}
				}
			?>





 </div>

 	<div id="sub_content_box">
  <ul class="gal_list_area">
   <li class="result">(全<?=$total_count?>件)</li>
   <?=$viewlist?>
	 </ul>
	</div>



<?
  include"inc_footer.php";
?>

</body>
</html>