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);
}
}
}
function DeleteTournament($connection, $tournamentKey)
{
$t = GetTournament($connection, $tournamentKey);
if (is_null($t)) {
die('Tournament with key ' . $tournamentKey . ' does not exist');
}
// Clear all the tables that have tournament related data
ClearTableWithTournamentKey($connection, 'Chits', $tournamentKey);
ClearTableWithTournamentKey($connection, 'ClosestToThePin', $tournamentKey);
ClearTableWithTournamentKey($connection, 'Pool', $tournamentKey);
ClearTableWithTournamentKey($connection, 'Scores', $tournamentKey);
ClearTableWithTournamentKey($connection, 'SignUps', $tournamentKey);
ClearTableWithTournamentKey($connection, 'SignUpsPlayers', $tournamentKey);
ClearTableWithTournamentKey($connection, 'TeeTimes', $tournamentKey);
ClearTableWithTournamentKey($connection, 'TeeTimesPlayers', $tournamentKey);
ClearTableWithTournamentKey($connection, 'TournamentDetails', $tournamentKey);
ClearTableWithTournamentKey($connection, 'Tournaments', $tournamentKey);
}
die("Missing tournament key");
} else {
for ($i = 0; $i < count($_POST['TeeTime']); ++$i) {
$teeTime = new TeeTime();
$teeTime->StartTime = $_POST['TeeTime'][$i]['StartTime'];
$teeTime->StartHole = $_POST['TeeTime'][$i]['StartHole'];
$tournamentKey = $_POST['TeeTime'][$i]['TournamentKey'];
for ($player = 0; $player < count($_POST['TeeTime'][$i]['Player']); ++$player) {
$teeTime->Players[] = FixNameCasing($_POST['TeeTime'][$i]['Player'][$player]);
$teeTime->GHIN[] = $_POST['TeeTime'][$i]['GHIN'][$player];
}
$teeTimes[] = $teeTime;
}
// echo "tournament key is: " . $tournamentKey;
ClearTableWithTournamentKey($connection, 'TeeTimes', $tournamentKey);
ClearTableWithTournamentKey($connection, 'TeeTimesPlayers', $tournamentKey);
/*
* for($i = 0; $i < count($teeTimes); ++$i) { echo $i . ': '; echo $teeTimes[$i]->StartTime . ": "; echo "Hole " . $teeTimes[$i]->StartHole . ": "; if($teeTimes[$i]->Players) { for($player = 0; $player < count($teeTimes[$i]->Players); ++$player) { if($player > 0) echo ", "; echo $teeTimes[$i]->Players[$player]; } echo "\n"; } echo "\n"; }
*/
for ($i = 0; $i < count($teeTimes); ++$i) {
$teeTimeKey = InsertTeeTime($connection, $tournamentKey, $teeTimes[$i]->StartTime, $teeTimes[$i]->StartHole);
if ($teeTimes[$i]->Players) {
for ($player = 0; $player < count($teeTimes[$i]->Players); ++$player) {
InsertTeeTimePlayer($connection, $teeTimeKey, $tournamentKey, $teeTimes[$i]->GHIN[$player], $teeTimes[$i]->Players[$player], $player);
}
}
}
$date = date('Y-m-d');
UpdateTournamentResultsField($connection, $tournamentKey, 'TeeTimesPostedDate', $date, 's');
}
}
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . $script_folder . '/functions.php';
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . $script_folder . '/results_functions.php';
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']);
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . '/login.php';
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . $script_folder . '/functions.php';
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . $script_folder . '/signup functions.php';
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);
}
$tournamentKey = $_POST['Tournament'];
if (!$tournamentKey) {
die("Missing tournament key");
}
// var_dump($_POST);
login($_POST['Login'], $_POST['Password']);
ClearTableWithTournamentKey($connection, 'SignUpsWaitingList', $tournamentKey);
for ($i = 0; $i < count($_POST['SignUpsWaitingList']); ++$i) {
$signUpWaitingList = new SignUpWaitingListClass();
$signUpWaitingList->TournamentKey = $tournamentKey;
$signUpWaitingList->Position = $_POST['SignUpsWaitingList'][$i]['Position'];
$signUpWaitingList->GHIN1 = $_POST['SignUpsWaitingList'][$i]['GHIN1'];
$signUpWaitingList->Name1 = $_POST['SignUpsWaitingList'][$i]['Name1'];
$signUpWaitingList->GHIN2 = $_POST['SignUpsWaitingList'][$i]['GHIN2'];
$signUpWaitingList->Name2 = $_POST['SignUpsWaitingList'][$i]['Name2'];
$signUpWaitingList->GHIN3 = $_POST['SignUpsWaitingList'][$i]['GHIN3'];
$signUpWaitingList->Name3 = $_POST['SignUpsWaitingList'][$i]['Name3'];
$signUpWaitingList->GHIN4 = $_POST['SignUpsWaitingList'][$i]['GHIN4'];
$signUpWaitingList->Name4 = $_POST['SignUpsWaitingList'][$i]['Name4'];
InsertSignUpWaitingListEntry($connection, $signUpWaitingList);
}
$connection->close();
