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