\n" . " \n" . " \n" . " \n" . " \n" . " \n" . " \n" . " \n" . " \n" . " \n" . " \n" . " \n" . "

\n" . " \n" . " \n" . " \n" . "

\n" . " \n" . " "; print $html; } function genEpilogue() { print (" "); } function genInputField ($type, $name, $size, $value) { $f = "\n"); print ("" . "Draft" . "A League" . ""); $rowCount = 0; while ($rowCount < $draftCount || $rowCount < $aCount) { print (""); if ($rowCount < $draftCount) { print ("" . $draftTeams[$rowCount]["name"] .""); } else print (" "); if ($rowCount < $aCount) { print ("" . $aTeams[$rowCount]["name"] .""); } else print (" "); print (""); $rowCount += 1; } print (""); } function genDivisionStandings($division) { GLOBAL $dbserver, $dbuser, $dbpwd, $dbprefix, $database; $link = mysql_connect ($dbserver, $dbuser, $dbpwd) or die ("Could not connect"); $q = "SELECT id, name, wins, losses, draws " . " from $database.team t " . " where division = '" . $division . "'" . " order by wins DESC, losses, draws"; $AResult = mysql_query($q, $link) or die("Query Failed In genTeamInfo:[" . $q . "]"); print ("\n" . "" . "" . "" . "" . "" . "" . ""); while ($row = mysql_fetch_array ($AResult)) { $teamId = $row[0]; $name = $row[1]; $wins = $row[2]; $losses = $row[3]; $draws = $row[4]; print ("" . "" . "" . "" . "" . ""); } print ("

$division League Standings
Team	Wins	Losses	Draws
$name	$wins	$losses	$draws

"); mysql_free_result ($AResult); mysql_close ($link); } function genTeamInfo($teamId) { GLOBAL $dbserver, $dbuser, $dbpwd, $dbprefix; $link = mysql_connect ($dbserver, $dbuser, $dbpwd) or die ("Could not connect"); $q = "SELECT id, name, wins, losses, draws from " . $dbprefix . "team"; if ($teamId != null) $q .= " where id = " . "$teamId"; $q .= " order by wins DESC, losses, draws"; $result = mysql_query($q, $link) or die("Query Failed In genTeamInfo:[" . $q . "]"); print ("\n" . "" . "" . "" . "" . "" . "" . ""); while ($row = mysql_fetch_array ($result)) { $teamId = $row[0]; $name = $row[1]; $wins = $row[2]; $losses = $row[3]; $draws = $row[4]; print ("" . "" . "" . "" . "" . "" . ""); } print ("

Team	Wins	Losses	Draws
$name	$wins	$losses	$draws	Roster

"); mysql_free_result ($result); mysql_close ($link); } function genGameStats($gameId, $teamId, $playerId) { genGameStatsForUpdate($gameId, $teamId, $playerId); } function genGameStatsForUpdate($gameId, $teamId, $playerId) { $game = array(); getGameInfo($gameId, &$game); $stats = array(); getGameStats($gameId, $teamId, $playerId, &$stats); if ($game["homeTeamId"] == $teamId) { $userTeam = $game["homeTeam"]; $otherTeam = $game["awayTeam"]; } else { $userTeam = $game["awayTeam"]; $otherTeam = $game["homeTeam"]; } print ("

\n" . " " . "" . "" . "" . "" . "" . "" . "" . "" . "" . "\n"); $count = 0; foreach ($stats AS $stat) { print (""); $playerId = $stat["playerId"]; $firstName = $stat["firstName"]; $lastName = $stat["lastName"]; $goals = $stat["goals"]; $assists = $stat["assists"]; $blocks = $stat["blocks"]; // need to figure this out for insert/update if ($stat["statId"] == null) $statId = "null"; else $statId=$stat["statId"];; print ("\n"); print ("\n"); print ("\n"); print ("\n"); print("\n"); $count += 1; } print ("\n"); print ("

