Completed
Push — master ( 550aa3...43c414 )
by Yannick
59:36 queued 29:37
created

live-geojson.php (1 issue)

Upgrade to new PHP Analysis Engine

These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more

1
<?php
2
require_once('require/class.Connection.php');
3
require_once('require/class.Common.php');
4
$tracker = false;
5
$marine = false;
6
$usecoord = false;
7
if (isset($_GET['tracker'])) {
8
    $tracker = true;
9
}
10
if (isset($_GET['marine'])) {
11
    $marine = true;
12
}
13
if ($tracker) {
14
    require_once('require/class.Tracker.php');
15
    require_once('require/class.TrackerLive.php');
16
    require_once('require/class.TrackerArchive.php');
17
} elseif ($marine) {
18
    require_once('require/class.Marine.php');
19
    require_once('require/class.MarineLive.php');
20
    require_once('require/class.MarineArchive.php');
21
} else {
22
    require_once('require/class.Spotter.php');
23
    require_once('require/class.SpotterLive.php');
24
    require_once('require/class.SpotterArchive.php');
25
}
26
27
$begintime = microtime(true);
28
if ($tracker) {
29
	$TrackerLive = new TrackerLive();
30
	$Tracker = new Tracker();
31
	$TrackerArchive = new TrackerArchive();
32
} elseif ($marine) {
33
	$MarineLive = new MarineLive();
34
	$Marine = new Marine();
35
	$MarineArchive = new MarineArchive();
36
} else {
37
	$SpotterLive = new SpotterLive();
38
	$Spotter = new Spotter();
39
	$SpotterArchive = new SpotterArchive();
40
}
41
$Common = new Common();
42
43
if (isset($_GET['download'])) {
44
    if ($_GET['download'] == "true")
45
    {
46
	header('Content-disposition: attachment; filename="flightairmap.json"');
47
    }
48
}
49
header('Content-Type: text/javascript');
50
51
if (!isset($globalJsonCompress)) $compress = true;
52
else $compress = $globalJsonCompress;
53
54
$from_archive = false;
55
$min = true;
56
$allhistory = false;
57
$filter['source'] = array();
58
if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalVATSIM) && $globalVATSIM && isset($_COOKIE['filter_ShowVATSIM']) && $_COOKIE['filter_ShowVATSIM'] == 'true') $filter['source'] = array_merge($filter['source'],array('vatsimtxt'));
59
if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalIVAO) && $globalIVAO && isset($_COOKIE['filter_ShowIVAO']) && $_COOKIE['filter_ShowIVAO'] == 'true') $filter['source'] = array_merge($filter['source'],array('whazzup'));
60
if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalphpVMS) && $globalphpVMS && isset($_COOKIE['filter_ShowVMS']) && $_COOKIE['filter_ShowVMS'] == 'true') $filter['source'] = array_merge($filter['source'],array('phpvmacars'));
61
if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalSBS1) && $globalSBS1 && isset($_COOKIE['filter_ShowSBS1']) && $_COOKIE['filter_ShowSBS1'] == 'true') $filter['source'] = array_merge($filter['source'],array('sbs','famaprs'));
62
if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalAPRS) && $globalAPRS && isset($_COOKIE['filter_ShowAPRS']) && $_COOKIE['filter_ShowAPRS'] == 'true') $filter['source'] = array_merge($filter['source'],array('aprs'));
63
if (isset($_COOKIE['filter_ident']) && $_COOKIE['filter_ident'] != '') $filter['ident'] = filter_var($_COOKIE['filter_ident'],FILTER_SANITIZE_STRING);
64
if (isset($_COOKIE['filter_mmsi']) && $_COOKIE['filter_mmsi'] != '') $filter['mmsi'] = filter_var($_COOKIE['filter_mmsi'],FILTER_SANITIZE_STRING);
65
if (isset($_COOKIE['filter_Airlines']) && $_COOKIE['filter_Airlines'] != '') $filter['airlines'] = filter_var_array(explode(',',$_COOKIE['filter_Airlines']),FILTER_SANITIZE_STRING);
66
if (isset($_COOKIE['filter_Sources']) && $_COOKIE['filter_Sources'] != '') $filter['source_aprs'] = filter_var_array(explode(',',$_COOKIE['filter_Sources']),FILTER_SANITIZE_STRING);
67
if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] != 'all') $filter['airlinestype'] = filter_var($_COOKIE['filter_airlinestype'],FILTER_SANITIZE_STRING);
68
if (isset($_COOKIE['filter_alliance']) && $_COOKIE['filter_alliance'] != 'all') $filter['alliance'] = filter_var($_COOKIE['filter_alliance'],FILTER_SANITIZE_STRING);
69
70
if (isset($globalMapPopup) && !$globalMapPopup && !(isset($_COOKIE['flightpopup']) && $_COOKIE['flightpopup'] == 'true')) {
71
	$min = true;
72
} else $min = false;
73
74
$spotter_array = array();
75
76
if (isset($_GET['ident'])) {
77
	$ident = urldecode(filter_input(INPUT_GET,'ident',FILTER_SANITIZE_STRING));
78
	if ($tracker) {
79
		$spotter_array = $TrackerLive->getLastLiveTrackerDataByIdent($ident);
80
	} elseif ($marine) {
81
		$spotter_array = $MarineLive->getLastLiveMarineDataByIdent($ident);
82
	} else {
83
		$spotter_array = $SpotterLive->getLastLiveSpotterDataByIdent($ident);
84
		if (empty($spotter_array)) {
85
			$from_archive = true;
86
			$spotter_array = $SpotterArchive->getLastArchiveSpotterDataByIdent($ident);
87
		}
88
	}
89
	$allhistory = true;
90
} elseif (isset($_GET['flightaware_id'])) {
91
	$flightaware_id = filter_input(INPUT_GET,'flightaware_id',FILTER_SANITIZE_STRING);
92
	$spotter_array = $SpotterLive->getLastLiveSpotterDataById($flightaware_id);
93
	if (empty($spotter_array)) {
94
		$from_archive = true;
95
		$spotter_array = $SpotterArchive->getLastArchiveSpotterDataById($flightaware_id);
96
	}
97
	$allhistory = true;
98
} elseif (isset($_GET['famtrack_id'])) {
99
	$famtrack_id = urldecode(filter_input(INPUT_GET,'famtrack_id',FILTER_SANITIZE_STRING));
100
	$spotter_array = $TrackerLive->getLastLiveTrackerDataById($famtrack_id);
101
	$allhistory = true;
102
} elseif (isset($_GET['fammarine_id'])) {
103
	$fammarine_id = urldecode(filter_input(INPUT_GET,'fammarine_id',FILTER_SANITIZE_STRING));
104
	$spotter_array = $MarineLive->getLastLiveMarineDataById($fammarine_id);
105
	$allhistory = true;
106
} elseif (isset($globalMapUseBbox) && $globalMapUseBbox && isset($_GET['coord']) && (!isset($globalMapPopup) || $globalMapPopup || (isset($_COOKIE['flightpopup']) && $_COOKIE['flightpopup'] == 'true'))) {
107
//} elseif (isset($_GET['coord'])) {
108
	$usecoord = true;
109
	$coord = explode(',',$_GET['coord']);
110
	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) 
