Completed
Push — master ( 072036...f3a36a )
by Yannick
29:27
created
live-czml.php 1 patch
Spacing   +82 added lines, -82 removed lines patch added patch discarded remove patch
@@ -66,11 +66,11 @@  discard block
 block discarded – undo
66 66
     $s3 = sin($bank/2);
67 67
     $c1c2 = $c1*$c2;
68 68
     $s1s2 = $s1*$s2;
69
-    $w =$c1c2*$c3 - $s1s2*$s3;
70
-    $x =$c1c2*$s3 + $s1s2*$c3;
71
-    $y =$s1*$c2*$c3 + $c1*$s2*$s3;
72
-    $z =$c1*$s2*$c3 - $s1*$c2*$s3;
73
-    return array('x' => $x,'y' => $y,'z' => $z,'w' => $w);
69
+    $w = $c1c2*$c3 - $s1s2*$s3;
70
+    $x = $c1c2*$s3 + $s1s2*$c3;
71
+    $y = $s1*$c2*$c3 + $c1*$s2*$s3;
72
+    $z = $c1*$s2*$c3 - $s1*$c2*$s3;
73
+    return array('x' => $x, 'y' => $y, 'z' => $z, 'w' => $w);
74 74
 //    return array('x' => '0.0','y' => '-0.931','z' => '0.0','w' => '0.365');
75 75
 
76 76
 }
@@ -91,18 +91,18 @@  discard block
 block discarded – undo
91 91
 $min = false;
92 92
 $allhistory = false;
93 93
 $filter['source'] = array();
94
-if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalVATSIM) && $globalVATSIM && isset($_COOKIE['filter_ShowVATSIM']) && $_COOKIE['filter_ShowVATSIM'] == 'true') $filter['source'] = array_merge($filter['source'],array('vatsimtxt'));
95
-if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalIVAO) && $globalIVAO && isset($_COOKIE['filter_ShowIVAO']) && $_COOKIE['filter_ShowIVAO'] == 'true') $filter['source'] = array_merge($filter['source'],array('whazzup'));
96
-if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalphpVMS) && $globalphpVMS && isset($_COOKIE['filter_ShowVMS']) && $_COOKIE['filter_ShowVMS'] == 'true') $filter['source'] = array_merge($filter['source'],array('phpvmacars'));
97
-if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalSBS1) && $globalSBS1 && isset($_COOKIE['filter_ShowSBS1']) && $_COOKIE['filter_ShowSBS1'] == 'true') $filter['source'] = array_merge($filter['source'],array('sbs','famaprs'));
98
-if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalAPRS) && $globalAPRS && isset($_COOKIE['filter_ShowAPRS']) && $_COOKIE['filter_ShowAPRS'] == 'true') $filter['source'] = array_merge($filter['source'],array('aprs'));
99
-if (isset($_COOKIE['filter_ident']) && $_COOKIE['filter_ident'] != '') $filter['ident'] = filter_var($_COOKIE['filter_ident'],FILTER_SANITIZE_STRING);
100
-if (isset($_COOKIE['filter_mmsi']) && $_COOKIE['filter_mmsi'] != '') $filter['mmsi'] = filter_var($_COOKIE['filter_mmsi'],FILTER_SANITIZE_STRING);
101
-if (isset($_COOKIE['filter_Airlines']) && $_COOKIE['filter_Airlines'] != '') $filter['airlines'] = filter_var_array(explode(',',$_COOKIE['filter_Airlines']),FILTER_SANITIZE_STRING);
102
-if (isset($_COOKIE['filter_Sources']) && $_COOKIE['filter_Sources'] != '') $filter['source_aprs'] = filter_var_array(explode(',',$_COOKIE['filter_Sources']),FILTER_SANITIZE_STRING);
103
-if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] != 'all') $filter['airlinestype'] = filter_var($_COOKIE['filter_airlinestype'],FILTER_SANITIZE_STRING);
104
-if (isset($_COOKIE['filter_alliance']) && $_COOKIE['filter_alliance'] != 'all') $filter['alliance'] = filter_var($_COOKIE['filter_alliance'],FILTER_SANITIZE_STRING);
105
-if (isset($_COOKIE['filter_race']) && $_COOKIE['filter_race'] != 'all') $filter['race'] = filter_var($_COOKIE['filter_race'],FILTER_SANITIZE_NUMBER_INT);
94
+if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalVATSIM) && $globalVATSIM && isset($_COOKIE['filter_ShowVATSIM']) && $_COOKIE['filter_ShowVATSIM'] == 'true') $filter['source'] = array_merge($filter['source'], array('vatsimtxt'));
95
+if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalIVAO) && $globalIVAO && isset($_COOKIE['filter_ShowIVAO']) && $_COOKIE['filter_ShowIVAO'] == 'true') $filter['source'] = array_merge($filter['source'], array('whazzup'));
96
+if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalphpVMS) && $globalphpVMS && isset($_COOKIE['filter_ShowVMS']) && $_COOKIE['filter_ShowVMS'] == 'true') $filter['source'] = array_merge($filter['source'], array('phpvmacars'));
97
+if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalSBS1) && $globalSBS1 && isset($_COOKIE['filter_ShowSBS1']) && $_COOKIE['filter_ShowSBS1'] == 'true') $filter['source'] = array_merge($filter['source'], array('sbs', 'famaprs'));
98
+if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalAPRS) && $globalAPRS && isset($_COOKIE['filter_ShowAPRS']) && $_COOKIE['filter_ShowAPRS'] == 'true') $filter['source'] = array_merge($filter['source'], array('aprs'));
99
+if (isset($_COOKIE['filter_ident']) && $_COOKIE['filter_ident'] != '') $filter['ident'] = filter_var($_COOKIE['filter_ident'], FILTER_SANITIZE_STRING);
100
+if (isset($_COOKIE['filter_mmsi']) && $_COOKIE['filter_mmsi'] != '') $filter['mmsi'] = filter_var($_COOKIE['filter_mmsi'], FILTER_SANITIZE_STRING);
101
+if (isset($_COOKIE['filter_Airlines']) && $_COOKIE['filter_Airlines'] != '') $filter['airlines'] = filter_var_array(explode(',', $_COOKIE['filter_Airlines']), FILTER_SANITIZE_STRING);
102
+if (isset($_COOKIE['filter_Sources']) && $_COOKIE['filter_Sources'] != '') $filter['source_aprs'] = filter_var_array(explode(',', $_COOKIE['filter_Sources']), FILTER_SANITIZE_STRING);
103
+if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] != 'all') $filter['airlinestype'] = filter_var($_COOKIE['filter_airlinestype'], FILTER_SANITIZE_STRING);
104
+if (isset($_COOKIE['filter_alliance']) && $_COOKIE['filter_alliance'] != 'all') $filter['alliance'] = filter_var($_COOKIE['filter_alliance'], FILTER_SANITIZE_STRING);
105
+if (isset($_COOKIE['filter_race']) && $_COOKIE['filter_race'] != 'all') $filter['race'] = filter_var($_COOKIE['filter_race'], FILTER_SANITIZE_NUMBER_INT);
106 106
 /*
107 107
 if (isset($globalMapPopup) && !$globalMapPopup && !(isset($_COOKIE['flightpopup']) && $_COOKIE['flightpopup'] == 'true')) {
108 108
 	$min = true;
@@ -149,17 +149,17 @@  discard block
 block discarded – undo
149 149
 	$from_archive = true;
150 150
 //	$begindate = filter_input(INPUT_GET,'begindate',FILTER_VALIDATE_REGEXP,array("options"=>array("regexp"=>'~^\d{4}/\d{2}/\d{2}$~')));
151 151
 //	$enddate = filter_input(INPUT_GET,'enddate',FILTER_VALIDATE_REGEXP,array("options"=>array("regexp"=>'~^\d{4}/\d{2}/\d{2}$~')));
152
-	$begindate = filter_input(INPUT_GET,'begindate',FILTER_SANITIZE_NUMBER_INT);
153
-	$enddate = filter_input(INPUT_GET,'enddate',FILTER_SANITIZE_NUMBER_INT);
154
-	$archivespeed = filter_input(INPUT_GET,'speed',FILTER_SANITIZE_NUMBER_INT);
155
-	$begindate = date('Y-m-d H:i:s',$begindate);
156
-	$enddate = date('Y-m-d H:i:s',$enddate);
152
+	$begindate = filter_input(INPUT_GET, 'begindate', FILTER_SANITIZE_NUMBER_INT);
153
+	$enddate = filter_input(INPUT_GET, 'enddate', FILTER_SANITIZE_NUMBER_INT);
154
+	$archivespeed = filter_input(INPUT_GET, 'speed', FILTER_SANITIZE_NUMBER_INT);
155
+	$begindate = date('Y-m-d H:i:s', $begindate);
156
+	$enddate = date('Y-m-d H:i:s', $enddate);
157 157
 	if ($tracker) {
158
-		$spotter_array = $TrackerArchive->getMinLiveTrackerDataPlayback($begindate,$enddate,$filter);
158
+		$spotter_array = $TrackerArchive->getMinLiveTrackerDataPlayback($begindate, $enddate, $filter);
159 159
 	} elseif ($marine) {
160
-		$spotter_array = $MarineArchive->getMinLiveMarineDataPlayback($begindate,$enddate,$filter);
160
+		$spotter_array = $MarineArchive->getMinLiveMarineDataPlayback($begindate, $enddate, $filter);
161 161
 	} else {
162
-		$spotter_array = $SpotterArchive->getMinLiveSpotterDataPlayback($begindate,$enddate,$filter);
162
+		$spotter_array = $SpotterArchive->getMinLiveSpotterDataPlayback($begindate, $enddate, $filter);
163 163
 	}
164 164
 } elseif (isset($_COOKIE['archive']) && isset($_COOKIE['archive_begin']) && isset($_COOKIE['archive_end']) && isset($_COOKIE['archive_speed'])) {
165 165
 	$from_archive = true;
@@ -176,36 +176,36 @@  discard block
 block discarded – undo
176 176
 	}
177 177
 	$enddate = $_COOKIE['archive_end'];
178 178
 	$enddateinitial = $_COOKIE['archive_end'];
179
-	$archivespeed = filter_var($_COOKIE['archive_speed'],FILTER_SANITIZE_NUMBER_INT);
180
-	$begindate = date('Y-m-d H:i:s',$begindate);
181
-	$enddate = date('Y-m-d H:i:s',$enddate);
179
+	$archivespeed = filter_var($_COOKIE['archive_speed'], FILTER_SANITIZE_NUMBER_INT);
180
+	$begindate = date('Y-m-d H:i:s', $begindate);
181
+	$enddate = date('Y-m-d H:i:s', $enddate);
182 182
 	//echo 'Begin : '.$begindate.' - End : '.$enddate."\n";
183 183
 	if ($tracker) {
184
-		$spotter_array = $TrackerArchive->getMinLiveTrackerData($begindate,$enddate,$filter);
184
+		$spotter_array = $TrackerArchive->getMinLiveTrackerData($begindate, $enddate, $filter);
185 185
 	} elseif ($marine) {
186
-		$spotter_array = $MarineArchive->getMinLiveMarineData($begindate,$enddate,$filter);
186
+		$spotter_array = $MarineArchive->getMinLiveMarineData($begindate, $enddate, $filter);
187 187
 	} else {
188
-		$spotter_array = $SpotterArchive->getMinLiveSpotterData($begindate,$enddate,$filter);
188
+		$spotter_array = $SpotterArchive->getMinLiveSpotterData($begindate, $enddate, $filter);
189 189
 	}
190 190
 } elseif ($tracker) {
191 191
 	$coord = array();
192 192
 	if (isset($_GET['coord']) && $_GET['coord'] != '') {
193
-		$coord = explode(',',$_GET['coord']);
194
-		if (!(filter_var($coord[0],FILTER_VALIDATE_FLOAT) && filter_var($coord[1],FILTER_VALIDATE_FLOAT) && filter_var($coord[2],FILTER_VALIDATE_FLOAT) && filter_var($coord[3],FILTER_VALIDATE_FLOAT) 
193
+		$coord = explode(',', $_GET['coord']);
194
+		if (!(filter_var($coord[0], FILTER_VALIDATE_FLOAT) && filter_var($coord[1], FILTER_VALIDATE_FLOAT) && filter_var($coord[2], FILTER_VALIDATE_FLOAT) && filter_var($coord[3], FILTER_VALIDATE_FLOAT) 
195 195
 		    && $coord[0] > -180.0 && $coord[0] < 180.0 && $coord[1] > -90.0 && $coord[1] < 90.0 && $coord[2] > -180.0 && $coord[2] < 180.0 && $coord[3] > -90.0 && $coord[3] < 90.0)) {
196 196
 			$coord = array();
197 197
 		}
198 198
 	}
199 199
 	$previous_filter = $filter;
200 200
 	if ((isset($_COOKIE['singlemodel']) && $_COOKIE['singlemodel'] == 'true') && (isset($_COOKIE['MapTrackTracker']) && $_COOKIE['MapTrackTracker'] != '')) {
201
-		$filter = array_merge($filter,array('id' => $_COOKIE['MapTrackTracker']));
202
-		$spotter_array = $TrackerLive->getMinLastLiveTrackerData($coord,$filter,false);
201
+		$filter = array_merge($filter, array('id' => $_COOKIE['MapTrackTracker']));
202
+		$spotter_array = $TrackerLive->getMinLastLiveTrackerData($coord, $filter, false);
203 203
 	/*
204 204
 	} elseif (isset($_COOKIE['MapTrack']) && $_COOKIE['MapTrack'] != '' && !empty($coord)) {
205 205
 		$spotter_array = $TrackerLive->getMinLastLiveTrackerData($coord,$filter,true,$_COOKIE['MapTrack']);
206 206
 	*/
207 207
 	} elseif (!isset($_COOKIE['singlemodel']) || $_COOKIE['singlemodel'] == 'false') {
208
-		$spotter_array = $TrackerLive->getMinLastLiveTrackerData($coord,$filter,false);
208
+		$spotter_array = $TrackerLive->getMinLastLiveTrackerData($coord, $filter, false);
209 209
 	} else {
210 210
 		$spotter_array = array();
211 211
 	}
@@ -214,20 +214,20 @@  discard block
 block discarded – undo
214 214
 	$coord = array();
215 215
 	//if (isset($_GET['coord']) && $_GET['coord'] != '') {
