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 : importsurvey.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. #
 ############################################################# 
*/
//Ensure script is not run directly, avoid path disclosure
if (empty($homedir)) {die ("Cannot run this script directly");}

// A FILE TO IMPORT A DUMPED SURVEY FILE, AND CREATE A NEW SURVEY

echo " \n";
echo "<table width='350' align='center' style='border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n";
echo "\t<tr bgcolor='#555555'><td colspan='2' height='4'>"
._IMPORTSURVEY."</td></tr>\n";
echo "\t<tr bgcolor='#CCCCCC'><td align='center'>$setfont\n";

$the_full_file_path = $tempdir . "/" . $_FILES['the_file']['name'];

if (!@move_uploaded_file($_FILES['the_file']['tmp_name'], $the_full_file_path))
 {
 echo ""._ERROR." \n";
 echo _IS_FAILUPLOAD." \n";
 echo "<input $btstyle type='submit' value='"._GO_ADMIN."' onClick=\"window.open('$scriptname', '_top')\">\n";
 echo "</td></tr></table>\n";
 echo "</body>\n</html>\n";
 exit;
 }

// IF WE GOT THIS FAR, THEN THE FILE HAS BEEN UPLOADED SUCCESFULLY

echo ""._SUCCESS." \n";
echo _IS_OKUPLOAD." \n";
echo _IS_READFILE." \n";
$handle = fopen($the_full_file_path, "r");
while (!feof($handle))
 {
 //$buffer = fgets($handle, 1024); //Length parameter is required for PHP versions < 4.2.0
 $buffer = fgets($handle, 10240); //To allow for very long survey welcomes (up to 10k)
 $bigarray[] = $buffer;
 }
fclose($handle);

if (substr($bigarray[1], 0, 22) != "# SURVEYOR SURVEY DUMP")
 {
 echo ""._ERROR." \n";
 echo _IS_WRONGFILE." \n";
 echo "<input $btstyle type='submit' value='"._GO_ADMIN."' onClick=\"window.open('$scriptname', '_top')\">\n";
 echo "</td></tr></table>\n";
 echo "</body>\n</html>\n";
 unlink($the_full_file_path);
 exit;
 }

for ($i=0; $i<9; $i++)
 {
 unset($bigarray[$i]);
 }
$bigarray = array_values($bigarray);

//SURVEYS
if (array_search("# GROUPS TABLE\n", $bigarray))
 {
 $stoppoint = array_search("# GROUPS TABLE\n", $bigarray);
 }
elseif (array_search("# GROUPS TABLE\r\n", $bigarray))
 {
 $stoppoint = array_search("# GROUPS TABLE\r\n", $bigarray);
 }
for ($i=0; $i<=$stoppoint+1; $i++)
 {
 if ($i<$stoppoint-2) {$tablearray[] = $bigarray[$i];}
 unset($bigarray[$i]);
 }
$bigarray = array_values($bigarray);

//GROUPS
if (array_search("# QUESTIONS TABLE\n", $bigarray))
 {
 $stoppoint = array_search("# QUESTIONS TABLE\n", $bigarray);
 }
elseif (array_search("# QUESTIONS TABLE\r\n", $bigarray))
 {
 $stoppoint = array_search("# QUESTIONS TABLE\r\n", $bigarray);
 }
else
 {
 $stoppoint = count($bigarray)-1;
 }
for ($i=0; $i<=$stoppoint+1; $i++)
 {
 if ($i<$stoppoint-2) {$grouparray[] = $bigarray[$i];}
 unset($bigarray[$i]);
 }
$bigarray = array_values($bigarray);

//QUESTIONS
if (array_search("# ANSWERS TABLE\n", $bigarray))
 {
 $stoppoint = array_search("# ANSWERS TABLE\n", $bigarray);
 }
elseif (array_search("# ANSWERS TABLE\r\n", $bigarray))
 {
 $stoppoint = array_search("# ANSWERS TABLE\r\n", $bigarray);
 }
