getBanerList('sample_lecture'); } if($_GET[sampleMode]=='Y'){ $sql = "SELECT b.lec_content, a.lec_name, a.intro, a.sampleLink, a.`teacher_name`, a.`lec_level`, a.`lec_process`, a.`lec_su`, a.`lec_term`, a.book_type, a.lec_real_price,a.no AS lec_code, a.handout_img, c.`book_code`, d.`book_id`, d.`book_name`, d.`book_img`, d.`amount` AS book_price, e.no AS middle_cart, e.`name` AS middle_name, f.`teacher_id` FROM lecture as a JOIN lecture_kang as b ON a.no=b.lecture_no LEFT JOIN `LecToBook` AS c ON a.`no` = c.`lec_code` LEFT JOIN `book_info` AS d ON c.`book_code` = d.`book_id` LEFT JOIN Category_middle AS e ON a.`middle_cart` = e.`no` LEFT JOIN teacher_info AS f ON a.no = f.lec_code WHERE a.no=".$_GET["lec_code"]." AND a.lec_state = 2 AND a.sampleLink = b.leck_kang_name"; }else{ $sql = "SELECT a.lec_content, b.lec_name, b.intro FROM lecture_kang as a JOIN lecture as b WHERE lecture_no=".$_GET["lec_code"]." AND leck_kang_name=".$_GET["lec_num"]." AND a.lecture_no = b.no"; } $db->execute($sql); $data = $db->get_db_data(); if(empty($data)){ alertClose('해당 강의는 수강 가능한 강의가 아닙니다.'); } $lectureData = $data; $lec_kang=1; $listMode = $data[intro]; $title_name = $data[lec_name]; $title_num = $_GET[lec_num]."강"; $title_content = $title_num." /". $data[lec_content]; $speed_rate = $_GET[speed_rate]; //화면 화질 $idx = $_GET[idx]; //index값 $lec_code = $_GET[lec_code]; //강의코드 $lec_num = $_GET[lec_num]; //강의차수 $rate = $_GET[rate]; //화면비율 if($_GET['spped_rate']==""){ $speed_rate =700; } if($_GET[sampleMode] != ""){ if($_GET[sampleMode]=="Y"){ $sampleMode="Y"; $sub_text = "샘플강의"; $title_content =""; $title_num = "샘플"; $count_su=1; }else if($_GET['sampleMode']=="O"){ $sampleMode="O"; $sub_text = "오리엔테이션 강의"; $title_content =""; $title_num = "OT"; } }else{ $sampleMode="N"; $title_num = $lec_num."강"; $cut=60; $sub_len = strlen($data['lec_content']); $sub_text = $data['lec_content']; $len_cut = $cut -1; $sub_text = substr($sub_text,0, $cut-(($cut+$len_cut+1)%2)); if($sub_len > $cut){ $sub_text.="..."; } } /////////////////////강의 리스트 출력//////////////////// $title = "

강의명".$title_name."

"; $title.="

".$title_num."".$sub_text."

