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

<?php
/*
	#############################################################
	# >>> PHPSurveyor  										    #
	#############################################################
	# > Author:  Jason Cleeland									#
	# > E-mail:  jason@cleeland.org								#
	# > Mail:    Box 99, Trades Hall, 54 Victoria St,			#
	# >          CARLTON SOUTH 3053, AUSTRALIA					#
 	# > Date: 	 19 April 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');

$surveyid=returnglobal('sid');

//Ensure script is not run directly, avoid path disclosure
if (empty($surveyid)) {die("No SID provided.");}

$query = "SELECT language FROM {$dbprefix}surveys WHERE sid=$surveyid";
$result = mysql_query($query) or die("Error selecting language: <br />".$query."<br />".mysql_error());
while ($row=mysql_fetch_array($result)) {$surveylanguage = $row['language'];}
$langdir="$publicdir/lang";
$langfilename="$langdir/$surveylanguage.lang.php";
if (!is_file($langfilename)) {$langfilename="$langdir/$defaultlang.lang.php";}
require($langfilename);

sendcacheheaders();

if(isset($_POST['cquestions'])) {
	echo str_replace("<body ", "<body onload='getAnswers(\"".$_POST['cquestions']."\")'", $htmlheader);
} else {
	echo $htmlheader;
}

echo "<table width='100%' border='0' bgcolor='#555555' cellspacing='0' cellpadding='0'>\n"
	."\t<tr><td align='center'>$setfont<font color='white'><strong>"
	._CD_CONDITIONDESIGNER."</strong></font></font></td></tr>\n"
	."</table>\n";

if (!isset($surveyid))
	{
	echo "<br /><center>$setfont<strong>"
		._CD_NOSID." "._CD_NODIRECT
		."</strong></font></center>\n"
		."</body></html>\n";
	exit;
	}
if (!isset($_GET['qid']) && !isset($_POST['qid']))
	{
	echo "<br /><center>$setfont<strong>"
		._CD_NOQID." "._CD_NODIRECT
		."</strong></font></center>\n"
		."</body></html>\n";
	exit;
	}

//ADD NEW ENTRY IF THIS IS AN ADD
if (isset($_POST['action']) && $_POST['action'] == "insertcondition")
	{
	if (!isset($_POST['canswers']) || !isset($_POST['cquestions']))
		{
		echo "<script type=\"text/javascript\">\n\n</script>\n";				
		}
	else
		{
		foreach ($_POST['canswers'] as $ca)
			{
			$query = "INSERT INTO {$dbprefix}conditions (qid, cqid, cfieldname, value) VALUES "
				   . "('{$_POST['qid']}', '{$_POST['cqid']}', '{$_POST['cquestions']}', '$ca')";
			$result = mysql_query($query) or die ("Couldn't insert new condition<br />$query<br />".mysql_error());
			}
		}
	}
//DELETE ENTRY IF THIS IS DELETE
if (isset($_POST['action']) && $_POST['action'] == "delete")
	{
	$query = "DELETE FROM {$dbprefix}conditions WHERE cid={$_POST['cid']}";
	$result = mysql_query($query) or die ("Couldn't delete condition<br />$query<br />".mysql_error());
	}
//COPY CONDITIONS IF THIS IS COPY
if (isset($_POST['action']) && $_POST['action'] == "copyconditions") 
	{
	$qid=returnglobal('qid');
	$copyconditionsfrom=returnglobal('copyconditionsfrom');
	$copyconditionsto=returnglobal('copyconditionsto');
	if (isset($copyconditionsto) && is_array($copyconditionsto) && isset($copyconditionsfrom) && is_array($copyconditionsfrom)) 
		{
		//Get the conditions we are going to copy
		$query = "SELECT * FROM {$dbprefix}conditions\n"
				."WHERE cid in ('";
		$query .= implode("', '", $copyconditionsfrom);
		$query .= "')";
		$result = mysql_query($query) or die("Couldn't get conditions for copy<br />$query<br />".mysql_error());
		while($row=mysql_fetch_array($result))
			{
			$proformaconditions[]=array("cqid"=>$row['cqid'],
										"cfieldname"=>$row['cfieldname'],
										"method"=>$row['method'],
										"value"=>$row['value']);
			} // while
		foreach ($copyconditionsto as $copyc)
			{
			list($newsid, $newgid, $newqid)=explode("X", $copyc);
			foreach ($proformaconditions as $pfc)
				{
				//First lets make sure there isn't already an exact replica of this condition
				$query = "SELECT * FROM {$dbprefix}conditions\n"
						."WHERE qid='$newqid'\n"
						."AND cqid='".$pfc['cqid']."'\n"
						."AND cfieldname='".$pfc['cfieldname']."'\n"
						."AND method='".$pfc['method']."'\n"
						."AND value='".$pfc['value']."'";
				$result = mysql_query($query) or die("Couldn't check for existing condition<br />$query<br />".mysql_error());
				$count = mysql_num_rows($result);
				if ($count == 0) //If there is no match, add the condition.
					{
					$query = "INSERT INTO {$dbprefix}conditions ( qid,cqid,cfieldname,method,value) \n"
							."VALUES ( '$newqid', '".$pfc['cqid']."',"
							."'".$pfc['cfieldname']."', '".$pfc['method']."',"
							."'".$pfc['value']."')";
					$result=mysql_query($query) or die ("Couldn't insert query<br />$query<br />".mysql_error());
					}
				}
			}
		}
	else
		{
		$message = _CD_DIDNOTCOPYQ.": ";
		if (!isset($copyconditionsfrom))
			{
		    $message .= _CD_NOCONDITIONTOCOPY.". ";
			}
		if (!isset($copyconditionsto)) 
			{
		    $message .= _CD_NOQUESTIONTOCOPYTO.".";
			}
		echo "<script type=\"text/javascript\">\n\n</script>\n";
		}
	}

unset($cquestions);
unset($canswers);

// *******************************************************************
// ** ADD FORM
// *******************************************************************
//1: Get information for this question
if (!isset($qid)) {$qid=returnglobal('qid');}
if (!isset($surveyid)) {$surveyid=returnglobal('sid');}

$query = "SELECT * FROM {$dbprefix}questions, {$dbprefix}groups\n"
		."WHERE {$dbprefix}questions.gid={$dbprefix}groups.gid\n"
		."AND qid=$qid";
$result = mysql_query($query) or die ("Couldn't get information for question $qid<br />$query<br />".mysql_error());
while ($rows=mysql_fetch_array($result))
	{
	$questiongroupname=$rows['group_name'];
	$questiontitle=$rows['title'];
	$questiontext=$rows['question'];
	$questiontype=$rows['type'];
	}

//2: Get all other questions that occur before this question that are pre-determined answer types

//TO AVOID NATURAL SORT ORDER ISSUES, FIRST GET ALL QUESTIONS IN NATURAL SORT ORDER, AND FIND OUT WHICH NUMBER IN THAT ORDER THIS QUESTION IS
$qquery = "SELECT *\n"
		. "FROM {$dbprefix}questions, {$dbprefix}groups\n"
		."WHERE {$dbprefix}questions.gid={$dbprefix}groups.gid\n"
		."AND {$dbprefix}questions.sid=$surveyid\n";

$qresult = mysql_query($qquery) or die ("$qquery<br />".mysql_error());
$qrows = array(); //Create an empty array in case mysql_fetch_array does not return any rows
while ($qrow = mysql_fetch_assoc($qresult)) {$qrows[] = $qrow;} // Get table output into array
usort($qrows, 'CompareGroupThenTitle'); // Perform a case insensitive natural sort on group name then question title of a multidimensional array

$position="before";
foreach ($qrows as $qrow) //Go through each question until we reach the current one
	{
	if ($qrow["qid"] != $qid && $position=="before") 
		{
		if ($qrow['type'] != "S" && $qrow['type'] != "D" && $qrow['type'] != "T" && $qrow['type'] != "Q")
			{
			$questionlist[]=$qrow["qid"];
			}
		}
	elseif ($qrow["qid"] == $qid)
		{
		break;
		}
	}

//Now, using the same array which is now properly sorted by group then question
//Create an array of all the questions that appear AFTER the current one
$position = "before";
foreach ($qrows as $qrow) //Go through each question until we reach the current one
	{
	if ($qrow["qid"] == $qid)
		{
		$position="after";
		//break;
		}
	elseif ($qrow["qid"] != $qid && $position=="after")
		{
		$postquestionlist[]=$qrow['qid'];
		}
	}

$theserows=array();
if (isset($questionlist) && is_array($questionlist))
	{
	foreach ($questionlist as $ql)
		{
		$query = "SELECT {$dbprefix}questions.qid, {$dbprefix}questions.sid, {$dbprefix}questions.gid, {$dbprefix}questions.question, {$dbprefix}questions.type, {$dbprefix}questions.lid, {$dbprefix}questions.title FROM {$dbprefix}questions, {$dbprefix}groups WHERE {$dbprefix}questions.gid={$dbprefix}groups.gid AND {$dbprefix}questions.qid=$ql";
		$result=mysql_query($query) or die("Couldn't get question $qid");
		$thiscount=mysql_num_rows($result);
		while ($myrows=mysql_fetch_array($result)) 
			{
			$theserows[]=array("qid"=>$myrows['qid'], "sid"=>$myrows['sid'], "gid"=>$myrows['gid'], "question"=>$myrows['question'], "type"=>$myrows['type'], "lid"=>$myrows['lid'], "title"=>$myrows['title']);
			}
		}
	}

if (isset($postquestionlist) && is_array($postquestionlist))
	{
	foreach ($postquestionlist as $pq)
		{
		$query = "SELECT {$dbprefix}questions.qid, {$dbprefix}questions.sid, {$dbprefix}questions.gid, {$dbprefix}questions.question, {$dbprefix}questions.type, {$dbprefix}questions.lid, {$dbprefix}questions.title FROM {$dbprefix}questions, {$dbprefix}groups WHERE {$dbprefix}questions.gid={$dbprefix}groups.gid AND {$dbprefix}questions.qid=$pq";
		$result = mysql_query($query) or die("Couldn't get postquestions $qid<br />$query<br />".mysql_error());
		$postcount=mysql_num_rows($result);
		while($myrows=mysql_fetch_array($result))
			{
			$postrows[]=array("qid"=>$myrows['qid'], "sid"=>$myrows['sid'], "gid"=>$myrows['gid'], "question"=>$myrows['question'], "type"=>$myrows['type'], "lid"=>$myrows['lid'], "title"=>$myrows['title']);
			} // while
		}
	$postquestionscount=count($postrows);
	}

$questionscount=count($theserows);

if (isset($postquestionscount) && $postquestionscount > 0) //Build the select box for questions after this one
	{
	foreach ($postrows as $pr)
		{
		$pquestions[]=array("text"=>$pr['title'].": ".substr($pr['question'], 0, 30),
							"fieldname"=>$pr['sid']."X".$pr['gid']."X".$pr['qid']);
		}
	}

if ($questionscount > 0)
	{
	$X="X";
	foreach($theserows as $rows)
		{
		if (strlen($rows['question']) > 30) {$shortquestion=$rows['title'].": ".substr(strip_tags($rows['question']), 0, 30).".. ";}
		else {$shortquestion=$rows['title'].": ".strip_tags($rows['question']);}
		if ($rows['type'] == "A" || $rows['type'] == "B" || $rows['type'] == "C" || $rows['type'] == "E" || $rows['type'] == "F" || $rows['type'] == "H")
			{
			$aquery="SELECT * FROM {$dbprefix}answers WHERE qid={$rows['qid']} ORDER BY sortorder, answer";
			$aresult=mysql_query($aquery) or die ("Couldn't get answers to Array questions<br />$aquery<br />".mysql_error());
			while ($arows = mysql_fetch_array($aresult))
				{
				if (strlen($arows['answer']) > 10) {$shortanswer=substr($arows['answer'], 0, 10).".. ";}
				else {$shortanswer = $arows['answer'];}
				$shortanswer .= " [{$arows['code']}]";
				$cquestions[]=array("$shortquestion [$shortanswer]", $rows['qid'], $rows['type'], $rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$arows['code']);
				switch ($rows['type'])
					{
					case "A":
						for ($i=1; $i<=5; $i++)
							{
							$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$arows['code'], $i, $i);
							}
						break;
					case "B":
						for ($i=1; $i<=10; $i++)
							{
							$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$arows['code'], $i, $i);
							}
						break;
					case "C":
						$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$arows['code'], "Y", _YES);
						$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$arows['code'], "U", _UNCERTAIN);
						$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$arows['code'], "N", _NO);
						break;
					case "E":
						$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$arows['code'], "I", _INCREASE);
						$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$arows['code'], "S", _SAME);
						$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$arows['code'], "D", _DECREASE);
						break;
					case "F":
					case "H":
						$fquery = "SELECT * FROM {$dbprefix}labels\n"
								. "WHERE lid={$rows['lid']}\n"
								. "ORDER BY sortorder, code";
						$fresult = mysql_query($fquery);
						while ($frow=mysql_fetch_array($fresult))
							{
							$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$arows['code'], $frow['code'], $frow['title']);
							}
						break;
					}
				$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$arows['code'], "", _NOANSWER);
				}
			}
		elseif ($rows['type'] == "R")
			{
			$aquery="SELECT * FROM {$dbprefix}answers\n"
				   ."WHERE qid={$rows['qid']}\n"
				   ."ORDER BY sortorder, answer"; 
			$aresult=mysql_query($aquery) or die ("Couldn't get answers to Ranking question<br />$aquery<br />".mysql_error());
			$acount=mysql_num_rows($aresult);
			while ($arow=mysql_fetch_array($aresult))
				{
				$theanswer = addcslashes($arow['answer'], "'");
				$quicky[]=array($arow['code'], $theanswer);
				}
			for ($i=1; $i<=$acount; $i++)
				{
				$cquestions[]=array("$shortquestion [RANK $i]", $rows['qid'], $rows['type'], $rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$i);
				foreach ($quicky as $qck)
					{
					$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$i, $qck[0], $qck[1]);
					}
				$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$i, "", _NOANSWER);
				}
			unset($quicky);
			}
		else
			{
			$cquestions[]=array($shortquestion, $rows['qid'], $rows['type'], $rows['sid'].$X.$rows['gid'].$X.$rows['qid']);
			switch ($rows['type'])
				{
				case "Y":
					$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'], "Y", _YES);
					$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'], "N", _NO);
					$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'], "", _NOANSWER);
					break;
				case "G":
					$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'], "F", _FEMALE);
					$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'], "M", _MALE);
					$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'], "", _NOANSWER);
					break;
				case "5":
					for ($i=1; $i<=5; $i++)
						{
						$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'], $i, $i);
						}
					$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'], "", _NOANSWER);
					break;
				case "W":
				case "Z":
					$fquery = "SELECT * FROM {$dbprefix}labels\n"
						. "WHERE lid={$rows['lid']}\n"
						. "ORDER BY sortorder, code";
					
					$fresult = mysql_query($fquery);
					while ($frow=mysql_fetch_array($fresult))
						{
						$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'].$arows['code'], $frow['code'], $frow['title']);
						}
					break;
				default:
					$aquery="SELECT * FROM {$dbprefix}answers\n"
						   ."WHERE qid={$rows['qid']}\n"
						   ."ORDER BY sortorder, answer";
					$aresult=mysql_query($aquery) or die ("Couldn't get answers to Ranking question<br />$aquery<br />".mysql_error());
					while ($arows=mysql_fetch_array($aresult))
						{
						$theanswer = addcslashes($arows['answer'], "'");
						$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'], $arows['code'], $theanswer);
						}
					if ($rows['type'] != "M" && $rows['type'] != "P")
						{
						$canswers[]=array($rows['sid'].$X.$rows['gid'].$X.$rows['qid'], "", _NOANSWER);
						}
					break;
				}
			}
		}
	}

//JAVASCRIPT TO SHOW MATCHING ANSWERS TO SELECTED QUESTION
echo "<script type='text/javascript'>\n"
	."<!--\n"
	."\tvar Fieldnames = new Array();\n"
	."\tvar Codes = new Array();\n"
	."\tvar Answers = new Array();\n"
	."\tvar QFieldnames = new Array();\n"
	."\tvar Qcqids = new Array();\n";
$jn=0;
if (isset($canswers))
	{
	foreach($canswers as $can)
		{
		$an=str_replace("'", "`", $can[2]);
		echo "\t\tFieldnames[$jn]='$can[0]';\n"
			."\t\tCodes[$jn]='$can[1]';\n"
			."\t\tAnswers[$jn]='$an';\n";
		$jn++;
	}
}
$jn=0;

if (isset($cquestions))
	{
	foreach ($cquestions as $cqn)
		{
		echo "\t\tQFieldnames[$jn]='$cqn[3]';\n"
			."\t\tQcqids[$jn]='$cqn[1]';\n";
		$jn++;
		}
}	
echo "\n"
	."\tfunction clearAnswers()\n"
	."\t\t{\n"
	."\t\t\tfor (var i=document.getElementById('canswers').options.length-1; i>=0; i--)\n"
	."\t\t\t\t{\n";
//echo "alert(i);\n";
echo "\t\t\t\t\tdocument.getElementById('canswers').options[i] = null;\n"
	."\t\t\t\t}\n"
	."\t\t}\n";

echo "\tfunction getAnswers(fname)\n"
	."\t\t{\n";
//echo "\t\talert(getElementById('canswers').options.length)\n";
//echo "\t\t\t{\n";
echo "\t\t\tfor (var i=document.getElementById('canswers').options.length-1; i>=0; i--)\n"
	."\t\t\t\t{\n";
//echo "alert(i);\n";
echo "\t\t\t\t\tdocument.getElementById('canswers').options[i] = null;\n"
	."\t\t\t\t}\n";
//echo "\t\t\t}\n";
//echo "\t\t\talert(fname);\n";
echo "\t\t\tvar Keys = new Array();\n"
	."\t\t\tfor (var i=0;i<Fieldnames.length;i++)\n"
	."\t\t\t\t{\n"
	."\t\t\t\tif (Fieldnames[i] == fname)\n"
	."\t\t\t\t\t{\n"
	."\t\t\t\t\tKeys[Keys.length]=i;\n"
	."\t\t\t\t\t}\n"
	."\t\t\t\t}\n"
	."\t\t\tfor (var i=0;i<QFieldnames.length;i++)\n"
	."\t\t\t\t{\n"
	."\t\t\t\tif (QFieldnames[i] == fname)\n"
	."\t\t\t\t\t{\n"
	."\t\t\t\t\tdocument.getElementById('cqid').value=Qcqids[i];\n"
	."\t\t\t\t\t}\n"
	."\t\t\t\t}\n";
//echo "\t\t\talert(Keys.length);\n";
echo "\t\t\tfor (var i=0;i<Keys.length;i++)\n"
	."\t\t\t\t{\n";
//echo "\t\t\t\talert(Answers[Keys[i]]);\n";
echo "\t\t\t\tdocument.getElementById('canswers').options[document.getElementById('canswers').options.length] = new Option(Answers[Keys[i]], Codes[Keys[i]]);\n"
	."\t\t\t\t}\n"
	."\t\t}\n"
	."//-->\n"
	."</script>\n";

//SHOW FORM TO CREATE IT!
echo "<table width='100%' align='center' cellspacing='0' cellpadding='0' style='border-style: solid; border-width: 1; border-color: #555555'>\n"
	."\t<tr bgcolor='#CCFFCC'>\n"
	."\t\t<td  align='center' >\n";
$showreplace="$questiontitle<img src='$imagefiles/speaker.jpg' alt=\""
	. htmlspecialchars($questiontext)
	. "\" onClick=\"alert('"
	. htmlspecialchars(addslashes(strip_tags($questiontext)))
	. "')\">";
$onlyshow=str_replace("{QID}", $showreplace, _CD_ONLYSHOW);
echo "\t\t\t$setfont<strong>$onlyshow</strong></font>\n"
	."\t\t</td>\n"
	."\t</tr>\n";

//3: Get other conditions currently set for this question
$query = "SELECT {$dbprefix}conditions.cid, {$dbprefix}conditions.cqid, {$dbprefix}conditions.cfieldname, {$dbprefix}conditions.value, {$dbprefix}questions.type\n"
		."FROM {$dbprefix}conditions, {$dbprefix}questions\n"
		."WHERE {$dbprefix}conditions.cqid={$dbprefix}questions.qid\n"
		."AND {$dbprefix}conditions.qid=$qid\n"
		."ORDER BY {$dbprefix}conditions.cfieldname";
$result = mysql_query($query) or die ("Couldn't get other conditions for question $qid<br />$query<br />".mysql_error());
$conditionscount=mysql_num_rows($result);

if ($conditionscount > 0)
	{
	while ($rows=mysql_fetch_array($result))
		{
		if (isset($currentfield) && $currentfield != $rows['cfieldname'])
			{
			echo "\t\t\t\t<tr bgcolor='#E1FFE1'>\n"
				."\t\t\t\t\t<td valign='middle' align='center'>\n"
				."$setfont<font size='1'><strong>"
				._AND."</strong></font></font>";
			}
		elseif (isset($currentfield))
			{
			echo "\t\t\t\t<tr bgcolor='#E1FFE1'>\n"
				."\t\t\t\t\t<td valign='top' align='center'>\n"
				."$setfont<font size='1'><strong>"
				._AD_OR."</strong></font></font>";
			}
		echo "\t<tr bgcolor='#E1FFE1'>\n"
			."\t<td><form style='margin-bottom:0;' name='del{$rows['cid']}' id='del{$rows['cid']}' method='post' action='{$_SERVER['PHP_SELF']}'>\n"
			."\t\t<table width='100%' style='height: 13px;' cellspacing='0' cellpadding='0'><tr><td valign='middle' align='right' width='50%'><font size='1' face='verdana'>\n";
		//BUILD FIELDNAME?
		foreach ($cquestions as $cqn)
			{
			if ($cqn[3] == $rows['cfieldname'])
				{
				echo "\t\t\t$cqn[0] (qid{$rows['cqid']})\n";
				$conditionsList[]=array("cid"=>$rows['cid'],
										"text"=>$cqn[0]." ({$rows['value']})");
				}
			else
				{
				//echo "\t\t\t<font color='red'>ERROR: Delete this condition. It is out of order.</font>\n";
				}
			}
		echo "\t\t</font></td>\n"
			."\t\t<td align='center' valign='middle' width='15%'>$setfont<font size='1'>"
			._CD_EQUALS."</font></font></td>"
			."\t\t\t\t\n"
			."\t\t\t\t\t<td align='left' valign='middle' width='30%'>\n"
			."\t\t\t\t\t\t<font size='1' face='verdana'>\n";
		foreach ($canswers as $can)
			{
			//echo $rows['cfieldname'] . "- $can[0]<br />";
			//echo $can[1];
			if ($can[0] == $rows['cfieldname'] && $can[1] == $rows['value'])
				{
				echo "\t\t\t\t\t\t$can[2] ($can[1])\n";
				}
			}
		echo "\t\t\t\t\t</font></td>\n"
			."\t\t\t\t\t<td align='right' valign='middle' >\n"
			."\t\t\t\t\t\t<input type='submit' value='Del' style='font-family: verdana; font-size: 8; height:15'>\n"
			."\t\t\t\t\t<input type='hidden' name='action' value='delete'>\n"
			."\t\t\t\t\t<input type='hidden' name='cid' value='{$rows['cid']}'>\n"
			."\t\t\t\t\t<input type='hidden' name='sid' value='$surveyid'>\n"
			."\t\t\t\t\t<input type='hidden' name='qid' value='$qid'>\n"
			."\t\t\t\t\t</td>\n"
			."\t</table></form>\n"
			."\t</tr>\n";
		$currentfield=$rows['cfieldname'];
		}
	echo "\t<tr>\n"
		."\t\t<td height='3'>\n"
		."\t\t</td>\n"
		."\t</tr>\n";
	}
else
	{
	echo "\t<tr>\n"
		."\t\t<td colspan='3' height='3'>\n"
		."\t\t</td>\n"
		."\t</tr>\n";
	}

echo "\t<tr bgcolor='#555555'><td colspan='3'></td></tr>\n";

if ($conditionscount > 0 && isset($postquestionscount) && $postquestionscount > 0) 
	{
	echo "<tr bgcolor='#555555'><td colspan='3'><form action='".$_SERVER['PHP_SELF']."' name='copyconditions' id='copyconditions' method='post'>\n";

echo "\t<table width='100%'><tr bgcolor='#CDCDCD'>\n"
		."\t\t<td colspan='3' align='center'>\n"
		."\t\t$setfont<strong>"
		._CD_COPYCONDITIONS."</strong></font>\n"
		."\t\t</td>\n"
		."\t</tr>\n";

echo "\t<tr>\n"
		."\t\t<th>{$setfont}"._CD_CONDITION."</font></th><th></th><th>{$setfont}"._QUESTION."</font></th>\n"
		."\t</tr>\n";
	
	echo "\t<tr>\n"
		."\t\t<td align='center'>\n"
		."\t\t<select name='copyconditionsfrom[]' multiple style='font-family:verdana; font-size:10; width:220; background-color: #E1FFE1' size='4' >\n";
	foreach ($conditionsList as $cl)
		{
		echo "<option value='".$cl['cid']."'>".$cl['text']."</option>\n";
		}
	echo "\t\t</select>\n"
		."\t\t</td>\n"
		."\t\t<td align='center'>$setfont\n"
		."\t\t"._CD_COPYTO."\n"
		."\t\t</font></td>\n"
		."\t\t<td align='center'>\n"
		."\t\t<select name='copyconditionsto[]' multiple style='font-family:verdana; font-size:10; width:220' size='4'>\n";
	foreach ($pquestions as $pq)
		{
		echo "<option value='{$pq['fieldname']}'>".$pq['text']."</option>\n";
		}
	echo "\t\t</select>\n";
	echo "\t\t</td>\n"
		."\t</tr>\n";
	
	echo "\t<tr><td colspan='3' align='center'>$setfont\n"
		."<input type='submit' value='"._CD_COPYCONDITIONS."' $btstyle onclick=\"return confirm('"._CD_COPYRUSURE."')\">"
		."\t\t</font>\n";
		
	echo "<input type='hidden' name='action' value='copyconditions'>\n"
		."<input type='hidden' name='sid' value='$surveyid'>\n"
		."<input type='hidden' name='qid' value='$qid'>\n"
		."</td></tr></table></form>\n";

echo "\t<tr ><td colspan='3'></td></tr>\n"
		."\t<tr bgcolor='#555555'><td colspan='3'></td></tr>\n";
	}
	
echo "</table>\n";
echo "<form action='{$_SERVER['PHP_SELF']}' name='addconditions' id='addconditions' method='post'>\n";
echo "<table width='100%' border='0' >";
echo "\t<tr bgcolor='#CDCDCD'>\n"
	."\t\t<td colspan='3' align='center'>\n"
	."\t\t\t$setfont<strong>"._CD_ADDCONDITION."</strong></font>\n"
	."\t\t</td>\n"
	."\t</tr>\n"
	."\t<tr bgcolor='#EFEFEF'>\n"
	."\t\t<th width='40%'>\n"
	."\t\t\t$setfont<strong>"._QUESTION."</strong></font>\n"
	."\t\t</th>\n"
	."\t\t<th width='20%'>\n"
	."\t\t</th>\n"
	."\t\t<th width='40%'>\n"
	."\t\t\t$setfont<strong>"._AL_ANSWER."</strong></font>\n"
	."\t\t</th>\n"
	."\t</tr>\n"
	."\t<tr>\n"
	."\t\t<td valign='top' align='center'>\n"
	."\t\t\t<select onClick=\"getAnswers(this.options[this.selectedIndex].value)\" name='cquestions' id='cquestions' style='font-family:verdana; font-size:10; width:220' size='5'>\n";
if (isset($cquestions))
	{
	foreach ($cquestions as $cqn)
		{
		echo "\t\t\t\t<option value='$cqn[3]'";
		if (isset($_POST['cquestions']) && $cqn[3] == $_POST['cquestions']) {
	    	echo " selected";
		}
		echo ">$cqn[0]</option>\n";
		}
	}	
echo "\t\t\t</select>\n"
	."\t\t</td>\n"
	."\t\t<td align='center'>$setfont\n";
//echo "\t\t\t<select name='method' id='method' style='font-family:verdana; font-size:10'>\n";
//echo "\t\t\t\t<option value='='>Equals</option>\n";
//echo "\t\t\t\t<option value='!'>Does not equal</option>\n";
//echo "\t\t\t</select>\n";
echo "\t\t\t"._CD_EQUALS."\n"
	."\t\t</font></td>\n"
	."\t\t<td valign='top' align='center'>\n"
	."\t\t\t<select name='canswers[]' multiple id='canswers' style='font-family:verdana; font-size:10; width:220' size='5'>\n";

echo "\t\t\t</select>\n"
	."\t</tr>\n"
	."\t<tr>\n"
	."\t\t<td colspan='3' align='center'>\n"
	."\t\t\t<input type='reset' value='"._ST_CLEAR."' onClick=\"clearAnswers()\" $btstyle />\n"
	."\t\t\t<input type='submit' value='"._CD_ADDCONDITION."' $btstyle />\n"
	."<input type='hidden' name='sid' value='$surveyid' />\n"
	."<input type='hidden' name='qid' value='$qid' />\n"
	."<input type='hidden' name='action' value='insertcondition' />\n"
	."<input type='hidden' name='cqid' id='cqid' value='' />\n"
	."\t\t</td>\n"
	."\t</tr>\n"
	."</table>\n"
	."</form>\n"
	."<table width='100%'  border='0'>\n";
echo "\t<tr><td colspan='3'></td></tr>\n"
	."\t<tr bgcolor='#555555'>\n"
	."\t\t<td height='5' colspan='3'>\n"
	."\t\t</td>\n";
echo "\t<tr bgcolor='#CDCDCD'><td colspan=3 height='10'></td></tr>\n"
	."\t\t<tr><td colspan='3' align='center'>\n"
	."\t\t\t<input type='submit' value='"._CLOSEWIN."' onClick=\"window.close()\" $btstyle>\n"
	."\t\t</td>\n"
	."\t</tr>\n";
echo "\t<tr><td colspan='3'></td></tr>\n"
	."</table>\n";

echo getAdminFooter("$langdir/instructions.html#conditions", "Using PHPSurveyor`s Conditions");

${this.title}

Code Editor : conditions.php