<th><?php echo get_lang('AllAttempts'); ?> </th> </tr> <?php $csv_content[] = array(); $csv_content[] = array(get_lang('Exercises'), get_lang('LearningPath'), get_lang('AvgCourseScore'), get_lang('Attempts')); $t_quiz = Database::get_course_table(TABLE_QUIZ_TEST); $sql = "SELECT quiz.title, id FROM " . $t_quiz . " AS quiz\n WHERE\n quiz.c_id = " . $info_course['real_id'] . " AND\n (quiz.session_id = {$sessionId} OR quiz.session_id = 0) AND\n active IN (0, 1)\n ORDER BY quiz.title ASC "; $result_exercices = Database::query($sql); $i = 0; if (Database::num_rows($result_exercices) > 0) { while ($exercices = Database::fetch_array($result_exercices)) { $exercise_id = intval($exercices['id']); $count_attempts = Tracking::count_student_exercise_attempts($student_id, $courseInfo['real_id'], $exercise_id, 0, 0, $sessionId, 2); $score_percentage = Tracking::get_avg_student_exercise_score($student_id, $course_code, $exercise_id, $sessionId, 1, 0); if (!isset($score_percentage) && $count_attempts > 0) { $scores_lp = Tracking::get_avg_student_exercise_score($student_id, $course_code, $exercise_id, $sessionId, 2, 1); $score_percentage = $scores_lp[0]; $lp_name = $scores_lp[1]; } else { $lp_name = '-'; } $lp_name = !empty($lp_name) ? $lp_name : get_lang('NoLearnpath'); if ($i % 2) { $css_class = 'row_odd'; } else { $css_class = 'row_even'; } echo '<tr class="' . $css_class . '"><td>' . $exercices['title'] . '</td>';
<th><?php echo get_lang('AllAttempts'); ?> </th> </tr> <?php $csv_content[] = array(); $csv_content[] = array(get_lang('Exercices'), get_lang('Score'), get_lang('Attempts')); $t_quiz = Database::get_course_table(TABLE_QUIZ_TEST); $sql_exercices = "SELECT quiz.title, iid FROM " . $t_quiz . " AS quiz\n\t\t\t\t\t\t WHERE quiz.c_id = " . $courseId . " AND\n\t\t\t\t\t\t \t\tactive='1' AND\n\t\t\t\t\t\t\t\t(quiz.session_id = {$session_id} OR quiz.session_id = 0)\n ORDER BY quiz.title ASC "; $result_exercices = Database::query($sql_exercices); $i = 0; if (Database::num_rows($result_exercices) > 0) { while ($exercices = Database::fetch_array($result_exercices)) { $exercise_id = intval($exercices['iid']); $count_attempts = Tracking::count_student_exercise_attempts($student_id, $courseId, $exercise_id, 0, 0, $session_id); $score_percentage = Tracking::get_avg_student_exercise_score($student_id, $courseId, $exercise_id, $session_id); $csv_content[] = array($exercices['title'], $score_percentage . '%', $count_attempts); if ($i % 2) { $css_class = 'row_odd'; } else { $css_class = 'row_even'; } echo '<tr class="' . $css_class . '"><td>' . $exercices['title'] . '</td>'; echo '<td>'; if ($count_attempts > 0) { echo $score_percentage . '%'; } else { echo '-'; $score_percentage = 0; }