function JQ_FinishQuiz($quiz_id, $stu_quiz_id, $user_unique_id, $id) { global $JLMS_DB, $my, $Itemid, $JLMS_CONFIG; $ret_str = ''; require_once dirname(__FILE__) . '/ajax_quiz.class.php'; $query = "SELECT * FROM #__lms_quiz_t_quiz WHERE c_id = '" . $quiz_id . "'"; $JLMS_DB->SetQuery($query); $quiz = $JLMS_DB->LoadObjectList(); if (count($quiz)) { $quiz = $quiz[0]; } else { return $ret_str; } $quiz_params = new JLMSParameters($quiz->params); $inside_lp = intval(mosGetParam($_REQUEST, 'inside_lp', 0)); $QA = new JLMS_quiz_API($quiz_id, $inside_lp); if (!$QA->quiz_valid()) { return ''; } $toolbar_no_a = $QA->quiz_Get_NoAtToolbar(); $QA->set('stu_quiz_id', $stu_quiz_id); $QA->set('user_unique_id', $user_unique_id); $QA->quiz_ProcessStartData(); if ($QA->start_valid() && $quiz_id) { $query = "SELECT SUM(c_score) FROM #__lms_quiz_r_student_question WHERE c_stu_quiz_id = '" . $stu_quiz_id . "'"; $JLMS_DB->SetQuery($query); $user_score = $JLMS_DB->LoadResult(); if (!$user_score) { $user_score = 0; } $max_score = $QA->quiz_Get_MaxScore(); $nugno_score = $QA->get_qvar('c_passing_score', 0) * $max_score / 100; $user_passed = 0; if ($user_score >= $nugno_score) { $user_passed = 1; } $user_time = 0; $quiz_time1 = time() - date('Z'); $query = "SELECT c_date_time FROM #__lms_quiz_r_student_quiz WHERE c_id = '" . $stu_quiz_id . "'"; $JLMS_DB->SetQuery($query); $quiz_time2 = $JLMS_DB->LoadResult(); $quiz_time2a = strtotime($quiz_time2); $user_time = $quiz_time1 - $quiz_time2a; $query = "SELECT c_total_score, c_passed, c_total_time FROM #__lms_quiz_r_student_quiz WHERE c_id = '" . $stu_quiz_id . "' and c_quiz_id = '" . $quiz_id . "' and c_student_id = '" . $my->id . "'"; $JLMS_DB->SetQuery($query); $user_quiz_results_obj = $JLMS_DB->LoadObject(); if (is_object($user_quiz_results_obj)) { $user_score = $user_quiz_results_obj->c_total_score; $user_passed = $user_quiz_results_obj->c_passed; $user_time = $user_quiz_results_obj->c_total_time; } // update lms results $lms_course = $QA->get_qvar('course_id', 0); $lms_quiz = $quiz_id; $lms_user = $my->id; $lms_score = $user_score; $lms_time = $user_time; $lms_date = date('Y-m-d H:i:s', time() - date('Z')); //the same as gmdate $lms_passed = $user_passed; global $JLMS_CONFIG; if ($lms_course && $JLMS_CONFIG->get('course_id') == $lms_course) { $course_params = $JLMS_CONFIG->get('course_params'); $params = new JLMSParameters($course_params); $do_insert_new_res = false; if ($params->get('track_type', 0) == 1) { $query = "SELECT * FROM #__lms_quiz_results WHERE course_id = '" . $lms_course . "' AND quiz_id = '" . $lms_quiz . "' AND user_id = '" . $lms_user . "'"; $JLMS_DB->SetQuery($query); $old_user_results = $JLMS_DB->LoadObject(); if (is_object($old_user_results)) { if (!$lms_passed && !$old_user_results->user_passed && $lms_score > $old_user_results->user_score) { $do_insert_new_res = true; } elseif ($lms_passed && !$old_user_results->user_passed) { $do_insert_new_res = true; } elseif ($lms_passed && $old_user_results->user_passed && $lms_score > $old_user_results->user_score) { $do_insert_new_res = true; } elseif ($lms_passed && $old_user_results->user_passed && $lms_score == $old_user_results->user_score && $lms_time < $old_user_results->user_time) { $do_insert_new_res = true; } } else { $do_insert_new_res = true; } } else { $do_insert_new_res = true; } if ($do_insert_new_res) { $query = "DELETE FROM #__lms_quiz_results WHERE course_id = '" . $lms_course . "' AND quiz_id = '" . $lms_quiz . "' AND user_id = '" . $lms_user . "'"; $JLMS_DB->SetQuery($query); $JLMS_DB->query(); $query = "INSERT INTO #__lms_quiz_results (course_id, quiz_id, user_id, user_score, quiz_max_score, user_time, quiz_date, user_passed)" . "\n VALUES ('" . $lms_course . "', '" . $lms_quiz . "', '" . $lms_user . "', '" . $lms_score . "', " . intval($max_score) . ", '" . $lms_time . "', '" . $lms_date . "', '" . $lms_passed . "')"; $JLMS_DB->SetQuery($query); $JLMS_DB->query(); } } // end of lms results section $cur_tmpl = 'joomlaquiz_lms_template'; if ($cur_tmpl) { require_once dirname(__FILE__) . '/templates/' . $cur_tmpl . '/jq_template.php'; 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; #$ret_str .= "\t" . '<task>results</task>' . "\n"; $eee = $jq_language['quiz_header_fin_message']; #$ret_str .= "\t" . '<finish_msg><![CDATA['; if ($user_passed) { if ($QA->get_qvar('c_pass_message', '')) { $jq_language['quiz_user_passes'] = nl2br($QA->get_qvar('c_pass_message', '')); } } else { if ($QA->get_qvar('c_unpass_message', '')) { $jq_language['quiz_user_fails'] = nl2br($QA->get_qvar('c_unpass_message', '')); } } #$ret_str .= ']]></finish_msg>' . "\n"; $t_ar = array(); $t_ar[] = mosHTML::makeOption($user_score . " of " . $max_score, $jq_language['quiz_res_mes_score']); $t_ar[] = mosHTML::makeOption($nugno_score ? $nugno_score . " (" . $QA->get_qvar('c_passing_score', 0) . "%)" : '', $jq_language['quiz_res_mes_pas_score']); $tot_hour = floor($user_time / 3600); if ($tot_hour) { $tot_min = floor(($user_time - $tot_hour * 3600) / 60); $tot_sec = $user_time - $tot_hour * 3600 - $tot_min * 60; $tot_time = str_pad($tot_hour, 2, "0", STR_PAD_LEFT) . ":" . str_pad($tot_min, 2, "0", STR_PAD_LEFT) . ":" . str_pad($tot_sec, 2, "0", STR_PAD_LEFT); } else { $tot_min = floor($user_time / 60); $tot_sec = $user_time - $tot_min * 60; $tot_time = str_pad($tot_min, 2, "0", STR_PAD_LEFT) . ":" . str_pad($tot_sec, 2, "0", STR_PAD_LEFT); } $t_ar[] = mosHTML::makeOption($tot_time, $jq_language['quiz_res_mes_time']); if ($quiz_params->get('sh_final_page_text', 1) == 1) { $results_txt = JoomlaQuiz_template_class::JQ_show_results($jq_language['quiz_header_fin_results'], $t_ar); } else { $results_txt = ''; } $footer_ar = array(); $footer_ar[] = mosHTML::makeOption(0, $jq_language['quiz_fin_btn_review']); $footer_ar[] = mosHTML::makeOption(1, $jq_language['quiz_fin_btn_print']); $footer_ar[] = mosHTML::makeOption(2, $jq_language['quiz_fin_btn_certificate']); $footer_ar[] = mosHTML::makeOption(3, $jq_language['quiz_fin_btn_email']); $toolbar_fotter = array(); if ($QA->get_qvar('c_certificate', 0) && $user_passed) { $link_inside_1 = ampReplace($JLMS_CONFIG->get('live_site') . '/index.php?tmpl=component&option=com_joomla_lms&Itemid=' . $Itemid . '&no_html=1&task=print_quiz_cert&course_id=' . $lms_course . '&stu_quiz_id=' . $stu_quiz_id . '&user_unique_id=' . $user_unique_id); $btn_certificate = 'window.open(\'' . $link_inside_1 . '\',\'blank\');'; $footer_ar[2]->text = "<div class='back_button'><a href='javascript:void(0)' onclick=\"window.open ('" . $JLMS_CONFIG->get('live_site') . "/index.php?tmpl=component&option=com_joomla_lms&Itemid=" . $Itemid . "&no_html=1&task=print_quiz_cert&course_id=" . $lms_course . "&stu_quiz_id=" . $stu_quiz_id . "&user_unique_id=" . $user_unique_id . "','blank');\">" . $jq_language['quiz_fin_btn_certificate'] . "</a></div>"; $toolbar_footer[2] = array('btn_type' => 'certificate_fbar', 'btn_js' => $btn_certificate); } if ($QA->get_qvar('c_enable_print', 0)) { $link_inside_2 = ampReplace($JLMS_CONFIG->get('live_site') . '/index.php?tmpl=component&option=com_joomla_lms&Itemid=' . $Itemid . '&no_html=1&task=print_quiz_result&course_id=' . $lms_course . '&stu_quiz_id=' . $stu_quiz_id . '&user_unique_id='); $btn_print = 'window.open(\'' . $link_inside_2 . '\'+user_unique_id,\'blank\');'; $footer_ar[1]->text = "<div class='back_button'><a href='javascript:void(0)' onclick=\"window.open ('" . $JLMS_CONFIG->get('live_site') . "/index.php?tmpl=component&option=com_joomla_lms&Itemid=" . $Itemid . "&no_html=1&task=print_quiz_result&course_id=" . $lms_course . "&stu_quiz_id=" . $stu_quiz_id . "&user_unique_id=' + user_unique_id,'blank');\">" . $jq_language['quiz_fin_btn_print'] . "</a></div>"; $toolbar_footer[1] = array('btn_type' => 'print_fbar', 'btn_js' => $btn_print); } if ($QA->get_qvar('c_email_to', 0)) { $btn_email_to = 'jq_emailResults();'; $footer_ar[3]->text = "<div class='back_button'><a href='javascript:void(0)' onclick=\"jq_emailResults();\">" . $jq_language['quiz_fin_btn_email'] . "</a></div>"; $toolbar_footer[3] = array('btn_type' => 'email_to_fbar', 'btn_js' => $btn_email_to); } if ($QA->get_qvar('c_enable_review', 0)) { $btn_review = 'jq_startReview();'; $query = "UPDATE #__lms_quiz_r_student_quiz SET allow_review = 1 WHERE c_id = '" . $stu_quiz_id . "' and c_quiz_id = '" . $quiz_id . "' and c_student_id = '" . $my->id . "'"; $JLMS_DB->SetQuery($query); $JLMS_DB->query(); $footer_ar[0]->text = "<div class='back_button'><a href='javascript:void(0)' onclick=\"jq_startReview();\">" . $jq_language['quiz_fin_btn_review'] . "</a></div>"; $toolbar_footer[0] = array('btn_type' => 'review_fbar', 'btn_js' => $btn_review); } $footer_html_graf = ''; if ($quiz_params->get('sh_final_page_grafic', 0) == 1) { ////----barss----//// $is_pool = 0; if ($quiz_id == -1 || $quiz_id == 0) { $is_pool = 1; $quiz_id = 0; } $rows = $QA->quiz_Get_QuestionList(); // 18 August 2007 - changes (DEN) - added check for GD and FreeType support $generate_images = true; $msg = ''; if (!function_exists('imageftbbox') || !function_exists('imagecreatetruecolor')) { $generate_images = false; $sec = false; if (!function_exists('imagecreatetruecolor')) { $msg = 'This function requires GD 2.0.1 or later (2.0.28 or later is recommended).'; $sec = true; } if (!function_exists('imageftbbox')) { $msg .= ($sec ? '<br />' : '') . 'This function is only available if PHP is compiled with freetype support.'; } } // end of GD and FreeType support check if ($JLMS_CONFIG->get('temp_folder', '') && $generate_images) { // temp folder setup is ready. //--------- array of bar-images $img_arr = array(); $title_arr = array(); $count_graph = array(); global $option; for ($i = 0, $n = count($rows); $i < $n; $i++) { $row = $rows[$i]; $quest_params = new JLMSParameters($row->params); $z = 1; if (isset($row->c_pool) && $row->c_pool) { $row->c_pool_id = $row->c_pool; } else { $row->c_pool_id = $row->c_id; } $show_case = true; // if($showtype_id && !$quest_params->get('survey_question')) if (false && !$quest_params->get('survey_question')) { $show_case = false; } if ($show_case) { require_once _JOOMLMS_FRONT_HOME . "/includes/libraries/lms.lib.graph.php"; $group_id = 0; $str_user_in_groups = ''; $c_question_id = $row->c_pool_id; $obj_GraphStat = JLMS_GraphStatistics($option, $id, $quiz_id, $i, $z, $row, $c_question_id, $group_id, $str_user_in_groups); foreach ($obj_GraphStat as $key => $item) { if (preg_match_all('#([a-z]+)_(\\w+)#', $key, $out, PREG_PATTERN_ORDER)) { if ($out[1][0] == 'img') { $img_arr[$i]->{$out}[2][0] = $item; } else { if ($out[1][0] == 'title') { $title_arr[$i]->{$out}[2][0] = $item; } else { if ($out[1][0] == 'count') { $count_graph[$i]->{$out}[2][0] = $item; } } } } } } } } $footer_html_graf = JoomlaQuiz_template_class::JQ_show_results_footer_content_bars($img_arr, $title_arr, $count_graph, $id); } $ret_str .= $results_txt; // this filed shouldn't be a null - null caused errors in Safari if ($quiz_params->get('sh_final_page_fdbck', 1) == 1) { $ret_str .= '<br />'; $ret_str .= JoomlaQuiz_template_class::JQ_show_results_msg($eee, $user_passed ? $jq_language['quiz_user_passes'] : $jq_language['quiz_user_fails'], $user_passed); $ret_str .= '<br />'; } else { $ret_str .= '<br />'; } if (isset($toolbar_footer) && count($toolbar_footer) > 0) { ksort($toolbar_footer); $footer_html = JLMS_ShowToolbar($toolbar_footer, false, 'center'); $footer_html = str_replace('"components/com_joomla_lms', '"' . $JLMS_CONFIG->get('live_site') . '/components/com_joomla_lms', $footer_html); } else { $footer_html = ''; } $entire_footer_data = $footer_html . ($footer_html_graf ? '<br />' . $footer_html_graf : ''); $ret_str .= $entire_footer_data ? $entire_footer_data : ' '; } } return $ret_str; }
function JQ_SeekQuestion_nojs() { global $JLMS_DB, $my, $option, $Itemid, $JLMS_CONFIG; $ret_str = ''; $quiz_id = intval(mosGetParam($_REQUEST, 'quiz', 0)); $inside_lp = intval(mosGetParam($_REQUEST, 'inside_lp', 0)); $QA = new JLMS_quiz_API($quiz_id, $inside_lp); if (!$QA->quiz_valid()) { return ''; } $id = intval(mosGetParam($_REQUEST, 'id', 0)); $quest_num = intval(mosGetParam($_REQUEST, 'quest_num', 0)); $stu_quiz_id = intval(mosGetParam($_REQUEST, 'stu_quiz_id', 0)); $seek_quest_id = intval(mosGetParam($_REQUEST, 'seek_quest_id', 0)); $user_unique_id = strval(mosGetParam($_REQUEST, 'user_unique_id', '')); $QA->set('stu_quiz_id', $stu_quiz_id); $QA->set('user_unique_id', $user_unique_id); $QA->quiz_ProcessStartData(); // fill in start_valid private variable ?> <form action='<?php echo ampReplace($JLMS_CONFIG->get('live_site') . "/index.php?option={$option}&Itemid={$Itemid}"); ?> ' method='post' name='quest_form'> <?php if ($QA->start_valid() && $seek_quest_id) { $quiz = $QA->quiz_data; // temporary for compatibility if ($QA->time_is_up()) { return JLMS_quiz_ajax_class::JQ_TimeIsUp_nojs($quiz); } $q_data = $QA->quiz_Get_QuestionList(); $kol_quests = count($q_data); $seek_avail = false; $i = 0; foreach ($q_data as $qd) { if ($qd->c_id == $seek_quest_id) { $seek_avail = true; break; } $i++; } if ($seek_avail) { // if Seek question from the current quiz $quest_num = $i + 1; // number of question in the quiz sequence global $JLMS_LANGUAGE, $JLMS_CONFIG; JLMS_require_lang($JLMS_LANGUAGE, 'quiz.lang', $JLMS_CONFIG->get('default_language')); //require(_JOOMLMS_FRONT_HOME . "/languages/".$JLMS_CONFIG->get('default_language').'/quiz.lang.php'); require _JOOMLMS_FRONT_HOME . '/includes/quiz/quiz_language.php'; global $jq_language; if ($quiz->c_wrong_message) { $jq_language['quiz_answer_incorrect'] = htmlspecialchars(nl2br($quiz->c_wrong_message)); } if ($quiz->c_right_message) { $jq_language['quiz_answer_correct'] = htmlspecialchars(nl2br($quiz->c_right_message)); } $cur_tmpl = 'joomlaquiz_lms_template'; if ($cur_tmpl) { require_once dirname(__FILE__) . '/templates/' . $cur_tmpl . '/jq_template.php'; if (isset($q_data[$i])) { $query = "SELECT a.*, b.lpath_id FROM #__lms_learn_path_step_quiz_results as a, #__lms_learn_path_steps as b WHERE a.stu_quiz_id = '" . $stu_quiz_id . "' AND a.step_id = b.id"; $JLMS_DB->setQuery($query); $this_lpath = $JLMS_DB->LoadObject(); $toolbar = array(); if (isset($this_lpath->stu_quiz_id) && $this_lpath->stu_quiz_id == $stu_quiz_id) { if ($q_data[$i]->c_type == 10) { if (isset($q_data[$j]->c_slide) && $q_data[$j]->c_slide) { $toolbar[] = array('kol_quests' => $kol_quests, 'num_quest' => $quest_num, 'quest_score' => $q_data[$i]->c_point, 'img_btn' => 'btn_start.png', 'text_btn' => _JLMS_NEXT_ALT_TITLE, 'link_cont' => '&task=show_lpath_nojs&action=contents_lpath&course_id=' . $id . '&id=' . $this_lpath->lpath_id . '&stu_quiz_id=' . $stu_quiz_id . '&user_unique_id=' . $this_lpath->unique_id . '&step_id=' . $this_lpath->step_id . '&user_start_id=' . $this_lpath->start_id . '&quest_id=' . $seek_quest_id . '&quiz_id=' . $quiz_id . '&stu_quiz_id=' . $stu_quiz_id . ''); } else { $toolbar[] = array('kol_quests' => $kol_quests, 'num_quest' => $quest_num, 'quest_score' => $q_data[$i]->c_point, 'img_btn' => 'btn_start.png', 'text_btn' => _JLMS_NEXT_ALT_TITLE); } } else { if (isset($q_data[$j]->c_slide) && $q_data[$j]->c_slide) { $toolbar[] = array('kol_quests' => $kol_quests, 'num_quest' => $quest_num, 'quest_score' => $q_data[$i]->c_point, 'img_btn' => 'btn_complete.png', 'text_btn' => _JLMS_OK_ALT_TITLE, 'link_cont' => '&task=show_lpath_nojs&action=contents_lpath&course_id=' . $id . '&id=' . $this_lpath->lpath_id . '&stu_quiz_id=' . $stu_quiz_id . '&user_unique_id=' . $this_lpath->unique_id . '&step_id=' . $this_lpath->step_id . '&user_start_id=' . $this_lpath->start_id . '&quest_id=' . $seek_quest_id . '&quiz_id=' . $quiz_id . '&stu_quiz_id=' . $stu_quiz_id . ''); } else { $toolbar[] = array('kol_quests' => $kol_quests, 'num_quest' => $quest_num, 'quest_score' => $q_data[$i]->c_point, 'img_btn' => 'btn_complete.png', 'text_btn' => _JLMS_OK_ALT_TITLE); } } } else { if ($q_data[$i]->c_type == 10) { if (isset($q_data[$j]->c_slide) && $q_data[$j]->c_slide) { $toolbar[] = array('kol_quests' => $kol_quests, 'num_quest' => $quest_num, 'quest_score' => $q_data[$i]->c_point, 'img_btn' => 'btn_start.png', 'text_btn' => _JLMS_NEXT_ALT_TITLE, 'link_cont' => '&task=quiz_action&atask=contents&id=' . $id . '&quiz=' . $quiz_id . '&stu_quiz_id=' . $stu_quiz_id . '&user_unique_id=' . $user_unique_id . '&quest_id=' . $seek_quest_id . ''); } else { $toolbar[] = array('kol_quests' => $kol_quests, 'num_quest' => $quest_num, 'quest_score' => $q_data[$i]->c_point, 'img_btn' => 'btn_start.png', 'text_btn' => _JLMS_NEXT_ALT_TITLE); } } else { if (isset($q_data[$j]->c_slide) && $q_data[$j]->c_slide) { $toolbar[] = array('kol_quests' => $kol_quests, 'num_quest' => $quest_num, 'quest_score' => $q_data[$i]->c_point, 'img_btn' => 'btn_complete.png', 'text_btn' => _JLMS_OK_ALT_TITLE, 'link_cont' => '&task=quiz_action&atask=contents&id=' . $id . '&quiz=' . $quiz_id . '&stu_quiz_id=' . $stu_quiz_id . '&user_unique_id=' . $user_unique_id . '&quest_id=' . $seek_quest_id . ''); } else { $toolbar[] = array('kol_quests' => $kol_quests, 'num_quest' => $quest_num, 'quest_score' => $q_data[$i]->c_point, 'img_btn' => 'btn_complete.png', 'text_btn' => _JLMS_OK_ALT_TITLE); } } } echo JLMS_quiz_ajax_class::JQ_toolbar_nojs($toolbar, $q_data[$i]->c_type, 1); echo JLMS_quiz_ajax_class::JQ_GetQuestData_nojs($q_data[$i], $jq_language, $QA->get('stu_quiz_id', 0)); } } ?> <input type='hidden' name='stu_quiz_id' value='<?php echo $stu_quiz_id; ?> '/> <input type='hidden' name='user_unique_id' value='<?php echo $user_unique_id; ?> '/> <input type='hidden' name='atask' value='next'/> <input type='hidden' name='quiz' value='<?php echo $quiz_id; ?> '/> <input type='hidden' name='task' value='quiz_action'/> <input type='hidden' name='id' value='<?php echo $id; ?> '/> <input type='hidden' name='option' value='<?php echo $option; ?> '/> <?php } } ?> </form> <?php // return $ret_str; }