sfunctions.php

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

				$contents .= $answertext[$k];
				$contents .= "<TR>$leftborderr";
				if ($admin) {
					$contents .= "<TD BGCOLOR=#DDEEFF ALIGN=right>".$countarray[$k]."&nbsp;($percent%)&nbsp;</TD>";
					$contents .= "<TD BGCOLOR=#DDEEFF WIDTH=$barsize><IMG SRC=\"admin/images/bar.gif\" WIDTH=$barwidth HEIGHT=8 ALT=\"\"></TD>";
				}
				else {
					$contents .= "<TD ALIGN=right STYLE=\"".$masurvey["ResultsStats"]."\">".$countarray[$k]."&nbsp;($percent%)&nbsp;</TD>";
					$contents .= "<TD STYLE=\"".$masurvey["ResultsStats"]."\" WIDTH=$barsize><TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0><TR><TD STYLE=\"".$masurvey["ResultsGraph"]."\"><IMG SRC=\"admin/images/invdot.gif\" WIDTH=$barwidth HEIGHT=1 ALT=\"\"></TD></TR></TABLE></TD>";
				}
				$contents .= "$rightborderr</TR>\n";
			}
			break;
		case "textfield":
		case "textarea":
			$validanswer = array();

			if ($stattype == 'u' || $stattype == 'v') {
				$cletter = ($stattype == 'u') ? 'n' : 'y';
				$query = "SELECT COUNT(*) as num FROM phpQAnswer,phpQUser WHERE phpQAnswer.SID = \"".ProtectMySQL($sid)."\" and phpQAnswer.QID = \"".ProtectMySQL($qid)."\" and phpQAnswer.UID=phpQUser.UID and phpQAnswer.Answer != '' AND phpQUser.EmailConfirm = \"$cletter\"";
			}
			else {
				$query = "SELECT COUNT(*) as num FROM phpQAnswer WHERE SID = \"".ProtectMySQL($sid)."\" and QID = \"".ProtectMySQL($qid)."\" and Answer != ''";
			}
			$mqtnum = mysql_query($query);
			$matnum = mysql_fetch_array($mqtnum);
			$totalcount = $matnum["num"];

			$qclause = "";
			if ($stattype == 'u' || $stattype == 'v') {
				$cletter = ($stattype == 'u') ? 'n' : 'y';
				$qclause = " AND phpQUser.EmailConfirm=\"$cletter\"";
			}
			$qstring = "select phpQAnswer.Answer, phpQUser.UID, phpQUser.Email, phpQUser.IPAddr, date_format(phpQUser.CompleteDate, '".$phpQlang['MySQLDateFormat']."') as FDate FROM phpQAnswer,phpQUser WHERE phpQAnswer.SID = \"".ProtectMySQL($sid)."\" and phpQAnswer.QID = \"".ProtectMySQL($qid)."\" and phpQAnswer.UID=phpQUser.UID and phpQAnswer.Answer != ''$qclause ORDER BY phpQUser.CompleteDate DESC LIMIT $textfieldlimit";
			$mqtanswer = mysql_query($qstring);
			for ($i=0; $i<mysql_num_rows($mqtanswer); $i++) {
				$matanswer = mysql_fetch_array($mqtanswer);

				$contents .= "<TR>$leftbordera";
				if ($admin) {
					$contents .= "<TD BGCOLOR=#FFFFFF ALIGN=right>";
				}
				else {
					$contents .= "<TD ALIGN=right STYLE=\"padding-left: 5px; padding-right: 5px; ".$masurvey["ResultsAnswer"]."\">";
				}

				if (substr($masurvey["SurveyUsers"],2,1)) {
					$email = $matanswer["Email"] ? ProtectHTML($matanswer["Email"]) : $phpQlang['notentered'];
					$contents .= "<B>".$phpQlang["Email"].":</B> $email&nbsp;&nbsp;&nbsp;";
				}
				else {
					$contents .= "<B>".$phpQlang["IP"].":</B> ".ProtectHTML($matanswer["IPAddr"])."&nbsp;&nbsp;&nbsp;";
				}
				$fdate = $matanswer["FDate"];
				if ($admin) {
					$fdate = "<A HREF=\"view.php?sid=$sid&uid=".$matanswer["UID"]."\" CLASS=link TARGET=_blank>$fdate</A>";
				}
				$contents .= "<B>".$phpQlang["Date"].":</B> $fdate";
				$contents .= "</TD>$rightbordera</TR><TR>$leftborderr";
				if ($admin) {
					$contents .= "<TD BGCOLOR=#DDEEFF WIDTH=100%>";
				}
				else {
					$contents .= "<TD WIDTH=100% STYLE=\"padding-left: 5px; padding-right: 5px; ".$masurvey["ResultsStats"]."\">";
				}
				$contents .= "<B>".($i+1).".</B>&nbsp;".ProtectHTML($matanswer["Answer"])."</TD>$rightborderr</TR>\n";
			}

			if (!$totalcount) {
				if ($admin) {
					$contents .= "<TR>$leftbordera<TD BGCOLOR=#FFFFFF WIDTH=100%>".$phpQlang["NoResults"]."</TD>$rightbordera</TR>";
				}
				else {
					$contents .= "<TR>$leftbordera<TD WIDTH=100% STYLE=\"padding-left: 5px; padding-right: 5px; ".$masurvey["ResultsAnswer"]."\">".$phpQlang["NoResults"]."</TD>$rightbordera</TR>";
				}
			}

			if ($totalcount > $textfieldlimit) {
				$style = $admin ? 'color: #FFFFFF;' : $masurvey["ResultsBorder"];
				$class = $admin ? ' CLASS=link' : '';
				$seemore = "&nbsp;&nbsp;<A HREF=\"javascript:ViewText($sid,$qid,'$stattype','$admin')\"$class STYLE=\"$style\"><B>".$phpQlang["SeeMoreLink"]."</B></A>&nbsp;&nbsp;";
			}

			break;
	}

	if ($admin) {
		$contents .= "<TR BGCOLOR=#333366>";
		$contents .= "<TD><IMG SRC=\"admin/images/bound9.gif\" WIDTH=7 HEIGHT=17 ALT=\"\"></TD>";
		$contents .= "<TD ALIGN=right HEIGHT=17 COLSPAN=$tcolspan STYLE=\"color: #FFFFFF;\"><NOBR><B>".$phpQlang['Total'].":</B> $totalcount&nbsp;&nbsp;$seemore</NOBR></TD></TR>";
	}
	else {
		$contents .= "<TR><TD ALIGN=right HEIGHT=17 COLSPAN=$tcolspan STYLE=\"".$masurvey["ResultsBorder"]."\"><NOBR><B>".$phpQlang['Total'].":</B> $totalcount&nbsp;&nbsp;$seemore</NOBR></TD></TR>";
	}
	$contents .= "</TABLE>\n";

	return $contents;
}

