function checksettings()
{
global $connect, $dbprefix, $clang, $databasename, $scriptname, $iFileUploadTotalSpaceMB;
//GET NUMBER OF SURVEYS
$query = "SELECT count(sid) FROM ".db_table_name('surveys');
$surveycount=$connect->GetOne($query); //Checked
$query = "SELECT count(sid) FROM ".db_table_name('surveys')." WHERE active='Y'";
$activesurveycount=$connect->GetOne($query); //Checked
$query = "SELECT count(users_name) FROM ".db_table_name('users');
$usercount = $connect->GetOne($query); //Checked
if ($activesurveycount==false) $activesurveycount=0;
if ($surveycount==false) $surveycount=0;
$tablelist = $connect->MetaTables();
foreach ($tablelist as $table)
{
if (strpos($table,$dbprefix."old_tokens_")!==false)
{
$oldtokenlist[]=$table;
}
elseif (strpos($table,$dbprefix."tokens_")!==false)
{
$tokenlist[]=$table;
}
elseif (strpos($table,$dbprefix."old_survey_")!==false)
{
$oldresultslist[]=$table;
}
}
if(isset($oldresultslist) && is_array($oldresultslist))
{$deactivatedsurveys=count($oldresultslist);} else {$deactivatedsurveys=0;}
if(isset($oldtokenlist) && is_array($oldtokenlist))
{$deactivatedtokens=count($oldtokenlist);} else {$deactivatedtokens=0;}
if(isset($tokenlist) && is_array($tokenlist))
{$activetokens=count($tokenlist);} else {$activetokens=0;}
$cssummary = "<div class='header ui-widget-header'>".$clang->gT("System overview")."</div>\n";
// Database name & default language
$cssummary .= "<br /><table class='statisticssummary'><tr>\n"
. "<th width='50%' align='right'>".$clang->gT("Database name").":</th><td>$databasename</td>\n"
. "</tr>\n";
// Other infos
$cssummary .= "<tr>\n"
. "<th align='right'>".$clang->gT("Users").":</th><td>$usercount</td>\n"
. "</tr>\n"
. "<tr>\n"
. "<th align='right'>".$clang->gT("Surveys").":</th><td>$surveycount</td>\n"
. "</tr>\n"
. "<tr>\n"
. "<th align='right'>".$clang->gT("Active surveys").":</th><td>$activesurveycount</td>\n"
. "</tr>\n"
. "<tr>\n"
. "<th align='right'>".$clang->gT("Deactivated result tables").":</th><td>$deactivatedsurveys</td>\n"
. "</tr>\n"
. "<tr>\n"
. "<th align='right'>".$clang->gT("Active token tables").":</th><td>$activetokens</td>\n"
. "</tr>\n"
. "<tr>\n"
. "<th align='right'>".$clang->gT("Deactivated token tables").":</th><td>$deactivatedtokens</td>\n"
. "</tr>\n";
if ($iFileUploadTotalSpaceMB>0)
{
$fUsed=fCalculateTotalFileUploadUsage();
$cssummary .= "<tr>\n"
. "<th align='right'>".$clang->gT("Used/free space for file uploads").":</th><td>".sprintf('%01.2F',$fUsed)." MB / ".sprintf('%01.2F',$iFileUploadTotalSpaceMB-$fUsed)." MB</td>\n"
. "</tr>\n";
}
$cssummary .= "</table>\n";
if ($_SESSION['USER_RIGHT_CONFIGURATOR'] == 1)
{
$cssummary .= "<p><input type='button' onclick='window.open(\"$scriptname?action=showphpinfo\")' value='".$clang->gT("Show PHPInfo")."' />";
}
return $cssummary;
}
echo ls_json_encode($return);
} else {
if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $randfileloc)) {
$return = array("success" => true, "size" => $size, "name" => rawurlencode(basename($filename)), "ext" => $ext, "filename" => $randfilename, "msg" => $clang->gT("The file has been successfuly uploaded."));
echo ls_json_encode($return);
// TODO : unlink this file since this is just a preview
// unlink($randfileloc);
}
}
} else {
// if everything went fine and the file was uploaded successfuly,
// send the file related info back to the client
if ($size > $maxfilesize) {
$return = array("success" => false, "msg" => sprintf($clang->gT("Sorry, this file is too large. Only files up to %s KB are allowed.", 'unescaped'), $maxfilesize));
echo ls_json_encode($return);
} elseif ($iFileUploadTotalSpaceMB > 0 && fCalculateTotalFileUploadUsage() + $size / 1024 / 1024 > $iFileUploadTotalSpaceMB) {
$return = array("success" => false, "msg" => $clang->gT("We are sorry but there was a system error and your file was not saved. An email has been dispatched to notify the survey administrator.", 'unescaped'));
echo ls_json_encode($return);
} elseif (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $randfileloc)) {
$return = array("success" => true, "size" => $size, "name" => rawurlencode(basename($filename)), "ext" => $ext, "filename" => $randfilename, "msg" => $clang->gT("The file has been successfuly uploaded."));
echo ls_json_encode($return);
} else {
// check for upload error
if ($_FILES['uploadfile']['error'] > 2) {
$return = array("success" => false, "msg" => $clang->gT("Sorry, there was an error uploading your file"));
echo ls_json_encode($return);
} else {
if ($_FILES['uploadfile']['error'] == 1 || $_FILES['uploadfile']['error'] == 2 || $size > $maxfilesize) {
$return = array("success" => false, "msg" => sprintf($clang->gT("Sorry, this file is too large. Only files upto %s KB are allowed."), $maxfilesize));
echo ls_json_encode($return);
} else {
// TODO : unlink this file since this is just a preview
// unlink($randfileloc);
}
}
else
{ // if everything went fine and the file was uploaded successfuly,
// send the file related info back to the client
if ($size > $maxfilesize)
{
$return = array(
"success" => false,
"msg" => sprintf($clang->gT("Sorry, this file is too large. Only files up to %s KB are allowed.",'unescaped'), $maxfilesize)
);
echo json_encode($return);
}
elseif ($iFileUploadTotalSpaceMB>0 && ((fCalculateTotalFileUploadUsage()+($size/1024/1024))>$iFileUploadTotalSpaceMB))
{
$return = array(
"success" => false,
"msg" => $clang->gT("We are sorry but there was a system error and your file was not saved. An email has been dispatched to notify the survey administrator.",'unescaped')
);
echo json_encode($return);
}
elseif (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $randfileloc))
{
if (!isset($_SESSION[$fieldname]['filecount']))
$_SESSION[$fieldname]['filecount'] = 0;
$filecount = $_SESSION[$fieldname]['filecount'] += 1;
$_SESSION[$fieldname]['files'][$filecount]['name'] = rawurlencode(basename($filename));