3 // SourceForge: Breaking Down the Barriers to Open Source Development
4 // Copyright 1999-2000 (c) The SourceForge Crew
5 // http://sourceforge.net
10 require($DOCUMENT_ROOT.'/survey/survey_utils.php');
12 survey_header(array('title'=>'Edit A Survey'));
14 if (!user_isloggedin() || !user_ismember($group_id,'A')) {
15 echo "<H1>Permission Denied</H1>";
16 survey_footer(array());
21 $sql="UPDATE surveys SET survey_title='$survey_title', survey_questions='$survey_questions', is_active='$is_active' ".
22 "WHERE survey_id='$survey_id' AND group_id='$group_id'";
23 $result=db_query($sql);
24 if (db_affected_rows($result) < 1) {
25 $feedback .= ' UPDATE FAILED ';
28 $feedback .= ' UPDATE SUCCESSFUL ';
33 Get this survey out of the DB
36 $sql="SELECT * FROM surveys WHERE survey_id='$survey_id' AND group_id='$group_id'";
37 $result=db_query($sql);
38 $survey_title=db_result($result, 0, "survey_title");
39 $survey_questions=db_result($result, 0, "survey_questions");
40 $is_active=db_result($result, 0, "is_active");
43 <SCRIPT LANGUAGE="JavaScript">
47 function show_questions() {
48 newWindow = open("","occursDialog","height=600,width=500,scrollbars=yes,resizable=yes");
49 newWindow.location=('show_questions.php?group_id=<?php echo $group_id; ?>');
55 <H2>Edit a Survey</H2><P>
57 <H3><FONT COLOR="RED">WARNING! It is a bad idea to edit a survey after responses have been posted</FONT></H3>
59 If you change a survey after you already have responses, your results pages could be misleading or messed up.
61 <FORM ACTION="<?php echo $PHP_SELF; ?>" METHOD="POST">
62 <INPUT TYPE="HIDDEN" NAME="group_id" VALUE="<?php echo $group_id; ?>">
63 <INPUT TYPE="HIDDEN" NAME="post_changes" VALUE="y">
64 <B>Name of Survey:</B>
66 <INPUT TYPE="HIDDEN" NAME="survey_id" VALUE="<?php echo $survey_id; ?>">
67 <INPUT TYPE="TEXT" NAME="survey_title" VALUE="<?php echo $survey_title; ?>" LENGTH="60" MAXLENGTH="150">
71 List question numbers, in desired order, separated by commas. <B>Refer to your list of questions</B> so you can view
72 the question id's. Do <B>not</B> include spaces or end your list with a comma.
75 <BR><INPUT TYPE="TEXT" NAME="survey_questions" VALUE="<?php echo $survey_questions; ?>" LENGTH="90" MAXLENGTH="1500"><P>
77 <BR><INPUT TYPE="RADIO" NAME="is_active" VALUE="1"<?php if ($is_active=='1') { echo ' CHECKED'; } ?>> Yes
78 <BR><INPUT TYPE="RADIO" NAME="is_active" VALUE="0"<?php if ($is_active=='0') { echo ' CHECKED'; } ?>> No
80 <INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="Submit Changes">
85 Function ShowResultsEditSurvey($result) {
86 global $group_id,$PHP_SELF;
87 $rows = db_NumRows($result);
88 $cols = db_NumFields($result);
89 echo "<h3>$rows Found</h3>";
91 echo /*"<TABLE BGCOLOR=\"NAVY\"><TR><TD BGCOLOR=\"NAVY\">*/ "<table border=0>\n";
92 /* Create the headers */
93 echo "<tr BGCOLOR=\"$GLOBALS[COLOR_MENUBARBACK]\">\n";
94 for ($i = 0; $i < $cols; $i++) {
95 printf( "<th><FONT COLOR=\"WHITE\"><B>%s</th>\n", db_fieldname($result,$i));
98 for ($j=0; $j<$rows; $j++) {
103 $row_bg="$GLOBALS[COLOR_LTBACK1]";
106 echo "<tr BGCOLOR=\"$row_bg\">\n";
108 echo "<TD><A HREF=\"$PHP_SELF?group_id=$group_id&survey_id=".
109 db_result($result,$j,0)."\">".db_result($result,$j,0)."</A></TD>";
110 for ($i = 1; $i < $cols; $i++) {
111 printf("<TD>%s</TD>\n",db_result($result,$j,$i));
116 echo "</table>"; //</TD></TR></TABLE>";
120 Select all surveys from the database
123 $sql="SELECT * FROM surveys WHERE group_id='$group_id'";
125 $result=db_query($sql);
130 <INPUT TYPE="BUTTON" NAME="none" VALUE="Show Existing Questions" ONCLICK="show_questions()">
133 <H2>Existing Surveys</H2>
136 ShowResultsEditSurvey($result);
138 survey_footer(array());