<?
	require_once '../common/boardSet.php';
	require_once '../common/boardFunc.php';

	if(!$db){
		die("db를 설정해 주십시오.");
	}

	if(!$no){
		die("set NO error");
	}

	if(!$fileno){
		die("set FINENO error");
	}

	//$section[1] = 함수 및 접속 파일불러옴

//echo $member['eTime'];
//exit;
//	if($_memberTerm<1){
//		errorMSG("회원님은 유효기간중이 아닙니다. 다운 받을 수 없습니다.");
//	}
	///////////////////////////////////////////////////////////////////
	$query = "select * from dbx_admin_board where db = '$db'";
	$result = mysqli_query($connect,$query);
	$array = mysqli_fetch_array($result);
	foreach($array as $key => $value){
		$key = "SET_".$key;
		$$key = $value;
		unset($key);
		unset($value);
	}

	///////////////////////////////////////////////////////////////////

	$query = "select * from dbx_board_$db where no = '$no'";
	$result = mysqli_query($connect,$query);
	$array = mysqli_fetch_array($result);
	foreach($array as $key => $value){
		$key = "DB_".$key;
		$$key = $value;
		unset($key);
		unset($value);
	}

	///////////////////////////////////////////////////////////////////

	//$section[3] = 게시판에 허용된 레벨인가 체크
		$fileID = "view";
		$page2ID = "download";
		require_once("../member/process/login_chk.php");
	//게시판에 허용된 레벨인가 체크 종료
  
  if(trim($fileno) != ""){
    $updateQuery = "update dbx_board_$db set file_hit${fileno} = file_hit${fileno}+1";
		$DB_file_name = ${'DB_file_name'.$fileno};
		$DB_file_code = ${'DB_file_code'.$fileno};
  }
		
	$updateQuery.= " where no='$no'";
	$updateResult = mysqli_query($connect,$updateQuery);

	$explodeName = explode(".", $DB_file_name);
	$ext = array_pop($explodeName);

//$DB_file_name='1.hwp';
//$DB_file_code='1.hwp';
//$explodeName='1';
//$ext='hwp';

	if ($ext=="avi" || $ext=="asf")					$file_type = "video/x-msvideo";
	else if ($ext=="mpg" || $ext=="mpeg")		$file_type = "video/x-msvideo";
	else if ($ext=="asf" || $ext=="asx")		$file_type = "video/x-msvideo";
	else if ($ext=="mp3" || $ext=="wmv")		$file_type = "video/x-msvideo";
	else if ($ext=="jpg" || $ext=="jpeg" || $ext=="JPG" || $ext=="JPEG")	$file_type = "image/jpg";
	else if ($ext=="gif" || $ext=="GIF")		$file_type = "image/gif";
	else if ($ext=="png" || $ext=="PNG")		$file_type = "image/png";
	else if ($ext=="zip")										$file_type = "application/x-zip-compressed";
	else if ($ext=="txt" || $ext=="hwp" || $ext=="gul" || $ext=="doc" || $ext=="ppt" || $ext=="xls" || $ext=="html" || $ext=="htm" || $ext=="pdf"){
		$file_type = "text/plain";
	}

	if($ext=="jpg" || $ext=="jpeg" || $ext=="gif" || $ext=="JPG" || $ext=="JPEG" || $ext=="GIF" || $ext=="hwp" || $ext=="wav" || $ext=="mp3" || $ext=="wma" || $ext=="doc" || $ext=="ppt" || $ext=="hwp" || $ext=="mpg" || $ext=="mpeg" || $ext=="avi" || $ext=="xls" || $ext=="pdf"){
		$downSaveDir = $boardDir."data/".$db."/".$no."/";
		$mdownSaveDir = $localUrl."board/data/".$db."/".$no."/".$DB_file_name;
		$downLoadFile = $downSaveDir.$DB_file_name;

	}
	else{
		$downSaveDir = $boardDir."data/".$db."/";
		$downLoadFile = $downSaveDir.$DB_file_code;
		$mdownSaveDir = $localUrl."board/data/".$db."/".$no."/".$DB_file_code;
	}


	$isFile = is_file($downLoadFile);
	if(!$isFile){
		error("파일이 존재하지 않습니다.");
	}


	if(preg_match("/(MSIE 5.0|MSIE 5.1|MSIE 5.5|MSIE 6.0)/i", $HTTP_USER_AGENT)) { 
	  if(strstr($HTTP_USER_AGENT, "MSIE 5.5")) { 
		  header("Content-Type: doesn/matter"); 
			header("Content-disposition: filename=$DB_file_name"); 
			header("Content-Transfer-Encoding: binary"); 
			Header("Cache-Control: cache, must-revalidate");
			header("Pragma: no-cache"); 
			header("Expires: 0"); 
		} 

		if(strstr($HTTP_USER_AGENT, "MSIE 5.0"))  { 
		  Header("Content-type: file/unknown"); 
		  header("Content-Disposition: attachment; filename=$DB_file_name");
			Header("Content-Description: PHP3 Generated Data"); 
			Header("Cache-Control: cache, must-revalidate");
			header("Pragma: no-cache"); 
			header("Expires: 0"); 
		} 

		if(strstr($HTTP_USER_AGENT, "MSIE 5.1")) { 
			Header("Content-type: file/unknown"); 
			header("Content-Disposition: attachment; filename=$DB_file_name"); 
			Header("Content-Description: PHP3 Generated Data"); 
			Header("Cache-Control: cache, must-revalidate");
			header("Pragma: no-cache"); 
			header("Expires: 0"); 
		}

		if(strstr($HTTP_USER_AGENT, "MSIE 6.0")){
			Header("Content-type: application/x-msdownload");
			Header("Content-Length: ".(string)(filesize("$downLoadFile")));
			Header("Content-Disposition: attachment; filename=$DB_file_name");
			Header("Cache-Control: cache, must-revalidate");
			Header("Content-Transfer-Encoding: binary");
			Header("Pragma: no-cache");
			Header("Expires: 0");
		}
	}
	else{
Header("Content-type: file/unknown"); 
		Header("Content-Length: ".(string)(filesize("$downLoadFile"))); 
		Header("Content-Disposition: attachment; filename=$DB_file_name"); 
		Header("Content-Description: PHP3 Generated Data"); 
		Header("Cache-Control: cache, must-revalidate");  // 요게 잇어야 웹상에서열림
		Header("Pragma: no-cache"); 
		Header("Expires: 0"); 

	}


	if(is_file($downLoadFile)){
		

		$fp = fopen($downLoadFile, "r+b");
	}
	else{

		errorMSG("화일이 존재하지 않거나, 시스템 오류입니다.");
	}
  

	if(!fpassthru($fp)){
		fclose($fp);
	}

?>