_('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;
}
$sql="UPDATE surveys SET survey_title='".htmlspecialchars($survey_title)."', survey_questions='$survey_questions', is_active='$is_active' ".
"WHERE survey_id='$survey_id' AND group_id='$group_id'";
$result=db_query($sql);
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) {
$sql="SELECT * FROM surveys WHERE survey_id='$survey_id' AND group_id='$group_id'";
$result=db_query($sql);
$survey_title=db_result($result, 0, "survey_title");
$survey_questions=db_result($result, 0, "survey_questions");
$is_active=db_result($result, 0, "is_active");
}
?>
.