12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 |
- <?php
- include('exercise.class.php');
- include('question.class.php');
- include('answer.class.php');
- include('../inc/global.inc.php');
- include('../inc/lib/database.lib.php');
- $courseCode = $_GET['coursecode'];
- $questionId = $_GET['questionId'];
- $coordinates = $_GET['coord'];
- $objExcercise = $_SESSION['objExercise'];
- $exerciseId = $objExcercise->selectId();
- $answerOrderId = count($_SESSION['exerciseResult'][$questionId]['ids'])+1;
- if ($_GET['answerId'] == "0")
- {
- $hit = 0;
- $answerId = NULL;
- }
- else
- {
- $hit = 1;
- $answerId = api_substr($_GET['answerId'],22,2);
-
- $_SESSION['exerciseResult'][$questionId][$answerId] = $hit;
- }
- $coords = explode('/',$coordinates);
- $coordinates = '';
- foreach ($coords as $coord) {
- list($x,$y) = explode(';',$coord);
- $coordinates .= round($x).';'.round($y).'/';
- }
- $coordinates = substr($coordinates,0,-1);
- $TBL_TRACK_E_HOTSPOT = Database::get_statistic_table(STATISTIC_TRACK_E_HOTSPOTS);
- $sql = "INSERT INTO $TBL_TRACK_E_HOTSPOT (user_id , course_id , quiz_id , question_id , answer_id , correct , coordinate ) VALUES (
- '".Database::escape_string($_user['user_id'])."',
- '".Database::escape_string($courseCode)."',
- '".Database::escape_string($exerciseId)."',
- '".Database::escape_string($questionId)."',
- '".Database::escape_string($answerId)."',
- '".Database::escape_string($hit)."',
- '".Database::escape_string($coordinates)."')";
- $result = Database::query($sql);
- $insert_id = Database::insert_id();
- $_SESSION['exerciseResult'][$questionId]['ids'][$answerOrderId] = $insert_id;
|