View GitHub Repository FlightAirMap

Schedule Inspection
Subscribe
Completed
Push — master ( 30b860...f1043a )
by Yannick
32:05
created
Status
Category
Toggle Patches
require/class.SpotterArchive.php 1 patch
Spacing   +116 added lines, -116 removed lines patch added patch discarded remove patch 
@@ -14,75 +14,75 @@  discard block
 
 block discarded – undo
14 14 
 	* @param Array $filter the filter
15 15 
 	* @return Array the SQL part
16 16 
 	*/
17 
-	public function getFilter($filter = array(),$where = false,$and = false) {
17 
+	public function getFilter($filter = array(), $where = false, $and = false) {
18 18 
 		global $globalFilter, $globalStatsFilters, $globalFilterName, $globalDBdriver;
19 19 
 		$filters = array();
20 20 
 		if (is_array($globalStatsFilters) && isset($globalStatsFilters[$globalFilterName])) {
21 21 
 			if (isset($globalStatsFilters[$globalFilterName][0]['source'])) {
22 22 
 				$filters = $globalStatsFilters[$globalFilterName];
23 23 
 			} else {
24 
-				$filter = array_merge($filter,$globalStatsFilters[$globalFilterName]);
24 
+				$filter = array_merge($filter, $globalStatsFilters[$globalFilterName]);
25 25 
 			}
26 26 
 		}
27 27 
 		if (isset($filter[0]['source'])) {
28 
-			$filters = array_merge($filters,$filter);
28 
+			$filters = array_merge($filters, $filter);
29 29 
 		}
30 
-		if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter);
30 
+		if (is_array($globalFilter)) $filter = array_merge($filter, $globalFilter);
31 31 
 		$filter_query_join = '';
32 32 
 		$filter_query_where = '';
33 
-		foreach($filters as $flt) {
33 
+		foreach ($filters as $flt) {
34 34 
 			if (isset($flt['airlines']) && !empty($flt['airlines'])) {
35 35 
 				if ($flt['airlines'][0] != '' && $flt['airlines'][0] != 'all') {
36 36 
 					if (isset($flt['source'])) {
37 
-						$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_icao IN ('".implode("','",$flt['airlines'])."') AND spotter_archive_output.format_source IN ('".implode("','",$flt['source'])."')) saff ON saff.flightaware_id = spotter_archive_output.flightaware_id";
37 
+						$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_icao IN ('".implode("','", $flt['airlines'])."') AND spotter_archive_output.format_source IN ('".implode("','", $flt['source'])."')) saff ON saff.flightaware_id = spotter_archive_output.flightaware_id";
38 38 
 					} else {
39 
-						$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_icao IN ('".implode("','",$flt['airlines'])."')) saff ON saff.flightaware_id = spotter_archive_output.flightaware_id";
39 
+						$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_icao IN ('".implode("','", $flt['airlines'])."')) saff ON saff.flightaware_id = spotter_archive_output.flightaware_id";
40 40 
 					}
41 41 
 				}
42 42 
 			}
43 43 
 			if (isset($flt['pilots_id']) && !empty($flt['pilots_id'])) {
44 44 
 				if (isset($flt['source'])) {
45 
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.pilot_id IN ('".implode("','",$flt['pilots_id'])."') AND spotter_archive_output.format_source IN ('".implode("','",$flt['source'])."')) sp ON sp.flightaware_id = spotter_archive_output.flightaware_id";
45 
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.pilot_id IN ('".implode("','", $flt['pilots_id'])."') AND spotter_archive_output.format_source IN ('".implode("','", $flt['source'])."')) sp ON sp.flightaware_id = spotter_archive_output.flightaware_id";
46 46 
 				} else {
47 
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.pilot_id IN ('".implode("','",$flt['pilots_id'])."')) sp ON sp.flightaware_id = spotter_archive_output.flightaware_id";
47 
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.pilot_id IN ('".implode("','", $flt['pilots_id'])."')) sp ON sp.flightaware_id = spotter_archive_output.flightaware_id";
48 48 
 				}
49 49 
 			}
50 50 
 			if (isset($flt['idents']) && !empty($flt['idents'])) {
51 51 
 				if (isset($flt['source'])) {
52 
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.ident IN ('".implode("','",$flt['idents'])."') AND spotter_archive_output.format_source IN ('".implode("','",$flt['source'])."')) spi ON spi.flightaware_id = spotter_archive_output.flightaware_id";
52 
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.ident IN ('".implode("','", $flt['idents'])."') AND spotter_archive_output.format_source IN ('".implode("','", $flt['source'])."')) spi ON spi.flightaware_id = spotter_archive_output.flightaware_id";
53 53 
 				} else {
54 
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.ident IN ('".implode("','",$flt['idents'])."')) spi ON spi.flightaware_id = spotter_archive_output.flightaware_id";
54 
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.ident IN ('".implode("','", $flt['idents'])."')) spi ON spi.flightaware_id = spotter_archive_output.flightaware_id";
55 55 
 				}
56 56 
 			}
57 57 
 			if (isset($flt['registrations']) && !empty($flt['registrations'])) {
58 58 
 				if (isset($flt['source'])) {
59 
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.registration IN ('".implode("','",$flt['registrations'])."') AND spotter_archive_output.format_source IN ('".implode("','",$flt['source'])."')) sre ON sre.flightaware_id = spotter_archive_output.flightaware_id";
59 
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.registration IN ('".implode("','", $flt['registrations'])."') AND spotter_archive_output.format_source IN ('".implode("','", $flt['source'])."')) sre ON sre.flightaware_id = spotter_archive_output.flightaware_id";
60 60 
 				} else {
61 
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.registration IN ('".implode("','",$flt['registrations'])."')) sre ON sre.flightaware_id = spotter_archive_output.flightaware_id";
61 
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.registration IN ('".implode("','", $flt['registrations'])."')) sre ON sre.flightaware_id = spotter_archive_output.flightaware_id";
62 62 
 				}
63 63 
 			}
64 64 
 			if ((isset($flt['airlines']) && empty($flt['airlines']) && isset($flt['pilots_id']) && empty($flt['pilots_id']) && isset($flt['idents']) && empty($flt['idents']) && isset($flt['registrations']) && empty($flt['registrations'])) || (!isset($flt['airlines']) && !isset($flt['pilots_id']) && !isset($flt['idents']) && !isset($flt['registrations']))) {
65 65 
 				if (isset($flt['source'])) {
66 
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_output.format_source IN ('".implode("','",$flt['source'])."')) saa ON saa.flightaware_id = spotter_archive_output.flightaware_id";
66 
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_output.format_source IN ('".implode("','", $flt['source'])."')) saa ON saa.flightaware_id = spotter_archive_output.flightaware_id";
67 67 
 				}
68 68 
 			}
69 69 
 		}
70 70 
 		if (isset($filter['airlines']) && !empty($filter['airlines'])) {
71 71 
 			if ($filter['airlines'][0] != '' && $filter['airlines'][0] != 'all') {
72 
-				$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) saf ON saf.flightaware_id = spotter_archive_output.flightaware_id";
72 
+				$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_icao IN ('".implode("','", $filter['airlines'])."')) saf ON saf.flightaware_id = spotter_archive_output.flightaware_id";
73 73 
 			}
74 74 
 		}
75 75 
 		if (isset($filter['airlinestype']) && !empty($filter['airlinestype'])) {
76 76 
 			$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_archive_output.flightaware_id ";
77 77 
 		}
78 78 
 		if (isset($filter['pilots_id']) && !empty($filter['pilots_id'])) {
79 
-			$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.pilot_id IN ('".implode("','",$filter['pilots_id'])."')) spi ON spi.flightaware_id = spotter_archive_output.flightaware_id";
79 
+			$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.pilot_id IN ('".implode("','", $filter['pilots_id'])."')) spi ON spi.flightaware_id = spotter_archive_output.flightaware_id";
80 80 
 		}
81 81 
 		if (isset($filter['source']) && !empty($filter['source'])) {
82 82 
 			if (count($filter['source']) == 1) {
83 83 
 				$filter_query_where .= " AND format_source = '".$filter['source'][0]."'";
84 84 
 			} else {
85 
-				$filter_query_where .= " AND format_source IN ('".implode("','",$filter['source'])."')";
85 
+				$filter_query_where .= " AND format_source IN ('".implode("','", $filter['source'])."')";
86 86 
 			}
87 87 
 		}
88 88 
 		if (isset($filter['ident']) && !empty($filter['ident'])) {
 
@@ -92,7 +92,7 @@  discard block
 
 block discarded – undo
92 92 
 			$filter_query_where .= " AND flightaware_id = '".$filter['id']."'";
93 93 
 		}
94 94 
 		if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) {
95 
-			$filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')";
95 
+			$filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','", $filter['source_aprs'])."')";
96 96 
 		}
97 97 
 		if ((isset($filter['year']) && $filter['year'] != '') || (isset($filter['month']) && $filter['month'] != '') || (isset($filter['day']) && $filter['day'] != '')) {
98 98 
 			$filter_query_date = '';
 
@@ -117,41 +117,41 @@  discard block
 
 block discarded – undo
117 117 
 					$filter_query_date .= " AND EXTRACT(DAY FROM spotter_archive_output.date) = '".$filter['day']."'";
118 118 
 				}
119 119 
 			}