"; if($_GET[sampleMode]=='Y'){ $list = "
    "; }else{ $list = "
      "; } if($sampleMode == "N"){ $sql2 = "SELECT link_num, link_title, position FROM lec_link_list WHERE lec_code=".$lec_code." AND lec_no=".$lec_num." ORDER BY no"; $res2 = mysql_query($sql2); $list_su = mysql_num_rows($res2); if($list_su>0){ while($row2=mysql_fetch_array($res2)){ $time = explode(":",$row2['position']); $time_min = intval($time[0]); $time_sec = intval($time[1]); $list.= "
    1. ".$row2['link_title']."
      2. \n"; } }else{ $sql2 = "SELECT lec_content,leck_kang_name FROM lecture_kang WHERE lecture_no='".$lec_code."' AND leck_kang_name>0 order by no asc"; if($_SERVER["REMOTE_ADDR"] == '183.98.58.18'){echo $sql2;} $res2 = mysql_query($sql2); $list_su = mysql_num_rows($res2); while($row2=mysql_fetch_array($res2)){ $kang_id = 'kang'.$lec_kang; $lec_content = $row2["lec_content"]; $kang_name = $row2["leck_kang_name"]; if($lec_num==$kang_name){ $class_type="on"; }else{ $class_type=""; } $list.= "
    2. ".$lec_kang."강".$lec_content."
      3. \n"; $lec_kang++; } } }else{ $list.= "
    3. ".$title_num."".$sub_text."
      4. \n"; } $list.="
    "; //////////////////////////////////////////////////////////// ///////////////OT강의 영상 화질 버튼 제거///////////////// if($sampleMode!="O"){ $btn="

    HD일반

    "; } //////////////////////////////////////////////////////////// ///////////////////이어듣기 여부 확인////////////////////// if($sampleMode=="N"){ $sql3 = "SELECT position FROM lesson_pos WHERE idx=".$idx." AND lesson=".$lec_code." AND seq=".$lec_num; $db->execute($sql3); $data2 = $db->get_db_data(); if($data2[position]!=''){ $src = "/player/rate21/lesson_pos.php?idx=".$idx."&lec_code=".$lec_code."&lec_num=".$lec_num; }else{ $pos=0; if ($_SESSION['user_id'] == 'shinjh2040') { $src = "/aquanplayer/index.html?lec_code=" . $lec_code . "&lec_num=" . $lec_num . "&lec_type=a&speed_rate=" . $speed_rate . "&sampleMode=" . $sampleMode . "&listMode=" . $listMode . "&idx=" . $idx . "&pos=" . $pos . "&rate=" . $rate; } else { $src = "/AquaPlayer/Player_Auth2.php?lec_code=".$lec_code."&lec_num=".$lec_num."&lec_type=a&speed_rate=".$speed_rate."&sampleMode=".$sampleMode."&listMode=".$listMode."&idx=".$idx."&pos=".$pos."&rate=".$rate; } //}else{ // $src = "/AquaPlayer/Player_Auth2_before.php?lec_code=".$lec_code."&lec_num=".$lec_num."&lec_type=a&speed_rate=".$speed_rate."&sampleMode=".$sampleMode."&listMode=".$listMode."&idx=".$idx."&pos=".$pos."&rate=".$rate; //} } }else{ $pos=0; //if($_SERVER[REMOTE_ADDR]=='211.222.90.98' || $_SERVER[REMOTE_ADDR]=='121.135.246.236' || $_SERVER[REMOTE_ADDR]=='211.222.90.119'){ //if($_SERVER["REMOTE_ADDR"]=="220.85.96.240"){ $src = "/jwPlayer/player.php?lec_code=".$lec_code."&lec_num=".$lec_num."&lec_type=a&speed_rate=".$speed_rate."&sampleMode=".$sampleMode."&listMode=".$listMode."&idx=".$idx."&pos=".$pos."&rate=".$rate; // }else{ // //$src = "/jwPlayer/player.php?lec_code=".$lec_code."&lec_num=".$lec_num."&lec_type=a&speed_rate=".$speed_rate."&sampleMode=".$sampleMode."&listMode=".$listMode."&idx=".$idx."&pos=".$pos."&rate=".$rate; // $src = "/AquaPlayer/Player_Auth2.php?lec_code=".$lec_code."&lec_num=".$lec_num."&lec_type=a&speed_rate=".$speed_rate."&sampleMode=".$sampleMode."&listMode=".$listMode."&idx=".$idx."&pos=".$pos."&rate=".$rate; // } //}else{ // $src = "/AquaPlayer/Player_Auth2_before.php?lec_code=".$lec_code."&lec_num=".$lec_num."&lec_type=a&speed_rate=".$speed_rate."&sampleMode=".$sampleMode."&listMode=".$listMode."&idx=".$idx."&pos=".$pos."&rate=".$rate; //} } //////////////////////////////////////////////////////////// if($_GET['sampleMode']=='Y') { // 강의정보 $lecLevelArr = array( 1 => '입문', 2 => '기본', 3 => '응용', 4 => '심화', 5 => '실전', 6 => '기초', 7 => '기출' ); $lecProcessArr = array( 1 => '정규강좌', 2 => '특강', 3 => '일반영어', 4 => '정규강좌', 5 => '모의고사' ); $levelArr = ''; $lectureLevel = explode(',', $lectureData['lec_level']); if (!empty($lectureLevel)){ foreach ($lectureLevel as $key => $value) { $levelArr[] = $lecLevelArr[$value]; } } $totalPrice = $lectureData['lec_real_price']; // 추천강의 해당강의 선생님만 나오게 요청 $sql = "SELECT GROUP_CONCAT(teacher_no) teacher_no FROM lecture_teacher_join WHERE lec_no=".$lec_code; $db->execute($sql); $data3 = $db->get_db_data(); $teacher_no_in = $data3["teacher_no"]; $sql = "SELECT a.`lec_name`, a.`teacher_name`, a.big_cart, a.no AS lec_code, a.rate, a.sampleLink, c.`book_id`, c.`book_img`, d.teacher_id, a.book_type, a.handout_img FROM lecture AS a INNER JOIN lecture_list_2018 as f ON a.no = f.lec_no LEFT JOIN LecToBook AS b ON a.`no` = b.`lec_code` LEFT JOIN book_info AS c ON b.`book_code` = c.`book_id` LEFT JOIN teacher_info AS d ON a.no = d.lec_code LEFT JOIN teacher_list AS e ON d.`teacher_id` = e.`mem_id` WHERE a.middle_cart = '{$lectureData['middle_cart']}' AND a.lec_state = 2 AND a.no != '{$lec_code}' #AND a.lec_level REGEXP '".implode('|',$lectureLevel)."' AND (a.lec_join IS NULL OR a.lec_join = '') AND e.`mem_id` NOT IN ('kang918','grammaniac','hayacap65','jr0712','ericajeong') /* 해당 선생님 추천강의 제외 */ AND f.teacher_no in ({$teacher_no_in}) group by a.no ORDER BY a.lec_level ASC, a.no DESC LIMIT 5"; $recommendLecture = $db->getAll($sql,'ARRAY'); } ?>

    해커스편입 | 동영상

    빠른수강신청

    • · 교수님

    • · 영역

    • · 단계

    • · 강의수

      강

    • · 수강기간

      일

    • · 교재명

    • 총 금액 0원
    장바구니 바로결제
    장바구니에 정상적으로
    저장되었습니다.
    장바구니로 이동 닫기
    추천강의가 없습니다.
    copyright (c) 2012 HackersUT ALL RIGHT RESERVED