function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenEventId, $chosenCompetitionId, $chosenShow, $chosenAnything;
    $chosenEventId = getNormalParam('eventId');
    $chosenCompetitionId = getNormalParam('competitionId');
    $chosenShow = getBooleanParam('show');
    $chosenAnything = $chosenEventId || $chosenCompetitionId;
}

function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenEventId, $chosenRegionId, $chosenPatternHtml, $chosenPatternMysql;
    $chosenEventId = getNormalParam('eventId');
    $chosenRegionId = getNormalParam('regionId');
    $chosenPatternHtml = getHtmlParam('pattern');
    $chosenPatternMysql = getMysqlParam('pattern');
}

function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenCompetitionId, $chosenShow, $competitionCondition, $competitionDescription;
    $chosenCompetitionId = getNormalParam('competitionId');
    $chosenShow = getBooleanParam('show');
    $competitionCondition = competitionCondition();
    $competitionDescription = $chosenCompetitionId ? $chosenCompetitionId : "all competitions";
}

function analyzeChoices () {
#----------------------------------------------------------------------
  global $chosenUpload, $chosenConfirm, $chosenNamesFile, $chosenFilename;

  $chosenUpload      = getBooleanParam( 'upload' );
  $chosenConfirm     = getBooleanParam( 'confirm' );
  $chosenNamesFile   = getNormalParam( 'namesFile' );
  $chosenFilename    = getNormalParam( 'filename' );

}

function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenRegionId;
    global $chosenSingle, $chosenAverage;
    $chosenRegionId = getNormalParam('regionId');
    $chosenSingle = getBooleanParam('single');
    $chosenAverage = getBooleanParam('average');
    if (!$chosenAverage) {
        $chosenSingle = true;
    }
}

function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenEventId, $chosenCompetitionId, $chosenWhat, $chosenShow, $chosenWhich, $competitionCondition;
    $chosenEventId = getNormalParam('eventId');
    $chosenCompetitionId = getNormalParam('competitionId');
    $chosenWhat = getNormalParam('what');
    $chosenShow = getBooleanParam('show');
    $chosenWhich = "";
    $chosenWhich .= $chosenEventId ? $chosenEventId : "all events";
    $chosenWhich .= " in " . ($chosenCompetitionId ? $chosenCompetitionId : "all competitions");
    $competitionCondition = eventCondition() . competitionCondition();
}

function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenYears, $chosenRegionId, $chosenOrder;
    $chosenYears = getNormalParam('years');
    $chosenRegionId = getNormalParam('regionId');
    $chosenOrder = getNormalParam('order');
    if (getNormalParam('filter') == '') {
        $chosenYears = "only " . wcaDate('Y');
    }
    if (!preg_match('/^(date|submission)$/', $chosenOrder)) {
        $chosenOrder = 'submission';
    }
}

function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenEventId, $chosenRegionId, $chosenYears, $chosenShow;
    global $chosenSingle, $chosenAverage;
    $chosenEventId = getNormalParamDefault('eventId', '333');
    $chosenRegionId = getNormalParam('regionId');
    $chosenYears = getNormalParam('years');
    $chosenShow = getNormalParamDefault('show', '100 Persons');
    $chosenSingle = getBooleanParam('single');
    $chosenAverage = getBooleanParam('average');
    if (!$chosenAverage) {
        $chosenSingle = true;
    }
}

function analyzeChoices () {
#----------------------------------------------------------------------
  global $chosenId, $chosenConfirm, $chosenName, $chosenNameHtml, $chosenCountryId, $chosenGender, $chosenDay, $chosenMonth, $chosenYear, $chosenUpdate, $chosenFix;

  $chosenConfirm     = getBooleanParam( 'confirm'   );
  $chosenUpdate      = getBooleanParam( 'update'    );
  $chosenFix         = getBooleanParam( 'fix'       );
  $chosenId          = getNormalParam ( 'id'        );
  $chosenName        = getMysqlParam  ( 'name'      );
  $chosenNameHtml    = getHtmlParam   ( 'name'      );
  $chosenCountryId   = getMysqlParam  ( 'countryId' );
  $chosenGender      = getNormalParam ( 'gender'    );
  $chosenDay         = getNormalParam ( 'day'       );
  $chosenMonth       = getNormalParam ( 'month'     );
  $chosenYear        = getNormalParam ( 'year'      );

}

function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenRegionId, $chosenEventId, $chosenYears;
    global $chosenMixed, $chosenSlim, $chosenSeparate, $chosenHistory, $chosenMixHist;
    $chosenRegionId = getNormalParam('regionId');
    $chosenEventId = getNormalParam('eventId');
    $chosenYears = getNormalParam('years');
    $chosenMixed = getBooleanParam('mixed');
    $chosenSlim = getBooleanParam('slim');
    $chosenSeparate = getBooleanParam('separate');
    $chosenHistory = getBooleanParam('history');
    $chosenMixHist = getBooleanParam('mixHist');
    if (!$chosenSlim && !$chosenSeparate && !$chosenHistory && !$chosenMixHist) {
        $chosenMixed = true;
    }
}