120 
-			$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output".preg_replace('/^ AND/',' WHERE',$filter_query_date).") sd ON sd.flightaware_id = spotter_archive_output.flightaware_id";
120 
+			$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output".preg_replace('/^ AND/', ' WHERE', $filter_query_date).") sd ON sd.flightaware_id = spotter_archive_output.flightaware_id";
121 121 
 		}
122 122 
 		if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE';
123 123 
 		elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND';
124 124 
 		if ($filter_query_where != '') {
125 
-			$filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where);
125 
+			$filter_query_where = preg_replace('/^ AND/', ' WHERE', $filter_query_where);
126 126 
 		}
127 127 
 		$filter_query = $filter_query_join.$filter_query_where;
128 128 
 		return $filter_query;
129 129 
 	}
130 130
131 131 
 	// Spotter_archive
132 
-	public function addSpotterArchiveData($flightaware_id = '', $ident = '', $registration = '', $airline_name = '', $airline_icao = '', $airline_country = '', $airline_type = '', $aircraft_icao = '', $aircraft_shadow = '', $aircraft_name = '', $aircraft_manufacturer = '', $departure_airport_icao = '', $departure_airport_name = '', $departure_airport_city = '', $departure_airport_country = '', $departure_airport_time = '',$arrival_airport_icao = '', $arrival_airport_name = '', $arrival_airport_city ='', $arrival_airport_country = '', $arrival_airport_time = '', $route_stop = '', $date = '',$latitude = '', $longitude = '', $waypoints = '', $altitude = '', $real_altitude = '',$heading = '', $ground_speed = '', $squawk = '', $ModeS = '', $pilot_id = '', $pilot_name = '',$verticalrate = '',$format_source = '', $source_name = '', $over_country = '') {
132 
+	public function addSpotterArchiveData($flightaware_id = '', $ident = '', $registration = '', $airline_name = '', $airline_icao = '', $airline_country = '', $airline_type = '', $aircraft_icao = '', $aircraft_shadow = '', $aircraft_name = '', $aircraft_manufacturer = '', $departure_airport_icao = '', $departure_airport_name = '', $departure_airport_city = '', $departure_airport_country = '', $departure_airport_time = '', $arrival_airport_icao = '', $arrival_airport_name = '', $arrival_airport_city = '', $arrival_airport_country = '', $arrival_airport_time = '', $route_stop = '', $date = '', $latitude = '', $longitude = '', $waypoints = '', $altitude = '', $real_altitude = '', $heading = '', $ground_speed = '', $squawk = '', $ModeS = '', $pilot_id = '', $pilot_name = '', $verticalrate = '', $format_source = '', $source_name = '', $over_country = '') {
133 133 
 		require_once(dirname(__FILE__).'/class.Spotter.php');
134 134 
 		if ($over_country == '') {
135 135 
 			$Spotter = new Spotter($this->db);
136 
-			$data_country = $Spotter->getCountryFromLatitudeLongitude($latitude,$longitude);
136 
+			$data_country = $Spotter->getCountryFromLatitudeLongitude($latitude, $longitude);
137 137 
 			if (!empty($data_country)) $country = $data_country['iso2'];
138 138 
 			else $country = '';
139 139 
 		} else $country = $over_country;
140 
-		if ($airline_type === NULL) $airline_type ='';
140 
+		if ($airline_type === NULL) $airline_type = '';
141 141
142 142 
 		//if ($country == '') echo "\n".'************ UNKNOW COUNTRY ****************'."\n";
143 143 
 		//else echo "\n".'*/*/*/*/*/*/*/ Country : '.$country.' */*/*/*/*/*/*/*/*/'."\n";
144 144
145 145 
 		// Route is not added in spotter_archive
146 
-		$query  = "INSERT INTO spotter_archive (flightaware_id, ident, registration, airline_name, airline_icao, airline_country, airline_type, aircraft_icao, aircraft_shadow, aircraft_name, aircraft_manufacturer, departure_airport_icao, departure_airport_name, departure_airport_city, departure_airport_country, departure_airport_time,arrival_airport_icao, arrival_airport_name, arrival_airport_city, arrival_airport_country, arrival_airport_time, route_stop, date,latitude, longitude, waypoints, altitude, heading, ground_speed, squawk, ModeS, pilot_id, pilot_name, verticalrate,format_source,over_country,source_name,real_altitude)
146 
+		$query = "INSERT INTO spotter_archive (flightaware_id, ident, registration, airline_name, airline_icao, airline_country, airline_type, aircraft_icao, aircraft_shadow, aircraft_name, aircraft_manufacturer, departure_airport_icao, departure_airport_name, departure_airport_city, departure_airport_country, departure_airport_time,arrival_airport_icao, arrival_airport_name, arrival_airport_city, arrival_airport_country, arrival_airport_time, route_stop, date,latitude, longitude, waypoints, altitude, heading, ground_speed, squawk, ModeS, pilot_id, pilot_name, verticalrate,format_source,over_country,source_name,real_altitude)
147 147 
 		          VALUES (:flightaware_id, :ident, :registration, :airline_name, :airline_icao, :airline_country, :airline_type, :aircraft_icao, :aircraft_shadow, :aircraft_name, :aircraft_manufacturer, :departure_airport_icao, :departure_airport_name, :departure_airport_city, :departure_airport_country, :departure_airport_time,:arrival_airport_icao, :arrival_airport_name, :arrival_airport_city, :arrival_airport_country, :arrival_airport_time, :route_stop, :date,:latitude, :longitude, :waypoints, :altitude, :heading, :ground_speed, :squawk, :ModeS, :pilot_id, :pilot_name, :verticalrate, :format_source, :over_country, :source_name,:real_altitude)";
148 148
149 
-		$query_values = array(':flightaware_id' => $flightaware_id, ':ident' => $ident, ':registration' => $registration, ':airline_name' => $airline_name, ':airline_icao' => $airline_icao, ':airline_country' => $airline_country, ':airline_type' => $airline_type, ':aircraft_icao' => $aircraft_icao, ':aircraft_shadow' => $aircraft_shadow, ':aircraft_name' => $aircraft_name, ':aircraft_manufacturer' => $aircraft_manufacturer, ':departure_airport_icao' => $departure_airport_icao, ':departure_airport_name' => $departure_airport_name, ':departure_airport_city' => $departure_airport_city, ':departure_airport_country' => $departure_airport_country, ':departure_airport_time' => $departure_airport_time,':arrival_airport_icao' => $arrival_airport_icao, ':arrival_airport_name' => $arrival_airport_name, ':arrival_airport_city' => $arrival_airport_city, ':arrival_airport_country' => $arrival_airport_country, ':arrival_airport_time' => $arrival_airport_time, ':route_stop' => $route_stop, ':date' => $date,':latitude' => $latitude, ':longitude' => $longitude, ':waypoints' => $waypoints, ':altitude' => $altitude, ':heading' => $heading, ':ground_speed' => $ground_speed, ':squawk' => $squawk, ':ModeS' => $ModeS, ':pilot_id' => $pilot_id, ':pilot_name' => $pilot_name, ':verticalrate' => $verticalrate, ':format_source' => $format_source, ':over_country' => $country, ':source_name' => $source_name,':real_altitude' => $real_altitude);
149 
+		$query_values = array(':flightaware_id' => $flightaware_id, ':ident' => $ident, ':registration' => $registration, ':airline_name' => $airline_name, ':airline_icao' => $airline_icao, ':airline_country' => $airline_country, ':airline_type' => $airline_type, ':aircraft_icao' => $aircraft_icao, ':aircraft_shadow' => $aircraft_shadow, ':aircraft_name' => $aircraft_name, ':aircraft_manufacturer' => $aircraft_manufacturer, ':departure_airport_icao' => $departure_airport_icao, ':departure_airport_name' => $departure_airport_name, ':departure_airport_city' => $departure_airport_city, ':departure_airport_country' => $departure_airport_country, ':departure_airport_time' => $departure_airport_time, ':arrival_airport_icao' => $arrival_airport_icao, ':arrival_airport_name' => $arrival_airport_name, ':arrival_airport_city' => $arrival_airport_city, ':arrival_airport_country' => $arrival_airport_country, ':arrival_airport_time' => $arrival_airport_time, ':route_stop' => $route_stop, ':date' => $date, ':latitude' => $latitude, ':longitude' => $longitude, ':waypoints' => $waypoints, ':altitude' => $altitude, ':heading' => $heading, ':ground_speed' => $ground_speed, ':squawk' => $squawk, ':ModeS' => $ModeS, ':pilot_id' => $pilot_id, ':pilot_name' => $pilot_name, ':verticalrate' => $verticalrate, ':format_source' => $format_source, ':over_country' => $country, ':source_name' => $source_name, ':real_altitude' => $real_altitude);
150 150 
 		try {
151 151 
 			$sth = $this->db->prepare($query);
152 152 
 			$sth->execute($query_values);
153 153 
 			$sth->closeCursor();
154 
-		} catch(PDOException $e) {
154 
+		} catch (PDOException $e) {
155 155 
 			return "error : ".$e->getMessage();
156 156 
 		}
157 157 
 		return "success";
 
@@ -170,9 +170,9 @@  discard block
 
 block discarded – undo
170 170
171 171 
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
172 172 
 		//$query  = "SELECT spotter_archive.* FROM spotter_archive INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_archive l WHERE l.ident = :ident GROUP BY l.flightaware_id) s on spotter_archive.flightaware_id = s.flightaware_id AND spotter_archive.date = s.maxdate LIMIT 1";
173 
-		$query  = "SELECT spotter_archive.* FROM spotter_archive WHERE ident = :ident ORDER BY date DESC LIMIT 1";
173 
+		$query = "SELECT spotter_archive.* FROM spotter_archive WHERE ident = :ident ORDER BY date DESC LIMIT 1";
174 174
175 
-		$spotter_array = $Spotter->getDataFromDB($query,array(':ident' => $ident));
175 
+		$spotter_array = $Spotter->getDataFromDB($query, array(':ident' => $ident));
176 176
177 177 
 		return $spotter_array;
178 178 
 	}
 
@@ -190,7 +190,7 @@  discard block
 
 block discarded – undo
190 190 
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
191 191 
 		//$query  = SpotterArchive->$global_query." WHERE spotter_archive.flightaware_id = :id";
192 192 
 		//$query  = "SELECT spotter_archive.* FROM spotter_archive INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_archive l WHERE l.flightaware_id = :id GROUP BY l.flightaware_id) s on spotter_archive.flightaware_id = s.flightaware_id AND spotter_archive.date = s.maxdate LIMIT 1";
193 
-		$query  = "SELECT * FROM spotter_archive WHERE flightaware_id = :id ORDER BY date DESC LIMIT 1";
193 
+		$query = "SELECT * FROM spotter_archive WHERE flightaware_id = :id ORDER BY date DESC LIMIT 1";
194 194
195 195 
 //              $spotter_array = Spotter->getDataFromDB($query,array(':id' => $id));
196 196 
 		/*
 
@@ -203,7 +203,7 @@  discard block
 
 block discarded – undo
203 203 
 		}
204 204 
 		$spotter_array = $sth->fetchAll(PDO->FETCH_ASSOC);
205 205 
 		*/
206 
-		$spotter_array = $Spotter->getDataFromDB($query,array(':id' => $id));
206 
+		$spotter_array = $Spotter->getDataFromDB($query, array(':id' => $id));
207 207
208 208 
 		return $spotter_array;
209 209 
 	}
 