Player Stats For " . "$userTeam On Game " . $game["date"] . " vs. $otherTeam
Player	Goals	Assists	Blocks
"); print ("$firstName $lastName :"); genInputField("hidden", "playerId" . "$count", "1", $playerId); genInputField("hidden", "statId" . "$count", "1", $statId); print("	\n"); genInputField("text", "goals" . "$count", "2", $goals); print("	"); genInputField("text", "assists" . "$count", "2", $assists); print("	"); genInputField("text", "blocks" . "$count", "2", $blocks); print("
"); genInputField("submit", "Save", "1", "Save"); genInputField("hidden", "game_id", "1", $gameId); genInputField("hidden", "team_id", "1", $teamId); genInputField("hidden", "playerCount", "1", "$count"); print ("

"); } function genTeamRosterUpdate($teamId) { $roster = array(); getTeamRoster($teamId, &$roster); print ("\n"); foreach ($roster AS $player) { $playerId = $player["playerId"]; $firstName = $player["firstName"]; $lastName = $player["lastName"]; $isCaptain = $player["isCaptain"]; $captainText = " "; if ($isCaptain == 'Y') $captainText = "[Captain]"; print (""); } print ("

$firstName $lastName $captainText Remove

"); } function genAvailablePlayersSelection($fieldName, $division, $captainsOnly = false) { $players = array(); getAvailablePlayers($captainsOnly, $division, &$players); print (""); // empty option print ("Select Player"); foreach ($players AS $player) { $playerId = $player["playerId"]; $firstName = $player["firstName"]; $lastName = $player["lastName"]; print ("$lastName, $firstName"); } print(""); } function genTeamRoster($teamId) { $players = array(); getTeamRoster($teamId, &$players); $r = 0; print ("\n"); print (""); print ("". "". "". "". "". "". "". "". "". "". ""); print (""); foreach ($players AS $player) { $firstName = $player["firstName"]; $lastName = $player["lastName"]; $nickName = $player["nickName"]; $isCaptain = $player["isCaptain"]; $street = $player["street"]; $city = $player["city"]; $state = $player["state"]; $zipcode = $player["zipcode"]; $homePhone = $player["homePhone"]; $workPhone = $player["workPhone"]; $emailAddress = $player["emailAddress"]; $isPaid = $player["isPaid"]; $captainText = ""; if ($isCaptain == 'Y') $captainText = "[Captain] "; $color = "white"; if ($r % 2 == 0) $color = "gray"; print (""); print (""); print (""); print (""); print (""); print (""); print (""); print (""); print (""); print (""); print (""); print (""); print (""); $r += 1; } print ("

Last Name	First Name	Email Address	Nickname	Street	City	State	Zip	Home Phone	Work Phone	Paid Dues
$captainText" . "$firstName	$lastName	$emailAddress	$nickName	$street	$city	$state	$zipcode	$homePhone	$workPhone	$isPaid

"); } function genLeagueRoster() { $players = array(); getTeamRoster(null, &$players); $r = 0; print ("\n"); print (""); print ("". "". "". "". "". "". "". ""); print (""); foreach ($players AS $player) { $firstName = $player["firstName"]; $lastName = $player["lastName"]; $nickName = $player["nickName"]; $isCaptain = $player["isCaptain"]; $street = $player["street"]; $city = $player["city"]; $state = $player["state"]; $zipcode = $player["zipcode"]; $homePhone = $player["homePhone"]; $workPhone = $player["workPhone"]; $emailAddress = $player["emailAddress"]; $isPaid = $player["isPaid"]; $teamName = $player["teamName"]; $captainText = ""; if ($isCaptain == 'Y') $captainText = "[Captain] "; $color = "white"; if ($r % 2 == 0) $color = "gray"; print (""); print (""); print (""); print (""); print (""); print (""); print (""); print (""); print (""); print (""); $r += 1; } print ("

