📄 admin.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/ifunctions.php");
#-->> Setting Variables
$varnames = array("oldpasswd", "newpasswd1", "newpasswd2", "summarylimit",
"textarealimit", "popuplimit", "template", "advanceinterface", "listsurvey",
"timeout", "action", "submit_action", "cs", "language", "alanguage", "cookiedomain");
SetVars($varnames);
#-->> Logging In
IsAdmin(1);
SetLanguage('', 'ADMIN');
$imgurl = $GLOBALS["phpQImageDir"];
$alanguages = GetLanguages('ADMIN');
$languages = GetLanguages();
#-->> Modify
if ($submit_action == $phpQlang['UploadDatabaseButton']) {
if ($HTTP_POST_FILES["restorefile"]['tmp_name'] == 'none') {
$message = $phpQlang['UploadError'];
}
elseif ($HTTP_POST_FILES["restorefile"]['tmp_name']) {
$fp = @fopen($HTTP_POST_FILES["restorefile"]['tmp_name'], 'r');
if ($fp) {
$flag = ($HTTP_POST_VARS["restoreb"] == 'erase') ? 'erase' : 'save';
ImportSurvey($fp, 'BACKUP', $flag);
if (!$message) { $message = $phpQlang['DatabaseRestored']; }
fclose($fp);
}
else {
$message = $phpQlang['UploadReadError'];
}
}
else {
$message = $phpQlang['NoUploadError'];
}
}
elseif ($submit_action == $phpQlang['URLDatabaseButton']) {
if ($HTTP_POST_VARS["restoreurl"]) {
$fp = @fopen($HTTP_POST_VARS["restoreurl"], 'r');
if ($fp) {
$flag = ($HTTP_POST_VARS["restoreb"] == 'erase') ? 'erase' : 'save';
ImportSurvey($fp, 'BACKUP', $flag);
if (!$message) { $message = $phpQlang['DatabaseRestored']; }
fclose($fp);
}
else {
$message = $phpQlang['URLReadError'];
}
}
else {
$message = $phpQlang['NoURLError'];
}
}
elseif ($action) {
$oldpasswd = ProtectMySQL($oldpasswd);
$newpasswd1 = ProtectMySQL($newpasswd1);
$newpasswd2 = ProtectMySQL($newpasswd2);
$summarylimit = ValidNumber(ProtectMySQL($summarylimit), 10);
$textarealimit = ValidNumber(ProtectMySQL($textarealimit), 10);
$popuplimit = ValidNumber(ProtectMySQL($popuplimit), 10);
$template = ProtectMySQL($template);
if (!isset($languages[$language])) {
if (isset($languages['english'])) { $language = 'english'; }
else { foreach ($languages as $key => $value) { $language = $key; break; } }
}
$language = ProtectMySQL($language);
if (!isset($alanguages[$alanguage])) {
if (isset($alanguages['english'])) { $alanguage = 'english'; }
else { foreach ($alanguages as $key => $value) { $alanguage = $key; break; } }
}
SetLanguage($alanguage, 'ADMIN');
$alanguage = ProtectMySQL($alanguage);
$advanceinterface = ($advanceinterface == "y" || $advanceinterface == "n") ? $advanceinterface : "n";
$listsurvey = ($listsurvey == "y" || $listsurvey == "n") ? $listsurvey : "y";
$cookiedomain = ProtectMySQL($cookiedomain);
$timeout = ($timeout >= 60) ? $timeout : 86400;
$qstring = "update phpQAdmin set ";
$qstring .= "SummaryLimit = \"$summarylimit\", TextareaLimit = \"$textarealimit\", ";
$qstring .= "PopupLimit = \"$popuplimit\", AdvanceInterface = \"$advanceinterface\", ";
$qstring .= "Template = \"$template\", Language = \"$language\", AdminLanguage = \"$alanguage\", ListSurvey = \"$listsurvey\", ";
$qstring .= "TimeOut = \"$timeout\", CookieDomain = \"$cookiedomain\"";
if ($newpasswd1 || $newpasswd2) {
if ($newpasswd1 == $newpasswd2) {
if ($phpQAdmin["Passwd"] == $oldpasswd) {
$qstring .= ", Passwd = \"$newpasswd1\" ";
$success = mysql_query($qstring);
$message = $success ? $phpQlang['PasswordChanged'] : $phpQlang['ConfigError'];
}
else {
$message = $phpQlang['IncorrectPassword'];
}
}
else {
$message = $phpQlang['PasswordMismatch'];
}
}
else {
$success = mysql_query($qstring);
$message = $success ? $phpQlang['ConfigChanged'] : $phpQlang['ConfigError'];
}
}
$message = ($message) ? "<B>".$phpQlang['Status']."</B> ".$message : "<IMG SRC=\"images/invdot.gif\" WIDTH=100 HEIGHT=1 ALT=\"\">";
#-->> Option Arrays
$advancearray = array(array($phpQlang['Basic'], "n"), array($phpQlang['Advanced'], "y"));
$yesnoarray = array(array($phpQlang['Yes'], "y"), array($phpQlang['No'], "n"));
#-->> Content
$mqadmin = mysql_query("select * from phpQAdmin limit 1");
if ($GLOBALS['phpQAdmin'] = mysql_fetch_array($mqadmin)) {
$summarylimit = ProtectHTML($phpQAdmin["SummaryLimit"]);
$textarealimit = ProtectHTML($phpQAdmin["TextareaLimit"]);
$popuplimit = ProtectHTML($phpQAdmin["PopupLimit"]);
$cookiedomain = ProtectHTML($phpQAdmin["CookieDomain"]);
$timeout = ($phpQAdmin["TimeOut"] >= 60) ? $phpQAdmin["TimeOut"] : 86400;
$template = $phpQAdmin["Template"];
$language = $phpQAdmin["Language"];
$alanguage = $phpQAdmin["AdminLanguage"];
$listsurvey = ($phpQAdmin["ListSurvey"]=="y") ? "y" : "n";
$advanceinterface = ($phpQAdmin["AdvanceInterface"]=="y") ? "y" : "n";
}
$surveyoptions = "";
$mqsurveys = mysql_query("select SID,Name,AddDate from phpQSurvey ORDER BY AddDate DESC");
while (($masurvey = mysql_fetch_array($mqsurveys))) {
$surveyname = (strlen($masurvey["Name"]) > 30) ? substr($masurvey["Name"],0,27)."..." : $masurvey["Name"];
$surveyname = substr($masurvey["AddDate"],0,10).": $surveyname";
$surveyoptions .= "<option value=\"".ProtectHTML($masurvey["SID"])."\">".ProtectHTML($surveyname)."\n";
}
$althelp = $phpQlang['?'];
$dtlabel = $phpQlang['DefaultTemplate'];
$admintitle = $phpQlang['ConfigurationTitle'];
$contents = <<<END
<TABLE CELLPADDING=2 CELLSPACING=0 BORDER=0>
<FORM ACTION=admin.php METHOD=POST>
<TR>
<TD COLSPAN=4><IMG SRC="$imgurl/headingadmin.gif" WIDTH=93 HEIGHT=17 ALT="$admintitle"></TD>
</TR>
END;
if (count($alanguages) > 1) {
$allabel = $phpQlang['AdminLanguage'];
$contents .= <<<END
<TR>
<TD ALIGN=right><NOBR><B>$allabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_alanguage', 'AdminLanguage')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD COLSPAN=2><SELECT NAME=alanguage CLASS=huge>
END;
$contents .= LanguageOptionList($alanguages, $alanguage);
$contents .= <<<END
</SELECT></TD>
</TR>
END;
}
$contents .= <<<END
<TR>
<TD ALIGN=right><NOBR><B>$dtlabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_template', 'DefaultTemplate')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD COLSPAN=2><SELECT NAME=template CLASS=huge>
END;
$contents .= TemplateOptionList($template);
$contents .= <<<END
</SELECT></TD>
</TR>
END;
if (count($languages) > 1) {
$dllabel = $phpQlang['DefaultLanguage'];
$contents .= <<<END
<TR>
<TD ALIGN=right><NOBR><B>$dllabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_language', 'DefaultLanguage')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD COLSPAN=2><SELECT NAME=language CLASS=huge>
END;
$contents .= LanguageOptionList($languages, $language);
$contents .= <<<END
</SELECT></TD>
</TR>
END;
}
$laslabel = $phpQlang['ListActiveSurveys'];
$cdlabel = $phpQlang['CookieDomain'];
$contents .= <<<END
<TR>
<TD ALIGN=right><NOBR><B>$cdlabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_cdomain','CookieDomain')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD COLSPAN=2><INPUT TYPE=text NAME=cookiedomain CLASS=huge VALUE="$cookiedomain"></TD>
</TR>
<TR>
<TD ALIGN=right><NOBR><B>$laslabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_listsurvey','ListActiveSurveys')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD><SELECT NAME=listsurvey CLASS=medium>
END;
for ($i=0; $i<sizeof($yesnoarray); $i++) {
$selected = ($yesnoarray[$i][1] == $listsurvey) ? "SELECTED" : "";
$contents .= "<OPTION $selected VALUE=\"".$yesnoarray[$i][1]."\">".$yesnoarray[$i][0];
}
$eilabel = $phpQlang['EditorInterface'];
$contents .= <<<END
</SELECT></TD>
<TD ROWSPAN=12 ALIGN=CENTER WIDTH=250><IMG SRC="images/phpQrot.gif" WIDTH=200 HEIGHT=200 BORDER=0 ALT="phpQ?"></TD>
</TR>
<TR>
<TD ALIGN=right><NOBR><B>$eilabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_interface','EditorInterface')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD><SELECT NAME=advanceinterface CLASS=medium>
END;
for ($i=0; $i<sizeof($advancearray); $i++) {
$selected = ($advancearray[$i][1] == $advanceinterface) ? "SELECTED" : "";
$contents .= "<OPTION $selected VALUE=\"".$advancearray[$i][1]."\">".$advancearray[$i][0];
}
$atlabel = $phpQlang['AdminTimeout'];
$sdlabel = $phpQlang['SummaryDisplay'];
$tidlabel = $phpQlang['TextInputDisplay'];
$pdlabel = $phpQlang['PopupDisplay'];
$elabel = $phpQlang['entries'];
$slabel = $phpQlang['seconds'];
$mobutton = $phpQlang['ModifyOptionsButton'];
$cpbutton = $phpQlang['ChangePasswordButton'];
$cplabel = $phpQlang['CurrentPassword'];
$nplabel = $phpQlang['NewPassword'];
$rplabel = $phpQlang['RetypePassword'];
$contents .= <<<END
</SELECT></TD>
<TD></TD>
</TR>
<TR>
<TD ALIGN=right><NOBR><B>$atlabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_timeout','AdminTimeout')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD><INPUT TYPE=text NAME=timeout CLASS=medium MAXLENGTH=5 VALUE="$timeout"> $slabel</TD>
</TR>
<TR>
<TD ALIGN=right><NOBR><B>$sdlabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_summarydisp','SummaryDisplay')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD><INPUT TYPE=text NAME=summarylimit CLASS=medium MAXLENGTH=5 VALUE="$summarylimit"> $elabel</TD>
</TR>
<TR>
<TD ALIGN=right><NOBR><B>$tidlabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_textdisp','TextInputDisplay')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD><INPUT TYPE=text NAME=textarealimit CLASS=medium MAXLENGTH=5 VALUE="$textarealimit"> $elabel</TD>
</TR>
<TR>
<TD ALIGN=right><NOBR><B>$pdlabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_popupdisp','PopupDisplay')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD><INPUT TYPE=text NAME=popuplimit CLASS=medium MAXLENGTH=5 VALUE="$popuplimit"> $elabel</TD>
</TR>
<TR>
<TD COLSPAN=2></TD>
<TD><INPUT TYPE=submit VALUE="$mobutton"></TD>
</TR>
<TR>
<TD COLSPAN=3>
<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=300>
<TR><TD BACKGROUND="images/border.gif"><IMG SRC="images/invdot.gif" WIDTH=100 HEIGHT=1 ALT=""></TD></TR>
</TABLE>
</TD>
</TR>
<TR>
<TD ALIGN=right><NOBR><B>$cplabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_password','CurrentPassword')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD><INPUT TYPE=password NAME=oldpasswd CLASS=medium MAXLENGTH=20 VALUE=""></TD>
</TR>
<TR>
<TD ALIGN=right><NOBR><B>$nplabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_password','NewPassword')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD><INPUT TYPE=password NAME=newpasswd1 CLASS=medium MAXLENGTH=20 VALUE=""></TD>
</TR>
<TR>
<TD ALIGN=right><NOBR><B>$rplabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_password','RetypePassword')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD><INPUT TYPE=password NAME=newpasswd2 CLASS=medium MAXLENGTH=20 VALUE=""></TD>
</TR>
<TR>
<TD COLSPAN=2></TD>
<TD><INPUT TYPE=submit VALUE="$cpbutton"></TD>
</TR>
<INPUT TYPE=hidden NAME=action VALUE="modify">
<INPUT TYPE=hidden NAME=cs VALUE="$cs">
</FORM>
<TR>
<TD COLSPAN=4>
<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>
</TD>
</TR>
END;
$bdlabel = $phpQlang['BackupDatabase'];
$bedtext = $phpQlang['BackupEntireDatabase'];
$downloadbutton = $phpQlang['DownloadDatabaseButton'];
$rdflabel = $phpQlang['RestoreDataFile'];
$uploadbutton = $phpQlang['UploadDatabaseButton'];
$rfulabel = $phpQlang['RestoreFromURL'];
$urlbutton = $phpQlang['URLDatabaseButton'];
$rblabel = $phpQlang['RestoreBehavior'];
$restoresave = $phpQlang['RestoreSAVE'];
$restoreerase = $phpQlang['RestoreERASE'];
$contents .= <<<END
<FORM NAME="backup">
<TR>
<TD ALIGN=right><NOBR><B>$bdlabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_backup','BackupDatabase')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD COLSPAN=2><SELECT NAME="choosesurvey" STYLE="width: 280px;">
<OPTION VALUE="0">$bedtext$surveyoptions
</SELECT>
<INPUT TYPE=button ONCLICK="DownloadResult()" VALUE="$downloadbutton">
</TD>
</TR>
</FORM>
<TR>
<TD COLSPAN=4>
<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>
</TD>
</TR>
<FORM NAME="restore" ACTION="admin.php" ENCTYPE="multipart/form-data" METHOD=POST>
<TR>
<TD ALIGN=right><NOBR><B>$rdflabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_restorefile','RestoreDataFile')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD COLSPAN=2>
<INPUT TYPE=file NAME="restorefile" SIZE=30>
<INPUT TYPE=submit NAME="submit_action" VALUE="$uploadbutton">
</TD>
</TR>
<TR>
<TD ALIGN=right><NOBR><B>$rfulabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_restoreurl','RestoreFromURL')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD COLSPAN=2>
<INPUT TYPE=TEXT NAME="restoreurl" class=large style="width: 270px;">
<INPUT TYPE=submit NAME="submit_action" VALUE="$urlbutton">
</TD>
</TR>
<TR>
<TD ALIGN=right><NOBR><B>$rblabel:</B></NOBR></TD>
<TD><A HREF="javascript:phpQHelp('a_restoreb','RestoreBehavior')"><IMG SRC="$imgurl/qmark.gif" WIDTH=13 HEIGHT=13 BORDER=0 ALT="$althelp"></A></TD>
<TD COLSPAN=2><SELECT NAME="restoreb" class=huge><OPTION VALUE='save'>$restoresave<OPTION VALUE='erase'>$restoreerase</SELECT></TD>
</TR>
</FORM>
<TR>
<TD COLSPAN=4>
<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>
</TD>
</TR>
END;
$contents .= <<<END
</TR>
</TABLE>
END;
#-->> Output Page
CreatePage("admin", $phpQlang['AdminTitle'].' :: '.$phpQlang['ConfigurationTitle'], $contents, true, "jsadmin.php");
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -