function calculateStats() { global $mysqli, $weekStats, $playerTotals, $possibleScoreTotal; //get latest week with all entered scores $lastCompletedWeek = getLastCompletedWeek(); //loop through weeks for ($week = 1; $week <= $lastCompletedWeek; $week++) { //get array of games $games = array(); $sql = "select * from " . DB_PREFIX . "schedule where weekNum = " . $week . " order by gameTimeEastern, gameID"; $query = $mysqli->query($sql); while ($row = $query->fetch_assoc()) { $games[$row['gameID']]['gameID'] = $row['gameID']; $games[$row['gameID']]['homeID'] = $row['homeID']; $games[$row['gameID']]['visitorID'] = $row['visitorID']; if ((int) $row['homeScore'] > (int) $row['visitorScore']) { $games[$row['gameID']]['winnerID'] = $row['homeID']; } if ((int) $row['visitorScore'] > (int) $row['homeScore']) { $games[$row['gameID']]['winnerID'] = $row['visitorID']; } } $query->free; //get array of player picks $playerPicks = array(); $playerWeeklyTotals = array(); $sql = "select p.userID, p.gameID, p.pickID, p.points, u.firstname, u.lastname, u.userName "; $sql .= "from " . DB_PREFIX . "picks p "; $sql .= "inner join " . DB_PREFIX . "users u on p.userID = u.userID "; $sql .= "inner join " . DB_PREFIX . "schedule s on p.gameID = s.gameID "; $sql .= "where s.weekNum = " . $week . " and u.userName <> 'admin' "; $sql .= "order by u.lastname, u.firstname, s.gameTimeEastern"; $query = $mysqli->query($sql); while ($row = $query->fetch_assoc()) { $playerPicks[$row['userID'] . $row['gameID']] = $row['pickID']; $playerWeeklyTotals[$row['userID']][week] = $week; $playerTotals[$row['userID']][wins] += 0; $playerTotals[$row['userID']][name] = $row['firstname'] . ' ' . $row['lastname']; $playerTotals[$row['userID']][userName] = $row['userName']; if (!empty($games[$row['gameID']]['winnerID']) && $row['pickID'] == $games[$row['gameID']]['winnerID']) { //player has picked the winning team $playerWeeklyTotals[$row['userID']][score] += 1; $playerTotals[$row['userID']][score] += 1; } else { $playerWeeklyTotals[$row['userID']][score] += 0; $playerTotals[$row['userID']][score] += 0; } } $query->free; //get winners & highest score for current week $highestScore = 0; arsort($playerWeeklyTotals); foreach ($playerWeeklyTotals as $playerID => $stats) { if ($stats[score] > $highestScore) { $highestScore = $stats[score]; } if ($stats[score] < $highestScore) { break; } $weekStats[$week][winners][] = $playerID; $playerTotals[$playerID][wins] += 1; } $weekStats[$week][highestScore] = $highestScore; $weekStats[$week][possibleScore] = getGameTotal($week); $possibleScoreTotal += $weekStats[$week][possibleScore]; } }
echo $currentWeek; ?> is locked'}); //--> </script> <?php } ?> <div style="clear: left;"></div> <!-- end countdown code --> <h3>Your Picks At A Glance:</h3> <table cellpadding="4" cellspacing="0" class="table1"> <tr><th>Week</th><th>First Game</th><th>Cutoff</th><th>Picks</th></tr> <?php $lastCompletedWeek = getLastCompletedWeek(); $sql = "select s.weekNum, count(s.gameID) as gamesTotal,"; $sql .= " min(s.gameTimeEastern) as firstGameTime,"; $sql .= " (select gameTimeEastern from " . $db_prefix . "schedule where weekNum = s.weekNum and DATE_FORMAT(gameTimeEastern, '%W') = 'Sunday' order by gameTimeEastern limit 1) as cutoffTime,"; $sql .= " (DATE_ADD(NOW(), INTERVAL " . SERVER_TIMEZONE_OFFSET . " HOUR) > (select gameTimeEastern from " . $db_prefix . "schedule where weekNum = s.weekNum and DATE_FORMAT(gameTimeEastern, '%W') = 'Sunday' order by gameTimeEastern limit 1)) as expired "; $sql .= "from " . $db_prefix . "schedule s "; $sql .= "group by s.weekNum "; $sql .= "order by s.weekNum;"; $query = mysql_query($sql); $i = 0; $rowclass = ''; while ($result = mysql_fetch_array($query)) { $rowclass = $i % 2 == 0 ? ' class="altrow"' : ''; echo ' <tr' . $rowclass . '>' . "\n"; echo ' <td>Week ' . $result['weekNum'] . '</td>' . "\n"; echo ' <td>' . date('n/j g:i a', strtotime($result['firstGameTime'])) . '</td>' . "\n";