else
 {
 $stoppoint = count($bigarray)-1;
 }
for ($i=0; $i<=$stoppoint+1; $i++)
 {
 if ($i<$stoppoint-2) 
 {
 $questionarray[] = $bigarray[$i];
 }
 unset($bigarray[$i]);
 }
$bigarray = array_values($bigarray);

//ANSWERS
if (array_search("# CONDITIONS TABLE\n", $bigarray))
 {
 $stoppoint = array_search("# CONDITIONS TABLE\n", $bigarray);
 }
elseif (array_search("# CONDITIONS TABLE\r\n", $bigarray))
 {
 $stoppoint = array_search("# CONDITIONS TABLE\r\n", $bigarray);
 }
else
 {
 $stoppoint = count($bigarray)-1;
 }
for ($i=0; $i<=$stoppoint+1; $i++)
 {
 if ($i<$stoppoint-2) 
 {
 $answerarray[] = str_replace("`default`", "`default_value`", $bigarray[$i]);
 }
 unset($bigarray[$i]);
 }
$bigarray = array_values($bigarray);

//CONDITIONS
if (array_search("# LABELSETS TABLE\n", $bigarray))
 {
 $stoppoint = array_search("# LABELSETS TABLE\n", $bigarray);
 }
elseif (array_search("# LABELSETS TABLE\r\n", $bigarray))
 {
 $stoppoint = array_search("# LABELSETS TABLE\r\n", $bigarray);
 }
else
 { //There is no labelsets information, so presumably this is a pre-0.98rc3 survey.
 $stoppoint = count($bigarray);
 }
for ($i=0; $i<=$stoppoint+1; $i++)
 {
 if ($i<$stoppoint-2) {$conditionsarray[] = $bigarray[$i];}
 unset($bigarray[$i]);
 }
$bigarray = array_values($bigarray);

//LABELSETS
if (array_search("# LABELS TABLE\n", $bigarray))
 {
 $stoppoint = array_search("# LABELS TABLE\n", $bigarray);
 }
elseif (array_search("# LABELS TABLE\r\n", $bigarray))
 {
 $stoppoint = array_search("# LABELS TABLE\r\n", $bigarray);
 }
else
 {
 $stoppoint = count($bigarray)-1;
 }
for ($i=0; $i<=$stoppoint+1; $i++)
 {
 if ($i<$stoppoint-2) {$labelsetsarray[] = $bigarray[$i];}
 unset($bigarray[$i]);
 }
$bigarray = array_values($bigarray);

//LABELS
if (array_search("# QUESTION_ATTRIBUTES TABLE\n", $bigarray))
 {
 $stoppoint = array_search("# QUESTION_ATTRIBUTES TABLE\n", $bigarray);
 }
elseif (array_search("# QUESTION_ATTRIBUTES TABLE\r\n", $bigarray))
 {
 $stoppoint = array_search("# QUESTION_ATTRIBUTES TABLE\r\n", $bigarray);
 }
else
 {
 $stoppoint = count($bigarray)-1;
 }
for ($i=0; $i<=$stoppoint+1; $i++)
 {
 if ($i<$stoppoint-2) {$labelsarray[] = $bigarray[$i];}
 unset($bigarray[$i]);
 }
$bigarray = array_values($bigarray);

//QUESTION_ATTRIBUTES
if (array_search("# ASSESSMENTS TABLE\n", $bigarray))
 {
 $stoppoint = array_search("# ASSESSMENTS TABLE\n", $bigarray);
 }
elseif (array_search("# ASSESSMENTS TABLE\r\n", $bigarray))
 {
 $stoppoint = array_search("# ASSESSMENTS TABLE\r\n", $bigarray);
 }
else
 {
 $stoppoint = count($bigarray)-1;
 }
for ($i=0; $i<=$stoppoint+1; $i++)
 {
 if ($i<$stoppoint-2 || $i==count($bigarray)-1) {$question_attributesarray[] = $bigarray[$i];}
 unset($bigarray[$i]);
 }
