static function set($db)
{
$variablesRs = $db->queryForVariables();
$variablesRs->data_seek(0);
$firstRow = $variablesRs->fetch_assoc();
CommonVariables::$currentTimePeriod = $firstRow['Week'];
CommonVariables::$scorecardEnabled = $firstRow['ScorecardEnabled'];
CommonVariables::$news1 = $firstRow['News1'];
CommonVariables::$news2 = $firstRow['News2'];
CommonVariables::$news3 = $firstRow['News3'];
}
<?php
include_once "db.php";
include_once "utility.php";
$db = new DbHandler();
CommonVariables::set($db);
$week = CommonVariables::$currentTimePeriod;
reset($_POST);
$userName = htmlspecialchars(each($_POST)['value']);
$userPass = htmlspecialchars(each($_POST)['value']);
$userId = $db->queryForUserId($userName, $userPass);
if (!isset($userId) || $userId == "") {
exit("Invalid Username and Password Combination.");
}
if (alreadyPicked($userId, $week, $db)) {
exit("You already picked this week.");
}
$picks = array();
$opponentPicks = array();
while (list($key, $value) = each($_POST)) {
$teamId = determineTeamId(htmlspecialchars($value), $db);
if ($week > 1 && didPick($teamId, $userId, $week - 1, $db)) {
exit("You picked {$value} last week, choose again.");
}
array_push($picks, $teamId);
}
define("NUM_TO_PICK", 7);
if (count($picks) != NUM_TO_PICK) {
exit("You must make a selection for all conferences.");
}
$matches = getMatches($week, $db);