function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenEventId, $chosenRegionId, $chosenYears, $chosenPatternHtml, $chosenPatternMysql, $chosenList, $chosenMap;
    $chosenEventId = getNormalParam('eventId');
    $chosenRegionId = getNormalParam('regionId');
    $chosenPatternHtml = getHtmlParam('pattern');
    $chosenPatternMysql = getMysqlParam('pattern');
    $chosenYears = getNormalParam('years');
    $chosenList = getBooleanParam('list');
    $chosenMap = getBooleanParam('map');
    if (!$chosenList && !$chosenMap) {
        $chosenYears = "current";
    }
    if (!$chosenMap) {
        $chosenList = true;
    }
}

function analyzeChoices () {
#----------------------------------------------------------------------
  global $chosenCompetitionId;
  global $chosenByPerson, $chosenAllResults, $chosenTop3, $chosenWinners;
  global $chosenForm, $chosenList;

  $chosenCompetitionId = getNormalParam( 'competitionId' );

  $chosenByPerson      = getBooleanParam( 'byPerson' );
  $chosenAllResults    = getBooleanParam( 'allResults' );
  $chosenTop3          = getBooleanParam( 'top3' );
  $chosenWinners       = getBooleanParam( 'winners' );
  if( !$chosenAllResults  &&  !$chosenTop3 && !$chosenByPerson )
    $chosenWinners = true;
    
  $chosenForm          = getBooleanParam( 'form' );
  $chosenList          = getBooleanParam( 'list' );
  if( !$chosenForm ) $chosenList = true;
}

function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenType, $chosenStatus, $chosenRegionId, $chosenOrder;
    $chosenType = getNormalParam('type');
    $chosenStatus = getNormalParam('status');
    $chosenRegionId = getNormalParam('regionId');
    $chosenOrder = getNormalParam('order');
    if (!preg_match('/^(article|report|multimedia)$/', $chosenType)) {
        $chosenType = '';
    }
    if (!preg_match('/^(date|submission)$/', $chosenOrder)) {
        $chosenOrder = 'submission';
    }
    if (!preg_match('/^(pending|accepted)$/', $chosenStatus)) {
        // Do we need a "refused" status ?
        $chosenStatus = 'pending';
    }
}

function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenId, $chosenConfirm, $chosenName, $chosenNameHtml, $chosenCountryId, $chosenGender, $chosenDay, $chosenMonth, $chosenYear, $chosenUpdate, $chosenFix;
    $chosenConfirm = getBooleanParam('confirm');
    $chosenUpdate = getBooleanParam('update');
    $chosenFix = getBooleanParam('fix');
    $chosenId = getNormalParam('id');
    // Gah, this is awful. We can't call getNormalParam because it refuses to
    // return anything if the parameter has a quote in it. We don't want to call
    // getMysqlParam, as we're using pdo_query throughout this file, and we don't
    // want double escaping to occur.
    $chosenName = getRawParamThisShouldBeAnException('name');
    $chosenNameHtml = getHtmlParam('name');
    $chosenCountryId = getNormalParam('countryId');
    $chosenGender = getNormalParam('gender');
    $chosenDay = getNormalParam('day');
    $chosenMonth = getNormalParam('month');
    $chosenYear = getNormalParam('year');
}

function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenCompetitionId, $chosenType, $chosenText, $chosenUri;
    global $chosenSubmitterName, $chosenSubmitterEmail, $chosenSubmitterComment;
    global $chosenTextHtml, $chosenUriHtml, $chosenSubmitterNameHtml, $chosenSubmitterEmailHtml, $chosenSubmitterCommentHtml;
    global $chosenRecaptchaChallenge, $chosenRecaptchaResponse;
    $chosenCompetitionId = getNormalParam('competitionId');
    $chosenType = getNormalParam('type');
    $chosenText = getMysqlParam('text');
    $chosenUri = getMysqlParam('uri');
    $chosenSubmitterName = getMysqlParam('submitterName');
    $chosenSubmitterEmail = getMysqlParam('submitterEmail');
    $chosenSubmitterComment = getMysqlParam('submitterComment');
    $chosenTextHtml = getHtmlParam('text');
    $chosenUriHtml = getHtmlParam('uri');
    $chosenSubmitterNameHtml = getHtmlParam('submitterName');
    $chosenSubmitterEmailHtml = getHtmlParam('submitterEmail');
    $chosenSubmitterCommentHtml = getHtmlParam('submitterComment');
    $chosenRecaptchaChallenge = getRawParamThisShouldBeAnException('recaptcha_challenge_field');
    $chosenRecaptchaResponse = getRawParamThisShouldBeAnException('recaptcha_response_field');
}