@@ -217,14 +217,14 @@  discard block
 
 block discarded – undo
217 217 
 	public function getAllArchiveSpotterDataById($id) {
218 218 
 		date_default_timezone_set('UTC');
219 219 
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
220 
-		$query  = $this->global_query." WHERE spotter_archive.flightaware_id = :id ORDER BY date";
220 
+		$query = $this->global_query." WHERE spotter_archive.flightaware_id = :id ORDER BY date";
221 221
222 222 
 //              $spotter_array = Spotter->getDataFromDB($query,array(':id' => $id));
223 223
224 224 
 		try {
225 225 
 			$sth = $this->db->prepare($query);
226 226 
 			$sth->execute(array(':id' => $id));
227 
-		} catch(PDOException $e) {
227 
+		} catch (PDOException $e) {
228 228 
 			echo $e->getMessage();
229 229 
 			die;
230 230 
 		}
 
@@ -242,11 +242,11 @@  discard block
 
 block discarded – undo
242 242 
 	public function getCoordArchiveSpotterDataById($id) {
243 243 
 		date_default_timezone_set('UTC');
244 244 
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
245 
-		$query  = "SELECT spotter_archive.latitude, spotter_archive.longitude, spotter_archive.date FROM spotter_archive WHERE spotter_archive.flightaware_id = :id ORDER by spotter_archive.date ASC";
245 
+		$query = "SELECT spotter_archive.latitude, spotter_archive.longitude, spotter_archive.date FROM spotter_archive WHERE spotter_archive.flightaware_id = :id ORDER by spotter_archive.date ASC";
246 246 
 		try {
247 247 
 			$sth = $this->db->prepare($query);
248 248 
 			$sth->execute(array(':id' => $id));
249 
-		} catch(PDOException $e) {
249 
+		} catch (PDOException $e) {
250 250 
 			echo $e->getMessage();
251 251 
 			die;
252 252 
 		}
 
@@ -266,12 +266,12 @@  discard block
 
 block discarded – undo
266 266 
 		date_default_timezone_set('UTC');
267 267
268 268 
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
269 
-		$query  = "SELECT spotter_archive.altitude, spotter_archive.date FROM spotter_archive WHERE spotter_archive.ident = :ident AND spotter_archive.latitude <> 0 AND spotter_archive.longitude <> 0 ORDER BY date";
269 
+		$query = "SELECT spotter_archive.altitude, spotter_archive.date FROM spotter_archive WHERE spotter_archive.ident = :ident AND spotter_archive.latitude <> 0 AND spotter_archive.longitude <> 0 ORDER BY date";
270 270
271 271 
 		try {
272 272 
 			$sth = $this->db->prepare($query);
273 273 
 			$sth->execute(array(':ident' => $ident));
274 
-		} catch(PDOException $e) {
274 
+		} catch (PDOException $e) {
275 275 
 			echo $e->getMessage();
276 276 
 			die;
277 277 
 		}
 
@@ -291,12 +291,12 @@  discard block
 
 block discarded – undo
291 291 
 		date_default_timezone_set('UTC');
292 292
293 293 
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
294 
-		$query  = "SELECT spotter_archive.altitude, spotter_archive.date FROM spotter_archive WHERE spotter_archive.flightaware_id = :id AND spotter_archive.latitude <> 0 AND spotter_archive.longitude <> 0 ORDER BY date";
294 
+		$query = "SELECT spotter_archive.altitude, spotter_archive.date FROM spotter_archive WHERE spotter_archive.flightaware_id = :id AND spotter_archive.latitude <> 0 AND spotter_archive.longitude <> 0 ORDER BY date";
295 295
296 296 
 		try {
297 297 
 			$sth = $this->db->prepare($query);
298 298 
 			$sth->execute(array(':id' => $id));
299 
-		} catch(PDOException $e) {
299 
+		} catch (PDOException $e) {
300 300 
 			echo $e->getMessage();
301 301 
 			die;
302 302 
 		}
 
@@ -314,11 +314,11 @@  discard block
 
 block discarded – undo
314 314 
 	public function getAltitudeSpeedArchiveSpotterDataById($id) {
315 315 
 		date_default_timezone_set('UTC');
316 316 
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
317 
-		$query  = "SELECT spotter_archive.altitude, spotter_archive.real_altitude,spotter_archive.ground_speed, spotter_archive.date FROM spotter_archive WHERE spotter_archive.flightaware_id = :id ORDER BY date";
317 
+		$query = "SELECT spotter_archive.altitude, spotter_archive.real_altitude,spotter_archive.ground_speed, spotter_archive.date FROM spotter_archive WHERE spotter_archive.flightaware_id = :id ORDER BY date";
318 318 
 		try {
319 319 
 			$sth = $this->db->prepare($query);
320 320 
 			$sth->execute(array(':id' => $id));
321 
-		} catch(PDOException $e) {
321 
+		} catch (PDOException $e) {
322 322 
 			echo $e->getMessage();
323 323 
 			die;
324 324 
 		}
 
@@ -335,12 +335,12 @@  discard block
 
 block discarded – undo
335 335 
 	public function getLastAltitudeArchiveSpotterDataByIdent($ident) {
336 336 
 		date_default_timezone_set('UTC');
337 337 
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
338 
-		$query  = "SELECT spotter_archive.altitude, spotter_archive.date FROM spotter_archive INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_archive l WHERE l.ident = :ident GROUP BY l.flightaware_id) s on spotter_archive.flightaware_id = s.flightaware_id AND spotter_archive.date = s.maxdate LIMIT 1";
338 
+		$query = "SELECT spotter_archive.altitude, spotter_archive.date FROM spotter_archive INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_archive l WHERE l.ident = :ident GROUP BY l.flightaware_id) s on spotter_archive.flightaware_id = s.flightaware_id AND spotter_archive.date = s.maxdate LIMIT 1";
339 339 
 //                $query  = "SELECT spotter_archive.altitude, spotter_archive.date FROM spotter_archive WHERE spotter_archive.ident = :ident";
340 340 
 		try {
341 341 
 			$sth = $this->db->prepare($query);
342 342 
 			$sth->execute(array(':ident' => $ident));
343 
-		} catch(PDOException $e) {
343 
+		} catch (PDOException $e) {
344 344 
 			echo $e->getMessage();
345 345 
 			die;
346 346 
 		}
 
@@ -356,11 +356,11 @@  discard block
 
 block discarded – undo
356 356 
 	 * @return Array the spotter information
357 357 
 	 *
358 358 
 	 */
359 
-	public function getSpotterArchiveData($ident,$flightaware_id,$date) {
359 
+	public function getSpotterArchiveData($ident, $flightaware_id, $date) {
360 360 
 		$Spotter = new Spotter($this->db);
361 361 
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
362 
-		$query  = "SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident AND l.flightaware_id = :flightaware_id AND l.date LIKE :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate";
363 
-		$spotter_array = $Spotter->getDataFromDB($query,array(':ident' => $ident,':flightaware_id' => $flightaware_id,':date' => $date.'%'));
362 
+		$query = "SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident AND l.flightaware_id = :flightaware_id AND l.date LIKE :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate";
363 
+		$spotter_array = $Spotter->getDataFromDB($query, array(':ident' => $ident, ':flightaware_id' => $flightaware_id, ':date' => $date.'%'));
364 364 
 		return $spotter_array;
365 365 
 	}
366 366 
 
@@ -374,7 +374,7 @@  discard block
 
 block discarded – undo
374 374 
 		try {
375 375 
 			$sth = $this->db->prepare($query);
376 376 
 			$sth->execute();
377 
-		} catch(PDOException $e) {
377 
+		} catch (PDOException $e) {
378 378 
 			echo $e->getMessage();
379 379 
 			die;
380 380 
 		}
 
@@ -386,34 +386,34 @@  discard block
 
 block discarded – undo
386 386 
 	    * @return Array the spotter information
387 387 
 	    *
388 388 
 	    */
389 
-	public function getMinLiveSpotterData($begindate,$enddate,$filter = array()) {
389 
+	public function getMinLiveSpotterData($begindate, $enddate, $filter = array()) {
390 390 
 		global $globalDBdriver, $globalLiveInterval;
391 391 
 		date_default_timezone_set('UTC');
392 392
393 393 
 		$filter_query = '';
394 394 
 		if (isset($filter['source']) && !empty($filter['source'])) {
395 
-			$filter_query .= " AND format_source IN ('".implode("','",$filter['source'])."') ";
395 
+			$filter_query .= " AND format_source IN ('".implode("','", $filter['source'])."') ";
396 396 
 		}
397 397 
 		// Use spotter_output also ?
398 398 
 		if (isset($filter['airlines']) && !empty($filter['airlines'])) {
399 
-			$filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) so ON so.flightaware_id = spotter_archive.flightaware_id ";
399 
+			$filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_icao IN ('".implode("','", $filter['airlines'])."')) so ON so.flightaware_id = spotter_archive.flightaware_id ";
400 400 
 		}
401 401 
 		if (isset($filter['airlinestype']) && !empty($filter['airlinestype'])) {
402 402 
 			$filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_archive.flightaware_id ";
403 403 
 		}
404 404 
 		if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) {
405 
-			$filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')";
405 
+			$filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','", $filter['source_aprs'])."')";
406 406 
 		}
407 407
408 408 
 		//if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
409 409 
 		if ($globalDBdriver == 'mysql') {
410 
-			$query  = 'SELECT spotter_archive.date,spotter_archive.flightaware_id, spotter_archive.ident, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, a.aircraft_shadow,a.engine_type, a.engine_count, a.wake_category
410 
+			$query = 'SELECT spotter_archive.date,spotter_archive.flightaware_id, spotter_archive.ident, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, a.aircraft_shadow,a.engine_type, a.engine_count, a.wake_category
411 411 
 			          FROM spotter_archive
412 412 
 			          INNER JOIN (SELECT * FROM aircraft) a on spotter_archive.aircraft_icao = a.icao
413 413 
 			          WHERE spotter_archive.date BETWEEN '."'".$begindate."'".' AND '."'".$begindate."'".'
414 414 
 			          '.$filter_query.' ORDER BY flightaware_id';
415 415 
 		} else {
416 
-			$query  = 'SELECT spotter_archive.flightaware_id, spotter_archive.date, spotter_archive.ident, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, a.aircraft_shadow,a.engine_type, a.engine_count, a.wake_category
416 
+			$query = 'SELECT spotter_archive.flightaware_id, spotter_archive.date, spotter_archive.ident, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, a.aircraft_shadow,a.engine_type, a.engine_count, a.wake_category
417 417 
 			          FROM spotter_archive
418 418 
 			          INNER JOIN (SELECT * FROM aircraft) a on spotter_archive.aircraft_icao = a.icao
419 419 
 			          WHERE spotter_archive.date BETWEEN '."'".$begindate."'".' AND '."'".$enddate."'".'
 
@@ -423,7 +423,7 @@  discard block
 
 block discarded – undo
423 423 
 		try {
424 424 
 			$sth = $this->db->prepare($query);
425 425 
 			$sth->execute();
426 
-		} catch(PDOException $e) {
426 
+		} catch (PDOException $e) {
427 427 
 			echo $e->getMessage();
428 428 
 			die;
429 429 
 		}
 
@@ -438,23 +438,23 @@  discard block
 
 block discarded – undo
438 438 
 	    * @return Array the spotter information
439 439 
 	    *
440 440 
 	    */
441 
-	public function getMinLiveSpotterDataPlayback($begindate,$enddate,$filter = array()) {
441 
+	public function getMinLiveSpotterDataPlayback($begindate, $enddate, $filter = array()) {
442 442 
 		global $globalDBdriver, $globalLiveInterval;
443 443 
 		date_default_timezone_set('UTC');
444 444
445 445 
 		$filter_query = '';
446 446 
 		if (isset($filter['source']) && !empty($filter['source'])) {
447 
-			$filter_query .= " AND format_source IN ('".implode("','",$filter['source'])."') ";
447 
+			$filter_query .= " AND format_source IN ('".implode("','", $filter['source'])."') ";
448 448 
 		}
449 449 
 		// Should use spotter_output also ?
450 450 
 		if (isset($filter['airlines']) && !empty($filter['airlines'])) {
451 
-			$filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) so ON so.flightaware_id = spotter_archive.flightaware_id ";
451 
+			$filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_icao IN ('".implode("','", $filter['airlines'])."')) so ON so.flightaware_id = spotter_archive.flightaware_id ";
452 452 
 		}
453 453 
 		if (isset($filter['airlinestype']) && !empty($filter['airlinestype'])) {
454 454 
 			$filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output WHERE spotter_archive_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_archive.flightaware_id ";
455 455 
 		}
456 456 
 		if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) {
457 
-			$filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')";
457 
+			$filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','", $filter['source_aprs'])."')";
458 458 
 		}
459 459
460 460 
 		//if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
 
@@ -464,7 +464,7 @@  discard block
 
 block discarded – undo
464 464 
 				    FROM spotter_archive
465 465 
 				    INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_archive l WHERE (l.date BETWEEN '."'".$begindate."'".' AND '."'".$enddate."'".') GROUP BY l.flightaware_id) s on spotter_archive.flightaware_id = s.flightaware_id AND spotter_archive.date = s.maxdate '.$filter_query.'LEFT JOIN (SELECT aircraft_shadow,icao FROM aircraft) a ON spotter_archive.aircraft_icao = a.icao';
466 466 
 			*/
467 
-			$query  = 'SELECT a.aircraft_shadow, spotter_archive_output.ident, spotter_archive_output.flightaware_id, spotter_archive_output.aircraft_icao, spotter_archive_output.departure_airport_icao as departure_airport, spotter_archive_output.arrival_airport_icao as arrival_airport, spotter_archive_output.latitude, spotter_archive_output.longitude, spotter_archive_output.altitude, spotter_archive_output.heading, spotter_archive_output.ground_speed, spotter_archive_output.squawk
467 
+			$query = 'SELECT a.aircraft_shadow, spotter_archive_output.ident, spotter_archive_output.flightaware_id, spotter_archive_output.aircraft_icao, spotter_archive_output.departure_airport_icao as departure_airport, spotter_archive_output.arrival_airport_icao as arrival_airport, spotter_archive_output.latitude, spotter_archive_output.longitude, spotter_archive_output.altitude, spotter_archive_output.heading, spotter_archive_output.ground_speed, spotter_archive_output.squawk
468 468 
 			          FROM spotter_archive_output
469 469 
 			          LEFT JOIN (SELECT aircraft_shadow,icao FROM aircraft) a ON spotter_archive_output.aircraft_icao = a.icao
470 470 
 			          WHERE (spotter_archive_output.date BETWEEN '."'".$begindate."'".' AND '."'".$enddate."'".')
 
@@ -479,7 +479,7 @@  discard block
 
 block discarded – undo
479 479 
 			 	    WHERE spotter_archive_output.date >= '."'".$begindate."'".' AND spotter_archive_output.date <= '."'".$enddate."'".'
480 480 
 			 	    '.$filter_query.' GROUP BY spotter_archive_output.flightaware_id, spotter_archive_output.ident, spotter_archive_output.aircraft_icao, spotter_archive_output.departure_airport_icao, spotter_archive_output.arrival_airport_icao, spotter_archive_output.latitude, spotter_archive_output.longitude, spotter_archive_output.altitude, spotter_archive_output.heading, spotter_archive_output.ground_speed, spotter_archive_output.squawk, a.aircraft_shadow';
481 481 
 			 */
482 
-			$query  = 'SELECT DISTINCT spotter_archive_output.flightaware_id, spotter_archive_output.ident, spotter_archive_output.aircraft_icao, spotter_archive_output.departure_airport_icao as departure_airport, spotter_archive_output.arrival_airport_icao as arrival_airport, spotter_archive_output.latitude, spotter_archive_output.longitude, spotter_archive_output.altitude, spotter_archive_output.heading, spotter_archive_output.ground_speed, spotter_archive_output.squawk, a.aircraft_shadow
482 
+			$query = 'SELECT DISTINCT spotter_archive_output.flightaware_id, spotter_archive_output.ident, spotter_archive_output.aircraft_icao, spotter_archive_output.departure_airport_icao as departure_airport, spotter_archive_output.arrival_airport_icao as arrival_airport, spotter_archive_output.latitude, spotter_archive_output.longitude, spotter_archive_output.altitude, spotter_archive_output.heading, spotter_archive_output.ground_speed, spotter_archive_output.squawk, a.aircraft_shadow
483 483 
 			          FROM spotter_archive_output
484 484 
 			          INNER JOIN (SELECT * FROM aircraft) a on spotter_archive_output.aircraft_icao = a.icao
485 485 
 			          WHERE spotter_archive_output.date >= '."'".$begindate."'".' AND spotter_archive_output.date <= '."'".$enddate."'".'
 
@@ -491,7 +491,7 @@  discard block
 
 block discarded – undo
491 491 
 		try {
492 492 
 			$sth = $this->db->prepare($query);
493 493 
 			$sth->execute();
494 
-		} catch(PDOException $e) {
494 
+		} catch (PDOException $e) {
495 495 
 			echo $e->getMessage();
496 496 
 			die;
497 497 
 		}
 
@@ -506,22 +506,22 @@  discard block
 
 block discarded – undo
506 506 
 	   * @return Array the spotter information
507 507 
 	   *
508 508 
 	   */
509 
-	public function getLiveSpotterCount($begindate,$enddate,$filter = array()) {
509 
+	public function getLiveSpotterCount($begindate, $enddate, $filter = array()) {
510 510 
 		global $globalDBdriver, $globalLiveInterval;
511 511 
 		date_default_timezone_set('UTC');
512 512
513 513 
 		$filter_query = '';
514 514 
 		if (isset($filter['source']) && !empty($filter['source'])) {
515 
-			$filter_query .= " AND format_source IN ('".implode("','",$filter['source'])."') ";
515 
+			$filter_query .= " AND format_source IN ('".implode("','", $filter['source'])."') ";
516 516 
 		}
517 517 
 		if (isset($filter['airlines']) && !empty($filter['airlines'])) {
518 
-			$filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) so ON so.flightaware_id = spotter_archive.flightaware_id ";
518 
+			$filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','", $filter['airlines'])."')) so ON so.flightaware_id = spotter_archive.flightaware_id ";
519 519 
 		}
520 520 
 		if (isset($filter['airlinestype']) && !empty($filter['airlinestype'])) {
521 521 
 			$filter_query .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_archive.flightaware_id ";
522 522 
 		}
523 523 
 		if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) {
524 
-			$filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')";
524 
+			$filter_query = " AND format_source = 'aprs' AND source_name IN ('".implode("','", $filter['source_aprs'])."')";
525 525 
 		}
526 526
527 527 
 		//if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
 
@@ -536,7 +536,7 @@  discard block
 
 block discarded – undo
536 536 
 		try {
537 537 
 			$sth = $this->db->prepare($query);
538 538 
 			$sth->execute();
539 
-		} catch(PDOException $e) {
539 
+		} catch (PDOException $e) {
540 540 
 			echo $e->getMessage();
541 541 
 			die;
542 542 
 		}
 
@@ -556,7 +556,7 @@  discard block
 
 block discarded – undo
556 556 
 	* @return Array the spotter information
557 557 
 	*
558 558 
 	*/
559 
-	public function searchSpotterData($q = '', $registration = '', $aircraft_icao = '', $aircraft_manufacturer = '', $highlights = '', $airline_icao = '', $airline_country = '', $airline_type = '', $airport = '', $airport_country = '', $callsign = '', $departure_airport_route = '', $arrival_airport_route = '', $owner = '',$pilot_id = '',$pilot_name = '',$altitude = '', $date_posted = '', $limit = '', $sort = '', $includegeodata = '',$origLat = '',$origLon = '',$dist = '', $filters=array()) {
559 
+	public function searchSpotterData($q = '', $registration = '', $aircraft_icao = '', $aircraft_manufacturer = '', $highlights = '', $airline_icao = '', $airline_country = '', $airline_type = '', $airport = '', $airport_country = '', $callsign = '', $departure_airport_route = '', $arrival_airport_route = '', $owner = '', $pilot_id = '', $pilot_name = '', $altitude = '', $date_posted = '', $limit = '', $sort = '', $includegeodata = '', $origLat = '', $origLon = '', $dist = '', $filters = array()) {
560 560 
 		global $globalTimezone, $globalDBdriver;
561 561 
 		require_once(dirname(__FILE__).'/class.Translation.php');
562 562 
 		$Translation = new Translation($this->db);
 
@@ -606,7 +606,7 @@  discard block
 
 block discarded – undo
606 606 
 		}
607 607
608 608 
 		if ($registration != "") {
609 
-			$registration = filter_var($registration,FILTER_SANITIZE_STRING);
609 
+			$registration = filter_var($registration, FILTER_SANITIZE_STRING);
610 610 
 			if (!is_string($registration)) {
611 611 
 				return false;
612 612 
 			} else {
 
@@ -615,7 +615,7 @@  discard block
 
 block discarded – undo
615 615 
 		}
616 616
617 617 
 		if ($aircraft_icao != "") {
618 
-			$aircraft_icao = filter_var($aircraft_icao,FILTER_SANITIZE_STRING);
618 
+			$aircraft_icao = filter_var($aircraft_icao, FILTER_SANITIZE_STRING);
619 619 
 			if (!is_string($aircraft_icao)) {
620 620 
 				return false;
621 621 
 			} else {
 
@@ -624,7 +624,7 @@  discard block
 
 block discarded – undo
624 624 
 		}
625 625
626 626 
 		if ($aircraft_manufacturer != "") {
627 
-			$aircraft_manufacturer = filter_var($aircraft_manufacturer,FILTER_SANITIZE_STRING);
627 
+			$aircraft_manufacturer = filter_var($aircraft_manufacturer, FILTER_SANITIZE_STRING);
628 628 
 			if (!is_string($aircraft_manufacturer)) {
629 629 
 				return false;
630 630 
 			} else {
 
@@ -641,7 +641,7 @@  discard block
 
 block discarded – undo
641 641 
 		}
642 642
643 643 
 		if ($airline_icao != "") {
644 
-			$airline_icao = filter_var($airline_icao,FILTER_SANITIZE_STRING);
644 
+			$airline_icao = filter_var($airline_icao, FILTER_SANITIZE_STRING);
645 645 
 			if (!is_string($airline_icao)) {
646 646 
 				return false;
647 647 
 			} else {
 
@@ -650,7 +650,7 @@  discard block
 
 block discarded – undo
650 650 
 		}
651 651
652 652 
 		if ($airline_country != "") {
653 
-			$airline_country = filter_var($airline_country,FILTER_SANITIZE_STRING);
653 
+			$airline_country = filter_var($airline_country, FILTER_SANITIZE_STRING);
654 654 
 			if (!is_string($airline_country)) {
655 655 
 				return false;
656 656 
 			} else {
 
@@ -659,7 +659,7 @@  discard block
 
 block discarded – undo
659 659 
 		}
660 660
661 661 
 		if ($airline_type != "") {
662 
-			$airline_type = filter_var($airline_type,FILTER_SANITIZE_STRING);
662 
+			$airline_type = filter_var($airline_type, FILTER_SANITIZE_STRING);
663 663 
 			if (!is_string($airline_type)) {
664 664 
 				return false;
665 665 
 			} else {
 
@@ -676,7 +676,7 @@  discard block
 
 block discarded – undo
676 676 
 		}
677 677
678 678 
 		if ($airport != "") {
679 
-			$airport = filter_var($airport,FILTER_SANITIZE_STRING);
679 
+			$airport = filter_var($airport, FILTER_SANITIZE_STRING);
680 680 
 			if (!is_string($airport)) {
681 681 
 				return false;
682 682 
 			} else {
 
@@ -685,7 +685,7 @@  discard block
 
 block discarded – undo
685 685 
 		}
686 686
687 687 
 		if ($airport_country != "") {
688 
-			$airport_country = filter_var($airport_country,FILTER_SANITIZE_STRING);
688 
+			$airport_country = filter_var($airport_country, FILTER_SANITIZE_STRING);
689 689 
 			if (!is_string($airport_country)) {
690 690 
 				return false;
691 691 
 			} else {
 
@@ -694,14 +694,14 @@  discard block
 
 block discarded – undo
694 694 
 		}
695 695
696 696 
 		if ($callsign != "") {
697 
-			$callsign = filter_var($callsign,FILTER_SANITIZE_STRING);
697 
+			$callsign = filter_var($callsign, FILTER_SANITIZE_STRING);
698 698 
 			if (!is_string($callsign)) {
699 699 
 				return false;
700 700 
 			} else {
701 701 
 				$translate = $Translation->ident2icao($callsign);
702 702 
 				if ($translate != $callsign) {
703 703 
 					$additional_query .= " AND (spotter_archive_output.ident = :callsign OR spotter_archive_output.ident = :translate)";
704 
-					$query_values = array_merge($query_values,array(':callsign' => $callsign,':translate' => $translate));
704 
+					$query_values = array_merge($query_values, array(':callsign' => $callsign, ':translate' => $translate));
705 705 
 				} else {
706 706 
 					$additional_query .= " AND (spotter_archive_output.ident = '".$callsign."')";
707 707 
 				}
 
@@ -709,7 +709,7 @@  discard block
 
 block discarded – undo
709 709 
 		}
710 710
711 711 
 		if ($owner != "") {
712 
-			$owner = filter_var($owner,FILTER_SANITIZE_STRING);
712 
+			$owner = filter_var($owner, FILTER_SANITIZE_STRING);
713 713 
 			if (!is_string($owner)) {
714 714 
 				return false;
715 715 
 			} else {
 
@@ -718,7 +718,7 @@  discard block
 
 block discarded – undo
718 718 
 		}
719 719
720 720 
 		if ($pilot_name != "") {
721 
-			$pilot_name = filter_var($pilot_name,FILTER_SANITIZE_STRING);
721 
+			$pilot_name = filter_var($pilot_name, FILTER_SANITIZE_STRING);
722 722 
 			if (!is_string($pilot_name)) {
723 723 
 				return false;
724 724 
 			} else {
 
@@ -727,7 +727,7 @@  discard block
 
 block discarded – undo
727 727 
 		}
728 728
729 729 
 		if ($pilot_id != "") {
730 
-			$pilot_id = filter_var($pilot_id,FILTER_SANITIZE_NUMBER_INT);
730 
+			$pilot_id = filter_var($pilot_id, FILTER_SANITIZE_NUMBER_INT);
731 731 
 			if (!is_string($pilot_id)) {
732 732 
 				return false;
733 733 
 			} else {
 
@@ -736,7 +736,7 @@  discard block
 
 block discarded – undo
736 736 
 		}
737 737
738 738 
 		if ($departure_airport_route != "") {
739 
-			$departure_airport_route = filter_var($departure_airport_route,FILTER_SANITIZE_STRING);
739 
+			$departure_airport_route = filter_var($departure_airport_route, FILTER_SANITIZE_STRING);
740 740 
 			if (!is_string($departure_airport_route)) {
741 741 
 				return false;
742 742 
 			} else {
 
@@ -745,7 +745,7 @@  discard block
 
 block discarded – undo
745 745 
 		}
746 746
747 747 
 		if ($arrival_airport_route != "") {
748 
-			$arrival_airport_route = filter_var($arrival_airport_route,FILTER_SANITIZE_STRING);
748 
+			$arrival_airport_route = filter_var($arrival_airport_route, FILTER_SANITIZE_STRING);
749 749 
 			if (!is_string($arrival_airport_route)) {
750 750 
 				return false;
751 751 
 			} else {
 
@@ -756,8 +756,8 @@  discard block
 
 block discarded – undo
756 756 
 		if ($altitude != "") {
757 757 
 			$altitude_array = explode(",", $altitude);
758 758
759 
-			$altitude_array[0] = filter_var($altitude_array[0],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
760 
-			$altitude_array[1] = filter_var($altitude_array[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
759 
+			$altitude_array[0] = filter_var($altitude_array[0], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
760 
+			$altitude_array[1] = filter_var($altitude_array[1], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
761 761
762 762
763 763 
 			if ($altitude_array[1] != "") {
 
@@ -772,8 +772,8 @@  discard block
 
 block discarded – undo
772 772
773 773 
 		if ($date_posted != "") {
774 774 
 			$date_array = explode(",", $date_posted);
775 
-			$date_array[0] = filter_var($date_array[0],FILTER_SANITIZE_STRING);
776 
-			$date_array[1] = filter_var($date_array[1],FILTER_SANITIZE_STRING);
775 
+			$date_array[0] = filter_var($date_array[0], FILTER_SANITIZE_STRING);
776 
+			$date_array[1] = filter_var($date_array[1], FILTER_SANITIZE_STRING);
777 777 
 			if ($globalTimezone != '') {
778 778 
 				date_default_timezone_set($globalTimezone);
779 779 
 				$datetime = new DateTime();
 
@@ -798,16 +798,16 @@  discard block
 
 block discarded – undo
798 798 
 		}
799 799 
 		if ($limit != "") {
800 800 
 			$limit_array = explode(",", $limit);
801 
-			$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT);
802 
-			$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT);
801 
+			$limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT);
802 
+			$limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT);
803 803 
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0) {
804 804 
 				//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1];
805 805 
 				$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0];
806 806 
 			}
807 807 
 		}
808 808 
 		if ($origLat != "" && $origLon != "" && $dist != "") {
809 
-			$dist = number_format($dist*0.621371,2,'.','');
810 
-			$query="SELECT spotter_archive_output.*, 3956 * 2 * ASIN(SQRT( POWER(SIN(($origLat - ABS(CAST(spotter_archive.latitude as double precision)))*pi()/180/2),2)+COS( $origLat *pi()/180)*COS(ABS(CAST(spotter_archive.latitude as double precision))*pi()/180)*POWER(SIN(($origLon-CAST(spotter_archive.longitude as double precision))*pi()/180/2),2))) as distance
809 
+			$dist = number_format($dist*0.621371, 2, '.', '');
810 
+			$query = "SELECT spotter_archive_output.*, 3956 * 2 * ASIN(SQRT( POWER(SIN(($origLat - ABS(CAST(spotter_archive.latitude as double precision)))*pi()/180/2),2)+COS( $origLat *pi()/180)*COS(ABS(CAST(spotter_archive.latitude as double precision))*pi()/180)*POWER(SIN(($origLon-CAST(spotter_archive.longitude as double precision))*pi()/180/2),2))) as distance
811 811 
 			       FROM spotter_archive_output, spotter_archive WHERE spotter_output_archive.flightaware_id = spotter_archive.flightaware_id AND spotter_output.ident <> '' ".$additional_query."AND CAST(spotter_archive.longitude as double precision) between ($origLon-$dist/ABS(cos(radians($origLat))*69)) and ($origLon+$dist/ABS(cos(radians($origLat))*69)) and CAST(spotter_archive.latitude as double precision) between ($origLat-($dist/69)) and ($origLat+($dist/69))
812 812 
 			       AND (3956 * 2 * ASIN(SQRT( POWER(SIN(($origLat - ABS(CAST(spotter_archive.latitude as double precision)))*pi()/180/2),2)+COS( $origLat *pi()/180)*COS(ABS(CAST(spotter_archive.latitude as double precision))*pi()/180)*POWER(SIN(($origLon-CAST(spotter_archive.longitude as double precision))*pi()/180/2),2)))) < $dist".$filter_query." ORDER BY distance";
813 813 
 		} else {
 
@@ -821,12 +821,12 @@  discard block
 
 block discarded – undo
821 821 
 				$additional_query .= " AND (spotter_archive_output.waypoints <> '')";
822 822 
 			}
823 823
824 
-			$query  = "SELECT spotter_archive_output.* FROM spotter_archive_output
824 
+			$query = "SELECT spotter_archive_output.* FROM spotter_archive_output
825 825 
 			          WHERE spotter_archive_output.ident <> ''
826 826 
 			          ".$additional_query."
827 827 
 			          ".$filter_query.$orderby_query;
828 828 
 		}
829 
-		$spotter_array = $Spotter->getDataFromDB($query, $query_values,$limit_query);
829 
+		$spotter_array = $Spotter->getDataFromDB($query, $query_values, $limit_query);
830 830 
 		return $spotter_array;
831 831 
 	}
832 832 
 
@@ -841,7 +841,7 @@  discard block
 
 block discarded – undo
841 841 
 		try {
842 842 
 			$sth = $this->db->prepare($query);
843 843 
 			$sth->execute();
844 
-		} catch(PDOException $e) {
844 
+		} catch (PDOException $e) {
845 845 
 			return "error";
846 846 
 		}
847 847 
 	}
 
@@ -874,8 +874,8 @@  discard block
 
 block discarded – undo
874 874 
 		if ($limit != "") {
875 875 
 			$limit_array = explode(",", $limit);
876 876
877 
-			$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT);
878 
-			$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT);
877 
+			$limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT);
878 
+			$limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT);
879 879
880 880 
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0) {
881 881 
 				//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1];
 
@@ -913,7 +913,7 @@  discard block
 
 block discarded – undo
913 913 
 		$query_values = array();
914 914 
 		$limit_query = '';
915 915 
 		$additional_query = '';
916 
-		$filter_query = $this->getFilter($filter,true,true);
916 
+		$filter_query = $this->getFilter($filter, true, true);
917 917
918 918 
 		if ($owner != "") {
919 919 
 			if (!is_string($owner)) {
 
@@ -927,8 +927,8 @@  discard block
 
 block discarded – undo
927 927 
 		if ($limit != "") {
928 928 
 			$limit_array = explode(",", $limit);
929 929
930 
-			$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT);
931 
-			$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT);
930 
+			$limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT);
931 
+			$limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT);
932 932
933 933 
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0) {
934 934 
 				//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1];
 
@@ -965,7 +965,7 @@  discard block
 
 block discarded – undo
965 965 
 		$query_values = array();
966 966 
 		$limit_query = '';
967 967 
 		$additional_query = '';
968 
-		$filter_query = $this->getFilter($filter,true,true);
968 
+		$filter_query = $this->getFilter($filter, true, true);
969 969
970 970 
 		if ($pilot != "") {
971 971 
 			$additional_query = " AND (spotter_archive_output.pilot_id = :pilot OR spotter_archive_output.pilot_name = :pilot)";
 
@@ -975,8 +975,8 @@  discard block
 
 block discarded – undo
975 975 
 		if ($limit != "") {
976 976 
 			$limit_array = explode(",", $limit);
977 977
978 
-			$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT);
979 
-			$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT);
978 
+			$limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT);
979 
+			$limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT);
980 980
981 981 
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0) {
982 982 
 				//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1];
 
@@ -1004,7 +1004,7 @@  discard block
 
 block discarded – undo
1004 1004 
 	* @return Array the airline country list
1005 1005 
 	*
1006 1006 
 	*/
1007 
-	public function countAllFlightOverCountries($limit = true,$olderthanmonths = 0,$sincedate = '') {
1007 
+	public function countAllFlightOverCountries($limit = true, $olderthanmonths = 0, $sincedate = '') {
1008 1008 
 		global $globalDBdriver;
1009 1009 
 		/*
1010 1010 
 		$query = "SELECT c.name, c.iso3, c.iso2, count(c.name) as nb
 
@@ -1032,7 +1032,7 @@  discard block
 
 block discarded – undo
1032 1032 
 		$flight_array = array();
1033 1033 
 		$temp_array = array();
1034 1034
1035 
-		while($row = $sth->fetch(PDO::FETCH_ASSOC)) {
1035 
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
1036 1036 
 			$temp_array['flight_count'] = $row['nb'];
1037 1037 
 			$temp_array['flight_country'] = $row['name'];
1038 1038 
 			$temp_array['flight_country_iso3'] = $row['iso3'];
 
@@ -1048,7 +1048,7 @@  discard block
 
 block discarded – undo
1048 1048 
 	* @return Array the airline country list
1049 1049 
 	*
1050 1050 
 	*/
1051 
-	public function countAllFlightOverCountriesByAirlines($limit = true,$olderthanmonths = 0,$sincedate = '') {
1051 
+	public function countAllFlightOverCountriesByAirlines($limit = true, $olderthanmonths = 0, $sincedate = '') {
1052 1052 
 		global $globalDBdriver;
1053 1053 
 		/*
1054 1054 
 		$query = "SELECT c.name, c.iso3, c.iso2, count(c.name) as nb
 
@@ -1076,7 +1076,7 @@  discard block
 
 block discarded – undo
1076 1076 
 		$flight_array = array();
1077 1077 
 		$temp_array = array();
1078 1078
1079 
-		while($row = $sth->fetch(PDO::FETCH_ASSOC)) {
1079 
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
1080 1080 
 			$temp_array['airline_icao'] = $row['airline_icao'];
1081 1081 
 			$temp_array['flight_count'] = $row['nb'];
1082 1082 
 			$temp_array['flight_country'] = $row['name'];
 
@@ -1093,13 +1093,13 @@  discard block
 
 block discarded – undo
1093 1093 
 	* @return Array the spotter information
1094 1094 
 	*
1095 1095 
 	*/
1096 
-	public function getDateArchiveSpotterDataById($id,$date) {
1096 
+	public function getDateArchiveSpotterDataById($id, $date) {
1097 1097 
 		$Spotter = new Spotter($this->db);
1098 1098 
 		date_default_timezone_set('UTC');
1099 1099 
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
1100 
-		$query  = 'SELECT spotter_archive.* FROM spotter_archive INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_archive l WHERE l.flightaware_id = :id AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_archive.flightaware_id = s.flightaware_id AND spotter_archive.date = s.maxdate ORDER BY spotter_archive.date DESC';
1101 
-		$date = date('c',$date);
1102 
-		$spotter_array = $Spotter->getDataFromDB($query,array(':id' => $id,':date' => $date));
1100 
+		$query = 'SELECT spotter_archive.* FROM spotter_archive INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_archive l WHERE l.flightaware_id = :id AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_archive.flightaware_id = s.flightaware_id AND spotter_archive.date = s.maxdate ORDER BY spotter_archive.date DESC';
1101 
+		$date = date('c', $date);
1102 
+		$spotter_array = $Spotter->getDataFromDB($query, array(':id' => $id, ':date' => $date));
1103 1103 
 		return $spotter_array;
1104 1104 
 	}
1105 1105 
 
@@ -1109,13 +1109,13 @@  discard block
 
 block discarded – undo
1109 1109 
 	* @return Array the spotter information
1110 1110 
 	*
1111 1111 
 	*/
1112 
-	public function getDateArchiveSpotterDataByIdent($ident,$date) {
1112 
+	public function getDateArchiveSpotterDataByIdent($ident, $date) {
1113 1113 
 		$Spotter = new Spotter($this->db);
1114 1114 
 		date_default_timezone_set('UTC');
1115 1115 
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
1116 
-		$query  = 'SELECT spotter_archive.* FROM spotter_archive INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_archive l WHERE l.ident = :ident AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_archive.flightaware_id = s.flightaware_id AND spotter_archive.date = s.maxdate ORDER BY spotter_archive.date DESC';
1117 
-		$date = date('c',$date);
1118 
-		$spotter_array = $Spotter->getDataFromDB($query,array(':ident' => $ident,':date' => $date));
1116 
+		$query = 'SELECT spotter_archive.* FROM spotter_archive INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_archive l WHERE l.ident = :ident AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_archive.flightaware_id = s.flightaware_id AND spotter_archive.date = s.maxdate ORDER BY spotter_archive.date DESC';
1117 
+		$date = date('c', $date);
1118 
+		$spotter_array = $Spotter->getDataFromDB($query, array(':ident' => $ident, ':date' => $date));
1119 1119 
 		return $spotter_array;
1120 1120 
 	}
1121 1121 
 
@@ -1125,14 +1125,14 @@  discard block
 
 block discarded – undo
1125 1125 
 	* @return Array the spotter information
1126 1126 
 	*
1127 1127 
 	*/
1128 
-	public function getSpotterDataByAirport($airport = '', $limit = '', $sort = '',$filters = array()) {
1128 
+	public function getSpotterDataByAirport($airport = '', $limit = '', $sort = '', $filters = array()) {
1129 1129 
 		global $global_query;
1130 1130 
 		$Spotter = new Spotter($this->db);
1131 1131 
 		date_default_timezone_set('UTC');
1132 1132 
 		$query_values = array();
1133 1133 
 		$limit_query = '';
1134 1134 
 		$additional_query = '';
1135 
-		$filter_query = $this->getFilter($filters,true,true);
1135 
+		$filter_query = $this->getFilter($filters, true, true);
1136 1136
1137 1137 
 		if ($airport != "") {
1138 1138 
 			if (!is_string($airport)) {
 
@@ -1146,8 +1146,8 @@  discard block
 
 block discarded – undo
1146 1146 
 		if ($limit != "") {
1147 1147 
 			$limit_array = explode(",", $limit);
1148 1148
1149 
-			$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT);
1150 
-			$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT);
1149 
+			$limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT);
1150 
+			$limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT);
1151 1151
1152 1152 
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0) {
1153 1153 
 				//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1];
Please login to merge, or discard this patch.
archive-geojson.php 1 patch
Spacing   +28 added lines, -28 removed lines patch added patch discarded remove patch 
@@ -60,24 +60,24 @@  discard block
 
 block discarded – undo
60 60 
 $min = false;
61 61 
 $allhistory = false;
62 62 
 $filter['source'] = array();
63 
-if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalVATSIM) && $globalVATSIM && isset($_COOKIE['filter_ShowVATSIM']) && $_COOKIE['filter_ShowVATSIM'] == 'true') $filter['source'] = array_merge($filter['source'],array('vatsimtxt'));
64 
-if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalIVAO) && $globalIVAO && isset($_COOKIE['filter_ShowIVAO']) && $_COOKIE['filter_ShowIVAO'] == 'true') $filter['source'] = array_merge($filter['source'],array('whazzup'));
65 
-if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalphpVMS) && $globalphpVMS && isset($_COOKIE['filter_ShowVMS']) && $_COOKIE['filter_ShowVMS'] == 'true') $filter['source'] = array_merge($filter['source'],array('phpvmacars'));
66 
-if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalSBS1) && $globalSBS1 && isset($_COOKIE['filter_ShowSBS1']) && $_COOKIE['filter_ShowSBS1'] == 'true') $filter['source'] = array_merge($filter['source'],array('sbs','famaprs'));
67 
-if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalAPRS) && $globalAPRS && isset($_COOKIE['filter_ShowAPRS']) && $_COOKIE['filter_ShowAPRS'] == 'true') $filter['source'] = array_merge($filter['source'],array('aprs'));
68 
-if (isset($_COOKIE['filter_ident']) && $_COOKIE['filter_ident'] != '') $filter['ident'] = filter_var($_COOKIE['filter_ident'],FILTER_SANITIZE_STRING);
69 
-if (isset($_COOKIE['filter_mmsi']) && $_COOKIE['filter_mmsi'] != '') $filter['mmsi'] = filter_var($_COOKIE['filter_mmsi'],FILTER_SANITIZE_STRING);
70 
-if (isset($_COOKIE['filter_Airlines']) && $_COOKIE['filter_Airlines'] != '') $filter['airlines'] = filter_var_array(explode(',',$_COOKIE['filter_Airlines']),FILTER_SANITIZE_STRING);
71 
-if (isset($_COOKIE['filter_Sources']) && $_COOKIE['filter_Sources'] != '') $filter['source_aprs'] = filter_var_array(explode(',',$_COOKIE['filter_Sources']),FILTER_SANITIZE_STRING);
72 
-if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] != 'all') $filter['airlinestype'] = filter_var($_COOKIE['filter_airlinestype'],FILTER_SANITIZE_STRING);
73 
-if (isset($_COOKIE['filter_alliance']) && $_COOKIE['filter_alliance'] != 'all') $filter['alliance'] = filter_var($_COOKIE['filter_alliance'],FILTER_SANITIZE_STRING);
63 
+if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalVATSIM) && $globalVATSIM && isset($_COOKIE['filter_ShowVATSIM']) && $_COOKIE['filter_ShowVATSIM'] == 'true') $filter['source'] = array_merge($filter['source'], array('vatsimtxt'));
64 
+if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalIVAO) && $globalIVAO && isset($_COOKIE['filter_ShowIVAO']) && $_COOKIE['filter_ShowIVAO'] == 'true') $filter['source'] = array_merge($filter['source'], array('whazzup'));
65 
+if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalphpVMS) && $globalphpVMS && isset($_COOKIE['filter_ShowVMS']) && $_COOKIE['filter_ShowVMS'] == 'true') $filter['source'] = array_merge($filter['source'], array('phpvmacars'));
66 
+if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalSBS1) && $globalSBS1 && isset($_COOKIE['filter_ShowSBS1']) && $_COOKIE['filter_ShowSBS1'] == 'true') $filter['source'] = array_merge($filter['source'], array('sbs', 'famaprs'));
67 
+if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalAPRS) && $globalAPRS && isset($_COOKIE['filter_ShowAPRS']) && $_COOKIE['filter_ShowAPRS'] == 'true') $filter['source'] = array_merge($filter['source'], array('aprs'));
68 
+if (isset($_COOKIE['filter_ident']) && $_COOKIE['filter_ident'] != '') $filter['ident'] = filter_var($_COOKIE['filter_ident'], FILTER_SANITIZE_STRING);
69 
+if (isset($_COOKIE['filter_mmsi']) && $_COOKIE['filter_mmsi'] != '') $filter['mmsi'] = filter_var($_COOKIE['filter_mmsi'], FILTER_SANITIZE_STRING);
70 
+if (isset($_COOKIE['filter_Airlines']) && $_COOKIE['filter_Airlines'] != '') $filter['airlines'] = filter_var_array(explode(',', $_COOKIE['filter_Airlines']), FILTER_SANITIZE_STRING);
71 
+if (isset($_COOKIE['filter_Sources']) && $_COOKIE['filter_Sources'] != '') $filter['source_aprs'] = filter_var_array(explode(',', $_COOKIE['filter_Sources']), FILTER_SANITIZE_STRING);
72 
+if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] != 'all') $filter['airlinestype'] = filter_var($_COOKIE['filter_airlinestype'], FILTER_SANITIZE_STRING);
73 
+if (isset($_COOKIE['filter_alliance']) && $_COOKIE['filter_alliance'] != 'all') $filter['alliance'] = filter_var($_COOKIE['filter_alliance'], FILTER_SANITIZE_STRING);
74 74
75 75 
 if (isset($globalMapPopup) && !$globalMapPopup && !(isset($_COOKIE['flightpopup']) && $_COOKIE['flightpopup'] == 'true')) {
76 76 
 	$min = true;
77 77 
 } else $min = false;
