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();