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);