111
	    && $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) {
112
		if ($tracker) {
113
			$spotter_array = $TrackerLive->getLiveTrackerDatabyCoord($coord,$filter);
114
		} elseif ($marine) {
115
			$spotter_array = $MarineLive->getLiveMarineDatabyCoord($coord,$filter);
116
		} else {
117
			$spotter_array = $SpotterLive->getLiveSpotterDatabyCoord($coord,$filter);
118
		}
119
	}
120
} elseif (isset($globalMapUseBbox) && $globalMapUseBbox && isset($_GET['coord']) && $min) {
121
	$usecoord = true;
122
	$coord = explode(',',$_GET['coord']);
123
	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) 
124
	    && $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) {
125
		if ($tracker) {
126
			$spotter_array = $TrackerLive->getMinLiveTrackerDatabyCoord($coord,$filter);
127
		} elseif ($marine) {
128
			$spotter_array = $MarineLive->getMinLiveMarineDatabyCoord($coord,$filter);
129
		} else {
130
			$spotter_array = $SpotterLive->getMinLiveSpotterDatabyCoord($coord,$filter);
131
		}
132
	}
133
} elseif (isset($_GET['archive']) && isset($_GET['begindate']) && isset($_GET['enddate']) && isset($_GET['speed']) && !isset($_GET['tracker']) && !isset($_GET['marine'])) {
134
	$from_archive = true;
135
//	$begindate = filter_input(INPUT_GET,'begindate',FILTER_VALIDATE_REGEXP,array("options"=>array("regexp"=>'~^\d{4}/\d{2}/\d{2}$~')));
136
//	$enddate = filter_input(INPUT_GET,'enddate',FILTER_VALIDATE_REGEXP,array("options"=>array("regexp"=>'~^\d{4}/\d{2}/\d{2}$~')));
137
	$begindate = filter_input(INPUT_GET,'begindate',FILTER_SANITIZE_NUMBER_INT);
138
	$enddate = filter_input(INPUT_GET,'enddate',FILTER_SANITIZE_NUMBER_INT);
139
	$archivespeed = filter_input(INPUT_GET,'speed',FILTER_SANITIZE_NUMBER_INT);
140
	$begindate = date('Y-m-d H:i:s',$begindate);
141
	$enddate = date('Y-m-d H:i:s',$enddate);
142
	$spotter_array = $SpotterArchive->getMinLiveSpotterData($begindate,$enddate,$filter);
143
} elseif ($min) {
144
	if ($tracker) {
145
		$spotter_array = $TrackerLive->getMinLiveTrackerData($filter);
146
	} elseif ($marine) {
147
		$spotter_array = $MarineLive->getMinLiveMarineData($filter);
148
	} else {
149
		$spotter_array = $SpotterLive->getMinLiveSpotterData($filter);
150
	}
151
#	$min = true;
152
} else {
153
	if ($tracker) {
154
		$spotter_array = $TrackerLive->getLiveTrackerData('','',$filter);
155
	} elseif ($marine) {
156
		$spotter_array = $marineLive->getLiveMarineData('','',$filter);
157
	} else {
158
		$spotter_array = $SpotterLive->getLiveSpotterData('','',$filter);
159
	}
160
}
161
162
if ($usecoord) {
163
	if (isset($_GET['archive'])) {
164
		$flightcnt = $SpotterArchive->getLiveSpotterCount($begindate,$enddate,$filter);
165
	} else {
166
		if ($tracker) {
167
			$flightcnt = $TrackerLive->getLiveTrackerCount($filter);
168
		} elseif ($marine) {
169
			$flightcnt = $MarineLive->getLiveMarineCount($filter);
170
		} else {
171
			$flightcnt = $SpotterLive->getLiveSpotterCount($filter);
172
		}
173
	}
174
	if ($flightcnt == '') $flightcnt = 0;
175
} else $flightcnt = 0;
176
177
$sqltime = round(microtime(true)-$begintime,2);
178
179
$currenttime = filter_input(INPUT_GET,'currenttime',FILTER_SANITIZE_NUMBER_INT);
180
if ($currenttime != '') $currenttime = round($currenttime/1000);
181
182
if ((!isset($_COOKIE['flightestimation']) && isset($globalMapEstimation) && $globalMapEstimation == FALSE) || (isset($_COOKIE['flightestimation']) && $_COOKIE['flightestimation'] == 'false')) $usenextlatlon = false;
183
else $usenextlatlon = true;
184
if ($usenextlatlon === false) $currenttime = '';
185
$j = 0;
186
$prev_flightaware_id = '';
187
$aircrafts_shadow = array();
188
$output = '{';
189
	$output .= '"type": "FeatureCollection",';