function TableofContents ($masurvey, $stattype, $view, $admin) {
	global $phpQlang;
	$sid = $masurvey["SID"];
	$tablewidth = $masurvey["ResultsWidth"] ? $masurvey["ResultsWidth"] : 500;
	$tablewidth = $admin ? 500 : $tablewidth;
	$class = $admin ? ' CLASS=link' : '';
	$fa = $admin ? '&fa=1' : '';
	$qcount = 1;

	$contents = "<TABLE CELLPADDING=2 CELLSPACING=0 BORDER=0 WIDTH=$tablewidth>\n";

	$contents .= "<TR><TD COLSPAN=3 ALIGN=center>\n";
	$contents .= ($view != "n") ? "<A HREF=\"stats.php?sid=$sid&st=$stattype&vw=n$fa\"$class><B>".$phpQlang["TableofContents"]."</B></A>" : "<B>[ ".$phpQlang["TableofContents"]." ]</B>";
	$contents .= " : ";
	$contents .= ($view != "p") ? "<A HREF=\"stats.php?sid=$sid&st=$stattype&vw=p$fa\"$class><B>".$phpQlang["ViewwithPagebreaks"]."</B></A>" : "<B>[ ".$phpQlang["ViewwithPagebreaks"]." ]</B>";
	$contents .= " : ";
	$contents .= ($view != "a") ? "<A HREF=\"stats.php?sid=$sid&st=$stattype&vw=a$fa\"$class><B>".$phpQlang["ViewAllQuestions"]."</B></A>" : "<B>[ ".$phpQlang["ViewAllQuestions"]." ]</B>";
	$contents .= "</TD></TR>\n";

	$contents .= PrintBorder2($admin);

	$reqstyle = $admin ? ' STYLE="color: red;"' : '';
	if ($view == "n") {
		$contents .= "<TR><TD></TD><TD ALIGN=center COLSPAN=2>".sprintf($phpQlang["AsteriskText"],$reqstyle)."</TD></TR>\n";

		$contents .= PrintBorder2($admin);

		$mqquestion = mysql_query("select * from phpQQuestion where SID = \"".ProtectMySQL($sid)."\" and Type != 'htmlcontent' order by SortOrder");
		while ($maquestion = mysql_fetch_array($mqquestion)) {
			if ($maquestion["Type"] != "pagebreak") {
				$qloc = "stats.php?sid=$sid&st=$stattype&vw=q".$maquestion["QID"].$fa;
				$contents .= "<TR><TD VALIGN=top>";
				$contents .= ($maquestion["Required"] != 'n') ? "<B$reqstyle>".$phpQlang['*']."</B>" : '&nbsp;';
				$contents .= "</TD><TD VALIGN=top><NOBR><B>".$phpQlang['Question']." $qcount:</B></NOBR></TD>";
				$contents .= "<TD WIDTH=100%><A HREF=\"$qloc\"$class>".$maquestion["Question"]."</A></TD></TR>\n";
				$qcount++;
			}
		}
	}

	$contents .= "</TABLE>\n";

	return $contents;
}