216 216
 	if (!((isset($_COOKIE['singlemodel']) && $_COOKIE['singlemodel'] == 'true') && (isset($_COOKIE['MapTrackMarine']) && $_COOKIE['MapTrackMarine'] != '')) && isset($_GET['coord']) && $_GET['coord'] != '') {
217
-		$coord = explode(',',$_GET['coord']);
218
-		if (!(filter_var($coord[0],FILTER_VALIDATE_FLOAT) && filter_var($coord[1],FILTER_VALIDATE_FLOAT) && filter_var($coord[2],FILTER_VALIDATE_FLOAT) && filter_var($coord[3],FILTER_VALIDATE_FLOAT) 
217
+		$coord = explode(',', $_GET['coord']);
218
+		if (!(filter_var($coord[0], FILTER_VALIDATE_FLOAT) && filter_var($coord[1], FILTER_VALIDATE_FLOAT) && filter_var($coord[2], FILTER_VALIDATE_FLOAT) && filter_var($coord[3], FILTER_VALIDATE_FLOAT) 
219 219
 		    && $coord[0] > -180.0 && $coord[0] < 180.0 && $coord[1] > -90.0 && $coord[1] < 90.0 && $coord[2] > -180.0 && $coord[2] < 180.0 && $coord[3] > -90.0 && $coord[3] < 90.0)) {
220 220
 			$coord = array();
221 221
 		}
222 222
 	}
223 223
 	$previous_filter = $filter;
224 224
 	if ((isset($_COOKIE['singlemodel']) && $_COOKIE['singlemodel'] == 'true') && (isset($_COOKIE['MapTrackMarine']) && $_COOKIE['MapTrackMarine'] != '')) {
225
-		$filter = array_merge($filter,array('id' => $_COOKIE['MapTrackMarine']));
226
-		$spotter_array = $MarineLive->getMinLastLiveMarineData($coord,$filter,false);
225
+		$filter = array_merge($filter, array('id' => $_COOKIE['MapTrackMarine']));
226
+		$spotter_array = $MarineLive->getMinLastLiveMarineData($coord, $filter, false);
227 227
 	} elseif (isset($_COOKIE['MapTrackMarine']) && $_COOKIE['MapTrackMarine'] != '' && !empty($coord)) {
228
-		$spotter_array = $MarineLive->getMinLastLiveMarineData($coord,$filter,false,$_COOKIE['MapTrack']);
228
+		$spotter_array = $MarineLive->getMinLastLiveMarineData($coord, $filter, false, $_COOKIE['MapTrack']);
229 229
 	} elseif (!isset($_COOKIE['singlemodel']) || $_COOKIE['singlemodel'] == 'false') {
230
-		$spotter_array = $MarineLive->getMinLastLiveMarineData($coord,$filter,false);
230
+		$spotter_array = $MarineLive->getMinLastLiveMarineData($coord, $filter, false);
231 231
 	} else {
232 232
 		$spotter_array = array();
233 233
 	}
@@ -235,8 +235,8 @@  discard block
 block discarded – undo
235 235
 } else {
236 236
 	$coord = array();
237 237
 	if (!((isset($_COOKIE['singlemodel']) && $_COOKIE['singlemodel'] == 'true') && (isset($_COOKIE['MapTrack']) && $_COOKIE['MapTrack'] != '')) && isset($_GET['coord']) && $_GET['coord'] != '') {
238
-		$coord = explode(',',$_GET['coord']);
239
-		if (!(filter_var($coord[0],FILTER_VALIDATE_FLOAT) && filter_var($coord[1],FILTER_VALIDATE_FLOAT) && filter_var($coord[2],FILTER_VALIDATE_FLOAT) && filter_var($coord[3],FILTER_VALIDATE_FLOAT) 
238
+		$coord = explode(',', $_GET['coord']);
239
+		if (!(filter_var($coord[0], FILTER_VALIDATE_FLOAT) && filter_var($coord[1], FILTER_VALIDATE_FLOAT) && filter_var($coord[2], FILTER_VALIDATE_FLOAT) && filter_var($coord[3], FILTER_VALIDATE_FLOAT) 
240 240
 		    && $coord[0] > -180.0 && $coord[0] < 180.0 && $coord[1] > -90.0 && $coord[1] < 90.0 && $coord[2] > -180.0 && $coord[2] < 180.0 && $coord[3] > -90.0 && $coord[3] < 90.0)) {
241 241
 			$coord = array();
242 242
 		}
@@ -244,14 +244,14 @@  discard block
 block discarded – undo
244 244
 	$previous_filter = $filter;
245 245
 	if (((isset($_COOKIE['singlemodel']) && $_COOKIE['singlemodel'] == 'true') || ((!isset($_COOKIE['singlemodel']) && isset($globalMap3DSelected) && $globalMap3DSelected)) && (isset($_COOKIE['MapTrack']) && $_COOKIE['MapTrack'] != '')) {
246 246
 		//$filter = array_merge($filter,array('id' => $_COOKIE['MapTrack']));
247
-		$spotter_array = $SpotterLive->getMinLastLiveSpotterDataByID($_COOKIE['MapTrack'],$filter,false);
247
+		$spotter_array = $SpotterLive->getMinLastLiveSpotterDataByID($_COOKIE['MapTrack'], $filter, false);
248 248
 		//$spotter_array = $SpotterLive->getMinLastLiveSpotterData($coord,$filter,false);
249 249
 	} elseif (isset($_COOKIE['MapTrack']) && $_COOKIE['MapTrack'] != '') {
250 250
 		//$spotter_array = $SpotterLive->getMinLastLiveSpotterDataByID($_COOKIE['MapTrack'],$filter,false);
251 251
 		//if (empty($spotter_array)) $spotter_array = $SpotterLive->getMinLastLiveSpotterData($coord,$filter,false,$_COOKIE['MapTrack']);
252
-		$spotter_array = $SpotterLive->getMinLastLiveSpotterData($coord,$filter,false,$_COOKIE['MapTrack']);
252
+		$spotter_array = $SpotterLive->getMinLastLiveSpotterData($coord, $filter, false, $_COOKIE['MapTrack']);
253 253
 	} elseif (!isset($_COOKIE['singlemodel']) || $_COOKIE['singlemodel'] == 'false') {
254
-		$spotter_array = $SpotterLive->getMinLastLiveSpotterData($coord,$filter,false);
254
+		$spotter_array = $SpotterLive->getMinLastLiveSpotterData($coord, $filter, false);
255 255
 	} else {
256 256
 		$spotter_array = array();
257 257
 	}
@@ -261,19 +261,19 @@  discard block
 block discarded – undo
261 261
 if (!empty($spotter_array) && isset($coord)) {
262 262
 	if ($tracker) {
263 263
 		if (isset($_GET['archive'])) {
264
-			$flightcnt = $TrackerArchive->getLiveTrackerCount($begindate,$enddate,$filter);
264
+			$flightcnt = $TrackerArchive->getLiveTrackerCount($begindate, $enddate, $filter);
265 265
 		} else {
266 266
 			$flightcnt = $TrackerLive->getLiveTrackerCount($filter);
267 267
 		}
268 268
 	} elseif ($marine) {
269 269
 		if (isset($_GET['archive'])) {
270
-			$flightcnt = $MarineArchive->getLiveMarineCount($begindate,$enddate,$filter);
270
+			$flightcnt = $MarineArchive->getLiveMarineCount($begindate, $enddate, $filter);
271 271
 		} else {
272 272
 			$flightcnt = $MarineLive->getLiveMarineCount($filter);
273 273
 		}
274 274
 	} else {
275 275
 		if (isset($_GET['archive'])) {
276
-			$flightcnt = $SpotterArchive->getLiveSpotterCount($begindate,$enddate,$filter);
276
+			$flightcnt = $SpotterArchive->getLiveSpotterCount($begindate, $enddate, $filter);
277 277
 		} else {
278 278
 			$flightcnt = $SpotterLive->getLiveSpotterCount($filter);
279 279
 		}
@@ -281,17 +281,17 @@  discard block
 block discarded – undo
281 281
 	if ($flightcnt == '') $flightcnt = 0;
282 282
 } else $flightcnt = 0;
283 283
 
284
-$sqltime = round(microtime(true)-$begintime,2);
284
+$sqltime = round(microtime(true) - $begintime, 2);
285 285
 $minitime = time();
286 286
 $minitracktime_begin = time();
287 287
 $minitracktime = $minitracktime_begin;
288 288
 $maxitime = 0;
289
-$lastupdate = filter_input(INPUT_GET,'update',FILTER_SANITIZE_NUMBER_INT);
289
+$lastupdate = filter_input(INPUT_GET, 'update', FILTER_SANITIZE_NUMBER_INT);
290 290
 $modelsdb = array();
291 291
 if (file_exists(dirname(__FILE__).'/models/modelsdb')) {
292
-	if (($handle = fopen(dirname(__FILE__).'/models/modelsdb','r')) !== FALSE) {
293
-		while (($row = fgetcsv($handle,1000)) !== FALSE) {
294
-			if (isset($row[1]) ){
292
+	if (($handle = fopen(dirname(__FILE__).'/models/modelsdb', 'r')) !== FALSE) {
293
+		while (($row = fgetcsv($handle, 1000)) !== FALSE) {
294
+			if (isset($row[1])) {
295 295
 				$model = $row[0];
296 296
 				$modelsdb[$model] = $row[1];
297 297
 			}
@@ -301,9 +301,9 @@  discard block
 block discarded – undo
301 301
 }
302 302
 $modelsdb2 = array();
303 303
 if (file_exists(dirname(__FILE__).'/models/gltf2/modelsdb')) {
304
-	if (($handle = fopen(dirname(__FILE__).'/models/gltf2/modelsdb','r')) !== FALSE) {
305
-		while (($row = fgetcsv($handle,1000)) !== FALSE) {
306
-			if (isset($row[1]) ){
304
+	if (($handle = fopen(dirname(__FILE__).'/models/gltf2/modelsdb', 'r')) !== FALSE) {
305
+		while (($row = fgetcsv($handle, 1000)) !== FALSE) {
306
+			if (isset($row[1])) {
307 307
 				$model = $row[0];
308 308
 				$glb = $row[1];
309 309
 				if (isset($row[2])) {
@@ -349,7 +349,7 @@  discard block
 block discarded – undo
349 349
 if (!empty($spotter_array) && is_array($spotter_array))
350 350
 {
351 351
 	$nblatlong = 0;
352
-	foreach($spotter_array as $spotter_item)
352
+	foreach ($spotter_array as $spotter_item)
353 353
 	{
354 354
 		$j++;
355 355
 		//if (isset($spotter_item['format_source']) && $spotter_item['format_source'] == 'airwhere') $heightrelative = 'RELATIVE_TO_GROUND';
@@ -403,16 +403,16 @@  discard block
 block discarded – undo
403 403
 			}
404 404
 			if (isset($spotter_item['registration'])) $output .= '"registration": "'.$spotter_item['registration'].'",';
405 405
 			if (isset($spotter_item['format_source'])) $output .= '"format": "'.$spotter_item['format_source'].'",';
406
-			if (isset($spotter_item['ident'])) $output.= '"ident": '.json_encode($spotter_item['ident']).',';
406
+			if (isset($spotter_item['ident'])) $output .= '"ident": '.json_encode($spotter_item['ident']).',';
407 407
 			if ($tracker) {
408 408
 				if (isset($spotter_item['type'])) $output .= '"tracker_type": '.json_encode($spotter_item['type']).',';
409
-				$output.= '"type": "tracker"';
409
+				$output .= '"type": "tracker"';
410 410
 			} elseif ($marine) {
411 411
 				if (isset($spotter_item['type'])) $output .= '"marine_type": '.json_encode($spotter_item['type']).',';
412 412
 				if (isset($spotter_item['captain_name'])) $output .= '"captain": '.json_encode($spotter_item['captain_name']).',';
413 413
 				if (isset($spotter_item['race_name'])) $output .= '"race": '.json_encode($spotter_item['race_name']).',';
414 414
 				if (isset($spotter_item['race_rank'])) $output .= '"rank": "'.$spotter_item['race_rank'].'",';
415
-				$output.= '"type": "marine"';
415
+				$output .= '"type": "marine"';
416 416
 			} else {
417 417
 				if ($one3dmodel === false && isset($globalMap3DLiveries) && $globalMap3DLiveries) {
418 418
 					$aircraft_icao = $spotter_item['aircraft_icao'];
@@ -426,14 +426,14 @@  discard block
 block discarded – undo
426 426
 						if (isset($airline_icao)) {
427 427
 							$imagefile = $aircraft_icao.'-'.$airline_icao.'.png';
428 428
 							if (file_exists(dirname(__FILE__).'/models/gltf2/liveries/'.$imagefile)) {
429
-								$output.= '"liveries": "'.$globalURL.'/models/gltf2/liveries/'.$imagefile.'",';
429
+								$output .= '"liveries": "'.$globalURL.'/models/gltf2/liveries/'.$imagefile.'",';
430 430
 							}
431 431
 						}
432 432
 					}
433 433
 					//if ($ident != '') $output.= '"ident": "'.$ident.'",';
434 434
 				}
435
-				$output.= '"gltf2": %gltf2%,';
436
-				$output.= '"type": "flight"';
435
+				$output .= '"gltf2": %gltf2%,';
436
+				$output .= '"type": "flight"';
437 437
 			}
438 438
 			$output .= '},';
439 439
 
@@ -808,8 +808,8 @@  discard block
 block discarded – undo
808 808
 					$output .= '},';
809 809
 				}
810 810
 			}
811
-			if (isset($onground) && $onground) $output = str_replace('%onground%','true',$output);
812
-			else $output = str_replace('%onground%','false',$output);
811
+			if (isset($onground) && $onground) $output = str_replace('%onground%', 'true', $output);
812
+			else $output = str_replace('%onground%', 'false', $output);
813 813
 
814 814
 	//		$output .= '"heightReference": "CLAMP_TO_GROUND",';
815 815
 			//$output .= '"heightReference": "'.$heightrelative.'",';
@@ -825,7 +825,7 @@  discard block
 block discarded – undo
825 825
 			if ($minitime > strtotime($spotter_item['date'])) $minitime = strtotime($spotter_item['date']);
826 826
 			if (isset($_COOKIE['MapTrack']) && $id == $_COOKIE['MapTrack'] && $minitracktime > strtotime($spotter_item['date'])) $minitracktime = strtotime($spotter_item['date']);
827 827
 			if ($maxitime < strtotime($spotter_item['date'])) $maxitime = strtotime($spotter_item['date']);
828
-			$output .= '"'.date("c",strtotime($spotter_item['date'])).'", ';
828
+			$output .= '"'.date("c", strtotime($spotter_item['date'])).'", ';
829 829
 			$output .= $spotter_item['longitude'].', ';
830 830
 			$output .= $spotter_item['latitude'];
831 831
 			$prevlong = $spotter_item['longitude'];
@@ -853,8 +853,8 @@  discard block
 block discarded – undo
853 853
 			//$quat = quaternionrotate(deg2rad($spotter_item['heading']),deg2rad(0),deg2rad(0));
854 854
 			//$orientation .= '"'.date("c",strtotime($spotter_item['date'])).'",'.$quat['x'].','.$quat['y'].','.$quat['z'].','.$quat['w'];
855 855
 		} else {
856
-			$nblatlong = $nblatlong+1;
857
-			$output .= ',"'.date("c",strtotime($spotter_item['date'])).'", ';
856
+			$nblatlong = $nblatlong + 1;
857
+			$output .= ',"'.date("c", strtotime($spotter_item['date'])).'", ';
858 858
 			if ($maxitime < strtotime($spotter_item['date'])) $maxitime = strtotime($spotter_item['date']);
859 859
 			if ($spotter_item['ground_speed'] == 0) {
860 860
 				$output .= $prevlong.', ';
@@ -895,26 +895,26 @@  discard block
 block discarded – undo
895 895
 $output .= ']';
896 896
 if (isset($globalArchive) && $globalArchive === TRUE) {
897 897
 	if (isset($begindateinitial)) {
898
-		$output = str_replace('%minitime%',date("c",$begindateinitial),$output);
899
-	} elseif ((time()-$globalLiveInterval) > $minitime) {
900
-		if (time()-$globalLiveInterval > $maxitime) {
901
-			$output = str_replace('%minitime%',date("c",$maxitime),$output);
898
+		$output = str_replace('%minitime%', date("c", $begindateinitial), $output);
899
+	} elseif ((time() - $globalLiveInterval) > $minitime) {
900
+		if (time() - $globalLiveInterval > $maxitime) {
901
+			$output = str_replace('%minitime%', date("c", $maxitime), $output);
902 902
 		} else {
903
-			$output = str_replace('%minitime%',date("c",time()-$globalLiveInterval),$output);
903
+			$output = str_replace('%minitime%', date("c", time() - $globalLiveInterval), $output);
904 904
 		}
905 905
 	}
906
-	else $output = str_replace('%minitime%',date("c",$minitime),$output);
906
+	else $output = str_replace('%minitime%', date("c", $minitime), $output);
907 907
 } elseif (isset($_COOKIE['MapTrack']) && $_COOKIE['MapTrack'] != '' && $minitracktime != $minitracktime_begin) {
908
-	$output = str_replace('%minitime%',date("c",$minitracktime),$output);
908
+	$output = str_replace('%minitime%', date("c", $minitracktime), $output);
909 909
 } else {
910
-	$output = str_replace('%minitime%',date("c",$minitime),$output);
910
+	$output = str_replace('%minitime%', date("c", $minitime), $output);
911 911
 }
912 912
 if (isset($enddateinitial)) {
913
-	$output = str_replace('%maxitime%',date("c",$enddateinitial),$output);
913
+	$output = str_replace('%maxitime%', date("c", $enddateinitial), $output);
914 914
 } else {
915
-	$output = str_replace('%maxitime%',date("c",$maxitime),$output);
915
+	$output = str_replace('%maxitime%', date("c", $maxitime), $output);
916 916
 }
917
-if ($gltf2) $output = str_replace('%gltf2%','true',$output);
918
-else $output = str_replace('%gltf2%','false',$output);
917
+if ($gltf2) $output = str_replace('%gltf2%', 'true', $output);
918
+else $output = str_replace('%gltf2%', 'false', $output);
919 919
 print $output;
920 920
 ?>
Please login to merge, or discard this patch.
require/class.SpotterLive.php 3 patches
Indentation   +210 added lines, -210 removed lines patch added patch discarded remove patch
@@ -13,10 +13,10 @@  discard block
 block discarded – undo
13 13
 
14 14
 
15 15
 	/**
16
-	* Get SQL query part for filter used
17
-	* @param Array $filter the filter
18
-	* @return Array the SQL part
19
-	*/
16
+	 * Get SQL query part for filter used
17
+	 * @param Array $filter the filter
18
+	 * @return Array the SQL part
19
+	 */
20 20
 	public function getFilter($filter = array(),$where = false,$and = false) {
21 21
 		global $globalFilter, $globalStatsFilters, $globalFilterName, $globalDBdriver;
22 22
 		$filters = array();
@@ -136,11 +136,11 @@  discard block
 block discarded – undo
136 136
 	}
137 137
 
138 138
 	/**
139
-	* Gets all the spotter information based on the latest data entry
140
-	*
141
-	* @return Array the spotter information
142
-	*
143
-	*/
139
+	 * Gets all the spotter information based on the latest data entry
140
+	 *
141
+	 * @return Array the spotter information
142
+	 *
143
+	 */
144 144
 	public function getLiveSpotterData($limit = '', $sort = '', $filter = array())
145 145
 	{
146 146
 		global $globalDBdriver, $globalLiveInterval;
@@ -183,11 +183,11 @@  discard block
 block discarded – undo
183 183
 	}
184 184
 
185 185
 	/**
186
-	* Gets Minimal Live Spotter data
187
-	*
188
-	* @return Array the spotter information
189
-	*
190
-	*/
186
+	 * Gets Minimal Live Spotter data
187
+	 *
188
+	 * @return Array the spotter information
189
+	 *
190
+	 */
191 191
 	public function getMinLiveSpotterData($filter = array())
192 192
 	{
193 193
 		global $globalDBdriver, $globalLiveInterval, $globalArchive;
@@ -224,11 +224,11 @@  discard block
 block discarded – undo
224 224
 	}
225 225
 
226 226
 	/**
227
-	* Gets Minimal Live Spotter data since xx seconds
228
-	*
229
-	* @return Array the spotter information
230
-	*
231
-	*/
227
+	 * Gets Minimal Live Spotter data since xx seconds
228
+	 *
229
+	 * @return Array the spotter information
230
+	 *
231
+	 */
232 232
 	public function getMinLastLiveSpotterData($coord = array(),$filter = array(), $limit = false, $id = '')
233 233
 	{
234 234
 		global $globalDBdriver, $globalLiveInterval, $globalArchive, $globalMap3DAircraftsLimit;
@@ -325,11 +325,11 @@  discard block
 block discarded – undo
325 325
 	}
326 326
 
327 327
 	/**
328
-	* Gets Minimal Live Spotter data since xx seconds
329
-	*
330
-	* @return Array the spotter information
331
-	*
332
-	*/
328
+	 * Gets Minimal Live Spotter data since xx seconds
329
+	 *
330
+	 * @return Array the spotter information
331
+	 *
332
+	 */
333 333
 	public function getMinLastLiveSpotterDataByID($id = '',$filter = array(), $limit = false)
334 334
 	{
335 335
 		global $globalDBdriver, $globalLiveInterval, $globalArchive, $globalMap3DAircraftsLimit;
@@ -394,11 +394,11 @@  discard block
 block discarded – undo
394 394
 	}
395 395
 
396 396
 	/**
397
-	* Gets number of latest data entry
398
-	*
399
-	* @return String number of entry
400
-	*
401
-	*/
397
+	 * Gets number of latest data entry
398
+	 *
399
+	 * @return String number of entry
400
+	 *
401
+	 */
402 402
 	public function getLiveSpotterCount($filter = array())
403 403
 	{
404 404
 		global $globalDBdriver, $globalLiveInterval;
@@ -425,11 +425,11 @@  discard block
 block discarded – undo
425 425
 	}
426 426
 
427 427
 	/**
428
-	* Gets all the spotter information based on the latest data entry and coord
429
-	*
430
-	* @return Array the spotter information
431
-	*
432
-	*/
428
+	 * Gets all the spotter information based on the latest data entry and coord
429
+	 *
430
+	 * @return Array the spotter information
431
+	 *
432
+	 */
433 433
 	public function getLiveSpotterDatabyCoord($coord, $filter = array())
434 434
 	{
435 435
 		global $globalDBdriver, $globalLiveInterval;
@@ -454,11 +454,11 @@  discard block
 block discarded – undo
454 454
 	}
455 455
 
456 456
 	/**
457
-	* Gets all the spotter information based on the latest data entry and coord
458
-	*
459
-	* @return Array the spotter information
460
-	*
461
-	*/
457
+	 * Gets all the spotter information based on the latest data entry and coord
458
+	 *
459
+	 * @return Array the spotter information
460
+	 *
461
+	 */
462 462
 	public function getMinLiveSpotterDatabyCoord($coord, $filter = array())
463 463
 	{
464 464
 		global $globalDBdriver, $globalLiveInterval, $globalArchive;
@@ -523,11 +523,11 @@  discard block
 block discarded – undo
523 523
 	}
524 524
 
525 525
 	/**
526
-	* Gets all the spotter information based on a user's latitude and longitude
527
-	*
528
-	* @return Array the spotter information
529
-	*
530
-	*/
526
+	 * Gets all the spotter information based on a user's latitude and longitude
527
+	 *
528
+	 * @return Array the spotter information
529
+	 *
530
+	 */
531 531
 	public function getLatestSpotterForLayar($lat, $lng, $radius, $interval)
532 532
 	{
533 533
 		$Spotter = new Spotter($this->db);
@@ -537,98 +537,98 @@  discard block
 block discarded – undo
537 537
 				return false;
538 538
 			}
539 539
 		}
540
-        if ($lng != '')
541
-                {
542
-                        if (!is_numeric($lng))
543
-                        {
544
-                                return false;
545
-                        }
546
-                }
547
-
548
-                if ($radius != '')
549
-                {
550
-                        if (!is_numeric($radius))
551
-                        {
552
-                                return false;
553
-                        }
554
-                }
540
+		if ($lng != '')
541
+				{
542
+						if (!is_numeric($lng))
543
+						{
544
+								return false;
545
+						}
546
+				}
547
+
548
+				if ($radius != '')
549
+				{
550
+						if (!is_numeric($radius))
551
+						{
552
+								return false;
553
+						}
554
+				}
555 555
 		$additional_query = '';
556
-        if ($interval != '')
557
-                {
558
-                        if (!is_string($interval))
559
-                        {
560
-                                //$additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE) <= spotter_live.date ';
561
-			        return false;
562
-                        } else {
563
-                if ($interval == '1m')
564
-                {
565
-                    $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE) <= spotter_live.date ';
566
-                } else if ($interval == '15m'){
567
-                    $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 15 MINUTE) <= spotter_live.date ';
568
-                } 
569
-            }
570
-                } else {
571
-         $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE) <= spotter_live.date ';   
572
-        }
573
-
574
-                $query  = "SELECT spotter_live.*, ( 6371 * acos( cos( radians(:lat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(:lng) ) + sin( radians(:lat) ) * sin( radians( latitude ) ) ) ) AS distance FROM spotter_live 
556
+		if ($interval != '')
557
+				{
558
+						if (!is_string($interval))
559
+						{
560
+								//$additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE) <= spotter_live.date ';
561
+					return false;
562
+						} else {
563
+				if ($interval == '1m')
564
+				{
565
+					$additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE) <= spotter_live.date ';
566
+				} else if ($interval == '15m'){
567
+					$additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 15 MINUTE) <= spotter_live.date ';
568
+				} 
569
+			}
570
+				} else {
571
+		 $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE) <= spotter_live.date ';   
572
+		}
573
+
574
+				$query  = "SELECT spotter_live.*, ( 6371 * acos( cos( radians(:lat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(:lng) ) + sin( radians(:lat) ) * sin( radians( latitude ) ) ) ) AS distance FROM spotter_live 
575 575
                    WHERE spotter_live.latitude <> '' 
576 576
                                    AND spotter_live.longitude <> '' 
577 577
                    ".$additional_query."
578 578
                    HAVING distance < :radius  
579 579
                                    ORDER BY distance";
580 580
 
581
-                $spotter_array = $Spotter->getDataFromDB($query, array(':lat' => $lat, ':lng' => $lng,':radius' => $radius));
581
+				$spotter_array = $Spotter->getDataFromDB($query, array(':lat' => $lat, ':lng' => $lng,':radius' => $radius));
582 582
 
583
-                return $spotter_array;
584
-        }
583
+				return $spotter_array;
584
+		}
585 585
 
586 586
     
587
-        /**
588
-	* Gets all the spotter information based on a particular callsign
589
-	*
590
-	* @return Array the spotter information
591
-	*
592
-	*/
587
+		/**
588
+		 * Gets all the spotter information based on a particular callsign
589
+		 *
590
+		 * @return Array the spotter information
591
+		 *
592
+		 */
593 593
 	public function getLastLiveSpotterDataByIdent($ident)
594 594
 	{
595 595
 		$Spotter = new Spotter($this->db);
596 596
 		date_default_timezone_set('UTC');
597 597
 
598 598
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
599
-                $query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';
599
+				$query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';
600 600
 
601 601
 		$spotter_array = $Spotter->getDataFromDB($query,array(':ident' => $ident),'',true);
602 602
 
603 603
 		return $spotter_array;
604 604
 	}
605 605
 
606
-        /**
607
-	* Gets all the spotter information based on a particular callsign
608
-	*
609
-	* @return Array the spotter information
610
-	*
611
-	*/
606
+		/**
607
+		 * Gets all the spotter information based on a particular callsign
608
+		 *
609
+		 * @return Array the spotter information
610
+		 *
611
+		 */
612 612
 	public function getDateLiveSpotterDataByIdent($ident,$date)
613 613
 	{
614 614
 		$Spotter = new Spotter($this->db);
615 615
 		date_default_timezone_set('UTC');
616 616
 
617 617
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
618
-                $query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';
618
+				$query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';
619 619
 
620
-                $date = date('c',$date);
620
+				$date = date('c',$date);
621 621
 		$spotter_array = $Spotter->getDataFromDB($query,array(':ident' => $ident,':date' => $date));
622 622
 
623 623
 		return $spotter_array;
624 624
 	}
625 625
 
626
-        /**
627
-	* Gets last spotter information based on a particular callsign
628
-	*
629
-	* @return Array the spotter information
630
-	*
631
-	*/
626
+		/**
627
+		 * Gets last spotter information based on a particular callsign
628
+		 *
629
+		 * @return Array the spotter information
630
+		 *
631
+		 */
632 632
 	public function getLastLiveSpotterDataById($id)
633 633
 	{
634 634
 		$Spotter = new Spotter($this->db);
@@ -639,12 +639,12 @@  discard block
 block discarded – undo
639 639
 		return $spotter_array;
640 640
 	}
641 641
 
642
-        /**
643
-	* Gets last spotter information based on a particular callsign
644
-	*
645
-	* @return Array the spotter information
646
-	*
647
-	*/
642
+		/**
643
+		 * Gets last spotter information based on a particular callsign
644
+		 *
645
+		 * @return Array the spotter information
646
+		 *
647
+		 */
648 648
 	public function getDateLiveSpotterDataById($id,$date)
649 649
 	{
650 650
 		$Spotter = new Spotter($this->db);
@@ -657,21 +657,21 @@  discard block
 block discarded – undo
657 657
 		return $spotter_array;
658 658
 	}
659 659
 
660
-        /**
661
-	* Gets altitude information based on a particular callsign
662
-	*
663
-	* @return Array the spotter information
664
-	*
665
-	*/
660
+		/**
661
+		 * Gets altitude information based on a particular callsign
662
+		 *
663
+		 * @return Array the spotter information
664
+		 *
665
+		 */
666 666
 	public function getAltitudeLiveSpotterDataByIdent($ident)
667 667
 	{
668 668
 
669 669
 		date_default_timezone_set('UTC');
670 670
 
671 671
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
672
-                $query  = 'SELECT spotter_live.altitude, spotter_live.date FROM spotter_live WHERE spotter_live.ident = :ident';
672
+				$query  = 'SELECT spotter_live.altitude, spotter_live.date FROM spotter_live WHERE spotter_live.ident = :ident';
673 673
 
674
-    		try {
674
+			try {
675 675
 			
676 676
 			$sth = $this->db->prepare($query);
677 677
 			$sth->execute(array(':ident' => $ident));
@@ -684,12 +684,12 @@  discard block
 block discarded – undo
684 684
 		return $spotter_array;
685 685
 	}
686 686
 
687
-        /**
688
-	* Gets all the spotter information based on a particular id
689
-	*
690
-	* @return Array the spotter information
691
-	*
692
-	*/
687
+		/**
688
+		 * Gets all the spotter information based on a particular id
689
+		 *
690
+		 * @return Array the spotter information
691
+		 *
692
+		 */
693 693
 	public function getAllLiveSpotterDataById($id,$liveinterval = false)
694 694
 	{
695 695
 		global $globalDBdriver, $globalLiveInterval;
@@ -717,18 +717,18 @@  discard block
 block discarded – undo
717 717
 		return $spotter_array;
718 718
 	}
719 719
 
720
-        /**
721
-	* Gets all the spotter information based on a particular ident
722
-	*
723
-	* @return Array the spotter information
724
-	*
725
-	*/
720
+		/**
721
+		 * Gets all the spotter information based on a particular ident
722
+		 *
723
+		 * @return Array the spotter information
724
+		 *
725
+		 */
726 726
 	public function getAllLiveSpotterDataByIdent($ident)
727 727
 	{
728 728
 		date_default_timezone_set('UTC');
729 729
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
730 730
 		$query  = self::$global_query.' WHERE spotter_live.ident = :ident';
731
-    		try {
731
+			try {
732 732
 			
733 733
 			$sth = $this->db->prepare($query);
734 734
 			$sth->execute(array(':ident' => $ident));
@@ -742,23 +742,23 @@  discard block
 block discarded – undo
742 742
 
743 743
 
744 744
 	/**
745
-	* Deletes all info in the table
746
-	*
747
-	* @return String success or false
748
-	*
749
-	*/
745
+	 * Deletes all info in the table
746
+	 *
747
+	 * @return String success or false
748
+	 *
749
+	 */
750 750
 	public function deleteLiveSpotterData()
751 751
 	{
752 752
 		global $globalDBdriver;
753 753
 		if ($globalDBdriver == 'mysql') {
754 754
 			//$query  = "DELETE FROM spotter_live WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL 30 MINUTE) >= spotter_live.date";
755 755
 			$query  = 'DELETE FROM spotter_live WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL 9 HOUR) >= spotter_live.date';
756
-            		//$query  = "DELETE FROM spotter_live WHERE spotter_live.id IN (SELECT spotter_live.id FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 HOUR) >= spotter_live.date)";
756
+					//$query  = "DELETE FROM spotter_live WHERE spotter_live.id IN (SELECT spotter_live.id FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 HOUR) >= spotter_live.date)";
757 757
 		} else {
758 758
 			$query  = "DELETE FROM spotter_live WHERE NOW() AT TIME ZONE 'UTC' - INTERVAL '9 HOURS' >= spotter_live.date";
759 759
 		}
760 760
         
761
-    		try {
761
+			try {
762 762
 			
763 763
 			$sth = $this->db->prepare($query);
764 764
 			$sth->execute();
@@ -770,18 +770,18 @@  discard block
 block discarded – undo
770 770
 	}
771 771
 
772 772
 	/**
773
-	* Deletes all info in the table for aircraft not seen since 2 HOUR
774
-	*
775
-	* @return String success or false
776
-	*
777
-	*/
773
+	 * Deletes all info in the table for aircraft not seen since 2 HOUR
774
+	 *
775
+	 * @return String success or false
776
+	 *
777
+	 */
778 778
 	public function deleteLiveSpotterDataNotUpdated()
779 779
 	{
780 780
 		global $globalDBdriver, $globalDebug;
781 781
 		if ($globalDBdriver == 'mysql') {
782 782
 			//$query = 'SELECT flightaware_id FROM spotter_live WHERE DATE_SUB(UTC_TIMESTAMP(), INTERVAL 1 HOUR) >= spotter_live.date AND spotter_live.flightaware_id NOT IN (SELECT flightaware_id FROM spotter_live WHERE DATE_SUB(UTC_TIMESTAMP(), INTERVAL 1 HOUR) < spotter_live.date) LIMIT 800 OFFSET 0';
783
-    			$query = "SELECT spotter_live.flightaware_id FROM spotter_live INNER JOIN (SELECT flightaware_id,MAX(date) as max_date FROM spotter_live GROUP BY flightaware_id) s ON s.flightaware_id = spotter_live.flightaware_id AND DATE_SUB(UTC_TIMESTAMP(), INTERVAL 2 HOUR) >= s.max_date LIMIT 2000 OFFSET 0";
784
-    			try {
783
+				$query = "SELECT spotter_live.flightaware_id FROM spotter_live INNER JOIN (SELECT flightaware_id,MAX(date) as max_date FROM spotter_live GROUP BY flightaware_id) s ON s.flightaware_id = spotter_live.flightaware_id AND DATE_SUB(UTC_TIMESTAMP(), INTERVAL 2 HOUR) >= s.max_date LIMIT 2000 OFFSET 0";
784
+				try {
785 785
 				
786 786
 				$sth = $this->db->prepare($query);
787 787
 				$sth->execute();
@@ -789,8 +789,8 @@  discard block
 block discarded – undo
789 789
 				return "error";
790 790
 			}
791 791
 			$query_delete = 'DELETE FROM spotter_live WHERE flightaware_id IN (';
792
-                        $i = 0;
793
-                        $j =0;
792
+						$i = 0;
793
+						$j =0;
794 794
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
795 795
 			foreach($all as $row)
796 796
 			{
@@ -798,20 +798,20 @@  discard block
 block discarded – undo
798 798
 				$j++;
799 799
 				if ($j == 30) {
800 800
 					if ($globalDebug) echo ".";
801
-				    	try {
801
+						try {
802 802
 						
803 803
 						$sth = $this->db->prepare(substr($query_delete,0,-1).")");
804 804
 						$sth->execute();
805 805
 					} catch(PDOException $e) {
806 806
 						return "error";
807 807
 					}
808
-                                	$query_delete = 'DELETE FROM spotter_live WHERE flightaware_id IN (';
809
-                                	$j = 0;
808
+									$query_delete = 'DELETE FROM spotter_live WHERE flightaware_id IN (';
809
+									$j = 0;
810 810
 				}
811 811
 				$query_delete .= "'".$row['flightaware_id']."',";
812 812
 			}
813 813
 			if ($i > 0) {
814
-    				try {
814
+					try {
815 815
 					
816 816
 					$sth = $this->db->prepare(substr($query_delete,0,-1).")");
817 817
 					$sth->execute();
@@ -822,9 +822,9 @@  discard block
 block discarded – undo
822 822
 			return "success";
823 823
 		} elseif ($globalDBdriver == 'pgsql') {
824 824
 			//$query = "SELECT flightaware_id FROM spotter_live WHERE NOW() AT TIME ZONE 'UTC' - INTERVAL '9 HOURS' >= spotter_live.date AND spotter_live.flightaware_id NOT IN (SELECT flightaware_id FROM spotter_live WHERE NOW() AT TIME ZONE 'UTC' - INTERVAL '9 HOURS' < spotter_live.date) LIMIT 800 OFFSET 0";
825
-    			//$query = "SELECT spotter_live.flightaware_id FROM spotter_live INNER JOIN (SELECT flightaware_id,MAX(date) as max_date FROM spotter_live GROUP BY flightaware_id) s ON s.flightaware_id = spotter_live.flightaware_id AND NOW() AT TIME ZONE 'UTC' - INTERVAL '2 HOURS' >= s.max_date LIMIT 800 OFFSET 0";
826
-    			$query = "DELETE FROM spotter_live WHERE flightaware_id IN (SELECT spotter_live.flightaware_id FROM spotter_live INNER JOIN (SELECT flightaware_id,MAX(date) as max_date FROM spotter_live GROUP BY flightaware_id) s ON s.flightaware_id = spotter_live.flightaware_id AND NOW() AT TIME ZONE 'UTC' - INTERVAL '2 HOURS' >= s.max_date LIMIT 2000 OFFSET 0)";
827
-    			try {
825
+				//$query = "SELECT spotter_live.flightaware_id FROM spotter_live INNER JOIN (SELECT flightaware_id,MAX(date) as max_date FROM spotter_live GROUP BY flightaware_id) s ON s.flightaware_id = spotter_live.flightaware_id AND NOW() AT TIME ZONE 'UTC' - INTERVAL '2 HOURS' >= s.max_date LIMIT 800 OFFSET 0";
826
+				$query = "DELETE FROM spotter_live WHERE flightaware_id IN (SELECT spotter_live.flightaware_id FROM spotter_live INNER JOIN (SELECT flightaware_id,MAX(date) as max_date FROM spotter_live GROUP BY flightaware_id) s ON s.flightaware_id = spotter_live.flightaware_id AND NOW() AT TIME ZONE 'UTC' - INTERVAL '2 HOURS' >= s.max_date LIMIT 2000 OFFSET 0)";
827
+				try {
828 828
 				
829 829
 				$sth = $this->db->prepare($query);
830 830
 				$sth->execute();
@@ -868,17 +868,17 @@  discard block
 block discarded – undo
868 868
 	}
869 869
 
870 870
 	/**
871
-	* Deletes all info in the table for an ident
872
-	*
873
-	* @return String success or false
874
-	*
875
-	*/
871
+	 * Deletes all info in the table for an ident
872
+	 *
873
+	 * @return String success or false
874
+	 *
875
+	 */
876 876
 	public function deleteLiveSpotterDataByIdent($ident)
877 877
 	{
878 878
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
879 879
 		$query  = 'DELETE FROM spotter_live WHERE ident = :ident';
880 880
         
881
-    		try {
881
+			try {
882 882
 			
883 883
 			$sth = $this->db->prepare($query);
884 884
 			$sth->execute(array(':ident' => $ident));
@@ -890,17 +890,17 @@  discard block
 block discarded – undo
890 890
 	}
891 891
 
892 892
 	/**
893
-	* Deletes all info in the table for an id
894
-	*
895
-	* @return String success or false
896
-	*
897
-	*/
893
+	 * Deletes all info in the table for an id
894
+	 *
895
+	 * @return String success or false
896
+	 *
897
+	 */
898 898
 	public function deleteLiveSpotterDataById($id)
899 899
 	{
900 900
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
901 901
 		$query  = 'DELETE FROM spotter_live WHERE flightaware_id = :id';
902 902
         
903
-    		try {
903
+			try {
904 904
 			
905 905
 			$sth = $this->db->prepare($query);
906 906
 			$sth->execute(array(':id' => $id));
@@ -913,11 +913,11 @@  discard block
 block discarded – undo
913 913
 
914 914
 
915 915
 	/**
916
-	* Gets the aircraft ident within the last hour
917
-	*
918
-	* @return String the ident
919
-	*
920
-	*/
916
+	 * Gets the aircraft ident within the last hour
917
+	 *
918
+	 * @return String the ident
919
+	 *
920
+	 */
921 921
 	public function getIdentFromLastHour($ident)
922 922
 	{
923 923
 		global $globalDBdriver, $globalTimezone;
@@ -943,14 +943,14 @@  discard block
 block discarded – undo
943 943
 			$ident_result = $row['ident'];
944 944
 		}
945 945
 		return $ident_result;
946
-        }
946
+		}
947 947
 
948 948
 	/**
949
-	* Check recent aircraft
950
-	*
951
-	* @return String the ident
952
-	*
953
-	*/
949
+	 * Check recent aircraft
950
+	 *
951
+	 * @return String the ident
952
+	 *
953
+	 */
954 954
 	public function checkIdentRecent($ident)
955 955
 	{
956 956
 		global $globalDBdriver, $globalTimezone;
@@ -976,14 +976,14 @@  discard block
 block discarded – undo
976 976
 			$ident_result = $row['flightaware_id'];
977 977
 		}
978 978
 		return $ident_result;
979
-        }
979
+		}
980 980
 
981 981
 	/**
982
-	* Check recent aircraft by id
983
-	*
984
-	* @return String the ident
985
-	*
986
-	*/
982
+	 * Check recent aircraft by id
983
+	 *
984
+	 * @return String the ident
985
+	 *
986
+	 */
987 987
 	public function checkIdRecent($id)
988 988
 	{
989 989
 		global $globalDBdriver, $globalTimezone;
@@ -1009,14 +1009,14 @@  discard block
 block discarded – undo
1009 1009
 			$ident_result = $row['flightaware_id'];
1010 1010
 		}
1011 1011
 		return $ident_result;
1012
-        }
1012
+		}
1013 1013
 
1014 1014
 	/**
1015
-	* Check recent aircraft by ModeS
1016
-	*
1017
-	* @return String the ModeS
1018
-	*
1019
-	*/
1015
+	 * Check recent aircraft by ModeS
1016
+	 *
1017
+	 * @return String the ModeS
1018
+	 *
1019
+	 */
1020 1020
 	public function checkModeSRecent($modes)
1021 1021
 	{
1022 1022
 		global $globalDBdriver, $globalTimezone;
@@ -1046,11 +1046,11 @@  discard block
 block discarded – undo
1046 1046
 	}
1047 1047
 
1048 1048
 	/**
1049
-	* Gets the aircraft data from the last 20 seconds
1050
-	*
1051
-	* @return Array the spotter data
1052
-	*
1053
-	*/
1049
+	 * Gets the aircraft data from the last 20 seconds
1050
+	 *
1051
+	 * @return Array the spotter data
1052
+	 *
1053
+	 */
1054 1054
 	public function getRealTimeData($q = '')
1055 1055
 	{
1056 1056
 		global $globalDBdriver;
@@ -1092,16 +1092,16 @@  discard block
 block discarded – undo
1092 1092
 	}
1093 1093
 
1094 1094
 	/**
1095
-	* Adds a new spotter data
1096
-	*
1097
-	* @param String $flightaware_id the ID from flightaware
1098
-	* @param String $ident the flight ident
1099
-	* @param String $aircraft_icao the aircraft type
1100
-	* @param String $departure_airport_icao the departure airport
1101
-	* @param String $arrival_airport_icao the arrival airport
1102
-	* @return String success or false
1103
-	*
1104
-	*/
1095
+	 * Adds a new spotter data
1096
+	 *
1097
+	 * @param String $flightaware_id the ID from flightaware
1098
+	 * @param String $ident the flight ident
1099
+	 * @param String $aircraft_icao the aircraft type
1100
+	 * @param String $departure_airport_icao the departure airport
1101
+	 * @param String $arrival_airport_icao the arrival airport
1102
+	 * @return String success or false
1103
+	 *
1104
+	 */
1105 1105
 	public function addLiveSpotterData($flightaware_id = '', $ident = '', $aircraft_icao = '', $departure_airport_icao = '', $arrival_airport_icao = '', $latitude = '', $longitude = '', $waypoints = '', $altitude = '', $altitude_real = '',$heading = '', $groundspeed = '', $date = '',$departure_airport_time = '', $arrival_airport_time = '', $squawk = '', $route_stop = '', $ModeS = '', $putinarchive = false,$registration = '',$pilot_id = '', $pilot_name = '', $verticalrate = '', $noarchive = false, $ground = false,$format_source = '', $source_name = '', $over_country = '')
1106 1106
 	{
1107 1107
 		global $globalURL, $globalArchive, $globalDebug;
@@ -1244,10 +1244,10 @@  discard block
 block discarded – undo
1244 1244
 		$arrival_airport_country = '';
1245 1245
 		
1246 1246
             	
1247
-            	if ($squawk == '' || $Common->isInteger($squawk) === false ) $squawk = NULL;
1248
-            	if ($verticalrate == '' || $Common->isInteger($verticalrate) === false ) $verticalrate = NULL;
1249
-            	if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) $groundspeed = 0;
1250
-            	if ($heading == '' || $Common->isInteger($heading) === false ) $heading = 0;
1247
+				if ($squawk == '' || $Common->isInteger($squawk) === false ) $squawk = NULL;
1248
+				if ($verticalrate == '' || $Common->isInteger($verticalrate) === false ) $verticalrate = NULL;
1249
+				if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) $groundspeed = 0;
1250
+				if ($heading == '' || $Common->isInteger($heading) === false ) $heading = 0;
1251 1251
 		
1252 1252
 		$query = '';
1253 1253
 		if ($globalArchive) {
@@ -1268,10 +1268,10 @@  discard block
 block discarded – undo
1268 1268
 			return "error : ".$e->getMessage();
1269 1269
 		}
1270 1270
 		if (isset($globalArchive) && $globalArchive && $putinarchive && $noarchive !== true) {
1271
-		    if ($globalDebug) echo '(Add to SBS archive : ';
1272
-		    $SpotterArchive = new SpotterArchive($this->db);
1273
-		    $result =  $SpotterArchive->addSpotterArchiveData($flightaware_id, $ident, $registration, $airline_name, $airline_icao, $airline_country, $airline_type, $aircraft_icao, $aircraft_shadow, $aircraft_name, $aircraft_manufacturer, $departure_airport_icao, $departure_airport_name, $departure_airport_city, $departure_airport_country, $departure_airport_time,$arrival_airport_icao, $arrival_airport_name, $arrival_airport_city, $arrival_airport_country, $arrival_airport_time, $route_stop, $date,$latitude, $longitude, $waypoints, $altitude, $altitude_real,$heading, $groundspeed, $squawk, $ModeS, $pilot_id, $pilot_name,$verticalrate,$format_source,$source_name, $over_country);
1274
-		    if ($globalDebug) echo $result.')';
1271
+			if ($globalDebug) echo '(Add to SBS archive : ';
1272
+			$SpotterArchive = new SpotterArchive($this->db);
1273
+			$result =  $SpotterArchive->addSpotterArchiveData($flightaware_id, $ident, $registration, $airline_name, $airline_icao, $airline_country, $airline_type, $aircraft_icao, $aircraft_shadow, $aircraft_name, $aircraft_manufacturer, $departure_airport_icao, $departure_airport_name, $departure_airport_city, $departure_airport_country, $departure_airport_time,$arrival_airport_icao, $arrival_airport_name, $arrival_airport_city, $arrival_airport_country, $arrival_airport_time, $route_stop, $date,$latitude, $longitude, $waypoints, $altitude, $altitude_real,$heading, $groundspeed, $squawk, $ModeS, $pilot_id, $pilot_name,$verticalrate,$format_source,$source_name, $over_country);
1274
+			if ($globalDebug) echo $result.')';
1275 1275
 		} elseif ($globalDebug && $putinarchive !== true) {
1276 1276
 			echo '(Not adding to archive)';
1277 1277
 		} elseif ($globalDebug && $noarchive === true) {
Please login to merge, or discard this patch.
Spacing   +143 added lines, -143 removed lines patch added patch discarded remove patch
@@ -17,62 +17,62 @@  discard block
 block discarded – undo
17 17
 	* @param Array $filter the filter
18 18
 	* @return Array the SQL part
19 19
 	*/
20
-	public function getFilter($filter = array(),$where = false,$and = false) {
20
+	public function getFilter($filter = array(), $where = false, $and = false) {
21 21
 		global $globalFilter, $globalStatsFilters, $globalFilterName, $globalDBdriver;
22 22
 		$filters = array();
23 23
 		if (is_array($globalStatsFilters) && isset($globalStatsFilters[$globalFilterName])) {
24 24
 			if (isset($globalStatsFilters[$globalFilterName][0]['source'])) {
25 25
 				$filters = $globalStatsFilters[$globalFilterName];
26 26
 			} else {
27
-				$filter = array_merge($filter,$globalStatsFilters[$globalFilterName]);
27
+				$filter = array_merge($filter, $globalStatsFilters[$globalFilterName]);
28 28
 			}
29 29
 		}
30 30
 		if (isset($filter[0]['source'])) {
31
-			$filters = array_merge($filters,$filter);
31
+			$filters = array_merge($filters, $filter);
32 32
 		}
33
-		if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter);
33
+		if (is_array($globalFilter)) $filter = array_merge($filter, $globalFilter);
34 34
 		$filter_query_join = '';
35 35
 		$filter_query_where = '';
36
-		foreach($filters as $flt) {
36
+		foreach ($filters as $flt) {
37 37
 			if (isset($flt['airlines']) && !empty($flt['airlines'])) {
38 38
 				if ($flt['airlines'][0] != '' && $flt['airlines'][0] != 'all') {
39 39
 					if (isset($flt['source'])) {
40
-						$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','",$flt['airlines'])."') AND spotter_output.format_source IN ('".implode("','",$flt['source'])."')) saf ON saf.flightaware_id = spotter_live.flightaware_id";
40
+						$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','", $flt['airlines'])."') AND spotter_output.format_source IN ('".implode("','", $flt['source'])."')) saf ON saf.flightaware_id = spotter_live.flightaware_id";
41 41
 					} else {
42
-						$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','",$flt['airlines'])."')) saf ON saf.flightaware_id = spotter_live.flightaware_id";
42
+						$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','", $flt['airlines'])."')) saf ON saf.flightaware_id = spotter_live.flightaware_id";
43 43
 					}
44 44
 				}
45 45
 			}
46 46
 			if (isset($flt['pilots_id']) && !empty($flt['pilots_id'])) {
47 47
 				if (isset($flt['source'])) {
48
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.pilot_id IN ('".implode("','",$flt['pilots_id'])."') AND spotter_output.format_source IN ('".implode("','",$flt['source'])."')) spi ON spi.flightaware_id = spotter_live.flightaware_id";
48
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.pilot_id IN ('".implode("','", $flt['pilots_id'])."') AND spotter_output.format_source IN ('".implode("','", $flt['source'])."')) spi ON spi.flightaware_id = spotter_live.flightaware_id";
49 49
 				} else {
50
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.pilot_id IN ('".implode("','",$flt['pilots_id'])."')) spi ON spi.flightaware_id = spotter_live.flightaware_id";
50
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.pilot_id IN ('".implode("','", $flt['pilots_id'])."')) spi ON spi.flightaware_id = spotter_live.flightaware_id";
51 51
 				}
52 52
 			}
53 53
 			if (isset($flt['idents']) && !empty($flt['idents'])) {
54 54
 				if (isset($flt['source'])) {
55
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.ident IN ('".implode("','",$flt['idents'])."') AND spotter_output.format_source IN ('".implode("','",$flt['source'])."')) spid ON spid.flightaware_id = spotter_live.flightaware_id";
55
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.ident IN ('".implode("','", $flt['idents'])."') AND spotter_output.format_source IN ('".implode("','", $flt['source'])."')) spid ON spid.flightaware_id = spotter_live.flightaware_id";
56 56
 				} else {
57
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.ident IN ('".implode("','",$flt['idents'])."')) spid ON spid.flightaware_id = spotter_live.flightaware_id";
57
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.ident IN ('".implode("','", $flt['idents'])."')) spid ON spid.flightaware_id = spotter_live.flightaware_id";
58 58
 				}
59 59
 			}
60 60
 			if (isset($flt['registrations']) && !empty($flt['registrations'])) {
61 61
 				if (isset($flt['source'])) {
62
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.registration IN ('".implode("','",$flt['registrations'])."') AND spotter_output.format_source IN ('".implode("','",$flt['source'])."')) sre ON sre.flightaware_id = spotter_live.flightaware_id";
62
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.registration IN ('".implode("','", $flt['registrations'])."') AND spotter_output.format_source IN ('".implode("','", $flt['source'])."')) sre ON sre.flightaware_id = spotter_live.flightaware_id";
63 63
 				} else {
64
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.registration IN ('".implode("','",$flt['registrations'])."')) sre ON sre.flightaware_id = spotter_live.flightaware_id";
64
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.registration IN ('".implode("','", $flt['registrations'])."')) sre ON sre.flightaware_id = spotter_live.flightaware_id";
65 65
 				}
66 66
 			}
67 67
 			if ((isset($flt['airlines']) && empty($flt['airlines']) && isset($flt['pilots_id']) && empty($flt['pilots_id']) && isset($flt['idents']) && empty($flt['idents'])) || (!isset($flt['airlines']) && !isset($flt['pilots_id']) && !isset($flt['idents']) && !isset($flt['registrations']))) {
68 68
 				if (isset($flt['source'])) {
69
-					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.format_source IN ('".implode("','",$flt['source'])."')) ssf ON ssf.flightaware_id = spotter_live.flightaware_id";
69
+					$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.format_source IN ('".implode("','", $flt['source'])."')) ssf ON ssf.flightaware_id = spotter_live.flightaware_id";
70 70
 				}
71 71
 			}
72 72
 		}
73 73
 		if (isset($filter['airlines']) && !empty($filter['airlines'])) {
74 74
 			if ($filter['airlines'][0] != '' && $filter['airlines'][0] != 'all') {
75
-				$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) sai ON sai.flightaware_id = spotter_live.flightaware_id";
75
+				$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','", $filter['airlines'])."')) sai ON sai.flightaware_id = spotter_live.flightaware_id";
76 76
 			}
77 77
 		}
78 78
 		if (isset($filter['alliance']) && !empty($filter['alliance'])) {
@@ -82,13 +82,13 @@  discard block
 block discarded – undo
82 82
 			$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_live.flightaware_id ";
83 83
 		}
84 84
 		if (isset($filter['pilots_id']) && !empty($filter['pilots_id'])) {
85
-			$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.pilot_id IN ('".implode("','",$filter['pilots_id'])."')) sp ON sp.flightaware_id = spotter_live.flightaware_id";
85
+			$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.pilot_id IN ('".implode("','", $filter['pilots_id'])."')) sp ON sp.flightaware_id = spotter_live.flightaware_id";
86 86
 		}
87 87
 		if (isset($filter['source']) && !empty($filter['source'])) {
88 88
 			if (count($filter['source']) == 1) {
89 89
 				$filter_query_where .= " AND format_source = '".$filter['source'][0]."'";
90 90
 			} else {
91
-				$filter_query_where .= " AND format_source IN ('".implode("','",$filter['source'])."')";
91
+				$filter_query_where .= " AND format_source IN ('".implode("','", $filter['source'])."')";
92 92
 			}
93 93
 		}
94 94
 		if (isset($filter['ident']) && !empty($filter['ident'])) {
@@ -121,15 +121,15 @@  discard block
 block discarded – undo
121 121
 					$filter_query_date .= " AND EXTRACT(DAY FROM spotter_output.date) = '".$filter['day']."'";
122 122
 				}
123 123
 			}
124
-			$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output".preg_replace('/^ AND/',' WHERE',$filter_query_date).") sd ON sd.flightaware_id = spotter_live.flightaware_id";
124
+			$filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output".preg_replace('/^ AND/', ' WHERE', $filter_query_date).") sd ON sd.flightaware_id = spotter_live.flightaware_id";
125 125
 		}
126 126
 		if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) {
127
-			$filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')";
127
+			$filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','", $filter['source_aprs'])."')";
128 128
 		}
129 129
 		if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE';
130 130
 		elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND';
131 131
 		if ($filter_query_where != '') {
132
-			$filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where);
132
+			$filter_query_where = preg_replace('/^ AND/', ' WHERE', $filter_query_where);
133 133
 		}
134 134
 		$filter_query = $filter_query_join.$filter_query_where;
135 135
 		return $filter_query;
@@ -152,8 +152,8 @@  discard block
 block discarded – undo
152 152
 		if ($limit != '')
153 153
 		{
154 154
 			$limit_array = explode(',', $limit);
155
-			$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT);
156
-			$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT);
155
+			$limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT);
156
+			$limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT);
157 157
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0)
158 158
 			{
159 159
 				$limit_query = ' LIMIT '.$limit_array[1].' OFFSET '.$limit_array[0];
@@ -177,7 +177,7 @@  discard block
 block discarded – undo
177 177
 		} else {
178 178
 			$query  = "SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate".$filter_query.$orderby_query;
179 179
 		}
