echo ' <td>' . date('n/j g:i a', strtotime($result['cutoffTime'])) . '</td>' . "\n"; if ($result['expired']) { //if week is expired, show score (if scores are entered) if ($lastCompletedWeek >= (int) $result['weekNum']) { //scores entered, show score $weekTotal = getGameTotal($result['weekNum']); //get player score $userScore = getUserScore($result['weekNum'], $user->userID); echo ' <td class="lighter" style="color: #000;">Score: ' . $userScore . '/' . $weekTotal . ' (' . number_format($userScore / $weekTotal * 100, 2) . '%)</td>' . "\n"; } else { //scores not entered, show ??? echo ' <td class="lighter" style="color: #000;">week closed, scores not entered.</td>' . "\n"; } } else { //week is not expired yet, check to see if all picks have been entered $picks = getUserPicks($result['weekNum'], $user->userID); if (sizeof($picks) < (int) $result['gamesTotal']) { //not all picks were entered $tmpStyle = ''; if ((int) $currentWeek == (int) $result['weekNum']) { //only show in red if this is the current week $tmpStyle = ' style="color: red;"'; } echo ' <td class="lighter"' . $tmpStyle . '>Missing ' . ((int) $result['gamesTotal'] - sizeof($picks)) . ' / ' . $result['gamesTotal'] . ' picks. <a href="entry_form.php?week=' . $result['weekNum'] . '">enter now >></a></td>' . "\n"; } else { //all picks were entered echo ' <td class="lighter" style="color: green;">All picks entered.</td>' . "\n"; } } $i++; }
?> <div class="row"> <div class="col-md-4 col-xs-12 col-right"> <?php include 'includes/column_right.php'; ?> </div> <div id="content" class="col-md-8 col-xs-12"> <h2>Week <?php echo $week; ?> - Make Your Picks:</h2> <p>Please make your picks below for each game.</p> <?php //get existing picks $picks = getUserPicks($week, $user->userID); $pickSummary = get_pick_summary($user->userID, $week); //get show picks status $showPicks = (int) $pickSummary['showPicks']; //display schedule for week $sql = "select s.*, (DATE_ADD(NOW(), INTERVAL " . SERVER_TIMEZONE_OFFSET . " HOUR) > gameTimeEastern or DATE_ADD(NOW(), INTERVAL " . SERVER_TIMEZONE_OFFSET . " HOUR) > '" . $cutoffDateTime . "') as expired "; $sql .= "from " . DB_PREFIX . "schedule s "; $sql .= "inner join " . DB_PREFIX . "teams ht on s.homeID = ht.teamID "; $sql .= "inner join " . DB_PREFIX . "teams vt on s.visitorID = vt.teamID "; $sql .= "where s.weekNum = " . $week . " "; $sql .= "order by s.gameTimeEastern, s.gameID"; //echo $sql; $query = $mysqli->query($sql) or die($mysqli->error); if ($query->num_rows > 0) { echo '<form name="entryForm" action="entry_form.php" method="post" onsubmit="return checkform();">' . "\n"; echo '<input type="hidden" name="week" value="' . $week . '" />' . "\n";
//echo ' </tr>'."\n"; if ($row['expired']) { //if week is expired, show score (if scores are entered) if ($lastCompletedWeek >= (int) $row['weekNum']) { //scores entered, show score $weekTotal = getGameTotal($row['weekNum']); //get player score $userScore = getUserScore($row['weekNum'], $user->userID); echo ' <div class="bg-info"><b>Score: ' . $userScore . '/' . $weekTotal . ' (' . number_format($userScore / $weekTotal * 100, 2) . '%)</b><br /><a href="results.php?week=' . $row['weekNum'] . '">See Results »</a></div>' . "\n"; } else { //scores not entered, show ??? echo ' <div class="bg-info">Week is closed,</b> but scores have not yet been entered.<br /><a href="results.php?week=' . $row['weekNum'] . '">See Results »</a></div>' . "\n"; } } else { //week is not expired yet, check to see if all picks have been entered $picks = getUserPicks($row['weekNum'], $user->userID); if (sizeof($picks) < (int) $row['gamesTotal']) { //not all picks were entered $tmpStyle = ''; if ((int) $currentWeek == (int) $row['weekNum']) { //only show in red if this is the current week $tmpStyle = ' style="color: red;"'; } echo ' <div class="bg-warning"' . $tmpStyle . '><b>Missing ' . ((int) $row['gamesTotal'] - sizeof($picks)) . ' / ' . $row['gamesTotal'] . ' picks.</b><br /><a href="entry_form.php?week=' . $row['weekNum'] . '">Enter now »</a></div>' . "\n"; } else { //all picks were entered echo ' <div class="bg-info" style="color: green;"><b>All picks entered.</b><br /><a href="entry_form.php?week=' . $row['weekNum'] . '">Change your picks »</a></div>' . "\n"; } } echo ' </div>' . "\n"; $i++;