function printGames($result, $teamID) { if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { echo '<table>'; echo '<caption>'; echo 'Game Title: ' . $row['Title'] . '<br>Type of game: ' . $row['Event_Type']; echo '<br>Game Location: ' . getLocationForId($row['Location_ID']); echo "<br>The game occurred on: " . date("D, M d, Y @h:ia", strtotime($row['Game_Start_Time'])); echo '<br><a href=viewGame.php?gameID=' . $row['Game_ID']; echo '>View the game here!</a>'; echo '</caption>'; echo '<tr><th>Team Name</th><th>Average Score Per Player</th></tr>'; $allTeams = $row['Teams']; $separatedTeams = explode(",", $allTeams); foreach ($separatedTeams as $team) { echo '<tr><th>'; if ($teamID == $team) { echo '<u>' . getTeamNameForTeamId($team) . '</u>'; } else { echo getTeamNameForTeamId($team); } echo '</th>'; echo '<th>' . calculateAverageScoreFor($row['Game_ID'], $team) . '</th>'; echo '</tr>'; } echo '</table>'; echo "<br>"; echo "<br>"; echo "<br>"; } } else { } }
function printOutPlayerInfoOnTeam($playerID, $gameID, $teamID, $playerTitle) { $teamName = getTeamNameForTeamId($teamID); $playerName = getPlayerNameForPlayerId($playerID); echo '<tr>'; if ($_SESSION['player_id'] == $playerID) { $conn = connectToDatabase(); //get number of last frame $frameNumber = 1; $query = "SELECT max(Frame_Number) as 'max' FROM Frame WHERE player_ID = {$playerID} AND Game_ID = {$gameID} AND Team_ID = {$teamID}"; $allFrames = $conn->query($query); $temp = $allFrames->fetch_assoc(); $maxFrame = $temp['max']; $gameIsDone = 0; //set current frame number and roll ID $rollID = ''; if ($maxFrame == 10) { //on the tenth frame //see if game is done, in case of tenth frame $query = "SELECT * FROM Frame WHERE player_ID = {$playerID} AND Game_ID = {$gameID} AND Team_ID = {$teamID} AND Frame_Number = {$maxFrame}"; $result = $conn->query($query); if ($result) { //frame exists $row = $result->fetch_assoc(); $rollOneID = $row['Roll_One_ID']; $query = "SELECT * FROM Roll WHERE Roll_ID = {$rollOneID}"; $result2 = $conn->query($query); if ($result2) { //roll one exists $pinsDown1 = getNumberOfPinsHitForRollID($rollOneID); if ($pinsDown1 > 0) { //roll one is full //look for roll 2 $rollTwoID = $row['Roll_Two_ID']; $query = "SELECT * FROM Roll WHERE Roll_ID = {$rollTwoID}"; $result2 = $conn->query($query); if ($result2) { //roll two exists $pinsDown2 = getNumberOfPinsHitForRollID($rollTwoID); if ($pinsDown2 > 0) { //roll two is full //check if roll three should be set $pinsDown1 = getNumberOfPinsHitForRollID($row['Roll_One_ID']); $pinsDown2 = getNumberOfPinsHitForRollID($row['Roll_Two_ID']); $total = $pinsDown1 + $pinsDown2; if ($total >= 10) { //roll three needed //check if roll three is set $rollThreeID = $row['Roll_Three_ID']; $query = "SELECT * FROM Roll WHERE Roll_ID = {$rollThreeID}"; $result2 = $conn->query($query); if ($result2) { //roll three exists $gameIsDone = 1; } else { //roll three does not exist $gameIsDone = 0; } } else { //roll three should be null, game is done $gameIsDone = 1; } } else { //roll two is empty $rollID = $rollTwoID; $frameNumber = $maxFrame; } } else { //roll two doesn't exist $rollID = $rollTwoID; $frameNumber = $maxFrame; } } else { //row one is empty $rollID = $rollOneID; $frameNumber = $maxFrame; } } } } else { if ($maxFrame > 0) { //max is less than 10 //see if game is done, in case of normal frame $query = "SELECT * FROM Frame WHERE player_ID = {$playerID} AND Game_ID = {$gameID} AND Team_ID = {$teamID} AND Frame_Number = {$maxFrame}"; $result = $conn->query($query); if ($result) { //frame exists $row = $result->fetch_assoc(); $rollOneID = $row['Roll_One_ID']; $query = "SELECT * FROM Roll WHERE Roll_ID = {$rollOneID}"; $result2 = $conn->query($query); if ($result2) { //roll one exists $pinsDown1 = getNumberOfPinsHitForRollID($rollOneID); if ($pinsDown1 > 0) { //roll one is full if ($pinsDown1 == 10) { // roll one is a strike //look to next frame $frameNumber = $maxFrame + 1; } else { //roll one is not a strike //look for roll 2 $rollTwoID = $row['Roll_Two_ID']; $query = "SELECT * FROM Roll WHERE Roll_ID = {$rollTwoID}"; $result2 = $conn->query($query); if ($result2) { //roll two exists $pinsDown2 = getNumberOfPinsHitForRollID($rollTwoID); if ($pinsDown2 > 0) { //roll two is full //look to next frame $frameNumber = $maxFrame + 1; } else { //roll two is empty $rollID = $rollTwoID; $frameNumber = $maxFrame; } } else { //frame two doesn't exist $rollID = $rollTwoID; $frameNumber = $maxFrame; } } } else { //row one is empty $rollID = $rollOneID; $frameNumber = $maxFrame; } } else { //frame one doesn't exist $rollID = $rollOneID; $frameNumber = $maxFrame; } } } } //if maxFrames is 0, then frame number stays as 1 //check if button shows if (!$gameIsDone) { //show button // echo "current frame = $frameNumber"; // echo "roll ID = $rollID"; echo "<th colspan=6 rowspan=2><form action='addRoll.php' method='post'>\n <input type='hidden' name='gameID' value='{$gameID}'>\n <input type='hidden' name='teamID' value='{$teamID}'>\n <input type='hidden' name='playerID' value='{$playerID}'>\n <input type='hidden' name='frameNumber' value='{$frameNumber}'>\n <input type='hidden' name='rollID' value='{$rollID}'>\n <input type='submit' value='Add Roll'>"; echo "</form></th>"; echo "<th colspan=6 rowspan=2>{$teamName}<br>{$playerTitle}: {$playerName}</th>"; } else { //show normal box echo "<th colspan=12 rowspan=2>{$teamName}<br>{$playerTitle}: {$playerName}</th>"; } } else { //not the logged in player echo "<th colspan=12 rowspan=2>{$teamName}<br>{$playerTitle}: {$playerName}</th>"; } printRollsInformation($playerID, $gameID, $teamID); $game = calculateTotalScore($playerID, $gameID, $teamID); $score = $game->score(); echo "<th colspan='6' rowspan=2>{$score}</th>"; printOutFrameTotals($playerID, $gameID, $teamID, $game->score_by_frame()); echo '</tr>'; }