180
-		$spotter_array = $Spotter->getDataFromDB($query.$limit_query,array(),'',true);
180
+		$spotter_array = $Spotter->getDataFromDB($query.$limit_query, array(), '', true);
181 181
 
182 182
 		return $spotter_array;
183 183
 	}
@@ -192,7 +192,7 @@  discard block
 block discarded – undo
192 192
 	{
193 193
 		global $globalDBdriver, $globalLiveInterval, $globalArchive;
194 194
 		date_default_timezone_set('UTC');
195
-		$filter_query = $this->getFilter($filter,true,true);
195
+		$filter_query = $this->getFilter($filter, true, true);
196 196
 		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
197 197
 		if ($globalDBdriver == 'mysql') {
198 198
 			if (isset($globalArchive) && $globalArchive === TRUE) {
@@ -215,7 +215,7 @@  discard block
 block discarded – undo
215 215
 		try {
216 216
 			$sth = $this->db->prepare($query);
217 217
 			$sth->execute();
218
-		} catch(PDOException $e) {
218
+		} catch (PDOException $e) {
219 219
 			echo $e->getMessage();
220 220
 			die;
221 221
 		}
@@ -229,20 +229,20 @@  discard block
 block discarded – undo
229 229
 	* @return Array the spotter information
230 230
 	*
231 231
 	*/
232
-	public function getMinLastLiveSpotterData($coord = array(),$filter = array(), $limit = false, $id = '')
232
+	public function getMinLastLiveSpotterData($coord = array(), $filter = array(), $limit = false, $id = '')
233 233
 	{
234 234
 		global $globalDBdriver, $globalLiveInterval, $globalArchive, $globalMap3DAircraftsLimit;
235 235
 		date_default_timezone_set('UTC');
236 236
 		$usecoord = false;
237 237
 		if (is_array($coord) && !empty($coord)) {
238
-			$minlong = filter_var($coord[0],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
239
-			$minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
240
-			$maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
241
-			$maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
238
+			$minlong = filter_var($coord[0], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
239
+			$minlat = filter_var($coord[1], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
240
+			$maxlong = filter_var($coord[2], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
241
+			$maxlat = filter_var($coord[3], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
242 242
 			$usecoord = true;
243 243
 		}
244
-		$id = filter_var($id,FILTER_SANITIZE_STRING);
245
-		$filter_query = $this->getFilter($filter,true,true);
244
+		$id = filter_var($id, FILTER_SANITIZE_STRING);
245
+		$filter_query = $this->getFilter($filter, true, true);
246 246
 
247 247
 		if (!isset($globalLiveInterval) || $globalLiveInterval == '') $globalLiveInterval = '200';
248 248
 		if (!isset($globalMap3DAircraftsLimit) || $globalMap3DAircraftsLimit == '') $globalMap3DAircraftsLimit = '300';
@@ -254,7 +254,7 @@  discard block
 block discarded – undo
254 254
 				WHERE spotter_archive.latitude <> '0' AND spotter_archive.longitude <> '0' 
255 255
 				ORDER BY spotter_archive.flightaware_id, spotter_archive.date";
256 256
 				*/
257
-				$query  = 'SELECT * FROM (SELECT spotter_archive.ident, spotter_archive.flightaware_id, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, spotter_archive.date, spotter_archive.format_source, spotter_archive.registration 
257
+				$query = 'SELECT * FROM (SELECT spotter_archive.ident, spotter_archive.flightaware_id, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, spotter_archive.date, spotter_archive.format_source, spotter_archive.registration 
258 258
 				FROM spotter_archive INNER JOIN (SELECT flightaware_id FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date) l ON l.flightaware_id = spotter_archive.flightaware_id ";
259 259
 				if ($usecoord) $query .= "AND (spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong.") ";
260 260
 				if ($id != '') $query .= "OR spotter_archive.flightaware_id = :id ";
@@ -268,7 +268,7 @@  discard block
 block discarded – undo
268 268
 				ORDER BY flightaware_id, date";
269 269
 				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
270 270
 			} else {
271
-				$query  = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
271
+				$query = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
272 272
 				FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date ";
273 273
 				if ($usecoord) $query .= "AND (spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong.") ";
274 274
 				if ($id != '') $query .= "OR spotter_live.flightaware_id = :id ";
@@ -284,13 +284,13 @@  discard block
 block discarded – undo
284 284
 				WHERE spotter_archive.latitude <> '0' AND spotter_archive.longitude <> '0' 
285 285
 				ORDER BY spotter_archive.flightaware_id, spotter_archive.date";
286 286
                                */
287
-				$query  = "SELECT * FROM (
287
+				$query = "SELECT * FROM (
288 288
 				SELECT spotter_archive.ident, spotter_archive.flightaware_id, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, spotter_archive.date, spotter_archive.format_source, spotter_archive.registration 
289 289
 				FROM spotter_archive 
290 290
 				INNER JOIN (
291 291
 				    SELECT flightaware_id 
292 292
 				    FROM spotter_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date";
293
-				$query.= ") l ON l.flightaware_id = spotter_archive.flightaware_id ";
293
+				$query .= ") l ON l.flightaware_id = spotter_archive.flightaware_id ";
294 294
 				if ($usecoord) $query .= "AND (spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong.") ";
295 295
 				if ($id != '') $query .= "OR spotter_archive.flightaware_id = :id ";
296 296
 				$query .= "UNION
@@ -316,7 +316,7 @@  discard block
 block discarded – undo
316 316
 		try {
317 317
 			$sth = $this->db->prepare($query);
318 318
 			$sth->execute($query_values);
319
-		} catch(PDOException $e) {
319
+		} catch (PDOException $e) {
320 320
 			echo $e->getMessage();
321 321
 			die;
322 322
 		}
@@ -330,12 +330,12 @@  discard block
 block discarded – undo
330 330
 	* @return Array the spotter information
331 331
 	*
332 332
 	*/
333
-	public function getMinLastLiveSpotterDataByID($id = '',$filter = array(), $limit = false)
333
+	public function getMinLastLiveSpotterDataByID($id = '', $filter = array(), $limit = false)
334 334
 	{
335 335
 		global $globalDBdriver, $globalLiveInterval, $globalArchive, $globalMap3DAircraftsLimit;
336 336
 		date_default_timezone_set('UTC');
337
-		$id = filter_var($id,FILTER_SANITIZE_STRING);
338
-		$filter_query = $this->getFilter($filter,true,true);
337
+		$id = filter_var($id, FILTER_SANITIZE_STRING);
338
+		$filter_query = $this->getFilter($filter, true, true);
339 339
 
340 340
 		if (!isset($globalLiveInterval) || $globalLiveInterval == '') $globalLiveInterval = '200';
341 341
 		if (!isset($globalMap3DAircraftsLimit) || $globalMap3DAircraftsLimit == '') $globalMap3DAircraftsLimit = '300';
@@ -359,13 +359,13 @@  discard block
 block discarded – undo
359 359
 			}
360 360
 		} else {
361 361
 			if (isset($globalArchive) && $globalArchive === TRUE) {
362
-				$query  = "SELECT * FROM (
362
+				$query = "SELECT * FROM (
363 363
 				SELECT spotter_archive.ident, spotter_archive.flightaware_id, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, spotter_archive.date, spotter_archive.format_source, spotter_archive.registration 
364 364
 				FROM spotter_archive 
365 365
 				INNER JOIN (
366 366
 				    SELECT flightaware_id 
367 367
 				    FROM spotter_live".$filter_query." spotter_live.flightaware_id = :id";
368
-				$query.= ") l ON l.flightaware_id = spotter_archive.flightaware_id ";
368
+				$query .= ") l ON l.flightaware_id = spotter_archive.flightaware_id ";
369 369
 				$query .= "UNION
370 370
 				    SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
371 371
 				    FROM spotter_live".$filter_query." spotter_live.flightaware_id = :id";
@@ -385,7 +385,7 @@  discard block
 block discarded – undo
385 385
 		try {
386 386
 			$sth = $this->db->prepare($query);
387 387
 			$sth->execute($query_values);
388
-		} catch(PDOException $e) {
388
+		} catch (PDOException $e) {
389 389
 			echo $e->getMessage();
390 390
 			die;
391 391
 		}
@@ -402,7 +402,7 @@  discard block
 block discarded – undo
402 402
 	public function getLiveSpotterCount($filter = array())
403 403
 	{
404 404
 		global $globalDBdriver, $globalLiveInterval;
405
-		$filter_query = $this->getFilter($filter,true,true);
405
+		$filter_query = $this->getFilter($filter, true, true);
406 406
 
407 407
 		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
408 408
 		if ($globalDBdriver == 'mysql') {
@@ -415,7 +415,7 @@  discard block
 block discarded – undo
415 415
 		try {
416 416
 			$sth = $this->db->prepare($query);
417 417
 			$sth->execute();
418
-		} catch(PDOException $e) {
418
+		} catch (PDOException $e) {
419 419
 			echo $e->getMessage();
420 420
 			die;
421 421
 		}
@@ -438,10 +438,10 @@  discard block
 block discarded – undo
438 438
 		$filter_query = $this->getFilter($filter);
439 439
 
440 440
 		if (is_array($coord)) {
441
-			$minlong = filter_var($coord[0],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
442
-			$minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
443
-			$maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
444
-			$maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
441
+			$minlong = filter_var($coord[0], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
442
+			$minlat = filter_var($coord[1], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
443
+			$maxlong = filter_var($coord[2], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
444
+			$maxlat = filter_var($coord[3], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
445 445
 		} else return array();
446 446
 		if ($globalDBdriver == 'mysql') {
447 447
 			$query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate AND spotter_live.latitude BETWEEN '.$minlat.' AND '.$maxlat.' AND spotter_live.longitude BETWEEN '.$minlong.' AND '.$maxlong.' GROUP BY spotter_live.flightaware_id'.$filter_query;
@@ -464,23 +464,23 @@  discard block
 block discarded – undo
464 464
 		global $globalDBdriver, $globalLiveInterval, $globalArchive;
465 465
 		$Spotter = new Spotter($this->db);
466 466
 		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
467
-		$filter_query = $this->getFilter($filter,true,true);
467
+		$filter_query = $this->getFilter($filter, true, true);
468 468
 
469 469
 		if (is_array($coord)) {
470
-			$minlong = filter_var($coord[0],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
471
-			$minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
472
-			$maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
473
-			$maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
470
+			$minlong = filter_var($coord[0], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
471
+			$minlat = filter_var($coord[1], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
472
+			$maxlong = filter_var($coord[2], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
473
+			$maxlat = filter_var($coord[3], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
474 474
 		} else return array();
475 475
 		if ($globalDBdriver == 'mysql') {
476 476
 			if (isset($globalArchive) && $globalArchive === TRUE) {
477
-				$query  = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.real_altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
477
+				$query = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.real_altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
478 478
 				FROM spotter_live 
479 479
 				'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= spotter_live.date 
480 480
 				AND spotter_live.latitude BETWEEN '.$minlat.' AND '.$maxlat.' AND spotter_live.longitude BETWEEN '.$minlong.' AND '.$maxlong.'
481 481
 				AND spotter_live.latitude <> 0 AND spotter_live.longitude <> 0 ORDER BY date DESC';
482 482
 			} else {
483
-				$query  = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.real_altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
483
+				$query = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.real_altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
484 484
 				FROM spotter_live 
485 485
 				INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate 
486 486
 				    FROM spotter_live l 
@@ -492,14 +492,14 @@  discard block
 block discarded – undo
492 492
 			}
493 493
 		} else {
494 494
 			if (isset($globalArchive) && $globalArchive === TRUE) {
495
-				$query  = "SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.real_altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
495
+				$query = "SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.real_altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
496 496
 				FROM spotter_live 
497 497
 				".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date 
498 498
 				AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." 
499 499
 				AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong." 
500 500
 				AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' ORDER BY date DESC";
501 501
 			} else {
502
-				$query  = "SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.real_altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
502
+				$query = "SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.real_altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
503 503
 				FROM spotter_live 
504 504
 				INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate 
505 505
 				    FROM spotter_live l 
@@ -514,7 +514,7 @@  discard block
 block discarded – undo
514 514
 		try {
515 515
 			$sth = $this->db->prepare($query);
516 516
 			$sth->execute();
517
-		} catch(PDOException $e) {
517
+		} catch (PDOException $e) {
518 518
 			echo $e->getMessage();
519 519
 			die;
520 520
 		}
@@ -563,7 +563,7 @@  discard block
 block discarded – undo
563 563
                 if ($interval == '1m')
564 564
                 {
565 565
                     $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE) <= spotter_live.date ';
566
-                } else if ($interval == '15m'){
566
+                } else if ($interval == '15m') {
567 567
                     $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 15 MINUTE) <= spotter_live.date ';
568 568
                 } 
569 569
             }
@@ -571,14 +571,14 @@  discard block
 block discarded – undo
571 571
          $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE) <= spotter_live.date ';   
572 572
         }
573 573
 
574
-                $query  = "SELECT spotter_live.*, ( 6371 * acos( cos( radians(:lat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(:lng) ) + sin( radians(:lat) ) * sin( radians( latitude ) ) ) ) AS distance FROM spotter_live 
574
+                $query = "SELECT spotter_live.*, ( 6371 * acos( cos( radians(:lat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(:lng) ) + sin( radians(:lat) ) * sin( radians( latitude ) ) ) ) AS distance FROM spotter_live 
575 575
                    WHERE spotter_live.latitude <> '' 
576 576
                                    AND spotter_live.longitude <> '' 
577 577
                    ".$additional_query."
578 578
                    HAVING distance < :radius  
579 579
                                    ORDER BY distance";
580 580
 
581
-                $spotter_array = $Spotter->getDataFromDB($query, array(':lat' => $lat, ':lng' => $lng,':radius' => $radius));
581
+                $spotter_array = $Spotter->getDataFromDB($query, array(':lat' => $lat, ':lng' => $lng, ':radius' => $radius));
582 582
 
583 583
                 return $spotter_array;
584 584
         }
@@ -596,9 +596,9 @@  discard block
 block discarded – undo
596 596
 		date_default_timezone_set('UTC');
597 597
 
598 598
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
599
-                $query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';
599
+                $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';
600 600
 
601
-		$spotter_array = $Spotter->getDataFromDB($query,array(':ident' => $ident),'',true);
601
+		$spotter_array = $Spotter->getDataFromDB($query, array(':ident' => $ident), '', true);
602 602
 
603 603
 		return $spotter_array;
604 604
 	}
@@ -609,16 +609,16 @@  discard block
 block discarded – undo
609 609
 	* @return Array the spotter information
610 610
 	*
611 611
 	*/
612
-	public function getDateLiveSpotterDataByIdent($ident,$date)
612
+	public function getDateLiveSpotterDataByIdent($ident, $date)
613 613
 	{
614 614
 		$Spotter = new Spotter($this->db);
615 615
 		date_default_timezone_set('UTC');
616 616
 
617 617
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
618
-                $query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';
618
+                $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';
619 619
 
620
-                $date = date('c',$date);
621
-		$spotter_array = $Spotter->getDataFromDB($query,array(':ident' => $ident,':date' => $date));
620
+                $date = date('c', $date);
621
+		$spotter_array = $Spotter->getDataFromDB($query, array(':ident' => $ident, ':date' => $date));
622 622
 
623 623
 		return $spotter_array;
624 624
 	}
@@ -634,8 +634,8 @@  discard block
 block discarded – undo
634 634
 		$Spotter = new Spotter($this->db);
635 635
 		date_default_timezone_set('UTC');
636 636
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
637
-		$query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.flightaware_id = :id GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';
638
-		$spotter_array = $Spotter->getDataFromDB($query,array(':id' => $id),'',true);
637
+		$query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.flightaware_id = :id GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';
638
+		$spotter_array = $Spotter->getDataFromDB($query, array(':id' => $id), '', true);
639 639
 		return $spotter_array;
640 640
 	}
641 641
 
@@ -645,15 +645,15 @@  discard block
 block discarded – undo
645 645
 	* @return Array the spotter information
646 646
 	*
647 647
 	*/
648
-	public function getDateLiveSpotterDataById($id,$date)
648
+	public function getDateLiveSpotterDataById($id, $date)
649 649
 	{
650 650
 		$Spotter = new Spotter($this->db);
651 651
 		date_default_timezone_set('UTC');
652 652
 
653 653
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
654
-		$query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.flightaware_id = :id AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';
655
-		$date = date('c',$date);
656
-		$spotter_array = $Spotter->getDataFromDB($query,array(':id' => $id,':date' => $date),'',true);
654
+		$query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.flightaware_id = :id AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';
655
+		$date = date('c', $date);
656
+		$spotter_array = $Spotter->getDataFromDB($query, array(':id' => $id, ':date' => $date), '', true);
657 657
 		return $spotter_array;
658 658
 	}
659 659
 
@@ -669,13 +669,13 @@  discard block
 block discarded – undo
669 669
 		date_default_timezone_set('UTC');
670 670
 
671 671
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
672
-                $query  = 'SELECT spotter_live.altitude, spotter_live.date FROM spotter_live WHERE spotter_live.ident = :ident';
672
+                $query = 'SELECT spotter_live.altitude, spotter_live.date FROM spotter_live WHERE spotter_live.ident = :ident';
673 673
 
674 674
     		try {
675 675
 			
676 676
 			$sth = $this->db->prepare($query);
677 677
 			$sth->execute(array(':ident' => $ident));
678
-		} catch(PDOException $e) {
678
+		} catch (PDOException $e) {
679 679
 			echo $e->getMessage();
680 680
 			die;
681 681
 		}
@@ -690,7 +690,7 @@  discard block
 block discarded – undo
690 690
 	* @return Array the spotter information
691 691
 	*
692 692
 	*/
693
-	public function getAllLiveSpotterDataById($id,$liveinterval = false)
693
+	public function getAllLiveSpotterDataById($id, $liveinterval = false)
694 694
 	{
695 695
 		global $globalDBdriver, $globalLiveInterval;
696 696
 		date_default_timezone_set('UTC');
@@ -709,7 +709,7 @@  discard block
 block discarded – undo
709 709
 		try {
710 710
 			$sth = $this->db->prepare($query);
711 711
 			$sth->execute(array(':id' => $id));
712
-		} catch(PDOException $e) {
712
+		} catch (PDOException $e) {
713 713
 			echo $e->getMessage();
714 714
 			die;
715 715
 		}
@@ -727,12 +727,12 @@  discard block
 block discarded – undo
727 727
 	{
728 728
 		date_default_timezone_set('UTC');
729 729
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
730
-		$query  = self::$global_query.' WHERE spotter_live.ident = :ident';
730
+		$query = self::$global_query.' WHERE spotter_live.ident = :ident';
731 731
     		try {
732 732
 			
733 733
 			$sth = $this->db->prepare($query);
734 734
 			$sth->execute(array(':ident' => $ident));
735
-		} catch(PDOException $e) {
735
+		} catch (PDOException $e) {
736 736
 			echo $e->getMessage();
737 737
 			die;
738 738
 		}
@@ -762,7 +762,7 @@  discard block
 block discarded – undo
762 762
 			
763 763
 			$sth = $this->db->prepare($query);
764 764
 			$sth->execute();
765
-		} catch(PDOException $e) {
765
+		} catch (PDOException $e) {
766 766
 			return "error";
767 767
 		}
768 768
 
@@ -785,14 +785,14 @@  discard block
 block discarded – undo
785 785
 				
786 786
 				$sth = $this->db->prepare($query);
787 787
 				$sth->execute();
788
-			} catch(PDOException $e) {
788
+			} catch (PDOException $e) {
789 789
 				return "error";
790 790
 			}
791 791
 			$query_delete = 'DELETE FROM spotter_live WHERE flightaware_id IN (';
792 792
                         $i = 0;
793
-                        $j =0;
793
+                        $j = 0;
794 794
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
795
-			foreach($all as $row)
795
+			foreach ($all as $row)
796 796
 			{
797 797
 				$i++;
798 798
 				$j++;
@@ -800,9 +800,9 @@  discard block
 block discarded – undo
800 800
 					if ($globalDebug) echo ".";
801 801
 				    	try {
802 802
 						
803
-						$sth = $this->db->prepare(substr($query_delete,0,-1).")");
803
+						$sth = $this->db->prepare(substr($query_delete, 0, -1).")");
804 804
 						$sth->execute();
805
-					} catch(PDOException $e) {
805
+					} catch (PDOException $e) {
806 806
 						return "error";
807 807
 					}
808 808
                                 	$query_delete = 'DELETE FROM spotter_live WHERE flightaware_id IN (';
@@ -813,9 +813,9 @@  discard block
 block discarded – undo
813 813
 			if ($i > 0) {
814 814
     				try {
815 815
 					
816
-					$sth = $this->db->prepare(substr($query_delete,0,-1).")");
816
+					$sth = $this->db->prepare(substr($query_delete, 0, -1).")");
817 817
 					$sth->execute();
818
-				} catch(PDOException $e) {
818
+				} catch (PDOException $e) {
819 819
 					return "error";
820 820
 				}
821 821
 			}
@@ -828,7 +828,7 @@  discard block
 block discarded – undo
828 828
 				
829 829
 				$sth = $this->db->prepare($query);
830 830
 				$sth->execute();
831
-			} catch(PDOException $e) {
831
+			} catch (PDOException $e) {
832 832
 				return "error";
833 833
 			}
834 834
 /*			$query_delete = "DELETE FROM spotter_live WHERE flightaware_id IN (";
@@ -876,13 +876,13 @@  discard block
 block discarded – undo
876 876
 	public function deleteLiveSpotterDataByIdent($ident)
877 877
 	{
878 878
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
879
-		$query  = 'DELETE FROM spotter_live WHERE ident = :ident';
879
+		$query = 'DELETE FROM spotter_live WHERE ident = :ident';
880 880
         
881 881
     		try {
882 882
 			
883 883
 			$sth = $this->db->prepare($query);
884 884
 			$sth->execute(array(':ident' => $ident));
885
-		} catch(PDOException $e) {
885
+		} catch (PDOException $e) {
886 886
 			return "error";
887 887
 		}
888 888
 
@@ -898,13 +898,13 @@  discard block
 block discarded – undo
898 898
 	public function deleteLiveSpotterDataById($id)
899 899
 	{
900 900
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
901
-		$query  = 'DELETE FROM spotter_live WHERE flightaware_id = :id';
901
+		$query = 'DELETE FROM spotter_live WHERE flightaware_id = :id';
902 902
         
903 903
     		try {
904 904
 			
905 905
 			$sth = $this->db->prepare($query);
906 906
 			$sth->execute(array(':id' => $id));
907
-		} catch(PDOException $e) {
907
+		} catch (PDOException $e) {
908 908
 			return "error";
909 909
 		}
910 910
 
@@ -922,13 +922,13 @@  discard block
 block discarded – undo
922 922
 	{
923 923
 		global $globalDBdriver, $globalTimezone;
924 924
 		if ($globalDBdriver == 'mysql') {
925
-			$query  = 'SELECT spotter_live.ident FROM spotter_live 
925
+			$query = 'SELECT spotter_live.ident FROM spotter_live 
926 926
 				WHERE spotter_live.ident = :ident 
927 927
 				AND spotter_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 HOUR) 
928 928
 				AND spotter_live.date < UTC_TIMESTAMP()';
929 929
 			$query_data = array(':ident' => $ident);
930 930
 		} else {
931
-			$query  = "SELECT spotter_live.ident FROM spotter_live 
931
+			$query = "SELECT spotter_live.ident FROM spotter_live 
932 932
 				WHERE spotter_live.ident = :ident 
933 933
 				AND spotter_live.date >= now() AT TIME ZONE 'UTC' - INTERVAL '1 HOURS'
934 934
 				AND spotter_live.date < now() AT TIME ZONE 'UTC'";
@@ -937,8 +937,8 @@  discard block
 block discarded – undo
937 937
 		
938 938
 		$sth = $this->db->prepare($query);
939 939
 		$sth->execute($query_data);
940
-		$ident_result='';
941
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
940
+		$ident_result = '';
941
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
942 942
 		{
943 943
 			$ident_result = $row['ident'];
944 944
 		}
@@ -955,13 +955,13 @@  discard block
 block discarded – undo
955 955
 	{
956 956
 		global $globalDBdriver, $globalTimezone;
957 957
 		if ($globalDBdriver == 'mysql') {
958
-			$query  = 'SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live 
958
+			$query = 'SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live 
959 959
 				WHERE spotter_live.ident = :ident 
960 960
 				AND spotter_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 20 MINUTE)'; 
961 961
 //				AND spotter_live.date < UTC_TIMESTAMP()";
962 962
 			$query_data = array(':ident' => $ident);
963 963
 		} else {
964
-			$query  = "SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live 
964
+			$query = "SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live 
965 965
 				WHERE spotter_live.ident = :ident 
966 966
 				AND spotter_live.date >= now() AT TIME ZONE 'UTC' - INTERVAL '20 MINUTES'";
967 967
 //				AND spotter_live.date < now() AT TIME ZONE 'UTC'";
@@ -970,8 +970,8 @@  discard block
 block discarded – undo
970 970
 		
971 971
 		$sth = $this->db->prepare($query);
972 972
 		$sth->execute($query_data);
973
-		$ident_result='';
974
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
973
+		$ident_result = '';
974
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
975 975
 		{
976 976
 			$ident_result = $row['flightaware_id'];
977 977
 		}
@@ -988,13 +988,13 @@  discard block
 block discarded – undo
988 988
 	{
989 989
 		global $globalDBdriver, $globalTimezone;
990 990
 		if ($globalDBdriver == 'mysql') {
991
-			$query  = 'SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live 
991
+			$query = 'SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live 
992 992
 				WHERE spotter_live.flightaware_id = :id 
993 993
 				AND spotter_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 10 HOUR)'; 
994 994
 //				AND spotter_live.date < UTC_TIMESTAMP()";
995 995
 			$query_data = array(':id' => $id);
996 996
 		} else {
997
-			$query  = "SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live 
997
+			$query = "SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live 
998 998
 				WHERE spotter_live.flightaware_id = :id 
999 999
 				AND spotter_live.date >= now() AT TIME ZONE 'UTC' - INTERVAL '10 HOUR'";
1000 1000
 //				AND spotter_live.date < now() AT TIME ZONE 'UTC'";
@@ -1003,8 +1003,8 @@  discard block
 block discarded – undo
1003 1003
 		
1004 1004
 		$sth = $this->db->prepare($query);
1005 1005
 		$sth->execute($query_data);
1006
-		$ident_result='';
1007
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1006
+		$ident_result = '';
1007
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1008 1008
 		{
1009 1009
 			$ident_result = $row['flightaware_id'];
1010 1010
 		}
@@ -1021,13 +1021,13 @@  discard block
 block discarded – undo
1021 1021
 	{
1022 1022
 		global $globalDBdriver, $globalTimezone;
1023 1023
 		if ($globalDBdriver == 'mysql') {
1024
-			$query  = 'SELECT spotter_live.ModeS, spotter_live.flightaware_id FROM spotter_live 
1024
+			$query = 'SELECT spotter_live.ModeS, spotter_live.flightaware_id FROM spotter_live 
1025 1025
 				WHERE spotter_live.ModeS = :modes 
1026 1026
 				AND spotter_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 20 MINUTE)'; 
1027 1027
 //				AND spotter_live.date < UTC_TIMESTAMP()";
1028 1028
 			$query_data = array(':modes' => $modes);
1029 1029
 		} else {
1030
-			$query  = "SELECT spotter_live.ModeS, spotter_live.flightaware_id FROM spotter_live 
1030
+			$query = "SELECT spotter_live.ModeS, spotter_live.flightaware_id FROM spotter_live 
1031 1031
 				WHERE spotter_live.ModeS = :modes 
1032 1032
 				AND spotter_live.date >= CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '20 MINUTE'";
1033 1033
 //			//	AND spotter_live.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC'";
@@ -1036,8 +1036,8 @@  discard block
 block discarded – undo
1036 1036
 		
1037 1037
 		$sth = $this->db->prepare($query);
1038 1038
 		$sth->execute($query_data);
1039
-		$ident_result='';
1040
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1039
+		$ident_result = '';
1040
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1041 1041
 		{
1042 1042
 			//$ident_result = $row['spotter_live_id'];
1043 1043
 			$ident_result = $row['flightaware_id'];
@@ -1062,8 +1062,8 @@  discard block
 block discarded – undo
1062 1062
 				return array();
1063 1063
 			} else {
1064 1064
 				$q_array = explode(" ", $q);
1065
-				foreach ($q_array as $q_item){
1066
-					$q_item = filter_var($q_item,FILTER_SANITIZE_STRING);
1065
+				foreach ($q_array as $q_item) {
1066
+					$q_item = filter_var($q_item, FILTER_SANITIZE_STRING);
1067 1067
 					$additional_query .= " AND (";
1068 1068
 					$additional_query .= "(spotter_live.aircraft_icao like '%".$q_item."%') OR ";
1069 1069
 					$additional_query .= "(spotter_live.aircraft_name like '%".$q_item."%') OR ";
@@ -1078,11 +1078,11 @@  discard block
 block discarded – undo
1078 1078
 			}
1079 1079
 		}
1080 1080
 		if ($globalDBdriver == 'mysql') {
1081
-			$query  = "SELECT spotter_live.* FROM spotter_live 
1081
+			$query = "SELECT spotter_live.* FROM spotter_live 
1082 1082
 			    WHERE spotter_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 20 SECOND) ".$additional_query." 
1083 1083
 			    AND spotter_live.date < UTC_TIMESTAMP()";
1084 1084
 		} else {
1085
-			$query  = "SELECT spotter_live.* FROM spotter_live 
1085
+			$query = "SELECT spotter_live.* FROM spotter_live 
1086 1086
 			    WHERE spotter_live.date::timestamp >= CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '20 SECONDS' ".$additional_query." 
1087 1087
 			    AND spotter_live.date::timestamp < CURRENT_TIMESTAMP AT TIME ZONE 'UTC'";
1088 1088
 		}
@@ -1102,7 +1102,7 @@  discard block
 block discarded – undo
1102 1102
 	* @return String success or false
1103 1103
 	*
1104 1104
 	*/
1105
-	public function addLiveSpotterData($flightaware_id = '', $ident = '', $aircraft_icao = '', $departure_airport_icao = '', $arrival_airport_icao = '', $latitude = '', $longitude = '', $waypoints = '', $altitude = '', $altitude_real = '',$heading = '', $groundspeed = '', $date = '',$departure_airport_time = '', $arrival_airport_time = '', $squawk = '', $route_stop = '', $ModeS = '', $putinarchive = false,$registration = '',$pilot_id = '', $pilot_name = '', $verticalrate = '', $noarchive = false, $ground = false,$format_source = '', $source_name = '', $over_country = '')
1105
+	public function addLiveSpotterData($flightaware_id = '', $ident = '', $aircraft_icao = '', $departure_airport_icao = '', $arrival_airport_icao = '', $latitude = '', $longitude = '', $waypoints = '', $altitude = '', $altitude_real = '', $heading = '', $groundspeed = '', $date = '', $departure_airport_time = '', $arrival_airport_time = '', $squawk = '', $route_stop = '', $ModeS = '', $putinarchive = false, $registration = '', $pilot_id = '', $pilot_name = '', $verticalrate = '', $noarchive = false, $ground = false, $format_source = '', $source_name = '', $over_country = '')
1106 1106
 	{
1107 1107
 		global $globalURL, $globalArchive, $globalDebug;
1108 1108
 		$Common = new Common();
@@ -1202,27 +1202,27 @@  discard block
 block discarded – undo
1202 1202
 		if ($date == '') $date = date("Y-m-d H:i:s", time());
1203 1203
 
1204 1204
         
1205
-		$flightaware_id = filter_var($flightaware_id,FILTER_SANITIZE_STRING);
1206
-		$ident = filter_var($ident,FILTER_SANITIZE_STRING);
1207
-		$aircraft_icao = filter_var($aircraft_icao,FILTER_SANITIZE_STRING);
1208
-		$departure_airport_icao = filter_var($departure_airport_icao,FILTER_SANITIZE_STRING);
1209
-		$arrival_airport_icao = filter_var($arrival_airport_icao,FILTER_SANITIZE_STRING);
1210
-		$latitude = filter_var($latitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
1211
-		$longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
1212
-		$waypoints = filter_var($waypoints,FILTER_SANITIZE_STRING);
1213
-		$altitude = filter_var($altitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
1214
-		$altitude_real = filter_var($altitude_real,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
1215
-		$heading = filter_var($heading,FILTER_SANITIZE_NUMBER_INT);
1216
-		$groundspeed = filter_var($groundspeed,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
1217
-		$squawk = filter_var($squawk,FILTER_SANITIZE_NUMBER_INT);
1218
-		$route_stop = filter_var($route_stop,FILTER_SANITIZE_STRING);
1219
-		$ModeS = filter_var($ModeS,FILTER_SANITIZE_STRING);
1220
-		$pilot_id = filter_var($pilot_id,FILTER_SANITIZE_STRING);
1221
-		$pilot_name = filter_var($pilot_name,FILTER_SANITIZE_STRING);
1222
-		$format_source = filter_var($format_source,FILTER_SANITIZE_STRING);
1223
-		$source_name = filter_var($source_name,FILTER_SANITIZE_STRING);
1224
-		$over_country = filter_var($over_country,FILTER_SANITIZE_STRING);
1225
-		$verticalrate = filter_var($verticalrate,FILTER_SANITIZE_NUMBER_INT);
1205
+		$flightaware_id = filter_var($flightaware_id, FILTER_SANITIZE_STRING);
1206
+		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
1207
+		$aircraft_icao = filter_var($aircraft_icao, FILTER_SANITIZE_STRING);
1208
+		$departure_airport_icao = filter_var($departure_airport_icao, FILTER_SANITIZE_STRING);
1209
+		$arrival_airport_icao = filter_var($arrival_airport_icao, FILTER_SANITIZE_STRING);
1210
+		$latitude = filter_var($latitude, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
1211
+		$longitude = filter_var($longitude, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
1212
+		$waypoints = filter_var($waypoints, FILTER_SANITIZE_STRING);
1213
+		$altitude = filter_var($altitude, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
1214
+		$altitude_real = filter_var($altitude_real, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
1215
+		$heading = filter_var($heading, FILTER_SANITIZE_NUMBER_INT);
1216
+		$groundspeed = filter_var($groundspeed, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
1217
+		$squawk = filter_var($squawk, FILTER_SANITIZE_NUMBER_INT);
1218
+		$route_stop = filter_var($route_stop, FILTER_SANITIZE_STRING);
1219
+		$ModeS = filter_var($ModeS, FILTER_SANITIZE_STRING);
1220
+		$pilot_id = filter_var($pilot_id, FILTER_SANITIZE_STRING);
1221
+		$pilot_name = filter_var($pilot_name, FILTER_SANITIZE_STRING);
1222
+		$format_source = filter_var($format_source, FILTER_SANITIZE_STRING);
1223
+		$source_name = filter_var($source_name, FILTER_SANITIZE_STRING);
1224
+		$over_country = filter_var($over_country, FILTER_SANITIZE_STRING);
1225
+		$verticalrate = filter_var($verticalrate, FILTER_SANITIZE_NUMBER_INT);
1226 1226
 
1227 1227
 		$airline_name = '';
1228 1228
 		$airline_icao = '';
@@ -1244,10 +1244,10 @@  discard block
 block discarded – undo
1244 1244
 		$arrival_airport_country = '';
1245 1245
 		
1246 1246
             	
1247
-            	if ($squawk == '' || $Common->isInteger($squawk) === false ) $squawk = NULL;
1248
-            	if ($verticalrate == '' || $Common->isInteger($verticalrate) === false ) $verticalrate = NULL;
1249
-            	if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) $groundspeed = 0;
1250
-            	if ($heading == '' || $Common->isInteger($heading) === false ) $heading = 0;
1247
+            	if ($squawk == '' || $Common->isInteger($squawk) === false) $squawk = NULL;
1248
+            	if ($verticalrate == '' || $Common->isInteger($verticalrate) === false) $verticalrate = NULL;
1249
+            	if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0;
1250
+            	if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0;
1251 1251
 		
1252 1252
 		$query = '';
1253 1253
 		if ($globalArchive) {
@@ -1258,19 +1258,19 @@  discard block
 block discarded – undo
1258 1258
 		$query  .= 'INSERT INTO spotter_live (flightaware_id, ident, registration, airline_name, airline_icao, airline_country, airline_type, aircraft_icao, aircraft_shadow, aircraft_name, aircraft_manufacturer, departure_airport_icao, departure_airport_name, departure_airport_city, departure_airport_country, arrival_airport_icao, arrival_airport_name, arrival_airport_city, arrival_airport_country, latitude, longitude, waypoints, altitude, heading, ground_speed, date, departure_airport_time, arrival_airport_time, squawk, route_stop, ModeS, pilot_id, pilot_name, verticalrate, ground, format_source, source_name, over_country, real_altitude) 
1259 1259
 		VALUES (:flightaware_id,:ident,:registration,:airline_name,:airline_icao,:airline_country,:airline_type,:aircraft_icao,:aircraft_shadow,:aircraft_type,:aircraft_manufacturer,:departure_airport_icao,:departure_airport_name, :departure_airport_city, :departure_airport_country, :arrival_airport_icao, :arrival_airport_name, :arrival_airport_city, :arrival_airport_country, :latitude,:longitude,:waypoints,:altitude,:heading,:groundspeed,:date,:departure_airport_time,:arrival_airport_time,:squawk,:route_stop,:ModeS, :pilot_id, :pilot_name, :verticalrate, :ground, :format_source, :source_name, :over_country, :real_altitude)';
1260 1260
 
1261
-		$query_values = array(':flightaware_id' => $flightaware_id,':ident' => $ident, ':registration' => $registration,':airline_name' => $airline_name,':airline_icao' => $airline_icao,':airline_country' => $airline_country,':airline_type' => $airline_type,':aircraft_icao' => $aircraft_icao,':aircraft_shadow' => $aircraft_shadow,':aircraft_type' => $aircraft_type,':aircraft_manufacturer' => $aircraft_manufacturer,':departure_airport_icao' => $departure_airport_icao,':departure_airport_name' => $departure_airport_name,':departure_airport_city' => $departure_airport_city,':departure_airport_country' => $departure_airport_country,':arrival_airport_icao' => $arrival_airport_icao,':arrival_airport_name' => $arrival_airport_name,':arrival_airport_city' => $arrival_airport_city,':arrival_airport_country' => $arrival_airport_country,':latitude' => $latitude,':longitude' => $longitude, ':waypoints' => $waypoints,':altitude' => $altitude,':heading' => $heading,':groundspeed' => $groundspeed,':date' => $date, ':departure_airport_time' => $departure_airport_time,':arrival_airport_time' => $arrival_airport_time, ':squawk' => $squawk,':route_stop' => $route_stop,':ModeS' => $ModeS, ':pilot_id' => $pilot_id, ':pilot_name' => $pilot_name, ':verticalrate' => $verticalrate, ':format_source' => $format_source,':ground' => $ground, ':source_name' => $source_name, ':over_country' => $over_country,':real_altitude' => $altitude_real);
1261
+		$query_values = array(':flightaware_id' => $flightaware_id, ':ident' => $ident, ':registration' => $registration, ':airline_name' => $airline_name, ':airline_icao' => $airline_icao, ':airline_country' => $airline_country, ':airline_type' => $airline_type, ':aircraft_icao' => $aircraft_icao, ':aircraft_shadow' => $aircraft_shadow, ':aircraft_type' => $aircraft_type, ':aircraft_manufacturer' => $aircraft_manufacturer, ':departure_airport_icao' => $departure_airport_icao, ':departure_airport_name' => $departure_airport_name, ':departure_airport_city' => $departure_airport_city, ':departure_airport_country' => $departure_airport_country, ':arrival_airport_icao' => $arrival_airport_icao, ':arrival_airport_name' => $arrival_airport_name, ':arrival_airport_city' => $arrival_airport_city, ':arrival_airport_country' => $arrival_airport_country, ':latitude' => $latitude, ':longitude' => $longitude, ':waypoints' => $waypoints, ':altitude' => $altitude, ':heading' => $heading, ':groundspeed' => $groundspeed, ':date' => $date, ':departure_airport_time' => $departure_airport_time, ':arrival_airport_time' => $arrival_airport_time, ':squawk' => $squawk, ':route_stop' => $route_stop, ':ModeS' => $ModeS, ':pilot_id' => $pilot_id, ':pilot_name' => $pilot_name, ':verticalrate' => $verticalrate, ':format_source' => $format_source, ':ground' => $ground, ':source_name' => $source_name, ':over_country' => $over_country, ':real_altitude' => $altitude_real);
1262 1262
 		try {
1263 1263
 			
1264 1264
 			$sth = $this->db->prepare($query);
1265 1265
 			$sth->execute($query_values);
1266 1266
 			$sth->closeCursor();
1267
-		} catch(PDOException $e) {
1267
+		} catch (PDOException $e) {
1268 1268
 			return "error : ".$e->getMessage();
1269 1269
 		}
1270 1270
 		if (isset($globalArchive) && $globalArchive && $putinarchive && $noarchive !== true) {
1271 1271
 		    if ($globalDebug) echo '(Add to SBS archive : ';
1272 1272
 		    $SpotterArchive = new SpotterArchive($this->db);
1273
-		    $result =  $SpotterArchive->addSpotterArchiveData($flightaware_id, $ident, $registration, $airline_name, $airline_icao, $airline_country, $airline_type, $aircraft_icao, $aircraft_shadow, $aircraft_name, $aircraft_manufacturer, $departure_airport_icao, $departure_airport_name, $departure_airport_city, $departure_airport_country, $departure_airport_time,$arrival_airport_icao, $arrival_airport_name, $arrival_airport_city, $arrival_airport_country, $arrival_airport_time, $route_stop, $date,$latitude, $longitude, $waypoints, $altitude, $altitude_real,$heading, $groundspeed, $squawk, $ModeS, $pilot_id, $pilot_name,$verticalrate,$format_source,$source_name, $over_country);
1273
+		    $result = $SpotterArchive->addSpotterArchiveData($flightaware_id, $ident, $registration, $airline_name, $airline_icao, $airline_country, $airline_type, $aircraft_icao, $aircraft_shadow, $aircraft_name, $aircraft_manufacturer, $departure_airport_icao, $departure_airport_name, $departure_airport_city, $departure_airport_country, $departure_airport_time, $arrival_airport_icao, $arrival_airport_name, $arrival_airport_city, $arrival_airport_country, $arrival_airport_time, $route_stop, $date, $latitude, $longitude, $waypoints, $altitude, $altitude_real, $heading, $groundspeed, $squawk, $ModeS, $pilot_id, $pilot_name, $verticalrate, $format_source, $source_name, $over_country);
1274 1274
 		    if ($globalDebug) echo $result.')';
1275 1275
 		} elseif ($globalDebug && $putinarchive !== true) {
1276 1276
 			echo '(Not adding to archive)';
@@ -1283,7 +1283,7 @@  discard block
 block discarded – undo
1283 1283
 
1284 1284
 	public function getOrderBy()
1285 1285
 	{
1286
-		$orderby = array("aircraft_asc" => array("key" => "aircraft_asc", "value" => "Aircraft Type - ASC", "sql" => "ORDER BY spotter_live.aircraft_icao ASC"), "aircraft_desc" => array("key" => "aircraft_desc", "value" => "Aircraft Type - DESC", "sql" => "ORDER BY spotter_live.aircraft_icao DESC"),"manufacturer_asc" => array("key" => "manufacturer_asc", "value" => "Aircraft Manufacturer - ASC", "sql" => "ORDER BY spotter_live.aircraft_manufacturer ASC"), "manufacturer_desc" => array("key" => "manufacturer_desc", "value" => "Aircraft Manufacturer - DESC", "sql" => "ORDER BY spotter_live.aircraft_manufacturer DESC"),"airline_name_asc" => array("key" => "airline_name_asc", "value" => "Airline Name - ASC", "sql" => "ORDER BY spotter_live.airline_name ASC"), "airline_name_desc" => array("key" => "airline_name_desc", "value" => "Airline Name - DESC", "sql" => "ORDER BY spotter_live.airline_name DESC"), "ident_asc" => array("key" => "ident_asc", "value" => "Ident - ASC", "sql" => "ORDER BY spotter_live.ident ASC"), "ident_desc" => array("key" => "ident_desc", "value" => "Ident - DESC", "sql" => "ORDER BY spotter_live.ident DESC"), "airport_departure_asc" => array("key" => "airport_departure_asc", "value" => "Departure Airport - ASC", "sql" => "ORDER BY spotter_live.departure_airport_city ASC"), "airport_departure_desc" => array("key" => "airport_departure_desc", "value" => "Departure Airport - DESC", "sql" => "ORDER BY spotter_live.departure_airport_city DESC"), "airport_arrival_asc" => array("key" => "airport_arrival_asc", "value" => "Arrival Airport - ASC", "sql" => "ORDER BY spotter_live.arrival_airport_city ASC"), "airport_arrival_desc" => array("key" => "airport_arrival_desc", "value" => "Arrival Airport - DESC", "sql" => "ORDER BY spotter_live.arrival_airport_city DESC"), "date_asc" => array("key" => "date_asc", "value" => "Date - ASC", "sql" => "ORDER BY spotter_live.date ASC"), "date_desc" => array("key" => "date_desc", "value" => "Date - DESC", "sql" => "ORDER BY spotter_live.date DESC"));
1286
+		$orderby = array("aircraft_asc" => array("key" => "aircraft_asc", "value" => "Aircraft Type - ASC", "sql" => "ORDER BY spotter_live.aircraft_icao ASC"), "aircraft_desc" => array("key" => "aircraft_desc", "value" => "Aircraft Type - DESC", "sql" => "ORDER BY spotter_live.aircraft_icao DESC"), "manufacturer_asc" => array("key" => "manufacturer_asc", "value" => "Aircraft Manufacturer - ASC", "sql" => "ORDER BY spotter_live.aircraft_manufacturer ASC"), "manufacturer_desc" => array("key" => "manufacturer_desc", "value" => "Aircraft Manufacturer - DESC", "sql" => "ORDER BY spotter_live.aircraft_manufacturer DESC"), "airline_name_asc" => array("key" => "airline_name_asc", "value" => "Airline Name - ASC", "sql" => "ORDER BY spotter_live.airline_name ASC"), "airline_name_desc" => array("key" => "airline_name_desc", "value" => "Airline Name - DESC", "sql" => "ORDER BY spotter_live.airline_name DESC"), "ident_asc" => array("key" => "ident_asc", "value" => "Ident - ASC", "sql" => "ORDER BY spotter_live.ident ASC"), "ident_desc" => array("key" => "ident_desc", "value" => "Ident - DESC", "sql" => "ORDER BY spotter_live.ident DESC"), "airport_departure_asc" => array("key" => "airport_departure_asc", "value" => "Departure Airport - ASC", "sql" => "ORDER BY spotter_live.departure_airport_city ASC"), "airport_departure_desc" => array("key" => "airport_departure_desc", "value" => "Departure Airport - DESC", "sql" => "ORDER BY spotter_live.departure_airport_city DESC"), "airport_arrival_asc" => array("key" => "airport_arrival_asc", "value" => "Arrival Airport - ASC", "sql" => "ORDER BY spotter_live.arrival_airport_city ASC"), "airport_arrival_desc" => array("key" => "airport_arrival_desc", "value" => "Arrival Airport - DESC", "sql" => "ORDER BY spotter_live.arrival_airport_city DESC"), "date_asc" => array("key" => "date_asc", "value" => "Date - ASC", "sql" => "ORDER BY spotter_live.date ASC"), "date_desc" => array("key" => "date_desc", "value" => "Date - DESC", "sql" => "ORDER BY spotter_live.date DESC"));
1287 1287
 		return $orderby;
1288 1288
 	}
1289 1289
 
Please login to merge, or discard this patch.
Braces   +161 added lines, -54 removed lines patch added patch discarded remove patch
@@ -8,7 +8,9 @@  discard block
 block discarded – undo
8 8
 	public function __construct($dbc = null) {
9 9
 		$Connection = new Connection($dbc);
10 10
 		$this->db = $Connection->db();
11
-		if ($this->db === null) die('Error: No DB connection. (SpotterLive)');
11
+		if ($this->db === null) {
12
+			die('Error: No DB connection. (SpotterLive)');
13
+		}
12 14
 	}
13 15
 
14 16
 
@@ -30,7 +32,9 @@  discard block
 block discarded – undo
30 32
 		if (isset($filter[0]['source'])) {
31 33
 			$filters = array_merge($filters,$filter);
32 34
 		}
33
-		if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter);
35
+		if (is_array($globalFilter)) {
36
+			$filter = array_merge($filter,$globalFilter);
37
+		}
34 38
 		$filter_query_join = '';
35 39
 		$filter_query_where = '';
36 40
 		foreach($filters as $flt) {
@@ -126,8 +130,11 @@  discard block
 block discarded – undo
126 130
 		if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) {
127 131
 			$filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')";
128 132
 		}
129
-		if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE';
130
-		elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND';
133
+		if ($filter_query_where == '' && $where) {
134
+			$filter_query_where = ' WHERE';
135
+		} elseif ($filter_query_where != '' && $and) {
136
+			$filter_query_where .= ' AND';
137
+		}
131 138
 		if ($filter_query_where != '') {
132 139
 			$filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where);
133 140
 		}
@@ -168,9 +175,13 @@  discard block
 block discarded – undo
168 175
 				$orderby_query = ' '.$search_orderby_array[$sort]['sql'];
169 176
 			}
170 177
 		}
171
-		if ($orderby_query == '') $orderby_query = ' ORDER BY date DESC';
178
+		if ($orderby_query == '') {
179
+			$orderby_query = ' ORDER BY date DESC';
180
+		}
172 181
 
173
-		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
182
+		if (!isset($globalLiveInterval)) {
183
+			$globalLiveInterval = '200';
184
+		}
174 185
 		if ($globalDBdriver == 'mysql') {
175 186
 			//$query  = "SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL 30 SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate";
176 187
 			$query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate'.$filter_query.$orderby_query;
@@ -193,7 +204,9 @@  discard block
 block discarded – undo
193 204
 		global $globalDBdriver, $globalLiveInterval, $globalArchive;
194 205
 		date_default_timezone_set('UTC');
195 206
 		$filter_query = $this->getFilter($filter,true,true);
196
-		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
207
+		if (!isset($globalLiveInterval)) {
208
+			$globalLiveInterval = '200';
209
+		}
197 210
 		if ($globalDBdriver == 'mysql') {
198 211
 			if (isset($globalArchive) && $globalArchive === TRUE) {
199 212
 				$query  = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.real_altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
@@ -244,8 +257,12 @@  discard block
 block discarded – undo
244 257
 		$id = filter_var($id,FILTER_SANITIZE_STRING);
245 258
 		$filter_query = $this->getFilter($filter,true,true);
246 259
 
247
-		if (!isset($globalLiveInterval) || $globalLiveInterval == '') $globalLiveInterval = '200';
248
-		if (!isset($globalMap3DAircraftsLimit) || $globalMap3DAircraftsLimit == '') $globalMap3DAircraftsLimit = '300';
260
+		if (!isset($globalLiveInterval) || $globalLiveInterval == '') {
261
+			$globalLiveInterval = '200';
262
+		}
263
+		if (!isset($globalMap3DAircraftsLimit) || $globalMap3DAircraftsLimit == '') {
264
+			$globalMap3DAircraftsLimit = '300';
265
+		}
249 266
 		if ($globalDBdriver == 'mysql') {
250 267
 			if (isset($globalArchive) && $globalArchive === TRUE) {
251 268
 				/*
@@ -256,25 +273,41 @@  discard block
 block discarded – undo
256 273
 				*/
257 274
 				$query  = 'SELECT * FROM (SELECT spotter_archive.ident, spotter_archive.flightaware_id, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, spotter_archive.date, spotter_archive.format_source, spotter_archive.registration 
258 275
 				FROM spotter_archive INNER JOIN (SELECT flightaware_id FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date) l ON l.flightaware_id = spotter_archive.flightaware_id ";
259
-				if ($usecoord) $query .= "AND (spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong.") ";
260
-				if ($id != '') $query .= "OR spotter_archive.flightaware_id = :id ";
276
+				if ($usecoord) {
277
+					$query .= "AND (spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong.") ";
278
+				}
279
+				if ($id != '') {
280
+					$query .= "OR spotter_archive.flightaware_id = :id ";
281
+				}
261 282
 				$query .= "UNION
262 283
 				SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
263 284
 				FROM spotter_live".$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date";
264
-				if ($usecoord) $query .= " AND (spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong.")";
265
-				if ($id != '') $query .= " OR spotter_live.flightaware_id = :id";
285
+				if ($usecoord) {
286
+					$query .= " AND (spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong.")";
287
+				}
288
+				if ($id != '') {
289
+					$query .= " OR spotter_live.flightaware_id = :id";
290
+				}
266 291
 				$query .= ") AS spotter 
267 292
 				WHERE latitude <> '0' AND longitude <> '0' 
268 293
 				ORDER BY flightaware_id, date";
269
-				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
294
+				if ($limit) {
295
+					$query .= " LIMIT ".$globalMap3DAircraftsLimit;
296
+				}
270 297
 			} else {
271 298
 				$query  = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
272 299
 				FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date ";
273
-				if ($usecoord) $query .= "AND (spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong.") ";
274
-				if ($id != '') $query .= "OR spotter_live.flightaware_id = :id ";
300
+				if ($usecoord) {
301
+					$query .= "AND (spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong.") ";
302
+				}
303
+				if ($id != '') {
304
+					$query .= "OR spotter_live.flightaware_id = :id ";
305
+				}
275 306
 				$query .= "AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' 
276 307
 				ORDER BY spotter_live.flightaware_id, spotter_live.date";
277
-				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
308
+				if ($limit) {
309
+					$query .= " LIMIT ".$globalMap3DAircraftsLimit;
310
+				}
278 311
 			}
279 312
 		} else {
280 313
 			if (isset($globalArchive) && $globalArchive === TRUE) {
@@ -291,28 +324,46 @@  discard block
 block discarded – undo
291 324
 				    SELECT flightaware_id 
292 325
 				    FROM spotter_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date";
293 326
 				$query.= ") l ON l.flightaware_id = spotter_archive.flightaware_id ";
294
-				if ($usecoord) $query .= "AND (spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong.") ";
295
-				if ($id != '') $query .= "OR spotter_archive.flightaware_id = :id ";
327
+				if ($usecoord) {
328
+					$query .= "AND (spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong.") ";
329
+				}
330
+				if ($id != '') {
331
+					$query .= "OR spotter_archive.flightaware_id = :id ";
332
+				}
296 333
 				$query .= "UNION
297 334
 				    SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
298 335
 				    FROM spotter_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date";
299
-				if ($usecoord) $query .= " AND (spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong.")";
300
-				if ($id != '') $query .= " OR spotter_live.flightaware_id = :id";
336
+				if ($usecoord) {
337
+					$query .= " AND (spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong.")";
338
+				}
339
+				if ($id != '') {
340
+					$query .= " OR spotter_live.flightaware_id = :id";
341
+				}
301 342
 				$query .= ") AS spotter WHERE latitude <> '0' AND longitude <> '0' ";
302 343
 				$query .= "ORDER BY flightaware_id, date";
303
-				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
344
+				if ($limit) {
345
+					$query .= " LIMIT ".$globalMap3DAircraftsLimit;
346
+				}
304 347
 			} else {
305 348
 				$query  = "SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
306 349
 				FROM spotter_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date ";
307
-				if ($usecoord) $query .= "AND (spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong.") ";
308
-				if ($id != '') $query .= "OR spotter_live.flightaware_id = :id ";
350
+				if ($usecoord) {
351
+					$query .= "AND (spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong.") ";
352
+				}
353
+				if ($id != '') {
354
+					$query .= "OR spotter_live.flightaware_id = :id ";
355
+				}
309 356
 				$query .= "AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' 
310 357
 				ORDER BY spotter_live.flightaware_id, spotter_live.date";
311
-				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
358
+				if ($limit) {
359
+					$query .= " LIMIT ".$globalMap3DAircraftsLimit;
360
+				}
312 361
 			}
313 362
 		}
314 363
 		$query_values = array();
315
-		if ($id != '') $query_values = array(':id' => $id);
364
+		if ($id != '') {
365
+			$query_values = array(':id' => $id);
366
+		}
316 367
 		try {
317 368
 			$sth = $this->db->prepare($query);
318 369
 			$sth->execute($query_values);
@@ -337,8 +388,12 @@  discard block
 block discarded – undo
337 388
 		$id = filter_var($id,FILTER_SANITIZE_STRING);
338 389
 		$filter_query = $this->getFilter($filter,true,true);
339 390
 
340
-		if (!isset($globalLiveInterval) || $globalLiveInterval == '') $globalLiveInterval = '200';
341
-		if (!isset($globalMap3DAircraftsLimit) || $globalMap3DAircraftsLimit == '') $globalMap3DAircraftsLimit = '300';
391
+		if (!isset($globalLiveInterval) || $globalLiveInterval == '') {
392
+			$globalLiveInterval = '200';
393
+		}
394
+		if (!isset($globalMap3DAircraftsLimit) || $globalMap3DAircraftsLimit == '') {
395
+			$globalMap3DAircraftsLimit = '300';
396
+		}
342 397
 		if ($globalDBdriver == 'mysql') {
343 398
 			if (isset($globalArchive) && $globalArchive === TRUE) {
344 399
 				$query  = 'SELECT * FROM (SELECT spotter_archive.ident, spotter_archive.flightaware_id, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, spotter_archive.date, spotter_archive.format_source, spotter_archive.registration 
@@ -349,13 +404,17 @@  discard block
 block discarded – undo
349 404
 				$query .= ") AS spotter 
350 405
 				WHERE latitude <> '0' AND longitude <> '0' 
351 406
 				ORDER BY flightaware_id, date";
352
-				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
407
+				if ($limit) {
408
+					$query .= " LIMIT ".$globalMap3DAircraftsLimit;
409
+				}
353 410
 			} else {
354 411
 				$query  = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
355 412
 				FROM spotter_live'.$filter_query.' spotter_live.flightaware_id = :id ';
356 413
 				$query .= "AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' 
357 414
 				ORDER BY spotter_live.flightaware_id, spotter_live.date";
358
-				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
415
+				if ($limit) {
416
+					$query .= " LIMIT ".$globalMap3DAircraftsLimit;
417
+				}
359 418
 			}
360 419
 		} else {
361 420
 			if (isset($globalArchive) && $globalArchive === TRUE) {
@@ -371,13 +430,17 @@  discard block
 block discarded – undo
371 430
 				    FROM spotter_live".$filter_query." spotter_live.flightaware_id = :id";
372 431
 				$query .= ") AS spotter WHERE latitude <> '0' AND longitude <> '0' ";
373 432
 				$query .= "ORDER BY flightaware_id, date";
374
-				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
433
+				if ($limit) {
434
+					$query .= " LIMIT ".$globalMap3DAircraftsLimit;
435
+				}
375 436
 			} else {
376 437
 				$query  = "SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
377 438
 				FROM spotter_live".$filter_query." spotter_live.flightaware_id = :id ";
378 439
 				$query .= "AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' 
379 440
 				ORDER BY spotter_live.flightaware_id, spotter_live.date";
380
-				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
441
+				if ($limit) {
442
+					$query .= " LIMIT ".$globalMap3DAircraftsLimit;
443
+				}
381 444
 			}
382 445
 		}
383 446
 		$query_values = array();
@@ -404,7 +467,9 @@  discard block
 block discarded – undo
404 467
 		global $globalDBdriver, $globalLiveInterval;
405 468
 		$filter_query = $this->getFilter($filter,true,true);
406 469
 
407
-		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
470
+		if (!isset($globalLiveInterval)) {
471
+			$globalLiveInterval = '200';
472
+		}
408 473
 		if ($globalDBdriver == 'mysql') {
409 474
 			//$query  = 'SELECT COUNT(*) as nb FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate'.$filter_query;
410 475
 			$query = 'SELECT COUNT(DISTINCT spotter_live.flightaware_id) as nb FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date';
@@ -434,7 +499,9 @@  discard block
 block discarded – undo
434 499
 	{
435 500
 		global $globalDBdriver, $globalLiveInterval;
436 501
 		$Spotter = new Spotter($this->db);
437
-		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
502
+		if (!isset($globalLiveInterval)) {
503
+			$globalLiveInterval = '200';
504
+		}
438 505
 		$filter_query = $this->getFilter($filter);
439 506
 
440 507
 		if (is_array($coord)) {
@@ -442,7 +509,9 @@  discard block
 block discarded – undo
442 509
 			$minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
443 510
 			$maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
444 511
 			$maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
445
-		} else return array();
512
+		} else {
513
+			return array();
514
+		}
446 515
 		if ($globalDBdriver == 'mysql') {
447 516
 			$query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate AND spotter_live.latitude BETWEEN '.$minlat.' AND '.$maxlat.' AND spotter_live.longitude BETWEEN '.$minlong.' AND '.$maxlong.' GROUP BY spotter_live.flightaware_id'.$filter_query;
448 517
 		} else {
@@ -463,7 +532,9 @@  discard block
 block discarded – undo
463 532
 	{
464 533
 		global $globalDBdriver, $globalLiveInterval, $globalArchive;
465 534
 		$Spotter = new Spotter($this->db);
466
-		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
535
+		if (!isset($globalLiveInterval)) {
536
+			$globalLiveInterval = '200';
537
+		}
467 538
 		$filter_query = $this->getFilter($filter,true,true);
468 539
 
469 540
 		if (is_array($coord)) {
@@ -471,7 +542,9 @@  discard block
 block discarded – undo
471 542
 			$minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
472 543
 			$maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
473 544
 			$maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
474
-		} else return array();
545
+		} else {
546
+			return array();
547
+		}
475 548
 		if ($globalDBdriver == 'mysql') {
476 549
 			if (isset($globalArchive) && $globalArchive === TRUE) {
477 550
 				$query  = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.real_altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source, spotter_live.registration 
@@ -698,11 +771,15 @@  discard block
 block discarded – undo
698 771
 		//$query  = self::$global_query.' WHERE spotter_live.flightaware_id = :id ORDER BY date';
699 772
 		if ($globalDBdriver == 'mysql') {
700 773
 			$query = 'SELECT spotter_live.* FROM spotter_live WHERE spotter_live.flightaware_id = :id';
701
-			if ($liveinterval) $query .= ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date';
774
+			if ($liveinterval) {
775
+				$query .= ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date';
776
+			}
702 777
 			$query .= ' ORDER BY date';
703 778
 		} else {
704 779
 			$query = 'SELECT spotter_live.* FROM spotter_live WHERE spotter_live.flightaware_id = :id';
705
-			if ($liveinterval) $query .= " AND CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= date";
780
+			if ($liveinterval) {
781
+				$query .= " AND CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= date";
782
+			}
706 783
 			$query .= ' ORDER BY date';
707 784
 		}
708 785
 
@@ -797,7 +874,9 @@  discard block
 block discarded – undo
797 874
 				$i++;
798 875
 				$j++;
799 876
 				if ($j == 30) {
800
-					if ($globalDebug) echo ".";
877
+					if ($globalDebug) {
878
+						echo ".";
879
+					}
801 880
 				    	try {
802 881
 						
803 882
 						$sth = $this->db->prepare(substr($query_delete,0,-1).")");
@@ -1150,7 +1229,9 @@  discard block
 block discarded – undo
1150 1229
 			{
1151 1230
 				return false;
1152 1231
 			}
1153
-		} else return '';
1232
+		} else {
1233
+			return '';
1234
+		}
1154 1235
 
1155 1236
 		if ($longitude != '')
1156 1237
 		{
@@ -1158,7 +1239,9 @@  discard block
 block discarded – undo
1158 1239
 			{
1159 1240
 				return false;
1160 1241
 			}
1161
-		} else return '';
1242
+		} else {
1243
+			return '';
1244
+		}
1162 1245
 
1163 1246
 		if ($waypoints != '')
1164 1247
 		{
@@ -1174,14 +1257,18 @@  discard block
 block discarded – undo
1174 1257
 			{
1175 1258
 				return false;
1176 1259
 			}
1177
-		} else $altitude = 0;
1260
+		} else {
1261
+			$altitude = 0;
1262
+		}
1178 1263
 		if ($altitude_real != '')
1179 1264
 		{
1180 1265
 			if (!is_numeric($altitude_real))
1181 1266
 			{
1182 1267
 				return false;
1183 1268
 			}
1184
-		} else $altitude_real = 0;
1269
+		} else {
1270
+			$altitude_real = 0;
1271
+		}
1185 1272
 
1186 1273
 		if ($heading != '')
1187 1274
 		{
@@ -1189,7 +1276,9 @@  discard block
 block discarded – undo
1189 1276
 			{
1190 1277
 				return false;
1191 1278
 			}
1192
-		} else $heading = 0;
1279
+		} else {
1280
+			$heading = 0;
1281
+		}
1193 1282
 
1194 1283
 		if ($groundspeed != '')
1195 1284
 		{
@@ -1197,9 +1286,13 @@  discard block
 block discarded – undo
1197 1286
 			{
1198 1287
 				return false;
1199 1288
 			}
1200
-		} else $groundspeed = 0;
1289
+		} else {
1290
+			$groundspeed = 0;
1291
+		}
1201 1292
 		date_default_timezone_set('UTC');
1202
-		if ($date == '') $date = date("Y-m-d H:i:s", time());
1293
+		if ($date == '') {
1294
+			$date = date("Y-m-d H:i:s", time());
1295
+		}
1203 1296
 
1204 1297
         
1205 1298
 		$flightaware_id = filter_var($flightaware_id,FILTER_SANITIZE_STRING);
@@ -1244,14 +1337,24 @@  discard block
 block discarded – undo
1244 1337
 		$arrival_airport_country = '';
1245 1338
 		
1246 1339
             	
1247
-            	if ($squawk == '' || $Common->isInteger($squawk) === false ) $squawk = NULL;
1248
-            	if ($verticalrate == '' || $Common->isInteger($verticalrate) === false ) $verticalrate = NULL;
1249
-            	if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) $groundspeed = 0;
1250
-            	if ($heading == '' || $Common->isInteger($heading) === false ) $heading = 0;
1340
+            	if ($squawk == '' || $Common->isInteger($squawk) === false ) {
1341
+            		$squawk = NULL;
1342
+            	}
1343
+            	if ($verticalrate == '' || $Common->isInteger($verticalrate) === false ) {
1344
+            		$verticalrate = NULL;
1345
+            	}
1346
+            	if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) {
1347
+            		$groundspeed = 0;
1348
+            	}
1349
+            	if ($heading == '' || $Common->isInteger($heading) === false ) {
1350
+            		$heading = 0;
1351
+            	}
1251 1352
 		
1252 1353
 		$query = '';
1253 1354
 		if ($globalArchive) {
1254
-			if ($globalDebug) echo '-- Delete previous data -- ';
1355
+			if ($globalDebug) {
1356
+				echo '-- Delete previous data -- ';
1357
+			}
1255 1358
 			$query .= 'DELETE FROM spotter_live WHERE flightaware_id = :flightaware_id;';
1256 1359
 		}
1257 1360
 
@@ -1268,10 +1371,14 @@  discard block
 block discarded – undo
1268 1371
 			return "error : ".$e->getMessage();
1269 1372
 		}
1270 1373
 		if (isset($globalArchive) && $globalArchive && $putinarchive && $noarchive !== true) {
1271
-		    if ($globalDebug) echo '(Add to SBS archive : ';
1374
+		    if ($globalDebug) {
1375
+		    	echo '(Add to SBS archive : ';
1376
+		    }
1272 1377
 		    $SpotterArchive = new SpotterArchive($this->db);
1273 1378
 		    $result =  $SpotterArchive->addSpotterArchiveData($flightaware_id, $ident, $registration, $airline_name, $airline_icao, $airline_country, $airline_type, $aircraft_icao, $aircraft_shadow, $aircraft_name, $aircraft_manufacturer, $departure_airport_icao, $departure_airport_name, $departure_airport_city, $departure_airport_country, $departure_airport_time,$arrival_airport_icao, $arrival_airport_name, $arrival_airport_city, $arrival_airport_country, $arrival_airport_time, $route_stop, $date,$latitude, $longitude, $waypoints, $altitude, $altitude_real,$heading, $groundspeed, $squawk, $ModeS, $pilot_id, $pilot_name,$verticalrate,$format_source,$source_name, $over_country);
1274
-		    if ($globalDebug) echo $result.')';
1379
+		    if ($globalDebug) {
1380
+		    	echo $result.')';
1381
+		    }
1275 1382
 		} elseif ($globalDebug && $putinarchive !== true) {
1276 1383
 			echo '(Not adding to archive)';
1277 1384
 		} elseif ($globalDebug && $noarchive === true) {
Please login to merge, or discard this patch.
index.php 1 patch
Braces   +570 added lines, -144 removed lines patch added patch discarded remove patch
@@ -57,7 +57,10 @@  discard block
 block discarded – undo
57 57
 <?php
58 58
     if ((!isset($_COOKIE['MapFormat']) && isset($globalMap3Ddefault) && $globalMap3Ddefault) || (isset($_COOKIE['MapFormat']) && $_COOKIE['MapFormat'] == '3d')) {
59 59
 ?>
60
-<script src="<?php echo $globalURL; ?>/js/map.3d.js.php<?php if (isset($tsk)) print '?tsk='.$tsk; ?>"></script>
60
+<script src="<?php echo $globalURL; ?>/js/map.3d.js.php<?php if (isset($tsk)) {
61
+	print '?tsk='.$tsk;
62
+}
63
+?>"></script>
61 64
 <?php
62 65
 	if (!isset($globalAircraft) || $globalAircraft) {
63 66
 ?>
@@ -135,9 +138,18 @@  discard block
 block discarded – undo
135 138
 			<h1>Weather</h1>
136 139
 			<ul>
137 140
 			
138
-				<li><div class="checkbox"><label><input type="checkbox" name="wind" value="1" onclick="clickWind(this);" <?php if (isset($_COOKIE['weather_wind']) && $_COOKIE['weather_wind'] == 'true') print 'checked'; ?> /><?php echo _("Weather Winds"); ?></label></div></li>
139
-				<li><div class="checkbox"><label><input type="checkbox" name="wave" value="1" onclick="clickWave(this);" <?php if (isset($_COOKIE['weather_wave']) && $_COOKIE['weather_wave'] == 'true') print 'checked'; ?> /><?php echo _("Ocean surface currents"); ?></label></div></li>
140
-				<!-- <li><div class="checkbox"><label><input type="checkbox" name="backwave" value="1" onclick="clickBackWave(this);" <?php if (isset($_COOKIE['weather_backwave']) && $_COOKIE['weather_backwave'] == 'true') print 'checked'; ?> /><?php echo _("Weather Waves height background"); ?></label></div></li> -->
141
+				<li><div class="checkbox"><label><input type="checkbox" name="wind" value="1" onclick="clickWind(this);" <?php if (isset($_COOKIE['weather_wind']) && $_COOKIE['weather_wind'] == 'true') {
142
+	print 'checked';
143
+}
144
+?> /><?php echo _("Weather Winds"); ?></label></div></li>
145
+				<li><div class="checkbox"><label><input type="checkbox" name="wave" value="1" onclick="clickWave(this);" <?php if (isset($_COOKIE['weather_wave']) && $_COOKIE['weather_wave'] == 'true') {
146
+	print 'checked';
147
+}
148
+?> /><?php echo _("Ocean surface currents"); ?></label></div></li>
149
+				<!-- <li><div class="checkbox"><label><input type="checkbox" name="backwave" value="1" onclick="clickBackWave(this);" <?php if (isset($_COOKIE['weather_backwave']) && $_COOKIE['weather_backwave'] == 'true') {
150
+	print 'checked';
151
+}
152
+?> /><?php echo _("Weather Waves height background"); ?></label></div></li> -->
141 153
 			
142 154
 <?php
143 155
 		if (isset($globalOpenWeatherMapKey) && $globalOpenWeatherMapKey != '') {
@@ -156,7 +168,10 @@  discard block
 block discarded – undo
156 168
 ?>
157 169
 			<h1>Weather</h1>
158 170
 			<ul>
159
-				<li><div class="checkbox"><label><input type="checkbox" name="displayweather" value="1" onclick="clickDisplayWeather(this)" <?php if ((isset($_COOKIE['show_Weather']) && $_COOKIE['show_Weather'] == 'true') || (!isset($_COOKIE['show_Weather']) && (isset($globalMapWeather) && $globalMapWeather === TRUE))) print 'checked'; ?> ><?php echo _("Display weather on 3D map"); ?></label></div></li>
171
+				<li><div class="checkbox"><label><input type="checkbox" name="displayweather" value="1" onclick="clickDisplayWeather(this)" <?php if ((isset($_COOKIE['show_Weather']) && $_COOKIE['show_Weather'] == 'true') || (!isset($_COOKIE['show_Weather']) && (isset($globalMapWeather) && $globalMapWeather === TRUE))) {
172
+	print 'checked';
173
+}
174
+?> ><?php echo _("Display weather on 3D map"); ?></label></div></li>
160 175
 			</ul>
161 176
 <?php
162 177
 	}
@@ -173,13 +188,22 @@  discard block
 block discarded – undo
173 188
 <?php
174 189
 		if (!isset($globalAircraft) || $globalAircraft) {
175 190
 ?>
176
-				<li><div class="checkbox"><label><input type="checkbox" name="waypoints" value="1" onclick="showWaypoints(this);" <?php if (isset($_COOKIE['waypoints']) && $_COOKIE['waypoints'] == 'true') print 'checked'; ?> /><?php echo _("Display waypoints"); ?></label></div></li>
177
-				<li><div class="checkbox"><label><input type="checkbox" name="airspace" value="1" onclick="showAirspace(this);" <?php if (isset($_COOKIE['airspace']) && $_COOKIE['airspace'] == 'true') print 'checked'; ?> /><?php echo _("Display airspace"); ?></label></div></li>
191
+				<li><div class="checkbox"><label><input type="checkbox" name="waypoints" value="1" onclick="showWaypoints(this);" <?php if (isset($_COOKIE['waypoints']) && $_COOKIE['waypoints'] == 'true') {
192
+	print 'checked';
193
+}
194
+?> /><?php echo _("Display waypoints"); ?></label></div></li>
195
+				<li><div class="checkbox"><label><input type="checkbox" name="airspace" value="1" onclick="showAirspace(this);" <?php if (isset($_COOKIE['airspace']) && $_COOKIE['airspace'] == 'true') {
196
+	print 'checked';
197
+}
198
+?> /><?php echo _("Display airspace"); ?></label></div></li>
178 199
 <?php
179 200
 		}
180 201
 		if (isset($globalMarine) && $globalMarine) {
181 202
 ?>
182
-				<li><div class="checkbox"><label><input type="checkbox" name="openseamap" value="1" onclick="clickOpenSeaMap(this);" <?php if (isset($_COOKIE['openseamap']) && $_COOKIE['openseamap'] == 'true') print 'checked'; ?> /><?php echo _("Display OpenSeaMap"); ?></label></div></li>
203
+				<li><div class="checkbox"><label><input type="checkbox" name="openseamap" value="1" onclick="clickOpenSeaMap(this);" <?php if (isset($_COOKIE['openseamap']) && $_COOKIE['openseamap'] == 'true') {
204
+	print 'checked';
205
+}
206
+?> /><?php echo _("Display OpenSeaMap"); ?></label></div></li>
183 207
 <?php
184 208
 		}
185 209
 ?>
@@ -194,13 +218,22 @@  discard block
 block discarded – undo
194 218
 <?php
195 219
 		if (!isset($globalAircraft) || $globalAircraft) {
196 220
 ?>
197
-				<li><div class="checkbox"><label><input type="checkbox" name="waypoints" value="1" onclick="showWaypoints(this);" <?php if (isset($_COOKIE['waypoints']) && $_COOKIE['waypoints'] == 'true') print 'checked'; ?> /><?php echo _("Display waypoints"); ?> Beta</label></div></li>
198
-				<li><div class="checkbox"><label><input type="checkbox" name="airspace" value="1" onclick="showAirspace(this);" <?php if (isset($_COOKIE['airspace']) && $_COOKIE['airspace'] == 'true') print 'checked'; ?> /><?php echo _("Display airspace"); ?> Beta</label></div></li>
221
+				<li><div class="checkbox"><label><input type="checkbox" name="waypoints" value="1" onclick="showWaypoints(this);" <?php if (isset($_COOKIE['waypoints']) && $_COOKIE['waypoints'] == 'true') {
222
+	print 'checked';
223
+}
224
+?> /><?php echo _("Display waypoints"); ?> Beta</label></div></li>
225
+				<li><div class="checkbox"><label><input type="checkbox" name="airspace" value="1" onclick="showAirspace(this);" <?php if (isset($_COOKIE['airspace']) && $_COOKIE['airspace'] == 'true') {
226
+	print 'checked';
227
+}
228
+?> /><?php echo _("Display airspace"); ?> Beta</label></div></li>
199 229
 <?php
200 230
 		}
201 231
 		if (isset($globalMarine) && $globalMarine) {
202 232
 ?>
203
-				<li><div class="checkbox"><label><input type="checkbox" name="openseamap" value="1" onclick="clickOpenSeaMap(this);" <?php if (isset($_COOKIE['openseamap']) && $_COOKIE['openseamap'] == 'true') print 'checked'; ?> /><?php echo _("Display OpenSeaMap"); ?></label></div></li>
233
+				<li><div class="checkbox"><label><input type="checkbox" name="openseamap" value="1" onclick="clickOpenSeaMap(this);" <?php if (isset($_COOKIE['openseamap']) && $_COOKIE['openseamap'] == 'true') {
234
+	print 'checked';
235
+}
236
+?> /><?php echo _("Display OpenSeaMap"); ?></label></div></li>
204 237
 <?php
205 238
 		}
206 239
 ?>
@@ -215,14 +248,32 @@  discard block
 block discarded – undo
215 248
 		<h1>NOTAM</h1>
216 249
 		<form>
217 250
 			<ul>
218
-				<li><div class="checkbox"><label><input type="checkbox" name="notamcb" value="1" onclick="showNotam(this);" <?php if (isset($_COOKIE['notam']) && $_COOKIE['notam'] == 'true') print 'checked'; ?> /><?php echo _("Display NOTAM"); ?></label></div></li>
251
+				<li><div class="checkbox"><label><input type="checkbox" name="notamcb" value="1" onclick="showNotam(this);" <?php if (isset($_COOKIE['notam']) && $_COOKIE['notam'] == 'true') {
252
+	print 'checked';
253
+}
254
+?> /><?php echo _("Display NOTAM"); ?></label></div></li>
219 255
 				<li><?php echo _("NOTAM scope:"); ?>
220 256
 					<select class="selectpicker" onchange="notamscope(this);">
221
-						<option<?php if (!isset($_COOKIE['notamscope']) || $_COOKIE['notamscope'] == 'All') print ' selected'; ?>>All</option>
222
-						<option<?php if (isset($_COOKIE['notamscope']) && $_COOKIE['notamscope'] == 'Airport/Enroute warning') print ' selected'; ?>>Airport/Enroute warning</option>
223
-						<option<?php if (isset($_COOKIE['notamscope']) && $_COOKIE['notamscope'] == 'Airport warning') print ' selected'; ?>>Airport warning</option>
224
-						<option<?php if (isset($_COOKIE['notamscope']) && $_COOKIE['notamscope'] == 'Navigation warning') print ' selected'; ?>>Navigation warning</option>
225
-						<option<?php if (isset($_COOKIE['notamscope']) && $_COOKIE['notamscope'] == 'Enroute warning') print ' selected'; ?>>Enroute warning</option>
257
+						<option<?php if (!isset($_COOKIE['notamscope']) || $_COOKIE['notamscope'] == 'All') {
258
+	print ' selected';
259
+}
260
+?>>All</option>
261
+						<option<?php if (isset($_COOKIE['notamscope']) && $_COOKIE['notamscope'] == 'Airport/Enroute warning') {
262
+	print ' selected';
263
+}
264
+?>>Airport/Enroute warning</option>
265
+						<option<?php if (isset($_COOKIE['notamscope']) && $_COOKIE['notamscope'] == 'Airport warning') {
266
+	print ' selected';
267
+}
268
+?>>Airport warning</option>
269
+						<option<?php if (isset($_COOKIE['notamscope']) && $_COOKIE['notamscope'] == 'Navigation warning') {
270
+	print ' selected';
271
+}
272
+?>>Navigation warning</option>
273
+						<option<?php if (isset($_COOKIE['notamscope']) && $_COOKIE['notamscope'] == 'Enroute warning') {
274
+	print ' selected';
275
+}
276
+?>>Enroute warning</option>
226 277
 					</select
227 278
 				</li>
228 279
 			</ul>
@@ -250,7 +301,10 @@  discard block
 block discarded – undo
250 301
 		    <div class="form-group">
251 302
 			<label><?php echo _("From:"); ?></label>
252 303
 			<div class='input-group date' id='datetimepicker1'>
253
-			    <input type='text' id="start_date" name="start_date" class="form-control" autocomplete="off" value="<?php if (isset($_COOKIE['archive_begin']) && $_COOKIE['archive_begin'] != '') print date("Y-m-d H:i",$_COOKIE['archive_begin']).' UTC'; ?>" required />
304
+			    <input type='text' id="start_date" name="start_date" class="form-control" autocomplete="off" value="<?php if (isset($_COOKIE['archive_begin']) && $_COOKIE['archive_begin'] != '') {
305
+	print date("Y-m-d H:i",$_COOKIE['archive_begin']).' UTC';
306
+}
307
+?>" required />
254 308
 			    <span class="input-group-addon">
255 309
 				<span class="glyphicon glyphicon-calendar"></span>
256 310
 			    </span>
@@ -259,7 +313,10 @@  discard block
 block discarded – undo
259 313
 		    <div class="form-group">
260 314
 			<label><?php echo _("To:"); ?></label>
261 315
 			<div class='input-group date' id='datetimepicker2'>
262
-			    <input type='text' id="end_date" name="end_date" class="form-control" autocomplete="off" value="<?php if (isset($_COOKIE['archive_end']) && $_COOKIE['archive_end'] != '') print date("Y-m-d H:i",$_COOKIE['archive_end']).' UTC'; ?>" />
316
+			    <input type='text' id="end_date" name="end_date" class="form-control" autocomplete="off" value="<?php if (isset($_COOKIE['archive_end']) && $_COOKIE['archive_end'] != '') {
317
+	print date("Y-m-d H:i",$_COOKIE['archive_end']).' UTC';
318
+}
319
+?>" />
263 320
 			    <span class="input-group-addon">
264 321
 				<span class="glyphicon glyphicon-calendar"></span>
265 322
 			    </span>
@@ -291,8 +348,20 @@  discard block
 block discarded – undo
291 348
 		    </script>
292 349
 		<li><?php echo _("Playback speed:"); ?>
293 350
 		    <div class="range">
294
-			<input type="range" min="0" max="50" step="1" id="archivespeed" name="archivespeed" onChange="archivespeedrange.value=value;" value="<?php  if (isset($_POST['archivespeed'])) print $_POST['archivespeed']; elseif (isset($_COOKIE['archive_speed'])) print $_COOKIE['archive_speed']; else print '1'; ?>">
295
-			<output id="archivespeedrange"><?php  if (isset($_COOKIE['archive_speed'])) print $_COOKIE['archive_speed']; else print '1'; ?></output>
351
+			<input type="range" min="0" max="50" step="1" id="archivespeed" name="archivespeed" onChange="archivespeedrange.value=value;" value="<?php  if (isset($_POST['archivespeed'])) {
352
+	print $_POST['archivespeed'];
353
+} elseif (isset($_COOKIE['archive_speed'])) {
354
+	print $_COOKIE['archive_speed'];
355
+} else {
356
+	print '1';
357
+}
358
+?>">
359
+			<output id="archivespeedrange"><?php  if (isset($_COOKIE['archive_speed'])) {
360
+	print $_COOKIE['archive_speed'];
361
+} else {
362
+	print '1';
363
+}
364
+?></output>
296 365
 		    </div>
297 366
 		</li>
298 367
 		<?php
@@ -321,14 +390,20 @@  discard block
 block discarded – undo
321 390
 		    <li><?php echo _("Type of Map:"); ?>
322 391
 			    <?php
323 392
 				if ((!isset($_COOKIE['MapFormat']) && (!isset($globalMap3Ddefault) || !$globalMap3Ddefault)) || (isset($_COOKIE['MapFormat']) && $_COOKIE['MapFormat'] != '3d')) {
324
-					if (!isset($_COOKIE['MapType']) || $_COOKIE['MapType'] == '') $MapType = $globalMapProvider;
325
-					else $MapType = $_COOKIE['MapType'];
393
+					if (!isset($_COOKIE['MapType']) || $_COOKIE['MapType'] == '') {
394
+						$MapType = $globalMapProvider;
395
+					} else {
396
+						$MapType = $_COOKIE['MapType'];
397
+					}
326 398
 			    ?>
327 399
 			<select  class="selectpicker" onchange="mapType(this);">
328 400
 			    <?php
329 401
 				} else {
330
-					if (!isset($_COOKIE['MapType3D']) || $_COOKIE['MapType3D'] == '') $MapType = $globalMapProvider;
331
-					else $MapType = $_COOKIE['MapType3D'];
402
+					if (!isset($_COOKIE['MapType3D']) || $_COOKIE['MapType3D'] == '') {
403
+						$MapType = $globalMapProvider;
404
+					} else {
405
+						$MapType = $_COOKIE['MapType3D'];
406
+					}
332 407
 			    ?>
333 408
 			<select  class="selectpicker" onchange="mapType3D(this);">
334 409
 			    <?php
@@ -337,24 +412,48 @@  discard block
 block discarded – undo
337 412
 			    <?php
338 413
 				if (isset($globalMapOffline) && $globalMapOffline === TRUE) {
339 414
 			    ?>
340
-			    <option value="offline"<?php if ($MapType == 'offline') print ' selected'; ?>>Natural Earth (local)</option>
415
+			    <option value="offline"<?php if ($MapType == 'offline') {
416
+	print ' selected';
417
+}
418
+?>>Natural Earth (local)</option>
341 419
 			    <?php
342 420
 				} else {
343 421
 				    if (file_exists(dirname(__FILE__).'/js/Cesium/Assets/Textures/NaturalEarthII/tilemapresource.xml')) {
344 422
 			    ?>
345
-			    <option value="offline"<?php if ($MapType == 'offline') print ' selected'; ?>>Natural Earth (local)</option>
423
+			    <option value="offline"<?php if ($MapType == 'offline') {
424
+	print ' selected';
425
+}
426
+?>>Natural Earth (local)</option>
346 427
 			    <?php
347 428
 				    }
348 429
 			    ?>
349
-			    <option value="ArcGIS-Streetmap"<?php if ($MapType == 'ArcGIS-Streetmap') print ' selected'; ?>>ArcGIS Streetmap</option>
350
-			    <option value="ArcGIS-Satellite"<?php if ($MapType == 'ArcGIS-Satellite') print ' selected'; ?>>ArcGIS Satellite</option>
351
-			    <option value="ArcGIS-Satellite"<?php if ($MapType == 'ArcGIS-Ocean') print ' selected'; ?>>ArcGIS Ocean</option>
430
+			    <option value="ArcGIS-Streetmap"<?php if ($MapType == 'ArcGIS-Streetmap') {
431
+	print ' selected';
432
+}
433
+?>>ArcGIS Streetmap</option>
434
+			    <option value="ArcGIS-Satellite"<?php if ($MapType == 'ArcGIS-Satellite') {
435
+	print ' selected';
436
+}
437
+?>>ArcGIS Satellite</option>
438
+			    <option value="ArcGIS-Satellite"<?php if ($MapType == 'ArcGIS-Ocean') {
439
+	print ' selected';
440
+}
441
+?>>ArcGIS Ocean</option>
352 442
 			    <?php
353 443
 				    if (isset($globalBingMapKey) && $globalBingMapKey != '') {
354 444
 			    ?>
355
-			    <option value="Bing-Aerial"<?php if ($MapType == 'Bing-Aerial') print ' selected'; ?>>Bing-Aerial</option>
356
-			    <option value="Bing-Hybrid"<?php if ($MapType == 'Bing-Hybrid') print ' selected'; ?>>Bing-Hybrid</option>
357
-			    <option value="Bing-Road"<?php if ($MapType == 'Bing-Road') print ' selected'; ?>>Bing-Road</option>
445
+			    <option value="Bing-Aerial"<?php if ($MapType == 'Bing-Aerial') {
446
+	print ' selected';
447
+}
448
+?>>Bing-Aerial</option>
449
+			    <option value="Bing-Hybrid"<?php if ($MapType == 'Bing-Hybrid') {
450
+	print ' selected';
451
+}
452
+?>>Bing-Hybrid</option>
453
+			    <option value="Bing-Road"<?php if ($MapType == 'Bing-Road') {
454
+	print ' selected';
455
+}
456
+?>>Bing-Road</option>
358 457
 			    <?php
359 458
 				    }
360 459
 			    ?>
@@ -364,59 +463,143 @@  discard block
 block discarded – undo
364 463
 			    <?php
365 464
 					if (isset($globalHereappId) && $globalHereappId != '' && isset($globalHereappCode) && $globalHereappCode != '') {
366 465
 			    ?>
367
-			    <option value="Here-Aerial"<?php if ($MapType == 'Here') print ' selected'; ?>>Here-Aerial</option>
368
-			    <option value="Here-Hybrid"<?php if ($MapType == 'Here') print ' selected'; ?>>Here-Hybrid</option>
369
-			    <option value="Here-Road"<?php if ($MapType == 'Here') print ' selected'; ?>>Here-Road</option>
466
+			    <option value="Here-Aerial"<?php if ($MapType == 'Here') {
467
+	print ' selected';
468
+}
469
+?>>Here-Aerial</option>
470
+			    <option value="Here-Hybrid"<?php if ($MapType == 'Here') {
471
+	print ' selected';
472
+}
473
+?>>Here-Hybrid</option>
474
+			    <option value="Here-Road"<?php if ($MapType == 'Here') {
475
+	print ' selected';
476
+}
477
+?>>Here-Road</option>
370 478
 			    <?php
371 479
 					}
372 480
 			    ?>
373 481
 			    <?php
374 482
 					if (isset($globalGoogleAPIKey) && $globalGoogleAPIKey != '') {
375 483
 			    ?>
376
-			    <option value="Google-Roadmap"<?php if ($MapType == 'Google-Roadmap') print ' selected'; ?>>Google Roadmap</option>
377
-			    <option value="Google-Satellite"<?php if ($MapType == 'Google-Satellite') print ' selected'; ?>>Google Satellite</option>
378
-			    <option value="Google-Hybrid"<?php if ($MapType == 'Google-Hybrid') print ' selected'; ?>>Google Hybrid</option>
379
-			    <option value="Google-Terrain"<?php if ($MapType == 'Google-Terrain') print ' selected'; ?>>Google Terrain</option>
484
+			    <option value="Google-Roadmap"<?php if ($MapType == 'Google-Roadmap') {
485
+	print ' selected';
486
+}
487
+?>>Google Roadmap</option>
488
+			    <option value="Google-Satellite"<?php if ($MapType == 'Google-Satellite') {
489
+	print ' selected';
490
+}
491
+?>>Google Satellite</option>
492
+			    <option value="Google-Hybrid"<?php if ($MapType == 'Google-Hybrid') {
493
+	print ' selected';
494
+}
495
+?>>Google Hybrid</option>
496
+			    <option value="Google-Terrain"<?php if ($MapType == 'Google-Terrain') {
497
+	print ' selected';
498
+}
499
+?>>Google Terrain</option>
380 500
 			    <?php
381 501
 					}
382 502
 			    ?>
383 503
 			    <?php
384 504
 					if (isset($globalMapQuestKey) && $globalMapQuestKey != '') {
385 505
 			    ?>
386
-			    <option value="MapQuest-OSM"<?php if ($MapType == 'MapQuest-OSM') print ' selected'; ?>>MapQuest-OSM</option>
387
-			    <option value="MapQuest-Aerial"<?php if ($MapType == 'MapQuest-Aerial') print ' selected'; ?>>MapQuest-Aerial</option>
388
-			    <option value="MapQuest-Hybrid"<?php if ($MapType == 'MapQuest-Hybrid') print ' selected'; ?>>MapQuest-Hybrid</option>
506
+			    <option value="MapQuest-OSM"<?php if ($MapType == 'MapQuest-OSM') {
507
+	print ' selected';
508
+}
509
+?>>MapQuest-OSM</option>
510
+			    <option value="MapQuest-Aerial"<?php if ($MapType == 'MapQuest-Aerial') {
511
+	print ' selected';
512
+}
513
+?>>MapQuest-Aerial</option>
514
+			    <option value="MapQuest-Hybrid"<?php if ($MapType == 'MapQuest-Hybrid') {
515
+	print ' selected';
516
+}
517
+?>>MapQuest-Hybrid</option>
389 518
 			    <?php
390 519
 					}
391 520
 			    ?>
392
-			    <option value="Yandex"<?php if ($MapType == 'Yandex') print ' selected'; ?>>Yandex</option>
393
-			    <option value="offline"<?php if ($MapType == 'offline') print ' selected'; ?>>Natural Earth</option>
521
+			    <option value="Yandex"<?php if ($MapType == 'Yandex') {
522
+	print ' selected';
523
+}
524
+?>>Yandex</option>
525
+			    <option value="offline"<?php if ($MapType == 'offline') {
526
+	print ' selected';
527
+}
528
+?>>Natural Earth</option>
394 529
 			    <?php
395 530
 				    }
396 531
 			    ?>
397
-			    <option value="NatGeo-Street"<?php if ($MapType == 'NatGeo-Street') print ' selected'; ?>>National Geographic Street</option>
532
+			    <option value="NatGeo-Street"<?php if ($MapType == 'NatGeo-Street') {
533
+	print ' selected';
534
+}
535
+?>>National Geographic Street</option>
398 536
 			    <?php
399 537
 				    if (isset($globalMapboxToken) && $globalMapboxToken != '') {
400
-					if (!isset($_COOKIE['MapTypeId'])) $MapBoxId = 'default';
401
-					else $MapBoxId = $_COOKIE['MapTypeId'];
538
+					if (!isset($_COOKIE['MapTypeId'])) {
539
+						$MapBoxId = 'default';
540
+					} else {
541
+						$MapBoxId = $_COOKIE['MapTypeId'];
542
+					}
402 543
 			    ?>
403
-			    <option value="MapboxGL"<?php if ($MapType == 'MapboxGL') print ' selected'; ?>>Mapbox GL</option>
404
-			    <option value="Mapbox-default"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'default') print ' selected'; ?>>Mapbox default</option>
405
-			    <option value="Mapbox-mapbox.streets"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.streets') print ' selected'; ?>>Mapbox streets</option>
406
-			    <option value="Mapbox-mapbox.light"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.light') print ' selected'; ?>>Mapbox light</option>
407
-			    <option value="Mapbox-mapbox.dark"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.dark') print ' selected'; ?>>Mapbox dark</option>
408
-			    <option value="Mapbox-mapbox.satellite"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.satellite') print ' selected'; ?>>Mapbox satellite</option>
409
-			    <option value="Mapbox-mapbox.streets-satellite"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.streets-satellite') print ' selected'; ?>>Mapbox streets-satellite</option>
410
-			    <option value="Mapbox-mapbox.streets-basic"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.streets-basic') print ' selected'; ?>>Mapbox streets-basic</option>
411
-			    <option value="Mapbox-mapbox.comic"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.comic') print ' selected'; ?>>Mapbox comic</option>
412
-			    <option value="Mapbox-mapbox.outdoors"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.outdoors') print ' selected'; ?>>Mapbox outdoors</option>
413
-			    <option value="Mapbox-mapbox.pencil"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.pencil') print ' selected'; ?>>Mapbox pencil</option>
414
-			    <option value="Mapbox-mapbox.pirates"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.pirates') print ' selected'; ?>>Mapbox pirates</option>
415
-			    <option value="Mapbox-mapbox.emerald"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.emerald') print ' selected'; ?>>Mapbox emerald</option>
544
+			    <option value="MapboxGL"<?php if ($MapType == 'MapboxGL') {
545
+	print ' selected';
546
+}
547
+?>>Mapbox GL</option>
548
+			    <option value="Mapbox-default"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'default') {
549
+	print ' selected';
550
+}
551
+?>>Mapbox default</option>
552
+			    <option value="Mapbox-mapbox.streets"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.streets') {
553
+	print ' selected';
554
+}
555
+?>>Mapbox streets</option>
556
+			    <option value="Mapbox-mapbox.light"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.light') {
557
+	print ' selected';
558
+}
559
+?>>Mapbox light</option>
560
+			    <option value="Mapbox-mapbox.dark"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.dark') {
561
+	print ' selected';
562
+}
563
+?>>Mapbox dark</option>
564
+			    <option value="Mapbox-mapbox.satellite"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.satellite') {
565
+	print ' selected';
566
+}
567
+?>>Mapbox satellite</option>
568
+			    <option value="Mapbox-mapbox.streets-satellite"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.streets-satellite') {
569
+	print ' selected';
570
+}
571
+?>>Mapbox streets-satellite</option>
572
+			    <option value="Mapbox-mapbox.streets-basic"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.streets-basic') {
573
+	print ' selected';
574
+}
575
+?>>Mapbox streets-basic</option>
576
+			    <option value="Mapbox-mapbox.comic"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.comic') {
577
+	print ' selected';
578
+}
579
+?>>Mapbox comic</option>
580
+			    <option value="Mapbox-mapbox.outdoors"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.outdoors') {
581
+	print ' selected';
582
+}
583
+?>>Mapbox outdoors</option>
584
+			    <option value="Mapbox-mapbox.pencil"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.pencil') {
585
+	print ' selected';
586
+}
587
+?>>Mapbox pencil</option>
588
+			    <option value="Mapbox-mapbox.pirates"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.pirates') {
589
+	print ' selected';
590
+}
591
+?>>Mapbox pirates</option>
592
+			    <option value="Mapbox-mapbox.emerald"<?php if ($MapType == 'Mapbox' && $MapBoxId == 'mapbox.emerald') {
593
+	print ' selected';
594
+}
595
+?>>Mapbox emerald</option>
416 596
 			    <?php
