chamilo / chamilo-lms

            $course_id = api_get_course_id();

            // get search_did

            $tbl_se_ref = Database::get_main_table(TABLE_MAIN_SEARCH_ENGINE_REF);

            if ($addQs || $rmQs) {

                //there's only one row per question on normal db and one document per question on search engine db

                $sql = 'SELECT * FROM %s

                    WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_second_level=%s LIMIT 1';

                $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_QUIZ, $this->id);

            } else {

                $sql = 'SELECT * FROM %s

                    WHERE course_code=\'%s\' AND tool_id=\'%s\'

                    AND ref_id_high_level=%s AND ref_id_second_level=%s LIMIT 1';

                $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_QUIZ, $exerciseId, $this->id);

            }

            $res = Database::query($sql);

            if (Database::num_rows($res) > 0 || $addQs) {

                }

                if ($did || $rmQs) {

                    // save it to db

                    if ($addQs || $rmQs) {

                        $sql = "DELETE FROM %s

                            WHERE course_code = '%s' AND tool_id = '%s' AND ref_id_second_level = '%s'";

                        $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_QUIZ, $this->id);

                    } else {

                        $sql = "DELETE FROM %S

                            WHERE

                                course_code = '%s'

                                AND tool_id = '%s'

                                AND tool_id = '%s'

                                AND ref_id_high_level = '%s'

                                AND ref_id_second_level = '%s'";

                        $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_QUIZ, $exerciseId, $this->id);

                    }

                    Database::query($sql);

                    if ($rmQs) {

                        if (!empty($question_exercises)) {