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 : spss.php

<?php
require_once(dirname(__FILE__).'/../config.php');
if (!isset($imagefiles)) {$imagefiles="./images";}
if (!isset($surveyid)) {$surveyid=returnglobal('sid');}
if (!isset($style)) {$style=returnglobal('style');}
if (!isset($answers)) {$answers=returnglobal('answers');}
if (!isset($type)) {$type=returnglobal('type');}

if (empty($surveyid)) {die("Cannot run this script directly");}
#Get all legitimate question ids

header("Content-Type: application/octetstream");
header("Content-Disposition: ".(strpos($_SERVER["HTTP_USER_AGENT"],"MSIE 5.5")?"":"attachment; ")."filename=survey".$surveyid.".sav");

sendcacheheaders();
$query = "SELECT DISTINCT qid FROM {$dbprefix}questions WHERE sid=$surveyid"; //GET LIST OF LEGIT QIDs FOR TESTING LATER
$result=mysql_query($query) or die("Couldn't count fields $query ".mysql_error());
$num_results = mysql_num_rows($result);
# Build array that has to be returned
$fieldmap=createFieldMap($surveyid);
#See if tokens are being used
$tresult = @mysql_list_tables($databasename) or die ("Error getting table list ".mysql_error());
while($tbl = @mysql_tablename($tresult, $i++))
	{
	if ($tbl == "{$dbprefix}tokens_$surveyid") {$tokensexist = 1;}
	}

#Lookup the names of the attributes
$query="SELECT sid, attribute1, attribute2, private FROM {$dbprefix}surveys WHERE sid=$surveyid";
$result=mysql_query($query) or die("Couldn't count fields $query ".mysql_error());
$num_results = mysql_num_rows($result);
$num_fields = $num_results;
# Build array that has to be returned
for ($i=0; $i < $num_results; $i++) {
 $row = mysql_fetch_array($result);
	if ($row["attribute1"]) {$attr1_name = $row["attribute1"];} else {$attr1_name=_TL_ATTR1;}
	if ($row["attribute2"]) {$attr2_name = $row["attribute2"];} else {$attr2_name=_TL_ATTR2;}
	$surveyprivate=$row['private'];
}

$fieldno=0;

if (isset($tokensexist) && $tokensexist == 1 && $surveyprivate == "N") {
	$query="SHOW COLUMNS FROM {$dbprefix}tokens_$surveyid";
	$result=mysql_query($query) or die("Couldn't count fields in tokens $query ".mysql_error());
	while ($row=mysql_fetch_row($result)) {
			$token_fields[]=$row[0];
		}
	if (in_array("firstname", $token_fields)) {
	 $fields[$fieldno++]=array("id"=>"fname","name"=>_TL_FIRST,"code"=>"", "qid"=>0,"type"=>"A40" );
	}
	if (in_array("lastname", $token_fields)) {
	 $fields[$fieldno++]=array("id"=>"lname","name"=>_TL_LAST,"code"=>"", "qid"=>0,"type"=>"A40" );
	}
	if (in_array("email", $token_fields)) {
	 $fields[$fieldno++]=array("id"=>"email","name"=>_TL_EMAIL,"code"=>"", "qid"=>0,"type"=>"A100");
	}
	if (in_array("attribute_1", $token_fields)) {
	 $fields[$fieldno++]=array("id"=>"attr1","name"=>$attr1_name,"code"=>"", "qid"=>0,"type"=>"A100");
	}
	if (in_array("attribute_2", $token_fields)) {
	 $fields[$fieldno++]=array("id"=>"attr2","name"=>$attr2_name,"code"=>"", "qid"=>0,"type"=>"A100");
	}
//	$fields=array(
//		$fieldno++ =>array("id"=>"fname","name"=>_TL_FIRST,"code"=>"", "qid"=>0,"type"=>"A40" ) , 
//		$fieldno++ =>array("id"=>"lname","name"=>_TL_LAST,"code"=>"", "qid"=>0,"type"=>"A40" ) , 
//		$fieldno++ =>array("id"=>"email","name"=>_TL_EMAIL,"code"=>"", "qid"=>0,"type"=>"A100") , 
//		$fieldno++ =>array("id"=>"attr1","name"=>$attr1_name,"code"=>"", "qid"=>0,"type"=>"A100") , 
//		$fieldno++ =>array("id"=>"attr2","name"=>$attr2_name,"code"=>"", "qid"=>0,"type"=>"A100"));
} else {
	$fields=array();
}