190
		if ($min) $output .= '"minimal": "true",';
191
		else $output .= '"minimal": "false",';
192
		//$output .= '"fc": "'.$flightcnt.'",';
193
		$output .= '"sqt": "'.$sqltime.'",';
194
195
		if (!empty($spotter_array) && is_array($spotter_array))
196
		{
197
			$output .= '"features": [';
198
			foreach($spotter_array as $spotter_item)
199
			{
200
				$j++;
201
				date_default_timezone_set('UTC');
202
203
				if (isset($spotter_item['image_thumbnail']) && $spotter_item['image_thumbnail'] != "")
204
				{
205
					$image = $spotter_item['image_thumbnail'];
206
				} else {
207
					$image = "images/placeholder_thumb.png";
208
				}
209
210
/*
211
				if ($prev_flightaware_id != $spotter_item['flightaware_id']) {
212
				    if ($prev_flightaware_id != '') {
213
						$output .= ']';
214
						$output .= '}';
215
						$output .= '},';
216
				    }
217
				$prev_flightaware_id = $spotter_item['flightaware_id'];
218
*/
219
220
				//location of aircraft
221
//				print_r($spotter_item);
222
				$output .= '{';
223
					$output .= '"type": "Feature",';
224
						//$output .= '"fc": "'.$flightcnt.'",';
225
						//$output .= '"sqt": "'.$sqltime.'",';
226
						if (isset($spotter_item['flightaware_id'])) {
227
							$output .= '"id": "'.$spotter_item['flightaware_id'].'",';
228
						} elseif (isset($spotter_item['famtrackid'])) {
229
							$output .= '"id": "'.$spotter_item['famtrackid'].'",';
230
						} elseif (isset($spotter_item['fammarine_id'])) {
231
							$output .= '"id": "'.$spotter_item['fammarine_id'].'",';
232
						}
233
						$output .= '"properties": {';
234
						if (isset($spotter_item['flightaware_id'])) {
235
							if ($compress) $output .= '"fi": "'.$spotter_item['flightaware_id'].'",';
236
							else $output .= '"flightaware_id": "'.$spotter_item['flightaware_id'].'",';
237
						} elseif (isset($spotter_item['famtrackid'])) {
238
							if ($compress) $output .= '"fti": "'.$spotter_item['famtrackid'].'",';
239
							else $output .= '"famtrackid": "'.$spotter_item['famtrackid'].'",';
240
						} elseif (isset($spotter_item['fammarine_id'])) {
241
							if ($compress) $output .= '"fmi": "'.$spotter_item['fammarine_id'].'",';
242
							else $output .= '"fammarineid": "'.$spotter_item['fammarine_id'].'",';
243
						}
244
							$output .= '"fc": "'.$flightcnt.'",';
245
							$output .= '"sqt": "'.$sqltime.'",';
246
							if (isset($begindate)) $output .= '"archive_date": "'.$begindate.'",';
247
248
/*
249
							if ($min) $output .= '"minimal": "true",';
250
							else $output .= '"minimal": "false",';
251
*/
252
							//$output .= '"fc": "'.$spotter_item['nb'].'",';
253
						if (isset($spotter_item['ident']) && $spotter_item['ident'] != '') {
254
							if ($compress) $output .= '"c": "'.str_replace('\\','',$spotter_item['ident']).'",';
255
							else $output .= '"callsign": "'.str_replace('\\','',$spotter_item['ident']).'",';
256
							//"
257
						} else {
258
							if ($compress) $output .= '"c": "NA",';
259
							else $output .= '"callsign": "NA",';
260
						}
261
						if (isset($spotter_item['registration'])) $output .= '"registration": "'.$spotter_item['registration'].'",';
262
						if (isset($spotter_item['aircraft_name']) && isset($spotter_item['aircraft_type'])) {
263
							$output .= '"aircraft_name": "'.$spotter_item['aircraft_name'].' ('.$spotter_item['aircraft_type'].')",';
264
							$output .= '"aircraft_wiki": "http://'.strtolower($globalLanguage).'.wikipedia.org/wiki/'.urlencode(str_replace(' ','_',$spotter_item['aircraft_name'])).'",';
265
						} elseif (isset($spotter_item['aircraft_type'])) {
266
							$output .= '"aircraft_name": "NA ('.$spotter_item['aircraft_type'].')",';
267
						} elseif (!$min) {
268
							$output .= '"aircraft_name": "NA",';
269
						}
270
						if (!$min && isset($spotter_item['aircraft_icao'])) {
271
							$output .= '"aircraft_icao": "'.$spotter_item['aircraft_icao'].'",';
272
						}
273
						if (!isset($spotter_item['aircraft_shadow']) && !$tracker) {
274
							if (!isset($spotter_item['aircraft_icao']) || $spotter_item['aircraft_icao'] == '') $spotter_item['aircraft_shadow'] = '';
275
							else {
276
								$aircraft_icao = $spotter_item['aircraft_icao'];
277
								if (isset($aircrafts_shadow[$aircraft_icao])) $spotter_item['aircraft_shadow'] = $aircrafts_shadow[$aircraft_icao];
278
								else {
279
									$aircraft_info = $Spotter->getAllAircraftInfo($spotter_item['aircraft_icao']);
280
									if (count($aircraft_info) > 0) $spotter_item['aircraft_shadow'] = $aircraft_info[0]['aircraft_shadow'];
281
									elseif (isset($spotter_item['format_source']) && $spotter_item['format_source'] == 'aprs') $spotter_item['aircraft_shadow'] = 'PA18.png';
282
									elseif ($aircraft_icao == 'PARAGLIDER') $spotter_item['aircraft_shadow'] = 'PARAGLIDER.png';
283
									else $spotter_item['aircraft_shadow'] = '';
284
									$aircrafts_shadow[$aircraft_icao] = $spotter_item['aircraft_shadow'];
285
								}
286
							}
287
						}
288
						if (!isset($spotter_item['aircraft_shadow']) || $spotter_item['aircraft_shadow'] == '') {
289
							if ($tracker) {
290
								if (isset($spotter_item['type']) && $spotter_item['type'] == 'Ambulance') {
291
									if ($compress) $output .= '"as": "ambulance.png",';
292
									else $output .= '"aircraft_shadow": "ambulance.png",';
293
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Police') {
294
									if ($compress) $output .= '"as": "police.png",';
295
									else $output .= '"aircraft_shadow": "police.png",';
296
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Yacht (Sail)') {
297
									if ($compress) $output .= '"as": "ship.png",';
298
									else $output .= '"aircraft_shadow": "ship.png",';
299
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Ship (Power Boat)') {
300
									if ($compress) $output .= '"as": "ship.png",';
301
									else $output .= '"aircraft_shadow": "ship.png",';
302
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Shuttle') {
303
									if ($compress) $output .= '"as": "ship.png",';
304
									else $output .= '"aircraft_shadow": "ship.png",';
305
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Truck') {
306
									if ($compress) $output .= '"as": "truck.png",';
307
									else $output .= '"aircraft_shadow": "truck.png",';
308
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Truck (18 Wheeler)') {
309
									if ($compress) $output .= '"as": "truck.png",';
310
									else $output .= '"aircraft_shadow": "truck.png",';
311
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Aircraft (small)') {
312
									if ($compress) $output .= '"as": "aircraft.png",';
313
									else $output .= '"aircraft_shadow": "aircraft.png",';
314
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Large Aircraft') {
315
									if ($compress) $output .= '"as": "aircraft.png",';
316
									else $output .= '"aircraft_shadow": "aircraft.png",';
317
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Helicopter') {
318
									if ($compress) $output .= '"as": "helico.png",';
319
									else $output .= '"aircraft_shadow": "helico.png",';
320
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Railroad Engine') {
321
									if ($compress) $output .= '"as": "rail.png",';
322
									else $output .= '"aircraft_shadow": "rail.png",';
323
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Firetruck') {
324
									if ($compress) $output .= '"as": "firetruck.png",';
325
									else $output .= '"aircraft_shadow": "firetruck.png",';
326
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Bus') {
327
									if ($compress) $output .= '"as": "bus.png",';
328
									else $output .= '"aircraft_shadow": "bus.png",';
329
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Phone') {
330
									if ($compress) $output .= '"as": "phone.png",';
331
									else $output .= '"aircraft_shadow": "phone.png",';
332
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Jogger') {
333
									if ($compress) $output .= '"as": "jogger.png",';
334
									else $output .= '"aircraft_shadow": "jogger.png",';
335
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Bike') {
336
									if ($compress) $output .= '"as": "bike.png",';
337
									else $output .= '"aircraft_shadow": "bike.png",';
338
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Motorcycle') {
339
									if ($compress) $output .= '"as": "motorcycle.png",';
340
									else $output .= '"aircraft_shadow": "motorcycle.png",';
341
								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Balloon') {
342
									if ($compress) $output .= '"as": "balloon.png",';
343
									else $output .= '"aircraft_shadow": "balloon.png",';
344
								} else {
345
									if ($compress) $output .= '"as": "car.png",';
346
									else $output .= '"aircraft_shadow": "car.png",';
347
								}
348
							} elseif ($marine) {
349
								if ($compress) $output .= '"as": "ship.png",';
350
								else $output .= '"aircraft_shadow": "ship.png",';
351
							} else {
352
								if ($compress) $output .= '"as": "default.png",';
353
								else $output .= '"aircraft_shadow": "default.png",';
354
							}
355
						} else {
356
							if ($compress) $output .= '"as": "'.$spotter_item['aircraft_shadow'].'",';
357
							else $output .= '"aircraft_shadow": "'.$spotter_item['aircraft_shadow'].'",';
358
						}
359
						if (isset($spotter_item['airline_name'])) {
360
							$output .= '"airline_name": "'.$spotter_item['airline_name'].'",';
361
						} elseif (!$min) {
362
							$output .= '"airline_name": "NA",';
363
						}
364
						if (isset($spotter_item['departure_airport'])) {
365
							if ($compress) $output .= '"dac": "'.$spotter_item['departure_airport'].'",';
366
							else $output .= '"departure_airport_code": "'.$spotter_item['departure_airport'].'",';
367
						}
368
						if (isset($spotter_item['departure_airport_city'])) {
369
							$output .= '"departure_airport": "'.$spotter_item['departure_airport_city'].', '.$spotter_item['departure_airport_country'].'",';
370
						}
371
						if (isset($spotter_item['departure_airport_time'])) {
372
							$output .= '"departure_airport_time": "'.$spotter_item['departure_airport_time'].'",';
373
						}
374
						if (isset($spotter_item['arrival_airport_time'])) {
375
							$output .= '"arrival_airport_time": "'.$spotter_item['arrival_airport_time'].'",';
376
						}
377
						if (isset($spotter_item['arrival_airport'])) {
378
							if ($compress) $output .= '"aac": "'.$spotter_item['arrival_airport'].'",';
379
							else $output .= '"arrival_airport_code": "'.$spotter_item['arrival_airport'].'",';
380
						}
381
						if (isset($spotter_item['arrival_airport_city'])) {
382
							$output .= '"arrival_airport": "'.$spotter_item['arrival_airport_city'].', '.$spotter_item['arrival_airport_country'].'",';
383
						}
384
						
385
						if (isset($spotter_item['date_iso_8601'])) {
386
							$output .= '"date_update": "'.date("M j, Y, g:i a T", strtotime($spotter_item['date_iso_8601'])).'",';
387
						}
388
						if (isset($spotter_item['date'])) {
389
							$output .= '"lu": "'.strtotime($spotter_item['date']).'",';
390
						}
391
						if (!$min) {
392
							$output .= '"latitude": "'.$spotter_item['latitude'].'",';
393
							$output .= '"longitude": "'.$spotter_item['longitude'].'",';
394
							$output .= '"ground_speed": "'.$spotter_item['ground_speed'].'",';
395
						}
396
						
397
						if (isset($spotter_item['altitude'])) {
398
							if ($compress) $output .= '"a": "'.$spotter_item['altitude'].'",';
399
							else $output .= '"altitude": "'.$spotter_item['altitude'].'",';
400
						}
401
						if ($compress)$output .= '"h": "'.$spotter_item['heading'].'",';
402
						else $output .= '"heading": "'.$spotter_item['heading'].'",';
403
						
404
						if ($currenttime != '') {
405
							if (strtotime($spotter_item['date']) < $currenttime) {
406
								if (isset($archivespeed)) {
407
									$nextcoord = $Common->nextcoord($spotter_item['latitude'],$spotter_item['longitude'],$spotter_item['ground_speed'],$spotter_item['heading'],$archivespeed,($currenttime-strtotime($spotter_item['date'])+$globalMapRefresh));
408
									$output .= '"nextlatlon": ['.$nextcoord['latitude'].','.$nextcoord['longitude'].'],';
409
								} elseif ($usenextlatlon) {
410
									$nextcoord = $Common->nextcoord($spotter_item['latitude'],$spotter_item['longitude'],$spotter_item['ground_speed'],$spotter_item['heading'],1,($currenttime-strtotime($spotter_item['date'])+$globalMapRefresh));
411
									$output .= '"nextlatlon": ['.$nextcoord['latitude'].','.$nextcoord['longitude'].'],';
412
								}
413
							}
414
						} else {
415
							if (isset($archivespeed)) {
416
								$nextcoord = $Common->nextcoord($spotter_item['latitude'],$spotter_item['longitude'],$spotter_item['ground_speed'],$spotter_item['heading'],$archivespeed);
417
								$output .= '"nextlatlon": ['.$nextcoord['latitude'].','.$nextcoord['longitude'].'],';
418
							} elseif ($usenextlatlon) {
419
								$nextcoord = $Common->nextcoord($spotter_item['latitude'],$spotter_item['longitude'],$spotter_item['ground_speed'],$spotter_item['heading']);
420
								$output .= '"nextlatlon": ['.$nextcoord['latitude'].','.$nextcoord['longitude'].'],';
421
							}
422
						}
423
424
						if (!$min) $output .= '"image": "'.$image.'",';
425
						if (isset($spotter_item['image_copyright']) && $spotter_item['image_copyright'] != '') {
426
							$output .= '"image_copyright": "'.str_replace('"',"'",trim(str_replace(array("\r\n","\r","\n","\\r","\\n","\\r\\n"),'',$spotter_item['image_copyright']))).'",';
427
						}
428
						if (isset($spotter_item['image_source_website'])) {
429
							$output .= '"image_source_website": "'.urlencode($spotter_item['image_source_website']).'",';
430
						}
431
						if (isset($spotter_item['squawk'])) {
432
							if ($compress) $output .= '"sq": "'.$spotter_item['squawk'].'",';
433
							else $output .= '"squawk": "'.$spotter_item['squawk'].'",';
434
						}
435
						if (isset($spotter_item['squawk_usage'])) {
436
							$output .= '"squawk_usage": "'.$spotter_item['squawk_usage'].'",';
437
						}
438
						if (isset($spotter_item['pilot_id'])) {
439
							$output .= '"pilot_id": "'.$spotter_item['pilot_id'].'",';
440
						}
441
						if (isset($spotter_item['pilot_name'])) {
442
							$output .= '"pilot_name": "'.$spotter_item['pilot_name'].'",';
443
						}
444
						if (isset($spotter_item['waypoints']) && $spotter_item['waypoints'] != '') {
445
							$output .= '"waypoints": "'.$spotter_item['waypoints'].'",';
446
						}
447
						if (isset($spotter_item['acars'])) {
448
							$output .= '"acars": "'.trim(str_replace(array("\r\n","\r","\n","\\r","\\n","\\r\\n"), '<br />',$spotter_item['acars']['message'])).'",';
449
						}
450
						// type when not aircraft ?
451
						if (isset($spotter_item['type'])) {
452
							if ($compress) $output .= '"t": "'.$spotter_item['type'].'"';
453
							else $output .= '"type": "'.$spotter_item['type'].'"';
454
						} elseif ($marine) {
455
							if ($compress) $output .= '"t": "ship"';
456
							else $output .= '"type": "ship"';
457
						} else {
458
							if ($compress) $output .= '"t": "aircraft"';
459
							else $output .= '"type": "aircraft"';
460
						}
461
						$output .= '},';
462
						$output .= '"geometry": {';
463
							$output .= '"type": "Point",';
464
								$output .= '"coordinates": [';
465
								if ($currenttime != '') {
466
									if (strtotime($spotter_item['date']) < $currenttime) {
467
										if (!isset($archivespeed)) $archivespeed = 1;
468
										$nextcoord = $Common->nextcoord($spotter_item['latitude'],$spotter_item['longitude'],$spotter_item['ground_speed'],$spotter_item['heading'],$archivespeed,$currenttime-strtotime($spotter_item['date']));
469
										$output .= $nextcoord['longitude'].','.$nextcoord['latitude'];
470
									} else {
471
										$output .= $spotter_item['longitude'].', ';
472
										$output .= $spotter_item['latitude'];
473
									}
474
								} else {
475
										$output .= $spotter_item['longitude'].', ';
476
										$output .= $spotter_item['latitude'];
477
								}
478
										/*
479
										.', ';
480
										$output .= $spotter_item['altitude']*30.48;
481
										$output .= ', '.strtotime($spotter_item['date']);
482
										*/
483
								$output .= ']';
484
							$output .= '}';
485
				$output .= '},';
486
					
487
			/*	} else {
488
								$output .= ', ';
489
								$output .= $spotter_item['longitude'].', ';
490
								$output .= $spotter_item['latitude'].', ';
491
								$output .= $spotter_item['altitude']*30.48;
492
								$output .= ', '.strtotime($spotter_item['date']);
493
494
				}
495
*/                
496
497
/*                
498
                //previous location history of aircraft
499
                $output .= '{';
500
					$output .= '"type": "Feature",';
501
                        $output .= '"properties": {';
502
							$output .= '"callsign": "'.$spotter_item['ident'].'",';
503
							$output .= '"type": "history"';
504
						$output .= '},';
505
						$output .= '"geometry": {';
506
							$output .= '"type": "LineString",';
507
								$output .= '"coordinates": [';
508
                                    //$spotter_history_array = SpotterLive::getAllLiveSpotterDataByIdent($spotter_item['ident']);
509
                                    if ($from_archive) {
510
					    $spotter_history_array = SpotterArchive::getAllArchiveSpotterDataById($spotter_item['flightaware_id']);
511
                                    } else {
512
					    $spotter_history_array = SpotterLive::getAllLiveSpotterDataById($spotter_item['flightaware_id']);
513
                                    }
514
										$d = false;
515
										$neg = false;
516
									$history_output = '';
517
									foreach ($spotter_history_array as $key => $spotter_history)
518
									{
519
										if (abs($spotter_history['longitude']-$spotter_item['longitude']) > 200 || $d==true) {
520
											if ($d == false) $d = true;
521
									        } else {
522
											$history_output .= '[';
523
											$history_output .=  $spotter_history['longitude'].', ';
524
											$history_output .=  $spotter_history['latitude'].',';
525
											$history_output .=  $spotter_history['altitude'];
526
											$history_output .= '],';
527
528
										}
529
									}
530
									if ($history_output != '') $output .= substr($history_output, 0, -1);
531
								$output .= ']';
532
							$output .= '}';
533
				$output .= '},';
534
                
535
			}
536
*/
537
				$history = filter_input(INPUT_GET,'history',FILTER_SANITIZE_STRING);
538
				if ($history == '' && isset($_COOKIE['history'])) $history = $_COOKIE['history'];
539
				
540
				if (
541
				    (isset($_COOKIE['flightpath']) && $_COOKIE['flightpath'] == 'true') 
542
				    || ((isset($globalMapHistory) && $globalMapHistory) || $allhistory)
543
				//    || (isset($history) && $history != '' && $history != 'NA' && ($history == $spotter_item['ident'] || $history == $spotter_item['flightaware_id']))
544
				//    || (isset($history) && $history != '' && $history != 'NA' && $history == $spotter_item['ident'])
545
				    || (isset($history) && $history != '' && $history != 'NA' && isset($spotter_item['flightaware_id']) && str_replace('-','',$history) == str_replace('-','',$spotter_item['flightaware_id']))
546
				    || (isset($history) && $history == '' && isset($spotter_item['flightaware_id']) && isset($_GET['flightaware_id']) && $_GET['flightaware_id'] == $spotter_item['flightaware_id'])
547
				    || (isset($history) && $history != '' && $history != 'NA' && isset($spotter_item['fammarine_id']) && str_replace('-','',$history) == str_replace('-','',$spotter_item['fammarine_id']))
548
				    || (isset($history) && $history == '' && isset($spotter_item['flightaware_id']) && isset($_GET['fammarine_id']) && $_GET['fammarine_id'] == $spotter_item['fammarine_id'])
549
				    || (isset($history) && $history != '' && $history != 'NA' && isset($spotter_item['famtrackid']) && str_replace('-','',$history) == str_replace('-','',$spotter_item['famtrackid']))
550
				    || (isset($history) && $history == '' && isset($spotter_item['flightaware_id']) && isset($_GET['famtrackid']) && $_GET['famtrackid'] == $spotter_item['famtrackid'])
551
				    ) {
552
					if ($tracker) {
553
						if ($from_archive || $globalArchive) {
554
							$spotter_history_array = $TrackerArchive->getAllArchiveTrackerDataById($spotter_item['famtrackid']);
555
						} else {
556
							$spotter_history_array = $TrackerLive->getAllLiveTrackerDataById($spotter_item['famtrackid']);
557
						}
558
					} elseif ($marine) {
559
						if ($from_archive || $globalArchive) {
560
							$spotter_history_array = $MarineArchive->getAllArchiveMarineDataById($spotter_item['fammarine_id']);
561
						} else {
562
							$spotter_history_array = $MarineLive->getAllLiveMarineDataById($spotter_item['fammarine_id']);
563
						}
564
					} else {
565
						if ($from_archive || $globalArchive) {
566
							$spotter_history_array = $SpotterArchive->getAllArchiveSpotterDataById($spotter_item['flightaware_id']);
567
						} else {
568
							$spotter_history_array = $SpotterLive->getAllLiveSpotterDataById($spotter_item['flightaware_id']);
569
						}
570
					}
571
					$d = false;
572
					foreach ($spotter_history_array as $key => $spotter_history)
573
					{
574
						if (isset($spotter_history['altitude'])) {
575
							$alt = round($spotter_history['altitude']/10)*10;
576
							if (!isset($prev_alt) || $prev_alt != $alt) {
577
								if (isset($prev_alt)) {
578
									$output_history .= '['.$spotter_history['longitude'].', '.$spotter_history['latitude'].', '.$spotter_history['altitude'].']';
579
									$output_history .= ']}},';
580
									$output .= $output_history;
581
								}
582
								if ($compress) $output_history = '{"type": "Feature","properties": {"c": "'.$spotter_item['ident'].'","t": "history","a": "'.$alt.'"},"geometry": {"type": "LineString","coordinates": [';
583
								else $output_history = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['ident'].'","type": "history","altitude": "'.$alt.'"},"geometry": {"type": "LineString","coordinates": [';
584
							}
585
							$output_history .= '[';
586
							$output_history .=  $spotter_history['longitude'].', ';
587
							$output_history .=  $spotter_history['latitude'].', ';
588
							$output_history .=  $spotter_history['altitude']*30.48;
589
							$output_history .= '],';
590
							/*
591
							if ($from_archive === false) {
592
								$output_history .= '[';
593
								$output_history .=  $spotter_item['longitude'].', ';
594
								$output_history .=  $spotter_item['latitude'].', ';
595
								$output_history .=  $spotter_item['altitude']*30.48;
596
								$output_history .= '],';
597
							}
598
							*/
599
							$prev_alt = $alt;
600
						} else {
601
							if ($d == false) {
0 ignored issues
show
Coding Style Best Practice introduced by
It seems like you are loosely comparing two booleans. Considering using the strict comparison === instead.

When comparing two booleans, it is generally considered safer to use the strict comparison operator.

Loading history...
602
								if ($compress) $output_history = '{"type": "Feature","properties": {"c": "'.$spotter_item['ident'].'","t": "history"},"geometry": {"type": "LineString","coordinates": [';
603
								else $output_history = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['ident'].'","type": "history"},"geometry": {"type": "LineString","coordinates": [';
604
							} else $d = true;
605
							$output_history .= '[';
606
							$output_history .=  $spotter_history['longitude'].', ';
607
							$output_history .=  $spotter_history['latitude'];
608
							$output_history .= '],';
609
							/*
610
							if ($from_archive === false) {
611
								$output_history .= '[';
612
								$output_history .=  $spotter_item['longitude'].', ';
613
								$output_history .=  $spotter_item['latitude'];
614
								$output_history .= '],';
615
							}
616
							*/
617
						}
618
					}
619
					if (isset($output_history)) {
620
					
621
						if ($from_archive === false) {
622
							$output_historyd = '[';
623
							$output_historyd .=  $spotter_item['longitude'].', ';
624
							$output_historyd .=  $spotter_item['latitude'];
625
							if (isset($spotter_history['altitude'])) $output_historyd .=  ','.$spotter_item['altitude']*30.48;
626
							$output_historyd .= '],';
627
							//$output_history = $output_historyd.$output_history;
628
							$output_history = $output_history.$output_historyd;
629
						}
630
						
631
						$output_history  = substr($output_history, 0, -1);
632
						$output_history .= ']}},';
633
						$output .= $output_history;
634
						unset($prev_alt);
635
						unset($output_history);
636
					}
637
				}
638
				
639
				if (((isset($history) && $history != '' && $history != 'NA' && isset($spotter_item['flightaware_id']) && str_replace('-','',$history) == str_replace('-','',$spotter_item['flightaware_id']))
640
				    || (isset($history) && $history == '' && isset($spotter_item['flightaware_id']) && isset($_GET['flightaware_id']) && $_GET['flightaware_id'] == $spotter_item['flightaware_id']))
641
				     && (isset($spotter_item['departure_airport']) 
642
				        && $spotter_item['departure_airport'] != 'NA' 
643
				        && isset($spotter_item['arrival_airport']) 
644
				        && $spotter_item['arrival_airport'] != 'NA' 
645
				        && ((isset($_COOKIE['MapRoute']) && $_COOKIE['MapRoute'] == "true") 
646
				    	    || (!isset($_COOKIE['MapRoute']) && isset($globalMapRoute) && $globalMapRoute)))) {
647
				    if ($compress) $output_air = '{"type": "Feature","properties": {"c": "'.$spotter_item['ident'].'","t": "route"},"geometry": {"type": "LineString","coordinates": [';
648
				    else $output_air = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['ident'].'","type": "route"},"geometry": {"type": "LineString","coordinates": [';
649
				    if (isset($spotter_item['departure_airport_latitude'])) {
650
					$output_air .= '['.$spotter_item['departure_airport_longitude'].','.$spotter_item['departure_airport_latitude'].'],';
651
				    } elseif (isset($spotter_item['departure_airport']) && $spotter_item['departure_airport'] != 'NA') {
652
					$dairport = $Spotter->getAllAirportInfo($spotter_item['departure_airport']);
653
					if (isset($dairport[0]['latitude'])) {
654
					    $output_air .= '['.$dairport[0]['longitude'].','.$dairport[0]['latitude'].'],';
655
					}
656
				    }
657
				    if (isset($spotter_item['arrival_airport_latitude'])) {
658
					$output_air .= '['.$spotter_item['arrival_airport_longitude'].','.$spotter_item['arrival_airport_latitude'].'],';
659
				    } elseif (isset($spotter_item['arrival_airport']) && $spotter_item['arrival_airport'] != 'NA') {
660
					$aairport = $Spotter->getAllAirportInfo($spotter_item['arrival_airport']);
661
					if (isset($aairport[0]['latitude'])) {
662
					    $output_air .= '['.$aairport[0]['longitude'].','.$aairport[0]['latitude'].'],';
663
					}
664
				    }
665
				    $output_air  = substr($output_air, 0, -1);
666
				    $output_air .= ']}},';
667
				    $output .= $output_air;
668
				    unset($output_air);
669
				}
670
671
				//if (isset($history) && $history != '' && $history == $spotter_item['ident'] && isset($spotter_item['departure_airport']) && $spotter_item['departure_airport'] != 'NA' && isset($spotter_item['arrival_airport']) && $spotter_item['arrival_airport'] != 'NA' && ((isset($_COOKIE['MapRoute']) && $_COOKIE['MapRoute'] == "true") || (!isset($_COOKIE['MapRoute']) && (!isset($globalMapRoute) || (isset($globalMapRoute) && $globalMapRoute))))) {
672
				//if (isset($history) && $history != '' && $history == $spotter_item['ident'] && isset($spotter_item['arrival_airport']) && $spotter_item['arrival_airport'] != 'NA' && ((isset($_COOKIE['MapRoute']) && $_COOKIE['MapRoute'] == "true") || (!isset($_COOKIE['MapRoute']) && (!isset($globalMapRoute) || (isset($globalMapRoute) && $globalMapRoute))))) {
673
				if (((isset($history) && $history != '' && $history != 'NA' && isset($spotter_item['flightaware_id']) && str_replace('-','',$history) == str_replace('-','',$spotter_item['flightaware_id']))
674
				    || (isset($history) && $history == '' && isset($spotter_item['flightaware_id']) && isset($_GET['flightaware_id']) && $_GET['flightaware_id'] == $spotter_item['flightaware_id']))
675
				     && (isset($spotter_item['arrival_airport']) 
676
				        && $spotter_item['arrival_airport'] != 'NA' 
677
				        && ((isset($_COOKIE['MapRemainingRoute']) && $_COOKIE['MapRemainingRoute'] == "true") 
678
				    	    || (!isset($_COOKIE['MapRemainaingRoute']) && (!isset($globalMapRemainingRoute) 
679
				    	    || (isset($globalMapRemainingRoute) && $globalMapRemainingRoute)))))) {
680
				    $havedata = false;
681
				    if ($compress) $output_dest = '{"type": "Feature","properties": {"c": "'.$spotter_item['ident'].'","t": "routedest"},"geometry": {"type": "LineString","coordinates": [';
682
				    else $output_dest = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['ident'].'","type": "routedest"},"geometry": {"type": "LineString","coordinates": [';
683
				    $output_dest .= '['.$spotter_item['longitude'].','.$spotter_item['latitude'].'],';
684
685
				    if (isset($spotter_item['arrival_airport_latitude'])) {
686
					$output_dest .= '['.$spotter_item['arrival_airport_longitude'].','.$spotter_item['arrival_airport_latitude'].']';
687
					$havedata = true;
688
				    } elseif (isset($spotter_item['arrival_airport']) && $spotter_item['arrival_airport'] != 'NA') {
689
					$aairport = $Spotter->getAllAirportInfo($spotter_item['arrival_airport']);
690
					if (isset($aairport[0]['latitude'])) {
691
					    $output_dest .= '['.$aairport[0]['longitude'].','.$aairport[0]['latitude'].']';
692
					    $havedata = true;
693
					}
694
				    }
695
				    //$output_dest  = substr($output_dest, 0, -1);
696
				    $output_dest .= ']}},';
697
				    if ($havedata) $output .= $output_dest;
698
				    unset($output_dest);
699
				}
700
			}
701
			$output  = substr($output, 0, -1);
702
			$output .= ']';
703
			$output .= ',"initial_sqltime": "'.$sqltime.'",';
704
			$output .= '"totaltime": "'.round(microtime(true)-$begintime,2).'",';
705
			if (isset($begindate)) $output .= '"archive_date": "'.$begindate.'",';
706
			$output .= '"fc": "'.$j.'"';
707
		} else {
708
			$output .= '"features": ';
709
			$output .= '[{';
710
			$output .= '"type": "Feature",';
711
			$output .= '"properties": {';
712
			$output .= '"fc": "'.$flightcnt.'",';
713
			$output .= '"empty": "true"}';
714
			$output .= ',"geometry": {"type": "Point","coordinates": [0, 0]}';
715
			$output .= '}]';
716
		}
717
		
718
$output .= '}';
719
720
print $output;
721
722
?>
723