$bigarray = array_values($bigarray);

//LAST LOT (now assessments)
if (!isset($noconditions) || $noconditions != "Y")
 {
 $stoppoint = count($bigarray)-1;
 for ($i=0; $i<=$stoppoint+1; $i++)
 {
 if ($i<$stoppoint-1) {$assessmentsarray[] = $bigarray[$i];}
 unset($bigarray[$i]);
 }
 }
$bigarray = array_values($bigarray);

//QUESTION_ATTRIBUTES

if (isset($tablearray)) {$countsurveys = count($tablearray);} else {$countsurveys = 0;}
if (isset($grouparray)) {$countgroups = count($grouparray);} else {$countgroups = 0;}
if (isset($questionarray)) {$countquestions = count($questionarray);} else {$countquestions=0;}
if (isset($answerarray)) {$countanswers = count($answerarray);} else {$countanswers=0;}
if (isset($conditionsarray)) {$countconditions = count($conditionsarray);} else {$countconditions=0;}
if (isset($labelsetsarray)) {$countlabelsets = count($labelsetsarray);} else {$countlabelsets=0;}
if (isset($labelsarray)) {$countlabels = count($labelsarray);} else {$countlabels=0;}
if (isset($question_attributesarray)) {$countquestion_attributes = count($question_attributesarray);} else {$countquestion_attributes=0;}
if (isset($assessmentsarray)) {$countassessments=count($assessmentsarray);} else {$countassessments=0;}

// CREATE SURVEY
$sfieldorders=convertToArray($tablearray[0], "`, `", "(`", "`)");
$sffieldcontents=convertToArray($tablearray[0], "', '", "('", "')");

$surveyidpos=array_search("sid", $sfieldorders);
$surveyid=$sffieldcontents[$surveyidpos];

if (!$surveyid) 
 {
 echo " "._ERROR." \n";
 echo _IS_IMPFAILED." \n";
 echo _IS_FILEFAILS." \n"; //Couldn't find the SID - cannot continue
 echo "<input $btstyle type='submit' value='"._GO_ADMIN."' onClick=\"window.open('$scriptname', '_top')\">\n";
 echo "</td></tr></table>\n";
 echo "</body>\n</html>\n";
 unlink($the_full_file_path); //Delete the uploaded file
 exit;
 }

// A regex could do alot better here but I am bad on that so I am using the simple way.
$insert=$tablearray[0];
$start = strpos(strtolower ($insert), 'values'); 
$start = strpos($insert, '(',$start)+1;
$end  = strpos($insert, ',',$start)+1;
$insert = substr($insert,0,$start).substr($insert,$end,strlen($insert));

$start = strpos($insert, '(')+1; 
$end = strpos($insert, ',')+1;
$insert = substr($insert,0,$start).substr($insert,$end,strlen($insert));

$insert = str_replace("INTO surveys", "INTO {$dbprefix}surveys", $insert); //handle db prefix
$iresult = mysql_query($insert) or die(" "._IS_IMPFAILED." \n[$insert]<hr>$tablearray[0] \n" . mysql_error() . "</body>\n</html>");

$oldsid=$surveyid;

//GET NEW SID
$newsid = mysql_insert_id();

