Esempio n. 1
0
 /**
  * This function deletes a survey question and all its options
  *
  * @param integer $survey_id the id of the survey
  * @param integer $question_id the id of the question
  * @param integer $shared
  *
  * @todo also delete the answers to this question
  *
  * @author Patrick Cool <*****@*****.**>, Ghent University
  * @version March 2007
  */
 public static function delete_survey_question($survey_id, $question_id, $shared = false)
 {
     $course_id = api_get_course_int_id();
     // Table definitions
     $table_survey_question = Database::get_course_table(TABLE_SURVEY_QUESTION);
     if ($shared) {
         survey_manager::delete_shared_survey_question($survey_id, $question_id);
     }
     // Deleting the survey questions
     $sql = "DELETE FROM {$table_survey_question}\n\t\t        WHERE\n\t\t            c_id = {$course_id} AND\n\t\t            survey_id='" . Database::escape_string($survey_id) . "' AND\n\t\t            question_id='" . Database::escape_string($question_id) . "'";
     Database::query($sql);
     // Deleting the options of the question of the survey
     survey_manager::delete_survey_question_option($survey_id, $question_id, $shared);
 }
Esempio n. 2
0
    /**
     * This function deletes a survey question and all its options
     *
     * @param integer $survey_id the id of the survey
     * @param integer $question_id the id of the question
     * @param integer $shared
     *
     * @todo also delete the answers to this question
     *
     * @author Patrick Cool <*****@*****.**>, Ghent University
     * @version March 2007
     */
    public static function delete_survey_question($survey_id, $question_id, $shared = false)
    {
        $course_id = api_get_course_int_id();
        // Table definitions
        $table_survey_question 	= Database :: get_course_table(TABLE_SURVEY_QUESTION);
        if ($shared) {
            survey_manager::delete_shared_survey_question($survey_id, $question_id);
        }

        // Deleting the survey questions
        $sql = "DELETE FROM $table_survey_question
		        WHERE
		            c_id = $course_id AND
		            survey_id='".intval($survey_id)."' AND
		            question_id='".intval($question_id)."'";
        Database::query($sql);

        // Deleting the options of the question of the survey
        survey_manager::delete_survey_question_option($survey_id, $question_id, $shared);
    }