<?
	include "$DOCUMENT_ROOT/conf/conf_dir.php";
?>
<META http-equiv=Content-Type content="text/html; charset=UTF-8">
<?
switch($num){
    case 1:
        $sch_title = "新着順";
        $order_by ="order by start_date desc,no DESC";
        break;
    case 2:
        $sch_title = "評価の高い順";
        $order_by ="order by voted_count desc";
        break;
    case 3:
        $sch_title = "";
        $order_by ="order by no desc,reg_date desc";
        break;
    case 4:
        $sch_title = "私のお気に入り";
        $order_by ="order by hit desc";
        break;
}

if(!$pageCount) $pageCount = 4;
$show_one_page      = $pageCount;
$show_view_page     = 5;
$page     = ( $page ) ? $page : 1;
$offset   = ($page-1)*$show_one_page;


  //총 회원;
  if($sessionLevel !=15){ //관리자 일떄 다 보이기.
    $where .= " and is_secret='N' ";
  }

  if($sch_key) {
		$where .= "AND (subject like '%".$sch_key."%' OR contents like '%".$sch_key."%') ";
  }

  $url_tail .= "&sch_key=$sch_key";

  $tableName = "photo_movie";
  $total_count  = get_db("SELECT count(*) FROM $tableName where is_delete = 'N' $where");
  $query_limit  = "limit $offset,$show_one_page";

  $QUERY_PAGE  = "SELECT * FROM $tableName where is_delete = 'N' $where $order_by $query_limit";

  $total_page   = ceil( $total_count / $show_one_page);
  $viewlist     = ( !$total_count ) ? "" : Get_viewpage3($page,$total_count,$show_one_page,$show_view_page,$url_tail);
  $start_num    = $total_count - $offset;  //
  $result= mysql_query($QUERY_PAGE,$db_con);
  $total = mysql_affected_rows();

  if(!$total)
  {
    $BRD_LIST = "<li style='text-align:center;'>登録された商品がありません。</li>";
  }
  else
  {
    for($i=0; $i<$total; $i++)
    {
      unset($NUM_IMG,$New_icon);

      $row = mysql_fetch_array($result);
      $Num = $row[no];
      // 마우스 오버 icon_mv_play.png // 선택 icon_mv_click.png
      if(!$chk_no) $chk_no = $Num;
      if($chk_no== $Num) $check_select = "<div id='movieComt_ls_box_layer'><div class='movie_bg'></div><div class='on_play'><img src='/images/sub/icon_mv_click.png' /></div></div>";
      else $check_select = "<a href='javascript: view_paging($page,$row[no],\"$url_tail\");'><div id='movieComt_ls_box_layer'><div class='movie_bg'></div><div class='over_play'><img src='/images/sub/icon_mv_play.png' /></div></div></a>";
      //이미지 추출 시작
      $results  = Get_dbres("SELECT * FROM files WHERE module_name='movie' and module_no='$Num'");
      $rows = mysql_fetch_array($results);

      $BRD_LIST .="<li class='movieComt_ls_box' style='background-image:url(\"/files/muti/thump/$rows[file_name]\"	); background-size: cover; background-repeat:no-repeat;' >$check_select<div class='play_time'> $row[user_name] </div></li>";

  }
}

echo "<h2 class='font_BSize padding_b_22'>$sch_title</h2><ul class='movieList_le'>";
echo $BRD_LIST;
echo " </ul>";
echo "<ul class='pagination'>$viewlist</ul>";
?>
<script>
main_gall_resize();
</script>