function getNextLogicalRound() { global $mainframe, $database; $season = ""; $query = "SELECT MAX(g.round_id) FROM #__jtips_games g JOIN #__jtips_rounds r ON g.round_id = r.id WHERE r.season_id = " . $this->get('season_id') . ";"; $database->setQuery($query); $round_id = $database->loadResult(); $query = "SELECT round FROM #__jtips_rounds WHERE round_id = {$round_id};"; $database->setQuery($query); $round = $database->loadResult(); $jSeason = new jSeason($database); $jSeason->load($this->get('season_id')); if ($jSeason->get('rounds') == $round) { return $round; } else { return $round + 1; } }