$c->ScoreTotal = $_POST['ResultsScores'][$i]['ScoreTotal'];
$c->TeamNumber = $_POST['ResultsScores'][$i]['TeamNumber'];
$ScoresResults[] = $c;
}
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');
}
// var_dump($_POST);
login($_POST['Login'], $_POST['Password']);
if (!isset($_POST['TeeTime'])) {
die("No list of tee times");
} else {
if (!isset($_POST['TeeTime'][0]['TournamentKey'])) {
die("Missing tournament key");
} else {
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);
// 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']);
$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');
}
require_once realpath($_SERVER["DOCUMENT_ROOT"]) . $script_folder . '/functions.php';
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['WaitingList'])) {
die("No waiting list provided.");
} else {
clear_table($connection, 'WaitingList');
for ($i = 0; $i < count($_POST['WaitingList']); ++$i) {
$sqlCmd = "INSERT INTO `WaitingList` VALUES (?, ?, ?)";
$insert = $connection->prepare($sqlCmd);
if (!$insert) {
die($sqlCmd . " prepare failed: " . $connection->error);
}
// Change upper case name to normal case
$name = FixNameCasing($_POST['WaitingList'][$i]['Name']);
if (!$insert->bind_param('iss', $_POST['WaitingList'][$i]['Position'], $name, $_POST['WaitingList'][$i]['DateAdded'])) {
die($sqlCmd . " bind_param failed: " . $connection->error);
}
if (!$insert->execute()) {
die($sqlCmd . " execute failed: " . $connection->error);
}
}
$connection->close();
echo 'Success';
}