417 597
 				    }
418 598
 			    ?>
419
-			    <option value="OpenStreetMap"<?php if ($MapType == 'OpenStreetMap') print ' selected'; ?>>OpenStreetMap</option>
599
+			    <option value="OpenStreetMap"<?php if ($MapType == 'OpenStreetMap') {
600
+	print ' selected';
601
+}
602
+?>>OpenStreetMap</option>
420 603
 			    <?php
421 604
 				}
422 605
 			    ?>
@@ -427,10 +610,22 @@  discard block
 block discarded – undo
427 610
 ?>
428 611
 		    <li><?php echo _("Type of Terrain:"); ?>
429 612
 			<select  class="selectpicker" onchange="terrainType(this);">
430
-			    <option value="stk"<?php if (!isset($_COOKIE['MapTerrain']) || $_COOKIE['MapTerrain'] == 'stk') print ' selected'; ?>>stk terrain</option>
431
-			    <option value="ellipsoid"<?php if (isset($_COOKIE['MapTerrain']) && $_COOKIE['MapTerrain'] == 'ellipsoid') print ' selected';?>>ellipsoid</option>
432
-			    <option value="vrterrain"<?php if (isset($_COOKIE['MapTerrain']) && $_COOKIE['MapTerrain'] == 'vrterrain') print ' selected';?>>vr terrain</option>
433
-			    <option value="articdem"<?php if (isset($_COOKIE['MapTerrain']) && $_COOKIE['MapTerrain'] == 'articdem') print ' selected';?>>ArticDEM</option>
613
+			    <option value="stk"<?php if (!isset($_COOKIE['MapTerrain']) || $_COOKIE['MapTerrain'] == 'stk') {
614
+	print ' selected';
615
+}
616
+?>>stk terrain</option>
617
+			    <option value="ellipsoid"<?php if (isset($_COOKIE['MapTerrain']) && $_COOKIE['MapTerrain'] == 'ellipsoid') {
618
+	print ' selected';
619
+}
620
+?>>ellipsoid</option>
621
+			    <option value="vrterrain"<?php if (isset($_COOKIE['MapTerrain']) && $_COOKIE['MapTerrain'] == 'vrterrain') {
622
+	print ' selected';
623
+}
624
+?>>vr terrain</option>
625
+			    <option value="articdem"<?php if (isset($_COOKIE['MapTerrain']) && $_COOKIE['MapTerrain'] == 'articdem') {
626
+	print ' selected';
627
+}
628
+?>>ArticDEM</option>
434 629
 			</select>
