chamilo / chamilo-lms

     * @author Patrick Cool <[email protected]>, Ghent University

     * @version January 2007

     */

    public static function delete_all_survey_questions_options($survey_id, $shared = false)

    {

        // Table definitions

        $table_survey_question_option = Database :: get_course_table(TABLE_SURVEY_QUESTION_OPTION);

        $course_id = api_get_course_int_id();

        $course_condition = " c_id = $course_id AND ";

        if ($shared) {

            $course_condition = "";

            $table_survey_question_option = Database :: get_main_table(TABLE_MAIN_SHARED_SURVEY_QUESTION_OPTION);

        }

        $sql = "DELETE FROM $table_survey_question_option

                WHERE $course_condition survey_id='".intval($survey_id)."'";

        // Deleting the options of the survey questions

        Database::query($sql);

        return true;

    }

    /**

     * @author Julio Montoya

     * @version March 2007

     */

    public static function delete_survey_question_option($survey_id, $question_id, $shared = false)

    {

        $course_id = api_get_course_int_id();

        $course_condition = " c_id = $course_id AND ";

        // Table definitions

        $table_survey_question_option = Database :: get_course_table(TABLE_SURVEY_QUESTION_OPTION);

        if ($shared) {

            $course_condition = "";

            $table_survey_question_option = Database :: get_main_table(TABLE_MAIN_SHARED_SURVEY_QUESTION_OPTION);

        }

        // Deleting the options of the survey questions

        $sql = "DELETE from $table_survey_question_option

		        WHERE

		            $course_condition survey_id='".intval($survey_id)."' AND

		            question_id='".intval($question_id)."'";

        Database::query($sql);

        return true;

    }

    /**

     * SURVEY ANSWERS FUNCTIONS