//DO ANY LABELSETS FIRST, SO WE CAN KNOW WHAT THEIE NEW LID IS FOR THE QUESTIONS
if (isset($labelsetsarray) && $labelsetsarray) {
    $csarray=buildLabelsetCSArray();
    foreach ($labelsetsarray as $lsa) {
        $fieldorders=convertToArray($lsa, "`, `", "(`", "`)");
        $fieldcontents=convertToArray($lsa, "', '", "('", "')");
        $newfieldcontents=$fieldcontents;
        $oldlidpos=array_search("lid", $fieldorders);
        $oldlid=$fieldcontents[$oldlidpos];
        
        unset($newfieldcontents[array_search("lid", $fieldorders)]);
        $newvalues="('".implode("', '", $newfieldcontents)."')";
        $lsainsert = str_replace("('".implode("', '", $fieldcontents)."')", $newvalues, $lsa);
        $lsainsert = str_replace("INTO labelsets", "INTO {$dbprefix}labelsets", $lsainsert); //db prefix handler
        $lsainsert = str_replace("`lid`,", "", $lsainsert); //db prefix handler
        $lsiresult=mysql_query($lsainsert);
        $newlid=mysql_insert_id();

echo "OLDLID: $oldlid   NEWLID: $newlid";

if ($labelsarray) {
 foreach ($labelsarray as $la) {
 //GET ORDER OF FIELDS
 $lfieldorders=convertToArray($la, "`, `", "(`", "`)");
 $lfieldcontents=convertToArray($la, "', '", "('", "')");
 $newlfieldcontents=$lfieldcontents;
 $labellidpos=array_search("lid", $lfieldorders);
 $labellid=$lfieldcontents[$labellidpos];
 if ($labellid == $oldlid) {
 $newlfieldcontents[array_search("lid", $lfieldorders)]=$newlid;
 $newlvalues="('".implode("', '", $newlfieldcontents)."')";
 $lainsert = str_replace("('".implode("', '", $lfieldcontents)."')", $newlvalues, $la);
 //$lainsert = str_replace("'$labellid'", "'$newlid'", $la);
 $lainsert = str_replace ("INTO labels", "INTO {$dbprefix}labels", $lainsert);
 $liresult=mysql_query($lainsert);
 }
 }
 }
 
 //CHECK FOR DUPLICATE LABELSETS
 $thisset="";
 $query2 = "SELECT code, title, sortorder
 FROM {$dbprefix}labels
 WHERE lid=".$newlid."
 ORDER BY sortorder, code";
 $result2 = mysql_query($query2) or die("Died querying labelset $lid $query2 ".mysql_error());
 $numfields=mysql_num_fields($result2);
 while($row2=mysql_fetch_row($result2))
 {
 for ($i=0; $i<=$numfields-1; $i++)
 {
 $thisset .= $row2[$i];
 }
 } // while
 $newcs=dechex(crc32($thisset)*1);
 if (isset($csarray))
 {
 foreach($csarray as $key=>$val)
 {
 if ($val == $newcs)
 {
 $lsmatch=$key;
 }
 }
 }
 if (isset($lsmatch))
 {
 //There is a matching labelset. So, we will delete this one and refer
 //to the matched one.
 $query = "DELETE FROM {$dbprefix}labels WHERE lid=$newlid";
 $result=mysql_query($query) or die("Couldn't delete labels $query ".mysql_error());
 $query = "DELETE FROM {$dbprefix}labelsets WHERE lid=$newlid";
 $result=mysql_query($query) or die("Couldn't delete labelset $query ".mysql_error());
 $newlid=$lsmatch;
 }
 else
 {
 //There isn't a matching labelset, add this checksum to the $csarray array
 $csarray[$newlid]=$newcs;
 }
 //END CHECK FOR DUPLICATES
 $labelreplacements[]=array($oldlid, $newlid);
 }
}
// DO GROUPS, QUESTIONS FOR GROUPS, THEN ANSWERS FOR QUESTIONS IN A NESTED FORMAT!
if ($grouparray) {
 foreach ($grouparray as $ga) {
 //GET ORDER OF FIELDS
 $gafieldorders=convertToArray($ga, "`, `", "(`", "`)");
 $gacfieldcontents=convertToArray($ga, "', '", "('", "')");
 $gidpos=array_search("gid", $gafieldorders);
 $gid=$gacfieldcontents[$gidpos];
 $surveyidpos=array_search("sid", $gafieldorders);
 $gsid=$gacfieldcontents[$surveyidpos];
 if ($gsid != $surveyid) 
 {
 echo " \n"._ERROR.""
 ." \nA group in the sql file does not come from the same Survey. Import of survey stopped. \n"
 ."<input $btstyle type='submit' value='"._GO_ADMIN."' onClick=\"window.open('$scriptname?sid=$newsid', '_top')\">\n";
 exit;
 }
 //$gid = substr($ga, strpos($ga, "('")+2, (strpos($ga, "',")-(strpos($ga, "('")+2)));
 $ginsert = str_replace("('$gid', '$surveyid',", "('$newsid',", $ga);
 $ginsert = str_replace("(`gid`,", "(", $ginsert);
 $ginsert = str_replace("INTO groups", "INTO {$dbprefix}groups", $ginsert);
 $oldgid=$gid;
 $gres = mysql_query($ginsert) or die(""._ERROR." Failed to insert group \n$ginsert \n".mysql_error()."</body>\n</html>");
 //GET NEW GID
 $gidquery = "SELECT gid FROM {$dbprefix}groups ORDER BY gid DESC LIMIT 1";
 $gidres = mysql_query($gidquery);
 while ($grow = mysql_fetch_row($gidres)) {$newgid = $grow[0];}
 //NOW DO NESTED QUESTIONS FOR THIS GID
 if ($questionarray) {
 foreach ($questionarray as $qa) {
 $qafieldorders=convertToArray($qa, "`, `", "(`", "`)");
 $qacfieldcontents=convertToArray($qa, "', '", "('", "')");
 $newfieldcontents=$qacfieldcontents;
 $thisgid=$qacfieldcontents[array_search("gid", $qafieldorders)];
 if ($thisgid == $gid) {
 $qid = $qacfieldcontents[array_search("qid", $qafieldorders)];
 // Remove quid field
 unset($newfieldcontents[array_search("qid", $qafieldorders)]);
 $newfieldcontents[array_search("sid", $qafieldorders)] = $newsid;
 $newfieldcontents[array_search("gid", $qafieldorders)] = $newgid;
 $oldqid=$qid;
 $newvalues="('".implode("', '", $newfieldcontents)."')";
 $qinsert = str_replace ("('".implode("', '", $qacfieldcontents)."')", $newvalues, $qa);
 $qinsert = str_replace ("(`qid`,", "(", $qinsert);
 $qinsert = str_replace("INTO questions", "INTO {$dbprefix}questions", $qinsert);
 $type = $qacfieldcontents[array_search("type", $qafieldorders)]; //Get the type
 $other = $qacfieldcontents[array_search("other", $qafieldorders)]; //Get 'other';
 $qres = mysql_query($qinsert) or die (""._ERROR." Failed to insert question \n$qinsert \n".mysql_error()."</body>\n</html>");
 $qidquery = "SELECT qid, lid FROM {$dbprefix}questions ORDER BY qid DESC LIMIT 1"; //Get last question added (finds new qid)
 $qidres = mysql_query($qidquery);
 while ($qrow = mysql_fetch_array($qidres)) {$newqid = $qrow['qid']; $oldlid=$qrow['lid'];}
 if ($type == "F" || $type == "H" || $type == "W" || $type == "Z") {//IF this is a flexible label array, update the lid entry
 if (isset($labelreplacements)) {
 foreach ($labelreplacements as $lrp) {
 if ($lrp[0] == $oldlid) {
 $lrupdate="UPDATE {$dbprefix}questions SET lid='{$lrp[1]}' WHERE qid=$newqid";
 $lrresult=mysql_query($lrupdate);
 }
 }
 }
 }
 $newrank=0;
 $substitutions[]=array($oldsid, $oldgid, $oldqid, $newsid, $newgid, $newqid);
 //NOW DO NESTED ANSWERS FOR THIS QID
 if (isset($answerarray) && $answerarray) {
 foreach ($answerarray as $aa) {
 $aafieldorders=convertToArray($aa, "`, `", "(`", "`)");
 $aacfieldcontents=convertToArray($aa, "', '", "('", "')");
 $newfieldcontents=$aacfieldcontents;
 $code=$aacfieldcontents[array_search("code", $aafieldorders)];
 $thisqid=$aacfieldcontents[array_search("qid", $aafieldorders)];
 if ($thisqid == $qid) {
 $newfieldcontents[array_search("qid", $aafieldorders)]=$newqid;
 $newvalues="('".implode("', '", $newfieldcontents)."')";
 $ainsert = str_replace("('".implode("', '", $aacfieldcontents)."')", $newvalues, $aa);
 $ainsert = str_replace("INTO answers", "INTO {$dbprefix}answers", $ainsert);
 $ares = mysql_query($ainsert) or die (""._ERROR." Failed to insert answer \n$ainsert \n".mysql_error()."</body>\n</html>");
 if ($type == "M" || $type == "P") {
 $fieldnames[]=array("oldcfieldname"=>$oldsid."X".$oldgid."X".$oldqid, 
 "newcfieldname"=>$newsid."X".$newgid."X".$newqid, 
 "oldfieldname"=>$oldsid."X".$oldgid."X".$oldqid.$code, 
 "newfieldname"=>$newsid."X".$newgid."X".$newqid.$code);
 if ($type == "P") {
 $fieldnames[]=array("oldcfieldname"=>$oldsid."X".$oldgid."X".$oldqid."comment", 
 "newcfieldname"=>$newsid."X".$newgid."X".$newqid.$code."comment", 
 "oldfieldname"=>$oldsid."X".$oldgid."X".$oldqid.$code."comment", 
 "newfieldname"=>$newsid."X".$newgid."X".$newqid.$code."comment");
 }
 }
 elseif ($type == "A" || $type == "B" || $type == "C" || $type == "F" || $type == "H") {
 $fieldnames[]=array("oldcfieldname"=>$oldsid."X".$oldgid."X".$oldqid.$code, 
 "newcfieldname"=>$newsid."X".$newgid."X".$newqid.$code, 
 "oldfieldname"=>$oldsid."X".$oldgid."X".$oldqid.$code, 
 "newfieldname"=>$newsid."X".$newgid."X".$newqid.$code);
 }
 elseif ($type == "R") {
 $newrank++;
 }
 } 
 }
 if (($type == "A" || $type == "B" || $type == "C" || $type == "M" || $type == "P" || $type == "L") && ($other == "Y")) {
 $fieldnames[]=array("oldcfieldname"=>$oldsid."X".$oldgid."X".$oldqid."other", 
 "newcfieldname"=>$newsid."X".$newgid."X".$newqid."other", 
 "oldfieldname"=>$oldsid."X".$oldgid."X".$oldqid."other", 
 "newfieldname"=>$newsid."X".$newgid."X".$newqid."other");
 if ($type == "P") {
 $fieldnames[]=array("oldcfieldname"=>$oldsid."X".$oldgid."X".$oldqid."othercomment", 
 "newcfieldname"=>$newsid."X".$newgid."X".$newqid."othercomment", 
 "oldfieldname"=>$oldsid."X".$oldgid."X".$oldqid."othercomment", 
 "newfieldname"=>$newsid."X".$newgid."X".$newqid."othercomment");
 }
 }
 if ($type == "R" && $newrank >0) {
 for ($i=1; $i<=$newrank; $i++) {
 $fieldnames[]=array("oldcfieldname"=>$oldsid."X".$oldgid."X".$oldqid.$i, 
 "newcfieldname"=>$newsid."X".$newgid."X".$newqid.$i, 
 "oldfieldname"=>$oldsid."X".$oldgid."X".$oldqid.$i, 
 "newfieldname"=>$newsid."X".$newgid."X".$newqid.$i);
 }
 }
 if ($type != "A" && $type != "B" && $type != "C" && $type != "R" && $type != "M" && $type != "P") {
 $fieldnames[]=array("oldcfieldname"=>$oldsid."X".$oldgid."X".$oldqid, 
 "newcfieldname"=>$newsid."X".$newgid."X".$newqid, 
 "oldfieldname"=>$oldsid."X".$oldgid."X".$oldqid, 
 "newfieldname"=>$newsid."X".$newgid."X".$newqid); 
 if ($type == "O") {
 $fieldnames[]=array("oldcfieldname"=>$oldsid."X".$oldgid."X".$oldqid."comment", 
 "newcfieldname"=>$newsid."X".$newgid."X".$newqid."comment", 
 "oldfieldname"=>$oldsid."X".$oldgid."X".$oldqid."comment", 
 "newfieldname"=>$newsid."X".$newgid."X".$newqid."comment");
 }
 }
 } else {
 $fieldnames[]=array("oldcfieldname"=>$oldsid."X".$oldgid."X".$oldqid, 
 "newcfieldname"=>$newsid."X".$newgid."X".$newqid, 
 "oldfieldname"=>$oldsid."X".$oldgid."X".$oldqid, 
 "newfieldname"=>$newsid."X".$newgid."X".$newqid);
 }
 }
 }
 }
 }
}
//We've built two arrays along the way - one containing the old SID, GID and QIDs - and their NEW equivalents
//and one containing the old 'extended fieldname' and its new equivalent. These are needed to import conditions and question_attributes.
if (isset($question_attributesarray) && $question_attributesarray) {//ONLY DO THIS IF THERE ARE QUESTION_ATTRIBUES
 foreach ($question_attributesarray as $qar) {
 $fieldorders=convertToArray($qar, "`, `", "(`", "`)");
 $fieldcontents=convertToArray($qar, "', '", "('", "')");
 $newfieldcontents=$fieldcontents;
 $newqid="";
 $oldqid=$fieldcontents[array_search("qid", $fieldorders)];
 foreach ($substitutions as $subs) {
 if ($oldqid==$subs[2]) {$newqid=$subs[5];}
 }
 
 $newfieldcontents[array_search("qid", $fieldorders)]=$newqid;
 unset($newfieldcontents[array_search("qaid", $fieldorders)]);
 
 $newvalues="('".implode("', '", $newfieldcontents)."')";
 $insert=str_replace("('".implode("', '", $fieldcontents)."')", $newvalues, $qar);
 $insert=str_replace("INTO question_attributes", "INTO {$dbprefix}question_attributes", $insert);
 $insert=str_replace("`qaid`,", "", $insert);
 $result=mysql_query($insert) or die ("Couldn't insert question_attribute $insert ".mysql_error());

unset($newqid);
    }
}

