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;
}
