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;