chamilo / chamilo-lms

     * @param int $session_id

     * @param int $question_id

     */

    public static function delete_attempt($exe_id, $user_id, $courseId, $session_id, $question_id)

    {

        $table_track_attempt = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);

        $exe_id = intval($exe_id);

        $user_id = intval($user_id);

        $courseId = intval($courseId);

        $session_id = intval($session_id);

        $question_id = intval($question_id);

        $sql = "DELETE FROM $table_track_attempt

                WHERE

                    exe_id = $exe_id AND

                    user_id = $user_id AND

                    c_id = $courseId AND

                    session_id = $session_id AND

                    question_id = $question_id ";

        Database::query($sql);

        Event::addEvent(

            LOG_QUESTION_RESULT_DELETE,

            LOG_EXERCISE_ATTEMPT_QUESTION_ID,

            $exe_id . '-' . $question_id,

            null,

            null,

            $courseId,

            $session_id

        );

    }

    /**

     * @param $exe_id

     * @param $question_id

     * @param int $sessionId

     */

    public static function delete_attempt_hotspot($exe_id, $user_id, $courseId, $question_id, $sessionId = null)

    {

        $table_track_attempt = Database::get_main_table(TABLE_STATISTIC_TRACK_E_HOTSPOT);

        $exe_id = intval($exe_id);

        $user_id = intval($user_id);

        $courseId = intval($courseId);

        $question_id = intval($question_id);

        if (!isset($sessionId)) {

            $sessionId = api_get_session_id();

        }

        $sql = "DELETE FROM $table_track_attempt

                WHERE   hotspot_exe_id = $exe_id AND

                        hotspot_user_id = $user_id AND

                        c_id = $courseId AND

                        hotspot_question_id = $question_id ";

        Database::query($sql);

        Event::addEvent(

            LOG_QUESTION_RESULT_DELETE,

            LOG_EXERCISE_ATTEMPT_QUESTION_ID,

            $exe_id . '-' . $question_id,

            null,

            null,

            $courseId,

            $sessionId

        );

    }

    /**

     * Registers in track_e_course_access when user logs in for the first time to a course