';
// print_r($lecture);
// echo '';
}
@require_once ($_SERVER['DOCUMENT_ROOT'].'/__system/lib/func.bbs.php');
?>
getFetchQuery($sql);
$s_row['wm_orderby'] = str_replace("\'","'",$s_row['wm_orderby']);
//view_dump($s_row );
if (!isset($s_row['wm_table']) && empty($s_row['wm_table'])){
alert("설정된 URL이 아닙니다.", $Errorloadpage);
} else if( !in_array($mode,array('list','write','view','modify','reply','pwview','pwmodify','pwdel','pwcdel'))){
alert("존재하지 않는 글입니다.", $Errorloadpage);
} else if( $idx==0 && in_array($mode,array('view','modify','reply','pwview','pwmodify','pwdel','pwcdel'))){
alert("존재하지 않는 글입니다.", $Errorloadpage);
} else{
// 권한
$b_auth = [];
if(in_array($_SESSION['mb_level'],explode(",",$s_row['wm_list_level']))) $b_auth['list'] = true;
if(in_array($_SESSION['mb_level'],explode(",",$s_row['wm_read_level']))) $b_auth['read'] = true;
if(in_array($_SESSION['mb_level'],explode(",",$s_row['wm_write_level']))) $b_auth['write'] = true;
if(in_array($_SESSION['mb_level'],explode(",",$s_row['wm_write_level']))) $b_auth['modify'] = true;
if(in_array($_SESSION['mb_level'],explode(",",$s_row['wm_delete_level']))) $b_auth['del'] = true;
if(in_array($_SESSION['mb_level'],explode(",",$s_row['wm_reply_level'])) && $s_row['wm_reply']=='Y') $b_auth['reply'] = true;
if(in_array($_SESSION['mb_level'],explode(",",$s_row['wm_comment_level'])) && $s_row['wm_comment']=='Y') $b_auth['comment'] = true;
/*
// 권한
$b_auth = [];
if($s_row['wm_list_level'] <= $_SESSION['mb_level']) $b_auth['list'] = true;
if($s_row['wm_read_level'] <= $_SESSION['mb_level']) $b_auth['read'] = true;
if($s_row['wm_write_level'] <= $_SESSION['mb_level']) $b_auth['write'] = true;
if($s_row['wm_reply_level'] <= $_SESSION['mb_level'] && $s_row['wm_reply']=='Y') $b_auth['reply'] = true;
if($s_row['wm_comment_level'] <= $_SESSION['mb_level'] && $s_row['wm_comment']=='Y') $b_auth['comment'] = true;
*/
// 목록 권한없고 쓰기권한만 있을 경우
if($b_auth['list']==false && $b_auth['write']==true){
$mode="write";
}
// 카테고리
$b_cate = [];
if(trim($s_row['wm_category'])!='') $b_cate = explode("|", $s_row['wm_category']);
// 파라미터
$queryStr = "&bbs=".$bbs."&lecture=".$lecture2."&cate=".$cate."&option=".$option."&keyword=".$keyword;
$queryStr2 = "&bbs=".@str_replace("sp_wm_","",$_TB['b_review'])."&lecture=".$lecture2."&cate=".$cate."&option=".$option."&keyword=".$keyword;
// where query
if($_SESSION['mb_level']==10) $WHERE_auth = " WHERE wm_business_code = '"._BIZ_CODE."'";
else {
$where_qry = "";
if(isset($_SESSION['mb_official']) && $_SESSION['mb_official'] == 'Y'){ // 공식홈 일때
$where_qry = "AND wm_usage in('A','B')";
}else{ // 공식홈 아닐때 선택캠퍼스
if(_AGENCY_CODE != ""){
$where_qry = " AND (wm_usage='A' or ( wm_usage_ag_code like '%"._AGENCY_CODE."%' )) ";
}
}
// if($_SERVER['REMOTE_ADDR'] == "211.33.129.246"){
// view_dump(_AGENCY_CODE);
// view_dump($_SESSION['mb_official']);
// view_dump(_AGENCY_CODE != "");
// view_dump($where_qry);
// }
$WHERE_auth = " WHERE wm_business_code = '"._BIZ_CODE."' ".$where_qry." ";
}
// 과정
$b_lecture = [];
if(trim($s_row['wm_lecture'])=='Y') {
$where_lec = "";
if(_BIZ_CODE == "B0001"){ //메스컴일 경우 제외처리하는 과정타입
$where_lec = " and wm_lec_type not in ('A','B','C','E','F')";
$sql = "SELECT max(wm_id) as wm_id, wm_title FROM sp_lecture ".$WHERE_auth." ".$where_lec." AND ifnull(wm_status,'N')='Y'
GROUP BY wm_title
order by wm_title asc";
}else{
if(trim($s_row['wm_regular'])=='Y'){
$where_lec = " and wm_lec_type in ('A')";
}else if(trim($s_row['wm_regular'])=='O'){
$where_lec = " and wm_lec_type not in ('A')";
}
$sql = "SELECT wm_id, wm_title FROM sp_lecture ".$WHERE_auth." ".$where_lec." AND ifnull(wm_status,'N')='Y' order by wm_id desc";
}
$data = $db->getFetchQueryAll($sql);
foreach($data as $v){
$b_lecture[$v['wm_id']] = $v['wm_title'];
}
}
$WHERE1 = " AND ifnull(wm_notice,'N')<>'Y'";
$WHERE2 = "";
if($lecture2!='') $WHERE2 .=" AND wm_lecture='".$lecture2."'";
if($cate!='') $WHERE2 .=" AND wm_ca='".$cate."'";
if($keyword!='' && $option!=''){
$WHERE2 .=" AND wm_".$option." like '%".$keyword."%'";
} else if($keyword!=''){
$WHERE2 .=" AND (wm_title like '%".$keyword."%' || wm_content like '%".$keyword."%')";
}
// 사업부 선택이 Y인 경우
if($s_row['wm_usebiz']=='Y'){
$WHERE_auth = " WHERE ((wm_usebiz_code like '%"._BIZ_CODE."%') or (wm_usebiz_code is null and wm_business_code = '"._BIZ_CODE."'))";
}
// 프론트에서 삭제여부와 노출상태 조건추가
$WHERE_auth .= " and is_temp='N' and wm_status='Y'";
// 갤러리 일 경우 공지사항은 order by에추가 (일반 리스트에 공지사항 글 추가)
if(in_array($s_row['wm_skin'],array('gallery','sketch','portfolio','interview','jobinterview','event'))){
$WHERE = $WHERE_auth.$WHERE2;
//$s_row['wm_orderby'] = 'wm_notice desc, '.$s_row['wm_orderby'];
}else {
$WHERE = $WHERE_auth.$WHERE1.$WHERE2;
}
// list
if($mode=='list' || $mode=='view'){
// 권한체크
if(!$b_auth['list']) alert('목록 권한이 없습니다.', $Errorloadpage);
//bbs = it_seminar, seminar2 종료일 지나면 order_no=0처리
if(in_array($s_row['wm_table'],array('it_seminar', 'seminar2'))){ //hard
$sql2 = "UPDATE sp_wm_".$s_row['wm_table']." SET order_no=0 WHERE wm_end_date< '".date('Y-m-d')."'";
$db->setQuery($sql2);
}
// 공지사항
if($s_row['wm_table'] == 'it_seminar' || $s_row['wm_table'] == 'seminar2' ){ // hard it_seminar, seminar2 정렬값 변경
$sql = "SELECT * FROM (
SELECT *, SUBSTR(wm_wdate,3,8) as wdate, SUBSTR(wm_wdate,12,8) as wtime, (case when (CONCAT(wm_end_date,' ', wm_end_time)< NOW() OR order_no=0) then 0 else TIMESTAMPDIFF(MINUTE, NOW(),(CASE WHEN wm_end_date='' THEN NOW() ELSE CONCAT(wm_end_date,' ', wm_end_time) END)) END ) AS order_no_custom
FROM sp_wm_".$s_row['wm_table']." ".$WHERE_auth." AND (wm_notice='Y' and ((ifnull(wm_notice_sdate,'')='' and ifnull(wm_notice_edate,'')='') or (concat(wm_notice_sdate, ' ',wm_notice_stime)<='".date('Y-m-d H:i:00')."' and concat(wm_notice_edate, ' ',wm_notice_etime)>='".date('Y-m-d H:i:00')."')))
) tbl order by ".$s_row['wm_orderby']."";
} else{
//$sql = "SELECT *, left(wm_wdate,10) as wdate FROM sp_wm_".$s_row['wm_table']." ".$WHERE_auth." AND ifnull(wm_notice,'N')='Y' order by ".$s_row['wm_orderby']."";
$sql = "SELECT *, SUBSTR(wm_wdate,3,8) as wdate, SUBSTR(wm_wdate,12,8) as wtime
FROM sp_wm_".$s_row['wm_table']." ".$WHERE_auth." AND (wm_notice='Y' and ((ifnull(wm_notice_sdate,'')='' and ifnull(wm_notice_edate,'')='') or (concat(wm_notice_sdate, ' ',wm_notice_stime)<='".date('Y-m-d H:i:00')."' and concat(wm_notice_edate, ' ',wm_notice_etime)>='".date('Y-m-d H:i:00')."')))
order by ".$s_row['wm_orderby']."";
}
//echo($sql);
//exit;
$b_notice = $db->getFetchQueryAll($sql);
$b_cnt = count($b_notice);
// 일반글
$sql = "SELECT count(*) FROM sp_wm_".$s_row['wm_table']." ".$WHERE;
$total_cnt = $db->getFetchQueryOne($sql);
$pagesize = $s_row['wm_pagenum'];
if($mode=='view') $pagesize = 6; // 뷰 하단리스트
// if($s_row['wm_cnt']< (($page - 1) * $pagesize+1)) $page=1; // 뷰 하단리스트 와 페이지사이즈가 상의할때
$from_record = ($page - 1) * $pagesize; // 시작 열
$total_page = ceil($total_cnt / $pagesize);
if($s_row['wm_table'] == 'it_seminar' || $s_row['wm_table'] == 'seminar2' ){ // hard it_seminar, seminar2 정렬값 변경
$sql = "SELECT * FROM (
SELECT *, SUBSTR(wm_wdate,3,8) as wdate, SUBSTR(wm_wdate,12,8) as wtime, (case when (CONCAT(wm_end_date,' ', wm_end_time)< NOW() OR order_no=0) then 0 else TIMESTAMPDIFF(MINUTE, NOW(),(CASE WHEN wm_end_date='' THEN NOW() ELSE CONCAT(wm_end_date,' ', wm_end_time) END)) END ) AS order_no_custom
FROM sp_wm_".$s_row['wm_table']." ".$WHERE."
) tbl order by ".$s_row['wm_orderby']." limit ".$from_record." , ".$pagesize."";
}
else{
//$sql = "SELECT *, left(wm_wdate,10) as wdate FROM sp_wm_".$s_row['wm_table']." ".$WHERE." order by ".$s_row['wm_orderby']." limit ".$from_record." , ".$pagesize."";
$sql = "SELECT *, SUBSTR(wm_wdate,3,8) as wdate, SUBSTR(wm_wdate,12,8) as wtime FROM sp_wm_".$s_row['wm_table']." ".$WHERE." order by ".$s_row['wm_orderby']." limit ".$from_record." , ".$pagesize."";
}
//echo $sql;
//exit;
$b_list = $db->getFetchQueryAll($sql);
// 게시판 갯수 (공지+일반)
$bbs_total = $total_cnt+$b_cnt;
if(in_array($s_row['wm_skin'],array('gallery','sketch','portfolio','interview','jobinterview','event','review'))) $bbs_total = $total_cnt;
foreach($b_list as $k=>$v){
$b_list[$k]['wm_content'] = fnREChange_view($v['wm_content']);
$b_list[$k]['wm_content_m'] = fnREChange_view($v['wm_content_m']);
// 갤러리 첨부파일 목록
if(in_array($s_row['wm_skin'],array('gallery','sketch','portfolio','interview','jobinterview','event'))){
// if($bbs == "it_review") {
if($s_row['wm_skin'] == "review") {
if(trim($s_row['wm_lecture'])=='Y' && $v['wm_lecture']!=''){
$sql = "SELECT wm_image3 FROM sp_lecture WHERE wm_id='".$v['wm_lecture']."'";
$b_list[$k]['thumb_lecture'] = $db->getFetchQueryOne($sql);
$sql = "SELECT wm_lec_type FROM sp_lecture WHERE wm_id='".$v['wm_lecture']."'";
$lec_type = $db->getFetchQueryOne($sql);
switch($lec_type) {
case "A" :
$b_list[$k]['lec_type'] = "정규과정";
break;
case "B" :
$b_list[$k]['lec_type'] = "단과과정";
break;
case "C" :
$b_list[$k]['lec_type'] = "국비과정";
break;
case "D" :
$b_list[$k]['lec_type'] = "자격증과정";
break;
case "E" :
$b_list[$k]['lec_type'] = "특수과정";
break;
case "F" :
$b_list[$k]['lec_type'] = "정규과정";
break;
}
if($b_list[$k]['thumb_lecture']=='') $b_list[$k]['thumb_lecture'] = BBS_URL."/images/noimg.jpg";
else $b_list[$k]['thumb_lecture'] = BBS_DATA_URL."/../lecture/".$b_list[$k]['thumb_lecture'];
}
} else {
$sql = "SELECT wm_filename FROM sp_board_file WHERE wm_table='".$s_row['wm_table']."' and wm_bid='".$v['wm_id']."' and wm_num=0";
$b_list[$k]['thumb_img'] = $db->getFetchQueryOne($sql);
if($b_list[$k]['thumb_img']=='') $b_list[$k]['thumb_img'] = BBS_URL."/images/noimg.jpg";
else $b_list[$k]['thumb_img'] = IMG_S3.$b_list[$k]['thumb_img'];
}
}
// 비밀글 열람권한
if($_SESSION['mb_level']<2) $b_list[$k]['pwd_cnt'] = 0;
else{
$sql = "SELECT count(*) from sp_wm_".$s_row['wm_table']." where wm_parent=".$v['wm_parent']." and member_id='".$_SESSION['mb_id']."'";
$b_list[$k]['pwd_cnt'] = $db->getFetchQueryOne($sql);
}
// 게시기간
$b_list[$k]['wm_period']='Y';
if($_SESSION['mb_level']<8 && $s_row['wm_period']=='Y' && $v['wm_start_date']!='' || $v['wm_end_date']!=''){
$sd = $v['wm_start_date'].' '.$v['wm_start_time'];
$ed = $v['wm_end_date'].' '.$v['wm_end_time'];
$now = date('Y-m-d H:i');
if($now<$sd || $now>=$ed) $b_list[$k]['wm_period']='N'; // 종료
if($now<$sd) $b_list[$k]['wm_period']='P'; // 예정
}
// 수강후기
if(in_array($s_row['wm_skin'],array('review'))){
// 과정 사진 목록
if(trim($s_row['wm_lecture'])=='Y' && $v['wm_lecture']!=''){
$sql = "SELECT wm_image3 FROM sp_lecture WHERE wm_id='".$v['wm_lecture']."'";
$b_list[$k]['thumb_lecture'] = $db->getFetchQueryOne($sql);
if($b_list[$k]['thumb_lecture']==''){
$b_list[$k]['thumb_lecture'] = BBS_URL."/images/noimg.png";
}else{
//$b_list[$k]['thumb_lecture'] = BBS_DATA_URL."/../lecture/".$b_list[$k]['thumb_lecture'];
$b_list[$k]['thumb_lecture'] = IMG_S3."lecture/".$b_list[$k]['thumb_lecture'];
}
}
// 댓글
if($s_row['wm_comment']=='Y'){
$sql = "SELECT *, left(wm_wdate,10) as wdate FROM sp_wm_".$s_row['wm_table']."_comment WHERE wm_bid='".$v['wm_id']."' order by wm_id desc";
$b_list[$k]['c_list'] = $db->getFetchQueryAll($sql);
}
}
}
if($s_row['wm_table'] != 'it_seminar' && $s_row['wm_table'] != 'seminar2' ){
/* 수강 후기인 경우 */
// 공지사항 (수강후기인 경우)
//$sql = "SELECT *, left(wm_wdate,10) as wdate FROM ".$_TB['b_review']." ".$WHERE_auth." AND ifnull(wm_notice,'N')='Y' order by ".$s_row['wm_orderby']."";
//$b_notice2 = $db->getFetchQueryAll($sql);
//$b_cnt2 = count($b_notice2);
// 일반글2
$sql = "SELECT count(*) FROM ".$_TB['b_review']." ".$WHERE;
$total_cnt2 = $db->getFetchQueryOne($sql);
$pagesize2 = $s_row['wm_pagenum'];
$from_record2 = ($page - 1) * $pagesize2; // 시작 열
$total_page2 = ceil($total_cnt2 / $pagesize2);
$sql = "SELECT *, left(wm_wdate,10) as wdate FROM ".$_TB['b_review']." ".$WHERE." order by ".$s_row['wm_orderby']." limit ".$from_record." , ".$pagesize2."";
//echo $sql;
//exit;
$b_list2 = $db->getFetchQueryAll($sql);
// 게시판 갯수 (공지+일반)
$bbs_total2 = $total_cnt2+$b_cnt2;
if(in_array($s_row['wm_skin'],array('gallery','sketch','portfolio','interview','jobinterview','event'))) $bbs_total2 = $total_cnt2;
foreach($b_list2 as $k=>$v){
// 갤러리 첨부파일 목록
if(in_array($bbs,array('gallery', 'seminar', 'seminar2', 'sketch', 'sketch2','portfolio', 'portfolio2'))){
$sql = "SELECT wm_filename FROM sp_board_file WHERE wm_table='".$s_row['wm_table']."' and wm_bid='".$v['wm_id']."' and wm_num=0";
$b_list2[$k]['thumb_img'] = $db->getFetchQueryOne($sql);
if($b_list2[$k]['thumb_img']=='') $b_list2[$k]['thumb_img'] = BBS_URL."//images/noimg.jpg";
else $b_list2[$k]['thumb_img'] = BBS_DATA_URL."/review3/".$b_list2[$k]['thumb_img'];
}
// 비밀글 열람권한
if($_SESSION['mb_level']<2) $b_list2[$k]['pwd_cnt'] = 0;
else{
$sql = "SELECT count(*) from sp_wm_".$s_row['wm_table']." where wm_parent=".$v['wm_parent']." and member_id='".$_SESSION['mb_id']."'";
$b_list2[$k]['pwd_cnt'] = $db->getFetchQueryOne($sql);
}
// 댓글
if($s_row['wm_comment']=='Y'){
$sql = "SELECT *, left(wm_wdate,10) as wdate FROM sp_wm_".$s_row['wm_table']."_comment WHERE wm_bid='".$v['wm_id']."' order by wm_id desc";
$b_list[$k]['c_list'] = $db->getFetchQueryAll($sql);
}
}
/* 수강 후기인 경우 */
}
$skinPage = "skn_bbs_list.html";
echo "";
echo "";
}
if($mode!='list'){
// view or write
$visible_scope = [
"A"=>"전체사용(캠퍼스전체)",
"B"=>"전체사용(캠퍼스일부)",
"C"=>"캠퍼스만",
];
// 게시글
$sql = "SELECT * FROM sp_wm_".$s_row['wm_table']." ".$WHERE_auth." and wm_id=".$view_idx."";
$b_row = $db->getFetchQuery($sql);
$before1 = 'http://intra.megastudy-computer.com/data/board/editor/';
$after1 = 'https://img.megastudyacademy.co.kr/campus/intra/board/editor/';
$before2 = 'http://intra2.megastudy-computer.com/data/board/editor/';
$after2 = 'https://img.megastudyacademy.co.kr/campusdev/intra/board/editor/';
$b_row['wm_content'] = str_replace($before1, $after1, $b_row['wm_content']);
$b_row['wm_content'] = str_replace($before2, $after2, $b_row['wm_content']);
$b_row['wm_content'] = fnREChange_view($b_row['wm_content']);
$b_row['wm_content_m'] = str_replace($before1, $after1, $b_row['wm_content_m']);
$b_row['wm_content_m'] = str_replace($before2, $after2, $b_row['wm_content_m']);
$b_row['wm_content_m'] = fnREChange_view($b_row['wm_content_m']);
if($b_row['wm_parent']=='') $b_row['wm_parent'] = 0;
// 게시기간
if($_SESSION['mb_level']<8 && $s_row['wm_period']=='Y' && $b_row['wm_start_date']!='' || $b_row['wm_end_date']!=''){
$sd = $b_row['wm_start_date'].' '.$b_row['wm_start_time'];
$ed = $b_row['wm_end_date'].' '.$b_row['wm_end_time'];
$now = date('Y-m-d H:i');
// if($now<$sd || $now>=$ed) alert('오픈된 게시글이 아닙니다.', $Errorloadpage);
}
// 비밀글 열람권한
if($_SESSION['mb_level']<2) $b_row['pwd_cnt'] = 0;
else{
$sql = "SELECT count(*) from sp_wm_".$s_row['wm_table']." ".$WHERE_auth." and wm_parent=".$b_row['wm_parent']." and member_id='".$_SESSION['mb_id']."'";
$b_row['pwd_cnt'] = $db->getFetchQueryOne($sql);
}
// 권한체크
if($mode!='write' && !$b_row['wm_id']) alert('권한이 없습니다.', $Errorloadpage);
if($mode=='write'){
if(!$b_auth['write']) alert('글 작성 권한이 없습니다.', $Errorloadpage);
} else if($mode=='modify'){
if(!$b_auth['write']) alert('글 작성 권한이 없습니다.', $Errorloadpage);
// 비밀글 체크
if($b_row['wm_secret']=='Y'){
if(!isset($pwdcheck)) $pwdcheck = '';
if ($_SESSION['mb_level'] <2 && $pwdcheck != "Y") {
if ($pwdcheck =="") alert("비밀글은 열람할수 없습니다.", $Errorloadpage);
else alert("비밀글의 비밀번호가 일치하지 않습니다.", $Errorloadpage);
} else {
//회원일 경우
if ($_SESSION['mb_level']<10 && $_SESSION['mb_level'] >=2 && $b_row['member_id']!=$_SESSION['mb_id']) {
alert("내 게시글만 수정할수 있습니다.", $Errorloadpage);
}
}
}
} else if($mode=='reply'){
if(!$b_auth['reply']) alert('답글 작성 권한이 없습니다.', $Errorloadpage);
if($b_row['wm_notice'] == "Y") alert('공지에는 답변 할 수 없습니다.', $Errorloadpage);
} else if($mode=='view'){
if(!$b_auth['read']) alert('열람 권한이 없습니다.', $Errorloadpage);
// 비밀글 체크
if($b_row['wm_secret']=='Y'){
if(!isset($pwdcheck)) $pwdcheck = '';
if ($_SESSION['mb_level'] <2 && $pwdcheck != "Y") {
if ($pwdcheck =="") alert("비밀글은 열람할수 없습니다.");
else alert("비밀글의 비밀번호가 일치하지 않습니다.");
} else {
//회원일 경우
if ($_SESSION['mb_level']<10 && $_SESSION['mb_level'] >=2 && $b_row['member_id']!=$_SESSION['mb_id'] && $b_row['pwd_cnt']==0) {
alert("나의 비밀글만 확인할수 있습니다.");
}
}
}
// 조회수 update
$sql = "UPDATE sp_wm_".$s_row['wm_table']." SET wm_hit=wm_hit+1 WHERE wm_id = ".$idx."";
$db->setQuery($sql);
$b_row['wm_hit'] = $b_row['wm_hit']+1;
}
// 첨부파일 목록
$sql = "SELECT * FROM sp_board_file WHERE wm_table='".$s_row['wm_table']."' and wm_bid='".$b_row['wm_id']."' order by wm_num asc";
$data = $db->getFetchQueryAll($sql);
$f_list = [];
foreach($data as $v){
$f_list[$v['wm_num']] = $v;
}
// 뷰 페이지
if($mode=='view'){
// 이전글 & 다음글
if($s_row['wm_table'] == 'it_seminar' || $s_row['wm_table'] == 'seminar2' ){ // hard 뷰티 it_seminar, seminar2 정렬값 변경
$tbl = "SELECT @ROWNUM := @ROWNUM + 1 AS num, tbl.*
FROM (
SELECT wm_parent, wm_num, wm_id, wm_title, wm_wdate, wm_notice, order_no, wm_end_date, wm_end_time, (CASE WHEN (CONCAT(wm_end_date,' ', wm_end_time)< NOW() OR order_no=0) THEN 0 ELSE TIMESTAMPDIFF(MINUTE, NOW(),(CASE WHEN wm_end_date='' THEN NOW() ELSE CONCAT(wm_end_date,' ', wm_end_time) END)) END) AS order_no_custom
FROM sp_wm_".$s_row['wm_table']." ".$WHERE."
ORDER BY order_no DESC, (CASE WHEN wm_end_date='' THEN NOW() ELSE CONCAT(wm_end_date,' ', wm_end_time) END) DESC
) tbl
, (
SELECT @ROWNUM := 0) AS row_num
ORDER BY ".$s_row['wm_orderby']."";
$sql ="SELECT num FROM (
".$tbl."
) AS tbl2 WHERE wm_id=".$b_row['wm_id']."";
$num_row = $db->getFetchQueryOne($sql);
$sql ="SELECT wm_id, wm_title, wm_wdate FROM (
".$tbl."
) AS tbl2 WHERE num=(".$num_row."+1)";
$nexts = $db->getFetchQuery($sql);
$sql ="SELECT wm_id, wm_title, wm_wdate FROM (
".$tbl."
) AS tbl2 WHERE num=(".$num_row."-1)";
$prevs = $db->getFetchQuery($sql);
}else{
$sql = "SELECT wm_id, wm_title, wm_wdate FROM sp_wm_".$s_row['wm_table']." ".$WHERE." and (wm_parent<".$b_row['wm_parent']." or (wm_parent=".$b_row['wm_parent']." && wm_num<".$b_row['wm_num'].")) order by ".$s_row['wm_orderby']." limit 1";
$nexts = $db->getFetchQuery($sql);
$sql = "SELECT wm_id, wm_title, wm_wdate FROM sp_wm_".$s_row['wm_table']." ".$WHERE." and (wm_parent>".$b_row['wm_parent']." or (wm_parent=".$b_row['wm_parent']." && wm_num>".$b_row['wm_num'].")) order by ".$s_row['wm_orderby']."";
$prev_list = $db->getFetchQueryAll($sql);
}
$idx_next = $nexts['wm_id'];
$title_next = $nexts['wm_title'];
$idx_prev = $prevs['wm_id'];
$title_prev = $prevs['wm_title'];
$wdate_prev = substr($prevs['wm_wdate'], 0, 10);
// 댓글
if($b_auth['comment']){
$sql = "SELECT *, left(wm_wdate,10) as wdate FROM sp_wm_".$s_row['wm_table']."_comment WHERE wm_bid='".$b_row['wm_id']."' order by wm_id desc";
$c_list = $db->getFetchQueryAll($sql);
}
}
// 답글 작성시 내용처리
if($mode=='reply'){
$parent_row = $b_row;
$b_row = [];
$b_row['wm_ca'] = $parent_row['wm_ca'];
$b_row['wm_num'] = $parent_row['wm_num'];
$b_row['wm_reply'] = $parent_row['wm_reply'];
$b_row['wm_parent'] = $parent_row['wm_parent'];
$b_row['wm_depth'] = $parent_row['wm_depth'];
$b_row['wm_notice'] = $parent_row['wm_notice'];
$b_row['wm_secret'] = $parent_row['wm_secret'];
$b_row['wm_title'] = "Re : ".$parent_row['wm_title'];
$b_row['wm_content'] = $parent_row['wm_content']."
-----------------------------------------원문내용-----------------------------------------";
}
// 쌍따옴표 처리
$b_row['wm_title'] = str_replace('"',""",$b_row['wm_title']);
// $b_row['wm_content'] = str_replace('"',""",$b_row['wm_content']);
// $b_row['wm_content_m'] = str_replace('"',""",$b_row['wm_content_m']);
if($b_row['wm_name']=='') $b_row['wm_name'] = $_SESSION['mb_name'];
if($lecture2!='' && $b_row['wm_lecture']=='') $b_row['wm_lecture'] = $lecture2;
if($cate!='' && $b_row['wm_ca']=='') $b_row['wm_ca'] = $cate;
if($b_row['wm_usage']=='') $b_row['wm_usage'] = 'A';
//이미지 태그 없애기
$b_row['wm_content'] = str_replace("";
$skinPage = "skn_bbs_write.html";
}
else if($mode=='pwview' || $mode=='pwmodify' || $mode=='pwdel' || $mode=='pwcdel') {
echo "";
$skinPage = "skn_bbs_password.html";
}
else {
echo "";
$skinPage = "skn_bbs_view.html";
$lec_info = $db->getFetchQueryOne("SELECT wm_lec_type FROM sp_lecture WHERE wm_id = '".$b_row['wm_lecture']."'");
if($lec_info['wm_lec_type'] == "A") $url = "regular";
else $url = "lecture";
}
}
?>