<?
	include "$DOCUMENT_ROOT/conf/conf_dir.php";
  $tableName = "photo_gallery";
  $order_by ="ORDER BY order_by asc,no desc";
  if($search_word) $sch_title .="\"$search_word\" ";

  include "include_where.php";

  if(!$pageCount) $pageCount =9;  // 리스트 갯수
  $show_one_page      = $pageCount;
  $show_view_page     = 5;
  $page     = ( $page ) ? $page : 1;
  $offset   = ($page-1)*$show_one_page;
  $query_limit  = "limit $offset,$show_one_page";

  $total_count  = get_db("SELECT count(no) FROM $tableName where is_delete = 'N' $where");
  $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();


 for($i=0;$i< $total;$i++){

   $row = mysql_fetch_array($result);
   $regDate = substr($row[reg_date],0,10);
   unset($imgNames,$New_icon,$New_secret);

   $imgfileName = get_db("SELECT file_name FROM files where module_no = '$row[no]' and module_name='gallery' and module_type='C' order by order_by");

   $subject = $row[subject];
   if($row[start_date] == $today){$New_icon="<font color=orange><b>NEW</b></font>";}
   if($row[is_secret] == 'Y'){$New_secret="<font color='red'>[SECRET]</font>";}
   if($sessionIDX){
     $tmp_a = "<a href=\"javascript:openshow($row[no],'$tableName')\">";
   }else{
     $tmp_a = "<a href=\"javascript:alert('ログインしてください.'); location.href='./login.php'\">";
   }

   $photoList .="<li>$tmp_a<img src='/files/muti/gallery/$imgfileName' id='left_img".$row[no]."' class='grayscale'	/></a></li>";
 }

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