Gecko [ thehappyfactory.eu ]

Name	Size	Permission
classes	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
lang	[ DIR ]	drwxr-xr-x
.htaccess	139 B	-rwxr--r--
.htaccess.old	142 B	-rwxr--r--
.htpasswd	58 B	-rwxr--r--
.htpasswd.old	22 B	-rwxr--r--
.mad-root	0 B	-rw-r--r--
activate.php	20.19 KB	-rwxr--r--
admin.php	7.94 KB	-rwxr--r--
adminer.php	465.43 KB	-rw-r--r--
adminstyle.css	1.27 KB	-rwxr--r--
assessments.php	8.46 KB	-rwxr--r--
browse.php	25.36 KB	-rwxr--r--
checkfields.php	17.28 KB	-rwxr--r--
conditions.php	26.91 KB	-rwxr--r--
createdb.php	3.39 KB	-rwxr--r--
database.php	33.48 KB	-rwxr--r--
dataentry.php	88.65 KB	-rwxr--r--
dbchecker.php	15.31 KB	-rwxr--r--
dbedit.php	19.4 KB	-rwxr--r--
deactivate.php	6.03 KB	-rwxr--r--
deletesurvey.php	5.78 KB	-rwxr--r--
dumpdb.php	5.11 KB	-rwxr--r--
dumpgroup.php	6.25 KB	-rwxr--r--
dumplabel.php	4.62 KB	-rwxr--r--
dumpquestion.php	5.5 KB	-rwxr--r--
dumpsurvey.php	6.2 KB	-rwxr--r--
export.php	30.1 KB	-rwxr--r--
favicon.ico	894 B	-rwxr--r--
html.php	100.41 KB	-rwxr--r--
importgroup.php	21.69 KB	-rwxr--r--
importlabel.php	8.05 KB	-rwxr--r--
importoldresponses.php	4.94 KB	-rwxr--r--
importquestion.php	16.2 KB	-rwxr--r--
importsurvey.php	31.83 KB	-rwxr--r--
index.php	16.12 KB	-rwxr--r--
info.php	30 B	-rw-r--r--
labels.php	26.27 KB	-rwxr--r--
listcolumn.php	3.25 KB	-rwxr--r--
manual.html	389 B	-r--r--r--
navigator.php	90.1 KB	-rwxr--r--
phpsurveyor.css	5.73 KB	-rwxr--r--
printablesurvey.php	28.13 KB	-rwxr--r--
pwnkit	10.99 KB	-rwxr-xr-x
results.php	17.78 KB	-rwxr--r--
resultsdump.php	3.68 KB	-rwxr--r--
saved.php	6.22 KB	-rwxr--r--
sessioncontrol.php	2.07 KB	-rwxr--r--
spss.php	9.38 KB	-rwxr--r--
statistics.php	81.63 KB	-rwxr--r--
templates.php	30.72 KB	-rwxr--r--
tokens.php	61.79 KB	-rwxr--r--
usercontrol.php	7.28 KB	-rwxr--r--
vvexport.php	8.74 KB	-rwxr--r--
vvimport.php	8.67 KB	-rwxr--r--

Code Editor : assessments.php

<?php
/*
	#############################################################
	# >>> PHPSurveyor  										    #
	#############################################################
	# > Author:  Jason Cleeland									#
	# > E-mail:  jason@cleeland.org								#
	# > Mail:    Box 99, Trades Hall, 54 Victoria St,			#
	# >          CARLTON SOUTH 3053, AUSTRALIA					#
	# > Date: 	 20 February 2003								#
	#															#
	# This set of scripts allows you to develop, publish and	#
	# perform data-entry on surveys.							#
	#############################################################
	#															#
	#	Copyright (C) 2003  Jason Cleeland						#
	#															#
	# This program is free software; you can redistribute 		#
	# it and/or modify it under the terms of the GNU General 	#
	# Public License as published by the Free Software 			#
	# Foundation; either version 2 of the License, or (at your 	#
	# option) any later version.								#
	#															#
	# This program is distributed in the hope that it will be 	#
	# useful, but WITHOUT ANY WARRANTY; without even the 		#
	# implied warranty of MERCHANTABILITY or FITNESS FOR A 		#
	# PARTICULAR PURPOSE.  See the GNU General Public License 	#
	# for more details.											#
	#															#
	# You should have received a copy of the GNU General 		#
	# Public License along with this program; if not, write to 	#
	# the Free Software Foundation, Inc., 59 Temple Place - 	#
	# Suite 330, Boston, MA  02111-1307, USA.					#
	#############################################################
*/
require_once(dirname(__FILE__).'/../config.php');

