choose.php

调查问卷系统源码。想下的就下吧。不要条件

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

$GLOBALS["inAdmin"] = 1;

#-->> Including Files

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

#-->> GET and POST Variables

$varnames = array("action", "uid", "sid", "cs", "sortmethod", "sortdesc", "start");

SetVars($varnames);

#-->> Logging In

IsAdmin(1);
SetLanguage('', 'ADMIN');
$imgurl = $GLOBALS["phpQImageDir"];

#-->> Delete Result

if ($action == "delete" && $uid && $sid) {
	$qstring = "delete from phpQUser where UID = \"".ProtectMySQL($uid)."\" and SID = \"".ProtectMySQL($sid)."\"";
	$success = mysql_query($qstring);
	$qstring = "delete from phpQAnswer where UID = \"".ProtectMySQL($uid)."\" and SID = \"".ProtectMySQL($sid)."\"";
	$success = (mysql_query($qstring)) ? $success : false;

	$message = ($success) ? sprintf($phpQlang['DeleteResultSuccess'], $uid) :
	    sprintf($phpQlang['DeleteResultError'], $uid);
}

#-->> Message

$message = ($message) ? "<B>".$phpQlang['Status'].":</B> ".$message : "<IMG SRC=\"images/invdot.gif\" WIDTH=100 HEIGHT=1 ALT=\"\">";

#-->> Contents

$caslabel = $phpQlang['ChooseASurvey'];
$sslabel = $phpQlang['SelectSurvey'];
$contents = <<<END

<TABLE CELLPADDING=2 CELLSPACING=0 BORDER=0 WIDTH=100%>
<FORM NAME=chooseform ACTION=survey.php METHOD=POST>
<TR>
	<TD><IMG SRC="$imgurl/headingsurvey1.gif" WIDTH=109 HEIGHT=22 ALT="$caslabel"></TD>
</TR>
<TR>
	<TD ALIGN=center>
	<TABLE>
	<TR>
		<TD ALIGN=right><B>$sslabel:</B></TD>
		<TD><SELECT NAME=choosesurvey CLASS=huge ONCHANGE="ChangeSurvey()">

END;

$mqsurvey = mysql_query("select * from phpQSurvey order by AddDate desc, Name");
while ($masurvey = mysql_fetch_array($mqsurvey)) {
	$surveylist[] = $masurvey;
}

if (sizeof($surveylist) > 0) {
	$contents .= "<OPTION VALUE=0>".$phpQlang['NoSurveySelected'];
	for ($i=0; $i<sizeof($surveylist); $i++) {
		if ($surveylist[$i]["SID"] == $cs) {
			$emailconfirm = (substr($surveylist[$i]["SurveyUsers"],2,1)) ? true : false;
			$selected = "SELECTED";
		}
		else { $selected = ""; }
		$svname = (strlen($surveylist[$i]["Name"]) > 50) ? substr($surveylist[$i]["Name"],0,50)."..." : $surveylist[$i]["Name"];
		$text = substr($surveylist[$i]["AddDate"],0,10).": $svname";
		$contents .= "<OPTION $selected VALUE=".$surveylist[$i]["SID"].">".ProtectHTML($text);
	}
}
else { $contents .= "<OPTION VALUE=0>".$phpQlang['NoSurveyInDatabase']; }

$contents .= <<<END

			</SELECT></TD>
	</TR>
	<TR>
		<TD></TD>
		<TD>

END;

if ($emailconfirm) {
	$contents .= "<INPUT TYPE=button ONCLICK=\"ViewSurvey('v')\" VALUE=\"".$phpQlang['VerifiedResults']."\"> ";
	$contents .= "<INPUT TYPE=button ONCLICK=\"ViewSurvey('u')\" VALUE=\"".$phpQlang['UnverifiedResults']."\"> ";
	$contents .= "<INPUT TYPE=button ONCLICK=\"ViewSurvey('a')\" VALUE=\"".$phpQlang['AllResults']."\"> ";
} else {
	$contents .= "<INPUT TYPE=button ONCLICK=\"ViewSurvey('a')\" VALUE=\"".$phpQlang['ViewResults']."\"> ";
}

$contents .= <<<END

		</TD>
	</TR>
	</TABLE>
	</TD>
</TR>
</FORM>
</TABLE>

END;

