 |
|
SCORES
|
|
|
|
2009 United States Amateur Disc Golf Championship |
| | LOCATION: Toboggan Course, Kensington MetroPark, Milford MI |
| DATES: June 12 - 14, 2009 | | PAR: 62 | | FEET: 8,824 | | Current scores: click on player name for hole-by-hole info |
|
| 2009 United States Amateur Disc Golf Championship | | RATING | POS | | NAME | SCORE | TODAY | 1 | 2 | 3 | TOTAL |
getMessage());
}
$db->setFetchMode(DB_FETCHMODE_ASSOC);
// Once you have a valid DB object named $db...
$RoundData =& $db->getRow('SELECT RoundNum FROM Scores WHERE Scores.Hole1 IS NOT NULL ORDER BY RoundNum DESC;', array());
if (PEAR::isError($RoundData)) {
die($RoundData->getMessage());
}
$CurrentRound = $RoundData['RoundNum'];
// Proceed with a queries...
$player_query =& $db->query('SELECT DISTINCT PDGA_NO, LName, FName, State, Rating, IF( Round1 IS NULL , 999, Round1 ) AS R1, IF( Round2 IS NULL , 999, Round2 ) AS R2, IF( Round3 IS NULL , 999, Round3 ) AS R3 FROM LeaderBoard;');
if (PEAR::isError($player_query)) {
die($player_query->getMessage());
}
$course_query =& $db->query('SELECT SUM(Par) AS TotalPar, SUM(HoleLength) AS TotalLength FROM Course WHERE CourseSeq = 1');
if (PEAR::isError($course_query)) {
die($course_query->getMessage());
}
// Set Course Information
if ($course_query->fetchInto($course_row)) {
$CoursePar = $course_row['TotalPar'];
$CourseLength = $course_row['TotalLength'];
}
$oddrow = 0;
$LastRound = 0;
$Place = 0;
$TempPlace = 1;
// Get each row of data on each iteration until
// there are no more rows
while ($player_query->fetchInto($player_row)) {
$TotalScore = $player_row['R1'];
$TotalScore += $player_row['R2'];
$TotalScore += $player_row['R3'];
/*
** Undo for each round
*/
/*
// If this player DNF'd, don't show it.
if ($TotalScore >= 999) {
continue;
}
*/
if ($oddrow == 0) {
echo '';
$oddrow = 1;
}
else {
echo ' ';
$oddrow = 0;
}
// If the last score was the same as this one, we have a tie
if ($LastRound != $TotalScore) {
$Place += $TempPlace;
$TempPlace = 1;
}
else {
$TempPlace++;
}
// Rating
if ( $player_row['Rating'] == 0 || is_null($player_row['Rating'])) {
echo " | ";
}
else {
echo "" . $player_row['Rating'] . " | ";
}
// Place
echo "$Place | ";
// State Flag
if ( $player_row['State'] == "" ) {
echo ' | ';
}
else {
echo '![' . $player_row['State'] . '](images/flags/' . strtolower($player_row['State']) . '.gif) | ';
}
// Name
echo '' .$player_row['FName'] . " " . $player_row['LName'] . ' | ';
// Score to Par
if ($TotalScore < ($CoursePar * $CurrentRound)) {
echo '' . ($TotalScore - ($CoursePar * $CurrentRound)) . ' | ';
}
else if ($TotalScore == ($CoursePar * $CurrentRound)) {
echo 'E | ';
}
else {
echo '+' . ($TotalScore - ($CoursePar * $CurrentRound)) . ' | ';
}
// Today +/-
$TodayPM = $player_row['R' . $CurrentRound] - $CoursePar;
if ($TodayPM < 0) {
echo '' . $TodayPM .' | ';
}
else if ($TodayPM == 0) {
echo "E | ";
}
else {
echo "+$TodayPM | ";
}
// Round Scores
$ThisRound = 1;
while ($ThisRound <= $CurrentRound) {
echo "" . $player_row['R' . $ThisRound] . " | ";
$ThisRound++;
} // Each Round
$LastRound = $TotalScore;
// Total score
echo "$TotalScore | ";
echo " \n";
} // Each Player
?>
|
|
|
|
|
|
|
|
