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