function ClearResults($connection, $tournamentKey, $result)
{
$emptyDate = TournamentDetails::EMPTYDATE;
$td = GetTournamentDetails($connection, $tournamentKey);
if (isset($td)) {
// Clear the fields.
$file = null;
switch ($result) {
case 'Scores':
case 'MatchPlayResults':
$file = $td->ScoresFile;
UpdateTournamentDetails($connection, $tournamentKey, 'ScoresFile', '');
UpdateTournamentDetails($connection, $tournamentKey, 'ScoresPostedDate', $emptyDate);
break;
case 'Chits':
$file = $td->ChitsFile;
UpdateTournamentDetails($connection, $tournamentKey, 'ChitsFile', '');
UpdateTournamentDetails($connection, $tournamentKey, 'ChitsPostedDate', $emptyDate);
break;
case 'Pool':
$file = $td->PoolFile;
UpdateTournamentDetails($connection, $tournamentKey, 'PoolFile', '');
UpdateTournamentDetails($connection, $tournamentKey, 'PoolPostedDate', $emptyDate);
break;
default:
die('Unknown result type: ' . $result);
}
}
// Delete the data
ClearTableWithTournamentKey($connection, $result, $tournamentKey);
// And remove the results html file too
if (isset($file) && !empty($file)) {
$file = "results/" . $file;
if (file_exists($file)) {
unlink($file);
}
}
}
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . $wp_folder . '/wp-blog-header.php';
date_default_timezone_set('America/Los_Angeles');
$connection = new mysqli($db_hostname, $db_username, $db_password, $db_database);
if ($connection->connect_error) {
die($connection->connect_error);
}
// var_dump($_POST);
login($_POST['Login'], $_POST['Password']);
if (!isset($_POST['TournamentKey'])) {
die("No tournament key provided.");
} else {
if (isset($_POST['ClearClosestToPin'])) {
// delete the previous values
ClearTableWithTournamentKey($connection, 'ClosestToThePin', $_POST['TournamentKey']);
$emptyDate = TournamentDetails::EMPTYDATE;
UpdateTournamentDetails($connection, $_POST['TournamentKey'], 'ClosestToThePinPostedDate', $emptyDate);
}
if (isset($_POST['CTP'])) {
for ($i = 0; $i < count($_POST['CTP']); ++$i) {
$sqlCmd = "INSERT INTO `ClosestToThePin` VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
$insert = $connection->prepare($sqlCmd);
if (!$insert) {
die($sqlCmd . " prepare failed: " . $connection->error);
}
// Remove the slashes that PHP adds to single and double quotes
$date = stripslashes($_POST['CTP'][$i]['Date']);
$ghin = stripslashes($_POST['CTP'][$i]['GHIN']);
$name = FixNameCasing($_POST['CTP'][$i]['Name']);
$hole = stripslashes($_POST['CTP'][$i]['Hole']);
$distance = stripslashes($_POST['CTP'][$i]['Distance']);
$prize = stripslashes($_POST['CTP'][$i]['Prize']);
AddScoresResults($connection, $tournamentKey, $ScoresResults);
UpdateTournamentDetails($connection, $tournamentKey, 'ScoresPostedDate', date('Y-m-d'));
} else {
if (isset($_POST['MatchPlayResultsScores'])) {
$ScoresResults = array();
for ($i = 0; $i < count($_POST['MatchPlayResultsScores']); ++$i) {
$c = new Match();
$c->TournamentKey = $tournamentKey;
$c->Round = $_POST['MatchPlayResultsScores'][$i]['Round'];
$c->MatchNumber = $_POST['MatchPlayResultsScores'][$i]['MatchNumber'];
$c->Name1 = FixNameCasing($_POST['MatchPlayResultsScores'][$i]['Player1']);
$c->Name2 = FixNameCasing($_POST['MatchPlayResultsScores'][$i]['Player2']);
$ScoresResults[] = $c;
}
AddMatchPlayScoresResults($connection, $tournamentKey, $ScoresResults);
UpdateTournamentDetails($connection, $tournamentKey, 'ScoresPostedDate', date('Y-m-d'));
}
}
}
}
} else {
if ($_POST['Action'] == 'Clear') {
if (strcasecmp($_POST["Result"], 'scores') == 0) {
ClearResults($connection, $tournamentKey, 'Scores');
} else {
if (strcasecmp($_POST["Result"], 'match play scores') == 0) {
ClearResults($connection, $tournamentKey, 'MatchPlayResults');
} else {
if (strcasecmp($_POST["Result"], 'chits') == 0) {
ClearResults($connection, $tournamentKey, 'Chits');
} else {
$start = new DateTime($t->StartDate);
$fileName = sprintf('%s %s %d.html', $start->format('Y M d'), $_POST["Result"], $_POST["TournamentKey"]);
// echo 'new file name ' . $fileName;
// Update tournament details
switch ($_POST["Result"]) {
case 'scores':
UpdateTournamentDetails($connection, $_POST["TournamentKey"], 'ScoresFile', $fileName);
UpdateTournamentDetails($connection, $_POST["TournamentKey"], 'ScoresPostedDate', date('Y-m-d'));
break;
case 'chits':
UpdateTournamentDetails($connection, $_POST["TournamentKey"], 'ChitsFile', $fileName);
UpdateTournamentDetails($connection, $_POST["TournamentKey"], 'ChitsPostedDate', date('Y-m-d'));
break;
case 'pool':
UpdateTournamentDetails($connection, $_POST["TournamentKey"], 'PoolFile', $fileName);
UpdateTournamentDetails($connection, $_POST["TournamentKey"], 'PoolPostedDate', date('Y-m-d'));
break;
default:
die('Unknown result type: ' . $_POST["Result"]);
}
move_uploaded_file($_FILES["file"]["tmp_name"], "results/" . $fileName);
} else {
if ($_POST['Action'] == 'Clear') {
if (strcasecmp($_POST["Result"], 'scores') == 0) {
ClearResults($connection, $tournamentKey, 'Scores');
} else {
if (strcasecmp($_POST["Result"], 'chits') == 0) {
ClearResults($connection, $tournamentKey, 'Chits');
} else {
if (strcasecmp($_POST["Result"], 'pool') == 0) {
ClearResults($connection, $tournamentKey, 'Pool');
