function JQ_printCertificate() { global $JLMS_DB, $my, $JLMS_CONFIG; global $JLMS_LANGUAGE, $JLMS_CONFIG; JLMS_require_lang($JLMS_LANGUAGE, 'quiz.lang', $JLMS_CONFIG->get('default_language')); require _JOOMLMS_FRONT_HOME . '/includes/quiz/quiz_language.php'; global $jq_language; $stu_quiz_id = intval(mosGetParam($_GET, 'stu_quiz_id', 0)); $user_unique_id = strval(mosGetParam($_GET, 'user_unique_id', '')); $course_id = $JLMS_CONFIG->get('course_id', 0); $query = "SELECT sq.c_passed, sq.c_student_id, sq.c_total_score, sq.unique_id, sq.c_date_time as completion_datetime," . "\n qtq.c_full_score, qtq.c_title, qtq.c_certificate, qtq.course_id, qtq.c_id as quiz_id, qtq.course_id" . "\n FROM #__lms_quiz_r_student_quiz AS sq, #__lms_quiz_t_quiz AS qtq" . "\n WHERE sq.c_id = '" . $stu_quiz_id . "' and qtq.c_id = sq.c_quiz_id"; $JLMS_DB->SetQuery($query); $stu_quiz = $JLMS_DB->LoadObjectList(); if (count($stu_quiz) && $course_id) { $stu_quiz = $stu_quiz[0]; $query = "SELECT course_id FROM #__lms_quiz_t_quiz WHERE c_id = '" . $stu_quiz->quiz_id . "'"; $JLMS_DB->SetQuery($query); $quiz_course = $JLMS_DB->LoadResult(); if ($user_unique_id == $stu_quiz->unique_id && $quiz_course == $course_id) { $JLMS_ACL =& JLMSFactory::getACL(); $i_can_view_these_results = false; if ($my->id == $stu_quiz->c_student_id) { // user who passed the quiz $i_can_view_these_results = true; } elseif ($JLMS_ACL->isCourseTeacher()) { // course teacher $i_can_view_these_results = true; } elseif ($JLMS_ACL->isStaff() && isset($JLMS_ACL->_staff_learners) && is_array($JLMS_ACL->_staff_learners) && in_array($stu_quiz->c_student_id, $JLMS_ACL->_staff_learners)) { //users CEO $i_can_view_these_results = true; } if ($i_can_view_these_results) { $user_id = $stu_quiz->c_student_id; if ($stu_quiz->c_passed != 1) { echo $jq_language['quiz_mes_notpassed']; die; } if (!$stu_quiz->c_certificate) { echo $jq_language['quiz_mes_notavail']; die; } require_once _JOOMLMS_FRONT_HOME . "/includes/lms_certificates.php"; $query = "SELECT * FROM #__users WHERE id = '" . $user_id . "'"; $JLMS_DB->SetQuery($query); $u_data = $JLMS_DB->LoadObjectList(); $tm_obj = new stdClass(); $tm_obj->username = isset($u_data[0]->username) ? $u_data[0]->username : ''; $tm_obj->name = isset($u_data[0]->name) ? $u_data[0]->name : ''; $tm_obj->crtf_spec_answer = ''; $course_id = $stu_quiz->course_id; $tm_obj->is_preview = false; $tm_obj->quiz_id = $stu_quiz->quiz_id; $tm_obj->quiz_name = $stu_quiz->c_title; $tm_obj->stu_quiz_id = $stu_quiz_id; $tm_obj->crtf_date = strtotime($stu_quiz->completion_datetime); $user = new stdClass(); $user->id = isset($u_data[0]->id) ? $u_data[0]->id : 0; $user->username = isset($u_data[0]->username) ? $u_data[0]->username : ''; $user->name = isset($u_data[0]->name) ? $u_data[0]->name : ''; $user->email = isset($u_data[0]->email) ? $u_data[0]->email : ''; JLMS_Certificates::JLMS_outputCertificate($stu_quiz->c_certificate, $stu_quiz->course_id, $tm_obj, $user); } } } echo $jq_language['quiz_mes_notavail']; }