public static function get_fixture_id($round, $date, $team) { $query = "SELECT id FROM fixture WHERE gameweek = %d AND kickoff_time = %s AND"; $team = explode(" ", $team); $team = explode("(", $team[0]); $team_id = Club::get_club_id_by_short($team[0]); if (strpos($team[1], "A") === false) { // playing at home $query = $query . " away_team = %d"; } else { // playing away $query = $query . " home_team = %d"; } $query = $query . " LIMIT 1"; $result = DB::query($query, $round, Fixture::convert_kickoff_time($date), $team_id); if (sizeof($result) == 1) { return (int) $result[0]['id']; } return false; }
function set_kickoff($kickoff) { $this->kickoff = Fixture::convert_kickoff_time($kickoff); }