require( '../includes/_header.php' );
require( '_helpers.php' );
analyzeChoices();
adminHeadline( 'Compute auxiliary data' );
showDescription();
showChoices();
if( $chosenDoIt ){
noticeBox3( 0, "Note: At the end of this, when this page is completed, you should see a green success box at the bottom of the page. If not, something went wrong (like an out-of-memory error we recently had, which killed the script)." );
// Adding best-3 mean computations, for 2014 mean/3 recognition.
computeBest3();
computeConciseRecords();
computeRanks( 'best', 'Single' );
computeRanks( 'average', 'Average' );
computeCachedDatabase('../generated/cachedDatabase.php');
deleteCaches();
noticeBox3( 1, "Ok, finished.<br />" . wcaDate() );
}
require( '../includes/_footer.php' );
#----------------------------------------------------------------------
function showDescription () {
#----------------------------------------------------------------------
echo "<p>This computes means for 3x3 bld, the auxiliary tables ConciseSingleResults, ConciseAverageResults, RanksSingle and RanksAverage, as well as the cachedDatabase.php script, and clears the caches.</p>\n";
echo "<p>Do it after changes to the database data so that these things are up-to-date.</p><hr />\n";
}
if (!$_SESSION["isAdmin"]) {
$request["filters"]["userID"] = $_SESSION["userID"];
}
$result = selectRows($db, $request);
$awarded = $result['items'];
if (!count($awarded)) {
return;
}
// we hope that there will be no collision in a serie of generated codes
$query = "INSERT ignore INTO `contestant` (`ID`, `algoreaCode`) values ";
$first = true;
foreach ($awarded as $contestant) {
if (!$first) {
$query = $query . ', ';
}
$first = false;
$query = $query . '(' . $contestant->ID . ', \'' . genAccessCode($db) . '\')';
}
$query = $query . ' on duplicate key update `algoreaCode` = values(`algoreaCode`)';
$db->exec($query);
}
if (!isset($_SESSION["isAdmin"]) || !$_SESSION["isAdmin"]) {
echo json_encode((object) array("success" => false, "message" => "Seul un admin peut calculer les classements"));
exit;
}
$contestID = $_REQUEST["contestID"];
computeRanks($db, $contestID);
computeRanksSchool($db, $contestID);
generateAlgoreaCodes($db, $contestID);
unset($db);
echo json_encode(array("success" => true));