435 630
 		    </li>
436 631
 <?php
@@ -440,59 +635,116 @@  discard block
 block discarded – undo
440 635
 <?php
441 636
     if (isset($globalMap3D) && $globalMap3D) {
442 637
 ?>
443
-		    <li><div class="checkbox"><label><input type="checkbox" name="synchro2d3d" value="1" onclick="clickSyncMap2D3D(this)" <?php if (isset($_COOKIE['Map2D3DSync']) && $_COOKIE['Map2D3DSync'] == 'true') print 'checked'; ?> ><?php echo _("Use same type of map for 2D & 3D"); ?></label></div></li>
638
+		    <li><div class="checkbox"><label><input type="checkbox" name="synchro2d3d" value="1" onclick="clickSyncMap2D3D(this)" <?php if (isset($_COOKIE['Map2D3DSync']) && $_COOKIE['Map2D3DSync'] == 'true') {
639
+	print 'checked';
640
+}
641
+?> ><?php echo _("Use same type of map for 2D & 3D"); ?></label></div></li>
444 642
 <?php
445 643
     }
446 644
 ?>
447 645
 <?php
448 646
     if (!isset($_COOKIE['MapFormat']) || $_COOKIE['MapFormat'] != '3d') {
449 647
 ?>
450
-		    <li><div class="checkbox"><label><input type="checkbox" name="display2dbuildings" value="1" onclick="clickDisplay2DBuildings(this)" <?php if (isset($_COOKIE['Map2DBuildings']) && $_COOKIE['Map2DBuildings'] == 'true') print 'checked'; ?> ><?php echo _("Display 2.5D buidings on map"); ?></label></div></li>
648
+		    <li><div class="checkbox"><label><input type="checkbox" name="display2dbuildings" value="1" onclick="clickDisplay2DBuildings(this)" <?php if (isset($_COOKIE['Map2DBuildings']) && $_COOKIE['Map2DBuildings'] == 'true') {
649
+	print 'checked';
650
+}
651
+?> ><?php echo _("Display 2.5D buidings on map"); ?></label></div></li>
451 652
 
452 653
 <?php
453 654
 	if (!isset($globalAircraft) || $globalAircraft === TRUE) {
454 655
 ?>
455
-		    <!--<li><div class="checkbox"><label><input type="checkbox" name="flightpopup" value="1" onclick="clickFlightPopup(this)" <?php if (isset($_COOKIE['flightpopup']) && $_COOKIE['flightpopup'] == 'true') print 'checked'; ?> ><?php echo _("Display flight info as popup"); ?></label></div></li>-->
456
-		    <li><div class="checkbox"><label><input type="checkbox" name="flightpath" value="1" onclick="clickFlightPath(this)" <?php if ((isset($_COOKIE['flightpath']) && $_COOKIE['flightpath'] == 'true')) print 'checked'; ?> ><?php echo _("Display flight path"); ?></label></div></li>
457
-		    <li><div class="checkbox"><label><input type="checkbox" name="flightroute" value="1" onclick="clickFlightRoute(this)" <?php if ((isset($_COOKIE['MapRoute']) && $_COOKIE['MapRoute'] == 'true') || (!isset($_COOKIE['MapRoute']) && isset($globalMapRoute) && $globalMapRoute)) print 'checked'; ?> ><?php echo _("Display flight route on click"); ?></label></div></li>
458
-		    <li><div class="checkbox"><label><input type="checkbox" name="flightremainingroute" value="1" onclick="clickFlightRemainingRoute(this)" <?php if ((isset($_COOKIE['MapRemainingRoute']) && $_COOKIE['MapRemainingRoute'] == 'true') || (!isset($_COOKIE['MapRemainingRoute']) && isset($globalMapRemainingRoute) && $globalMapRemainingRoute)) print 'checked'; ?> ><?php echo _("Display flight remaining route on click"); ?></label></div></li>
459
-		    <li><div class="checkbox"><label><input type="checkbox" name="flightestimation" value="1" onclick="clickFlightEstimation(this)" <?php if ((isset($_COOKIE['flightestimation']) && $_COOKIE['flightestimation'] == 'true') || (!isset($_COOKIE['flightestimation']) && !isset($globalMapEstimation)) || (!isset($_COOKIE['flightestimation']) && isset($globalMapEstimation) && $globalMapEstimation)) print 'checked'; ?> ><?php echo _("Planes animate between updates"); ?></label></div></li>
656
+		    <!--<li><div class="checkbox"><label><input type="checkbox" name="flightpopup" value="1" onclick="clickFlightPopup(this)" <?php if (isset($_COOKIE['flightpopup']) && $_COOKIE['flightpopup'] == 'true') {
657
+	print 'checked';
658
+}
659
+?> ><?php echo _("Display flight info as popup"); ?></label></div></li>-->
660
+		    <li><div class="checkbox"><label><input type="checkbox" name="flightpath" value="1" onclick="clickFlightPath(this)" <?php if ((isset($_COOKIE['flightpath']) && $_COOKIE['flightpath'] == 'true')) {
661
+	print 'checked';
662
+}
663
+?> ><?php echo _("Display flight path"); ?></label></div></li>
664
+		    <li><div class="checkbox"><label><input type="checkbox" name="flightroute" value="1" onclick="clickFlightRoute(this)" <?php if ((isset($_COOKIE['MapRoute']) && $_COOKIE['MapRoute'] == 'true') || (!isset($_COOKIE['MapRoute']) && isset($globalMapRoute) && $globalMapRoute)) {
665
+	print 'checked';
666
+}
667
+?> ><?php echo _("Display flight route on click"); ?></label></div></li>
668
+		    <li><div class="checkbox"><label><input type="checkbox" name="flightremainingroute" value="1" onclick="clickFlightRemainingRoute(this)" <?php if ((isset($_COOKIE['MapRemainingRoute']) && $_COOKIE['MapRemainingRoute'] == 'true') || (!isset($_COOKIE['MapRemainingRoute']) && isset($globalMapRemainingRoute) && $globalMapRemainingRoute)) {
669
+	print 'checked';
670
+}
671
+?> ><?php echo _("Display flight remaining route on click"); ?></label></div></li>
672
+		    <li><div class="checkbox"><label><input type="checkbox" name="flightestimation" value="1" onclick="clickFlightEstimation(this)" <?php if ((isset($_COOKIE['flightestimation']) && $_COOKIE['flightestimation'] == 'true') || (!isset($_COOKIE['flightestimation']) && !isset($globalMapEstimation)) || (!isset($_COOKIE['flightestimation']) && isset($globalMapEstimation) && $globalMapEstimation)) {
673
+	print 'checked';
674
+}
675
+?> ><?php echo _("Planes animate between updates"); ?></label></div></li>
460 676
 <?php
461 677
 	} elseif (!isset($globalTracker) || $globalTracker === TRUE) {
462 678
 ?>
463
-		    <li><div class="checkbox"><label><input type="checkbox" name="mapmatching" value="1" onclick="clickMapMatching(this)" <?php if ((isset($_COOKIE['mapmatching']) && $_COOKIE['mapmatching'] == 'true') || (!isset($_COOKIE['mapmatching']) && isset($globalMapMatching) && $globalMapMatching)) print 'checked'; ?> ><?php echo _("Enable map matching"); ?></label></div></li>
679
+		    <li><div class="checkbox"><label><input type="checkbox" name="mapmatching" value="1" onclick="clickMapMatching(this)" <?php if ((isset($_COOKIE['mapmatching']) && $_COOKIE['mapmatching'] == 'true') || (!isset($_COOKIE['mapmatching']) && isset($globalMapMatching) && $globalMapMatching)) {
680
+	print 'checked';
681
+}
682
+?> ><?php echo _("Enable map matching"); ?></label></div></li>
464 683
 <?php
465 684
 	}
466 685
 	if (isset($globalSatellite) && $globalSatellite === TRUE) {
467 686
 ?>
468
-		    <li><div class="checkbox"><label><input type="checkbox" name="satelliteestimation" value="1" onclick="clickSatelliteEstimation(this)" <?php if ((isset($_COOKIE['satelliteestimation']) && $_COOKIE['satelliteestimation'] == 'true') || (!isset($_COOKIE['satelliteestimation']) && !isset($globalMapEstimation)) || (!isset($_COOKIE['satelliteestimation']) && isset($globalMapEstimation) && $globalMapEstimation)) print 'checked'; ?> ><?php echo _("Satellites animate between updates"); ?></label></div></li>
687
+		    <li><div class="checkbox"><label><input type="checkbox" name="satelliteestimation" value="1" onclick="clickSatelliteEstimation(this)" <?php if ((isset($_COOKIE['satelliteestimation']) && $_COOKIE['satelliteestimation'] == 'true') || (!isset($_COOKIE['satelliteestimation']) && !isset($globalMapEstimation)) || (!isset($_COOKIE['satelliteestimation']) && isset($globalMapEstimation) && $globalMapEstimation)) {
688
+	print 'checked';
689
+}
690
+?> ><?php echo _("Satellites animate between updates"); ?></label></div></li>
469 691
 <?php
470 692
 	}
471 693
     }
