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();
}