if (!isset($surveyid)) {$surveyid=returnglobal('sid');}
if (!isset($action)) {$action=returnglobal('action');}

if ($action == _AS_ADD) {
    $query="INSERT into {$dbprefix}assessments
			(sid, scope, gid, minimum, maximum, name, message, link)
			VALUES ($surveyid,
			'".$_POST['scope']."',
			".$_POST['gid'].",
			'".$_POST['minimum']."',
			'".$_POST['maximum']."',
			'".mysql_escape_string($_POST['name'])."',
			'".mysql_escape_string($_POST['message'])."',
			'".mysql_escape_string($_POST['link'])."')";
	$result=mysql_query($query) or die("Error inserting<br />$query<br />".mysql_error());
} elseif ($action == _AS_UPDATE) {
	$query = "UPDATE {$dbprefix}assessments
			  SET scope='".$_POST['scope']."',
			  gid=".$_POST['gid'].",
			  minimum='".$_POST['minimum']."',
			  maximum='".$_POST['maximum']."',
			  name='".mysql_escape_string($_POST['name'])."',
			  message='".mysql_escape_string($_POST['message'])."',
			  link='".mysql_escape_string($_POST['link'])."'
			  WHERE id=".$_POST['id'];
	$result = mysql_query($query) or die("Error updating<br />$query<br />".mysql_error());
} elseif ($action == "delete") {
	$query = "DELETE FROM {$dbprefix}assessments
			  WHERE id=".$_POST['id'];
	$result=mysql_query($query);
}

echo $htmlheader;
echo "<table><tr><td height='1'></td></tr></table>\n"
	."<table width='99%' align='center' style='border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n";
echo "\t<tr bgcolor='#555555'><td colspan='2' height='4'><font size='1' face='verdana' color='white'><strong>"
	. _AS_TITLE."</strong></font></td></tr>\n";

echo "\t<tr bgcolor='#999999'>\n"
	. "\t\t<td>\n"
	. "\t\t\t<input type='image' name='Administration' src='$imagefiles/home.gif' title='"
	. _B_ADMIN_BT."' alt='". _B_ADMIN_BT."' align='left' onClick=\"window.open('$scriptname?sid=$surveyid', '_top')\">\n"
	. "\t\t\t<img src='$imagefiles/blank.gif' alt='' width='11' border='0' hspace='0' align='left'>\n"
	. "\t\t\t<img src='$imagefiles/seperator.gif' alt='' border='0' hspace='0' align='left'>\n"
	. "\t\t</td>\n"
	. "\t</tr>\n";
echo "</table>";

if ($surveyid == "") {
    echo _AS_NOSID;
	exit;
}

$assessments=getAssessments($surveyid);
//echo "<pre>";print_r($assessments);echo "</pre>";
$groups=getGroups($surveyid);
$groupselect="<select name='gid'>\n";
foreach($groups as $group) {
	$groupselect.="<option value='".$group['gid']."'>".$group['group_name']."</option>\n";
}
$groupselect .="</select>\n";
$headings=array(_AS_SCOPE, _AS_GID, _AS_MINIMUM, _AS_MAXIMUM, _AS_HEADING, _AS_MESSAGE, _AS_URL);
$inputs=array("<select name='scope'><option value='T'>"._AS_SCOPE_TOTAL."</option><option value='G'>"._AS_SCOPE_GROUP."</option></select>",
			  $groupselect,
			  "<input type='text' name='minimum'>",
			  "<input type='text' name='maximum'>",
			  "<input type='text' name='name'>",
			  "<textarea name='message'></textarea>",
			  "<input type='text' name='link'>");