function PrintSubmit ($masurvey, $qcount, $cq, $sid, $stattype, $view, $admin) {
	global $phpQlang;

	$buttonsubmit = GetButton($masurvey, 'next');
	$fa = $admin ? "<INPUT TYPE=hidden NAME=fa VALUE=1>" : '';
	$contents = "<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%>\n";
	$contents .= "<FORM ACTION=\"stats.php\">\n";
	$contents .= "<TR><TD ALIGN=center>$buttonsubmit</TD></TR>\n";
	$contents .= "<INPUT TYPE=hidden NAME=sid VALUE=\"$sid\">\n";
	$contents .= "<INPUT TYPE=hidden NAME=st VALUE=\"$stattype\">\n";
	$contents .= "<INPUT TYPE=hidden NAME=vw VALUE=\"$view\">\n";
	$contents .= "<INPUT TYPE=hidden NAME=cq VALUE=\"$cq\">\n";
	$contents .= $fa;
	$contents .= "<INPUT TYPE=hidden NAME=qcount VALUE=\"$qcount\">\n";
	$contents .= "</FORM>\n";
	$contents .= "</TABLE>\n";

	return $contents;
}

function GetButton ($masurvey, $buttontext) {
	global $phpQlang;

	switch ($buttontext) {
		case 'submit':
			$index = 'Submit';
			$text = 'Submit';
			break;
		case 'next':
			$index = 'Next';
			$text = 'Next';
			break;
		case 'results':
			$index = 'Result';
			$text = 'ShowResults';
			break;
	}

	$buttonalt = $masurvey[$index.'ImageText'] ? ProtectHTML($masurvey[$index.'ImageText']) : '';
	if ($masurvey[$index.'ImageSrc']) { 
		$buttonsrc = ProtectHTML($masurvey[$index.'ImageSrc']);
		$buttonwidth = $masurvey[$index.'ImageWidth'] > 0 ? 'WIDTH='.ProtectHTML($masurvey[$index.'ImageWidth']) : '';
		$buttonheight = $masurvey[$index.'ImageHeight'] > 0 ? 'HEIGHT='.ProtectHTML($masurvey[$index.'ImageHeight']) : '';
		$button = "<INPUT TYPE=\"image\" NAME=\"$buttontext\" SRC=\"$buttonsrc\" $buttonwidth $buttonheight BORDER=0 ALT=\"$buttonalt\" VALUE=\"1\">";
	}
	else {
		$buttonwidth = $masurvey[$index.'ImageWidth'] > 0 ? 'width: '.ProtectHTML($masurvey[$index.'ImageWidth']).'px;' : '';
		$buttonheight = $masurvey[$index.'ImageHeight'] > 0 ? 'height: '.ProtectHTML($masurvey[$index.'ImageHeight']).'px;' : '';
		$bstyle = $buttonwidth || $buttonheight ? "style=\"$buttonwidth $buttonheight\"" : "";
		$button = "<INPUT TYPE=submit NAME=\"$buttontext\" VALUE=\"$buttonalt\" $bstyle>";
	}

	return $button;
}


function PrintBorder ($admin, $tablewidth) {
	$tablewidth = $admin ? 500 : $tablewidth;
	$border = $admin ? "<TD BACKGROUND=\"admin/images/border.gif\"><IMG SRC=\"admin/images/invdot.gif\" WIDTH=100 HEIGHT=1 ALT=\"\"></TD>" : "<TD><HR SIZE=1 NOSHADE></TD>";
	$contents = "<BR>\n";
	$contents .= "<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=$tablewidth>\n";
	$contents .= "<TR>$border</TR>\n";
	$contents .= "</TABLE>\n";
	$contents .= "<BR>\n";

	return $contents;
}

function PrintBorder2 ($admin) {
	$border = $admin ? "<TD BACKGROUND=\"admin/images/border.gif\"><IMG SRC=\"admin/images/invdot.gif\" WIDTH=100 HEIGHT=1 ALT=\"\"></TD>" : "<TD><HR SIZE=1 NOSHADE></TD>";
	$contents .= "<TR><TD COLSPAN=3>\n";
	$contents .= "<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%>\n";
	$contents .= "<TR>$border</TR>\n";
	$contents .= "</TABLE>\n";
	$contents .= "</TD></TR>\n";

	return $contents;
}

function GrabTLimit () {
	global $phpQAdmin;
	return $phpQAdmin["TextareaLimit"] ? $phpQAdmin["TextareaLimit"] : 10;
}

?>