if (isset($assessmentsarray) && $assessmentsarray) {//ONLY DO THIS IF THERE ARE QUESTION_ATTRIBUES
 foreach ($assessmentsarray as $qar) {
 $fieldorders=convertToArray($qar, "`, `", "(`", "`)");
 $fieldcontents=convertToArray($qar, "', '", "('", "')");
 $newfieldcontents=$fieldcontents;
 $oldsid=$fieldcontents[array_search("sid", $fieldorders)];
 $oldgid=$fieldcontents[array_search("gid", $fieldorders)];
 foreach ($substitutions as $subs) {
 if ($oldsid==$subs[0]) {$newsid=$subs[3];}
 if ($oldgid==$subs[1]) {$newgid=$subs[4];}
 }
 
 $newfieldcontents[array_search("sid", $fieldorders)]=$newsid;
 $newfieldcontents[array_search("gid", $fieldorders)]=$newgid;
 unset($newfieldcontents[array_search("id", $fieldorders)]);
 
 $newvalues="('".implode("', '", $newfieldcontents)."')";
 $insert=str_replace("('".implode("', '", $fieldcontents)."')", $newvalues, $qar);
 $insert=str_replace("INTO assessments", "INTO {$dbprefix}assessments", $insert);
 $insert=str_replace("`id`,", "", $insert);
 $result=mysql_query($insert) or die ("Couldn't insert assessment $insert ".mysql_error());

unset($newgid);
    }
}

