<?
################################################################################
# phpQuestionnaire                           Version 2.2                       #
# Copyright 2003-2005 chumpsoft, inc.        March 28, 2005                    #
################################################################################
#              SCRiPTMAFiA 2005 - THE DiRTY HANDS ON YOUR SCRiPTS              #
################################################################################

#-->> Include Files

require("inc/init.php");
require("inc/mysql.php");
require("inc/functions.php");
require("inc/pfunctions.php");

#-->> Setting Variables

$varnames = array();
SetVars($varnames);

#-->> Set Default Language...

SetLanguage('');

#-->> Contents

$surveylist = $phpQlang['SurveyList'];

$contents = <<<END

<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=600>
<TR><TD WIDTH=48></TD><TD WIDTH=500></TD><TD WIDTH=48></TD>
<TR>
	<TD></TD>
	<TD COLSPAN=2><h2>$surveylist</h2></TD>
</TR>
<TR>
	<TD>&nbsp;</TD>
	<TD ALIGN=center>
	<TABLE CELLPADDING=2 CELLSPACING=0 BORDER=0>
	<TR><TD COLSPAN=2><HR SIZE=1 NOSHADE></TD></TR>

END;

if ($phpQAdmin["ListSurvey"] == "y") {

	$qstring = "select *, unix_timestamp() as unw, unix_timestamp(StartDate) as usd, unix_timestamp(EndDate) as ued ";
	$qstring .= "from phpQSurvey where Active = \"y\" ";
	$qstring .= "order by Active, Name";

	$mqsurvey = mysql_query($qstring);
	while ($masurvey = mysql_fetch_array($mqsurvey)) {
		$validtime = true;
		$validtime = (substr($masurvey["StartDate"],0,10) != "0000-00-00") ?
		    (($masurvey["unw"] >= $masurvey["usd"]) ? $validtime: false) : $validtime;
		$validtime = (substr($masurvey["EndDate"],0,10) != "0000-00-00") ?
		    (($masurvey["unw"] <= $masurvey["ued"]) ? $validtime : false) : $validtime;
		if ($validtime) {
			$responseloc = "";
			if ($masurvey["SurveyResults"]) {
				$mqresponse = mysql_query("select count(*) as ct from phpQUser where SID = \"".ProtectMySQL($masurvey["SID"])."\"");
				$responsect = 0;
				if ($maresponse = mysql_fetch_array($mqresponse)) {
					$responsect = $maresponse["ct"];
				}

				$responsemsg = ($responsect == 1) ? $phpQlang["response"] : $phpQlang["responses"];
				$responsemsg = sprintf($responsemsg, $responsect);

				$responseloc = "(<A HREF=\"stats.php?sid=".$masurvey["SID"]."\" CLASS=link>$responsemsg</A>)";
			}

			$sid = $masurvey["SID"];
			$lnkstyle = "CLASS=link";
			$svname = ProtectHTML($masurvey["Name"]);
			$svname = (strlen($svname) > 50) ? substr($svname,0,50)."..." : $svname;

			$contents .= "<TR><TD ALIGN=right><A HREF=\"fillsurvey.php?sid=$sid\" $lnkstyle>--</A></TD>";
			$contents .= "<TD><A HREF=\"fillsurvey.php?sid=$sid\" $lnkstyle><B>$svname</B></A> $responseloc</TD>";
			if ($masurvey["Description"]) {
				$contents .= "<TR><TD ALIGN=right VALIGN=top>&nbsp;</TD>";
				$contents .= "<TD>".$masurvey["Description"]."</TD></TR>";
			}
			$contents .= "<TR><TD COLSPAN=2><HR SIZE=1 NOSHADE></TD></TR>";
		}
	}
}
else {
	$contents .= "<TR><TD COLSPAN=2>".$phpQlang["NoSurveys"]."</TD></TR>\n";
}

$contents .= <<<END

	</TABLE>
	</TD>
	<TD>&nbsp;</TD>
</TR>
</TABLE>

END;

#-->> Output Page

CreatePage(0, $phpQlang["SurveyList"], $contents, false, '');

?>