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 : importoldresponses.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.					#
	#############################################################	
*/
//import responses from an old_ survey table into an active survey
require_once(dirname(__FILE__).'/../config.php');

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

if (!$action == "import")
	{
	// show UI for choosing old table

$query = "SHOW TABLES LIKE '{$dbprefix}old\_{$surveyid}\_%'";
	$result = mysql_query($query) or die("Error:<br />$query<br />".mysql_error());
	$optionElements = '';
	while ($row = mysql_fetch_array($result))
		{
		$optionElements .= "\t\t\t<option>{$row[0]}</option>\n";
		}
	
    echo $htmlheader;
	echo "<br /><table align='center' class='outlinetable'>
		<tr>
			<th colspan='2'>"._IORD_TITLE."</th>
		</tr>
		<form method='post'>
		<tr>
		 <td align='right'>"._IORD_TARGETID."</td>
		 <td> $surveyid<input type='hidden' $slstyle value='$surveyid' name='sid'></td>
		</tr>
		<tr>
		 <td align='right'>
		  Source table:
		 </td>
		 <td>
		  <select name='oldtable' $slstyle>
{$optionElements}
		  </select>
		 </td>
		</tr>
		<tr>
		 <td>&nbsp;
		 </td>
		 <td>
		  <input type='submit' value='"._IORD_BTIMPORT."' $btstyle onClick='return confirm(\"Are you sure?\")'>&nbsp;
		 </td>
		</tr>
		 <input type='hidden' name='action' value='import'>
		</form>
		<tr><td colspan='2' align='center'>[<a href='browse.php?sid=$surveyid'>"._B_ADMIN_BT."</a>]</td></tr>
		</table>
</body></html>";
	}
elseif (isset($surveyid) && $surveyid && isset($oldtable))
	{
	
	// options (UI not implemented)
	
	$dontimportfields = array(
		'id' //,'otherfield'
	);
	$presetfields = array( // quote all strings so we can allow NULL
		//'4X13X951'=>"'Y'"
		//'id' => "NULL" 
	);
	$importidrange = false; //array('first'=>3,'last'=>10);

$activetable = "{$dbprefix}survey_$surveyid";

// fields we can import
	$importablefields = array();	
	$query = "SHOW COLUMNS FROM {$activetable}";
	$result = mysql_query($query) or die("Error:<br />$query<br />".mysql_error());
	while ($row = mysql_fetch_assoc($result))
		{
		if (!in_array($row['Field'],$dontimportfields))
			{
			$importablefields[] = $row['Field'];
			}
		}

// fields we can supply
	$availablefields = array();
	$query = "SHOW COLUMNS FROM {$oldtable}";
	$result = mysql_query($query) or die("Error:<br />$query<br />".mysql_error());
	while ($row = mysql_fetch_assoc($result))
		{
		$availablefields[] = $row['Field'];
		}
	foreach ($presetfields as $field => $value)
		{
		if (!in_array($field,$availablefields))
			{
			$availablefields[] = $field;
			}
		}

$fieldstoimport = array_intersect($importablefields,$availablefields);

// data sources for each field (field of oldtable or preset value)
	$sourcefields = array();
	foreach ($fieldstoimport as $field)
		{
		$sourcefields[] = array_key_exists($field,$presetfields)?
			$presetfields[$field] 
			: ($oldtable.'.'.$field);
		}

$query = "INSERT INTO {$activetable} (\n\t".join("\t, ",$fieldstoimport)."\n) "
			."SELECT\n\t".join("\t,",$sourcefields)."\n"
			."FROM {$oldtable}";
	if (is_array($importidrange))
		{
		$query .= " WHERE {$oldtable}.id >= {$importidrange['first']} "
				 ." AND {$oldtable}.id <= {$importidrange['last']}";
		}
	
	$result = mysql_query($query) or die("Error:<br />$query<br />".mysql_error());

header("Location: {$homeurl}/browse.php?sid={$surveyid}");
	}

${this.title}

Code Editor : importoldresponses.php