function saveMedium()
{
    #----------------------------------------------------------------------
    global $mediumId;
    $type = getNormalParam('type');
    $competitionId = getNormalParam('competitionId');
    $text = getMysqlParam('text');
    $link = getMysqlParam('link');
    $submitterName = getMysqlParam('submitterName');
    $submitterEmail = getMysqlParam('submitterEmail');
    $submitterComment = getMysqlParam('submitterComment');
    $command = "\n  UPDATE CompetitionsMedia\n    SET type='{$type}',\n        competitionId='{$competitionId}',\n        text='{$text}',\n        uri='{$link}',\n        submitterName='{$submitterName}',\n        submitterEmail='{$submitterEmail}',\n        submitterComment='{$submitterComment}'\n    WHERE id={$mediumId}";
    dbCommand($command);
    echo "I just did this : \n";
    echo $command;
}

function analyzeChoices()
{
    #----------------------------------------------------------------------
    global $chosenPersonId;
    $chosenPersonId = strtoupper(getNormalParam('personId'));
}

<?php

$currentSection = "persons";
$mapsAPI = true;
require_once 'includes/_framework.php';
$chosenPersonId = getNormalParam('i');
$chosenCompetitions = dbQuery("\n  SELECT \n    competition.*\n  FROM\n    Results result,\n    Competitions competition\n  WHERE 1\n    AND result.personId='{$chosenPersonId}'\n    AND competition.id = result.competitionId\n  GROUP BY\n    competition.id\n  ORDER BY\n    latitude, longitude, year, month, day");
require 'includes/_header.php';
// simple validation first...
if (!preg_match('/\\d{4}\\w{4}\\d{2}/', $chosenPersonId)) {
    showErrorMessage('Invalid WCA id Format <strong>[</strong>' . o($chosenPersonId) . '<strong>]</strong>');
    print '<p><a href="persons.php">Click here to search for people.</a></p>';
    require 'includes/_footer.php';
    die;
}
#--- Get all incarnations of the person.
$persons = dbQuery("\n  SELECT person.name personName, country.name countryName, day, month, year, gender\n  FROM Persons person, Countries country\n  WHERE person.id = '{$chosenPersonId}' AND country.id = person.countryId\n  ORDER BY person.subId\n");
#--- If there are none, show an error and do no more.
if (!count($persons)) {
    showErrorMessage('Unknown person id <strong>[</strong>' . o($chosenPersonId) . '<strong>]</strong>');
    $namepart = substr($chosenPersonId, 4, 4);
    print '<p><a href="persons.php?pattern=' . urlEncode($namepart) . '">Click to search for people with `' . o($namepart) . '` in their name.</a></p>';
    require 'includes/_footer.php';
    die;
}
#--- Get and show the current incarnation.
$currentPerson = array_shift($persons);
echo "<h1>" . o($currentPerson['personName']) . " - Map of Competitions</h1>";
echo "<h2><a href='p.php?i=" . urlEncode($chosenPersonId) . "'>Back to Competitor Page</a></h2>";
// create map markers
$markers = array();

<?php

$currentSection = 'admin';
include "../../includes/_framework.php";
$compId = getNormalParam('c');
$eventId = getNormalParam('e');
$roundId = getNormalParam('r');
$table = getNormalParam('t');
if ($table == "Scrambles") {
    $deleted = $wcadb_conn->boundCommand("DELETE FROM Scrambles WHERE competitionId=? AND eventId=? AND roundId=?", array('sss', &$compId, &$eventId, &$roundId));
}
if ($table == "Results") {
    $deleted = $wcadb_conn->boundCommand("DELETE FROM Results WHERE competitionId=? AND eventId=? AND roundId=?", array('sss', &$compId, &$eventId, &$roundId));
}
if ($table == "All") {
    $deleted = $wcadb_conn->boundCommand("DELETE FROM Results WHERE competitionId=?", array('s', &$compId));
    $deleted = $wcadb_conn->boundCommand("DELETE FROM Scrambles WHERE competitionId=?", array('s', &$compId));
}
print '<span style="color:#A00;"><strong>Removed.</strong></span>';

<?php

include "../../includes/_framework.php";
$compId = getNormalParam('c');
$deleted = $wcadb_conn->boundCommand("DELETE FROM InboxResults WHERE competitionId=?", array('s', &$compId));
$deleted = $wcadb_conn->boundCommand("DELETE FROM InboxPersons WHERE competitionId=?", array('s', &$compId));
// delete scrambles using the other interface
// $deleted = $wcadb_conn->boundCommand(
//    "DELETE FROM Scrambles WHERE competitionId=?",
//     array('s', &$compId)
//   );
print "Removal attempted.";