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']);
$business = stripslashes($_POST['CTP'][$i]['Business']);
if (!$insert->bind_param('isisisss', $_POST['TournamentKey'], $date, $ghin, $name, $hole, $distance, $prize, $business)) {
die($sqlCmd . " bind_param failed: " . $connection->error);
}
if (!$insert->execute()) {
die($sqlCmd . " execute failed: " . $connection->error);
}
$insert->close();
}
$date = date('Y-m-d');
UpdateTournamentResultsField($connection, $_POST['TournamentKey'], 'ClosestToThePinPostedDate', $date, 's');
}
$connection->close();
echo 'Success';
}
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');
}
}
$connection->close();
echo 'Success';