Team	Last Name	First Name	Street	City	State	Zip	Paid Dues
$teamName	$captainText" . "$lastName	$firstName	$street	$city	$state	$zipcode	$isPaid

"); } function genTeamSelection($fieldName, $division) { $teams = array(); getTeamSet($division, &$teams); print (""); // empty option print ("Select Team"); foreach ($teams AS $team) { $teamId = $team["id"]; $name = $team["name"]; print ("$name"); } print(""); } function genUnplayedDivisionGames($division) { $games = array(); getDivisionGames($division, false, &$games); print (" " . "" . "" . "" . "" . "" . ""); foreach ($games AS $game) { print (""); print (""); print (""); print (""); print (""); print (""); } print ("

Date	Home	Away	Field
" . $game["date"] . "	" . $game["homeTeam"] . "	" . $game["awayTeam"] . "	" . $game["field"] . "

"); } function genTeamGameResults($team, $forCaptain) { $games = array(); getTeamGames($team, true, &$games); print (" " . "" . "" . "" . "" . "" . "" . "" . ""); foreach ($games AS $game) { print (""); print (""); print (""); print (""); print (""); if ($forCaptain == true) { print(""); print(""); } print (""); } print ("

Date	Home	Away	Field
" . $game["date"] . "	" . $game["homeTeam"] . ":".$game["homeScore"] . "	" . $game["awayTeam"] . ":".$game["awayScore"] . "	" . $game["field"] . "	Clear	Enter Player Stats

"); } function genTeamGameResultUpdate($team) { $games = array(); getTeamGames($team, false, &$games); print ("

" . "" . "" . "" . "" . "" . "" . ""); $gameCount = 0; foreach ($games AS $game) { print (""); print (""); print (""); print (""); print(""); print ("\n"); $gameCount += 1; } print(""); print("

Game	Home Score	Away Score
" . $game["date"] . " " . $game["homeTeam"] . " vs " . $game["awayTeam"] . "	"); print ("" . $game["homeTeam"] . " "); genInputField("text", "homeScore" . "$gameCount", "2", $game["homeScore"]); print("	"); print ("" . $game["awayTeam"] . " "); genInputField("text", "awayScore". "$gameCount", "2", $game["awayScore"] ); print("	"); genInputField("hidden", "gameId" . "$gameCount", 1, $game["id"]); genInputField("hidden", "team_id" . "$gameCount", 1, $team); genInputField("hidden", "home_team_id" . "$gameCount", 1, $game["homeTeamId"]); genInputField("hidden", "away_team_id" . "$gameCount", 1, $game["awayTeamId"]); print("
"); genInputField("hidden", "gameCount", "1", "$gameCount"); genInputField("hidden", "team_id", "1", "$team"); genInputField("submit", "saveGame", "1", "Save"); print ("

"); } function genUnpaidPlayersForUpdate($readOnly) { $players = array(); getUnpaidPlayers(&$players); print ("

\n" . " " . "" . "" . "" . "" . "" . "" . "" . "\n"); $count = 0; foreach ($players AS $player) { print (""); $playerId = $player["playerId"]; $firstName = $player["firstName"]; $lastName = $player["lastName"]; $isPaid = $player["isPaid"]; $providedWaiver = $player["providedWaiver"]; print ("\n"); print ("\n"); print ("\n"); print ("\n"); print("\n"); $count += 1; } print ("\n"); print ("

Last Name	First Name	Is Paid	Provided Waiver
"); genInputField("hidden", "playerId" . "$count", "1", $playerId); print ("$lastName" ); print("	" . "$firstName"); print("	"); if ($isPaid == 'Y') print (""); else print (""); print("	"); if ($providedWaiver == 'Y') print (""); else print (""); print("
"); if (!$readOnly) { genInputField("submit", "Save", "1", "Save"); genInputField("hidden", "playerCount", "1", "$count"); } print ("

"); } ?>