<?php
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . '/login.php';
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . $script_folder . '/signup functions.php';
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . $script_folder . '/tournament_functions.php';
date_default_timezone_set('America/Los_Angeles');
$tournamentKey = $_POST['tournament'];
if (!$tournamentKey) {
die("Which tournament?");
}
$connection = new mysqli('p:' . $db_hostname, $db_username, $db_password, $db_database);
if ($connection->connect_error) {
die($connection->connect_error);
}
$tournament = GetTournament($connection, $tournamentKey);
$signUpArray = GetSignups($connection, $tournamentKey, 'ORDER BY `SubmitKey` ASC');
//var_dump($signUpArray);
for ($i = 0; $i < count($signUpArray); ++$i) {
$playersSignedUp = GetPlayersForSignUp($connection, $signUpArray[$i]->SignUpKey);
$players = null;
for ($p = 0; $p < count($playersSignedUp); ++$p) {
if (!empty($players)) {
$players = $players . ",";
}
$extra = $playersSignedUp[$p]->Extra;
if (strlen($extra) == 0 && $playersSignedUp[$p]->GHIN === 0) {
$extra = "N";
}
if ($extra === "G" && $tournament->MemberGuest) {
$extra = $playersSignedUp[$p]->GHIN;
}
<?php
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . '/login.php';
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . $script_folder . '/tournament_functions.php';
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . $script_folder . '/results_functions.php';
date_default_timezone_set('America/Los_Angeles');
$connection = new mysqli('p:' . $db_hostname, $db_username, $db_password, $db_database);
if ($connection->connect_error) {
die($connection->connect_error);
}
if (isset($_POST['TournamentKey'])) {
$tournamentKey = $_POST['TournamentKey'];
} else {
die('TournamentKey is not set');
}
$t = GetTournament($connection, $_POST['TournamentKey']);
$ctpArray = GetClosestToThePin($connection, $tournamentKey, $t->StartDate);
SendClosestToThePin($ctpArray);
if (strcmp($t->StartDate, $t->EndDate) != 0) {
$ctpArray = GetClosestToThePin($connection, $tournamentKey, $t->EndDate);
SendClosestToThePin($ctpArray);
}
function SendClosestToThePin($ctpArray)
{
for ($i = 0; $i < count($ctpArray); ++$i) {
echo $ctpArray[$i]->Hole . ',';
echo $ctpArray[$i]->Date . ',';
echo $ctpArray[$i]->GHIN . ',';
echo '"' . $ctpArray[$i]->Name . '"' . ',';
// name can have commas, so escape it
echo $ctpArray[$i]->Distance . ',';
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);
}
function ShowSignups($connection, $tournamentKey)
{
$t = GetTournament($connection, $tournamentKey);
echo '<h2 style="text-align:center">' . $t->Name . ' Signups</h2>' . PHP_EOL;
echo '<table style="border: none; margin-left:auto;margin-right:auto;">' . PHP_EOL;
echo '<tbody>' . PHP_EOL;
if ($t->SrClubChampionship) {
echo '<tr><td style="border: none">' . PHP_EOL;
echo 'F1 = Flight 1 (under 55)<br>' . PHP_EOL;
echo 'F2 = Flight 2 (55-59)<br>' . PHP_EOL;
echo 'F3 = Flight 3 (60-69)<br>' . PHP_EOL;
echo 'F4 = Flight 4 (70 and older)<br>' . PHP_EOL;
echo 'CH = Championship Flight (55 and older)<br><br>' . PHP_EOL;
echo '</td></tr>' . PHP_EOL;
}
$signUpArray = GetSignups($connection, $tournamentKey, ' AND `Payment` < `PaymentDue` ORDER BY `SubmitKey` DESC');
if (!empty($signUpArray)) {
echo '<tr><td style="border: none">';
echo 'These players have not paid their tournament fee. You are not in the tournament until your fee has been paid. ';
echo '</td></tr>' . PHP_EOL;
echo '<tr><td style="border: none">';
echo 'If you have completed payment, but it is not yet recorded, be patient as PayPal may not have notified us yet. ';
echo 'Notify the tournament director if payment is not recorded after 24 hours.';
echo '</td></tr>' . PHP_EOL;
echo '<tr><td style="border: none">' . PHP_EOL;
ShowSignupsTable($connection, $tournamentKey, $signUpArray, $t);
echo '</td></tr>' . PHP_EOL;
}
$signUpArray = GetSignups($connection, $tournamentKey, ' AND `Payment` >= `PaymentDue` ORDER BY `SubmitKey` DESC');
if (!empty($signUpArray)) {
if ($t->RequirePayment) {
echo '<tr><td style="border: none">These players have signed up and have paid.</td></tr>';
} else {
echo '<tr><td style="border: none">These players have signed up.</td></tr>';
}
echo '<tr><td style="border: none">' . PHP_EOL;
ShowSignupsTable($connection, $tournamentKey, $signUpArray, $t);
echo '</td></tr>' . PHP_EOL;
}
echo '</tbody></table>' . PHP_EOL;
}
// echo '<br>';
// var_dump($_FILES);
// echo '<br>';
login($_POST['Login'], $_POST['Password']);
if ($_FILES["file"]["error"] > 0) {
echo "Error: " . $_FILES["file"]["error"] . "<br>";
} else {
// echo "Upload: " . $_FILES["file"]["name"] . "<br>";
// echo "Type: " . $_FILES["file"]["type"] . "<br>";
// echo "Size: " . ($_FILES["file"]["size"] / 1024) . " kB<br>";
// echo "Stored in: " . $_FILES["file"]["tmp_name"];
if ($_POST['Action'] == 'Submit') {
if (!IsHTML($_FILES['file']['tmp_name'])) {
die('Submitted file does not start with "<html"');
}
$t = GetTournament($connection, $_POST["TournamentKey"]);
if (!isset($t)) {
die('This is not a valid tournament key: ' . $_POST["TournamentKey"]);
}
$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'));
get_sidebar();
$signupKey = $_GET['signup'];
if (!$signupKey) {
get_header();
get_sidebar();
die("Which signup?");
}
$connection = new mysqli('p:' . $db_hostname, $db_username, $db_password, $db_database);
if ($connection->connect_error) {
die($connection->connect_error);
}
$signup = GetSignup($connection, $signupKey);
if (empty($signup)) {
die("Did not find a signup for key: " . $signupKey);
}
$tournament = GetTournament($connection, $signup->TournamentKey);
if (empty($tournament)) {
die("Did not find tournament for key: " . $signup->TournamentKey);
}
$tournamenDates = GetFriendlyTournamentDates($tournament);
//$errors = SendSignupEmail($connection, $tournament, $tournamenDates, $signupKey, $web_site);
if (!empty($errors)) {
echo "Error: " . $errors . "<br>";
}
$players = GetPlayersForSignUp($connection, $signupKey);
$playersRemoved[] = "none";
$refundFees = "as much as you can";
//SendRefundEmail($connection, $tournament, $signupKey, $players, $playersRemoved, $refundFees, $web_site);
if (isset($connection)) {
$connection->close();
}
