." AND r.USER_ID = '$user_id' "
." WHERE s.EXAM_SEQ = e.SEQ "
." AND s.CLASS_ID = '$p_class_id' "
." ORDER BY s.PLAN_ILSI ";
$res = $db->query($sql);
if (PEAR::isError($db)) {
die($db->getMessage());
}
// 편집
$iSeq=0;
while ($res->fetchInto($row)) {
if (!$tpl->setCurrentBlock("row")) Error("setCurrentBlock");
$exam_seq = call_encrypt($user_id,$row[5]);
$exam_sch_seq = call_encrypt($user_id,$row[6]);
$tpl->setVariable("SEQ" , $row[0]); // 시컨스 넘버
$tpl->setVariable("NAME" , $row[1]); // 이름
$tpl->setVariable("EXAM_SCORE" , $row[2]); // 점수
$tpl->setVariable("EXAM_PASS" , $row[3]); // 합격유무
$tpl->parseCurrentBlock("row");
// parse outter block
if (!$tpl->parse("row")) Error("parseCurrentBlock");
}
// print the output
$tpl->show();
?>
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.">");
}
}
