<? // 권한 검사 $connect=dbConn(); $member=member_info(); if($member[level] > 9) { Error("제한된 기능입니다."); } // 사용자 ID $user_id=$member[user_id]; // 자기가 관리한 반만 볼 수 있도록 제한 // call pear init & call call_pear_init(); require_once("DB.php"); require_once("HTML/Template/IT.php"); // Template $tpl = new HTML_Template_IT("/home/hosting_users/academysoft/www/templates"); if(!$tpl->loadTemplatefile("movie_view.tpl.htm", true, true)) Error("loadTemplatefile"); // DB 접속 $db =& DB::connect(call_pear_db_dsn()); if (PEAR::isError($db)) { die($db->getMessage()); } // 암호풀기 $movie_seq = (int)call_decrypt($user_id,$p_movie_seq);
function func_reg_ing($bookid, $examid, $userid, $examlgubun, $examsgubun, $elapsedtime) { // 권한 검사 $connect=dbConn(); $member=member_info(); call_pear_init(); require_once("DB.php"); // DB 접속 $db =& DB::connect(call_pear_db_dsn()); if (PEAR::isError($db)) { die($db->getMessage()); } //****************************** // CLASS_ID 찾기 $sql = "SELECT TB_REG1.CLASS_ID " ." FROM TB_CLASS, TB_REG1 " ." WHERE TB_REG1.USER_ID = '$userid' " ." AND BOOK_ID = '$bookid' " ." AND TB_REG1.CLASS_ID = TB_CLASS.CLASS_ID"; $res = $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $class_id = $row[0]; } //****************************** // TB_EXAM.SEQ 찾기 $sql = "SELECT SEQ " ." FROM TB_EXAM " ." WHERE BOOK_ID = '$bookid' " ." AND EXAM_ID = '$examid' "; $res = $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $exam_seq = $row[0]; } //****************************** // TB_EXAM_SCH.SEQ 찾기 $sql = "SELECT SEQ " ." FROM TB_EXAM_SCH " ." WHERE CLASS_ID = '$class_id' " ." AND EXAM_SEQ = '$exam_seq' "; $res = $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $exam_sch_seq = $row[0]; } // select 문제번호를 불러온다. $sql = "SELECT SEQ " ." FROM TB_EXAM_REC " ." WHERE USER_ID = '$userid' " ." AND EXAM_SCH_SEQ = '$exam_sch_seq' "; echo $sql; $res = $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $r_seq = $row[0]; } // TB_EXAM_REC RECORD UPDATE $sth = $db->prepare("UPDATE TB_EXAM_REC SET ELAPSED_TIME = ? WHERE SEQ = ?"); $data = array($elapsedtime, $r_seq); $db->execute($sth, $data ); echo "update complete : "; echo $elapsedtime; } // end function func_reg_ing
function func_reg_Skip($bookid, $examid, $userid, $p_examlgubun, $p_examsgubun, $skipno, $elapsedtime) { // 권한 검사 $connect=dbConn(); $member=member_info(); call_pear_init(); require_once("DB.php"); // DB 접속 $db =& DB::connect(call_pear_db_dsn()); if (PEAR::isError($db)) { die($db->getMessage()); } //****************************** // CLASS_ID 찾기 $sql = "SELECT TB_REG1.CLASS_ID " ." FROM TB_CLASS, TB_REG1 " ." WHERE TB_REG1.USER_ID = '$userid' " ." AND BOOK_ID = '$bookid' " ." AND TB_REG1.CLASS_ID = TB_CLASS.CLASS_ID"; $res = $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $class_id = $row[0]; } //****************************** // TB_EXAM.SEQ 찾기 $sql = "SELECT SEQ " ." FROM TB_EXAM " ." WHERE BOOK_ID = '$bookid' " ." AND EXAM_ID = '$examid' "; $res = $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $exam_seq = $row[0]; } //****************************** // TB_EXAM_SCH.SEQ 찾기 $sql = "SELECT SEQ " ." FROM TB_EXAM_SCH " ." WHERE CLASS_ID = '$class_id' " ." AND EXAM_SEQ = '$exam_seq' "; $res = $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $exam_sch_seq = $row[0]; } //****************************** $sql = "SELECT SEQ, SKIP_NO " ." FROM TB_EXAM_REC " ." WHERE EXAM_SCH_SEQ = '$exam_sch_seq' " ." AND USER_ID = '$userid' "; $res = $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $r_seq = $row[0]; } //****************************** $res = $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $r_skipno = $row[1]; } $r_skipno = $skipno."@".$r_skipno; // 문제번호 추가 // 수정 $sth = $db->prepare("UPDATE TB_EXAM_REC SET SKIP_NO = ?, UPDATE_ILSI = now(), ELAPSED_TIME = ? WHERE SEQ = ?"); $data = array($r_skipno, $elapsedtime, $r_seq); $db->execute($sth, $data ); }
function func_state_request($bookid, $examid, $userid, $examlgubun, $examsgubun) { echo $elapsedtime; // 권한 검사 $connect=dbConn(); $member=member_info(); call_pear_init(); require_once("DB.php"); // DB 접속 $db =& DB::connect(call_pear_db_dsn()); if (PEAR::isError($db)) { die($db->getMessage()); } //****************************** // CLASS_ID 찾기 $sql = "SELECT TB_REG1.CLASS_ID " ." FROM TB_CLASS, TB_REG1 " ." WHERE TB_REG1.USER_ID = '$userid' " ." AND BOOK_ID = '$bookid' " ." AND TB_REG1.CLASS_ID = TB_CLASS.CLASS_ID"; $res = $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $class_id = $row[0]; } //****************************** // TB_EXAM.SEQ 찾기 $sql = "SELECT SEQ " ." FROM TB_EXAM " ." WHERE BOOK_ID = '$bookid' " ." AND EXAM_ID = '$examid' "; $res = $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $exam_seq = $row[0]; } //****************************** // TB_EXAM_SCH.SEQ 찾기 $sql = "SELECT SEQ " ." FROM TB_EXAM_SCH " ." WHERE CLASS_ID = '$class_id' " ." AND EXAM_SEQ = '$exam_seq' "; $res = $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $exam_sch_seq = $row[0]; } $sql = "SELECT r.EXAM_START, r.EXAM_END, r.CUR_QST_SEQ, r.ELAPSED_TIME, r.RETAKE_CNT, r.SKIP_NO " ." FROM TB_EXAM_SCH s, TB_EXAM e, TB_EXAM_REC r " ." WHERE e.EXAM_ID = '$examid' " ." AND r.USER_ID = '$userid' " ." AND e.BOOK_ID = '$bookid' " ." AND r.EXAM_SCH_SEQ = '$exam_sch_seq' "; $res =& $db->query($sql); if (PEAR::isError($db)) { die($db->getMessage()); } while ($res->fetchInto($row)) { $r_examstart = $row[0]; $r_examend = $row[1]; $r_curqstseq = $row[2]; $r_elapsedtime = $row[3]; $r_retakecnt = $row[4]; $r_skipno = $row[5]; } $arr = array($r_examstart, $r_examend, $r_curqstseq, $r_elapsedtime, $r_retakecnt, $r_skipno); $rtn = implode(",", $arr); echo $rtn; }
function call_cb_pgm($board) { //$ss_job = $HTTP_SESSION_VARS['ss_job']; $ss_job = $_SESSION['ss_job']; if (!$ss_job) error("비정상적인 접근 방법입니다.(call_cb_board_check1)"); //$ss_class_id = $HTTP_SESSION_VARS['ss_class_id']; $ss_class_id = $_SESSION['ss_class_id']; if (!$ss_class_id) error("비정상적인 접근 방법입니다.(call_cb_board_check2)"); call_pear_init(); $enc_cb_pgm = call_encrypt($_SESSION["ss_user_id"],$ss_class_id); if ($board == "movie") { echo("<a href=/index.php?html=movie_list_student&p_class_id=".$ss_class_id.">"); } else if ($board == "member_list") { echo("<a href=/index.php?html=member_list&p_class_id=".$ss_class_id.">"); } else if ($board == "movie_sch_man") { echo("<a href=/index.php?html=movie_sch_man&p_class_id=".$ss_class_id.">"); } else if ($board == "movie_rec") { echo("<a href=/index.php?html=movie_rec&p_class_id=".$ss_class_id.">"); } else if ($board == "class_id_list") { echo($_SESSION['ss_class_id_list']); } else if ($board == "exam_list_student") { echo("<a href=/index.php?html=apps/exam/exam_list_student&p_class_id=".$ss_class_id.">"); } else if ($board == "exam_sch_man") { echo("<a href=/index.php?html=apps/exam/exam_sch_man&p_class_id=".$ss_class_id.">"); } else if ($board == "rec_no") { echo("<a href=/index.php?html=apps/exam/exam_rec_by_no&p_class_id=".$ss_class_id.">"); } else if ($board == "rec_student") { echo("<a href=/index.php?html=apps/exam/exam_rec_by_student&p_class_id=".$ss_class_id.">"); } }