정세찬_우리산전

우리산전 문의게시판 View

1. 문의게시판: 공개글, 비밀글 분류; 관리자페이지에서 문의 답변 가능

include_once "./__RootDir__.php";
        include_once "./_lib/_header.php";

$banner_path = "customer";
        $banner_title = "INQUIRY";
        $banner_text = "작은 이익보다는 고객에게 감동을 안겨주는 <br>큰 노력을 계속 하겠습니다";
        $category_name = "고객지원";
        $page_name = "문의게시판";
        $category_page ="e1_notice";
        $this_page = "e3_inquiry";
        include_once("header.php");
        include_once("sub_banner.php");

$idx							= xssClean($_REQUEST["idx"]);
        $page						= xssClean($_REQUEST["page"]);
        $s_keyfield				= xssClean($_REQUEST["s_keyfield"]);
        $s_keyword			= xssClean($_REQUEST["s_keyword"]);
        $bd_pw					= xssClean($_REQUEST["bd_pw"]);

$bid="qna";

$nowpage = "e3_inquiry";

if($idx==""){
        	alert("잘못된 경로입니다.","./");
        	exit;
        }

$sql = "select count(*) from sm_board a where bd_idx ='".$idx."' ".$bd_language_query." ";
        $result = query($sql);
        $row = mysqli_fetch_row($result);
        if($row[0]){
        	$sql= "select a.* , (select ad_name".$admin_language." from sm_admin where a.bd_regid =  ad_id) as bd_writer from sm_board a where bd_idx ='".$idx."' ".$bd_language_query." ";
        	$result = query($sql);
        	$row = mysqli_fetch_array($result);

if($row["bd_regtype"]=="M"){
        		if($row["bd_pw_yn"]=="Y"){
        			if($bd_pw==""){
        				alert("잘못된 경로입니다.","./");
        				exit;
        			}
        			if($bd_pw != $row["bd_password"]){
        				alert("패스워드가 올바르지 않습니다.");
        				exit;
        			}
        		}
        	}

$hit_query = "update sm_board set bd_hit =  bd_hit+1 where bd_idx ='".$idx."' ".$bd_language_query." ";
        	query($hit_query);

}
        else{
        	alert("잘못된 경로입니다.","./");
        	exit;
        }

$getvalue = "s_keyfield=".$s_keyfield."&s_keyword=".$s_keyword;

<section class="sub_page sub_padding notice view_page">
        	<div class="title_box">
        		<h2> echo $page_name; </h2>
        		<p>작은 이익보다는 고객에게 감동을 안겨주는 <br class="hidden-xs">큰 노력을 계속 하겠습니다</p>
        	</div>

<div class="view_wrap">
        		<div class="container">
        			<div class="view_box">
        				<div class="title">
        					<h2>=nl2br($row["bd_title"])</h2>
        					<h6>=substr($row["bd_regdate"],0,10)</h6>
        				</div>
        				<div class="contents_box">
        					=$row["bd_content"]

if($row["bd_regtype"]=="M"){
        						if($row["bd_state"]=="end"){

<br>
        							<br>
        							<h2  class="c-sm-title" style="font-size:20px"><span class="qna_comment_style">[Re] =nl2br($row["bd_answer_title"])</span></h2>
        							<div class="table board-view">

<div class="row input-info last" style="padding-left:20px">
        									<div class="text">
        										<p>=nl2br($row["bd_answer"])</p>
        									</div>
        								</div>

</div>

}
        					}

</div>

if($s_keyword){
        					if($s_keyfield=="all"){
        						$search_query .=" and (bd_title like '%".$s_keyword."%' || bd_content like '%".$s_keyword."%' || bd_writer like '%".$s_keyword."%' || bd_name like '%".$s_keyword."%'  ) ";
        					}
        					else if($s_keyfield=="bd_writer" ){
        						$search_query .=" and (bd_writer like '%".$s_keyword."%' || bd_name like '%".$s_keyword."%'  ) ";
        					}
        					else{
        						$search_query .=" and ".$s_keyfield."  like '%".$s_keyword."%' ";
        					}
        				}

