Ysurac / FlightAirMap

	* @return Array list of aircraft types

	*

	*/

	public function getAllManufacturers()

	{

		/*

		$query  = "SELECT DISTINCT spotter_output.aircraft_manufacturer AS aircraft_manufacturer

								FROM spotter_output

								WHERE spotter_output.aircraft_manufacturer <> '' 

								ORDER BY spotter_output.aircraft_manufacturer ASC";

		  */

		$query = "SELECT DISTINCT manufacturer AS aircraft_manufacturer FROM aircraft WHERE manufacturer <> '' ORDER BY manufacturer ASC";

		$sth = $this->db->prepare($query);

		$sth->execute();

		$manufacturer_array = array();

		$temp_array = array();

		while($row = $sth->fetch(PDO::FETCH_ASSOC))

		{

			$temp_array['aircraft_manufacturer'] = $row['aircraft_manufacturer'];

			$manufacturer_array[] = $temp_array;

		}

		return $manufacturer_array;

	}

  /**

	* @return Array list of aircraft registrations

	*

	*/

	public function getAllAircraftRegistrations()

	{

		$query  = "SELECT DISTINCT spotter_output.registration 

				FROM spotter_output  

				WHERE spotter_output.registration <> '' 

				ORDER BY spotter_output.registration ASC";

		$sth = $this->db->prepare($query);

		$sth->execute();

		$aircraft_array = array();

		$temp_array = array();

		while($row = $sth->fetch(PDO::FETCH_ASSOC))

		{

			$temp_array['registration'] = $row['registration'];

			$aircraft_array[] = $temp_array;

		}

		return $aircraft_array;

	}

	/**

	* Gets all source name

	* @return Array list of airline countries

	*

	*/

	public function getAllAirlineCountries()

	{

		$query  = "SELECT DISTINCT spotter_output.airline_country AS airline_country

				FROM spotter_output  

				WHERE spotter_output.airline_country <> '' 

				ORDER BY spotter_output.airline_country ASC";

		//$query = "SELECT DISTINCT country AS airline_country FROM airlines WHERE country <> '' AND active = 'Y' ORDER BY country ASC";

		$sth = $this->db->prepare($query);

		$sth->execute();

		$airline_array = array();

		$temp_array = array();

		while($row = $sth->fetch(PDO::FETCH_ASSOC))

		{

			$temp_array['airline_country'] = $row['airline_country'];

			$airline_array[] = $temp_array;

		}

		return $airline_array;

	}

	* @return Array list of ident/callsign names

	*

	*/

	public function getAllIdents()

	{

		$query  = "SELECT DISTINCT spotter_output.ident

								FROM spotter_output

								WHERE spotter_output.ident <> '' 

								ORDER BY spotter_output.date ASC LIMIT 700 OFFSET 0";

		$sth = $this->db->prepare($query);

		$sth->execute();

		$ident_array = array();

		$temp_array = array();

		while($row = $sth->fetch(PDO::FETCH_ASSOC))

		{

			$temp_array['ident'] = $row['ident'];

			$ident_array[] = $temp_array;

		}

		return $ident_array;

	}

	/**

	* Get a list of flights from airport since 7 days