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; } $players = $players . '"' . $playersSignedUp[$p]->LastName . '",' . $playersSignedUp[$p]->GHIN . ',' . $extra; } if (!empty($players)) {
function GetSignupsOfSize($connection, $tournamentKey, $maxSize, $signupKey) { $signups = array(); $paidSignups = GetSignups($connection, $tournamentKey, ' AND `Payment` >= `PaymentDue` ORDER BY `SubmitKey` DESC'); for ($i = 0; $i < count($paidSignups); ++$i) { if ($signupKey != $paidSignups[$i]->SignUpKey) { $playersSignedUp = GetPlayersForSignUp($connection, $paidSignups[$i]->SignUpKey); if (count($playersSignedUp) <= $maxSize) { $playerNames = null; for ($p = 0; $p < count($playersSignedUp); ++$p) { if (!empty($playerNames)) { $playerNames = $playerNames . " --- "; } $playerNames = $playerNames . " " . $playersSignedUp[$p]->LastName; } $m = new MergeSignUpClass(); $m->SignUpKey = $paidSignups[$i]->SignUpKey; $m->PlayerNames = ' ' . $playerNames . ' '; // add spaces for listbox $signups[] = $m; } } } return $signups; }
if (!$tournamentKey) { die("Which tournament?"); } $signupKey = $_GET['signup']; if (!$signupKey) { die("Which signup?"); } $connection = new mysqli($db_hostname, $db_username, $db_password, $db_database); if ($connection->connect_error) { die($connection->connect_error); } $signup = GetSignup($connection, $signupKey); if (empty($signup)) { die("There is no data for signup key: " . $signupKey); } $players = GetPlayersForSignUp($connection, $signupKey); if (count($players) == 0) { die("There are no players for signup code " . $_GET['signup']); } $t = GetTournament($connection, $tournamentKey); if (empty($t)) { die("There is no tournament numbered " . $tournamentKey); } //var_dump($_POST); $error = null; $flightErrorList = array(); $Extra = array(); $RequestedTime = $signup->RequestedTime; for ($i = 0; $i < count($players); ++$i) { $Extra[$i] = $players[$i]->Extra; }
function SendSignupEmail($connection, $tournament, $tournamentDates, $signupKey, $web_site) { $signup = GetSignup($connection, $signupKey); if (empty($signup)) { return "Did not find a signup for key: " . $signupKey; } $players = GetPlayersForSignUp($connection, $signupKey); if (count($players) == 0) { return "There are no players for signup code " . $_GET['signup']; } // compose message $message = "You are signed up for the Coronado Mens Golf " . $tournament->Name . ' tournament on ' . $tournamentDates . '.'; $message .= "\n\nPlayers in your group:"; for ($i = 0; $i < count($players); ++$i) { $message .= "\n " . $players[$i]->LastName; } $message .= "\n\nRequested time: " . $signup->RequestedTime; $message .= "\n\nDo not reply to this email. Contact the tournament director (" . $tournament->ChairmanName . ") if you have any questions.\n"; $player0Message = $message . "\nTo make changes to your signup, use this access code: " . $signup->AccessCode . "\n"; // make sure each line doesn't exceed 70 characters //$message = wordwrap($message, 70); for ($i = 0; $i < count($players); ++$i) { $rosterEntry = GetRosterEntry($connection, $players[$i]->GHIN); if (!empty($rosterEntry) && !empty($rosterEntry->Email)) { // send email if ($i == 0) { mail($rosterEntry->Email, 'Coronado Mens Golf Tournament Signup', $player0Message, "From: DoNotReply@" . $web_site); } else { mail($rosterEntry->Email, 'Coronado Mens Golf Tournament Signup', $message, "From: DoNotReply@" . $web_site); } } } return null; }