472 694
 ?>
473
-		    <li><div class="checkbox"><label><input type="checkbox" name="displayairports" value="1" onclick="clickDisplayAirports(this)" <?php if (isset($_COOKIE['displayairports']) && $_COOKIE['displayairports'] == 'true' || !isset($_COOKIE['displayairports'])) print 'checked'; ?> ><?php echo _("Display airports on map"); ?></label></div></li>
474
-		    <li><div class="checkbox"><label><input type="checkbox" name="displaygroundstation" value="1" onclick="clickDisplayGroundStation(this)" <?php if ((isset($_COOKIE['show_GroundStation']) && $_COOKIE['show_GroundStation'] == 'true') || (!isset($_COOKIE['show_GroundStation']) && (isset($globalMapGroundStation) && $globalMapGroundStation === TRUE))) print 'checked'; ?> ><?php echo _("Display ground station on map"); ?></label></div></li>
475
-		    <li><div class="checkbox"><label><input type="checkbox" name="displayweatherstation" value="1" onclick="clickDisplayWeatherStation(this)" <?php if ((isset($_COOKIE['show_WeatherStation']) && $_COOKIE['show_WeatherStation'] == 'true') || (!isset($_COOKIE['show_WeatherStation']) && (isset($globalMapWeatherStation) && $globalMapWeatherStation === TRUE))) print 'checked'; ?> ><?php echo _("Display weather station on map"); ?></label></div></li>
476
-		    <li><div class="checkbox"><label><input type="checkbox" name="displaylightning" value="1" onclick="clickDisplayLightning(this)" <?php if ((isset($_COOKIE['show_Lightning']) && $_COOKIE['show_Lightning'] == 'true') || (!isset($_COOKIE['show_Lightning']) && (isset($globalMapLightning) && $globalMapLightning === TRUE))) print 'checked'; ?> ><?php echo _("Display lightning on map"); ?></label></div></li>
695
+		    <li><div class="checkbox"><label><input type="checkbox" name="displayairports" value="1" onclick="clickDisplayAirports(this)" <?php if (isset($_COOKIE['displayairports']) && $_COOKIE['displayairports'] == 'true' || !isset($_COOKIE['displayairports'])) {
696
+	print 'checked';
697
+}
698
+?> ><?php echo _("Display airports on map"); ?></label></div></li>
699
+		    <li><div class="checkbox"><label><input type="checkbox" name="displaygroundstation" value="1" onclick="clickDisplayGroundStation(this)" <?php if ((isset($_COOKIE['show_GroundStation']) && $_COOKIE['show_GroundStation'] == 'true') || (!isset($_COOKIE['show_GroundStation']) && (isset($globalMapGroundStation) && $globalMapGroundStation === TRUE))) {
700
+	print 'checked';
701
+}
702
+?> ><?php echo _("Display ground station on map"); ?></label></div></li>
703
+		    <li><div class="checkbox"><label><input type="checkbox" name="displayweatherstation" value="1" onclick="clickDisplayWeatherStation(this)" <?php if ((isset($_COOKIE['show_WeatherStation']) && $_COOKIE['show_WeatherStation'] == 'true') || (!isset($_COOKIE['show_WeatherStation']) && (isset($globalMapWeatherStation) && $globalMapWeatherStation === TRUE))) {
704
+	print 'checked';
705
+}
706
+?> ><?php echo _("Display weather station on map"); ?></label></div></li>
707
+		    <li><div class="checkbox"><label><input type="checkbox" name="displaylightning" value="1" onclick="clickDisplayLightning(this)" <?php if ((isset($_COOKIE['show_Lightning']) && $_COOKIE['show_Lightning'] == 'true') || (!isset($_COOKIE['show_Lightning']) && (isset($globalMapLightning) && $globalMapLightning === TRUE))) {
708
+	print 'checked';
709
+}
710
+?> ><?php echo _("Display lightning on map"); ?></label></div></li>
477 711
 <?php