if (isset($conditionsarray) && $conditionsarray) {//ONLY DO THIS IF THERE ARE CONDITIONS!
 foreach ($conditionsarray as $car) {
 $fieldorders=convertToArray($car, "`, `", "(`", "`)");
 $fieldcontents=convertToArray($car, "', '", "('", "')");
 $newfieldcontents=$fieldcontents;
 $oldcid=$fieldcontents[array_search("cid", $fieldorders)];
 $oldqid=$fieldcontents[array_search("qid", $fieldorders)];
 $oldcfieldname=$fieldcontents[array_search("cfieldname", $fieldorders)];
 $oldcqid=$fieldcontents[array_search("cqid", $fieldorders)];
 $thisvalue=$fieldcontents[array_search("value", $fieldorders)];
 foreach ($substitutions as $subs) {
 if ($oldqid==$subs[2]) {$newqid=$subs[5];}
 if ($oldcqid==$subs[2]) {$newcqid=$subs[5];}
 }
 foreach($fieldnames as $fns) {
 //if the $fns['oldcfieldname'] is not the same as $fns['oldfieldname'] then this is a multiple type question
 if ($fns['oldcfieldname'] == $fns['oldfieldname']) { //The normal method - non multiples
 if ($oldcfieldname==$fns['oldcfieldname']) {
 $newcfieldname=$fns['newcfieldname'];
 }
 } else {
 if ($oldcfieldname == $fns['oldcfieldname'] && $oldcfieldname.$thisvalue == $fns['oldfieldname']) {
 $newcfieldname=$fns['newcfieldname'];
 }
 }
 }
 if (!isset($newcfieldname)) {$newcfieldname="";}
 unset($newfieldcontents[array_search("cid", $fieldorders)]);
 $newfieldcontents[array_search("qid", $fieldorders)]=$newqid;
 $newfieldcontents[array_search("cfieldname", $fieldorders)]=$newcfieldname;
 if (isset($newcqid)) {
 $newfieldcontents[array_search("cqid", $fieldorders)]=$newcqid;
 $newvalues="('".implode("', '", $newfieldcontents)."')";
 $insert=str_replace("('".implode("', '", $fieldcontents)."')", $newvalues, $car);
 $insert=str_replace("INTO conditions", "INTO {$dbprefix}conditions", $insert);
 $insert=str_replace("`cid`,", "", $insert);
 $result=mysql_query($insert) or die ("Couldn't insert condition $insert ".mysql_error());
 } else {
 echo "Condition for $oldqid skipped ($oldcqid does not exist) ";
 }
 unset($newcqid);
 }
}