$query="SHOW COLUMNS FROM {$dbprefix}survey_$surveyid";
$result=mysql_query($query) or die("Couldn't count fields $query ".mysql_error());
$num_results = mysql_num_rows($result);
$num_fields = $num_results;
# Build array that has to be returned
for ($i=0; $i < $num_results; $i++) {
 $row = mysql_fetch_array($result);
 #Conditions for SPSS fields:
 # - Length may not be longer than 8 characters
 # - Name may not begin with a digit
 $fieldname = $row["Field"];

#Rename 'datestamp' to stamp
        if ($fieldname =="datestamp") {
                $fieldname = "stamp";
        }

#Determine field type
	if ($fieldname=="stamp"){
		$fieldtype = "DATETIME20.0";
	} else {
		$fieldtype = "A20";
	}
	#Get qid (question id)
	$code="";
	if ($fieldname == "id" OR $fieldname=="token" OR $fieldname=="stamp" OR $fieldname=="attribute_1" OR $fieldname=="attribute_2"){
		$qid = 0;
	}else{
		//GET FIELD DATA
		$fielddata=arraySearchByKey($fieldname, $fieldmap, "fieldname", 1);
		$qid=$fielddata['qid'];
		$ftype=$fielddata['type'];
		$fsid=$fielddata['sid'];
		$fgid=$fielddata['gid'];
		$code=$fielddata['aid'];
	}
	$tempArray=array($fieldno++ =>array("id"=>"d".$fieldno,"name"=>substr($fieldname, 0, 8),"qid"=>$qid, "code"=>$code, "type"=>"$fieldtype"));
	$fields = $fields + $tempArray;
}

echo "DATA LIST FREE\n /";

foreach ($fields as $field){
        echo $field["id"];
        echo "(".$field["type"].") ";
}

echo ".";
echo "\n";

echo "BEGIN DATA.\n";

if (isset($tokensexist) && $tokensexist == 1 && $surveyprivate == "N") {
$query="SELECT `{$dbprefix}tokens_$surveyid`.`firstname`   ,
	       `{$dbprefix}tokens_$surveyid`.`lastname`    ,
	       `{$dbprefix}tokens_$surveyid`.`email`";
if (in_array("attribute_1", $token_fields)) {
    $query .= ",\n		`{$dbprefix}tokens_$surveyid`.`attribute_1`";
}
if (in_array("attribute_2", $token_fields)) {
    $query .= ",\n		`{$dbprefix}tokens_$surveyid`.`attribute_2`";
}
$query .= ",\n	       `{$dbprefix}survey_$surveyid`.* 
	FROM `{$dbprefix}survey_$surveyid`
	LEFT JOIN `{$dbprefix}tokens_$surveyid` ON `{$dbprefix}survey_$surveyid`.`token` = `{$dbprefix}tokens_$surveyid`.`token`";
} else {
$query = "SELECT `{$dbprefix}survey_$surveyid`.*
	FROM `{$dbprefix}survey_$surveyid`";
}

