$answer = array('answer' => $title, 'textbox_type' => $d['new_answers']['textbox_type'][$index], 'orderby' => $d['new_answers']['orderby'][$index], 'question_id' => $qid); $answer_id = cw_array2insert('survey_answers', $answer, $fields_to_update_answer); $answer['code'] = $edited_language; $answer['question_id'] = $qid; $answer['answer_id'] = $answer_id; cw_array2insert('survey_answers_lng', $answer, true, array('answer_id', 'code', 'answer')); } } } $top_message['content'] = cw_get_langvar_by_name('txt_survey_is_modifyed'); cw_header_location("index.php?target={$target}&survey_id={$survey_id}&js_tab=structure"); } if ($action == 'delete_structure') { if (is_array($check_answers)) { foreach ($check_answers as $val) { cw_surveys_delete_answer($val); } } if (is_array($check_questions)) { foreach ($check_questions as $val) { cw_surveys_delete_question($val); } } $top_message['content'] = cw_get_langvar_by_name('txt_survey_question_answers_are_deleted'); cw_header_location("index.php?target={$target}&survey_id={$survey_id}&js_tab=structure"); } if ($action == "delete" && !empty($check)) { # Delete question if (cw_query_first_cell("SELECT COUNT(*) FROM {$tables['survey_results']} WHERE survey_id = '{$survey_id}'") > 0) { cw_delete_survey_stats($survey_id); }
function cw_surveys_delete_question($questions) { global $tables; if (!is_array($questions)) { $questions = array($questions); } $com_str = '(' . implode("', '", $questions) . ')'; $answers = cw_query_column("select answer_id from {$tables['survey_answers']} where question_id in {$com_str}"); cw_surveys_delete_answer($answers); db_query("delete from {$tables['survey_questions']} where question_id in {$com_str}"); db_query("delete from {$tables['survey_questions_lng']} where question_id in {$com_str}"); }