_('Edit A Survey')));
if (!session_loggedin() || !user_ismember($group_id,'A')) {
echo '
'._('Permission denied').'
';
survey_footer(array());
exit;
}
if (getStringFromRequest('post_changes')) {
$survey_title = $survey_title;
$survey_questions = $survey_questions;
$is_active = $is_active;
if (!isset($survey_title) || $survey_title == "")
{
$feedback .= _('Update Failed: Survey Title Required');
}
elseif (!isset($survey_questions) || $survey_questions == "")
{
$feedback .= _('Update Failed: Survey Questions Required');
}
if (!isset($survey_id) || !isset($group_id) || $survey_id == "" || $group_id == "")
{
$feedback .= _('Update Failed: Missing Data');
}
else
{
if ($is_active) {
$is_active = 1;
} else {
$is_active = 0;
}
$result = db_query_params ('UPDATE surveys SET survey_title=$1, survey_questions=$2, is_active=$3
WHERE survey_id=$4 AND group_id=$5',
array (htmlspecialchars($survey_title),
$survey_questions,
$is_active,
$survey_id,
$group_id));
if (db_affected_rows($result) < 1) {
$feedback .= _('Update Failed');
echo db_error();
} else {
$feedback .= _('Update Successful');
}
}
}
/*
Get this survey out of the DB
*/
if ($survey_id) {
$result = db_query_params ('SELECT * FROM surveys WHERE survey_id=$1 AND group_id=$2',
array ($survey_id,
$group_id));
$survey_title=db_result($result, 0, "survey_title");
$survey_questions=db_result($result, 0, "survey_questions");
$is_active=db_result($result, 0, "is_active");
}
?>
.