exit;
}
$newPhaseSQL = "SELECT PhaseID,PhaseName," . dbdf_out($db, "StartDate") . "," . dbdf_out($db, "EndDate") . ",Status";
$newPhaseSQL .= " FROM " . $GLOBALS["DB_PREFIX"] . "ConferencePhase";
$newPhaseSQL .= " WHERE PhaseID = " . db_quote($db, $arrPhaseInfo["newPhaseID"]);
$newPhaseResult = $db->Execute($newPhaseSQL);
if (!$newPhaseResult) {
echo "Could not retrieve the phase information - please try again later.";
exit;
}
// Get settings info
$settingsInfo = get_Conference_Settings();
//Get the new phase info
$newPhaseInfo = $newPhaseResult->FetchNextObj();
//Get Current Phase, use true flag to ensure we get value from database rather than session variable
$currentPhaseInfo = getCurrentPhase(true);
?>
<form name="form1" method="post" action="process_change_phase.php">
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td colspan="2">Changing phase will reflect on accessibility of both User
and Reviewer side. This may disable or enable some functions on User and
Reviewer side. Make sure that you are changing to desired Phase. Press
Confirm to proceed.</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<?php
if (!empty($arrPhaseInfo["currentPhaseID"])) {
?>
<?php
$php_root_path = "..";
$privilege_root_path = "/admin";
require_once "includes/include_all_fns.inc";
session_start();
$err_message = " Unable to process your request due to the following problems: <br>\n";
// extract ( $_SESSION , EXTR_REFS ) ;
$valid_user = $_SESSION["valid_user"];
do_html_header("Admin Home", &$err_message);
//Call the function to get the conference information
$conferenceInfo = get_conference_info();
//Get Current Phase
$currentPhaseInfo = getCurrentPhase();
//Retrieve the setting information
$settingInfo = get_Conference_Settings();
//Connect to database
$db = adodb_connect();
if ($currentPhaseInfo->PhaseName == "Reviewing" || $currentPhaseInfo->PhaseName == "Final Paper Submission") {
$arrPaperReviewing = get_Paper_Reviewing_Statistic();
}
//Get the total number of submitted papers
$countPapersSQL = "SELECT COUNT(*) AS totalPapers FROM " . $GLOBALS["DB_PREFIX"] . "Paper WHERE Withdraw = 'false'";
$countPapersResult = $db->Execute($countPapersSQL);
$countPapersInfo = $countPapersResult->FetchNextObj();
//Get the total number of members
$countUserSQL = "SELECT COUNT(*) AS totalUsers FROM " . $GLOBALS["DB_PREFIX"] . "Member M," . $GLOBALS["DB_PREFIX"] . "PrivilegeType P";
$countUserSQL .= " WHERE M.PrivilegeTypeID = P.PrivilegeTypeID";
$countUserSQL .= " AND PrivilegeTypeName = 'User'";
$countUserResult = $db->Execute($countUserSQL);
$countUserInfo = $countUserResult->FetchNextObj();