| '.$exercices['title'].' | ';
echo '';
if (!empty($lp_name)) {
echo $lp_name;
} else {
echo '-';
}
echo ' | ';
echo '';
if ($count_attempts > 0) {
echo $score_percentage . '%';
} else {
echo '-';
$score_percentage = 0;
}
echo ' | ';
echo ''.$count_attempts.' | ';
echo '';
$sql = 'SELECT exe_id FROM ' . $tbl_stats_exercices . '
WHERE
exe_exo_id ="'.$exercise_id.'" AND
exe_user_id ="'.$student_id.'" AND
c_id = '.$courseInfo['real_id'].' AND
session_id ="'.$sessionId.'" AND
status = ""
ORDER BY exe_date DESC
LIMIT 1';
$result_last_attempt = Database::query($sql);
if (Database :: num_rows($result_last_attempt) > 0) {
$id_last_attempt = Database :: result($result_last_attempt, 0, 0);
if ($count_attempts > 0)
echo '
'.Display::return_icon('quiz.gif').'
';
}
echo ' | ';
echo '';
$all_attempt_url = "../exercice/exercise_report.php?exerciseId=$exercise_id&cidReq=$course_code&filter_by_user=$student_id&id_session=$sessionId";
echo Display::url(Display::return_icon('test_results.png', get_lang('AllAttempts'), array(), ICON_SIZE_SMALL), $all_attempt_url );
echo ' |
';
$data_exercices[$i][] = $exercices['title'];
$data_exercices[$i][] = $score_percentage . '%';
$data_exercices[$i][] = $count_attempts;
$csv_content[] = array(
$exercices['title'],
$lp_name,
$score_percentage,
$count_attempts
);
$i++;
}
} else {
echo '