Completed
Push — master ( 7b031c...3082e8 )
by Yannick
11:44
created
pilot-detailed.php 1 patch
Braces   +9 added lines, -3 removed lines patch added patch discarded remove patch
@@ -53,8 +53,12 @@  discard block
 block discarded – undo
53 53
 	{
54 54
 		$title = sprintf(_("Detailed View for %s"),$spotter_array[0]['pilot_name']);
55 55
 		$ident = $spotter_array[0]['ident'];
56
-		if (isset($spotter_array[0]['latitude'])) $latitude = $spotter_array[0]['latitude'];
57
-		if (isset($spotter_array[0]['longitude'])) $longitude = $spotter_array[0]['longitude'];
56
+		if (isset($spotter_array[0]['latitude'])) {
57
+			$latitude = $spotter_array[0]['latitude'];
58
+		}
59
+		if (isset($spotter_array[0]['longitude'])) {
60
+			$longitude = $spotter_array[0]['longitude'];
61
+		}
58 62
 		require_once('header.php');
59 63
 		/*
60 64
 		if (isset($globalArchive) && $globalArchive) {
@@ -107,7 +111,9 @@  discard block
 block discarded – undo
107 111
 		*/
108 112
 		print '<div class="info column">';
109 113
 		print '<h1>'.$spotter_array[0]['pilot_name'].'</h1>';
110
-		if (isset($spotter_array[0]['pilot_id']) && $spotter_array[0]['pilot_id'] != '') print '<div><span class="label">'._("Pilot ID").'</span>'.$spotter_array[0]['pilot_id'].'</div>';
114
+		if (isset($spotter_array[0]['pilot_id']) && $spotter_array[0]['pilot_id'] != '') {
115
+			print '<div><span class="label">'._("Pilot ID").'</span>'.$spotter_array[0]['pilot_id'].'</div>';
116
+		}
111 117
 		print '</div>';
112 118
 	
113 119
 		include('owner-sub-menu.php');
Please login to merge, or discard this patch.
pilot.php 1 patch
Braces   +11 added lines, -4 removed lines patch added patch discarded remove patch
@@ -31,7 +31,9 @@  discard block
 block discarded – undo
31 31
 			}
32 32
 			print '<a href="#'.$firstLetter.'">'.$firstLetter.'</a>';
33 33
 		}
34
-		if ($firstLetter != "'") $previous = $firstLetter;
34
+		if ($firstLetter != "'") {
35
+			$previous = $firstLetter;
36
+		}
35 37
 	}
36 38
 	print '</div>';
37 39
 	$previous = null;
@@ -46,10 +48,15 @@  discard block
 block discarded – undo
46 48
 				}
47 49
 				print '<a name="'.$firstLetter.'"></a><h4 class="alphabet-header">'.$firstLetter.'</h4><div class="alphabet">';
48 50
 			}
49
-			if ($firstLetter != "'") $previous = $firstLetter;
51
+			if ($firstLetter != "'") {
52
+				$previous = $firstLetter;
53
+			}
50 54
 			print '<div class="alphabet-item">';
51
-			if (isset($value['pilot_id']) && $value['pilot_id'] != '') print '<a href="'.$globalURL.'/pilot/'.$value['pilot_id'].'">'.$value['pilot_name'].' ('.$value['pilot_id'].')';
52
-			else print '<a href="'.$globalURL.'/pilot/'.$value['pilot_name'].'">'.$value['pilot_name'];
55
+			if (isset($value['pilot_id']) && $value['pilot_id'] != '') {
56
+				print '<a href="'.$globalURL.'/pilot/'.$value['pilot_id'].'">'.$value['pilot_name'].' ('.$value['pilot_id'].')';
57
+			} else {
58
+				print '<a href="'.$globalURL.'/pilot/'.$value['pilot_name'].'">'.$value['pilot_name'];
59
+			}
53 60
 			print '</a>';
54 61
 			print '</div>';
55 62
 		}
Please login to merge, or discard this patch.
owner-detailed.php 1 patch
Braces   +6 added lines, -2 removed lines patch added patch discarded remove patch
@@ -53,8 +53,12 @@
 block discarded – undo