echo " \n"._SUCCESS." \n";
echo ""._IS_IMPORTSUMMARY." \n";
echo "<ul>\n\t<li>"._SURVEYS.": $countsurveys</li>\n";
echo "\t<li>"._GROUPS.": $countgroups</li>\n";
echo "\t<li>"._QUESTIONS.": $countquestions</li>\n";
echo "\t<li>"._ANSWERS.": $countanswers</li>\n";
echo "\t<li>"._CONDITIONS.": $countconditions</li>\n";
echo "\t<li>"._LABELSET.": $countlabelsets ("._LABELANS.": $countlabels)</li>\n";
echo "\t<li>"._QL_QUESTIONATTRIBUTES." $countquestion_attributes</li>\n";
echo "\t<li>"._AS_TITLE." $countassessments</li>\n</ul>\n";

echo ""._IS_SUCCESS." \n";
echo "<input $btstyle type='submit' value='"._GO_ADMIN."' onClick=\"window.open('$scriptname?sid=$newsid', '_top')\">\n";

echo "</td></tr></table>\n";
echo "</body>\n</html>";
unlink($the_full_file_path);

function convertToArray($string, $seperator, $start, $end) {
    $begin=strpos($string, $start)+strlen($start);
    $len=strpos($string, $end)-$begin;
    $order=substr($string, $begin, $len);
    $orders=explode($seperator, $order);
    return $orders;
}
?>

${this.title}

Code Editor : importsurvey.php