selectId(); // Save clicking order $answerOrderId = count($_SESSION['exerciseResult'][$questionId]['ids']) + 1; if ($_GET['answerId'] == "0") { // click is NOT on a hotspot $hit = 0; $answerId = null; } else { // user clicked ON a hotspot $hit = 1; $answerId = api_substr($_GET['answerId'], 22, 2); // Save into session $_SESSION['exerciseResult'][$questionId][$answerId] = $hit; } //round-up the coordinates $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_main_table(TABLE_STATISTIC_TRACK_E_HOTSPOT); // Save into db $params = [ 'user_id' => api_get_user_id(), 'course_id' => $courseCode, 'quiz_id' => $exerciseId, 'question_id' => $questionId, 'answer_id' => $answerId, 'correct' => $hit, 'coordinate' => $coordinates, ]; // Save insert id into session if users changes answer. $insert_id = Database::insert($TBL_TRACK_E_HOTSPOT, $params); $_SESSION['exerciseResult'][$questionId]['ids'][$answerOrderId] = $insert_id;