$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);