function getSummaryScores()
{
global $database;
$season_ids = $this->getSeasons();
$scores = array();
foreach ($season_ids as $season_id) {
$jSeason = new jSeason($database);
$jSeason->load($season_id);
$round_id = $jSeason->getCurrentRound();
$jRound = new jRound($database);
$jRound->load($round_id);
$last_round_id = $jRound->getPrev();
$jHistory = new jHistory($database);
if (is_integer($last_round_id)) {
$params = array('user_id' => $this->user_id, 'round_id' => $round_id);
$jHistory->loadByParams($params);
}
$jTipsUser_season = new jTipsUser($database);
$params = array('user_id' => $this->user_id, 'season_id' => $season_id);
$jTipsUser_season->loadByParams($params);
$jRound->load($last_round_id);
$total = $jHistory->getTotal($this, 'points');
if (!isset($total)) {
$total = 0;
}
$average = $total / (is_numeric($jRound->round) && $jRound->round > 0 ? $jRound->round : 1);
if (!isset($average)) {
$average = 0;
}
$scores[$season_id] = array('total_points' => $total, 'total_precision' => $jHistory->getTotal($this, 'precision'), 'average' => $average, 'doubleup' => $jTipsUser_season->doubleup, 'paid' => $jTipsUser_season->paid);
}
return $scores;
}
function getLast(&$jTipsUser, $field = 'points')
{
global $database;
$jSeason = new jSeason($database);
$jSeason->load($jTipsUser->season_id);
$jRound = new jRound($database);
$jRound->load($jSeason->getLatestRound());
if ($jRound->scored != 1) {
$jRound->load($jRound->getPrev());
}
//$prev_id = $jRound->getPrev();
//$jRound->load($prev_id);
$query = "SELECT `{$field}` FROM #__jtips_history WHERE user_id = " . $jTipsUser->id . " AND round_id = " . $jRound->id . ";";
//jTipsDebug($query);
$database->setQuery($query);
$res = $database->loadResult();
return is_numeric($res) ? floatval($res) : 0;
}
$jTipsUser->load($user_id);
$render->assign('jTipsUser', $jTipsUser);
$round_id = jTipsGetParam($_REQUEST, 'rid', '');
$jSeason = new jSeason($database);
$jSeason->load($jTipsUser->season_id);
$render->assign('jSeason', $jSeason);
$jRound = new jRound($database);
if ($round_id == false) {
$complete = 0;
while ($complete !== 1) {
$tempRound = new jRound($database);
if ($round_id == false) {
$round_id = $jSeason->getCurrentRound();
}
$tempRound->load($round_id);
$round_id = $tempRound->getPrev();
if (!is_numeric($round_id)) {
break;
}
$jRound = new jRound($database);
$jRound->load($round_id);
$complete = $jRound->getStatus();
}
}
$jRound->load($round_id);
$render->assign('jRound', $jRound);
$jGameParams = array('round_id' => $jRound->id);
$jGame = new jGame($database);
$jGames = forceArray($jGame->loadByParams($jGameParams));
$render->assign('jGames', $jGames);
//should columns be hidden?
$round_id = jTipsGetParam($_REQUEST, 'round_id', false);
$jSeason = new jSeason($database);
$season_id = getSeasonID();
$jSeason->load($season_id);
$render->assign('jSeason', $jSeason);
//die(getSeasonID());
$jRound = new jRound($database);
if ($round_id !== false) {
$jRound->load($round_id);
} else {
//Bug 171 & 172 - getCurrentRound is problematic here - gets currently active round!
//$round_id = $jSeason->getCurrentRound();
$round_id = $jSeason->getLastRound();
$jRound->load($round_id);
if ($jRound->scored != 1) {
$prev_id = $jRound->getPrev();
if ($prev_id !== false) {
$jRound->load($prev_id);
}
}
}
$render->assign('jRound', $jRound);
$jTipsCurrentUserParams = array('season_id' => $jSeason->id, 'status' => 1);
$total = $jTipsCurrentUser->getCount($jTipsCurrentUserParams);
//Better pagination
$start = jTipsGetParam($_REQUEST, 'start', jTipsGetParam($_REQUEST, 'limitstart', 0));
$limit = jTipsGetParam($_REQUEST, 'limit', $jTips['NumMax']);
//BUG 238 - Busted page calculations filter down to select queries
$page = $start > 0 ? $start / $limit : 0;
$pageNav = new mosPageNav($total, $start, $limit);
$render->assign('pageNav', $pageNav);