78 78
79 79 
 if (isset($_GET['ident'])) {
80 
-	$ident = filter_input(INPUT_GET,'ident',FILTER_SANITIZE_STRING);
80 
+	$ident = filter_input(INPUT_GET, 'ident', FILTER_SANITIZE_STRING);
81 81 
 	$from_archive = true;
82 82 
 	if ($tracker) {
83 83 
 		$spotter_array = $TrackerArchive->getLastArchiveTrackerDataByIdent($ident);
 
@@ -91,7 +91,7 @@  discard block
 
 block discarded – undo
91 91 
 	$allhistory = true;
92 92 
 }
93 93 
 elseif (isset($_GET['flightaware_id'])) {
94 
-	$flightaware_id = filter_input(INPUT_GET,'flightaware_id',FILTER_SANITIZE_STRING);
94 
+	$flightaware_id = filter_input(INPUT_GET, 'flightaware_id', FILTER_SANITIZE_STRING);
95 95 
 	$from_archive = true;
96 96 
 	if ($tracker) {
97 97 
 		$spotter_array = $TrackerArchive->getLastArchiveTrackerDataById($flightaware_id);
 
@@ -106,23 +106,23 @@  discard block
 
 block discarded – undo
106 106 
 }
107 107 
 elseif (isset($_GET['archive']) && isset($_GET['begindate']) && isset($_GET['enddate']) && isset($_GET['speed'])) {
108 108 
 	$from_archive = true;
109 
-	$begindate = filter_input(INPUT_GET,'begindate',FILTER_SANITIZE_NUMBER_INT);
109 
+	$begindate = filter_input(INPUT_GET, 'begindate', FILTER_SANITIZE_NUMBER_INT);
110 110 
 	if (isset($globalAircraftMaxUpdate)) $begindate = $begindate - $globalAircraftMaxUpdate;
111 111 
 	else $begindate = $begindate - 3000;
112 
-	$enddate = filter_input(INPUT_GET,'enddate',FILTER_SANITIZE_NUMBER_INT);
113 
-	$archivespeed = filter_input(INPUT_GET,'speed',FILTER_SANITIZE_NUMBER_INT);
112 
+	$enddate = filter_input(INPUT_GET, 'enddate', FILTER_SANITIZE_NUMBER_INT);
113 
+	$archivespeed = filter_input(INPUT_GET, 'speed', FILTER_SANITIZE_NUMBER_INT);
114 114 
 	if ($begindate != '' && $enddate != '') {
115 
-		$begindate = date('Y-m-d H:i:s',$begindate);
116 
-		$enddate = date('Y-m-d H:i:s',$enddate);
115 
+		$begindate = date('Y-m-d H:i:s', $begindate);
116 
+		$enddate = date('Y-m-d H:i:s', $enddate);
117 117 
 		//$spotter_array = $SpotterArchive->getMinLiveSpotterDataPlayback($begindate,$enddate,$filter);
118 118 
 		if ($tracker) {
119 
-			$spotter_array = $TrackerArchive->getMinLiveTrackerData($begindate,$enddate,$filter);
119 
+			$spotter_array = $TrackerArchive->getMinLiveTrackerData($begindate, $enddate, $filter);
120 120 
 		}
121 121 
 		elseif ($marine) {
122 
-			$spotter_array = $MarineArchive->getMinLiveMarineData($begindate,$enddate,$filter);
122 
+			$spotter_array = $MarineArchive->getMinLiveMarineData($begindate, $enddate, $filter);
123 123 
 		}
124 124 
 		else {
125 
-			$spotter_array = $SpotterArchive->getMinLiveSpotterData($begindate,$enddate,$filter);
125 
+			$spotter_array = $SpotterArchive->getMinLiveSpotterData($begindate, $enddate, $filter);
126 126 
 		}
127 127 
 	}
128 128 
 }
 
@@ -133,7 +133,7 @@  discard block
 
 block discarded – undo
133 133 
 	if ($flightcnt == '') $flightcnt = 0;
134 134 
 } else $flightcnt = 0;
135 135
136 
-$sqltime = round(microtime(true)-$begintime,2);
136 
+$sqltime = round(microtime(true) - $begintime, 2);
137 137
138 138 
 $pfi = '';
139 139 
 //var_dump($spotter_array);
 
@@ -148,7 +148,7 @@  discard block
 
 block discarded – undo
148 148
149 149 
 if (!empty($spotter_array) && is_array($spotter_array)) {
150 150 
 	$output .= '"features": [';
151 
-	foreach($spotter_array as $spotter_item) {
151 
+	foreach ($spotter_array as $spotter_item) {
152 152 
 		$j++;
153 153 
 		date_default_timezone_set('UTC');
154 154 
 		if ($tracker) {
 
@@ -310,17 +310,17 @@  discard block
 
 block discarded – undo
310 310 
 					$k++;
311 311 
 					$output_history .= '['.$spotter_history['longitude'].', '.$spotter_history['latitude'].'],';
312 312 
 					$output_time .= (strtotime($spotter_history['date'])*1000).',';
313 
-					if ($previousts != 0) $output_timediff .= (strtotime($spotter_history['date'])-$previousts).',';
313 
+					if ($previousts != 0) $output_timediff .= (strtotime($spotter_history['date']) - $previousts).',';
314 314 
 					$previousts = strtotime($spotter_history['date']);
315 315 
 					if ($k > 1 && (strtotime($spotter_history['date'])*1000 > $enddate)) $end = true;
316 316 
 				}
317 317 
 			}
318 318 
 			if (isset($output_time)) {
319 
-				$output_time  = substr($output_time, 0, -1);
319 
+				$output_time = substr($output_time, 0, -1);
320 320 
 				$output .= '"time": ['.$output_time.'],';
321 321 
 			}
322 322 
 			if (isset($output_timediff)) {
323 
-				$output_timediff  = substr($output_timediff, 0, -1);
323 
+				$output_timediff = substr($output_timediff, 0, -1);
324 324 
 				$output .= '"timediff": ['.$output_timediff.'],';
325 325 
 			}
326 326 
 			// FIXME : type when not aircraft ?
 
@@ -333,7 +333,7 @@  discard block
 
 block discarded – undo
333 333 
 			$output .= '"coordinates": [';
334 334
335 335 
 			if (isset($output_history)) {
336 
-				$output_history  = substr($output_history, 0, -1);
336 
+				$output_history = substr($output_history, 0, -1);
337 337 
 				$output .= $output_history;
338 338 
 			}
339 339 
 			$output .= ']';
 
@@ -344,7 +344,7 @@  discard block
 
 block discarded – undo
344 344 
 	$output  = substr($output, 0, -1);
345 345 
 	$output .= ']';
346 346 
 	$output .= ',"initial_sqltime": "'.$sqltime.'",';
347 
-	$output .= '"totaltime": "'.round(microtime(true)-$begintime,2).'",';
347 
+	$output .= '"totaltime": "'.round(microtime(true) - $begintime, 2).'",';
348 348 
 	if (isset($begindate)) $output .= '"archive_date": "'.$begindate.'",';
349 349 
 	$output .= '"fc": "'.$flightcnt.'"';
350 350 
 } else {
Please login to merge, or discard this patch.