53 53
 	{
54 54
 		$title = sprintf(_("Detailed View for %s"),$spotter_array[0]['aircraft_owner']);
55 55
 		//$ident = $spotter_array[0]['ident'];
56
-		if (isset($spotter_array[0]['latitude'])) $latitude = $spotter_array[0]['latitude'];
57
-		if (isset($spotter_array[0]['longitude'])) $longitude = $spotter_array[0]['longitude'];
56
+		if (isset($spotter_array[0]['latitude'])) {
57
+			$latitude = $spotter_array[0]['latitude'];
58
+		}
59
+		if (isset($spotter_array[0]['longitude'])) {
60
+			$longitude = $spotter_array[0]['longitude'];
61
+		}
58 62
 		require_once('header.php');
59 63
 		/*
60 64
 		if (isset($globalArchive) && $globalArchive) {
Please login to merge, or discard this patch.
owner.php 1 patch
Braces   +6 added lines, -2 removed lines patch added patch discarded remove patch
@@ -33,7 +33,9 @@  discard block
 block discarded – undo
33 33
 			}
34 34
 			print '<a href="#'.$firstLetter.'">'.$firstLetter.'</a>';
35 35
 		}
36
-		if ($firstLetter != "'" && $firstLetter != '"') $previous = $firstLetter;
36
+		if ($firstLetter != "'" && $firstLetter != '"') {
37
+			$previous = $firstLetter;
38
+		}
37 39
 	}
38 40
 	print '</div>';
39 41
 	$previous = null;
@@ -48,7 +50,9 @@  discard block
 block discarded – undo
48 50
 				}
49 51
 				print '<a name="'.$firstLetter.'"></a><h4 class="alphabet-header">'.$firstLetter.'</h4><div class="alphabet">';
50 52
 			}
51
-			if ($firstLetter != "'" && $firstLetter != '"') $previous = $firstLetter;
53
+			if ($firstLetter != "'" && $firstLetter != '"') {
54
+				$previous = $firstLetter;
55
+			}
52 56
 			print '<div class="alphabet-item">';
53 57
 			print '<a href="'.$globalURL.'/owner/'.$value['owner_name'].'">';
54 58
 			print $value['owner_name'];
Please login to merge, or discard this patch.
require/class.Common.php 1 patch
Braces   +60 added lines, -25 removed lines patch added patch discarded remove patch
@@ -27,8 +27,11 @@  discard block
 block discarded – undo
27 27
 		} else {
28 28
 			curl_setopt($ch, CURLOPT_USERAGENT, $useragent);
29 29
 		}
30
-		if ($timeout == '') curl_setopt($ch, CURLOPT_TIMEOUT, 10); 
31
-		else curl_setopt($ch, CURLOPT_TIMEOUT, $timeout); 
30
+		if ($timeout == '') {
31
+			curl_setopt($ch, CURLOPT_TIMEOUT, 10);
32
+		} else {
33
+			curl_setopt($ch, CURLOPT_TIMEOUT, $timeout);
34
+		}
32 35
 		curl_setopt($ch, CURLOPT_HEADERFUNCTION, array('Common',"curlResponseHeaderCallback"));
33 36
 		if ($type == 'post') {
34 37
 			curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
@@ -74,8 +77,9 @@  discard block
 block discarded – undo
74 77
 	private function curlResponseHeaderCallback($ch, $headerLine) {
75 78
 		//global $cookies;
76 79
 		$cookies = array();
77
-		if (preg_match('/^Set-Cookie:\s*([^;]*)/mi', $headerLine, $cookie) == 1)
78
-			$cookies[] = $cookie;
80
+		if (preg_match('/^Set-Cookie:\s*([^;]*)/mi', $headerLine, $cookie) == 1) {
81
+					$cookies[] = $cookie;
82
+		}
79 83
 		return strlen($headerLine); // Needed by curl
80 84
 	}
81 85
 
@@ -86,11 +90,15 @@  discard block
 block discarded – undo
86 90
 		curl_setopt($ch, CURLOPT_URL, $url);
87 91
 		curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
88 92
 		curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
89
-		if ($referer != '') curl_setopt($ch, CURLOPT_REFERER, $referer);
93
+		if ($referer != '') {
94
+			curl_setopt($ch, CURLOPT_REFERER, $referer);
95
+		}
90 96
 		curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 GTB5');
91 97
 		curl_setopt($ch, CURLOPT_FILE, $fp);
92 98
 		curl_exec($ch);
93
-		if (curl_errno($ch) && $globalDebug) echo 'Download error: '.curl_error($ch);
99
+		if (curl_errno($ch) && $globalDebug) {
100
+			echo 'Download error: '.curl_error($ch);
101
+		}
94 102
 		curl_close($ch);
95 103
 		fclose($fp);
96 104
 	}
@@ -101,10 +109,16 @@  discard block
 block discarded – undo
101 109
 	* @return Array array of the tables in HTML page
102 110
 	*/
103 111
 	public function table2array($data) {
104
-		if (!is_string($data)) return array();
105
-		if ($data == '') return array();
112
+		if (!is_string($data)) {
113
+			return array();
114
+		}
115
+		if ($data == '') {
116
+			return array();
117
+		}
106 118
 		$html = str_get_html($data);
107
-		if ($html === false) return array();
119
+		if ($html === false) {
120
+			return array();
121
+		}
108 122
 		$tabledata=array();
109 123
 		foreach($html->find('tr') as $element)
110 124
 		{
@@ -139,7 +153,9 @@  discard block
 block discarded – undo
139 153
 	*/
140 154
 	public function text2array($data) {
141 155
 		$html = str_get_html($data);
142
-		if ($html === false) return array();
156
+		if ($html === false) {
157
+			return array();
158
+		}
143 159
 		$tabledata=array();
144 160
 		foreach($html->find('p') as $element)
145 161
 		{
@@ -160,7 +176,9 @@  discard block
 block discarded – undo
160 176
 	* @return Float Distance in $unit
161 177
 	*/
162 178
 	public function distance($lat, $lon, $latc, $lonc, $unit = 'km') {
163
-		if ($lat == $latc && $lon == $lonc) return 0;
179
+		if ($lat == $latc && $lon == $lonc) {
180
+			return 0;
181
+		}
164 182
 		$dist = rad2deg(acos(sin(deg2rad(floatval($lat)))*sin(deg2rad(floatval($latc)))+ cos(deg2rad(floatval($lat)))*cos(deg2rad(floatval($latc)))*cos(deg2rad(floatval($lon)-floatval($lonc)))))*60*1.1515;
165 183
 		if ($unit == "km") {
166 184
 			return round($dist * 1.609344);
@@ -184,10 +202,16 @@  discard block
 block discarded – undo
184 202
 	public function withinThreshold ($timeDifference, $distance) {
185 203
 		$x = abs($timeDifference);
186 204
 		$d = abs($distance);
187
-		if ($x == 0 || $d == 0) return true;
205
+		if ($x == 0 || $d == 0) {
206
+			return true;
207
+		}
188 208
 		// may be due to Internet jitter; distance is realistic
189
-		if ($x < 0.7 && $d < 2000) return true;
190
-		else return $d/$x < 1500*0.27778; // 1500 km/h max
209
+		if ($x < 0.7 && $d < 2000) {
210
+			return true;
211
+		} else {
212
+			return $d/$x < 1500*0.27778;
213
+		}
214
+		// 1500 km/h max
191 215
 	}
192 216
 
193 217
 
@@ -247,7 +271,9 @@  discard block
 block discarded – undo
247 271
 	public function hex2str($hex) {
248 272
 		$str = '';
249 273
 		$hexln = strlen($hex);
250
-		for($i=0;$i<$hexln;$i+=2) $str .= chr(hexdec(substr($hex,$i,2)));
274
+		for($i=0;$i<$hexln;$i+=2) {
275
+			$str .= chr(hexdec(substr($hex,$i,2)));
276
+		}
251 277
 		return $str;
252 278
 	}
253 279
 	
@@ -275,8 +301,11 @@  discard block
 block discarded – undo
275 301
 		$b = $lat2 - $lat1;
276 302
 		$c = -($a*$lat1+$b*$lon1);
277 303
 		$d = $a*$lat3+$b*$lon3+$c;
278
-		if ($d > -$approx && $d < $approx) return true;
279
-		else return false;
304
+		if ($d > -$approx && $d < $approx) {
305
+			return true;
306
+		} else {
307
+			return false;
308
+		}
280 309
 	}
281 310
 	
282 311
 	public function array_merge_noappend() {
@@ -312,7 +341,9 @@  discard block
 block discarded – undo
312 341
 			return $result;
313 342
 		}
314 343
 		$handle = @opendir('./locale');
315
-		if ($handle === false) return $result;
344
+		if ($handle === false) {
345
+			return $result;
346
+		}
316 347
 		while (false !== ($file = readdir($handle))) {
317 348
 			$path = './locale'.'/'.$file.'/LC_MESSAGES/fam.mo';
318 349
 			if ($file != "." && $file != ".." && @file_exists($path)) {
@@ -379,8 +410,9 @@  discard block
 block discarded – undo
379 410
 		$error = false; 
380 411
 		if ($fp_out = gzopen($dest, $mode)) { 
381 412
 			if ($fp_in = fopen($source,'rb')) { 
382
-				while (!feof($fp_in)) 
383
-					gzwrite($fp_out, fread($fp_in, 1024 * 512)); 
413
+				while (!feof($fp_in)) {
414
+									gzwrite($fp_out, fread($fp_in, 1024 * 512));
415
+				}
384 416
 				fclose($fp_in); 
385 417
 			} else {
386 418
 				$error = true; 
@@ -389,14 +421,17 @@  discard block
 block discarded – undo
389 421
 		} else {
390 422
 			$error = true; 
391 423
 		}
392
-		if ($error)
393
-			return false; 
394
-		else
395
-			return $dest; 
424
+		if ($error) {
425
+					return false;
426
+		} else {
427
+					return $dest;
428
+		}
396 429
 	} 
397 430
 	
398 431
 	function remove_accents($string) {
399
-		if ( !preg_match('/[\x80-\xff]/', $string) ) return $string;
432
+		if ( !preg_match('/[\x80-\xff]/', $string) ) {
433
+			return $string;
434
+		}
400 435
 		$chars = array(
401 436
 		    // Decompositions for Latin-1 Supplement
402 437
 		    chr(195).chr(128) => 'A', chr(195).chr(129) => 'A',
Please login to merge, or discard this patch.
require/class.Stats.php 1 patch
Braces   +452 added lines, -156 removed lines patch added patch discarded remove patch
@@ -12,7 +12,9 @@  discard block
 block discarded – undo
12 12
 	
13 13
 	public function __construct($dbc = null) {
14 14
 		global $globalFilterName;
15
-		if (isset($globalFilterName)) $this->filter_name = $globalFilterName;
15
+		if (isset($globalFilterName)) {
16
+			$this->filter_name = $globalFilterName;
17
+		}
16 18
 		$Connection = new Connection($dbc);
17 19
 		$this->db = $Connection->db();
18 20
         }
@@ -77,7 +79,9 @@  discard block
 block discarded – undo
77 79
                 }
78 80
         }
79 81
 	public function getAllAirlineNames($filter_name = '') {
80
-		if ($filter_name == '') $filter_name = $this->filter_name;
82
+		if ($filter_name == '') {
83
+			$filter_name = $this->filter_name;
84
+		}
81 85
                 $query = "SELECT * FROM stats_airline WHERE filter_name = :filter_name ORDER BY airline_name ASC";
82 86
                  try {
83 87
                         $sth = $this->db->prepare($query);
@@ -89,7 +93,9 @@  discard block
 block discarded – undo
89 93
                 return $all;
90 94
         }
91 95
 	public function getAllAircraftTypes($stats_airline = '',$filter_name = '') {
92
-		if ($filter_name == '') $filter_name = $this->filter_name;
96
+		if ($filter_name == '') {
97
+			$filter_name = $this->filter_name;
98
+		}
93 99
                 $query = "SELECT * FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_manufacturer ASC";
94 100
                  try {
95 101
                         $sth = $this->db->prepare($query);
@@ -101,7 +107,9 @@  discard block
 block discarded – undo
101 107
                 return $all;
102 108
         }
103 109
 	public function getAllManufacturers($stats_airline = '',$filter_name = '') {
104
-		if ($filter_name == '') $filter_name = $this->filter_name;
110
+		if ($filter_name == '') {
111
+			$filter_name = $this->filter_name;
112
+		}
105 113
                 $query = "SELECT DISTINCT(aircraft_manufacturer) FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name AND aircraft_manufacturer <> '' ORDER BY aircraft_manufacturer ASC";
106 114
                  try {
107 115
                         $sth = $this->db->prepare($query);
@@ -113,7 +121,9 @@  discard block
 block discarded – undo
113 121
                 return $all;
114 122
         }
115 123
 	public function getAllAirportNames($stats_airline = '',$filter_name = '') {
116
-		if ($filter_name == '') $filter_name = $this->filter_name;
124
+		if ($filter_name == '') {
125
+			$filter_name = $this->filter_name;
126
+		}
117 127
                 $query = "SELECT airport_icao, airport_name,airport_city,airport_country FROM stats_airport WHERE stats_airline = :stats_airline AND filter_name = :filter_name AND stats_type = 'daily' GROUP BY airport_icao,airport_name,airport_city,airport_country ORDER BY airport_city ASC";
118 128
                  try {
119 129
                         $sth = $this->db->prepare($query);
@@ -126,7 +136,9 @@  discard block
 block discarded – undo
126 136
         }
127 137
 
128 138
 	public function getAllOwnerNames($stats_airline = '',$filter_name = '') {
129
-		if ($filter_name == '') $filter_name = $this->filter_name;
139
+		if ($filter_name == '') {
140
+			$filter_name = $this->filter_name;
141
+		}
130 142
                 $query = "SELECT owner_name FROM stats_owner WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY owner_name ASC";
131 143
                  try {
132 144
                         $sth = $this->db->prepare($query);
@@ -139,7 +151,9 @@  discard block
 block discarded – undo
139 151
         }
140 152
 
141 153
 	public function getAllPilotNames($stats_airline = '',$filter_name = '') {
142
-		if ($filter_name == '') $filter_name = $this->filter_name;
154
+		if ($filter_name == '') {
155
+			$filter_name = $this->filter_name;
156
+		}
143 157
                 $query = "SELECT pilot_id,pilot_name FROM stats_pilot WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY pilot_name ASC";
144 158
                  try {
145 159
                         $sth = $this->db->prepare($query);
@@ -154,10 +168,15 @@  discard block
 block discarded – undo
154 168
 
155 169
 	public function countAllAircraftTypes($limit = true, $stats_airline = '', $filter_name = '',$year = '', $month = '') {
156 170
 		global $globalStatsFilters;
157
-		if ($filter_name == '') $filter_name = $this->filter_name;
171
+		if ($filter_name == '') {
172
+			$filter_name = $this->filter_name;
173
+		}
158 174
 		if ($year == '' && $month == '') {
159
-			if ($limit) $query = "SELECT aircraft_icao, cnt AS aircraft_icao_count, aircraft_name, aircraft_manufacturer FROM stats_aircraft WHERE aircraft_name <> '' AND aircraft_icao <> '' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_icao_count DESC LIMIT 10 OFFSET 0";
160
-			else $query = "SELECT aircraft_icao, cnt AS aircraft_icao_count, aircraft_name, aircraft_manufacturer FROM stats_aircraft WHERE aircraft_name <> '' AND aircraft_icao <> '' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_icao_count DESC";
175
+			if ($limit) {
176
+				$query = "SELECT aircraft_icao, cnt AS aircraft_icao_count, aircraft_name, aircraft_manufacturer FROM stats_aircraft WHERE aircraft_name <> '' AND aircraft_icao <> '' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_icao_count DESC LIMIT 10 OFFSET 0";
177
+			} else {
178
+				$query = "SELECT aircraft_icao, cnt AS aircraft_icao_count, aircraft_name, aircraft_manufacturer FROM stats_aircraft WHERE aircraft_name <> '' AND aircraft_icao <> '' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_icao_count DESC";
179
+			}
161 180
 			try {
162 181
 				$sth = $this->db->prepare($query);
163 182
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -165,7 +184,9 @@  discard block
 block discarded – undo
165 184
 				echo "error : ".$e->getMessage();
166 185
 			}
167 186
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
168
-		} else $all = array();
187
+		} else {
188
+			$all = array();
189
+		}
169 190
                 if (empty($all)) {
170 191
             	    $filters = array('airlines' => array($stats_airline));
171 192
             	    if ($filter_name != '') {
@@ -178,10 +199,15 @@  discard block
 block discarded – undo
178 199
 	}
179 200
 	public function countAllAirlineCountries($limit = true,$filter_name = '',$year = '',$month = '') {
180 201
 		global $globalStatsFilters;
181
-		if ($filter_name == '') $filter_name = $this->filter_name;
202
+		if ($filter_name == '') {
203
+			$filter_name = $this->filter_name;
204
+		}
182 205
 		if ($year == '' && $month == '') {
183
-			if ($limit) $query = "SELECT airlines.country AS airline_country, SUM(stats_airline.cnt) as airline_country_count FROM stats_airline,airlines WHERE stats_airline.airline_icao=airlines.icao AND filter_name = :filter_name GROUP BY airline_country ORDER BY airline_country_count DESC LIMIT 10 OFFSET 0";
184
-			else $query = "SELECT airlines.country AS airline_country, SUM(stats_airline.cnt) as airline_country_count FROM stats_airline,airlines WHERE stats_airline.airline_icao=airlines.icao AND filter_name = :filter_name GROUP BY airline_country ORDER BY airline_country_count DESC";
206
+			if ($limit) {
207
+				$query = "SELECT airlines.country AS airline_country, SUM(stats_airline.cnt) as airline_country_count FROM stats_airline,airlines WHERE stats_airline.airline_icao=airlines.icao AND filter_name = :filter_name GROUP BY airline_country ORDER BY airline_country_count DESC LIMIT 10 OFFSET 0";
208
+			} else {
209
+				$query = "SELECT airlines.country AS airline_country, SUM(stats_airline.cnt) as airline_country_count FROM stats_airline,airlines WHERE stats_airline.airline_icao=airlines.icao AND filter_name = :filter_name GROUP BY airline_country ORDER BY airline_country_count DESC";
210
+			}
185 211
 			try {
186 212
 				$sth = $this->db->prepare($query);
187 213
 				$sth->execute(array(':filter_name' => $filter_name));
@@ -189,7 +215,9 @@  discard block
 block discarded – undo
189 215
 				echo "error : ".$e->getMessage();
190 216
 			}
191 217
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
192
-		} else $all = array();
218
+		} else {
219
+			$all = array();
220
+		}
193 221
                 if (empty($all)) {
194 222
             		$Spotter = new Spotter($this->db);
195 223
             		$filters = array();
@@ -202,10 +230,15 @@  discard block
 block discarded – undo
202 230
 	}
203 231
 	public function countAllAircraftManufacturers($limit = true,$stats_airline = '', $filter_name = '',$year = '', $month = '') {
204 232
 		global $globalStatsFilters;
205
-		if ($filter_name == '') $filter_name = $this->filter_name;
233
+		if ($filter_name == '') {
234
+			$filter_name = $this->filter_name;
235
+		}
206 236
 		if ($year == '' && $month == '') {
207
-			if ($limit) $query = "SELECT aircraft_manufacturer, SUM(stats_aircraft.cnt) as aircraft_manufacturer_count FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY aircraft_manufacturer ORDER BY aircraft_manufacturer_count DESC LIMIT 10 OFFSET 0";
208
-			else $query = "SELECT aircraft_manufacturer, SUM(stats_aircraft.cnt) as aircraft_manufacturer_count FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY aircraft_manufacturer ORDER BY aircraft_manufacturer_count DESC";
237
+			if ($limit) {
238
+				$query = "SELECT aircraft_manufacturer, SUM(stats_aircraft.cnt) as aircraft_manufacturer_count FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY aircraft_manufacturer ORDER BY aircraft_manufacturer_count DESC LIMIT 10 OFFSET 0";
239
+			} else {
240
+				$query = "SELECT aircraft_manufacturer, SUM(stats_aircraft.cnt) as aircraft_manufacturer_count FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY aircraft_manufacturer ORDER BY aircraft_manufacturer_count DESC";
241
+			}
209 242
 			try {
210 243
 				$sth = $this->db->prepare($query);
211 244
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -213,7 +246,9 @@  discard block
 block discarded – undo
213 246
 				echo "error : ".$e->getMessage();
214 247
 			}
215 248
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
216
-		} else $all = array();
249
+		} else {
250
+			$all = array();
251
+		}
217 252
 		if (empty($all)) {
218 253
 			$filters = array('airlines' => array($stats_airline));
219 254
 			if ($filter_name != '') {
@@ -227,10 +262,15 @@  discard block
 block discarded – undo
227 262
 
228 263
 	public function countAllArrivalCountries($limit = true, $stats_airline = '', $filter_name = '',$year = '', $month = '') {
229 264
 		global $globalStatsFilters;
230
-		if ($filter_name == '') $filter_name = $this->filter_name;
265
+		if ($filter_name == '') {
266
+			$filter_name = $this->filter_name;
267
+		}
231 268
 		if ($year == '' && $month == '') {
232
-			if ($limit) $query = "SELECT airport_country AS airport_arrival_country, SUM(arrival) as airport_arrival_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_arrival_country ORDER BY airport_arrival_country_count DESC LIMIT 10 OFFSET 0";
233
-			else $query = "SELECT airport_country AS airport_arrival_country, SUM(arrival) as airport_arrival_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_arrival_country ORDER BY airport_arrival_country_count DESC";
269
+			if ($limit) {
270
+				$query = "SELECT airport_country AS airport_arrival_country, SUM(arrival) as airport_arrival_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_arrival_country ORDER BY airport_arrival_country_count DESC LIMIT 10 OFFSET 0";
271
+			} else {
272
+				$query = "SELECT airport_country AS airport_arrival_country, SUM(arrival) as airport_arrival_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_arrival_country ORDER BY airport_arrival_country_count DESC";
273
+			}
234 274
 			try {
235 275
 				$sth = $this->db->prepare($query);
236 276
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -238,7 +278,9 @@  discard block
 block discarded – undo
238 278
 				echo "error : ".$e->getMessage();
239 279
 			}
240 280
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
241
-		} else $all = array();
281
+		} else {
282
+			$all = array();
283
+		}
242 284
                 if (empty($all)) {
243 285
 			$filters = array('airlines' => array($stats_airline));
244 286
 			if ($filter_name != '') {
@@ -251,9 +293,14 @@  discard block
 block discarded – undo
251 293
 	}
252 294
 	public function countAllDepartureCountries($limit = true, $stats_airline = '', $filter_name = '', $year = '', $month = '') {
253 295
 		global $globalStatsFilters;
254
-		if ($filter_name == '') $filter_name = $this->filter_name;
255
-		if ($limit) $query = "SELECT airport_country AS airport_departure_country, SUM(departure) as airport_departure_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_departure_country ORDER BY airport_departure_country_count DESC LIMIT 10 OFFSET 0";
256
-		else $query = "SELECT airport_country AS airport_departure_country, SUM(departure) as airport_departure_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_departure_country ORDER BY airport_departure_country_count DESC";
296
+		if ($filter_name == '') {
297
+			$filter_name = $this->filter_name;
298
+		}
299
+		if ($limit) {
300
+			$query = "SELECT airport_country AS airport_departure_country, SUM(departure) as airport_departure_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_departure_country ORDER BY airport_departure_country_count DESC LIMIT 10 OFFSET 0";
301
+		} else {
302
+			$query = "SELECT airport_country AS airport_departure_country, SUM(departure) as airport_departure_country_count FROM stats_airport WHERE stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name GROUP BY airport_departure_country ORDER BY airport_departure_country_count DESC";
303
+		}
257 304
                  try {
258 305
                         $sth = $this->db->prepare($query);
259 306
                         $sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -274,10 +321,15 @@  discard block
 block discarded – undo
274 321
 
275 322
 	public function countAllAirlines($limit = true,$filter_name = '',$year = '',$month = '') {
276 323
 		global $globalStatsFilters;
277
-		if ($filter_name == '') $filter_name = $this->filter_name;
324
+		if ($filter_name == '') {
325
+			$filter_name = $this->filter_name;
326
+		}
278 327
 		if ($year == '' && $month == '') {
279
-			if ($limit) $query = "SELECT DISTINCT stats_airline.airline_icao, stats_airline.cnt AS airline_count, stats_airline.airline_name, airlines.country as airline_country FROM stats_airline, airlines WHERE stats_airline.airline_name <> '' AND stats_airline.airline_icao <> '' AND airlines.icao = stats_airline.airline_icao AND filter_name = :filter_name ORDER BY airline_count DESC LIMIT 10 OFFSET 0";
280
-			else $query = "SELECT DISTINCT stats_airline.airline_icao, stats_airline.cnt AS airline_count, stats_airline.airline_name, airlines.country as airline_country FROM stats_airline, airlines WHERE stats_airline.airline_name <> '' AND stats_airline.airline_icao <> '' AND airlines.icao = stats_airline.airline_icao AND filter_name = :filter_name ORDER BY airline_count DESC";
328
+			if ($limit) {
329
+				$query = "SELECT DISTINCT stats_airline.airline_icao, stats_airline.cnt AS airline_count, stats_airline.airline_name, airlines.country as airline_country FROM stats_airline, airlines WHERE stats_airline.airline_name <> '' AND stats_airline.airline_icao <> '' AND airlines.icao = stats_airline.airline_icao AND filter_name = :filter_name ORDER BY airline_count DESC LIMIT 10 OFFSET 0";
330
+			} else {
331
+				$query = "SELECT DISTINCT stats_airline.airline_icao, stats_airline.cnt AS airline_count, stats_airline.airline_name, airlines.country as airline_country FROM stats_airline, airlines WHERE stats_airline.airline_name <> '' AND stats_airline.airline_icao <> '' AND airlines.icao = stats_airline.airline_icao AND filter_name = :filter_name ORDER BY airline_count DESC";
332
+			}
281 333
 			try {
282 334
 				$sth = $this->db->prepare($query);
283 335
 				$sth->execute(array(':filter_name' => $filter_name));
@@ -285,7 +337,9 @@  discard block
 block discarded – undo
285 337
 				echo "error : ".$e->getMessage();
286 338
 			}
287 339
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
288
-		} else $all = array();
340
+		} else {
341
+			$all = array();
342
+		}
289 343
                 if (empty($all)) {
290 344
 	                $Spotter = new Spotter($this->db);
291 345
             		$filters = array();
@@ -299,10 +353,15 @@  discard block
 block discarded – undo
299 353
 	}
300 354
 	public function countAllAircraftRegistrations($limit = true,$stats_airline = '',$filter_name = '',$year = '',$month = '') {
301 355
 		global $globalStatsFilters;
302
-		if ($filter_name == '') $filter_name = $this->filter_name;
356
+		if ($filter_name == '') {
357
+			$filter_name = $this->filter_name;
358
+		}
303 359
 		if ($year == '' && $month == '') {
304
-			if ($limit) $query = "SELECT s.aircraft_icao, s.cnt AS aircraft_registration_count, a.type AS aircraft_name, s.registration FROM stats_registration s, aircraft a WHERE s.registration <> '' AND a.icao = s.aircraft_icao AND s.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_registration_count DESC LIMIT 10 OFFSET 0";
305
-			else $query = "SELECT s.aircraft_icao, s.cnt AS aircraft_registration_count, a.type AS aircraft_name FROM stats_registration s, aircraft a WHERE s.registration <> '' AND a.icao = s.aircraft_icao AND s.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_registration_count DESC";
360
+			if ($limit) {
361
+				$query = "SELECT s.aircraft_icao, s.cnt AS aircraft_registration_count, a.type AS aircraft_name, s.registration FROM stats_registration s, aircraft a WHERE s.registration <> '' AND a.icao = s.aircraft_icao AND s.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_registration_count DESC LIMIT 10 OFFSET 0";
362
+			} else {
363
+				$query = "SELECT s.aircraft_icao, s.cnt AS aircraft_registration_count, a.type AS aircraft_name FROM stats_registration s, aircraft a WHERE s.registration <> '' AND a.icao = s.aircraft_icao AND s.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY aircraft_registration_count DESC";
364
+			}
306 365
 			try {
307 366
 				$sth = $this->db->prepare($query);
308 367
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -310,7 +369,9 @@  discard block
 block discarded – undo
310 369
 				echo "error : ".$e->getMessage();
311 370
 			}
312 371
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
313
-		} else $all = array();
372
+		} else {
373
+			$all = array();
374
+		}
314 375
                 if (empty($all)) {
315 376
 			$filters = array('airlines' => array($stats_airline));
316 377
 			if ($filter_name != '') {
@@ -323,10 +384,15 @@  discard block
 block discarded – undo
323 384
 	}
324 385
 	public function countAllCallsigns($limit = true,$stats_airline = '',$filter_name = '',$year = '',$month = '') {
325 386
 		global $globalStatsFilters;
326
-		if ($filter_name == '') $filter_name = $this->filter_name;
387
+		if ($filter_name == '') {
388
+			$filter_name = $this->filter_name;
389
+		}
327 390
 		if ($year == '' && $month == '') {
328
-			if ($limit) $query = "SELECT s.callsign_icao, s.cnt AS callsign_icao_count, a.name AS airline_name, a.icao as airline_icao FROM stats_callsign s, airlines a WHERE s.callsign_icao <> '' AND a.icao = s.airline_icao AND s.airline_icao = :stats_airline AND filter_name = :filter_name ORDER BY callsign_icao_count DESC LIMIT 10 OFFSET 0";
329
-			else $query = "SELECT s.callsign_icao, s.cnt AS callsign_icao_count, a.name AS airline_name, a.icao as airline_icao FROM stats_callsign s, airlines a WHERE s.callsign_icao <> '' AND a.icao = s.airline_icao AND s.airline_icao = :stats_airline AND filter_name = :filter_name ORDER BY callsign_icao_count DESC";
391
+			if ($limit) {
392
+				$query = "SELECT s.callsign_icao, s.cnt AS callsign_icao_count, a.name AS airline_name, a.icao as airline_icao FROM stats_callsign s, airlines a WHERE s.callsign_icao <> '' AND a.icao = s.airline_icao AND s.airline_icao = :stats_airline AND filter_name = :filter_name ORDER BY callsign_icao_count DESC LIMIT 10 OFFSET 0";
393
+			} else {
394
+				$query = "SELECT s.callsign_icao, s.cnt AS callsign_icao_count, a.name AS airline_name, a.icao as airline_icao FROM stats_callsign s, airlines a WHERE s.callsign_icao <> '' AND a.icao = s.airline_icao AND s.airline_icao = :stats_airline AND filter_name = :filter_name ORDER BY callsign_icao_count DESC";
395
+			}
330 396
 			 try {
331 397
 				$sth = $this->db->prepare($query);
332 398
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -334,7 +400,9 @@  discard block
 block discarded – undo
334 400
 				echo "error : ".$e->getMessage();
335 401
 			}
336 402
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
337
-		} else $all = array();
403
+		} else {
404
+			$all = array();
405
+		}
338 406
 		if (empty($all)) {
339 407
 			$filters = array('airlines' => array($stats_airline));
340 408
 			if ($filter_name != '') {
@@ -347,11 +415,16 @@  discard block
 block discarded – undo
347 415
 	}
348 416
 	public function countAllFlightOverCountries($limit = true, $stats_airline = '',$filter_name = '',$year = '',$month = '') {
349 417
 		$Connection = new Connection();
350
-		if ($filter_name == '') $filter_name = $this->filter_name;
418
+		if ($filter_name == '') {
419
+			$filter_name = $this->filter_name;
420
+		}
351 421
 		if ($Connection->tableExists('countries')) {
352 422
 			if ($year == '' && $month == '') {
353
-				if ($limit) $query = "SELECT countries.iso3 as flight_country_iso3, countries.iso2 as flight_country_iso2, countries.name as flight_country, cnt as flight_count, lat as flight_country_latitude, lon as flight_country_longitude FROM stats_country, countries WHERE stats_country.iso2 = countries.iso2 AND stats_country.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY flight_count DESC LIMIT 20 OFFSET 0";
354
-				else $query = "SELECT countries.iso3 as flight_country_iso3, countries.iso2 as flight_country_iso2, countries.name as flight_country, cnt as flight_count, lat as flight_country_latitude, lon as flight_country_longitude FROM stats_country, countries WHERE stats_country.iso2 = countries.iso2 AND stats_country.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY flight_count DESC";
423
+				if ($limit) {
424
+					$query = "SELECT countries.iso3 as flight_country_iso3, countries.iso2 as flight_country_iso2, countries.name as flight_country, cnt as flight_count, lat as flight_country_latitude, lon as flight_country_longitude FROM stats_country, countries WHERE stats_country.iso2 = countries.iso2 AND stats_country.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY flight_count DESC LIMIT 20 OFFSET 0";
425
+				} else {
426
+					$query = "SELECT countries.iso3 as flight_country_iso3, countries.iso2 as flight_country_iso2, countries.name as flight_country, cnt as flight_count, lat as flight_country_latitude, lon as flight_country_longitude FROM stats_country, countries WHERE stats_country.iso2 = countries.iso2 AND stats_country.stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY flight_count DESC";
427
+				}
355 428
 				 try {
356 429
 					$sth = $this->db->prepare($query);
357 430
 					$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -366,17 +439,24 @@  discard block
 block discarded – undo
366 439
                 }
367 440
                 */
368 441
 				return $all;
369
-			} else return array();
442
+			} else {
443
+				return array();
444
+			}
370 445
 		} else {
371 446
 			return array();
372 447
 		}
373 448
 	}
374 449
 	public function countAllPilots($limit = true,$stats_airline = '',$filter_name = '', $year = '',$month = '') {
375 450
 		global $globalStatsFilters;
376
-		if ($filter_name == '') $filter_name = $this->filter_name;
451
+		if ($filter_name == '') {
452
+			$filter_name = $this->filter_name;
453
+		}
377 454
 		if ($year == '' && $month == '') {
378
-			if ($limit) $query = "SELECT pilot_id, cnt AS pilot_count, pilot_name, format_source FROM stats_pilot WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY pilot_count DESC LIMIT 10 OFFSET 0";
379
-			else $query = "SELECT pilot_id, cnt AS pilot_count, pilot_name, format_source FROM stats_pilot WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY pilot_count DESC";
455
+			if ($limit) {
456
+				$query = "SELECT pilot_id, cnt AS pilot_count, pilot_name, format_source FROM stats_pilot WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY pilot_count DESC LIMIT 10 OFFSET 0";
457
+			} else {
458
+				$query = "SELECT pilot_id, cnt AS pilot_count, pilot_name, format_source FROM stats_pilot WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY pilot_count DESC";
459
+			}
380 460
 			try {
381 461
 				$sth = $this->db->prepare($query);
382 462
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -384,7 +464,9 @@  discard block
 block discarded – undo
384 464
 				echo "error : ".$e->getMessage();
385 465
 			}
386 466
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
387
-		} else $all = array();
467
+		} else {
468
+			$all = array();
469
+		}
388 470
 		if (empty($all)) {
389 471
 			$filters = array('airlines' => array($stats_airline));
390 472
 			if ($filter_name != '') {
@@ -398,10 +480,15 @@  discard block
 block discarded – undo
398 480
 
399 481
 	public function countAllOwners($limit = true,$stats_airline = '', $filter_name = '',$year = '',$month = '') {
400 482
 		global $globalStatsFilters;
401
-		if ($filter_name == '') $filter_name = $this->filter_name;
483
+		if ($filter_name == '') {
484
+			$filter_name = $this->filter_name;
485
+		}
402 486
 		if ($year == '' && $month == '') {
403
-			if ($limit) $query = "SELECT owner_name, cnt AS owner_count FROM stats_owner WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY owner_count DESC LIMIT 10 OFFSET 0";
404
-			else $query = "SELECT owner_name, cnt AS owner_count FROM stats_owner WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY owner_count DESC";
487
+			if ($limit) {
488
+				$query = "SELECT owner_name, cnt AS owner_count FROM stats_owner WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY owner_count DESC LIMIT 10 OFFSET 0";
489
+			} else {
490
+				$query = "SELECT owner_name, cnt AS owner_count FROM stats_owner WHERE stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY owner_count DESC";
491
+			}
405 492
 			try {
406 493
 				$sth = $this->db->prepare($query);
407 494
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -409,7 +496,9 @@  discard block
 block discarded – undo
409 496
 				echo "error : ".$e->getMessage();
410 497
 			}
411 498
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
412
-		} else $all = array();
499
+		} else {
500
+			$all = array();
501
+		}
413 502
                 if (empty($all)) {
414 503
 			$filters = array('airlines' => array($stats_airline));
415 504
 			if ($filter_name != '') {
@@ -422,10 +511,15 @@  discard block
 block discarded – undo
422 511
 	}
423 512
 	public function countAllDepartureAirports($limit = true,$stats_airline = '',$filter_name = '',$year = '',$month = '') {
424 513
 		global $globalStatsFilters;
425
-		if ($filter_name == '') $filter_name = $this->filter_name;
514
+		if ($filter_name == '') {
515
+			$filter_name = $this->filter_name;
516
+		}
426 517
 		if ($year == '' && $month == '') {
427
-			if ($limit) $query = "SELECT DISTINCT airport_icao AS airport_departure_icao,airport_city AS airport_departure_city,airport_country AS airport_departure_country,departure AS airport_departure_icao_count FROM stats_airport WHERE departure > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_departure_icao_count DESC LIMIT 10 OFFSET 0";
428
-			else $query = "SELECT DISTINCT airport_icao AS airport_departure_icao,airport_city AS airport_departure_city,airport_country AS airport_departure_country,departure AS airport_departure_icao_count FROM stats_airport WHERE departure > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_departure_icao_count DESC";
518
+			if ($limit) {
519
+				$query = "SELECT DISTINCT airport_icao AS airport_departure_icao,airport_city AS airport_departure_city,airport_country AS airport_departure_country,departure AS airport_departure_icao_count FROM stats_airport WHERE departure > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_departure_icao_count DESC LIMIT 10 OFFSET 0";
520
+			} else {
521
+				$query = "SELECT DISTINCT airport_icao AS airport_departure_icao,airport_city AS airport_departure_city,airport_country AS airport_departure_country,departure AS airport_departure_icao_count FROM stats_airport WHERE departure > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_departure_icao_count DESC";
522
+			}
429 523
 			try {
430 524
 				$sth = $this->db->prepare($query);
431 525
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -433,7 +527,9 @@  discard block
 block discarded – undo
433 527
 				echo "error : ".$e->getMessage();
434 528
 			}
435 529
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
436
-		} else $all = array();
530
+		} else {
531
+			$all = array();
532
+		}
437 533
                 if (empty($all)) {
438 534
 			$filters = array('airlines' => array($stats_airline));
439 535
             		if ($filter_name != '') {
@@ -452,7 +548,9 @@  discard block
 block discarded – undo
452 548
         			$icao = $value['airport_departure_icao'];
453 549
         			if (isset($all[$icao])) {
454 550
         				$all[$icao]['airport_departure_icao_count'] = $all[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
455
-        			} else $all[$icao] = $value;
551
+        			} else {
552
+        				$all[$icao] = $value;
553
+        			}
456 554
         		}
457 555
         		$count = array();
458 556
         		foreach ($all as $key => $row) {
@@ -464,10 +562,15 @@  discard block
 block discarded – undo
464 562
 	}
465 563
 	public function countAllArrivalAirports($limit = true,$stats_airline = '',$filter_name = '',$year = '',$month = '') {
466 564
 		global $globalStatsFilters;
467
-		if ($filter_name == '') $filter_name = $this->filter_name;
565
+		if ($filter_name == '') {
566
+			$filter_name = $this->filter_name;
567
+		}
468 568
 		if ($year == '' && $month == '') {
469
-			if ($limit) $query = "SELECT DISTINCT airport_icao AS airport_arrival_icao,airport_city AS airport_arrival_city,airport_country AS airport_arrival_country,arrival AS airport_arrival_icao_count FROM stats_airport WHERE arrival > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_arrival_icao_count DESC LIMIT 10 OFFSET 0";
470
-			else $query = "SELECT DISTINCT airport_icao AS airport_arrival_icao,airport_city AS airport_arrival_city,airport_country AS airport_arrival_country,arrival AS airport_arrival_icao_count FROM stats_airport WHERE arrival > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_arrival_icao_count DESC";
569
+			if ($limit) {
570
+				$query = "SELECT DISTINCT airport_icao AS airport_arrival_icao,airport_city AS airport_arrival_city,airport_country AS airport_arrival_country,arrival AS airport_arrival_icao_count FROM stats_airport WHERE arrival > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_arrival_icao_count DESC LIMIT 10 OFFSET 0";
571
+			} else {
572
+				$query = "SELECT DISTINCT airport_icao AS airport_arrival_icao,airport_city AS airport_arrival_city,airport_country AS airport_arrival_country,arrival AS airport_arrival_icao_count FROM stats_airport WHERE arrival > 0 AND stats_type = 'yearly' AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY airport_arrival_icao_count DESC";
573
+			}
471 574
 			try {
472 575
 				$sth = $this->db->prepare($query);
473 576
 				$sth->execute(array(':stats_airline' => $stats_airline,':filter_name' => $filter_name));
@@ -475,7 +578,9 @@  discard block
 block discarded – undo
475 578
 				echo "error : ".$e->getMessage();
476 579
 			}
477 580
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
478
-		} else $all = array();
581
+		} else {
582
+			$all = array();
583
+		}
479 584
 		if (empty($all)) {
480 585
 			$filters = array('airlines' => array($stats_airline));
481 586
 			if ($filter_name != '') {
@@ -494,7 +599,9 @@  discard block
 block discarded – undo
494 599
         			$icao = $value['airport_arrival_icao'];
495 600
         			if (isset($all[$icao])) {
496 601
         				$all[$icao]['airport_arrival_icao_count'] = $all[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
497
-        			} else $all[$icao] = $value;
602
+        			} else {
603
+        				$all[$icao] = $value;
604
+        			}
498 605
         		}
499 606
         		$count = array();
500 607
         		foreach ($all as $key => $row) {
@@ -507,13 +614,21 @@  discard block
 block discarded – undo
507 614
 	}
508 615
 	public function countAllMonthsLastYear($limit = true,$stats_airline = '',$filter_name = '') {
509 616
 		global $globalDBdriver, $globalStatsFilters;
510
-		if ($filter_name == '') $filter_name = $this->filter_name;
617
+		if ($filter_name == '') {
618
+			$filter_name = $this->filter_name;
619
+		}
511 620
 		if ($globalDBdriver == 'mysql') {
512
-			if ($limit) $query = "SELECT MONTH(stats_date) as month_name, YEAR(stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 12 MONTH) AND stats_airline = :stats_airline AND filter_name = :filter_name";
513
-			else $query = "SELECT MONTH(stats_date) as month_name, YEAR(stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
621
+			if ($limit) {
622
+				$query = "SELECT MONTH(stats_date) as month_name, YEAR(stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 12 MONTH) AND stats_airline = :stats_airline AND filter_name = :filter_name";
623
+			} else {
624
+				$query = "SELECT MONTH(stats_date) as month_name, YEAR(stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
625
+			}
514 626
 		} else {
515
-			if ($limit) $query = "SELECT EXTRACT(MONTH FROM stats_date) as month_name, EXTRACT(YEAR FROM stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_date >= CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '12 MONTHS' AND stats_airline = :stats_airline AND filter_name = :filter_name";
516
-			else $query = "SELECT EXTRACT(MONTH FROM stats_date) as month_name, EXTRACT(YEAR FROM stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
627
+			if ($limit) {
628
+				$query = "SELECT EXTRACT(MONTH FROM stats_date) as month_name, EXTRACT(YEAR FROM stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_date >= CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '12 MONTHS' AND stats_airline = :stats_airline AND filter_name = :filter_name";
629
+			} else {
630
+				$query = "SELECT EXTRACT(MONTH FROM stats_date) as month_name, EXTRACT(YEAR FROM stats_date) as year_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
631
+			}
517 632
 		}
518 633
 		$query_data = array(':stats_airline' => $stats_airline,':filter_name' => $filter_name);
519 634
                  try {
@@ -537,7 +652,9 @@  discard block
 block discarded – undo
537 652
 	
538 653
 	public function countAllDatesLastMonth($stats_airline = '',$filter_name = '') {
539 654
 		global $globalStatsFilters;
540
-		if ($filter_name == '') $filter_name = $this->filter_name;
655
+		if ($filter_name == '') {
656
+			$filter_name = $this->filter_name;
657
+		}
541 658
 		$query = "SELECT flight_date as date_name, cnt as date_count FROM stats_flight WHERE stats_type = 'month' AND stats_airline = :stats_airline AND filter_name = :filter_name";
542 659
 		$query_data = array(':stats_airline' => $stats_airline,':filter_name' => $filter_name);
543 660
                  try {
@@ -559,7 +676,9 @@  discard block
 block discarded – undo
559 676
 	}
560 677
 	public function countAllDatesLast7Days($stats_airline = '',$filter_name = '') {
561 678
 		global $globalDBdriver, $globalStatsFilters;
562
-		if ($filter_name == '') $filter_name = $this->filter_name;
679
+		if ($filter_name == '') {
680
+			$filter_name = $this->filter_name;
681
+		}
563 682
 		if ($globalDBdriver == 'mysql') {
564 683
 			$query = "SELECT flight_date as date_name, cnt as date_count FROM stats_flight WHERE stats_type = 'month' AND flight_date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 7 DAY) AND stats_airline = :stats_airline AND filter_name = :filter_name";
565 684
 		} else {
@@ -585,7 +704,9 @@  discard block
 block discarded – undo
585 704
 	}
586 705
 	public function countAllDates($stats_airline = '',$filter_name = '') {
587 706
 		global $globalStatsFilters;
588
-		if ($filter_name == '') $filter_name = $this->filter_name;
707
+		if ($filter_name == '') {
708
+			$filter_name = $this->filter_name;
709
+		}
589 710
 		$query = "SELECT flight_date as date_name, cnt as date_count FROM stats_flight WHERE stats_type = 'date' AND stats_airline = :stats_airline AND filter_name = :filter_name";
590 711
 		$query_data = array(':stats_airline' => $stats_airline,':filter_name' => $filter_name);
591 712
                  try {
@@ -607,7 +728,9 @@  discard block
 block discarded – undo
607 728
 	}
608 729
 	public function countAllDatesByAirlines($filter_name = '') {
609 730
 		global $globalStatsFilters;
610
-		if ($filter_name == '') $filter_name = $this->filter_name;
731
+		if ($filter_name == '') {
732
+			$filter_name = $this->filter_name;
733
+		}
611 734
 		$query = "SELECT stats_airline as airline_icao, flight_date as date_name, cnt as date_count FROM stats_flight WHERE stats_type = 'date' AND filter_name = :filter_name";
612 735
 		$query_data = array('filter_name' => $filter_name);
613 736
                  try {
@@ -629,7 +752,9 @@  discard block
 block discarded – undo
629 752
 	}
630 753
 	public function countAllMonths($stats_airline = '',$filter_name = '') {
631 754
 		global $globalStatsFilters;
632
-		if ($filter_name == '') $filter_name = $this->filter_name;
755
+		if ($filter_name == '') {
756
+			$filter_name = $this->filter_name;
757
+		}
633 758
 	    	$query = "SELECT YEAR(stats_date) AS year_name,MONTH(stats_date) AS month_name, cnt as date_count FROM stats WHERE stats_type = 'flights_bymonth' AND stats_airline = :stats_airline AND filter_name = :filter_name";
634 759
                  try {
635 760
                         $sth = $this->db->prepare($query);
@@ -650,7 +775,9 @@  discard block
 block discarded – undo
650 775
 	}
651 776
 	public function countAllMilitaryMonths($filter_name = '') {
652 777
 		global $globalStatsFilters;
653
-		if ($filter_name == '') $filter_name = $this->filter_name;
778
+		if ($filter_name == '') {
779
+			$filter_name = $this->filter_name;
780
+		}
654 781
 	    	$query = "SELECT YEAR(stats_date) AS year_name,MONTH(stats_date) AS month_name, cnt as date_count FROM stats WHERE stats_type = 'military_flights_bymonth' AND filter_name = :filter_name";
655 782
                  try {
656 783
                         $sth = $this->db->prepare($query);
@@ -671,9 +798,14 @@  discard block
 block discarded – undo
671 798
 	}
672 799
 	public function countAllHours($orderby = 'hour',$limit = true,$stats_airline = '',$filter_name = '') {
673 800
 		global $globalTimezone, $globalDBdriver, $globalStatsFilters;
674
-		if ($filter_name == '') $filter_name = $this->filter_name;
675
-		if ($limit) $query = "SELECT flight_date as hour_name, cnt as hour_count FROM stats_flight WHERE stats_type = 'hour' AND stats_airline = :stats_airline AND filter_name = :filter_name";
676
-		else $query = "SELECT flight_date as hour_name, cnt as hour_count FROM stats_flight WHERE stats_type = 'hour' AND stats_airline = :stats_airline AND filter_name = :filter_name";
801
+		if ($filter_name == '') {
802
+			$filter_name = $this->filter_name;
803
+		}
804
+		if ($limit) {
805
+			$query = "SELECT flight_date as hour_name, cnt as hour_count FROM stats_flight WHERE stats_type = 'hour' AND stats_airline = :stats_airline AND filter_name = :filter_name";
806
+		} else {
807
+			$query = "SELECT flight_date as hour_name, cnt as hour_count FROM stats_flight WHERE stats_type = 'hour' AND stats_airline = :stats_airline AND filter_name = :filter_name";
808
+		}
677 809
 		if ($orderby == 'hour') {
678 810
 			/*
679 811
 			if ($globalDBdriver == 'mysql') {
@@ -682,7 +814,9 @@  discard block
 block discarded – undo
682 814
 			*/
683 815
 			$query .= " ORDER BY CAST(flight_date AS integer) ASC";
684 816
 		}
685
-		if ($orderby == 'count') $query .= " ORDER BY hour_count DESC";
817
+		if ($orderby == 'count') {
818
+			$query .= " ORDER BY hour_count DESC";
819
+		}
686 820
                  try {
687 821
                         $sth = $this->db->prepare($query);
688 822
                         $sth->execute(array(':stats_airline' => $stats_airline, ':filter_name' => $filter_name));
@@ -703,8 +837,12 @@  discard block
 block discarded – undo
703 837
 	
704 838
 	public function countOverallFlights($stats_airline = '', $filter_name = '',$year = '',$month = '') {
705 839
 		global $globalStatsFilters;
706
-		if ($filter_name == '') $filter_name = $this->filter_name;
707
-		if ($year == '') $year = date('Y');
840
+		if ($filter_name == '') {
841
+			$filter_name = $this->filter_name;
842
+		}
843
+		if ($year == '') {
844
+			$year = date('Y');
845
+		}
708 846
 		$all = $this->getSumStats('flights_bymonth',$year,$stats_airline,$filter_name,$month);
709 847
 		if (empty($all)) {
710 848
 			$filters = array('airlines' => array($stats_airline));
@@ -718,8 +856,12 @@  discard block
 block discarded – undo
718 856
 	}
719 857
 	public function countOverallMilitaryFlights($filter_name = '',$year = '', $month = '') {
720 858
 		global $globalStatsFilters;
721
-		if ($filter_name == '') $filter_name = $this->filter_name;
722
-		if ($year == '') $year = date('Y');
859
+		if ($filter_name == '') {
860
+			$filter_name = $this->filter_name;
861
+		}
862
+		if ($year == '') {
863
+			$year = date('Y');
864
+		}
723 865
 		$all = $this->getSumStats('military_flights_bymonth',$year,'',$filter_name,$month);
724 866
 		if (empty($all)) {
725 867
 		        $filters = array();
@@ -733,8 +875,12 @@  discard block
 block discarded – undo
733 875
 	}
734 876
 	public function countOverallArrival($stats_airline = '',$filter_name = '', $year = '', $month = '') {
735 877
 		global $globalStatsFilters;
736
-		if ($filter_name == '') $filter_name = $this->filter_name;
737
-		if ($year == '') $year = date('Y');
878
+		if ($filter_name == '') {
879
+			$filter_name = $this->filter_name;
880
+		}
881
+		if ($year == '') {
882
+			$year = date('Y');
883
+		}
738 884
 		$all = $this->getSumStats('realarrivals_bymonth',$year,$stats_airline,$filter_name,$month);
739 885
 		if (empty($all)) {
740 886
 			$filters = array('airlines' => array($stats_airline));
@@ -748,8 +894,12 @@  discard block
 block discarded – undo
748 894
 	}
749 895
 	public function countOverallAircrafts($stats_airline = '',$filter_name = '',$year = '', $month = '') {
750 896
 		global $globalStatsFilters;
751
-		if ($filter_name == '') $filter_name = $this->filter_name;
752
-		if ($year == '') $year = date('Y');
897
+		if ($filter_name == '') {
898
+			$filter_name = $this->filter_name;
899
+		}
900
+		if ($year == '') {
901
+			$year = date('Y');
902
+		}
753 903
 		$all = $this->getSumStats('aircrafts_bymonth',$year,$stats_airline,$filter_name,$month);
754 904
 		if (empty($all)) {
755 905
 			$filters = array('airlines' => array($stats_airline));
@@ -763,7 +913,9 @@  discard block
 block discarded – undo
763 913
 	}
764 914
 	public function countOverallAirlines($filter_name = '',$year = '',$month = '') {
765 915
 		global $globalStatsFilters;
766
-		if ($filter_name == '') $filter_name = $this->filter_name;
916
+		if ($filter_name == '') {
917
+			$filter_name = $this->filter_name;
918
+		}
767 919
 		if ($year == '' && $month == '') {
768 920
 			$query = "SELECT COUNT(*) AS nb_airline FROM stats_airline WHERE filter_name = :filter_name";
769 921
 			try {
@@ -774,7 +926,9 @@  discard block
 block discarded – undo
774 926
 			}
775 927
 			$result = $sth->fetchAll(PDO::FETCH_ASSOC);
776 928
 			$all = $result[0]['nb_airline'];
777
-		} else $all = $this->getSumStats('airlines_bymonth',$year,'',$filter_name,$month);
929
+		} else {
930
+			$all = $this->getSumStats('airlines_bymonth',$year,'',$filter_name,$month);
931
+		}
778 932
 		if (empty($all)) {
779 933
             		$filters = array();
780 934
             		if ($filter_name != '') {
@@ -787,8 +941,12 @@  discard block
 block discarded – undo
787 941
 	}
788 942
 	public function countOverallOwners($stats_airline = '',$filter_name = '',$year = '', $month = '') {
789 943
 		global $globalStatsFilters;
790
-		if ($filter_name == '') $filter_name = $this->filter_name;
791
-		if ($year == '') $year = date('Y');
944
+		if ($filter_name == '') {
945
+			$filter_name = $this->filter_name;
946
+		}
947
+		if ($year == '') {
948
+			$year = date('Y');
949
+		}
792 950
 		/*
793 951
 		$query = "SELECT COUNT(*) AS nb_owner FROM stats_owner";
794 952
                  try {
@@ -813,8 +971,12 @@  discard block
 block discarded – undo
813 971
 	}
814 972
 	public function countOverallPilots($stats_airline = '',$filter_name = '',$year = '',$month = '') {
815 973
 		global $globalStatsFilters;
816
-		if ($filter_name == '') $filter_name = $this->filter_name;
817
-		if ($year == '') $year = date('Y');
974
+		if ($filter_name == '') {
975
+			$filter_name = $this->filter_name;
976
+		}
977
+		if ($year == '') {
978
+			$year = date('Y');
979
+		}
818 980
 		$all = $this->getSumStats('pilots_bymonth',$year,$stats_airline,$filter_name,$month);
819 981
 		if (empty($all)) {
820 982
 			$filters = array('airlines' => array($stats_airline));
@@ -828,7 +990,9 @@  discard block
 block discarded – undo
828 990
 	}
829 991
 
830 992
 	public function getLast7DaysAirports($airport_icao = '', $stats_airline = '',$filter_name = '') {
831
-		if ($filter_name == '') $filter_name = $this->filter_name;
993
+		if ($filter_name == '') {
994
+			$filter_name = $this->filter_name;
995
+		}
832 996
 		$query = "SELECT * FROM stats_airport WHERE stats_type = 'daily' AND airport_icao = :airport_icao AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY date";
833 997
 		$query_values = array(':airport_icao' => $airport_icao,':stats_airline' => $stats_airline, ':filter_name' => $filter_name);
834 998
                  try {
@@ -841,7 +1005,9 @@  discard block
 block discarded – undo
841 1005
                 return $all;
842 1006
 	}
843 1007
 	public function getStats($type,$stats_airline = '', $filter_name = '') {
844
-		if ($filter_name == '') $filter_name = $this->filter_name;
1008
+		if ($filter_name == '') {
1009
+			$filter_name = $this->filter_name;
1010
+		}
845 1011
                 $query = "SELECT * FROM stats WHERE stats_type = :type AND stats_airline = :stats_airline AND filter_name = :filter_name ORDER BY stats_date";
846 1012
                 $query_values = array(':type' => $type,':stats_airline' => $stats_airline,':filter_name' => $filter_name);
847 1013
                  try {
@@ -854,7 +1020,9 @@  discard block
 block discarded – undo
854 1020
                 return $all;
855 1021
         }
856 1022
 	public function getSumStats($type,$year,$stats_airline = '',$filter_name = '',$month = '') {
857
-		if ($filter_name == '') $filter_name = $this->filter_name;
1023
+		if ($filter_name == '') {
1024
+			$filter_name = $this->filter_name;
1025
+		}
858 1026
     		global $globalArchiveMonths, $globalDBdriver;
859 1027
     		if ($globalDBdriver == 'mysql') {
860 1028
     			if ($month == '') {
@@ -884,7 +1052,9 @@  discard block
 block discarded – undo
884 1052
         }
885 1053
 	public function getStatsTotal($type, $stats_airline = '', $filter_name = '') {
886 1054
     		global $globalArchiveMonths, $globalDBdriver;
887
-		if ($filter_name == '') $filter_name = $this->filter_name;
1055
+		if ($filter_name == '') {
1056
+			$filter_name = $this->filter_name;
1057
+		}
888 1058
     		if ($globalDBdriver == 'mysql') {
889 1059
 			$query = "SELECT SUM(cnt) as total FROM stats WHERE stats_type = :type AND stats_date < DATE_SUB(UTC_TIMESTAMP(), INTERVAL ".$globalArchiveMonths." MONTH) AND stats_airline = :stats_airline AND filter_name = :filter_name";
890 1060
 		} else {
@@ -902,7 +1072,9 @@  discard block
 block discarded – undo
902 1072
         }
903 1073
 	public function getStatsAircraftTotal($stats_airline = '', $filter_name = '') {
904 1074
     		global $globalArchiveMonths, $globalDBdriver;
905
-		if ($filter_name == '') $filter_name = $this->filter_name;
1075
+		if ($filter_name == '') {
1076
+			$filter_name = $this->filter_name;
1077
+		}
906 1078
     		if ($globalDBdriver == 'mysql') {
907 1079
 			$query = "SELECT SUM(cnt) as total FROM stats_aircraft WHERE stats_airline = :stats_airline AND filter_name = :filter_name";
908 1080
                 } else {
@@ -919,7 +1091,9 @@  discard block
 block discarded – undo
919 1091
         }
920 1092
 	public function getStatsAirlineTotal($filter_name = '') {
921 1093
     		global $globalArchiveMonths, $globalDBdriver;
922
-		if ($filter_name == '') $filter_name = $this->filter_name;
1094
+		if ($filter_name == '') {
1095
+			$filter_name = $this->filter_name;
1096
+		}
923 1097
     		if ($globalDBdriver == 'mysql') {
924 1098
 			$query = "SELECT SUM(cnt) as total FROM stats_airline WHERE filter_name = :filter_name";
925 1099
                 } else {
@@ -936,7 +1110,9 @@  discard block
 block discarded – undo
936 1110
         }
937 1111
 	public function getStatsOwnerTotal($filter_name = '') {
938 1112
     		global $globalArchiveMonths, $globalDBdriver;
939
-		if ($filter_name == '') $filter_name = $this->filter_name;
1113
+		if ($filter_name == '') {
1114
+			$filter_name = $this->filter_name;
1115
+		}
940 1116
     		if ($globalDBdriver == 'mysql') {
941 1117
 			$query = "SELECT SUM(cnt) as total FROM stats_owner WHERE filter_name = :filter_name";
942 1118
 		} else {
@@ -953,7 +1129,9 @@  discard block
 block discarded – undo
953 1129
         }
954 1130
 	public function getStatsPilotTotal($filter_name = '') {
955 1131
     		global $globalArchiveMonths, $globalDBdriver;
956
-		if ($filter_name == '') $filter_name = $this->filter_name;
1132
+		if ($filter_name == '') {
1133
+			$filter_name = $this->filter_name;
1134
+		}
957 1135
     		if ($globalDBdriver == 'mysql') {
958 1136
             		$query = "SELECT SUM(cnt) as total FROM stats_pilot WHERE filter_name = :filter_name";
959 1137
             	} else {
@@ -971,7 +1149,9 @@  discard block
 block discarded – undo
971 1149
 
972 1150
 	public function addStat($type,$cnt,$stats_date,$stats_airline = '',$filter_name = '') {
973 1151
 		global $globalDBdriver;
974
-		if ($filter_name == '') $filter_name = $this->filter_name;
1152
+		if ($filter_name == '') {
1153
+			$filter_name = $this->filter_name;
1154
+		}
975 1155
 		if ($globalDBdriver == 'mysql') {
976 1156
 			$query = "INSERT INTO stats (stats_type,cnt,stats_date,stats_airline,filter_name) VALUES (:type,:cnt,:stats_date,:stats_airline,:filter_name) ON DUPLICATE KEY UPDATE cnt = :cnt";
977 1157
                 } else {
@@ -987,7 +1167,9 @@  discard block
 block discarded – undo
987 1167
         }
988 1168
 	public function updateStat($type,$cnt,$stats_date,$stats_airline = '',$filter_name = '') {
989 1169
 		global $globalDBdriver;
990
-		if ($filter_name == '') $filter_name = $this->filter_name;
1170
+		if ($filter_name == '') {
1171
+			$filter_name = $this->filter_name;
1172
+		}
991 1173
 		if ($globalDBdriver == 'mysql') {
992 1174
 			$query = "INSERT INTO stats (stats_type,cnt,stats_date,stats_airline,filter_name) VALUES (:type,:cnt,:stats_date,:stats_airline,:filter_name) ON DUPLICATE KEY UPDATE cnt = cnt+:cnt, stats_date = :date";
993 1175
 		} else {
@@ -1373,10 +1555,14 @@  discard block
 block discarded – undo
1373 1555
     		$Connection = new Connection();
1374 1556
     		date_default_timezone_set('UTC');
1375 1557
     		$last_update = $this->getLastStatsUpdate('last_update_stats');
1376
-			if ($globalDebug) echo 'Update stats !'."\n";
1558
+			if ($globalDebug) {
1559
+				echo 'Update stats !'."\n";
1560
+			}
1377 1561
 			if (isset($last_update[0]['value'])) {
1378 1562
 				$last_update_day = $last_update[0]['value'];
1379
-			} else $last_update_day = '2012-12-12 12:12:12';
1563
+			} else {
1564
+				$last_update_day = '2012-12-12 12:12:12';
1565
+			}
1380 1566
 			$reset = false;
1381 1567
 			if ($globalStatsResetYear) {
1382 1568
 				$reset = true;
@@ -1384,42 +1570,60 @@  discard block
 block discarded – undo
1384 1570
 			}
1385 1571
 			$Spotter = new Spotter($this->db);
1386 1572
 
1387
-			if ($globalDebug) echo 'Count all aircraft types...'."\n";
1573
+			if ($globalDebug) {
1574
+				echo 'Count all aircraft types...'."\n";
1575
+			}
1388 1576
 			$alldata = $Spotter->countAllAircraftTypes(false,0,$last_update_day);
1389 1577
 			foreach ($alldata as $number) {
1390 1578
 				$this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer'],'','',$reset);
1391 1579
 			}
1392
-			if ($globalDebug) echo 'Count all airlines...'."\n";
1580
+			if ($globalDebug) {
1581
+				echo 'Count all airlines...'."\n";
1582
+			}
1393 1583
 			$alldata = $Spotter->countAllAirlines(false,0,$last_update_day);
1394 1584
 			foreach ($alldata as $number) {
1395 1585
 				$this->addStatAirline($number['airline_icao'],$number['airline_count'],$number['airline_name'],'',$reset);
1396 1586
 			}
1397
-			if ($globalDebug) echo 'Count all registrations...'."\n";
1587
+			if ($globalDebug) {
1588
+				echo 'Count all registrations...'."\n";
1589
+			}
1398 1590
 			$alldata = $Spotter->countAllAircraftRegistrations(false,0,$last_update_day);
1399 1591
 			foreach ($alldata as $number) {
1400 1592
 				$this->addStatAircraftRegistration($number['registration'],$number['aircraft_registration_count'],$number['aircraft_icao'],'','',$reset);
1401 1593
 			}
1402
-			if ($globalDebug) echo 'Count all callsigns...'."\n";
1594
+			if ($globalDebug) {
1595
+				echo 'Count all callsigns...'."\n";
1596
+			}
1403 1597
 			$alldata = $Spotter->countAllCallsigns(false,0,$last_update_day);
1404 1598
 			foreach ($alldata as $number) {
1405 1599
 				$this->addStatCallsign($number['callsign_icao'],$number['callsign_icao_count'],$number['airline_icao'],'',$reset);
1406 1600
 			}
1407
-			if ($globalDebug) echo 'Count all owners...'."\n";
1601
+			if ($globalDebug) {
1602
+				echo 'Count all owners...'."\n";
1603
+			}
1408 1604
 			$alldata = $Spotter->countAllOwners(false,0,$last_update_day);
1409 1605
 			foreach ($alldata as $number) {
1410 1606
 				$this->addStatOwner($number['owner_name'],$number['owner_count'],'','',$reset);
1411 1607
 			}
1412
-			if ($globalDebug) echo 'Count all pilots...'."\n";
1608
+			if ($globalDebug) {
1609
+				echo 'Count all pilots...'."\n";
1610
+			}
1413 1611
 			$alldata = $Spotter->countAllPilots(false,0,$last_update_day);
1414 1612
 			foreach ($alldata as $number) {
1415 1613
 				$this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name'],'','',$number['format_source'],$reset);
1416 1614
 			}
1417 1615
 			
1418
-			if ($globalDebug) echo 'Count all departure airports...'."\n";
1616
+			if ($globalDebug) {
1617
+				echo 'Count all departure airports...'."\n";
1618
+			}
1419 1619
 			$pall = $Spotter->countAllDepartureAirports(false,0,$last_update_day);
1420
-			if ($globalDebug) echo 'Count all detected departure airports...'."\n";
1620
+			if ($globalDebug) {
1621
+				echo 'Count all detected departure airports...'."\n";
1622
+			}
1421 1623
         		$dall = $Spotter->countAllDetectedDepartureAirports(false,0,$last_update_day);
1422
-			if ($globalDebug) echo 'Order departure airports...'."\n";
1624
+			if ($globalDebug) {
1625
+				echo 'Order departure airports...'."\n";
1626
+			}
1423 1627
 	        	$alldata = array();
1424 1628
 	        	
1425 1629
     			foreach ($pall as $value) {
@@ -1430,7 +1634,9 @@  discard block
 block discarded – undo
1430 1634
     				$icao = $value['airport_departure_icao'];
1431 1635
         			if (isset($alldata[$icao])) {
1432 1636
     					$alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
1433
-        			} else $alldata[$icao] = $value;
1637
+        			} else {
1638
+        				$alldata[$icao] = $value;
1639
+        			}
1434 1640
 			}
1435 1641
     			$count = array();
1436 1642
     			foreach ($alldata as $key => $row) {
@@ -1440,11 +1646,17 @@  discard block
 block discarded – undo
1440 1646
 			foreach ($alldata as $number) {
1441 1647
 				echo $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count'],'','',$reset);
1442 1648
 			}
1443
-			if ($globalDebug) echo 'Count all arrival airports...'."\n";
1649
+			if ($globalDebug) {
1650
+				echo 'Count all arrival airports...'."\n";
1651
+			}
1444 1652
 			$pall = $Spotter->countAllArrivalAirports(false,0,$last_update_day);
1445
-			if ($globalDebug) echo 'Count all detected arrival airports...'."\n";
1653
+			if ($globalDebug) {
1654
+				echo 'Count all detected arrival airports...'."\n";
1655
+			}
1446 1656
         		$dall = $Spotter->countAllDetectedArrivalAirports(false,0,$last_update_day);
1447
-			if ($globalDebug) echo 'Order arrival airports...'."\n";
1657
+			if ($globalDebug) {
1658
+				echo 'Order arrival airports...'."\n";
1659
+			}
1448 1660
 	        	$alldata = array();
1449 1661
     			foreach ($pall as $value) {
1450 1662
 	        		$icao = $value['airport_arrival_icao'];
@@ -1454,7 +1666,9 @@  discard block
 block discarded – undo
1454 1666
     				$icao = $value['airport_arrival_icao'];
1455 1667
         			if (isset($alldata[$icao])) {
1456 1668
         				$alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
1457
-	        		} else $alldata[$icao] = $value;
1669
+	        		} else {
1670
+	        			$alldata[$icao] = $value;
1671
+	        		}
1458 1672
     			}
1459 1673
         		$count = array();
1460 1674
         		foreach ($alldata as $key => $row) {
@@ -1465,7 +1679,9 @@  discard block
 block discarded – undo
1465 1679
 				echo $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count'],'','',$reset);
1466 1680
 			}
1467 1681
 			if ($Connection->tableExists('countries')) {
1468
-				if ($globalDebug) echo 'Count all flights by countries...'."\n";
1682
+				if ($globalDebug) {
1683
+					echo 'Count all flights by countries...'."\n";
1684
+				}
1469 1685
 				$SpotterArchive = new SpotterArchive();
1470 1686
 				$alldata = $SpotterArchive->countAllFlightOverCountries(false,0,$last_update_day);
1471 1687
 				foreach ($alldata as $number) {
@@ -1477,46 +1693,66 @@  discard block
 block discarded – undo
1477 1693
 			// Add by month using getstat if month finish...
1478 1694
 
1479 1695
 			//if (date('m',strtotime($last_update_day)) != date('m')) {
1480
-			if ($globalDebug) echo 'Count all flights by months...'."\n";
1696
+			if ($globalDebug) {
1697
+				echo 'Count all flights by months...'."\n";
1698
+			}
1481 1699
 			$Spotter = new Spotter($this->db);
1482 1700
 			$alldata = $Spotter->countAllMonths();
1483 1701
 			$lastyear = false;
1484 1702
 			foreach ($alldata as $number) {
1485
-				if ($number['year_name'] != date('Y')) $lastyear = true;
1703
+				if ($number['year_name'] != date('Y')) {
1704
+					$lastyear = true;
1705
+				}
1486 1706
 				$this->addStat('flights_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1487 1707
 			}
1488
-			if ($globalDebug) echo 'Count all military flights by months...'."\n";
1708
+			if ($globalDebug) {
1709
+				echo 'Count all military flights by months...'."\n";
1710
+			}
1489 1711
 			$alldata = $Spotter->countAllMilitaryMonths();
1490 1712
 			foreach ($alldata as $number) {
1491 1713
 				$this->addStat('military_flights_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1492 1714
 			}
1493
-			if ($globalDebug) echo 'Count all owners by months...'."\n";
1715
+			if ($globalDebug) {
1716
+				echo 'Count all owners by months...'."\n";
1717
+			}
1494 1718
 			$alldata = $Spotter->countAllMonthsOwners();
1495 1719
 			foreach ($alldata as $number) {
1496 1720
 				$this->addStat('owners_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1497 1721
 			}
1498
-			if ($globalDebug) echo 'Count all pilots by months...'."\n";
1722
+			if ($globalDebug) {
1723
+				echo 'Count all pilots by months...'."\n";
1724
+			}
1499 1725
 			$alldata = $Spotter->countAllMonthsPilots();
1500 1726
 			foreach ($alldata as $number) {
1501 1727
 				$this->addStat('pilots_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1502 1728
 			}
1503
-			if ($globalDebug) echo 'Count all airlines by months...'."\n";
1729
+			if ($globalDebug) {
1730
+				echo 'Count all airlines by months...'."\n";
1731
+			}
1504 1732
 			$alldata = $Spotter->countAllMonthsAirlines();
1505 1733
 			foreach ($alldata as $number) {
1506 1734
 				$this->addStat('airlines_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1507 1735
 			}
1508
-			if ($globalDebug) echo 'Count all aircrafts by months...'."\n";
1736
+			if ($globalDebug) {
1737
+				echo 'Count all aircrafts by months...'."\n";
1738
+			}
1509 1739
 			$alldata = $Spotter->countAllMonthsAircrafts();
1510 1740
 			foreach ($alldata as $number) {
1511 1741
 				$this->addStat('aircrafts_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1512 1742
 			}
1513
-			if ($globalDebug) echo 'Count all real arrivals by months...'."\n";
1743
+			if ($globalDebug) {
1744
+				echo 'Count all real arrivals by months...'."\n";
1745
+			}
1514 1746
 			$alldata = $Spotter->countAllMonthsRealArrivals();
1515 1747
 			foreach ($alldata as $number) {
1516 1748
 				$this->addStat('realarrivals_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])));
1517 1749
 			}
1518
-			if ($globalDebug) echo 'Airports data...'."\n";
1519
-			if ($globalDebug) echo '...Departure'."\n";
1750
+			if ($globalDebug) {
1751
+				echo 'Airports data...'."\n";
1752
+			}
1753
+			if ($globalDebug) {
1754
+				echo '...Departure'."\n";
1755
+			}
1520 1756
 			$this->deleteStatAirport('daily');
1521 1757
 //			$pall = $Spotter->getLast7DaysAirportsDeparture();
1522 1758
   //      		$dall = $Spotter->getLast7DaysDetectedAirportsDeparture();
@@ -1636,37 +1872,53 @@  discard block
 block discarded – undo
1636 1872
 
1637 1873
 			// Count by airlines
1638 1874
 			echo '--- Stats by airlines ---'."\n";
1639
-			if ($globalDebug) echo 'Count all aircraft types by airlines...'."\n";
1875
+			if ($globalDebug) {
1876
+				echo 'Count all aircraft types by airlines...'."\n";
1877
+			}
1640 1878
 			$Spotter = new Spotter($this->db);
1641 1879
 			$alldata = $Spotter->countAllAircraftTypesByAirlines(false,0,$last_update_day);
1642 1880
 			foreach ($alldata as $number) {
1643 1881
 				$this->addStatAircraft($number['aircraft_icao'],$number['aircraft_icao_count'],$number['aircraft_name'],$number['aircraft_manufacturer'],$number['airline_icao'],'',$reset);
1644 1882
 			}
1645
-			if ($globalDebug) echo 'Count all aircraft registrations by airlines...'."\n";
1883
+			if ($globalDebug) {
1884
+				echo 'Count all aircraft registrations by airlines...'."\n";
1885
+			}
1646 1886
 			$alldata = $Spotter->countAllAircraftRegistrationsByAirlines(false,0,$last_update_day);
1647 1887
 			foreach ($alldata as $number) {
1648 1888
 				$this->addStatAircraftRegistration($number['registration'],$number['aircraft_registration_count'],$number['aircraft_icao'],$number['airline_icao'],'',$reset);
1649 1889
 			}
1650
-			if ($globalDebug) echo 'Count all callsigns by airlines...'."\n";
1890
+			if ($globalDebug) {
1891
+				echo 'Count all callsigns by airlines...'."\n";
1892
+			}
1651 1893
 			$alldata = $Spotter->countAllCallsignsByAirlines(false,0,$last_update_day);
1652 1894
 			foreach ($alldata as $number) {
1653 1895
 				$this->addStatCallsign($number['callsign_icao'],$number['callsign_icao_count'],$number['airline_icao'],'',$reset);
1654 1896
 			}
1655
-			if ($globalDebug) echo 'Count all owners by airlines...'."\n";
1897
+			if ($globalDebug) {
1898
+				echo 'Count all owners by airlines...'."\n";
1899
+			}
1656 1900
 			$alldata = $Spotter->countAllOwnersByAirlines(false,0,$last_update_day);
1657 1901
 			foreach ($alldata as $number) {
1658 1902
 				$this->addStatOwner($number['owner_name'],$number['owner_count'],$number['airline_icao'],'',$reset);
1659 1903
 			}
1660
-			if ($globalDebug) echo 'Count all pilots by airlines...'."\n";
1904
+			if ($globalDebug) {
1905
+				echo 'Count all pilots by airlines...'."\n";
1906
+			}
1661 1907
 			$alldata = $Spotter->countAllPilotsByAirlines(false,0,$last_update_day);
1662 1908
 			foreach ($alldata as $number) {
1663 1909
 				$this->addStatPilot($number['pilot_id'],$number['pilot_count'],$number['pilot_name'],$number['airline_icao'],'',$number['format_source'],$reset);
1664 1910
 			}
1665
-			if ($globalDebug) echo 'Count all departure airports by airlines...'."\n";
1911
+			if ($globalDebug) {
1912
+				echo 'Count all departure airports by airlines...'."\n";
1913
+			}
1666 1914
 			$pall = $Spotter->countAllDepartureAirportsByAirlines(false,0,$last_update_day);
1667
-			if ($globalDebug) echo 'Count all detected departure airports by airlines...'."\n";
1915
+			if ($globalDebug) {
1916
+				echo 'Count all detected departure airports by airlines...'."\n";
1917
+			}
1668 1918
        			$dall = $Spotter->countAllDetectedDepartureAirportsByAirlines(false,0,$last_update_day);
1669
-			if ($globalDebug) echo 'Order detected departure airports by airlines...'."\n";
1919
+			if ($globalDebug) {
1920
+				echo 'Order detected departure airports by airlines...'."\n";
1921
+			}
1670 1922
 	        	//$alldata = array();
1671 1923
     			foreach ($dall as $value) {
1672 1924
     				$icao = $value['airport_departure_icao'];
@@ -1687,11 +1939,17 @@  discard block
 block discarded – undo
1687 1939
 			foreach ($alldata as $number) {
1688 1940
 				echo $this->addStatDepartureAirports($number['airport_departure_icao'],$number['airport_departure_name'],$number['airport_departure_city'],$number['airport_departure_country'],$number['airport_departure_icao_count'],$number['airline_icao'],'',$reset);
1689 1941
 			}
1690
-			if ($globalDebug) echo 'Count all arrival airports by airlines...'."\n";
1942
+			if ($globalDebug) {
1943
+				echo 'Count all arrival airports by airlines...'."\n";
1944
+			}
1691 1945
 			$pall = $Spotter->countAllArrivalAirportsByAirlines(false,0,$last_update_day);
1692
-			if ($globalDebug) echo 'Count all detected arrival airports by airlines...'."\n";
1946
+			if ($globalDebug) {
1947
+				echo 'Count all detected arrival airports by airlines...'."\n";
1948
+			}
1693 1949
         		$dall = $Spotter->countAllDetectedArrivalAirportsByAirlines(false,0,$last_update_day);
1694
-			if ($globalDebug) echo 'Order arrival airports by airlines...'."\n";
1950
+			if ($globalDebug) {
1951
+				echo 'Order arrival airports by airlines...'."\n";
1952
+			}
1695 1953
 	        	//$alldata = array();
1696 1954
     			foreach ($dall as $value) {
1697 1955
     				$icao = $value['airport_arrival_icao'];
@@ -1710,37 +1968,53 @@  discard block
 block discarded – undo
1710 1968
     			}
1711 1969
     			$alldata = $pall;
1712 1970
                         foreach ($alldata as $number) {
1713
-				if ($number['airline_icao'] != '') echo $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count'],$number['airline_icao'],'',$reset);
1971
+				if ($number['airline_icao'] != '') {
1972
+					echo $this->addStatArrivalAirports($number['airport_arrival_icao'],$number['airport_arrival_name'],$number['airport_arrival_city'],$number['airport_arrival_country'],$number['airport_arrival_icao_count'],$number['airline_icao'],'',$reset);
1973
+				}
1974
+			}
1975
+			if ($globalDebug) {
1976
+				echo 'Count all flights by months by airlines...'."\n";
1714 1977
 			}
1715
-			if ($globalDebug) echo 'Count all flights by months by airlines...'."\n";
1716 1978
 			$Spotter = new Spotter($this->db);
1717 1979
 			$alldata = $Spotter->countAllMonthsByAirlines();
1718 1980
 			$lastyear = false;
1719 1981
 			foreach ($alldata as $number) {
1720
-				if ($number['year_name'] != date('Y')) $lastyear = true;
1982
+				if ($number['year_name'] != date('Y')) {
1983
+					$lastyear = true;
1984
+				}
1721 1985
 				$this->addStat('flights_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])),$number['airline_icao']);
1722 1986
 			}
1723
-			if ($globalDebug) echo 'Count all owners by months by airlines...'."\n";
1987
+			if ($globalDebug) {
1988
+				echo 'Count all owners by months by airlines...'."\n";
1989
+			}
1724 1990
 			$alldata = $Spotter->countAllMonthsOwnersByAirlines();
1725 1991
 			foreach ($alldata as $number) {
1726 1992
 				$this->addStat('owners_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])),$number['airline_icao']);
1727 1993
 			}
1728
-			if ($globalDebug) echo 'Count all pilots by months by airlines...'."\n";
1994
+			if ($globalDebug) {
1995
+				echo 'Count all pilots by months by airlines...'."\n";
1996
+			}
1729 1997
 			$alldata = $Spotter->countAllMonthsPilotsByAirlines();
1730 1998
 			foreach ($alldata as $number) {
1731 1999
 				$this->addStat('pilots_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])),$number['airline_icao']);
1732 2000
 			}
1733
-			if ($globalDebug) echo 'Count all aircrafts by months by airlines...'."\n";
2001
+			if ($globalDebug) {
2002
+				echo 'Count all aircrafts by months by airlines...'."\n";
2003
+			}
1734 2004
 			$alldata = $Spotter->countAllMonthsAircraftsByAirlines();
1735 2005
 			foreach ($alldata as $number) {
1736 2006
 				$this->addStat('aircrafts_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])),$number['airline_icao']);
1737 2007
 			}
1738
-			if ($globalDebug) echo 'Count all real arrivals by months by airlines...'."\n";
2008
+			if ($globalDebug) {
2009
+				echo 'Count all real arrivals by months by airlines...'."\n";
2010
+			}
1739 2011
 			$alldata = $Spotter->countAllMonthsRealArrivalsByAirlines();
1740 2012
 			foreach ($alldata as $number) {
1741 2013
 				$this->addStat('realarrivals_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])),$number['airline_icao']);
1742 2014
 			}
1743
-			if ($globalDebug) echo '...Departure'."\n";
2015
+			if ($globalDebug) {
2016
+				echo '...Departure'."\n";
2017
+			}
1744 2018
 			$pall = $Spotter->getLast7DaysAirportsDepartureByAirlines();
1745 2019
         		$dall = $Spotter->getLast7DaysDetectedAirportsDepartureByAirlines();
1746 2020
     			foreach ($dall as $value) {
@@ -1763,7 +2037,9 @@  discard block
 block discarded – undo
1763 2037
 			foreach ($alldata as $number) {
1764 2038
 				$this->addStatDepartureAirportsDaily($number['date'],$number['departure_airport_icao'],$number['departure_airport_name'],$number['departure_airport_city'],$number['departure_airport_country'],$number['departure_airport_count'],$number['airline_icao']);
1765 2039
 			}
1766
-			if ($globalDebug) echo '...Arrival'."\n";
2040
+			if ($globalDebug) {
2041
+				echo '...Arrival'."\n";
2042
+			}
1767 2043
 			$pall = $Spotter->getLast7DaysAirportsArrivalByAirlines();
1768 2044
         		$dall = $Spotter->getLast7DaysDetectedAirportsArrivalByAirlines();
1769 2045
     			foreach ($dall as $value) {
@@ -1787,13 +2063,19 @@  discard block
 block discarded – undo
1787 2063
 				$this->addStatArrivalAirportsDaily($number['date'],$number['arrival_airport_icao'],$number['arrival_airport_name'],$number['arrival_airport_city'],$number['arrival_airport_country'],$number['arrival_airport_count'],$number['airline_icao']);
1788 2064
 			}
1789 2065
 
1790
-			if ($globalDebug) echo 'Flights data...'."\n";
1791
-			if ($globalDebug) echo '-> countAllDatesLastMonth...'."\n";
2066
+			if ($globalDebug) {
2067
+				echo 'Flights data...'."\n";
2068
+			}
2069
+			if ($globalDebug) {
2070
+				echo '-> countAllDatesLastMonth...'."\n";
2071
+			}
1792 2072
 			$alldata = $Spotter->countAllDatesLastMonthByAirlines();
1793 2073
 			foreach ($alldata as $number) {
1794 2074
 				$this->addStatFlight('month',$number['date_name'],$number['date_count'], $number['airline_icao']);
1795 2075
 			}
1796
-			if ($globalDebug) echo '-> countAllDates...'."\n";
2076
+			if ($globalDebug) {
2077
+				echo '-> countAllDates...'."\n";
2078
+			}
1797 2079
 			//$previousdata = $this->countAllDatesByAirlines();
1798 2080
 			$alldata = $Common->array_merge_noappend($previousdatabyairlines,$Spotter->countAllDatesByAirlines());
1799 2081
 			$values = array();
@@ -1806,7 +2088,9 @@  discard block
 block discarded – undo
1806 2088
 				$this->addStatFlight('date',$number['date_name'],$number['date_count'],$number['airline_icao']);
1807 2089
 			}
1808 2090
 			
1809
-			if ($globalDebug) echo '-> countAllHours...'."\n";
2091
+			if ($globalDebug) {
2092
+				echo '-> countAllHours...'."\n";
2093
+			}
1810 2094
 			$alldata = $Spotter->countAllHoursByAirlines('hour');
1811 2095
 			foreach ($alldata as $number) {
1812 2096
 				$this->addStatFlight('hour',$number['hour_name'],$number['hour_count'],$number['airline_icao']);
@@ -1814,7 +2098,9 @@  discard block
 block discarded – undo
1814 2098
 			
1815 2099
 
1816 2100
 			// Stats by filters
1817
-			if (!isset($globalStatsFilters) || $globalStatsFilters == '') $globalStatsFilters = array();
2101
+			if (!isset($globalStatsFilters) || $globalStatsFilters == '') {
2102
+				$globalStatsFilters = array();
2103
+			}
1818 2104
 			foreach ($globalStatsFilters as $name => $filter) {
1819 2105
 				//$filter_name = $filter['name'];
1820 2106
 				$filter_name = $name;
@@ -1822,11 +2108,15 @@  discard block
 block discarded – undo
1822 2108
 				$last_update = $this->getLastStatsUpdate('last_update_stats_'.$filter_name);
1823 2109
 				if (isset($last_update[0]['value'])) {
1824 2110
 					$last_update_day = $last_update[0]['value'];
1825
-				} else $last_update_day = '2012-12-12 12:12:12';
2111
+				} else {
2112
+					$last_update_day = '2012-12-12 12:12:12';
2113
+				}
1826 2114
 				$reset = false;
1827 2115
 
1828 2116
 				// Count by filter
1829
-				if ($globalDebug) echo '--- Stats for filter '.$filter_name.' ---'."\n";
2117
+				if ($globalDebug) {
2118
+					echo '--- Stats for filter '.$filter_name.' ---'."\n";
2119
+				}
1830 2120
 				$Spotter = new Spotter($this->db);
1831 2121
 				$alldata = $Spotter->countAllAircraftTypes(false,0,$last_update_day,$filter);
1832 2122
 				foreach ($alldata as $number) {
@@ -1863,7 +2153,9 @@  discard block
 block discarded – undo
1863 2153
 	    				$icao = $value['airport_departure_icao'];
1864 2154
         				if (isset($alldata[$icao])) {
1865 2155
     						$alldata[$icao]['airport_departure_icao_count'] = $alldata[$icao]['airport_departure_icao_count'] + $value['airport_departure_icao_count'];
1866
-        				} else $alldata[$icao] = $value;
2156
+        				} else {
2157
+        					$alldata[$icao] = $value;
2158
+        				}
1867 2159
 				}
1868 2160
 	    			$count = array();
1869 2161
     				foreach ($alldata as $key => $row) {
@@ -1884,7 +2176,9 @@  discard block
 block discarded – undo
1884 2176
 	    				$icao = $value['airport_arrival_icao'];
1885 2177
         				if (isset($alldata[$icao])) {
1886 2178
         					$alldata[$icao]['airport_arrival_icao_count'] = $alldata[$icao]['airport_arrival_icao_count'] + $value['airport_arrival_icao_count'];
1887
-		        		} else $alldata[$icao] = $value;
2179
+		        		} else {
2180
+		        			$alldata[$icao] = $value;
2181
+		        		}
1888 2182
 	    			}
1889 2183
         			$count = array();
1890 2184
         			foreach ($alldata as $key => $row) {
@@ -1898,7 +2192,9 @@  discard block
 block discarded – undo
1898 2192
 				$alldata = $Spotter->countAllMonths($filter);
1899 2193
 				$lastyear = false;
1900 2194
 				foreach ($alldata as $number) {
1901
-					if ($number['year_name'] != date('Y')) $lastyear = true;
2195
+					if ($number['year_name'] != date('Y')) {
2196
+						$lastyear = true;
2197
+					}
1902 2198
 					$this->addStat('flights_bymonth',$number['date_count'],date('Y-m-d H:i:s',mktime(0,0,0,$number['month_name'],1,$number['year_name'])),'',$filter_name);
1903 2199
 				}
1904 2200
 				$alldata = $Spotter->countAllMonthsOwners($filter);
Please login to merge, or discard this patch.