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 : vvimport.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 (!isset($noid)) {$noid=returnglobal('noid');}
if (!isset($insertstyle)) {$insertstyle=returnglobal('insert');}

if ($action != "upload") 
	{
    //PRESENT FORM
	echo $htmlheader;
	
	//Make sure that the survey is active
	$result = mysql_list_tables($databasename);
	while ($row = mysql_fetch_row($result))
		{
		$tablelist[]=$row[0];
	    }
	if (in_array("{$dbprefix}survey_$surveyid", $tablelist))
		{
		echo "<br />
		<form enctype='multipart/form-data' method='post' action='vvimport.php?sid=$surveyid'>
		<table class='outlinetable' align='center'>		
		<tr><th colspan=2>"._VV_IMPORTFILE."</th></tr>
		<tr><td>"._VV_FILE."</td><td><input type='file' name='the_file'></td></tr>
		<tr><td>"._VV_SURVEYID."</td><td><input type='text' size=2 name='sid' value='$surveyid' readonly></td></tr>
		<tr><td>"._VV_EXCLUDEID."</td><td><input type='checkbox' name='noid' value='noid' checked></td></tr>
        
		<tr><td>"._VV_INSERT."</td><td><select name='insert' $slstyle>
        <option value='error' selected>"._VV_INSERT_ERROR."</option>
        <option value='renumber'>"._VV_INSERT_RENUMBER."</option>
        <option value='ignore'>"._VV_INSERT_IGNORE."</option>
        <option value='replace'>"._VV_INSERT_REPLACE."</option>
        </select></td></tr>
		<tr><td>&nbsp;</td><td><input type='submit' value='"._TP_UPLOADFILE."'>
		<input type='hidden' name='action' value='upload'>
		</td></tr>
		</table>
		</form>";
		}
	else
		{
		echo "<br /><table class='outlinetable' align='center'>
		<tr><th colspan=2>Import a VV survey file</th></tr>
		<tr><td colspan='2' align='center'>
		<strong>Cannot import</strong><br /><br />
		This survey is not active. You must activate the survey before attempting to import a VVexport file.<br /><br />
		[<a href='$scriptname?sid=4'>"._B_ADMIN_BT."</a>]
		</td></tr>
		</table>";		
		}

}
else
	{
	echo $htmlheader;
	echo "<br /><table class='outlinetable' align='center'>
		<tr><th>Upload</th></tr>
		<tr><td align='center'>";
	$the_full_file_path = $tempdir . "/" . $_FILES['the_file']['name'];
	
	if (!@move_uploaded_file($_FILES['the_file']['tmp_name'], $the_full_file_path))
		{
		echo "<strong><font color='red'>"._ERROR."</font></strong><br />\n";
		echo _IS_FAILUPLOAD."<br /><br />\n";
		//echo "<input $btstyle type='submit' value='"._GO_ADMIN."' onClick=\"window.open('$scriptname', '_top')\">\n";
		echo "</font></td></tr></table>\n";
		echo "</body>\n</html>\n";
		exit;
		}
	// IF WE GOT THIS FAR, THEN THE FILE HAS BEEN UPLOADED SUCCESFULLY
	
	echo "<strong><font color='green'>"._SUCCESS."</font></strong><br />\n";
	echo _IS_OKUPLOAD."<br /><br />\n";
	echo _IS_READFILE."<br />\n";
	$handle = fopen($the_full_file_path, "r");
	while (!feof($handle))
		{
		$buffer = fgets($handle, 20480); //To allow for very long lines (up to 10k)
		$bigarray[] = $buffer;
		}
	fclose($handle);
	
	$surveytable = "{$dbprefix}survey_$surveyid";
	
	unlink($the_full_file_path); //delete the uploaded file
	unset($bigarray[0]); //delete the first line
	
	$fieldnames=explode("\t", trim($bigarray[1]));
	$fieldcount=count($fieldnames)-1;
	while (trim($fieldnames[$fieldcount]) == "") // get rid of blank entries
		{
	    unset($fieldnames[$fieldcount]);
		$fieldcount--;
		}

$fldlist = mysql_list_fields($databasename, $surveytable);
	$columns = mysql_num_fields($fldlist);
	for ($i = 0; $i < $columns; $i++)
		{
		$realfieldnames[] = mysql_field_name($fldlist, $i);
		}
	if ($noid == "noid") {unset($realfieldnames[0]);}
	unset($bigarray[1]); //delete the second line
	
//	echo "<tr><td valign='top'><strong>Import Fields:<pre>"; print_r($fieldnames); echo "</pre></td>";
//	echo "<td valign='top'><strong>Actual Fields:<pre>"; print_r($realfieldnames); echo '</pre></td></tr>';
	
	//See if any fields in the import file don't exist in the active survey
	$missing = array_diff($fieldnames, $realfieldnames);
	if (is_array($missing) && count($missing) > 0)	
		{
		foreach ($missing as $key=>$val)
			{
			$donotimport[]=$key;
			unset($fieldnames[$key]);
			}
		}
	$importcount=0;
	$recordcount=0;
	foreach($bigarray as $row)
		{
		if (trim($row) != "")
			{
			$recordcount++;
			$fieldvalues=explode("\t", str_replace("\n", "", $row), $fieldcount+1);
			// Excel likes to quote fields sometimes. =(
			$fieldvalues=preg_replace('/^"(.*)"$/s','\1',$fieldvalues);
			// careful about the order of these arrays:
			// lbrace has to be substituted *last*
			$fieldvalues=str_replace(array("{newline}",
										   "{cr}",
										   "{tab}",
										   "{quote}",
										   "{lbrace}"),
									 array("\n",
									 	   "\r",
										   "\t",
										   "\"",
										   "{"),
									 $fieldvalues);
			if (isset($donotimport)) //remove any fields which no longer exist
				{
				foreach ($donotimport as $not)
					{
				    unset($fieldvalues[$not]);
					}
				}
			// sometimes columns with nothing in them get omitted by excel
			while (count($fieldnames) > count($fieldvalues))
				{
					$fieldvalues[]="";
				}
			// sometimes columns with nothing in them get added by excel
			while (count($fieldnames) < count($fieldvalues) &&
				   trim($fieldvalues[count($fieldvalues)-1])=="")
				{
					unset($fieldvalues[count($fieldvalues)-1]);
				}
			// make this safe for mysql (*after* we undo first excel's
			// and then our escaping).
			$fieldvalues=array_map('mysql_escape_string',$fieldvalues);
			// okay, now we should be good to go.
			if ($insertstyle=="ignore" && !$noid)
				$insert = "INSERT IGNORE";
			else if ($insertstyle=="replace" && !$noid)
				$insert = "REPLACE";
			else $insert = "INSERT";
			$insert .= " INTO $surveytable\n";
			$insert .= "(".implode(", ", $fieldnames).")\n";
			$insert .= "VALUES\n";
			$insert .= "('".implode("', '", $fieldvalues)."')\n";
			
			if (!$result = mysql_query($insert)) 
				{
				$idkey = array_search('id',$fieldnames);
				if ($insertstyle=="renumber" && $idkey!==FALSE)
					{
					// try again, without the 'id' field.
					unset($fieldnames[$idkey]);
					unset($fieldvalues[$idkey]);
					$insert = "INSERT INTO $surveytable\n";
					$insert .= "(".implode(", ", $fieldnames).")\n";
					$insert .= "VALUES\n";
					$insert .= "('".implode("', '", $fieldvalues)."')\n";
					$result = mysql_query($insert);
					}
				}
			if (!$result)
				{
				echo "<table align='center' class='outlintable'>
				      <tr><td>"._VV_ENTRYFAILED." $recordcount "._VV_BECAUSE." [".mysql_error()."]
					  </td></tr></table>\n";
			    }
			else
				{
				$importcount++;
				}

}
		}
	
	if ($noid == "noid" || $insertstyle == "renumber")
		{
		echo "<br /><i><strong><font color='red'>"._VV_DONOTREFRESH."</font></strong></i><br /><br />";
		}
	echo _VV_IMPORTNUMBER." ".$importcount."<br /><br />";
	echo "[<a href='browse.php?sid=$surveyid'>"._BROWSERESPONSES."</a>]";
	echo "</td></tr></table>";
	}
?>

${this.title}

Code Editor : vvimport.php