function cw_delete_survey($survey_id) { global $tables; if (!is_array($survey_id)) { $survey_id = array($survey_id); } $where = "survey_id IN ('" . implode("','", $survey_id) . "')"; foreach ($survey_id as $id) { db_query("DELETE FROM {$tables['languages_alt']} WHERE name = 'survey_name_{$id}'"); db_query("DELETE FROM {$tables['languages_alt']} WHERE name = 'survey_header_{$id}'"); db_query("DELETE FROM {$tables['languages_alt']} WHERE name = 'survey_footer_{$id}'"); db_query("DELETE FROM {$tables['languages_alt']} WHERE name = 'survey_complete_{$id}'"); } db_query("DELETE FROM {$tables['surveys']} WHERE " . $where); $ids = cw_query_column("SELECT question_id FROM {$tables['survey_questions']} WHERE " . $where); if (!empty($ids)) { foreach ($ids as $id) { db_query("DELETE FROM {$tables['languages_alt']} WHERE name = 'question_name_{$id}'"); } $aids = cw_query_column("SELECT answer_id FROM {$tables['survey_answers']} WHERE question_id IN ('" . implode("','", $ids) . "')"); if (!empty($aids)) { foreach ($aids as $id) { db_query("DELETE FROM {$tables['languages_alt']} WHERE name = 'answer_name_{$id}'"); } db_query("DELETE FROM {$tables['survey_answers']} WHERE question_id IN ('" . implode("','", $ids) . "')"); } } db_query("DELETE FROM {$tables['survey_questions']} WHERE " . $where); db_query("DELETE FROM {$tables['survey_maillist']} WHERE " . $where); cw_delete_survey_stats($survey_id); return true; }
} db_free_result($emails); } if ($cnt > 0) { $top_message = array("content" => cw_get_langvar_by_name("lbl_survey_invitations_are_sent")); } cw_header_location("index.php?target={$target}&survey_id=" . $survey_id . "&js_tab=maillist"); } elseif ($js_tab == 'instances' && $action == 'delete' && !empty($check)) { # Delete survey instance(s) db_query("DELETE FROM {$tables['survey_results']} WHERE survey_id = '{$survey_id}' AND survey_result_id IN ('" . implode("','", $check) . "')"); db_query("DELETE FROM {$tables['survey_result_answers']} WHERE survey_result_id IN ('" . implode("','", $check) . "')"); $top_message = array("content" => cw_get_langvar_by_name("txt_survey_instances_are_deleted")); cw_header_location("index.php?target={$target}&survey_id=" . $survey_id . "&js_tab=instances"); } elseif ($action == 'clear_stats' && !empty($survey_id)) { # Delete survey statistics cw_delete_survey_stats($survey_id); $top_message = array("content" => cw_get_langvar_by_name("txt_survey_statistics_is_cleared")); cw_header_location("index.php?target={$target}&survey_id=" . $survey_id . "&js_tab=stats"); } elseif ($js_tab == 'answer_texts') { if (empty($questionid)) { if (empty($as_text)) { cw_close_window(); } exit; } # Display answer comments as popup window $survey_id = cw_query_first_cell("SELECT survey_id FROM {$tables['survey_questions']} WHERE questionid = '{$questionid}'"); if (empty($survey_id)) { if (empty($as_text)) { cw_close_window(); }