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