478 712
 	if (isset($globalFires)) {
479 713
 ?>
480
-		    <li><div class="checkbox"><label><input type="checkbox" name="displayfires" value="1" onclick="clickDisplayFires(this)" <?php if ((isset($_COOKIE['show_Fires']) && $_COOKIE['show_Fires'] == 'true') || (!isset($_COOKIE['show_Fires']) && (isset($globalMapFires) && $globalMapFires === TRUE))) print 'checked'; ?> ><?php echo _("Display fires on map"); ?></label></div></li>
714
+		    <li><div class="checkbox"><label><input type="checkbox" name="displayfires" value="1" onclick="clickDisplayFires(this)" <?php if ((isset($_COOKIE['show_Fires']) && $_COOKIE['show_Fires'] == 'true') || (!isset($_COOKIE['show_Fires']) && (isset($globalMapFires) && $globalMapFires === TRUE))) {
715
+	print 'checked';
716
+}
717
+?> ><?php echo _("Display fires on map"); ?></label></div></li>
481 718
 <?php
482 719
 	}
483 720
 	if (isset($globalMap3D) && $globalMap3D) {
484 721
 ?>
485
-		    <li><div class="checkbox"><label><input type="checkbox" name="singlemodel" value="1" onclick="clickSingleModel(this)" <?php if ((isset($_COOKIE['singlemodel']) && $_COOKIE['singlemodel'] == 'true') || (!isset($_COOKIE['singlemodel']) && isset($globalMap3DSelected) && $globalMap3DSelected)) print 'checked'; ?> ><?php echo _("Only display selected flight on 3D mode"); ?></label></div></li>
722
+		    <li><div class="checkbox"><label><input type="checkbox" name="singlemodel" value="1" onclick="clickSingleModel(this)" <?php if ((isset($_COOKIE['singlemodel']) && $_COOKIE['singlemodel'] == 'true') || (!isset($_COOKIE['singlemodel']) && isset($globalMap3DSelected) && $globalMap3DSelected)) {
723
+	print 'checked';
724
+}
725
+?> ><?php echo _("Only display selected flight on 3D mode"); ?></label></div></li>
486 726
 <?php
487 727
 	}
488 728
 ?>
489 729
 <?php
490 730
     if (isset($_COOKIE['MapFormat']) && $_COOKIE['MapFormat'] == '3d') {
491 731
 ?>
492
-		    <li><div class="checkbox"><label><input type="checkbox" name="displayminimap" value="1" onclick="clickDisplayMinimap(this)" <?php if (!isset($_COOKIE['displayminimap']) || (isset($_COOKIE['displayminimap']) && $_COOKIE['displayminimap'] == 'true')) print 'checked'; ?> ><?php echo _("Show mini-map"); ?></label></div></li>
493
-		    <li><div class="checkbox"><label><input type="checkbox" name="shadows" value="1" onclick="clickShadows(this)" <?php if ((!isset($_COOKIE['map3dnoshadows']) && (!isset($globalMap3DShadows) || $globalMap3DShadows)) || (isset($_COOKIE['map3dnoshadows']) && $_COOKIE['map3dnoshadows'] == 'false')) print 'checked'; ?> ><?php echo _("Use shadows"); ?></label></div></li>
494
-		    <li><div class="checkbox"><label><input type="checkbox" name="one3dmodel" value="1" onclick="useOne3Dmodel(this)" <?php if ((isset($_COOKIE['one3dmodel']) && $_COOKIE['one3dmodel'] == 'true') || (!isset($_COOKIE['one3dmodel']) && isset($globalMap3DOneModel) && $globalMap3DOneModel)) print 'checked'; ?> ><?php echo _("Use same 3D model for all aircraft (use fewer resources)"); ?></label></div></li>
495
-		    <li><div class="checkbox"><label><input type="checkbox" name="updaterealtime" value="1" onclick="clickUpdateRealtime(this)" <?php if ((isset($_COOKIE['updaterealtime']) && $_COOKIE['updaterealtime'] == 'true') || !isset($_COOKIE['updaterealtime'])) print 'checked'; ?> ><?php echo _("Display realtime data in infobox"); ?></label></div></li>
732
+		    <li><div class="checkbox"><label><input type="checkbox" name="displayminimap" value="1" onclick="clickDisplayMinimap(this)" <?php if (!isset($_COOKIE['displayminimap']) || (isset($_COOKIE['displayminimap']) && $_COOKIE['displayminimap'] == 'true')) {
733
+	print 'checked';
734
+}
735
+?> ><?php echo _("Show mini-map"); ?></label></div></li>
736
+		    <li><div class="checkbox"><label><input type="checkbox" name="shadows" value="1" onclick="clickShadows(this)" <?php if ((!isset($_COOKIE['map3dnoshadows']) && (!isset($globalMap3DShadows) || $globalMap3DShadows)) || (isset($_COOKIE['map3dnoshadows']) && $_COOKIE['map3dnoshadows'] == 'false')) {
737
+	print 'checked';
738
+}
739
+?> ><?php echo _("Use shadows"); ?></label></div></li>
740
+		    <li><div class="checkbox"><label><input type="checkbox" name="one3dmodel" value="1" onclick="useOne3Dmodel(this)" <?php if ((isset($_COOKIE['one3dmodel']) && $_COOKIE['one3dmodel'] == 'true') || (!isset($_COOKIE['one3dmodel']) && isset($globalMap3DOneModel) && $globalMap3DOneModel)) {
741
+	print 'checked';
742
+}
743
+?> ><?php echo _("Use same 3D model for all aircraft (use fewer resources)"); ?></label></div></li>
744
+		    <li><div class="checkbox"><label><input type="checkbox" name="updaterealtime" value="1" onclick="clickUpdateRealtime(this)" <?php if ((isset($_COOKIE['updaterealtime']) && $_COOKIE['updaterealtime'] == 'true') || !isset($_COOKIE['updaterealtime'])) {
745
+	print 'checked';
746
+}
747
+?> ><?php echo _("Display realtime data in infobox"); ?></label></div></li>
496 748
 <?php
497 749
     }
498 750
     if (time() > mktime(0,0,0,12,1,date("Y")) && time() < mktime(0,0,0,12,31,date("Y"))) {
@@ -505,17 +757,25 @@  discard block
 block discarded – undo
505 757
 			if (function_exists('array_column')) {
506 758
 			    if (array_search(TRUE, array_column($globalSources, 'sourcestats')) !== FALSE) {
507 759
 		    ?>
508
-		    <li><div class="checkbox"><label><input type="checkbox" name="flightpolar" value="1" onclick="clickPolar(this)" <?php if ((isset($_COOKIE['polar']) && $_COOKIE['polar'] == 'true')) print 'checked'; ?> ><?php echo _("Display polar on map"); ?></label></div></li>
760
+		    <li><div class="checkbox"><label><input type="checkbox" name="flightpolar" value="1" onclick="clickPolar(this)" <?php if ((isset($_COOKIE['polar']) && $_COOKIE['polar'] == 'true')) {
761
+	print 'checked';
762
+}
763
+?> ><?php echo _("Display polar on map"); ?></label></div></li>
509 764
 		    <?php
510 765
 			    }
511 766
 			} elseif (isset($globalSources)) {
512 767
 			    $dispolar = false;
513 768
 			    foreach ($globalSources as $testsource) {
514
-			        if (isset($globalSources['sourcestats']) && $globalSources['sourcestats'] !== FALSE) $dispolar = true;
769
+			        if (isset($globalSources['sourcestats']) && $globalSources['sourcestats'] !== FALSE) {
770
+			        	$dispolar = true;
771
+			        }
515 772
 			    }
516 773
 			    if ($dispolar) {
517 774
 		    ?>
518
-		    <li><div class="checkbox"><label><input type="checkbox" name="flightpolar" value="1" onclick="clickPolar(this)" <?php if ((isset($_COOKIE['polar']) && $_COOKIE['polar'] == 'true')) print 'checked'; ?> ><?php echo _("Display polar on map"); ?></label></div></li>
775
+		    <li><div class="checkbox"><label><input type="checkbox" name="flightpolar" value="1" onclick="clickPolar(this)" <?php if ((isset($_COOKIE['polar']) && $_COOKIE['polar'] == 'true')) {
776
+	print 'checked';
777
+}
778
+?> ><?php echo _("Display polar on map"); ?></label></div></li>
519 779
 		    <?php
520 780
 			    }
521 781
 		        }
@@ -528,11 +788,21 @@  discard block
 block discarded – undo
528 788
 			if (!isset($globalAircraft) || $globalAircraft === TRUE) {
529 789
 		    	    if (extension_loaded('gd') && function_exists('gd_info')) {
530 790
 		    ?>
531
-		    <li><input type="checkbox" name="aircraftcoloraltitude" value="1" onclick="iconColorAltitude(this)" <?php if (isset($_COOKIE['IconColorAltitude']) && $_COOKIE['IconColorAltitude'] == 'true') print 'checked'; ?> ><?php echo _("Aircraft icon color based on altitude"); ?></li>
791
+		    <li><input type="checkbox" name="aircraftcoloraltitude" value="1" onclick="iconColorAltitude(this)" <?php if (isset($_COOKIE['IconColorAltitude']) && $_COOKIE['IconColorAltitude'] == 'true') {
792
+	print 'checked';
793
+}
794
+?> ><?php echo _("Aircraft icon color based on altitude"); ?></li>
532 795
 		    <?php 
533 796
 				if (!isset($_COOKIE['IconColorAltitude']) || $_COOKIE['IconColorAltitude'] == 'false') {
534 797
 		    ?>
535
-			<li><?php echo _("Aircraft icon color:"); ?><input type="color" name="aircraftcolor" id="html5colorpicker" onchange="iconColor(aircraftcolor.value);" value="#<?php if (isset($_COOKIE['IconColor'])) print $_COOKIE['IconColor']; elseif (isset($globalAircraftIconColor)) print $globalAircraftIconColor; else print '1a3151'; ?>"></li>
798
+			<li><?php echo _("Aircraft icon color:"); ?><input type="color" name="aircraftcolor" id="html5colorpicker" onchange="iconColor(aircraftcolor.value);" value="#<?php if (isset($_COOKIE['IconColor'])) {
799
+	print $_COOKIE['IconColor'];
800
+} elseif (isset($globalAircraftIconColor)) {
801
+	print $globalAircraftIconColor;
802
+} else {
803
+	print '1a3151';
804
+}
805
+?>"></li>
536 806
 		    <?php
537 807
 				}
538 808
 			    }
@@ -543,7 +813,14 @@  discard block
 block discarded – undo
543 813
 			    if (extension_loaded('gd') && function_exists('gd_info')) {
544 814
 		    ?>
545 815
 		    <li><?php echo _("Marine icon color:"); ?>
546
-			<input type="color" name="marinecolor" id="html5colorpicker" onchange="MarineiconColor(marinecolor.value);" value="#<?php if (isset($_COOKIE['MarineIconColor'])) print $_COOKIE['MarineIconColor']; elseif (isset($globalMarineIconColor)) print $globalMarineIconColor; else print '1a3151'; ?>">
816
+			<input type="color" name="marinecolor" id="html5colorpicker" onchange="MarineiconColor(marinecolor.value);" value="#<?php if (isset($_COOKIE['MarineIconColor'])) {
817
+	print $_COOKIE['MarineIconColor'];
818
+} elseif (isset($globalMarineIconColor)) {
819
+	print $globalMarineIconColor;
820
+} else {
821
+	print '1a3151';
822
+}
823
+?>">
547 824
 		    </li>
548 825
 		    <?php
549 826
 			    }
@@ -554,7 +831,14 @@  discard block
 block discarded – undo
554 831
 			    if (extension_loaded('gd') && function_exists('gd_info')) {
555 832
 		    ?>
556 833
 		    <li><?php echo _("Tracker icon color:"); ?>
557
-			<input type="color" name="trackercolor" id="html5colorpicker" onchange="TrackericonColor(trackercolor.value);" value="#<?php if (isset($_COOKIE['TrackerIconColor'])) print $_COOKIE['TrackerIconColor']; elseif (isset($globalTrackerIconColor)) print $globalTrackerIconColor; else print '1a3151'; ?>">
834
+			<input type="color" name="trackercolor" id="html5colorpicker" onchange="TrackericonColor(trackercolor.value);" value="#<?php if (isset($_COOKIE['TrackerIconColor'])) {
835
+	print $_COOKIE['TrackerIconColor'];
836
+} elseif (isset($globalTrackerIconColor)) {
837
+	print $globalTrackerIconColor;
838
+} else {
839
+	print '1a3151';
840
+}
841
+?>">
558 842
 		    </li>
559 843
 		    <?php
560 844
 			    }
@@ -565,8 +849,22 @@  discard block
 block discarded – undo
565 849
 		    ?>
566 850
 		    <li><?php echo _("Show airport icon at zoom level:"); ?>
567 851
 			<div class="range">
568
-			    <input type="range" min="0" max="19" step="1" name="airportzoom" onchange="range.value=value;airportDisplayZoom(airportzoom.value);" value="<?php if (isset($_COOKIE['AirportZoom'])) print $_COOKIE['AirportZoom']; elseif (isset($globalAirportZoom)) print $globalAirportZoom; else print '7'; ?>">
569
-			    <output id="range"><?php if (isset($_COOKIE['AirportZoom'])) print $_COOKIE['AirportZoom']; elseif (isset($globalAirportZoom)) print $globalAirportZoom; else print '7'; ?></output>
852
+			    <input type="range" min="0" max="19" step="1" name="airportzoom" onchange="range.value=value;airportDisplayZoom(airportzoom.value);" value="<?php if (isset($_COOKIE['AirportZoom'])) {
853
+	print $_COOKIE['AirportZoom'];
854
+} elseif (isset($globalAirportZoom)) {
855
+	print $globalAirportZoom;
856
+} else {
857
+	print '7';
858
+}
859
+?>">
860
+			    <output id="range"><?php if (isset($_COOKIE['AirportZoom'])) {
861
+	print $_COOKIE['AirportZoom'];
862
+} elseif (isset($globalAirportZoom)) {
863
+	print $globalAirportZoom;
864
+} else {
865
+	print '7';
866
+}
867
+?></output>
570 868
 			</div>
