$sql = "SELECT hasquiz FROM #__guru_program\r\n WHERE id =" . intval($id);
$db->setQuery($sql);
$db->query();
$nb_ofscores = $db->loadColumn();
$nb_ofscores = @$nb_ofscores[0];
if ($nb_ofscores != 0) {
$scores_avg_quizzes = intval($s / $nb_ofscores);
}
$certterm = $my_courses[$key]["certerm"];
if (!in_array($id, $already_edited)) {
$already_edited[] = $id;
?>
<td class="g_cell_1">
<?php
$course_details = $guruModelguruOrder->getCourses($id);
$certificateid = $guruModelguruOrder->getCertificateId($user_id, $id);
$author_name = "SELECT name FROM #__users WHERE id IN (SELECT author_id from #__guru_mycertificates where course_id=" . intval($id) . " and user_id=" . intval($user_id) . ") ";
$db->setQuery($author_name);
$author_name = $db->loadColumn();
$author_name = implode(", ", $author_name);
$date_completed = "SELECT datecertificate from #__guru_mycertificates where course_id=" . intval($id) . " and user_id=" . intval($user_id);
$db->setQuery($date_completed);
$date_completed = $db->loadResult();
$datetype = "SELECT datetype from #__guru_config WHERE id=1";
$db->setQuery($datetype);
$datetype = $db->loadResult();
$date_completed = date($datetype, strtotime($date_completed));
$sql = "SELECT id_final_exam FROM #__guru_program WHERE id=" . intval($id);
$db->setQuery($sql);
$result = $db->loadResult();
$sql = "SELECT max_score FROM #__guru_quiz WHERE id=" . intval($result);