$query2 = "select *   from  ( select a.*, (select ad_name".$admin_language." from sm_admin where a.bd_regid =  ad_id) as bd_writer from sm_board a ) as temp   where (bd_rank < '".$row["bd_rank"]."' and bd_id = '".$row["bd_id"]."') ".$search_query." ".$bd_language_query ." order by bd_rank  desc   limit 0,1";
        				$result2 = query($query2);
        				$cnt2 = mysqli_num_rows($result2);
        				if($cnt2){
        					$row_pre = mysqli_fetch_array($result2);
        					if($row_pre["bd_regtype"]=="M"){
        						if($row_pre["bd_pw_yn"]=="Y"){
        							$pre_str = "<p><a href=\"".$nowpage."_pw.php?idx=".$row_pre["bd_idx"]."&page=".$page."&".$getvalue."\"   >".$row_pre["bd_title"]."</a></p>";
        						}
        						else{
        							$pre_str = "<p><a href=\"".$PHP_SELF."?idx=".$row_pre["bd_idx"]."&page=".$page."&".$getvalue."\" >".$row_pre["bd_title"]."</a></p>";
        						}
        					}
        					else{
        						$pre_str = "<p><a href=\"".$PHP_SELF."?idx=".$row_pre["bd_idx"]."&page=".$page."&".$getvalue."\" >".$row_pre["bd_title"]."</a></p>";
        					}
        				}
        				else{
        					$pre_str  ="<p class=\"no_page\">이전글이 없습니다.</p>";
        				}

$query3 = "select *  from ( select a.*, (select ad_name".$admin_language." from sm_admin where a.bd_regid =  ad_id) as bd_writer from sm_board a ) as temp   where (bd_rank >  '".$row["bd_rank"]."' and bd_id = '".$row["bd_id"]."') ".$search_query." ".$bd_language_query ." order by bd_rank asc   limit 0,1";
        				$result3 = query($query3);
        				$cnt3 = mysqli_num_rows($result3);
        				if($cnt3){
        					$row_next = mysqli_fetch_array($result3);

if($row_next["bd_regtype"]=="M"){
        						if($row_next["bd_pw_yn"]=="Y"){
        							$next_str = "<p><a href=\"".$nowpage."_pw.php?idx=".$row_next["bd_idx"]."&page=".$page."&".$getvalue."\"   >".$row_next["bd_title"]."</a></p>";
        						}
        						else{
        							$next_str = "<p><a  href=\"".$PHP_SELF."?idx=".$row_next["bd_idx"]."&page=".$page."&".$getvalue."\" >".$row_next["bd_title"]."</a></p>";
        						}
        					}
        					else{
        						$next_str = "<p><a  href=\"".$PHP_SELF."?idx=".$row_next["bd_idx"]."&page=".$page."&".$getvalue."\" >".$row_next["bd_title"]."</a></p>";
        					}

}
        				else{
        					$next_str ="<p class=\"no_page\">다음글이 없습니다.</p>";
        				}

if($row["bd_file1"] != ""){
        							$bd_file = "./_upload/board/".$row["bd_file1"];
        							if(is_file($bd_file)){
        								$imageSize = filesize("./_upload/board/".$row["bd_file1"]) / 1024;
        								$imageSize = round($imageSize,1);

}
        						}

if($row["bd_regtype"]=="M"){

}

<form name="frm" id="frm" method="get" action="./php echo $nowpage_proc.php"> 
        	<input type="hidden" name="mode" id="mode" value="delete"/>
        	<input type="hidden" name="idx" id="idx" value="=$idx">
        	<input type="hidden" name="page" value="=$page">
        	<input type="hidden" name="s_keyfield" value="=$s_keyfield">
        	<input type="hidden" name="s_keyword" value="=$s_keyword">
        </form>
         include_once("footer.php");

$("#btn_check_delete").click(function() {
        			$("input[name='mode']").val("delete");
        			$("#frm").attr("action","./e3_inquiry_pw.php");
        			$("#frm").submit();
        			return;
        		});
        	});
        </script>