$result=mysql_query($query) or die("Couldn't get results $query ".mysql_error());
$num_results = mysql_num_rows($result);
$num_fields = mysql_num_fields($result);
for ($i=0; $i < $num_results; $i++) {
 $row = mysql_fetch_array($result);
	$fieldno = 0;
	while ($fieldno < $num_fields){
		// if ($fields[$fieldno]["id"]=="stamp"){
		// Must be changed if d2 is no longer the date field
		if ($fields[$fieldno]["id"]=="d2"){
			#convert mysql datestamp (yyyy-mm-dd hh:mm:ss) to SPSS datetime (dd-mmm-yyyy hh:mm:ss) format
			list( $year, $month, $day, $hour, $minute, $second ) = split( '([^0-9])', $row[$fieldno] );
			echo "'".date("d-m-Y H:i:s", mktime( $hour, $minute, $second, $month, $day, $year ) )."' ";
		}else {
			// Remove apostrophes (delimiters)
			$temp = str_replace("'","",$row[$fieldno]);
			// Remove extra spaces (delimiters)
			$temp = str_replace(" ","",$temp);
			// Only return first 5 characters
			echo "'".substr($temp,0,5)."' ";
		}
		$fieldno++;
	}
	echo "\n";
 #Conditions for SPSS fields:
 # - Length may not be longer than 8 charac
}
echo "END DATA.\n";

echo "*Define Variable Properties.\n";
foreach ($fields as $field){
	if ($field["id"] == "fname" OR $field["id"]=="lname" OR $field["id"]=="email" OR $field["id"]=="attr1" OR $field["id"]=="attr2"){
	        echo "VARIABLE LABELS ".$field["id"]." '".$field["name"]."'.\n";
	}else{
		#If a split question
		if ($field["code"] != ""){
			#Lookup the question

$query = "SELECT `{$dbprefix}questions`.`question` FROM {$dbprefix}questions WHERE ((`{$dbprefix}questions`.`sid` =".$surveyid.") AND (`{$dbprefix}questions`.`qid` =".$field["qid"]."))";
			#echo $query;
			$result=mysql_query($query) or die("Couldn't count fields $query ".mysql_error());
			$num_results = mysql_num_rows($result);
			$num_fields = $num_results;
			if ($num_results >0){
				# Build array that has to be returned
				for ($i=0; $i < $num_results; $i++) {
					$row = mysql_fetch_array($result);
					$question_text = $row["question"];
				}
			}
			#Lookup the answer
			$query = "SELECT `{$dbprefix}answers`.`answer` FROM {$dbprefix}answers WHERE ((`{$dbprefix}answers`.`qid` =".$field["qid"].") AND (`{$dbprefix}answers`.`code` ='".$field["code"]."'))";
			$result=mysql_query($query) or die("Couldn't count fields $query ".mysql_error());
			$num_results = mysql_num_rows($result);
			$num_fields = $num_results;
			if ($num_results >0){
				# Build array that has to be returned
				for ($i=0; $i < $num_results; $i++) {
					$row = mysql_fetch_array($result);
					echo "VARIABLE LABELS ".$field["id"]." '".$question_text." - ".$row["answer"]."'.\n";
				}
			}

#If a 'normal'
		}else{
				####
			#Split fieldname by "X"
			#$test[0] --> contains 'survey id' --> surveys-sid
			#$test[1] --> contains 'group is'  --> groups-gid
			#$test[2] --> contains a combination 'qid' and 'code' in 'answers' table
			$test=explode ("X", $field["name"]);
		}
	}
}

echo "*Define Value labels.\n";

foreach ($fields as $field){
	if ($field["qid"]!=0){
		$query = "SELECT `{$dbprefix}answers`.`code`, `{$dbprefix}answers`.`answer` FROM {$dbprefix}answers WHERE (`{$dbprefix}answers`.`qid` = ".$field["qid"].")";
		$result=mysql_query($query) or die("Couldn't count fields $query ".mysql_error());
		$num_results = mysql_num_rows($result);
		$num_fields = $num_results;
		if ($num_results >0){
			echo "VALUE LABELS ".$field["id"]."\n";
			# Build array that has to be returned
			for ($i=0; $i < $num_results; $i++) {
			 $row = mysql_fetch_array($result);
				echo $row["code"]." '".$row["answer"]."'\n";
			}
		}
	}
}
?>

${this.title}

Code Editor : spss.php