123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121 |
- <?php
- /* For licensing terms, see /license.txt */
- /**
- * Saving the scores.
- * @package chamilo.exercise
- * @author
- * @version $Id: savescores.php 15602 2008-06-18 08:52:24Z pcool $
- */
- // name of the language file that needs to be included
- $language_file = 'learnpath';
- if (isset($_GET['origin']) && $_GET['origin'] == 'learnpath') {
- require_once '../newscorm/learnpath.class.php';
- require_once '../newscorm/learnpathItem.class.php';
- require_once '../newscorm/scorm.class.php';
- require_once '../newscorm/scormItem.class.php';
- require_once '../newscorm/aicc.class.php';
- require_once '../newscorm/aiccItem.class.php';
- }
- require_once '../inc/global.inc.php';
- $courseInfo = api_get_course_info();
- $_user = api_get_user_info();
- $this_section = SECTION_COURSES;
- require_once api_get_path(LIBRARY_PATH).'fileManage.lib.php';
- $documentPath = api_get_path(SYS_COURSE_PATH).$courseInfo['path']."/document";
- $test = $_REQUEST['test'];
- $full_file_path = $documentPath.$test;
- my_delete($full_file_path.$_user['user_id'].".t.html");
- $TABLETRACK_HOTPOTATOES = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_HOTPOTATOES);
- $TABLE_LP_ITEM_VIEW = Database::get_course_table(TABLE_LP_ITEM_VIEW);
- $score = $_REQUEST['score'];
- $origin = $_REQUEST['origin'];
- $learnpath_item_id = intval($_REQUEST['learnpath_item_id']);
- $lpViewId = isset($_REQUEST['lp_view_id']) ? intval($_REQUEST['lp_view_id']) : null;
- $course_id = $courseInfo['real_id'];
- $_cid = api_get_course_id();
- $jscript2run = '';
- /**
- * Save the score for a HP quiz. Can be used by the learnpath tool as well
- * for HotPotatoes quizzes. When coming from the learning path, we
- * use the session variables telling us which item of the learning path has to
- * be updated (score-wise)
- * @param string File is the exercise name (the file name for a HP)
- * @param integer Score to save inside the tracking tables (HP and learnpath)
- * @return void
- */
- function save_scores($file, $score)
- {
- global $origin, $_user, $_cid, $TABLETRACK_HOTPOTATOES;
- // if tracking is disabled record nothing
- $weighting = 100; // 100%
- $date = api_get_utc_datetime();
- if ($_user['user_id']) {
- $user_id = $_user['user_id'];
- } else {
- // anonymous
- $user_id = "NULL";
- }
- $sql = "INSERT INTO $TABLETRACK_HOTPOTATOES (exe_name, exe_user_id, exe_date, exe_cours_id, exe_result, exe_weighting) VALUES (
- '".Database::escape_string($file)."',
- ".intval($user_id).",
- '".Database::escape_string($date)."',
- '".Database::escape_string($_cid)."',
- '".Database::escape_string($score)."',
- '".Database::escape_string($weighting)."')";
- Database::query($sql);
- if ($origin == 'learnpath') {
- //if we are in a learning path, save the score in the corresponding
- //table to get tracking in there as well
- global $jscript2run;
- //record the results in the learning path, using the SCORM interface (API)
- $jscript2run .= "<script>
- $(document).ready(function() {
- //API_obj = window.frames.window.content.API;
- //API_obj = $('content_id').context.defaultView.content.API; //works only in FF
- //API_obj = window.parent.frames.window.top.API;
- API_obj = window.top.API;
- API_obj.void_save_asset('$score', '$weighting', 0, 'completed');
- });
- </script>";
- }
- }
- // Save the Scores
- save_scores($test, $score);
- // Back
- if ($origin != 'learnpath') {
- $url = "exercice.php"; // back to exercices
- $jscript2run .= '<script>'."window.open('$url', '_top', '')".'</script>';
- echo $jscript2run;
- } else {
- $htmlHeadXtra[] = $jscript2run;
- Display::display_reduced_header();
- if (!empty($course_id) && !empty($learnpath_item_id) && !empty($lpViewId)) {
- $sql = "UPDATE $TABLE_LP_ITEM_VIEW SET
- status = 'completed'
- WHERE
- c_id = $course_id AND
- lp_item_id= $learnpath_item_id AND
- lp_view_id = $lpViewId
- ";
- Database::query($sql);
- Display::display_confirmation_message(get_lang('HotPotatoesFinished'));
- } else {
- Display::display_error_message(get_lang('Error'));
- }
- Display::display_footer();
- }
|