'A' and wm_usage_ag_code like '%"._AGENCY_CODE."%')) AND wm_status='Y' and wm_id=".$lecture_idx.""; $row = $db->getFetchQuery($sql); $fpath = IMG_S3.'intra/lecture/'; if($row["wm_menu_url"] ){ alert("", $row["wm_menu_url"], ""); exit(); } if(empty($row)) alert('잘못된 접속입니다.'); // 인젝션작업중 임시 주석 if($row['wm_lec_type'] == "A") { echo ""; } // 강사 포트폴리오 $tb_code = substr($_TB['b_portfolio'],6); $where_qry = ""; if(isset($_SESSION['mb_official']) && $_SESSION['mb_official'] == 'Y') $where_qry = " or b.wm_usage='B' "; $sql = "SELECT b.wm_id, b.wm_lecture, b.wm_title, b.wm_1, b.wm_2, b.wm_3, date_format(b.wm_wdate,'%y.%m.%d') as wdate, t.wm_filename FROM ".$_TB['b_portfolio']." AS b LEFT JOIN (SELECT wm_bid, wm_filename FROM ".$_TB['board_file']." WHERE wm_table='".$tb_code."' AND wm_num=0) AS t ON b.wm_id=t.wm_bid WHERE b.is_del='N' and b.is_temp='N' and b.wm_status='Y' and b.wm_business_code = '"._BIZ_CODE."' AND (b.wm_usage='A' ".$where_qry." or (b.wm_usage<>'A' and b.wm_usage_ag_code like '%"._AGENCY_CODE."%')) and wm_lecture=".$lecture_idx." ORDER BY wm_id DESC limit 4"; $portfolio = $db->getFetchQueryAll($sql); $fpath_board = IMG_S3; // 정규과정 코드 $sql2 ="SELECT wm_pl_no FROM ".$_TB['lecture_rel']." WHERE wm_lec_no=".$lecture_idx." ORDER BY wm_lec_sort asc, wm_id asc"; $wm_regular = $db->getFetchQueryOne($sql2); ?>