571 869
 		    </li>
572 870
 		    <?php
@@ -577,17 +875,40 @@  discard block
 block discarded – undo
577 875
 ?>
578 876
 		    <li><?php echo _("Set scaling factor for rendering resolution:"); ?>
579 877
 			<div class="range">
580
-			    <input type="range" min="0.5" max="2" step="0.5" name="resolutionscale" onchange="scale.value=value;resolutionScale(resolutionscale.value);" value="<?php if (isset($_COOKIE['resolutionScale'])) print $_COOKIE['resolutionScale']; else print '1'; ?>">
581
-			    <output id="scale"><?php if (isset($_COOKIE['resolutionScale'])) print $_COOKIE['resolutionScale']; else print '1'; ?></output>
878
+			    <input type="range" min="0.5" max="2" step="0.5" name="resolutionscale" onchange="scale.value=value;resolutionScale(resolutionscale.value);" value="<?php if (isset($_COOKIE['resolutionScale'])) {
879
+	print $_COOKIE['resolutionScale'];
880
+} else {
881
+	print '1';
882
+}
883
+?>">
884
+			    <output id="scale"><?php if (isset($_COOKIE['resolutionScale'])) {
885
+	print $_COOKIE['resolutionScale'];
886
+} else {
887
+	print '1';
888
+}
889
+?></output>
582 890
 			</div>
583 891
 		    </li>
584 892
 <?php
585 893
 	if (!isset($globalAircraft) || $globalAircraft === TRUE) {
586 894
 ?>
587
-		    <li><input type="checkbox" name="useliveries" value="1" onclick="useLiveries(this)" <?php if (isset($_COOKIE['UseLiveries']) && $_COOKIE['UseLiveries'] == 'true') print 'checked'; ?> > <?php echo _("Use airlines liveries"); ?></li>
588
-		    <li><input type="checkbox" name="aircraftcolorforce" value="1" onclick="iconColorForce(this)" <?php if (isset($_COOKIE['IconColorForce']) && $_COOKIE['IconColorForce'] == 'true') print 'checked'; ?> > <?php echo _("Force Aircraft color"); ?>&nbsp;
895
+		    <li><input type="checkbox" name="useliveries" value="1" onclick="useLiveries(this)" <?php if (isset($_COOKIE['UseLiveries']) && $_COOKIE['UseLiveries'] == 'true') {
896
+	print 'checked';
897
+}
898
+?> > <?php echo _("Use airlines liveries"); ?></li>
899
+		    <li><input type="checkbox" name="aircraftcolorforce" value="1" onclick="iconColorForce(this)" <?php if (isset($_COOKIE['IconColorForce']) && $_COOKIE['IconColorForce'] == 'true') {
900
+	print 'checked';
901
+}
902
+?> > <?php echo _("Force Aircraft color"); ?>&nbsp;
589 903
 		    <!--<li><?php echo _("Aircraft icon color:"); ?>-->
590
-			<input type="color" name="aircraftcolor" id="html5colorpicker" onchange="iconColor(aircraftcolor.value);" value="#<?php if (isset($_COOKIE['IconColor'])) print $_COOKIE['IconColor']; elseif (isset($globalAircraftIconColor)) print $globalAircraftIconColor; else print 'ff0000'; ?>">
904
+			<input type="color" name="aircraftcolor" id="html5colorpicker" onchange="iconColor(aircraftcolor.value);" value="#<?php if (isset($_COOKIE['IconColor'])) {
905
+	print $_COOKIE['IconColor'];
906
+} elseif (isset($globalAircraftIconColor)) {
907
+	print $globalAircraftIconColor;
908
+} else {
909
+	print 'ff0000';
910
+}
911
+?>">
591 912
 		    </li>
592 913
 <?php
593 914
 	}
@@ -595,9 +916,19 @@  discard block
 block discarded – undo
595 916
 <?php
596 917
 	if (isset($globalMarine) && $globalMarine === TRUE) {
597 918
 ?>
598
-		    <li><input type="checkbox" name="marinecolorforce" value="1" onclick="MarineiconColorForce(this)" <?php if (isset($_COOKIE['MarineIconColorForce']) && $_COOKIE['MarineIconColorForce'] == 'true') print 'checked'; ?> ><?php echo _("Force Marine color"); ?>&nbsp;
919
+		    <li><input type="checkbox" name="marinecolorforce" value="1" onclick="MarineiconColorForce(this)" <?php if (isset($_COOKIE['MarineIconColorForce']) && $_COOKIE['MarineIconColorForce'] == 'true') {
920
+	print 'checked';
921
+}
922
+?> ><?php echo _("Force Marine color"); ?>&nbsp;
599 923
 		    <!--<li><?php echo _("Marine icon color:"); ?>-->
600
-			<input type="color" name="marinecolor" id="html5colorpicker" onchange="MarineiconColor(marinecolor.value);" value="#<?php if (isset($_COOKIE['MarineIconColor'])) print $_COOKIE['MarineIconColor']; elseif (isset($globalMarineIconColor)) print $globalMarineIconColor; else print 'ff0000'; ?>">
924
+			<input type="color" name="marinecolor" id="html5colorpicker" onchange="MarineiconColor(marinecolor.value);" value="#<?php if (isset($_COOKIE['MarineIconColor'])) {
925
+	print $_COOKIE['MarineIconColor'];
926
+} elseif (isset($globalMarineIconColor)) {
927
+	print $globalMarineIconColor;
928
+} else {
929
+	print 'ff0000';
930
+}
931
+?>">
601 932
 		    </li>
602 933
 <?php
603 934
 	}
@@ -605,9 +936,19 @@  discard block
 block discarded – undo
605 936
 <?php
606 937
 	if (isset($globalTracker) && $globalTracker === TRUE) {
607 938
 ?>
608
-		    <li><input type="checkbox" name="trackercolorforce" value="1" onclick="TrackericonColorForce(this)" <?php if (isset($_COOKIE['TrackerIconColorForce']) && $_COOKIE['TrackerIconColorForce'] == 'true') print 'checked'; ?> ><?php echo _("Force Tracker color"); ?>&nbsp;
939
+		    <li><input type="checkbox" name="trackercolorforce" value="1" onclick="TrackericonColorForce(this)" <?php if (isset($_COOKIE['TrackerIconColorForce']) && $_COOKIE['TrackerIconColorForce'] == 'true') {
940
+	print 'checked';
941
+}
942
+?> ><?php echo _("Force Tracker color"); ?>&nbsp;
609 943
 		    <!--<li><?php echo _("Tracker icon color:"); ?>-->
610
-			<input type="color" name="trackercolor" id="html5colorpicker" onchange="TrackericonColor(trackercolor.value);" value="#<?php if (isset($_COOKIE['TrackerIconColor'])) print $_COOKIE['TrackerIconColor']; elseif (isset($globalTrackerIconColor)) print $globalTrackerIconColor; else print 'ff0000'; ?>">
944
+			<input type="color" name="trackercolor" id="html5colorpicker" onchange="TrackericonColor(trackercolor.value);" value="#<?php if (isset($_COOKIE['TrackerIconColor'])) {
945
+	print $_COOKIE['TrackerIconColor'];
946
+} elseif (isset($globalTrackerIconColor)) {
947
+	print $globalTrackerIconColor;
948
+} else {
949
+	print 'ff0000';
950
+}
951
+?>">
611 952
 		    </li>
612 953
 <?php
613 954
 	}
@@ -615,22 +956,46 @@  discard block
 block discarded – undo
615 956
 ?>
616 957
 		    <li><?php echo _("Distance unit:"); ?>
617 958
 			<select class="selectpicker" onchange="unitdistance(this);">
618
-			    <option value="km"<?php if ((!isset($_COOKIE['unitdistance']) && (!isset($globalUnitDistance) || (isset($globalUnitDistance) && $globalUnitDistance == 'km'))) || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'km')) echo ' selected'; ?>>km</option>
619
-			    <option value="nm"<?php if ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'nm') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'nm')) echo ' selected'; ?>>nm</option>
620
-			    <option value="mi"<?php if ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'mi') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'mi')) echo ' selected'; ?>>mi</option>
959
+			    <option value="km"<?php if ((!isset($_COOKIE['unitdistance']) && (!isset($globalUnitDistance) || (isset($globalUnitDistance) && $globalUnitDistance == 'km'))) || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'km')) {
960
+	echo ' selected';
961
+}
962
+?>>km</option>
963
+			    <option value="nm"<?php if ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'nm') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'nm')) {
964
+	echo ' selected';
965
+}
966
+?>>nm</option>
967
+			    <option value="mi"<?php if ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'mi') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'mi')) {
968
+	echo ' selected';
969
+}
970
+?>>mi</option>
621 971
 		        </select>
622 972
 		    </li>
623 973
 		    <li><?php echo _("Altitude unit:"); ?>
624 974
 			<select class="selectpicker" onchange="unitaltitude(this);">
625
-			    <option value="m"<?php if ((!isset($_COOKIE['unitaltitude']) && (!isset($globalUnitAltitude) || (isset($globalUnitAltitude) && $globalUnitAltitude == 'm'))) || (isset($_COOKIE['unitaltitude']) && $_COOKIE['unitaltitude'] == 'm')) echo ' selected'; ?>>m</option>
626
-			    <option value="feet"<?php if ((!isset($_COOKIE['unitaltitude']) && isset($globalUnitAltitude) && $globalUnitAltitude == 'feet') || (isset($_COOKIE['unitaltitude']) && $_COOKIE['unitaltitude'] == 'feet')) echo ' selected'; ?>>feet</option>
975
+			    <option value="m"<?php if ((!isset($_COOKIE['unitaltitude']) && (!isset($globalUnitAltitude) || (isset($globalUnitAltitude) && $globalUnitAltitude == 'm'))) || (isset($_COOKIE['unitaltitude']) && $_COOKIE['unitaltitude'] == 'm')) {
976
+	echo ' selected';
977
+}
978
+?>>m</option>
979
+			    <option value="feet"<?php if ((!isset($_COOKIE['unitaltitude']) && isset($globalUnitAltitude) && $globalUnitAltitude == 'feet') || (isset($_COOKIE['unitaltitude']) && $_COOKIE['unitaltitude'] == 'feet')) {
980
+	echo ' selected';
981
+}
982
+?>>feet</option>
627 983
 		        </select>
628 984
 		    </li>
629 985
 		    <li><?php echo _("Speed unit:"); ?>
630 986
 			<select class="selectpicker" onchange="unitspeed(this);">
631
-			    <option value="kmh"<?php if ((!isset($_COOKIE['unitspeed']) && (!isset($globalUnitSpeed) || (isset($globalUnitSpeed) && $globalUnitSpeed == 'kmh'))) || (isset($_COOKIE['unitspeed']) && $_COOKIE['unitspeed'] == 'kmh')) echo ' selected'; ?>>km/h</option>
632
-			    <option value="mph"<?php if ((!isset($_COOKIE['unitspeed']) && isset($globalUnitSpeed) && $globalUnitSpeed == 'mph') || (isset($_COOKIE['unitspeed']) && $_COOKIE['unitspeed'] == 'mph')) echo ' selected'; ?>>mph</option>
633
-			    <option value="knots"<?php if ((!isset($_COOKIE['unitspeed']) && isset($globalUnitSpeed) && $globalUnitSpeed == 'knots') || (isset($_COOKIE['unitspeed']) && $_COOKIE['unitspeed'] == 'knots')) echo ' selected'; ?>>knots</option>
987
+			    <option value="kmh"<?php if ((!isset($_COOKIE['unitspeed']) && (!isset($globalUnitSpeed) || (isset($globalUnitSpeed) && $globalUnitSpeed == 'kmh'))) || (isset($_COOKIE['unitspeed']) && $_COOKIE['unitspeed'] == 'kmh')) {
988
+	echo ' selected';
989
+}
990
+?>>km/h</option>
991
+			    <option value="mph"<?php if ((!isset($_COOKIE['unitspeed']) && isset($globalUnitSpeed) && $globalUnitSpeed == 'mph') || (isset($_COOKIE['unitspeed']) && $_COOKIE['unitspeed'] == 'mph')) {
992
+	echo ' selected';
993
+}
994
+?>>mph</option>
995
+			    <option value="knots"<?php if ((!isset($_COOKIE['unitspeed']) && isset($globalUnitSpeed) && $globalUnitSpeed == 'knots') || (isset($_COOKIE['unitspeed']) && $_COOKIE['unitspeed'] == 'knots')) {
996
+	echo ' selected';
997
+}
998
+?>>knots</option>
634 999
 		        </select>
635 1000
 		    </li>
636 1001
 
@@ -648,9 +1013,18 @@  discard block
 block discarded – undo
648 1013
 		    <?php
649 1014
 			if (((isset($globalVATSIM) && $globalVATSIM) || isset($globalIVAO) && $globalIVAO || isset($globalphpVMS) && $globalphpVMS) && (!isset($globalMapVAchoose) || $globalMapVAchoose)) {
650 1015
 		    ?>
651
-			<?php if (isset($globalVATSIM) && $globalVATSIM) { ?><li><input type="checkbox" name="vatsim" value="1" onclick="clickVATSIM(this)" <?php if ((isset($_COOKIE['ShowVATSIM']) && $_COOKIE['ShowVATSIM'] == 'true') || !isset($_COOKIE['ShowVATSIM'])) print 'checked'; ?> ><?php echo _("Display VATSIM data"); ?></li><?php } ?>
652
-			<?php if (isset($globalIVAO) && $globalIVAO) { ?><li><input type="checkbox" name="ivao" value="1" onclick="clickIVAO(this)" <?php if ((isset($_COOKIE['ShowIVAO']) && $_COOKIE['ShowIVAO'] == 'true') || !isset($_COOKIE['ShowIVAO'])) print 'checked'; ?> ><?php echo _("Display IVAO data"); ?></li><?php } ?>
653
-			<?php if (isset($globalphpVMS) && $globalphpVMS) { ?><li><input type="checkbox" name="phpvms" value="1" onclick="clickphpVMS(this)" <?php if ((isset($_COOKIE['ShowVMS']) && $_COOKIE['ShowVMS'] == 'true') || !isset($_COOKIE['ShowVMS'])) print 'checked'; ?> ><?php echo _("Display phpVMS data"); ?></li><?php } ?>
1016
+			<?php if (isset($globalVATSIM) && $globalVATSIM) { ?><li><input type="checkbox" name="vatsim" value="1" onclick="clickVATSIM(this)" <?php if ((isset($_COOKIE['ShowVATSIM']) && $_COOKIE['ShowVATSIM'] == 'true') || !isset($_COOKIE['ShowVATSIM'])) {
1017
+	print 'checked';
1018
+}
1019
+?> ><?php echo _("Display VATSIM data"); ?></li><?php } ?>
1020
+			<?php if (isset($globalIVAO) && $globalIVAO) { ?><li><input type="checkbox" name="ivao" value="1" onclick="clickIVAO(this)" <?php if ((isset($_COOKIE['ShowIVAO']) && $_COOKIE['ShowIVAO'] == 'true') || !isset($_COOKIE['ShowIVAO'])) {
1021
+	print 'checked';
1022
+}
1023
+?> ><?php echo _("Display IVAO data"); ?></li><?php } ?>
1024
+			<?php if (isset($globalphpVMS) && $globalphpVMS) { ?><li><input type="checkbox" name="phpvms" value="1" onclick="clickphpVMS(this)" <?php if ((isset($_COOKIE['ShowVMS']) && $_COOKIE['ShowVMS'] == 'true') || !isset($_COOKIE['ShowVMS'])) {
1025
+	print 'checked';
1026
+}
1027
+?> ><?php echo _("Display phpVMS data"); ?></li><?php } ?>
654 1028
 		    <?php
655 1029
 			}
656 1030
 		    ?>
@@ -658,10 +1032,16 @@  discard block
 block discarded – undo
658 1032
 			if (!(isset($globalVA) && $globalVA) && !(isset($globalVATSIM) && $globalVATSIM) && !(isset($globalIVAO) && $globalIVAO) && !(isset($globalphpVMS) && $globalphpVMS) && isset($globalSBS1) && $globalSBS1 && isset($globalAPRS) && $globalAPRS && (!isset($globalMapchoose) || $globalMapchoose)) {
659 1033
 		    ?>
660 1034
 			<?php if (isset($globalSBS1) && $globalSBS1) { ?>
661
-			    <li><div class="checkbox"><label><input type="checkbox" name="sbs" value="1" onclick="clickSBS1(this)" <?php if ((isset($_COOKIE['ShowSBS1']) && $_COOKIE['ShowSBS1'] == 'true') || !isset($_COOKIE['ShowSBS1'])) print 'checked'; ?> ><?php echo _("Display ADS-B data"); ?></label></div></li>
1035
+			    <li><div class="checkbox"><label><input type="checkbox" name="sbs" value="1" onclick="clickSBS1(this)" <?php if ((isset($_COOKIE['ShowSBS1']) && $_COOKIE['ShowSBS1'] == 'true') || !isset($_COOKIE['ShowSBS1'])) {
1036
+	print 'checked';
1037
+}
1038
+?> ><?php echo _("Display ADS-B data"); ?></label></div></li>
662 1039
 			<?php } ?>
663 1040
 			<?php if (isset($globalAPRS) && $globalAPRS) { ?>
664
-			    <li><div class="checkbox"><label><input type="checkbox" name="aprs" value="1" onclick="clickAPRS(this)" <?php if ((isset($_COOKIE['ShowAPRS']) && $_COOKIE['ShowAPRS'] == 'true') || !isset($_COOKIE['ShowAPRS'])) print 'checked'; ?> ><?php echo _("Display APRS data"); ?></label></div></li>
1041
+			    <li><div class="checkbox"><label><input type="checkbox" name="aprs" value="1" onclick="clickAPRS(this)" <?php if ((isset($_COOKIE['ShowAPRS']) && $_COOKIE['ShowAPRS'] == 'true') || !isset($_COOKIE['ShowAPRS'])) {
1042
+	print 'checked';
1043
+}
1044
+?> ><?php echo _("Display APRS data"); ?></label></div></li>
665 1045
 			<?php } ?>
666 1046
 		    <?php
667 1047
 			}
@@ -678,7 +1058,9 @@  discard block
 block discarded – undo
678 1058
 				}
679 1059
 				foreach($allairlinenames as $airline) {
680 1060
 					$airline_name = $airline['airline_name'];
681
-					if (strlen($airline_name) > 30) $airline_name = substr($airline_name,0,30).'...';
1061
+					if (strlen($airline_name) > 30) {
1062
+						$airline_name = substr($airline_name,0,30).'...';
1063
+					}
682 1064
 					if (isset($_COOKIE['filter_Airlines']) && in_array($airline['airline_icao'],explode(',',$_COOKIE['filter_Airlines']))) {
683 1065
 						echo '<option value="'.$airline['airline_icao'].'" selected>'.$airline_name.'</option>';
684 1066
 					} else {
@@ -696,7 +1078,10 @@  discard block
 block discarded – undo
696 1078
 		    <li><?php echo _("Display alliance:"); ?>
697 1079
 		    <br/>
698 1080
 			<select class="selectpicker" onchange="alliance(this);" id="display_alliance">
699
-			    <option value="all"<?php if (!isset($_COOKIE['filter_alliance']) || $_COOKIE['filter_alliance'] == 'all' || $_COOKIE['filter_alliance'] == '') echo ' selected'; ?>><?php echo _("All"); ?></option>
1081
+			    <option value="all"<?php if (!isset($_COOKIE['filter_alliance']) || $_COOKIE['filter_alliance'] == 'all' || $_COOKIE['filter_alliance'] == '') {
1082
+	echo ' selected';
1083
+}
1084
+?>><?php echo _("All"); ?></option>
700 1085
 			    <?php
701 1086
 				foreach($allalliancenames as $alliance) {
702 1087
 					$alliance_name = $alliance['alliance'];
@@ -755,10 +1140,22 @@  discard block
 block discarded – undo
755 1140
 		    ?>
756 1141
 		    <li><?php echo _("Display airlines of type:"); ?><br/>
757 1142
 			<select class="selectpicker" onchange="airlinestype(this);">
758
-			    <option value="all"<?php if (!isset($_COOKIE['filter_airlinestype']) || $_COOKIE['filter_airlinestype'] == 'all' || $_COOKIE['filter_airlinestype'] == '') echo ' selected'; ?>><?php echo _("All"); ?></option>
759
-			    <option value="passenger"<?php if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] == 'passenger') echo ' selected'; ?>><?php echo _("Passenger"); ?></option>
760
-			    <option value="cargo"<?php if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] == 'cargo') echo ' selected'; ?>><?php echo _("Cargo"); ?></option>
761
-			    <option value="military"<?php if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] == 'military') echo ' selected'; ?>><?php echo _("Military"); ?></option>
1143
+			    <option value="all"<?php if (!isset($_COOKIE['filter_airlinestype']) || $_COOKIE['filter_airlinestype'] == 'all' || $_COOKIE['filter_airlinestype'] == '') {
1144
+	echo ' selected';
1145
+}
1146
+?>><?php echo _("All"); ?></option>
1147
+			    <option value="passenger"<?php if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] == 'passenger') {
1148
+	echo ' selected';
1149
+}
1150
+?>><?php echo _("Passenger"); ?></option>
1151
+			    <option value="cargo"<?php if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] == 'cargo') {
1152
+	echo ' selected';
1153
+}
1154
+?>><?php echo _("Cargo"); ?></option>
1155
+			    <option value="military"<?php if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] == 'military') {
1156
+	echo ' selected';
1157
+}
1158
+?>><?php echo _("Military"); ?></option>
762 1159
 			</select>
763 1160
 		    </li>
764 1161
 		    <?php
@@ -772,7 +1169,10 @@  discard block
 block discarded – undo
772 1169
 		    ?>
773 1170
 		    <li>
774 1171
 			<?php echo _("Display vessels with MMSI:"); ?>
775
-			<input type="text" name="mmsifilter" onchange="mmsifilter();" id="mmsifilter" value="<?php if (isset($_COOKIE['filter_mmsi'])) print $_COOKIE['filter_mmsi']; ?>" />
1172
+			<input type="text" name="mmsifilter" onchange="mmsifilter();" id="mmsifilter" value="<?php if (isset($_COOKIE['filter_mmsi'])) {
1173
+	print $_COOKIE['filter_mmsi'];
1174
+}
1175
+?>" />
776 1176
 		    </li>
777 1177
 			<?php
778 1178
 				if (isset($globalVM) && $globalVM) {
@@ -803,7 +1203,10 @@  discard block
 block discarded – undo
803 1203
 		    ?>
804 1204
 		    <li>
805 1205
 			<?php echo _("Display with ident:"); ?>
806
-			<input type="text" name="identfilter" onchange="identfilter();" id="identfilter" value="<?php if (isset($_COOKIE['filter_ident'])) print $_COOKIE['filter_ident']; ?>" />
1206
+			<input type="text" name="identfilter" onchange="identfilter();" id="identfilter" value="<?php if (isset($_COOKIE['filter_ident'])) {
1207
+	print $_COOKIE['filter_ident'];
1208
+}
1209
+?>" />
807 1210
 		    </li>
808 1211
 		</ul>
809 1212
 	    </form>
@@ -819,7 +1222,10 @@  discard block
 block discarded – undo
819 1222
 	    <h1 class="sidebar-header"><?php echo _("Satellites"); ?><span class="sidebar-close"><i class="fa fa-caret-left"></i></span></h1>
820 1223
 	    <form>
821 1224
 		<ul>
822
-		    <li><div class="checkbox"><label><input type="checkbox" name="displayiss" value="1" onclick="clickDisplayISS(this)" <?php if ((isset($_COOKIE['displayiss']) && $_COOKIE['displayiss'] == 'true') || !isset($_COOKIE['displayiss'])) print 'checked'; ?> ><?php echo _("Show ISS, Tiangong-1 and Tiangong-2 on map"); ?></label></div></li>
1225
+		    <li><div class="checkbox"><label><input type="checkbox" name="displayiss" value="1" onclick="clickDisplayISS(this)" <?php if ((isset($_COOKIE['displayiss']) && $_COOKIE['displayiss'] == 'true') || !isset($_COOKIE['displayiss'])) {
1226
+	print 'checked';
1227
+}
1228
+?> ><?php echo _("Show ISS, Tiangong-1 and Tiangong-2 on map"); ?></label></div></li>
823 1229
 		    <li><?php echo _("Type:"); ?>
824 1230
 			<select class="selectpicker" multiple onchange="sattypes(this);">
825 1231
 			    <?php
@@ -827,25 +1233,45 @@  discard block
 block discarded – undo
827 1233
 				$types = $Satellite->get_tle_types();
828 1234
 				foreach ($types as $type) {
829 1235
 					$type_name = $type['tle_type'];
830
-					if ($type_name == 'musson') $type_name = 'Russian LEO Navigation';
831
-					else if ($type_name == 'nnss') $type_name = 'Navi Navigation Satellite System';
832
-					else if ($type_name == 'sbas') $type_name = 'Satellite-Based Augmentation System';
833
-					else if ($type_name == 'glo-ops') $type_name = 'Glonass Operational';
834
-					else if ($type_name == 'gps-ops') $type_name = 'GPS Operational';
835
-					else if ($type_name == 'argos') $type_name = 'ARGOS Data Collection System';
836
-					else if ($type_name == 'tdrss') $type_name = 'Tracking and Data Relay Satellite System';
837
-					else if ($type_name == 'sarsat') $type_name = 'Search & Rescue';
838
-					else if ($type_name == 'dmc') $type_name = 'Disaster Monitoring';
839
-					else if ($type_name == 'resource') $type_name = 'Earth Resources';
840
-					else if ($type_name == 'stations') $type_name = 'Space Stations';
841
-					else if ($type_name == 'geo') $type_name = 'Geostationary';
842
-					else if ($type_name == 'amateur') $type_name = 'Amateur Radio';
843
-					else if ($type_name == 'x-comm') $type_name = 'Experimental';
844
-					else if ($type_name == 'other-comm') $type_name = 'Other Comm';
845
-					else if ($type_name == 'science') $type_name = 'Space & Earth Science';
846
-					else if ($type_name == 'military') $type_name = 'Miscellaneous Military';
847
-					else if ($type_name == 'radar') $type_name = 'Radar Calibration';
848
-					else if ($type_name == 'tle-new') $type_name = 'Last 30 days launches';
1236
+					if ($type_name == 'musson') {
1237
+						$type_name = 'Russian LEO Navigation';
1238
+					} else if ($type_name == 'nnss') {
1239
+						$type_name = 'Navi Navigation Satellite System';
1240
+					} else if ($type_name == 'sbas') {
1241
+						$type_name = 'Satellite-Based Augmentation System';
1242
+					} else if ($type_name == 'glo-ops') {
1243
+						$type_name = 'Glonass Operational';
1244
+					} else if ($type_name == 'gps-ops') {
1245
+						$type_name = 'GPS Operational';
1246
+					} else if ($type_name == 'argos') {
1247
+						$type_name = 'ARGOS Data Collection System';
1248
+					} else if ($type_name == 'tdrss') {
1249
+						$type_name = 'Tracking and Data Relay Satellite System';
1250
+					} else if ($type_name == 'sarsat') {
1251
+						$type_name = 'Search & Rescue';
1252
+					} else if ($type_name == 'dmc') {
1253
+						$type_name = 'Disaster Monitoring';
1254
+					} else if ($type_name == 'resource') {
1255
+						$type_name = 'Earth Resources';
1256
+					} else if ($type_name == 'stations') {
1257
+						$type_name = 'Space Stations';
1258
+					} else if ($type_name == 'geo') {
1259
+						$type_name = 'Geostationary';
1260
+					} else if ($type_name == 'amateur') {
1261
+						$type_name = 'Amateur Radio';
1262
+					} else if ($type_name == 'x-comm') {
1263
+						$type_name = 'Experimental';
1264
+					} else if ($type_name == 'other-comm') {
1265
+						$type_name = 'Other Comm';
1266
+					} else if ($type_name == 'science') {
1267
+						$type_name = 'Space & Earth Science';
1268
+					} else if ($type_name == 'military') {
1269
+						$type_name = 'Miscellaneous Military';
1270
+					} else if ($type_name == 'radar') {
1271
+						$type_name = 'Radar Calibration';
1272
+					} else if ($type_name == 'tle-new') {
1273
+						$type_name = 'Last 30 days launches';
1274
+					}
849 1275
 					
850 1276
 					if (isset($_COOKIE['sattypes']) && in_array($type['tle_type'],explode(',',$_COOKIE['sattypes']))) {
851 1277
 						print '<option value="'.$type['tle_type'].'" selected>'.$type_name.'</option>';
Please login to merge, or discard this patch.