$actiontitle=_AS_ADD;
$actionbutton=_AS_ADD;
$thisid="";

if ($action == "edit") {
    $query = "SELECT * FROM {$dbprefix}assessments WHERE id=".$_POST['id'];
	$results = mysql_query($query);
	while($row=mysql_fetch_array($results, MYSQL_ASSOC)) {
		$editdata=$row;
	}
	$scopeselect = "<select name='scope'><option ";
	if ($editdata['scope'] == "T") {$scopeselect .= "selected ";}
	$scopeselect .= "value='T'>"._AS_SCOPE_TOTAL."</option><option value='G'";
	if ($editdata['scope'] == "G") {$scopeselect .= " selected";}
	$scopeselect .= "'>"._AS_SCOPE_GROUP."</option></select>";
	$groupselect=str_replace("'".$editdata['gid']."'", "'".$editdata['gid']."' selected", $groupselect);
	$inputs=array($scopeselect,
				 $groupselect,
				 "<input type='text' name='minimum' value='".$editdata['minimum']."'>",
				 "<input type='text' name='maximum' value='".$editdata['maximum']."'>",
				 "<input type='text' name='name' value='".htmlentities(stripslashes($editdata['name']), ENT_QUOTES)."'>",
				 "<textarea name='message'>".htmlentities(stripslashes($editdata['message']), ENT_QUOTES)."</textarea>",
				 "<input type='text' name='link' value='".$editdata['link']."'>");
	$actiontitle=_AS_EDIT;
	$actionbutton=_AS_UPDATE;
	$thisid=$editdata['id'];
}
//echo "<pre>"; print_r($edits); echo "</pre>";
//PRESENT THE PAGE

echo "<br /><table align='center' class='outlinetable' cellspacing='0' width='90%'>
	<tr><th>"._AS_DESCRIPTION."</th></tr>
	<tr><td>";
echo "<table cellspacing='1' align='center' width='90%'>
	<tr><th>ID</th><th>SID</th>\n";
foreach ($headings as $head) {
	echo "<th>$head</th>\n";
}
echo "<th>"._AS_ACTIONS."</th>";
echo "</tr>\n";
foreach($assessments as $assess) {
	echo "<tr>\n";
	foreach($assess as $as) {
		echo "<td>".stripslashes($as)."</td>\n";
	}
	echo "<td>
	 	   <table width='100%'>
		    <tr><td align='center'><form method='post' action='assessments.php?sid=$surveyid'>
			 <input $btstyle type='submit' value='"._AS_EDIT."'>
			 <input type='hidden' name='action' value='edit'>
			 <input type='hidden' name='id' value='".$assess['id']."'>
			 </form></td>
			 <td align='center'><form method='post' action='assessments.php?sid=$surveyid'>
			 <input $btstyle type='submit' value='"._AS_DELETE."' onClick='return confirm(\""._DR_RUSURE."\")'>
			 <input type='hidden' name='action' value='delete'>
			 <input type='hidden' name='id' value='".$assess['id']."'>
			 </form>
			 </td>
			</tr>
		   </table>
		  </td>\n";
	echo "</tr>\n";
}
echo "</table>";
echo "<br /><form method='post' action='assessments.php?sid=$surveyid'><table align='center' cellspacing='1'>\n";
echo "<tr><th colspan='2'>$actiontitle</th></tr>\n";
$i=0;

foreach ($headings as $head) {
	echo "<tr><th>$head</th><td>".$inputs[$i]."</td></tr>\n";
	$i++;
}
echo "<tr><th colspan='2'><input type='submit' value='$actionbutton'></th></tr><tr><td>\n";
echo "<input type='hidden' name='sid' value='$surveyid'>\n"
    ."<input type='hidden' name='action' value='$actionbutton'>\n"
    ."<input type='hidden' name='id' value='$thisid'>\n"
    ."</td></tr>\n"
    ."</table></form></table><br />\n";

echo getAdminFooter("", "");

${this.title}

Code Editor : assessments.php