if ($cs) {
	$sortmethod = ($sortmethod) ? $sortmethod : 'date';
	$sortdesc = ($sortdesc == "d" || $sortdesc == "a") ? $sortdesc : (($sortmethod == 'date') ? "d" : "a");
	$start = ($start > 0) ? $start : 0;

	$limit = $phpQAdmin["SummaryLimit"] ? $phpQAdmin["SummaryLimit"] : 10;

	$summary = RetrieveSummary($cs, SummaryQuestions($cs), $sortmethod, $sortdesc, $start, $limit);

	$dllabel = $phpQlang['DownloadResults'];
	if ($emailconfirm) {
		$dlresults .= "<INPUT TYPE=button ONCLICK=\"DownloadResult('$cs', 'v')\" VALUE=\"".$phpQlang['VerifiedResults']."\"> ";
		$dlresults .= "<INPUT TYPE=button ONCLICK=\"DownloadResult('$cs', 'u')\" VALUE=\"".$phpQlang['UnverifiedResults']."\"> ";
		$dlresults .= "<INPUT TYPE=button ONCLICK=\"DownloadResult('$cs', 'a')\" VALUE=\"".$phpQlang['AllResults']."\"> ";
	} else {
		$dlresults .= "<INPUT TYPE=button ONCLICK=\"DownloadResult('$cs', 'a')\" VALUE=\"$dllabel\"> ";
	}

	$helpalt = $phpQlang['?'];
	$summaryalt = $phpQlang['SurveySummary'];
	$fflabel = $phpQlang['FileFormat'];
	$csvlabel = $phpQlang['CSVName'];
	$xmllabel = $phpQlang['XMLName'];
	$xmlclabel = $phpQlang['XMLCName'];
	$sqllabel = $phpQlang['SQLName'];
	$pexlabel = $phpQlang['PEXName'];
	$phpqlabel = $phpQlang['PHPQName'];
	$contents .= <<<END

<BR>
<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%>
<TR><TD BACKGROUND="images/border.gif"><IMG SRC="images/invdot.gif" WIDTH=100 HEIGHT=1 ALT=""></TD></TR>
</TABLE>
<BR>

<TABLE CELLPADDING=2 CELLSPACING=0 BORDER=0 WIDTH=100%>
<FORM NAME=result>
<TR>
  <TD><IMG SRC="$imgurl/headingdlresults.gif" WIDTH=111 HEIGHT=17 ALT="$dllabel"></TD>
</TR>
<TR>
	<TD ALIGN=center>
		<TABLE>
		<TR>
			<TD ALIGN=right><B>$fflabel:</B></TD>
			<TD><A HREF="javascript:phpQHelp('c_fileformat', 'FileFormat')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$helpalt"></A></TD>
			<TD><SELECT NAME=chooseresult CLASS=huge>
				<OPTION VALUE="csv">$csvlabel
				<OPTION VALUE="xml">$xmllabel
				<OPTION VALUE="xml-c">$xmlclabel
				<OPTION VALUE="sql">$sqllabel
				<OPTION VALUE="pex">$pexlabel
				<OPTION VALUE="phpQ">$phpqlabel
				</SELECT></TD>
		</TR>
		<TR>
			<TD COLSPAN=2></TD>
			<TD>$dlresults</TD>
		</TR>
		</TABLE>
	</TD>
</TR>
</FORM>
</TABLE>

<BR>
<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%>
<TR><TD BACKGROUND="images/border.gif"><IMG SRC="images/invdot.gif" WIDTH=100 HEIGHT=1 ALT=""></TD></TR>
</TABLE>
<BR>

<TABLE CELLPADDING=2 CELLSPACING=0 BORDER=0 WIDTH=100%>
<TR>
	<TD><IMG SRC="$imgurl/headingsummary.gif" WIDTH=105 HEIGHT=22 ALT="$summaryalt"></TD>
</TR>
<TR>
	<TD ALIGN=center>$summary</TD>
</TR>
</TABLE>

END;
}

$contents .= <<<END
<BR>
<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%>
<TR><TD BACKGROUND="images/border.gif"><IMG SRC="images/invdot.gif" WIDTH=100 HEIGHT=1 ALT=""></TD></TR>
</TABLE>
END;

#-->> Output Page

CreatePage("choose", $phpQlang['AdminTitle'].' :: '.$phpQlang['SurveyResultsTitle'], $contents, true, "jschoose.php");

?>