1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
|
<?php
// edit_feedback_question.php - Form for editing feedback questions
//
// SiT (Support Incident Tracker) - Support call tracking system
// Copyright (C) 2010-2014 The Support Incident Tracker Project
// Copyright (C) 2000-2009 Salford Software Ltd. and Contributors
//
// This software may be used and distributed according to the terms
// of the GNU General Public License, incorporated herein by reference.
//
// by Ivan Lucas, June 2004
require ('core.php');
$permission = PERM_FEEDBACK_FORM_EDIT; // Edit Feedback Forms
require (APPLICATION_LIBPATH.'functions.inc.php');
// This page requires authentication
require (APPLICATION_LIBPATH.'auth.inc.php');
$title = $strEditFeedbackQuestion;
$qid = clean_int($_REQUEST['qid']);
$fid = clean_int($_REQUEST['fid']);
$action = clean_fixed_list($_REQUEST['action'], array('','save'));
switch ($action)
{
case 'save':
// External variables
$question = clean_dbstring($_POST['question']);
$questiontext = clean_dbstring($_POST['questiontext']);
$sectiontext = clean_dbstring($_POST['sectiontext']);
$taborder = clean_int($_POST['taborder']);
$type = clean_dbstring($_POST['type']);
$required = clean_fixed_list($_POST['required'], array('false','true'));
$options = clean_dbstring($_POST['options']);
$sql = "UPDATE `{$dbFeedbackQuestions}` SET ";
$sql .= "question='{$question}', ";
$sql .= "questiontext='{$questiontext}', ";
$sql .= "sectiontext='{$sectiontext}', ";
$sql .= "taborder='{$taborder}', ";
$sql .= "type='{$type}', ";
$sql .= "required='{$required}', ";
$sql .= "options='{$options}' ";
$sql .= "WHERE id='{$qid}' LIMIT 1";
mysql_query($sql);
if (mysql_error()) trigger_error ("MySQL Error: ".mysql_error(), E_USER_ERROR);
header("Location: feedback_form_edit.php?formid={$fid}");
exit;
break;
default:
include (APPLICATION_INCPATH . 'htmlheader.inc.php');
echo "<h2 align='center'>{$title}</h2>\n";
$sql = "SELECT * FROM `{$dbFeedbackQuestions}` WHERE id = '$qid'";
$result = mysql_query($sql);
if (mysql_error()) trigger_error ("MySQL Error: ".mysql_error(), E_USER_WARNING);
while ($question = mysql_fetch_object($result))
{
echo "<form action='{$_SERVER['PHP_SELF']}' method='post'>";
echo "<table summary='Form' class='maintable'>";
echo "<tr>";
echo "<th>{$strSectionText}:<br /></th>";
echo "<td><textarea name='sectiontext' cols='80' rows='5'>";
echo $question->sectiontext."</textarea>";
echo "({$strLeaveBlankForNewSection})";
echo "</td>";
echo "</tr>\n<tr>";
echo "<th>{$strQuestion} #:</th>";
echo "<td><input type='text' name='taborder' size='3' maxlength='5' value=\"{$question->taborder}\" /></td>";
echo "</tr>\n<tr>";
echo "<th>{$strQuestion}:</th>";
echo "<td><input type='text' name='question' size='70' maxlength='255' value=\"{$question->question}\" /></td>";
echo "</tr>\n<tr>";
echo "<th>{$strQuestionText}:<br /></th>";
echo "<td><textarea name='questiontext' cols='80' rows='5'>";
echo $question->questiontext."</textarea></td>";
echo "</tr>\n<tr>";
echo "<th>{$strType}:</th>";
echo "<td>";
echo feedback_qtype_listbox($question->type);
echo "</td></tr>\n<tr>";
echo "<th>$strOptionsOnePerLine:<br /></th>";
echo "<td><textarea name='options' cols='80' rows='10'>";
echo $question->options."</textarea></td>";
echo "</tr>\n<tr>";
echo "<th>{$strRequired}:</th>";
echo "<td>";
if ($question->required == 'true')
{
echo "<input type='checkbox' name='required' value='true' checked='checked' />";
}
else
{
echo "<input type='checkbox' name='required' value='true' />";
}
echo "</td></tr>\n";
echo "</table>";
echo "<p class='formbuttons'><input type='hidden' name='qid' value='{$qid}' />";
echo "<input type='hidden' name='fid' value='{$fid}' />";
echo "<input name='reset' type='reset' value='{$strReset}' /> ";
echo "<input type='hidden' name='action' value='save' />";
echo "<td><input type='submit' value='{$strSave}' />";
echo "</p>";
echo "<p><a href='feedback_form_edit.php?id={$fid}'>{$strReturnToPreviousPage}</a></p>";
echo "</form>";
}
include (APPLICATION_INCPATH . 'htmlfooter.inc.php');
break;
}
?>
|