Completed
Push — master ( cb0b23...3240cd )
by Yannick
74:14 queued 46:04
created
require/class.MarineLive.php 1 patch
Spacing   +106 added lines, -106 removed lines patch added patch discarded remove patch
@@ -17,33 +17,33 @@  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['idents']) && !empty($flt['idents'])) {
38 38
 				if (isset($flt['source'])) {
39
-					$filter_query_join .= " INNER JOIN (SELECT fammarine_id FROM marine_output WHERE marine_output.ident IN ('".implode("','",$flt['idents'])."') AND marine_output.format_source IN ('".implode("','",$flt['source'])."')) spid ON spid.fammarine_id = marine_live.fammarine_id";
39
+					$filter_query_join .= " INNER JOIN (SELECT fammarine_id FROM marine_output WHERE marine_output.ident IN ('".implode("','", $flt['idents'])."') AND marine_output.format_source IN ('".implode("','", $flt['source'])."')) spid ON spid.fammarine_id = marine_live.fammarine_id";
40 40
 				} else {
41
-					$filter_query_join .= " INNER JOIN (SELECT fammarine_id FROM marine_output WHERE marine_output.ident IN ('".implode("','",$flt['idents'])."')) spid ON spid.fammarine_id = marine_live.fammarine_id";
41
+					$filter_query_join .= " INNER JOIN (SELECT fammarine_id FROM marine_output WHERE marine_output.ident IN ('".implode("','", $flt['idents'])."')) spid ON spid.fammarine_id = marine_live.fammarine_id";
42 42
 				}
43 43
 			}
44 44
 		}
45 45
 		if (isset($filter['source']) && !empty($filter['source'])) {
46
-			$filter_query_where .= " AND format_source IN ('".implode("','",$filter['source'])."')";
46
+			$filter_query_where .= " AND format_source IN ('".implode("','", $filter['source'])."')";
47 47
 		}
48 48
 		if (isset($filter['ident']) && !empty($filter['ident'])) {
49 49
 			$filter_query_where .= " AND ident = '".$filter['ident']."'";
@@ -72,15 +72,15 @@  discard block
 block discarded – undo
72 72
 					$filter_query_date .= " AND EXTRACT(DAY FROM marine_output.date) = '".$filter['day']."'";
73 73
 				}
74 74
 			}
75
-			$filter_query_join .= " INNER JOIN (SELECT fammarine_id FROM marine_output".preg_replace('/^ AND/',' WHERE',$filter_query_date).") sd ON sd.fammarine_id = marine_live.fammarine_id";
75
+			$filter_query_join .= " INNER JOIN (SELECT fammarine_id FROM marine_output".preg_replace('/^ AND/', ' WHERE', $filter_query_date).") sd ON sd.fammarine_id = marine_live.fammarine_id";
76 76
 		}
77 77
 		if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) {
78
-			$filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')";
78
+			$filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','", $filter['source_aprs'])."')";
79 79
 		}
80 80
 		if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE';
81 81
 		elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND';
82 82
 		if ($filter_query_where != '') {
83
-			$filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where);
83
+			$filter_query_where = preg_replace('/^ AND/', ' WHERE', $filter_query_where);
84 84
 		}
85 85
 		$filter_query = $filter_query_join.$filter_query_where;
86 86
 		return $filter_query;
@@ -103,8 +103,8 @@  discard block
 block discarded – undo
103 103
 		if ($limit != '')
104 104
 		{
105 105
 			$limit_array = explode(',', $limit);
106
-			$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT);
107
-			$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT);
106
+			$limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT);
107
+			$limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT);
108 108
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0)
109 109
 			{
110 110
 				$limit_query = ' LIMIT '.$limit_array[1].' OFFSET '.$limit_array[0];
@@ -119,7 +119,7 @@  discard block
 block discarded – undo
119 119
 				$orderby_query = ' '.$search_orderby_array[$sort]['sql'];
120 120
 			}
121 121
 		}
122
-		if ($orderby_query == '') $orderby_query= ' ORDER BY date DESC';
122
+		if ($orderby_query == '') $orderby_query = ' ORDER BY date DESC';
123 123
 
124 124
 		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
125 125
 		if ($globalDBdriver == 'mysql') {
@@ -128,7 +128,7 @@  discard block
 block discarded – undo
128 128
 		} else {
129 129
 			$query  = "SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= l.date GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate".$filter_query.$orderby_query;
130 130
 		}
131
-		$spotter_array = $Marine->getDataFromDB($query.$limit_query,array(),'',true);
131
+		$spotter_array = $Marine->getDataFromDB($query.$limit_query, array(), '', true);
132 132
 
133 133
 		return $spotter_array;
134 134
 	}
@@ -144,7 +144,7 @@  discard block
 block discarded – undo
144 144
 		global $globalDBdriver, $globalLiveInterval;
145 145
 		date_default_timezone_set('UTC');
146 146
 
147
-		$filter_query = $this->getFilter($filter,true,true);
147
+		$filter_query = $this->getFilter($filter, true, true);
148 148
 
149 149
 		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
150 150
 		if ($globalDBdriver == 'mysql') {
@@ -158,7 +158,7 @@  discard block
 block discarded – undo
158 158
 		try {
159 159
 			$sth = $this->db->prepare($query);
160 160
 			$sth->execute();
161
-		} catch(PDOException $e) {
161
+		} catch (PDOException $e) {
162 162
 			echo $e->getMessage();
163 163
 			die;
164 164
 		}
@@ -173,19 +173,19 @@  discard block
 block discarded – undo
173 173
 	* @return Array the spotter information
174 174
 	*
175 175
 	*/
176
-	public function getMinLastLiveMarineData($coord = array(),$filter = array(), $limit = false)
176
+	public function getMinLastLiveMarineData($coord = array(), $filter = array(), $limit = false)
177 177
 	{
178 178
 		global $globalDBdriver, $globalLiveInterval, $globalMap3DMarinesLimit, $globalArchive;
179 179
 		date_default_timezone_set('UTC');
180 180
 		$usecoord = false;
181 181
 		if (is_array($coord) && !empty($coord)) {
182
-			$minlong = filter_var($coord[0],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
183
-			$minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
184
-			$maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
185
-			$maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
182
+			$minlong = filter_var($coord[0], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
183
+			$minlat = filter_var($coord[1], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
184
+			$maxlong = filter_var($coord[2], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
185
+			$maxlat = filter_var($coord[3], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
186 186
 			$usecoord = true;
187 187
 		}
188
-		$filter_query = $this->getFilter($filter,true,true);
188
+		$filter_query = $this->getFilter($filter, true, true);
189 189
 
190 190
 		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
191 191
 		if (!isset($globalMap3DMarinesLimit) || $globalMap3DMarinesLimit == '') $globalMap3DMarinesLimit = '300';
@@ -234,7 +234,7 @@  discard block
 block discarded – undo
234 234
 		try {
235 235
 			$sth = $this->db->prepare($query);
236 236
 			$sth->execute();
237
-		} catch(PDOException $e) {
237
+		} catch (PDOException $e) {
238 238
 			echo $e->getMessage();
239 239
 			die;
240 240
 		}
@@ -251,7 +251,7 @@  discard block
 block discarded – undo
251 251
 	public function getLiveMarineCount($filter = array())
252 252
 	{
253 253
 		global $globalDBdriver, $globalLiveInterval;
254
-		$filter_query = $this->getFilter($filter,true,true);
254
+		$filter_query = $this->getFilter($filter, true, true);
255 255
 
256 256
 		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
257 257
 		if ($globalDBdriver == 'mysql') {
@@ -262,7 +262,7 @@  discard block
 block discarded – undo
262 262
 		try {
263 263
 			$sth = $this->db->prepare($query);
264 264
 			$sth->execute();
265
-		} catch(PDOException $e) {
265
+		} catch (PDOException $e) {
266 266
 			echo $e->getMessage();
267 267
 			die;
268 268
 		}
@@ -285,10 +285,10 @@  discard block
 block discarded – undo
285 285
 		$filter_query = $this->getFilter($filter);
286 286
 
287 287
 		if (is_array($coord)) {
288
-			$minlong = filter_var($coord[0],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
289
-			$minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
290
-			$maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
291
-			$maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
288
+			$minlong = filter_var($coord[0], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
289
+			$minlat = filter_var($coord[1], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
290
+			$maxlong = filter_var($coord[2], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
291
+			$maxlat = filter_var($coord[3], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
292 292
 		} else return array();
293 293
 		if ($globalDBdriver == 'mysql') {
294 294
 			$query  = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate AND marine_live.latitude BETWEEN '.$minlat.' AND '.$maxlat.' AND marine_live.longitude BETWEEN '.$minlong.' AND '.$maxlong.' GROUP BY marine_live.fammarine_id'.$filter_query;
@@ -313,17 +313,17 @@  discard block
 block discarded – undo
313 313
 		$filter_query = $this->getFilter($filter);
314 314
 
315 315
 		if (is_array($coord)) {
316
-			$minlong = filter_var($coord[0],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
317
-			$minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
318
-			$maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
319
-			$maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
316
+			$minlong = filter_var($coord[0], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
317
+			$minlat = filter_var($coord[1], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
318
+			$maxlong = filter_var($coord[2], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
319
+			$maxlat = filter_var($coord[3], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
320 320
 		} else return array();
321 321
 		if ($globalDBdriver == 'mysql') {
322 322
 			$query  = 'SELECT marine_live.ident, marine_live.fammarine_id,marine_live.type, marine_live.latitude, marine_live.longitude, marine_live.heading, marine_live.ground_speed, marine_live.date, marine_live.format_source 
323 323
 			FROM marine_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= marine_live.date AND marine_live.latitude <> '0' AND marine_live.longitude <> '0' AND marine_live.latitude BETWEEN ".$minlat.' AND '.$maxlat.' AND marine_live.longitude BETWEEN '.$minlong.' AND '.$maxlong."
324 324
 			ORDER BY marine_live.fammarine_id, marine_live.date";
325 325
 		} else {
326
-			$query  = "SELECT marine_live.ident, marine_live.fammarine_id, marine_live.type,marine_live.latitude, marine_live.longitude, marine_live.heading, marine_live.ground_speed, marine_live.date, marine_live.format_source 
326
+			$query = "SELECT marine_live.ident, marine_live.fammarine_id, marine_live.type,marine_live.latitude, marine_live.longitude, marine_live.heading, marine_live.ground_speed, marine_live.date, marine_live.format_source 
327 327
 			FROM marine_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= marine_live.date AND marine_live.latitude <> '0' AND marine_live.longitude <> '0' AND marine_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_live.longitude BETWEEN ".$minlong." AND ".$maxlong."
328 328
 			ORDER BY marine_live.fammarine_id, marine_live.date";
329 329
 		}
@@ -372,7 +372,7 @@  discard block
 block discarded – undo
372 372
                 if ($interval == '1m')
373 373
                 {
374 374
                     $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE) <= marine_live.date ';
375
-                } else if ($interval == '15m'){
375
+                } else if ($interval == '15m') {
376 376
                     $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 15 MINUTE) <= marine_live.date ';
377 377
                 } 
378 378
             }
@@ -380,14 +380,14 @@  discard block
 block discarded – undo
380 380
          $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE) <= marine_live.date ';   
381 381
         }
382 382
 
383
-                $query  = "SELECT marine_live.*, ( 6371 * acos( cos( radians(:lat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(:lng) ) + sin( radians(:lat) ) * sin( radians( latitude ) ) ) ) AS distance FROM marine_live 
383
+                $query = "SELECT marine_live.*, ( 6371 * acos( cos( radians(:lat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(:lng) ) + sin( radians(:lat) ) * sin( radians( latitude ) ) ) ) AS distance FROM marine_live 
384 384
                    WHERE marine_live.latitude <> '' 
385 385
                                    AND marine_live.longitude <> '' 
386 386
                    ".$additional_query."
387 387
                    HAVING distance < :radius  
388 388
                                    ORDER BY distance";
389 389
 
390
-                $spotter_array = $Marine->getDataFromDB($query, array(':lat' => $lat, ':lng' => $lng,':radius' => $radius));
390
+                $spotter_array = $Marine->getDataFromDB($query, array(':lat' => $lat, ':lng' => $lng, ':radius' => $radius));
391 391
 
392 392
                 return $spotter_array;
393 393
         }
@@ -405,9 +405,9 @@  discard block
 block discarded – undo
405 405
 		date_default_timezone_set('UTC');
406 406
 
407 407
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
408
-                $query  = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.ident = :ident GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
408
+                $query = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.ident = :ident GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
409 409
 
410
-		$spotter_array = $Marine->getDataFromDB($query,array(':ident' => $ident),'',true);
410
+		$spotter_array = $Marine->getDataFromDB($query, array(':ident' => $ident), '', true);
411 411
 
412 412
 		return $spotter_array;
413 413
 	}
@@ -418,16 +418,16 @@  discard block
 block discarded – undo
418 418
 	* @return Array the spotter information
419 419
 	*
420 420
 	*/
421
-	public function getDateLiveMarineDataByIdent($ident,$date)
421
+	public function getDateLiveMarineDataByIdent($ident, $date)
422 422
 	{
423 423
 		$Marine = new Marine($this->db);
424 424
 		date_default_timezone_set('UTC');
425 425
 
426 426
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
427
-                $query  = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.ident = :ident AND l.date <= :date GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
427
+                $query = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.ident = :ident AND l.date <= :date GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
428 428
 
429
-                $date = date('c',$date);
430
-		$spotter_array = $Marine->getDataFromDB($query,array(':ident' => $ident,':date' => $date));
429
+                $date = date('c', $date);
430
+		$spotter_array = $Marine->getDataFromDB($query, array(':ident' => $ident, ':date' => $date));
431 431
 
432 432
 		return $spotter_array;
433 433
 	}
@@ -444,9 +444,9 @@  discard block
 block discarded – undo
444 444
 		date_default_timezone_set('UTC');
445 445
 
446 446
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
447
-                $query  = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.fammarine_id = :id GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
447
+                $query = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.fammarine_id = :id GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
448 448
 
449
-		$spotter_array = $Marine->getDataFromDB($query,array(':id' => $id),'',true);
449
+		$spotter_array = $Marine->getDataFromDB($query, array(':id' => $id), '', true);
450 450
 
451 451
 		return $spotter_array;
452 452
 	}
@@ -457,15 +457,15 @@  discard block
 block discarded – undo
457 457
 	* @return Array the spotter information
458 458
 	*
459 459
 	*/
460
-	public function getDateLiveMarineDataById($id,$date)
460
+	public function getDateLiveMarineDataById($id, $date)
461 461
 	{
462 462
 		$Marine = new Marine($this->db);
463 463
 		date_default_timezone_set('UTC');
464 464
 
465 465
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
466
-                $query  = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.fammarine_id = :id AND l.date <= :date GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
467
-                $date = date('c',$date);
468
-		$spotter_array = $Marine->getDataFromDB($query,array(':id' => $id,':date' => $date),'',true);
466
+                $query = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE l.fammarine_id = :id AND l.date <= :date GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate ORDER BY marine_live.date DESC';
467
+                $date = date('c', $date);
468
+		$spotter_array = $Marine->getDataFromDB($query, array(':id' => $id, ':date' => $date), '', true);
469 469
 
470 470
 		return $spotter_array;
471 471
 	}
@@ -477,7 +477,7 @@  discard block
 block discarded – undo
477 477
 	* @return Array the spotter information
478 478
 	*
479 479
 	*/
480
-	public function getAllLiveMarineDataById($id,$liveinterval = false)
480
+	public function getAllLiveMarineDataById($id, $liveinterval = false)
481 481
 	{
482 482
 		global $globalDBdriver, $globalLiveInterval;
483 483
 		date_default_timezone_set('UTC');
@@ -496,7 +496,7 @@  discard block
 block discarded – undo
496 496
 		try {
497 497
 			$sth = $this->db->prepare($query);
498 498
 			$sth->execute(array(':id' => $id));
499
-		} catch(PDOException $e) {
499
+		} catch (PDOException $e) {
500 500
 			echo $e->getMessage();
501 501
 			die;
502 502
 		}
@@ -514,12 +514,12 @@  discard block
 block discarded – undo
514 514
 	{
515 515
 		date_default_timezone_set('UTC');
516 516
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
517
-		$query  = self::$global_query.' WHERE marine_live.ident = :ident';
517
+		$query = self::$global_query.' WHERE marine_live.ident = :ident';
518 518
     		try {
519 519
 			
520 520
 			$sth = $this->db->prepare($query);
521 521
 			$sth->execute(array(':ident' => $ident));
522
-		} catch(PDOException $e) {
522
+		} catch (PDOException $e) {
523 523
 			echo $e->getMessage();
524 524
 			die;
525 525
 		}
@@ -549,7 +549,7 @@  discard block
 block discarded – undo
549 549
 			
550 550
 			$sth = $this->db->prepare($query);
551 551
 			$sth->execute();
552
-		} catch(PDOException $e) {
552
+		} catch (PDOException $e) {
553 553
 			return "error";
554 554
 		}
555 555
 
@@ -572,14 +572,14 @@  discard block
 block discarded – undo
572 572
 				
573 573
 				$sth = $this->db->prepare($query);
574 574
 				$sth->execute();
575
-			} catch(PDOException $e) {
575
+			} catch (PDOException $e) {
576 576
 				return "error";
577 577
 			}
578 578
 			$query_delete = 'DELETE FROM marine_live WHERE fammarine_id IN (';
579 579
                         $i = 0;
580
-                        $j =0;
580
+                        $j = 0;
581 581
 			$all = $sth->fetchAll(PDO::FETCH_ASSOC);
582
-			foreach($all as $row)
582
+			foreach ($all as $row)
583 583
 			{
584 584
 				$i++;
585 585
 				$j++;
@@ -587,9 +587,9 @@  discard block
 block discarded – undo
587 587
 					if ($globalDebug) echo ".";
588 588
 				    	try {
589 589
 						
590
-						$sth = $this->db->prepare(substr($query_delete,0,-1).")");
590
+						$sth = $this->db->prepare(substr($query_delete, 0, -1).")");
591 591
 						$sth->execute();
592
-					} catch(PDOException $e) {
592
+					} catch (PDOException $e) {
593 593
 						return "error";
594 594
 					}
595 595
                                 	$query_delete = 'DELETE FROM marine_live WHERE fammarine_id IN (';
@@ -600,9 +600,9 @@  discard block
 block discarded – undo
600 600
 			if ($i > 0) {
601 601
     				try {
602 602
 					
603
-					$sth = $this->db->prepare(substr($query_delete,0,-1).")");
603
+					$sth = $this->db->prepare(substr($query_delete, 0, -1).")");
604 604
 					$sth->execute();
605
-				} catch(PDOException $e) {
605
+				} catch (PDOException $e) {
606 606
 					return "error";
607 607
 				}
608 608
 			}
@@ -615,7 +615,7 @@  discard block
 block discarded – undo
615 615
 				
616 616
 				$sth = $this->db->prepare($query);
617 617
 				$sth->execute();
618
-			} catch(PDOException $e) {
618
+			} catch (PDOException $e) {
619 619
 				return "error";
620 620
 			}
621 621
 /*			$query_delete = "DELETE FROM marine_live WHERE fammarine_id IN (";
@@ -663,13 +663,13 @@  discard block
 block discarded – undo
663 663
 	public function deleteLiveMarineDataByIdent($ident)
664 664
 	{
665 665
 		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
666
-		$query  = 'DELETE FROM marine_live WHERE ident = :ident';
666
+		$query = 'DELETE FROM marine_live WHERE ident = :ident';
667 667
         
668 668
     		try {
669 669
 			
670 670
 			$sth = $this->db->prepare($query);
671 671
 			$sth->execute(array(':ident' => $ident));
672
-		} catch(PDOException $e) {
672
+		} catch (PDOException $e) {
673 673
 			return "error";
674 674
 		}
675 675
 
@@ -685,13 +685,13 @@  discard block
 block discarded – undo
685 685
 	public function deleteLiveMarineDataById($id)
686 686
 	{
687 687
 		$id = filter_var($id, FILTER_SANITIZE_STRING);
688
-		$query  = 'DELETE FROM marine_live WHERE fammarine_id = :id';
688
+		$query = 'DELETE FROM marine_live WHERE fammarine_id = :id';
689 689
         
690 690
     		try {
691 691
 			
692 692
 			$sth = $this->db->prepare($query);
693 693
 			$sth->execute(array(':id' => $id));
694
-		} catch(PDOException $e) {
694
+		} catch (PDOException $e) {
695 695
 			return "error";
696 696
 		}
697 697
 
@@ -709,13 +709,13 @@  discard block
 block discarded – undo
709 709
 	{
710 710
 		global $globalDBdriver, $globalTimezone;
711 711
 		if ($globalDBdriver == 'mysql') {
712
-			$query  = 'SELECT marine_live.ident FROM marine_live 
712
+			$query = 'SELECT marine_live.ident FROM marine_live 
713 713
 				WHERE marine_live.ident = :ident 
714 714
 				AND marine_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 HOUR) 
715 715
 				AND marine_live.date < UTC_TIMESTAMP()';
716 716
 			$query_data = array(':ident' => $ident);
717 717
 		} else {
718
-			$query  = "SELECT marine_live.ident FROM marine_live 
718
+			$query = "SELECT marine_live.ident FROM marine_live 
719 719
 				WHERE marine_live.ident = :ident 
720 720
 				AND marine_live.date >= now() AT TIME ZONE 'UTC' - INTERVAL '1 HOURS'
721 721
 				AND marine_live.date < now() AT TIME ZONE 'UTC'";
@@ -724,8 +724,8 @@  discard block
 block discarded – undo
724 724
 		
725 725
 		$sth = $this->db->prepare($query);
726 726
 		$sth->execute($query_data);
727
-		$ident_result='';
728
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
727
+		$ident_result = '';
728
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
729 729
 		{
730 730
 			$ident_result = $row['ident'];
731 731
 		}
@@ -742,13 +742,13 @@  discard block
 block discarded – undo
742 742
 	{
743 743
 		global $globalDBdriver, $globalTimezone;
744 744
 		if ($globalDBdriver == 'mysql') {
745
-			$query  = 'SELECT marine_live.ident, marine_live.fammarine_id FROM marine_live 
745
+			$query = 'SELECT marine_live.ident, marine_live.fammarine_id FROM marine_live 
746 746
 				WHERE marine_live.ident = :ident 
747 747
 				AND marine_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 30 MINUTE)'; 
748 748
 //				AND marine_live.date < UTC_TIMESTAMP()";
749 749
 			$query_data = array(':ident' => $ident);
750 750
 		} else {
751
-			$query  = "SELECT marine_live.ident, marine_live.fammarine_id FROM marine_live 
751
+			$query = "SELECT marine_live.ident, marine_live.fammarine_id FROM marine_live 
752 752
 				WHERE marine_live.ident = :ident 
753 753
 				AND marine_live.date >= now() AT TIME ZONE 'UTC' - INTERVAL '30 MINUTES'";
754 754
 //				AND marine_live.date < now() AT TIME ZONE 'UTC'";
@@ -757,8 +757,8 @@  discard block
 block discarded – undo
757 757
 		
758 758
 		$sth = $this->db->prepare($query);
759 759
 		$sth->execute($query_data);
760
-		$ident_result='';
761
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
760
+		$ident_result = '';
761
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
762 762
 		{
763 763
 			$ident_result = $row['fammarine_id'];
764 764
 		}
@@ -775,13 +775,13 @@  discard block
 block discarded – undo
775 775
 	{
776 776
 		global $globalDBdriver, $globalTimezone;
777 777
 		if ($globalDBdriver == 'mysql') {
778
-			$query  = 'SELECT marine_live.ident, marine_live.fammarine_id FROM marine_live 
778
+			$query = 'SELECT marine_live.ident, marine_live.fammarine_id FROM marine_live 
779 779
 				WHERE marine_live.fammarine_id = :id 
780 780
 				AND marine_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 10 HOUR)'; 
781 781
 //				AND marine_live.date < UTC_TIMESTAMP()";
782 782
 			$query_data = array(':id' => $id);
783 783
 		} else {
784
-			$query  = "SELECT marine_live.ident, marine_live.fammarine_id FROM marine_live 
784
+			$query = "SELECT marine_live.ident, marine_live.fammarine_id FROM marine_live 
785 785
 				WHERE marine_live.fammarine_id = :id 
786 786
 				AND marine_live.date >= now() AT TIME ZONE 'UTC' - INTERVAL '10 HOUR'";
787 787
 //				AND marine_live.date < now() AT TIME ZONE 'UTC'";
@@ -790,8 +790,8 @@  discard block
 block discarded – undo
790 790
 		
791 791
 		$sth = $this->db->prepare($query);
792 792
 		$sth->execute($query_data);
793
-		$ident_result='';
794
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
793
+		$ident_result = '';
794
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
795 795
 		{
796 796
 			$ident_result = $row['fammarine_id'];
797 797
 		}
@@ -808,13 +808,13 @@  discard block
 block discarded – undo
808 808
 	{
809 809
 		global $globalDBdriver, $globalTimezone;
810 810
 		if ($globalDBdriver == 'mysql') {
811
-			$query  = 'SELECT marine_live.fammarine_id FROM marine_live 
811
+			$query = 'SELECT marine_live.fammarine_id FROM marine_live 
812 812
 				WHERE marine_live.mmsi = :mmsi 
813 813
 				AND marine_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 10 HOUR)'; 
814 814
 //				AND marine_live.date < UTC_TIMESTAMP()";
815 815
 			$query_data = array(':mmsi' => $mmsi);
816 816
 		} else {
817
-			$query  = "SELECT marine_live.fammarine_id FROM marine_live 
817
+			$query = "SELECT marine_live.fammarine_id FROM marine_live 
818 818
 				WHERE marine_live.mmsi = :mmsi 
819 819
 				AND marine_live.date >= now() AT TIME ZONE 'UTC' - INTERVAL '10 HOUR'";
820 820
 //				AND marine_live.date < now() AT TIME ZONE 'UTC'";
@@ -823,8 +823,8 @@  discard block
 block discarded – undo
823 823
 		
824 824
 		$sth = $this->db->prepare($query);
825 825
 		$sth->execute($query_data);
826
-		$ident_result='';
827
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
826
+		$ident_result = '';
827
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
828 828
 		{
829 829
 			$ident_result = $row['fammarine_id'];
830 830
 		}
@@ -842,7 +842,7 @@  discard block
 block discarded – undo
842 842
 	* @return String success or false
843 843
 	*
844 844
 	*/
845
-	public function addLiveMarineData($fammarine_id = '', $ident = '', $latitude = '', $longitude = '', $heading = '', $groundspeed = '', $date = '', $putinarchive = false, $mmsi = '',$type = '',$typeid = '',$imo = '', $callsign = '',$arrival_code = '',$arrival_date = '',$status = '',$statusid = '',$noarchive = false,$format_source = '', $source_name = '', $over_country = '')
845
+	public function addLiveMarineData($fammarine_id = '', $ident = '', $latitude = '', $longitude = '', $heading = '', $groundspeed = '', $date = '', $putinarchive = false, $mmsi = '', $type = '', $typeid = '', $imo = '', $callsign = '', $arrival_code = '', $arrival_date = '', $status = '', $statusid = '', $noarchive = false, $format_source = '', $source_name = '', $over_country = '')
846 846
 	{
847 847
 		global $globalURL, $globalArchive, $globalDebug;
848 848
 		$Common = new Common();
@@ -894,26 +894,26 @@  discard block
 block discarded – undo
894 894
 		if ($date == '') $date = date("Y-m-d H:i:s", time());
895 895
 
896 896
         
897
-		$fammarine_id = filter_var($fammarine_id,FILTER_SANITIZE_STRING);
898
-		$ident = filter_var($ident,FILTER_SANITIZE_STRING);
899
-		$latitude = filter_var($latitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
900
-		$longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
901
-		$heading = filter_var($heading,FILTER_SANITIZE_NUMBER_INT);
902
-		$groundspeed = filter_var($groundspeed,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
903
-		$format_source = filter_var($format_source,FILTER_SANITIZE_STRING);
904
-		$source_name = filter_var($source_name,FILTER_SANITIZE_STRING);
905
-		$over_country = filter_var($over_country,FILTER_SANITIZE_STRING);
906
-		$type = filter_var($type,FILTER_SANITIZE_STRING);
907
-		$mmsi = filter_var($mmsi,FILTER_SANITIZE_NUMBER_INT);
908
-		$status = filter_var($status,FILTER_SANITIZE_STRING);
909
-		$imo = filter_var($imo,FILTER_SANITIZE_STRING);
910
-		$callsign = filter_var($callsign,FILTER_SANITIZE_STRING);
911
-		$arrival_code = filter_var($arrival_code,FILTER_SANITIZE_STRING);
912
-		$arrival_date = filter_var($arrival_date,FILTER_SANITIZE_STRING);
897
+		$fammarine_id = filter_var($fammarine_id, FILTER_SANITIZE_STRING);
898
+		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
899
+		$latitude = filter_var($latitude, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
900
+		$longitude = filter_var($longitude, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
901
+		$heading = filter_var($heading, FILTER_SANITIZE_NUMBER_INT);
902
+		$groundspeed = filter_var($groundspeed, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
903
+		$format_source = filter_var($format_source, FILTER_SANITIZE_STRING);
904
+		$source_name = filter_var($source_name, FILTER_SANITIZE_STRING);
905
+		$over_country = filter_var($over_country, FILTER_SANITIZE_STRING);
906
+		$type = filter_var($type, FILTER_SANITIZE_STRING);
907
+		$mmsi = filter_var($mmsi, FILTER_SANITIZE_NUMBER_INT);
908
+		$status = filter_var($status, FILTER_SANITIZE_STRING);
909
+		$imo = filter_var($imo, FILTER_SANITIZE_STRING);
910
+		$callsign = filter_var($callsign, FILTER_SANITIZE_STRING);
911
+		$arrival_code = filter_var($arrival_code, FILTER_SANITIZE_STRING);
912
+		$arrival_date = filter_var($arrival_date, FILTER_SANITIZE_STRING);
913 913
 		
914 914
 
915
-            	if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) $groundspeed = 0;
916
-            	if ($heading == '' || $Common->isInteger($heading) === false ) $heading = 0;
915
+            	if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0;
916
+            	if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0;
917 917
             	if ($arrival_date == '') $arrival_date = NULL;
918 918
             	$query = '';
919 919
 		if ($globalArchive) {
@@ -923,18 +923,18 @@  discard block
 block discarded – undo
923 923
 		$query .= 'INSERT INTO marine_live (fammarine_id, ident, latitude, longitude, heading, ground_speed, date, format_source, source_name, over_country, mmsi, type,status,imo,arrival_port_name,arrival_port_date) 
924 924
 		    VALUES (:fammarine_id,:ident,:latitude,:longitude,:heading,:groundspeed,:date,:format_source, :source_name, :over_country,:mmsi,:type,:status,:imo,:arrival_port_name,:arrival_port_date)';
925 925
 
926
-		$query_values = array(':fammarine_id' => $fammarine_id,':ident' => $ident,':latitude' => $latitude,':longitude' => $longitude,':heading' => $heading,':groundspeed' => $groundspeed,':date' => $date, ':format_source' => $format_source, ':source_name' => $source_name, ':over_country' => $over_country,':mmsi' => $mmsi,':type' => $type,':status' => $status,':imo' => $imo,':arrival_port_name' => $arrival_code,':arrival_port_date' => $arrival_date);
926
+		$query_values = array(':fammarine_id' => $fammarine_id, ':ident' => $ident, ':latitude' => $latitude, ':longitude' => $longitude, ':heading' => $heading, ':groundspeed' => $groundspeed, ':date' => $date, ':format_source' => $format_source, ':source_name' => $source_name, ':over_country' => $over_country, ':mmsi' => $mmsi, ':type' => $type, ':status' => $status, ':imo' => $imo, ':arrival_port_name' => $arrival_code, ':arrival_port_date' => $arrival_date);
927 927
 		try {
928 928
 			$sth = $this->db->prepare($query);
929 929
 			$sth->execute($query_values);
930
-		} catch(PDOException $e) {
930
+		} catch (PDOException $e) {
931 931
 			return "error : ".$e->getMessage();
932 932
 		}
933 933
 		
934 934
 		if (isset($globalArchive) && $globalArchive && $putinarchive && $noarchive !== true) {
935 935
 			if ($globalDebug) echo '(Add to Marine archive : ';
936 936
 			$MarineArchive = new MarineArchive($this->db);
937
-			$result =  $MarineArchive->addMarineArchiveData($fammarine_id, $ident, $latitude, $longitude, $heading, $groundspeed, $date, $putinarchive, $mmsi,$type,$typeid,$imo, $callsign,$arrival_code,$arrival_date,$status,$noarchive,$format_source, $source_name, $over_country);
937
+			$result = $MarineArchive->addMarineArchiveData($fammarine_id, $ident, $latitude, $longitude, $heading, $groundspeed, $date, $putinarchive, $mmsi, $type, $typeid, $imo, $callsign, $arrival_code, $arrival_date, $status, $noarchive, $format_source, $source_name, $over_country);
938 938
 			if ($globalDebug) echo $result.')';
939 939
 		}
940 940
 		return "success";
@@ -942,7 +942,7 @@  discard block
 block discarded – undo
942 942
 
943 943
 	public function getOrderBy()
944 944
 	{
945
-		$orderby = array("aircraft_asc" => array("key" => "aircraft_asc", "value" => "Aircraft Type - ASC", "sql" => "ORDER BY marine_live.aircraft_icao ASC"), "aircraft_desc" => array("key" => "aircraft_desc", "value" => "Aircraft Type - DESC", "sql" => "ORDER BY marine_live.aircraft_icao DESC"),"manufacturer_asc" => array("key" => "manufacturer_asc", "value" => "Aircraft Manufacturer - ASC", "sql" => "ORDER BY marine_live.aircraft_manufacturer ASC"), "manufacturer_desc" => array("key" => "manufacturer_desc", "value" => "Aircraft Manufacturer - DESC", "sql" => "ORDER BY marine_live.aircraft_manufacturer DESC"),"airline_name_asc" => array("key" => "airline_name_asc", "value" => "Airline Name - ASC", "sql" => "ORDER BY marine_live.airline_name ASC"), "airline_name_desc" => array("key" => "airline_name_desc", "value" => "Airline Name - DESC", "sql" => "ORDER BY marine_live.airline_name DESC"), "ident_asc" => array("key" => "ident_asc", "value" => "Ident - ASC", "sql" => "ORDER BY marine_live.ident ASC"), "ident_desc" => array("key" => "ident_desc", "value" => "Ident - DESC", "sql" => "ORDER BY marine_live.ident DESC"), "airport_departure_asc" => array("key" => "airport_departure_asc", "value" => "Departure Airport - ASC", "sql" => "ORDER BY marine_live.departure_airport_city ASC"), "airport_departure_desc" => array("key" => "airport_departure_desc", "value" => "Departure Airport - DESC", "sql" => "ORDER BY marine_live.departure_airport_city DESC"), "airport_arrival_asc" => array("key" => "airport_arrival_asc", "value" => "Arrival Airport - ASC", "sql" => "ORDER BY marine_live.arrival_airport_city ASC"), "airport_arrival_desc" => array("key" => "airport_arrival_desc", "value" => "Arrival Airport - DESC", "sql" => "ORDER BY marine_live.arrival_airport_city DESC"), "date_asc" => array("key" => "date_asc", "value" => "Date - ASC", "sql" => "ORDER BY marine_live.date ASC"), "date_desc" => array("key" => "date_desc", "value" => "Date - DESC", "sql" => "ORDER BY marine_live.date DESC"));
945
+		$orderby = array("aircraft_asc" => array("key" => "aircraft_asc", "value" => "Aircraft Type - ASC", "sql" => "ORDER BY marine_live.aircraft_icao ASC"), "aircraft_desc" => array("key" => "aircraft_desc", "value" => "Aircraft Type - DESC", "sql" => "ORDER BY marine_live.aircraft_icao DESC"), "manufacturer_asc" => array("key" => "manufacturer_asc", "value" => "Aircraft Manufacturer - ASC", "sql" => "ORDER BY marine_live.aircraft_manufacturer ASC"), "manufacturer_desc" => array("key" => "manufacturer_desc", "value" => "Aircraft Manufacturer - DESC", "sql" => "ORDER BY marine_live.aircraft_manufacturer DESC"), "airline_name_asc" => array("key" => "airline_name_asc", "value" => "Airline Name - ASC", "sql" => "ORDER BY marine_live.airline_name ASC"), "airline_name_desc" => array("key" => "airline_name_desc", "value" => "Airline Name - DESC", "sql" => "ORDER BY marine_live.airline_name DESC"), "ident_asc" => array("key" => "ident_asc", "value" => "Ident - ASC", "sql" => "ORDER BY marine_live.ident ASC"), "ident_desc" => array("key" => "ident_desc", "value" => "Ident - DESC", "sql" => "ORDER BY marine_live.ident DESC"), "airport_departure_asc" => array("key" => "airport_departure_asc", "value" => "Departure Airport - ASC", "sql" => "ORDER BY marine_live.departure_airport_city ASC"), "airport_departure_desc" => array("key" => "airport_departure_desc", "value" => "Departure Airport - DESC", "sql" => "ORDER BY marine_live.departure_airport_city DESC"), "airport_arrival_asc" => array("key" => "airport_arrival_asc", "value" => "Arrival Airport - ASC", "sql" => "ORDER BY marine_live.arrival_airport_city ASC"), "airport_arrival_desc" => array("key" => "airport_arrival_desc", "value" => "Arrival Airport - DESC", "sql" => "ORDER BY marine_live.arrival_airport_city DESC"), "date_asc" => array("key" => "date_asc", "value" => "Date - ASC", "sql" => "ORDER BY marine_live.date ASC"), "date_desc" => array("key" => "date_desc", "value" => "Date - DESC", "sql" => "ORDER BY marine_live.date DESC"));
946 946
 		return $orderby;
947 947
 	}
948 948
 
Please login to merge, or discard this patch.
require/class.Elevation.php 1 patch
Spacing   +28 added lines, -28 removed lines patch added patch discarded remove patch
@@ -41,7 +41,7 @@  discard block
 block discarded – undo
41 41
 			default:
42 42
 				throw new \Exception("bad resolution can be only one of 1,3");
43 43
 		}
44
-		register_shutdown_function(function () {
44
+		register_shutdown_function(function() {
45 45
 			$this->closeAllFiles();
46 46
 		});
47 47
 	}
@@ -55,10 +55,10 @@  discard block
 block discarded – undo
55 55
 
56 56
 	private function getElevationAtPosition($fileName, $row, $column) {
57 57
 		if (!array_key_exists($fileName, $this->openedFiles)) {
58
-			if (!file_exists($this->htgFilesDestination . DIRECTORY_SEPARATOR . $fileName)) {
58
+			if (!file_exists($this->htgFilesDestination.DIRECTORY_SEPARATOR.$fileName)) {
59 59
 				throw new \Exception("File '{$fileName}' not exists.");
60 60
 			}
61
-			$file = fopen($this->htgFilesDestination . DIRECTORY_SEPARATOR . $fileName, "r");
61
+			$file = fopen($this->htgFilesDestination.DIRECTORY_SEPARATOR.$fileName, "r");
62 62
 			if ($file === false) {
63 63
 				throw new \Exception("Cant open file '{$fileName}' for reading.");
64 64
 			}
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
72 72
 			throw new \Exception("Not implemented yet");
73 73
 		}
74 74
 		$aRow     = $this->measPerDeg - $row;
75
-		$position = ($this->measPerDeg * ($aRow - 1)) + $column;
75
+		$position = ($this->measPerDeg*($aRow - 1)) + $column;
76 76
 		$position *= 2;
77 77
 		fseek($file, $position);
78 78
 		$short  = fread($file, 2);
@@ -100,8 +100,8 @@  discard block
 block discarded – undo
100 100
 		$latSec = $this->getSec($lat);
101 101
 		$lonSec = $this->getSec($lon);
102 102
 
103
-		$Xn = round($latSec / $this->resolution, 3);
104
-		$Yn = round($lonSec / $this->resolution, 3);
103
+		$Xn = round($latSec/$this->resolution, 3);
104
+		$Yn = round($lonSec/$this->resolution, 3);
105 105
 
106 106
 		$a1 = round($Xn);
107 107
 		$a2 = round($Yn);
@@ -133,55 +133,55 @@  discard block
 block discarded – undo
133 133
 		$b3 = $this->getElevationAtPosition($fName, $b1, $b2);
134 134
 		$c3 = $this->getElevationAtPosition($fName, $c1, $c2);
135 135
 
136
-		$n1 = ($c2 - $a2) * ($b3 - $a3) - ($c3 - $a3) * ($b2 - $a2);
137
-		$n2 = ($c3 - $a3) * ($b1 - $a1) - ($c1 - $a1) * ($b3 - $a3);
138
-		$n3 = ($c1 - $a1) * ($b2 - $a2) - ($c2 - $a2) * ($b1 - $a1);
136
+		$n1 = ($c2 - $a2)*($b3 - $a3) - ($c3 - $a3)*($b2 - $a2);
137
+		$n2 = ($c3 - $a3)*($b1 - $a1) - ($c1 - $a1)*($b3 - $a3);
138
+		$n3 = ($c1 - $a1)*($b2 - $a2) - ($c2 - $a2)*($b1 - $a1);
139 139
 
140
-		$d  = -$n1 * $a1 - $n2 * $a2 - $n3 * $a3;
141
-		$zN = (-$n1 * $Xn - $n2 * $Yn - $d) / $n3;
140
+		$d  = -$n1*$a1 - $n2*$a2 - $n3*$a3;
141
+		$zN = (-$n1*$Xn - $n2*$Yn - $d)/$n3;
142 142
 
143 143
 		return $zN;
144 144
 	}
145 145
 
146 146
 	private function getDeg($deg, $numPrefix) {
147 147
 		$deg = abs($deg);
148
-		$d   = floor($deg);     // round degrees
148
+		$d   = floor($deg); // round degrees
149 149
 		if ($numPrefix >= 3) {
150 150
 			if ($d < 100) {
151
-				$d = '0' . $d;
151
+				$d = '0'.$d;
152 152
 			}
153 153
 		} // pad with leading zeros
154 154
 		if ($d < 10) {
155
-			$d = '0' . $d;
155
+			$d = '0'.$d;
156 156
 		}
157 157
 		return $d;
158 158
 	}
159 159
 
160 160
 	private function getSec($deg) {
161 161
 		$deg = abs($deg);
162
-		$sec = round($deg * 3600, 4);
163
-		$m   = fmod(floor($sec / 60), 60);
162
+		$sec = round($deg*3600, 4);
163
+		$m   = fmod(floor($sec/60), 60);
164 164
 		$s   = round(fmod($sec, 60), 4);
165
-		return ($m * 60) + $s;
165
+		return ($m*60) + $s;
166 166
 	}
167 167
 
168
-	public function download($lat,$lon, $debug = false) {
168
+	public function download($lat, $lon, $debug = false) {
169 169
 		$N      = $this->getDeg($lat, 2);
170 170
 		$E      = $this->getDeg($lon, 3);
171
-		$fileName  = "N{$N}E{$E}.hgt";
172
-		if (!file_exists($this->htgFilesDestination . DIRECTORY_SEPARATOR . $fileName)) {
171
+		$fileName = "N{$N}E{$E}.hgt";
172
+		if (!file_exists($this->htgFilesDestination.DIRECTORY_SEPARATOR.$fileName)) {
173 173
 			$Common = new Common();
174 174
 			if ($debug) echo 'Downloading '.$fileName.'.gz ...';
175
-			$Common->download('https://s3.amazonaws.com/elevation-tiles-prod/skadi/N'.$N.'/'.$fileName.'.gz',$this->htgFilesDestination . DIRECTORY_SEPARATOR . $fileName . '.gz');
176
-			if (!file_exists($this->htgFilesDestination . DIRECTORY_SEPARATOR . $fileName . '.gz')) {
175
+			$Common->download('https://s3.amazonaws.com/elevation-tiles-prod/skadi/N'.$N.'/'.$fileName.'.gz', $this->htgFilesDestination.DIRECTORY_SEPARATOR.$fileName.'.gz');
176
+			if (!file_exists($this->htgFilesDestination.DIRECTORY_SEPARATOR.$fileName.'.gz')) {
177 177
 				if ($debug) echo "File '{$fileName}.gz' not exists.";
178 178
 				return false;
179 179
 			}
180 180
 			if ($debug) echo 'Done'."\n";
181 181
 			if ($debug) echo 'Decompress '.$fileName.' ....';
182
-			$Common->gunzip($this->htgFilesDestination . DIRECTORY_SEPARATOR . $fileName . '.gz',$this->htgFilesDestination . DIRECTORY_SEPARATOR . $fileName);
182
+			$Common->gunzip($this->htgFilesDestination.DIRECTORY_SEPARATOR.$fileName.'.gz', $this->htgFilesDestination.DIRECTORY_SEPARATOR.$fileName);
183 183
 			if ($debug) echo 'Done'."\n";
184
-			unlink($this->htgFilesDestination . DIRECTORY_SEPARATOR . $fileName . '.gz');
184
+			unlink($this->htgFilesDestination.DIRECTORY_SEPARATOR.$fileName.'.gz');
185 185
 		}
186 186
 		return true;
187 187
 	}
@@ -194,22 +194,22 @@  discard block
 block discarded – undo
194 194
 		try {
195 195
 			$sth = $db->prepare($query);
196 196
 			$sth->execute($query_values);
197
-		} catch(PDOException $e) {
197
+		} catch (PDOException $e) {
198 198
 			return "error : ".$e->getMessage();
199 199
 		}
200 200
 		while ($data = $sth->fetch(PDO::FETCH_ASSOC)) {
201
-			$this->download($data['latitude'],$data['longitude'],true);
201
+			$this->download($data['latitude'], $data['longitude'], true);
202 202
 		}
203 203
 		$query = 'SELECT latitude, longitude FROM tracker_output WHERE latitude <> 0 AND longitude <> 0 ORDER BY date DESC LIMIT 50';
204 204
 		$query_values = array();
205 205
 		try {
206 206
 			$sth = $db->prepare($query);
207 207
 			$sth->execute($query_values);
208
-		} catch(PDOException $e) {
208
+		} catch (PDOException $e) {
209 209
 			return "error : ".$e->getMessage();
210 210
 		}
211 211
 		while ($data = $sth->fetch(PDO::FETCH_ASSOC)) {
212
-			$this->download($data['latitude'],$data['longitude'],true);
212
+			$this->download($data['latitude'], $data['longitude'], true);
213 213
 		}
214 214
 	}
215 215
 }
Please login to merge, or discard this patch.
search.php 1 patch
Spacing   +95 added lines, -95 removed lines patch added patch discarded remove patch
@@ -16,24 +16,24 @@  discard block
 block discarded – undo
16 16
 $sql_date = '';
17 17
 if (isset($_GET['start_date'])) {
18 18
 	//for the date manipulation into the query
19
-	if($_GET['start_date'] != "" && $_GET['end_date'] != ""){
19
+	if ($_GET['start_date'] != "" && $_GET['end_date'] != "") {
20 20
 		if (strtotime($_GET['start_date']) !== false && strtotime($_GET['end_date']) !== false) {
21 21
 			//$start_date = $_GET['start_date']." 00:00:00";
22
-			$start_date = date("Y-m-d",strtotime($_GET['start_date']))." 00:00:00";
22
+			$start_date = date("Y-m-d", strtotime($_GET['start_date']))." 00:00:00";
23 23
 			//$end_date = $_GET['end_date']." 00:00:00";
24
-			$end_date = date("Y-m-d",strtotime($_GET['end_date']))." 00:00:00";
24
+			$end_date = date("Y-m-d", strtotime($_GET['end_date']))." 00:00:00";
25 25
 			$sql_date = $start_date.",".$end_date;
26 26
 		}
27
-	} else if($_GET['start_date'] != ""){
27
+	} else if ($_GET['start_date'] != "") {
28 28
 		if (strtotime($_GET['start_date']) !== false) {
29 29
 			//$start_date = $_GET['start_date']." 00:00:00";
30
-			$start_date = date("Y-m-d",strtotime($_GET['start_date']))." 00:00:00";
30
+			$start_date = date("Y-m-d", strtotime($_GET['start_date']))." 00:00:00";
31 31
 			$sql_date = $start_date;
32 32
 		}
33
-	} else if($_GET['start_date'] == "" && $_GET['end_date'] != ""){
33
+	} else if ($_GET['start_date'] == "" && $_GET['end_date'] != "") {
34 34
 		if (strtotime($_GET['end_date']) !== false) {
35 35
 			//$end_date = date("Y-m-d H:i:s", strtotime("2014-04-12")).",".$_GET['end_date']." 00:00:00";
36
-			$end_date = date("Y-m-d H:i:s", strtotime("2014-04-12")).",".date("Y-m-d",strtotime($_GET['end_date']))." 00:00:00";
36
+			$end_date = date("Y-m-d H:i:s", strtotime("2014-04-12")).",".date("Y-m-d", strtotime($_GET['end_date']))." 00:00:00";
37 37
 			$sql_date = $end_date;
38 38
 		}
39 39
 	} else $sql_date = '';
@@ -41,21 +41,21 @@  discard block
 block discarded – undo
41 41
 
42 42
 if (isset($_GET['highest_altitude'])) {
43 43
 	//for altitude manipulation
44
-	if($_GET['highest_altitude'] != "" && $_GET['lowest_altitude'] != ""){
45
-		$end_altitude = filter_input(INPUT_GET,'highest_altitude',FILTER_SANITIZE_NUMBER_INT);
46
-		$start_altitude = filter_input(INPUT_GET,'lowest_altitude',FILTER_SANITIZE_NUMBER_INT);
44
+	if ($_GET['highest_altitude'] != "" && $_GET['lowest_altitude'] != "") {
45
+		$end_altitude = filter_input(INPUT_GET, 'highest_altitude', FILTER_SANITIZE_NUMBER_INT);
46
+		$start_altitude = filter_input(INPUT_GET, 'lowest_altitude', FILTER_SANITIZE_NUMBER_INT);
47 47
 		$sql_altitude = $start_altitude.",".$end_altitude;
48
-	} else if($_GET['highest_altitude'] != ""){
49
-		$end_altitude = filter_input(INPUT_GET,'highest_altitude',FILTER_SANITIZE_NUMBER_INT);
48
+	} else if ($_GET['highest_altitude'] != "") {
49
+		$end_altitude = filter_input(INPUT_GET, 'highest_altitude', FILTER_SANITIZE_NUMBER_INT);
50 50
 		$sql_altitude = $end_altitude;
51
-	} else if($_GET['highest_altitude'] == "" && $_GET['lowest_altitude'] != ""){
52
-		$start_altitude = filter_input(INPUT_GET,'lowest_altitude',FILTER_SANITIZE_NUMBER_INT).",60000";
51
+	} else if ($_GET['highest_altitude'] == "" && $_GET['lowest_altitude'] != "") {
52
+		$start_altitude = filter_input(INPUT_GET, 'lowest_altitude', FILTER_SANITIZE_NUMBER_INT).",60000";
53 53
 		$sql_altitude = $start_altitude;
54 54
 	} else $sql_altitude = '';
55 55
 } else $sql_altitude = '';
56 56
 
57 57
 //calculuation for the pagination
58
-if(!isset($_GET['limit']))
58
+if (!isset($_GET['limit']))
59 59
 {
60 60
 	if (!isset($_GET['number_results']))
61 61
 	{
@@ -63,45 +63,45 @@  discard block
 block discarded – undo
63 63
 		$limit_end = 25;
64 64
 		$absolute_difference = 25;
65 65
 	} else {
66
-		if ($_GET['number_results'] > 1000){
66
+		if ($_GET['number_results'] > 1000) {
67 67
 			$_GET['number_results'] = 1000;
68 68
 		}
69 69
 		$limit_start = 0;
70
-		$limit_end = filter_input(INPUT_GET,'number_results',FILTER_SANITIZE_NUMBER_INT);
71
-		$absolute_difference = filter_input(INPUT_GET,'number_results',FILTER_SANITIZE_NUMBER_INT);
70
+		$limit_end = filter_input(INPUT_GET, 'number_results', FILTER_SANITIZE_NUMBER_INT);
71
+		$absolute_difference = filter_input(INPUT_GET, 'number_results', FILTER_SANITIZE_NUMBER_INT);
72 72
 	}
73
-}  else {
73
+} else {
74 74
 	$limit_explode = explode(",", $_GET['limit']);
75
-	$limit_start = filter_var($limit_explode[0],FILTER_SANITIZE_NUMBER_INT);
76
-	$limit_end = filter_var($limit_explode[1],FILTER_SANITIZE_NUMBER_INT);
75
+	$limit_start = filter_var($limit_explode[0], FILTER_SANITIZE_NUMBER_INT);
76
+	$limit_end = filter_var($limit_explode[1], FILTER_SANITIZE_NUMBER_INT);
77 77
 }
78 78
 $absolute_difference = abs($limit_start - $limit_end);
79 79
 $limit_next = $limit_end + $absolute_difference;
80 80
 $limit_previous_1 = $limit_start - $absolute_difference;
81 81
 $limit_previous_2 = $limit_end - $absolute_difference;
82 82
 
83
-if (!empty($_GET)){  
84
-	$q = filter_input(INPUT_GET, 'q',FILTER_SANITIZE_STRING);
85
-	$registration = filter_input(INPUT_GET, 'registration',FILTER_SANITIZE_STRING);
86
-	$aircraft = filter_input(INPUT_GET, 'aircraft',FILTER_SANITIZE_STRING);
87
-	$manufacturer = filter_input(INPUT_GET, 'manufacturer',FILTER_SANITIZE_STRING);
88
-	$highlights = filter_input(INPUT_GET, 'highlights',FILTER_SANITIZE_STRING);
89
-	$airline = filter_input(INPUT_GET, 'airline',FILTER_SANITIZE_STRING);
90
-	$airline_country = filter_input(INPUT_GET, 'airline_country',FILTER_SANITIZE_STRING);
91
-	$airline_type = filter_input(INPUT_GET, 'airline_type',FILTER_SANITIZE_STRING);
92
-	$airport = filter_input(INPUT_GET, 'airport',FILTER_SANITIZE_STRING);
93
-	$airport_country = filter_input(INPUT_GET, 'airport_country',FILTER_SANITIZE_STRING);
94
-	$callsign = filter_input(INPUT_GET, 'callsign',FILTER_SANITIZE_STRING);
95
-	$owner = filter_input(INPUT_GET, 'owner',FILTER_SANITIZE_STRING);
96
-	$pilot_name = filter_input(INPUT_GET, 'pilot_name',FILTER_SANITIZE_STRING);
97
-	$pilot_id = filter_input(INPUT_GET, 'pilot_id',FILTER_SANITIZE_STRING);
98
-	$departure_airport_route = filter_input(INPUT_GET, 'departure_airport_route',FILTER_SANITIZE_STRING);
99
-	$arrival_airport_route = filter_input(INPUT_GET, 'arrival_airport_route',FILTER_SANITIZE_STRING);
100
-	$sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING);
101
-	$archive = filter_input(INPUT_GET,'archive',FILTER_SANITIZE_NUMBER_INT);
102
-	$origlat = filter_input(INPUT_GET,'origlat',FILTER_SANITIZE_NUMBER_FLOAT);
103
-	$origlon = filter_input(INPUT_GET,'origlon',FILTER_SANITIZE_NUMBER_FLOAT);
104
-	$dist = filter_input(INPUT_GET,'dist',FILTER_SANITIZE_NUMBER_INT);
83
+if (!empty($_GET)) {  
84
+	$q = filter_input(INPUT_GET, 'q', FILTER_SANITIZE_STRING);
85
+	$registration = filter_input(INPUT_GET, 'registration', FILTER_SANITIZE_STRING);
86
+	$aircraft = filter_input(INPUT_GET, 'aircraft', FILTER_SANITIZE_STRING);
87
+	$manufacturer = filter_input(INPUT_GET, 'manufacturer', FILTER_SANITIZE_STRING);
88
+	$highlights = filter_input(INPUT_GET, 'highlights', FILTER_SANITIZE_STRING);
89
+	$airline = filter_input(INPUT_GET, 'airline', FILTER_SANITIZE_STRING);
90
+	$airline_country = filter_input(INPUT_GET, 'airline_country', FILTER_SANITIZE_STRING);
91
+	$airline_type = filter_input(INPUT_GET, 'airline_type', FILTER_SANITIZE_STRING);
92
+	$airport = filter_input(INPUT_GET, 'airport', FILTER_SANITIZE_STRING);
93
+	$airport_country = filter_input(INPUT_GET, 'airport_country', FILTER_SANITIZE_STRING);
94
+	$callsign = filter_input(INPUT_GET, 'callsign', FILTER_SANITIZE_STRING);
95
+	$owner = filter_input(INPUT_GET, 'owner', FILTER_SANITIZE_STRING);
96
+	$pilot_name = filter_input(INPUT_GET, 'pilot_name', FILTER_SANITIZE_STRING);
97
+	$pilot_id = filter_input(INPUT_GET, 'pilot_id', FILTER_SANITIZE_STRING);
98
+	$departure_airport_route = filter_input(INPUT_GET, 'departure_airport_route', FILTER_SANITIZE_STRING);
99
+	$arrival_airport_route = filter_input(INPUT_GET, 'arrival_airport_route', FILTER_SANITIZE_STRING);
100
+	$sort = filter_input(INPUT_GET, 'sort', FILTER_SANITIZE_STRING);
101
+	$archive = filter_input(INPUT_GET, 'archive', FILTER_SANITIZE_NUMBER_INT);
102
+	$origlat = filter_input(INPUT_GET, 'origlat', FILTER_SANITIZE_NUMBER_FLOAT);
103
+	$origlon = filter_input(INPUT_GET, 'origlon', FILTER_SANITIZE_NUMBER_FLOAT);
104
+	$dist = filter_input(INPUT_GET, 'dist', FILTER_SANITIZE_NUMBER_INT);
105 105
 	if ($dist != '') {
106 106
 		if (isset($globalDistanceUnit) && $globalDistanceUnit == 'mi') $dist = $dist*1.60934;
107 107
 		elseif (isset($globalDistanceUnit) && $globalDistanceUnit == 'nm') $dist = $dist*1.852;
@@ -109,9 +109,9 @@  discard block
 block discarded – undo
109 109
 	if (!isset($sql_date)) $sql_date = '';
110 110
 	if ($archive == 1) {
111 111
 		$SpotterArchive = new SpotterArchive();
112
-		$spotter_array = $SpotterArchive->searchSpotterData($q,$registration,$aircraft,strtolower(str_replace("-", " ", $manufacturer)),$highlights,$airline,$airline_country,$airline_type,$airport,$airport_country,$callsign,$departure_airport_route,$arrival_airport_route,$owner,$pilot_id,$pilot_name,$sql_altitude,$sql_date,$limit_start.",".$absolute_difference,$sort,'',$origlat,$origlon,$dist);
112
+		$spotter_array = $SpotterArchive->searchSpotterData($q, $registration, $aircraft, strtolower(str_replace("-", " ", $manufacturer)), $highlights, $airline, $airline_country, $airline_type, $airport, $airport_country, $callsign, $departure_airport_route, $arrival_airport_route, $owner, $pilot_id, $pilot_name, $sql_altitude, $sql_date, $limit_start.",".$absolute_difference, $sort, '', $origlat, $origlon, $dist);
113 113
 	} else {
114
-		$spotter_array = $Spotter->searchSpotterData($q,$registration,$aircraft,strtolower(str_replace("-", " ", $manufacturer)),$highlights,$airline,$airline_country,$airline_type,$airport,$airport_country,$callsign,$departure_airport_route,$arrival_airport_route,$owner,$pilot_id,$pilot_name,$sql_altitude,$sql_date,$limit_start.",".$absolute_difference,$sort,'',$origlat,$origlon,$dist);
114
+		$spotter_array = $Spotter->searchSpotterData($q, $registration, $aircraft, strtolower(str_replace("-", " ", $manufacturer)), $highlights, $airline, $airline_country, $airline_type, $airport, $airport_country, $callsign, $departure_airport_route, $arrival_airport_route, $owner, $pilot_id, $pilot_name, $sql_altitude, $sql_date, $limit_start.",".$absolute_difference, $sort, '', $origlat, $origlon, $dist);
115 115
 	}
116 116
 	 
117 117
 	print '<span class="sub-menu-statistic column mobile">';
@@ -144,12 +144,12 @@  discard block
 block discarded – undo
144 144
 	//remove 3D=true parameter
145 145
 	$no3D = str_replace("&3D=true", "", $_SERVER['QUERY_STRING']);
146 146
 	$kmlURL = str_replace("http://", "kml://", $globalURL);
147
-	if (!isset($_GET['3D'])){
147
+	if (!isset($_GET['3D'])) {
148 148
 		print '<li><a href="'.$globalURL.'/search?'.$no3D.'" class="active"><i class="fa fa-table"></i> '._("Table").'</a></li>';
149 149
 	} else {
150 150
 		print '<li><span class="notablet"><a href="'.$globalURL.'/search?'.$no3D.'"><i class="fa fa-table"></i> '._("Table").'</a></span></li>';
151 151
 	}
152
-	if (isset($_GET['3D'])){
152
+	if (isset($_GET['3D'])) {
153 153
 		print '<li><a href="'.$globalURL.'/search?'.$no3D.'&3D=true" class="active"><i class="fa fa-globe"></i> '._("3D Map").'</a></li>';
154 154
 	} else {
155 155
 		print '<li ><a href="'.$globalURL.'/search?'.$no3D.'&3D=true" class="notablet nomobile"><i class="fa fa-globe"></i> '._("3D Map").'</a><a href="'.$kmlURL.'/search/kml?'.htmlentities($_SERVER['QUERY_STRING']).'" class="tablet mobile"><i class="fa fa-globe"></i> 3D Map</a></li>';
@@ -170,30 +170,30 @@  discard block
 block discarded – undo
170 170
 		print '<div class="column">';
171 171
 		print '<div class="info">';
172 172
 		print '<h1>'._("Search Results for").' ';
173
-		if (isset($_GET['q']) && $_GET['q'] != ""){ print _("Keyword:").' <span>'.$q.'</span> '; }
174
-		if (isset($_GET['aircraft']) && $_GET['aircraft'] != ""){ print _("Aircraft:").' <span>'.$aircraft.'</span> '; }
175
-		if (isset($_GET['manufacturer']) && $_GET['manufacturer'] != ""){ print _("Manufacturer:").' <span>'.$manufacturer.'</span> '; }
176
-		if (isset($_GET['registration']) && $_GET['registration'] != ""){ print _("Registration:").' <span>'.$registration.'</span> '; }
177
-		if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true"){ print _("Highlights:").' <span>'.$highlights.'</span> '; }
178
-		if (isset($_GET['airline']) && $_GET['airline'] != ""){ print _("Airline:").' <span>'.$airline.'</span> '; }
179
-		if (isset($_GET['airline_country']) && $_GET['airline_country'] != ""){ print _("Airline country:").' <span>'.$airline_country.'</span> '; }
180
-		if (isset($_GET['airline_type']) && $_GET['airline_type'] != ""){ print _("Airline type:").' <span>'.$airline_type.'</span> '; }
181
-		if (isset($_GET['airport']) && $_GET['airport'] != ""){ print _("Airport:").' <span>'.$airport.'</span> '; }
182
-		if (isset($_GET['airport_country']) && $_GET['airport_country'] != ""){ print _("Airport country:").' <span>'.$airport_country.'</span> '; }
183
-		if (isset($_GET['callsign']) && $_GET['callsign'] != ""){ print _("Callsign:").' <span>'.$callsign.'</span> '; }
184
-		if (isset($_GET['owner']) && $_GET['owner'] != ""){ print _("Owner:").' <span>'.$owner.'</span> '; }
185
-		if (isset($_GET['pilot_id']) && $_GET['pilot_id'] != ""){ print _("Pilot id:").' <span>'.$pilot_id.'</span> '; }
186
-		if (isset($_GET['pilot_name']) && $_GET['pilot_name'] != ""){ print _("Pilot name:").' <span>'.$pilot_name.'</span> '; }
187
-		if (isset($_GET['departure_airport_route']) && $_GET['departure_airport_route'] != "" && (!isset($_GET['arrival_airport_route']) || $_GET['arrival_airport_route'] == "")){ print _("Route out of:").' <span>'.$departure_airport_route.'</span> '; }
188
-		if (isset($_GET['departure_airport_route']) && $_GET['departure_airport_route'] == "" && isset($_GET['arrival_airport_route']) && $_GET['arrival_airport_route'] != ""){ print _("Route into:").' <span>'.$arrival_airport_route.'</span> '; }
189
-		if (isset($_GET['departure_airport_route']) && $_GET['departure_airport_route'] != "" && isset($_GET['arrival_airport_route']) && $_GET['arrival_airport_route'] != ""){ print _("Route between:").' <span>'.$departure_airport_route.'</span> and <span>'.$_GET['arrival_airport_route'].'</span> '; }
190
-		if (isset($_GET['start_date']) && $_GET['start_date'] != "" && isset($_GET['end_date']) && $_GET['end_date'] == ""){ print _("Date starting at:").' <span>'.$start_date.'</span> '; }
191
-		if (isset($_GET['start_date']) && $_GET['start_date'] == "" && isset($_GET['end_date']) && $_GET['end_date'] != ""){ print _("Date ending at:").' <span>'.$end_date.'</span> '; }
192
-		if (isset($_GET['start_date']) && $_GET['start_date'] != "" && isset($_GET['end_date']) && $_GET['end_date'] != ""){ print _("Date between:").' <span>'.$start_date.'</span> and <span>'.$end_date.'</span> '; }
193
-		if (isset($_GET['lowest_altitude']) && $_GET['lowest_altitude'] != "" && isset($_GET['highest_altitude']) && $_GET['highest_altitude'] == ""){ print _("Altitude starting at:").' <span>'.number_format($lowest_altitude).' feet</span> '; }
194
-		if (isset($_GET['lowest_altitude']) && $_GET['lowest_altitude'] == "" && isset($_GET['highest_altitude']) && $_GET['highest_altitude'] != ""){ print _("Altitude ending at:").' <span>'.number_format($highest_altitude).' feet</span> '; }
195
-		if (isset($_GET['lowest_altitude']) && $_GET['lowest_altitude'] != "" && isset($_GET['highest_altitude']) && $_GET['highest_altitude'] != ""){ print _("Altitude between:").' <span>'.number_format($lowest_altitude).' feet</span> '._("and").' <span>'.number_format($highest_altitude).' feet</span> '; }
196
-		if (isset($_GET['number_results']) && $_GET['number_results'] != ""){ print _("limit per page:").' <span>'.$number_results.'</span> '; }
173
+		if (isset($_GET['q']) && $_GET['q'] != "") { print _("Keyword:").' <span>'.$q.'</span> '; }
174
+		if (isset($_GET['aircraft']) && $_GET['aircraft'] != "") { print _("Aircraft:").' <span>'.$aircraft.'</span> '; }
175
+		if (isset($_GET['manufacturer']) && $_GET['manufacturer'] != "") { print _("Manufacturer:").' <span>'.$manufacturer.'</span> '; }
176
+		if (isset($_GET['registration']) && $_GET['registration'] != "") { print _("Registration:").' <span>'.$registration.'</span> '; }
177
+		if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true") { print _("Highlights:").' <span>'.$highlights.'</span> '; }
178
+		if (isset($_GET['airline']) && $_GET['airline'] != "") { print _("Airline:").' <span>'.$airline.'</span> '; }
179
+		if (isset($_GET['airline_country']) && $_GET['airline_country'] != "") { print _("Airline country:").' <span>'.$airline_country.'</span> '; }
180
+		if (isset($_GET['airline_type']) && $_GET['airline_type'] != "") { print _("Airline type:").' <span>'.$airline_type.'</span> '; }
181
+		if (isset($_GET['airport']) && $_GET['airport'] != "") { print _("Airport:").' <span>'.$airport.'</span> '; }
182
+		if (isset($_GET['airport_country']) && $_GET['airport_country'] != "") { print _("Airport country:").' <span>'.$airport_country.'</span> '; }
183
+		if (isset($_GET['callsign']) && $_GET['callsign'] != "") { print _("Callsign:").' <span>'.$callsign.'</span> '; }
184
+		if (isset($_GET['owner']) && $_GET['owner'] != "") { print _("Owner:").' <span>'.$owner.'</span> '; }
185
+		if (isset($_GET['pilot_id']) && $_GET['pilot_id'] != "") { print _("Pilot id:").' <span>'.$pilot_id.'</span> '; }
186
+		if (isset($_GET['pilot_name']) && $_GET['pilot_name'] != "") { print _("Pilot name:").' <span>'.$pilot_name.'</span> '; }
187
+		if (isset($_GET['departure_airport_route']) && $_GET['departure_airport_route'] != "" && (!isset($_GET['arrival_airport_route']) || $_GET['arrival_airport_route'] == "")) { print _("Route out of:").' <span>'.$departure_airport_route.'</span> '; }
188
+		if (isset($_GET['departure_airport_route']) && $_GET['departure_airport_route'] == "" && isset($_GET['arrival_airport_route']) && $_GET['arrival_airport_route'] != "") { print _("Route into:").' <span>'.$arrival_airport_route.'</span> '; }
189
+		if (isset($_GET['departure_airport_route']) && $_GET['departure_airport_route'] != "" && isset($_GET['arrival_airport_route']) && $_GET['arrival_airport_route'] != "") { print _("Route between:").' <span>'.$departure_airport_route.'</span> and <span>'.$_GET['arrival_airport_route'].'</span> '; }
190
+		if (isset($_GET['start_date']) && $_GET['start_date'] != "" && isset($_GET['end_date']) && $_GET['end_date'] == "") { print _("Date starting at:").' <span>'.$start_date.'</span> '; }
191
+		if (isset($_GET['start_date']) && $_GET['start_date'] == "" && isset($_GET['end_date']) && $_GET['end_date'] != "") { print _("Date ending at:").' <span>'.$end_date.'</span> '; }
192
+		if (isset($_GET['start_date']) && $_GET['start_date'] != "" && isset($_GET['end_date']) && $_GET['end_date'] != "") { print _("Date between:").' <span>'.$start_date.'</span> and <span>'.$end_date.'</span> '; }
193
+		if (isset($_GET['lowest_altitude']) && $_GET['lowest_altitude'] != "" && isset($_GET['highest_altitude']) && $_GET['highest_altitude'] == "") { print _("Altitude starting at:").' <span>'.number_format($lowest_altitude).' feet</span> '; }
194
+		if (isset($_GET['lowest_altitude']) && $_GET['lowest_altitude'] == "" && isset($_GET['highest_altitude']) && $_GET['highest_altitude'] != "") { print _("Altitude ending at:").' <span>'.number_format($highest_altitude).' feet</span> '; }
195
+		if (isset($_GET['lowest_altitude']) && $_GET['lowest_altitude'] != "" && isset($_GET['highest_altitude']) && $_GET['highest_altitude'] != "") { print _("Altitude between:").' <span>'.number_format($lowest_altitude).' feet</span> '._("and").' <span>'.number_format($highest_altitude).' feet</span> '; }
196
+		if (isset($_GET['number_results']) && $_GET['number_results'] != "") { print _("limit per page:").' <span>'.$number_results.'</span> '; }
197 197
 		print '</h1>';
198 198
 		print '</div>';
199 199
 
@@ -300,7 +300,7 @@  discard block
 block discarded – undo
300 300
 					    </select>
301 301
 					</div>
302 302
 				</div>
303
-				<script type="text/javascript">getSelect('manufacturer','<?php if(isset($_GET['manufacturer'])) print $manufacturer; ?>')</script>
303
+				<script type="text/javascript">getSelect('manufacturer','<?php if (isset($_GET['manufacturer'])) print $manufacturer; ?>')</script>
304 304
 				<div class="form-group">
305 305
 					<label class="control-label col-sm-2"><?php echo _("Type"); ?></label>
306 306
 						<div class="col-sm-10">
@@ -309,7 +309,7 @@  discard block
 block discarded – undo
309 309
 							</select>
310 310
 						</div>
311 311
 				</div>
312
-				<script type="text/javascript">getSelect('aircrafttypes','<?php if(isset($_GET['aircraft_icao'])) print $aircraft_icao; ?>');</script>
312
+				<script type="text/javascript">getSelect('aircrafttypes','<?php if (isset($_GET['aircraft_icao'])) print $aircraft_icao; ?>');</script>
313 313
 				<div class="form-group">
314 314
 					<label class="control-label col-sm-2"><?php echo _("Registration"); ?></label> 
315 315
 					<div class="col-sm-10">
@@ -332,7 +332,7 @@  discard block
 block discarded – undo
332 332
 					</div>
333 333
 				</div>
334 334
 <?php
335
-}else {
335
+} else {
336 336
 ?>
337 337
 				<div class="form-group">
338 338
 					<label class="control-label col-sm-2"><?php echo _("Owner name"); ?></label> 
@@ -345,8 +345,8 @@  discard block
 block discarded – undo
345 345
 ?>
346 346
 				<div class="form-group">
347 347
 					<div class="col-sm-offset-2 col-sm-10">
348
-					<!--<div><input type="checkbox" class="form-control" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true"){ print 'checked="checked"'; } ?>> <label for="highlights"><?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label></div>-->
349
-					<label class="checkbox-inline"><input type="checkbox" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true"){ print 'checked="checked"'; } ?>> <?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label>
348
+					<!--<div><input type="checkbox" class="form-control" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true") { print 'checked="checked"'; } ?>> <label for="highlights"><?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label></div>-->
349
+					<label class="checkbox-inline"><input type="checkbox" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true") { print 'checked="checked"'; } ?>> <?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label>
350 350
 					</div>
351 351
 				</div>
352 352
 			</fieldset>
@@ -360,7 +360,7 @@  discard block
 block discarded – undo
360 360
 						</select>
361 361
 					</div>
362 362
 				</div>
363
-				<script type="text/javascript">getSelect('airlinenames','<?php if(isset($_GET['airline'])) print $airline; ?>');</script>
363
+				<script type="text/javascript">getSelect('airlinenames','<?php if (isset($_GET['airline'])) print $airline; ?>');</script>
364 364
 				<div class="form-group">
365 365
 					<label class="control-label col-sm-2"><?php echo _("Country"); ?></label> 
366 366
 					<div class="col-sm-10">
@@ -369,7 +369,7 @@  discard block
 block discarded – undo
369 369
 						</select>
370 370
 					</div>
371 371
 				</div>
372
-				<script type="text/javascript">getSelect('airlinecountries','<?php if(isset($_GET['airline_country'])) print $airline_country; ?>');</script>
372
+				<script type="text/javascript">getSelect('airlinecountries','<?php if (isset($_GET['airline_country'])) print $airline_country; ?>');</script>
373 373
 				<div class="form-group">
374 374
 					<label class="control-label col-sm-2"><?php echo _("Callsign"); ?></label> 
375 375
 					<div class="col-sm-10">
@@ -378,10 +378,10 @@  discard block
 block discarded – undo
378 378
 				</div>
379 379
 				<div class="form-group">
380 380
 					<div class="col-sm-offset-2 col-sm-10">
381
-						<label class="radio-inline"><input type="radio" name="airline_type" value="all" id="airline_type_all" <?php if (!isset($_GET['airline_type']) || $_GET['airline_type'] == "all"){ print 'checked="checked"'; } ?>> <?php echo _("All airlines types"); ?></label>
382
-						<label class="radio-inline"><input type="radio" name="airline_type" value="passenger" id="airline_type_passenger" <?php if (isset($_GET['airline_type'])) if ($_GET['airline_type'] == "passenger"){ print 'checked="checked"'; } ?>> <?php echo _("Only Passenger airlines"); ?></label>
383
-						<label class="radio-inline"><input type="radio" name="airline_type" value="cargo" id="airline_type_cargo" <?php if (isset($_GET['airline_type'])) if ( $_GET['airline_type'] == "cargo"){ print 'checked="checked"'; } ?>> <?php echo _("Only Cargo airlines"); ?></label>
384
-						<label class="radio-inline"><input type="radio" name="airline_type" value="military" id="airline_type_military" <?php if (isset($_GET['airline_type'])) if ( $_GET['airline_type'] == "military"){ print 'checked="checked"'; } ?>> <?php echo _("Only Military airlines"); ?></label>
381
+						<label class="radio-inline"><input type="radio" name="airline_type" value="all" id="airline_type_all" <?php if (!isset($_GET['airline_type']) || $_GET['airline_type'] == "all") { print 'checked="checked"'; } ?>> <?php echo _("All airlines types"); ?></label>
382
+						<label class="radio-inline"><input type="radio" name="airline_type" value="passenger" id="airline_type_passenger" <?php if (isset($_GET['airline_type'])) if ($_GET['airline_type'] == "passenger") { print 'checked="checked"'; } ?>> <?php echo _("Only Passenger airlines"); ?></label>
383
+						<label class="radio-inline"><input type="radio" name="airline_type" value="cargo" id="airline_type_cargo" <?php if (isset($_GET['airline_type'])) if ($_GET['airline_type'] == "cargo") { print 'checked="checked"'; } ?>> <?php echo _("Only Cargo airlines"); ?></label>
384
+						<label class="radio-inline"><input type="radio" name="airline_type" value="military" id="airline_type_military" <?php if (isset($_GET['airline_type'])) if ($_GET['airline_type'] == "military") { print 'checked="checked"'; } ?>> <?php echo _("Only Military airlines"); ?></label>
385 385
 					</div>
386 386
 				</div>
387 387
 			</fieldset>
@@ -395,7 +395,7 @@  discard block
 block discarded – undo
395 395
 						</select>
396 396
 					</div>
397 397
 				</div>
398
-				<script type="text/javascript">getSelect('airportnames','<?php if(isset($_GET['airport_icao'])) print $airport_icao; ?>');</script>
398
+				<script type="text/javascript">getSelect('airportnames','<?php if (isset($_GET['airport_icao'])) print $airport_icao; ?>');</script>
399 399
 				<div class="form-group">
400 400
 					<label class="control-label col-sm-2"><?php echo _("Country"); ?></label> 
401 401
 					<div class="col-sm-10">
@@ -404,7 +404,7 @@  discard block
 block discarded – undo
404 404
 						</select>
405 405
 					</div>
406 406
 				</div>
407
-				<script type="text/javascript">getSelect('airportcountries','<?php if(isset($_GET['airport_country'])) print $airport_country; ?>');</script>
407
+				<script type="text/javascript">getSelect('airportcountries','<?php if (isset($_GET['airport_country'])) print $airport_country; ?>');</script>
408 408
 			</fieldset>
409 409
 			<fieldset>
410 410
 				<legend><?php echo _("Route"); ?></legend>
@@ -416,7 +416,7 @@  discard block
 block discarded – undo
416 416
 						</select>
417 417
 					</div>
418 418
 				</div>
419
-				<script type="text/javascript">getSelect('departureairportnames','<?php if(isset($_GET['departure_airport_route'])) print $departure_airport_route; ?>');</script>
419
+				<script type="text/javascript">getSelect('departureairportnames','<?php if (isset($_GET['departure_airport_route'])) print $departure_airport_route; ?>');</script>
420 420
 				<div class="form-group">
421 421
 					<label class="control-label col-sm-2"><?php echo _("Arrival Airport"); ?></label> 
422 422
 					<div class="col-sm-10">
@@ -425,7 +425,7 @@  discard block
 block discarded – undo
425 425
 						</select>
426 426
 					</div>
427 427
 				</div>
428
-				<script type="text/javascript">getSelect('arrivalairportnames','<?php if(isset($_GET['arrival_airport_route'])) print $arrival_airport_route; ?>');</script>
428
+				<script type="text/javascript">getSelect('arrivalairportnames','<?php if (isset($_GET['arrival_airport_route'])) print $arrival_airport_route; ?>');</script>
429 429
 			</fieldset>
430 430
 			<fieldset>
431 431
 				<legend><?php echo _("Date"); ?></legend>
@@ -479,9 +479,9 @@  discard block
 block discarded – undo
479 479
 						<option></option>
480 480
 <?php
481 481
 $altitude_array = Array(1000, 5000, 10000, 15000, 20000, 25000, 30000, 35000, 40000, 45000, 50000);
482
-foreach($altitude_array as $altitude)
482
+foreach ($altitude_array as $altitude)
483 483
 {
484
-	if(isset($_GET['lowest_altitude']) && $_GET['lowest_altitude'] == $altitude)
484
+	if (isset($_GET['lowest_altitude']) && $_GET['lowest_altitude'] == $altitude)
485 485
 	{
486 486
 		print '<option value="'.$altitude.'" selected="selected">'.number_format($altitude).' feet</option>';
487 487
 	} else {
@@ -499,9 +499,9 @@  discard block
 block discarded – undo
499 499
 					<option></option>
500 500
 <?php
501 501
 $altitude_array = Array(1000, 5000, 10000, 15000, 20000, 25000, 30000, 35000, 40000, 45000, 50000);
502
-foreach($altitude_array as $altitude)
502
+foreach ($altitude_array as $altitude)
503 503
 {
504
-	if(isset($_GET['highest_altitude']) && $_GET['highest_altitude'] == $altitude)
504
+	if (isset($_GET['highest_altitude']) && $_GET['highest_altitude'] == $altitude)
505 505
 	{
506 506
 		print '<option value="'.$altitude.'" selected="selected">'.number_format($altitude).' feet</option>';
507 507
 	} else {
@@ -540,10 +540,10 @@  discard block
 block discarded – undo
540 540
 				<div class="col-sm-10">
541 541
 					<select class="form-control" name="number_results">
542 542
 <?php
543
-$number_results_array = Array(25, 50, 100, 150, 200, 250, 300, 400, 500,  600, 700, 800, 900, 1000);
544
-foreach($number_results_array as $number)
543
+$number_results_array = Array(25, 50, 100, 150, 200, 250, 300, 400, 500, 600, 700, 800, 900, 1000);
544
+foreach ($number_results_array as $number)
545 545
 {
546
-	if(isset($_GET['number_results']) && $_GET['number_results'] == $number)
546
+	if (isset($_GET['number_results']) && $_GET['number_results'] == $number)
547 547
 	{
548 548
 		print '<option value="'.$number.'" selected="selected">'.$number.'</option>';
549 549
 	} else {
@@ -562,7 +562,7 @@  discard block
 block discarded – undo
562 562
 		<fieldset>
563 563
 			<div class="form-group">
564 564
 				<div class="col-sm-offset-2 col-sm-10">
565
-					<label class="checkbox-inline"><input type="checkbox" name="archive" value="1" disabled /><?php echo sprintf(_("Search in archive (older than %s months)"),$globalArchiveKeepMonths); ?></label>
565
+					<label class="checkbox-inline"><input type="checkbox" name="archive" value="1" disabled /><?php echo sprintf(_("Search in archive (older than %s months)"), $globalArchiveKeepMonths); ?></label>
566 566
 					<p class="help-block">Disabled in demo</p>
567 567
 				</div>
568 568
 			</div>
@@ -573,7 +573,7 @@  discard block
 block discarded – undo
573 573
 		<fieldset>
574 574
 			<div class="form-group">
575 575
 				<div class="col-sm-offset-2 col-sm-10">
576
-					<label class="checkbox-inline"><input type="checkbox" name="archive" value="1" /><?php echo sprintf(_("Search in archive (older than %s months)"),$globalArchiveKeepMonths); ?></label>
576
+					<label class="checkbox-inline"><input type="checkbox" name="archive" value="1" /><?php echo sprintf(_("Search in archive (older than %s months)"), $globalArchiveKeepMonths); ?></label>
577 577
 				</div>
578 578
 			</div>
579 579
 		</fieldset>
Please login to merge, or discard this patch.
index.php 1 patch
Spacing   +15 added lines, -15 removed lines patch added patch discarded remove patch
@@ -4,7 +4,7 @@  discard block
 block discarded – undo
4 4
 require_once('require/class.Language.php');
5 5
 require_once('require/class.Satellite.php');
6 6
 
7
-$trackident = filter_input(INPUT_GET,'trackid',FILTER_SANITIZE_STRING);
7
+$trackident = filter_input(INPUT_GET, 'trackid', FILTER_SANITIZE_STRING);
8 8
 if ($trackident != '') {
9 9
 	require_once('require/class.SpotterLive.php');
10 10
 	$SpotterLive = new SpotterLive();
@@ -14,7 +14,7 @@  discard block
 block discarded – undo
14 14
 		$spotterid = $Spotter->getSpotterIDBasedOnFlightAwareID($trackident);
15 15
 		header('Location: '.$globalURL.'/flightid/'.$spotterid);
16 16
 	} else {
17
-		setcookie('MapTrack',$resulttrackident[0]['flightaware_id']);
17
+		setcookie('MapTrack', $resulttrackident[0]['flightaware_id']);
18 18
 	}
19 19
 } else {
20 20
 	unset($_COOKIE['MapTrack']);
@@ -194,7 +194,7 @@  discard block
 block discarded – undo
194 194
 		        <div class="form-group">
195 195
 			    <label>From (UTC):</label>
196 196
 		            <div class='input-group date' id='datetimepicker1'>
197
-            			<input type='text' name="start_date" class="form-control" value="<?php if (isset($_POST['start_date'])) print $_POST['start_date']; elseif (isset($_COOKIE['archive_begin'])) print date("m/d/Y h:i a",$_COOKIE['archive_begin']); ?>" required />
197
+            			<input type='text' name="start_date" class="form-control" value="<?php if (isset($_POST['start_date'])) print $_POST['start_date']; elseif (isset($_COOKIE['archive_begin'])) print date("m/d/Y h:i a", $_COOKIE['archive_begin']); ?>" required />
198 198
 		                <span class="input-group-addon">
199 199
             			    <span class="glyphicon glyphicon-calendar"></span>
200 200
 		                </span>
@@ -203,7 +203,7 @@  discard block
 block discarded – undo
203 203
 		        <div class="form-group">
204 204
 			    <label>To (UTC):</label>
205 205
 		            <div class='input-group date' id='datetimepicker2'>
206
-		                <input type='text' name="end_date" class="form-control" value="<?php if (isset($_POST['end_date'])) print $_POST['end_date']; elseif (isset($_COOKIE['archive_end'])) print date("m/d/Y h:i a",$_COOKIE['archive_end']); ?>" />
206
+		                <input type='text' name="end_date" class="form-control" value="<?php if (isset($_POST['end_date'])) print $_POST['end_date']; elseif (isset($_COOKIE['archive_end'])) print date("m/d/Y h:i a", $_COOKIE['archive_end']); ?>" />
207 207
             			<span class="input-group-addon">
208 208
 		                    <span class="glyphicon glyphicon-calendar"></span>
209 209
             			</span>
@@ -327,9 +327,9 @@  discard block
 block discarded – undo
327 327
 		    <li><?php echo _("Type of Terrain:"); ?>
328 328
 			<select  class="selectpicker" onchange="terrainType(this);">
329 329
 			    <option value="stk"<?php if (!isset($_COOKIE['MapTerrain']) || $_COOKIE['MapTerrain'] == 'stk') print ' selected'; ?>>stk terrain</option>
330
-			    <option value="ellipsoid"<?php if (isset($_COOKIE['MapTerrain']) && $_COOKIE['MapTerrain'] == 'ellipsoid') print ' selected';?>>ellipsoid</option>
331
-			    <option value="vrterrain"<?php if (isset($_COOKIE['MapTerrain']) && $_COOKIE['MapTerrain'] == 'vrterrain') print ' selected';?>>vr terrain</option>
332
-			    <option value="articdem"<?php if (isset($_COOKIE['MapTerrain']) && $_COOKIE['MapTerrain'] == 'articdem') print ' selected';?>>ArticDEM</option>
330
+			    <option value="ellipsoid"<?php if (isset($_COOKIE['MapTerrain']) && $_COOKIE['MapTerrain'] == 'ellipsoid') print ' selected'; ?>>ellipsoid</option>
331
+			    <option value="vrterrain"<?php if (isset($_COOKIE['MapTerrain']) && $_COOKIE['MapTerrain'] == 'vrterrain') print ' selected'; ?>>vr terrain</option>
332
+			    <option value="articdem"<?php if (isset($_COOKIE['MapTerrain']) && $_COOKIE['MapTerrain'] == 'articdem') print ' selected'; ?>>ArticDEM</option>
333 333
 			</select>
334 334
 		    </li>
335 335
 <?php
@@ -365,7 +365,7 @@  discard block
 block discarded – undo
365 365
 		    <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>
366 366
 <?php
367 367
     }
368
-    if (time() > mktime(0,0,0,12,1,date("Y")) && time() < mktime(0,0,0,12,31,date("Y"))) {
368
+    if (time() > mktime(0, 0, 0, 12, 1, date("Y")) && time() < mktime(0, 0, 0, 12, 31, date("Y"))) {
369 369
 ?>
370 370
 		    <li><div class="checkbox"><label><input type="checkbox" name="displaysanta" value="1" onclick="clickSanta(this)"><i class="fa fa-snowflake-o" aria-hidden="true"></i> <?php echo _("Show Santa Claus now"); ?> <i class="fa fa-snowflake-o" aria-hidden="true"></i></label></div></li>
371 371
 <?php
@@ -541,10 +541,10 @@  discard block
 block discarded – undo
541 541
 					$Spotter = new Spotter();
542 542
 					$allairlinenames = $Spotter->getAllAirlineNames();
543 543
 				}
544
-				foreach($allairlinenames as $airline) {
544
+				foreach ($allairlinenames as $airline) {
545 545
 					$airline_name = $airline['airline_name'];
546
-					if (strlen($airline_name) > 30) $airline_name = substr($airline_name,0,30).'...';
547
-					if (isset($_COOKIE['filter_Airlines']) && in_array($airline['airline_icao'],explode(',',$_COOKIE['filter_Airlines']))) {
546
+					if (strlen($airline_name) > 30) $airline_name = substr($airline_name, 0, 30).'...';
547
+					if (isset($_COOKIE['filter_Airlines']) && in_array($airline['airline_icao'], explode(',', $_COOKIE['filter_Airlines']))) {
548 548
 						echo '<option value="'.$airline['airline_icao'].'" selected>'.$airline_name.'</option>';
549 549
 					} else {
550 550
 						echo '<option value="'.$airline['airline_icao'].'">'.$airline_name.'</option>';
@@ -563,7 +563,7 @@  discard block
 block discarded – undo
563 563
 			<select class="selectpicker" onchange="alliance(this);" id="display_alliance">
564 564
 			    <option value="all"<?php if (!isset($_COOKIE['filter_alliance']) || $_COOKIE['filter_alliance'] == 'all' || $_COOKIE['filter_alliance'] == '') echo ' selected'; ?>><?php echo _("All"); ?></option>
565 565
 			    <?php
566
-				foreach($allalliancenames as $alliance) {
566
+				foreach ($allalliancenames as $alliance) {
567 567
 					$alliance_name = $alliance['alliance'];
568 568
 					if (isset($_COOKIE['filter_alliance']) && $_COOKIE['filter_alliance'] == $alliance_name) {
569 569
 						echo '<option value="'.$alliance_name.'" selected>'.$alliance_name.'</option>';
@@ -599,8 +599,8 @@  discard block
 block discarded – undo
599 599
 				*/
600 600
 				$Source = new Source();
601 601
 				$datasource = $Source->getLocationInfoByType('gs');
602
-				foreach($datasource as $src) {
603
-					if (isset($_COOKIE['filter_Sources']) && in_array($src['name'],explode(',',$_COOKIE['filter_Sources']))) {
602
+				foreach ($datasource as $src) {
603
+					if (isset($_COOKIE['filter_Sources']) && in_array($src['name'], explode(',', $_COOKIE['filter_Sources']))) {
604 604
 						echo '<option value="'.$src['name'].'" selected>'.$src['name'].'</option>';
605 605
 					} else {
606 606
 						echo '<option value="'.$src['name'].'">'.$src['name'].'</option>';
@@ -679,7 +679,7 @@  discard block
 block discarded – undo
679 679
 					else if ($type_name == 'radar') $type_name = 'Radar Calibration';
680 680
 					else if ($type_name == 'tle-new') $type_name = 'Last 30 days launches';
681 681
 					
682
-					if (isset($_COOKIE['sattypes']) && in_array($type['tle_type'],explode(',',$_COOKIE['sattypes']))) {
682
+					if (isset($_COOKIE['sattypes']) && in_array($type['tle_type'], explode(',', $_COOKIE['sattypes']))) {
683 683
 						print '<option value="'.$type['tle_type'].'" selected>'.$type_name.'</option>';
684 684
 					} else {
685 685
 						print '<option value="'.$type['tle_type'].'">'.$type_name.'</option>';
Please login to merge, or discard this patch.
location-data.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -5,7 +5,7 @@  discard block
 block discarded – undo
5 5
 $Source = new Source();
6 6
 
7 7
 if (isset($_GET['sourceid'])) {
8
-	$sourceid = filter_input(INPUT_GET,'sourceid',FILTER_SANITIZE_NUMBER_INT);
8
+	$sourceid = filter_input(INPUT_GET, 'sourceid', FILTER_SANITIZE_NUMBER_INT);
9 9
 	$source_data = $Source->getLocationInfoById($sourceid);
10 10
 	if (isset($source_data[0])) {
11 11
  ?>
@@ -37,8 +37,8 @@  discard block
 block discarded – undo
37 37
 print '</div>';
38 38
 
39 39
 if ($spotter_item['city'] != '') print '<div><span>'._("City").'</span>'.$spotter_item['city'].'</div>';
40
-if ($spotter_item['country'] !='') print '<div><span>'._("Country").'</span>'.$spotter_item['country'].'</div>';
41
-print '<div><span>'._("Coordinates").'</span>'.round($spotter_item['latitude'],4).', '.round($spotter_item['longitude'],4).'</div>';
40
+if ($spotter_item['country'] != '') print '<div><span>'._("Country").'</span>'.$spotter_item['country'].'</div>';
41
+print '<div><span>'._("Coordinates").'</span>'.round($spotter_item['latitude'], 4).', '.round($spotter_item['longitude'], 4).'</div>';
42 42
 /*
43 43
 if ($spotter_item['atc_range'] > 0) {
44 44
     print '<div><span>'._("Range").'</span>';
@@ -47,7 +47,7 @@  discard block
 block discarded – undo
47 47
 }
48 48
 */
49 49
 if ($spotter_item['type'] == 'wx') {
50
-	$weather = json_decode($spotter_item['description'],true);
50
+	$weather = json_decode($spotter_item['description'], true);
51 51
 	//print_r($weather);
52 52
 	if (isset($weather['temp'])) print '<div><span>'._("Temperature").'</span>'.$weather['temp'].'°C</div>';
53 53
 	if (isset($weather['pressure'])) print '<div><span>'._("Pressure").'</span>'.$weather['pressure'].'hPa</div>';
Please login to merge, or discard this patch.
country-detailed.php 1 patch
Spacing   +9 added lines, -9 removed lines patch added patch discarded remove patch
@@ -3,17 +3,17 @@  discard block
 block discarded – undo
3 3
 require_once('require/class.Spotter.php');
4 4
 require_once('require/class.Language.php');
5 5
 
6
-if (!isset($_GET['country'])){
6
+if (!isset($_GET['country'])) {
7 7
 	header('Location: '.$globalURL.'');
8 8
 } else {
9 9
 	$Spotter = new Spotter();
10 10
 	//calculuation for the pagination
11
-	if(!isset($_GET['limit']))
11
+	if (!isset($_GET['limit']))
12 12
 	{
13 13
 	  $limit_start = 0;
14 14
 	  $limit_end = 25;
15 15
 	  $absolute_difference = 25;
16
-	}  else {
16
+	} else {
17 17
 		$limit_explode = explode(",", $_GET['limit']);
18 18
 		$limit_start = $limit_explode[0];
19 19
 		$limit_end = $limit_explode[1];
@@ -30,7 +30,7 @@  discard block
 block discarded – undo
30 30
 	$country = ucwords(str_replace("-", " ", $_GET['country']));
31 31
 	
32 32
 	$page_url = $globalURL.'/country/'.$_GET['country'];
33
-	$sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING);
33
+	$sort = filter_input(INPUT_GET, 'sort', FILTER_SANITIZE_STRING);
34 34
 	if ($country == 'Na') {
35 35
 		$spotter_array = array();
36 36
 	} else {
@@ -43,7 +43,7 @@  discard block
 block discarded – undo
43 43
 
44 44
 	if (!empty($spotter_array))
45 45
 	{
46
-		$title = sprintf(_("Detailed View for Airports &amp; Airlines from %s"),$country);
46
+		$title = sprintf(_("Detailed View for Airports &amp; Airlines from %s"), $country);
47 47
 
48 48
 		require_once('header.php');
49 49
 		print '<div class="select-item">';
@@ -51,9 +51,9 @@  discard block
 block discarded – undo
51 51
 		print '<select name="country" class="selectpicker" data-live-search="true">';
52 52
 		print '<option></option>';
53 53
 		$all_countries = $Spotter->getAllCountries();
54
-		foreach($all_countries as $all_country)
54
+		foreach ($all_countries as $all_country)
55 55
 		{
56
-			if($country == $all_country['country'])
56
+			if ($country == $all_country['country'])
57 57
 			{
58 58
 				print '<option value="'.strtolower(str_replace(" ", "-", $all_country['country'])).'" selected="selected">'.$all_country['country'].'</option>';
59 59
 			} else {
@@ -68,7 +68,7 @@  discard block
 block discarded – undo
68 68
 		if ($_GET['country'] != "NA")
69 69
 		{
70 70
 			print '<div class="info column">';
71
-			print '<h1>'.sprintf(_("Airports &amp; Airlines from %s"),$country).'</h1>';
71
+			print '<h1>'.sprintf(_("Airports &amp; Airlines from %s"), $country).'</h1>';
72 72
 			print '</div>';
73 73
 		} else {
74 74
 			print '<div class="alert alert-warning">'._("This special country profile shows all flights that do <u>not</u> have a country of a airline or departure/arrival airport associated with them.").'</div>';
@@ -76,7 +76,7 @@  discard block
 block discarded – undo
76 76
 
77 77
 		include('country-sub-menu.php');
78 78
 		print '<div class="table column">';
79
-		print '<p>'.sprintf(_("The table below shows the detailed information of all flights of airports (both departure &amp; arrival) OR airlines from <strong>%s</strong>."),$country).'</p>';
79
+		print '<p>'.sprintf(_("The table below shows the detailed information of all flights of airports (both departure &amp; arrival) OR airlines from <strong>%s</strong>."), $country).'</p>';
80 80
 
81 81
 		include('table-output.php');
82 82
 		print '<div class="pagination">';
Please login to merge, or discard this patch.
sitemap.php 1 patch
Spacing   +20 added lines, -20 removed lines patch added patch discarded remove patch
@@ -14,7 +14,7 @@  discard block
 block discarded – undo
14 14
 	$output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">';
15 15
 
16 16
 		$spotter_array = $Spotter->getAllFlightsforSitemap();
17
-		foreach($spotter_array as $spotter_item)
17
+		foreach ($spotter_array as $spotter_item)
18 18
 		{
19 19
 			$output .= '<url>';
20 20
 			    $output .= '<loc>'.'http://'.$_SERVER['HTTP_HOST'].$globalURL.'/flightid/'.$spotter_item['spotter_id'].'</loc>';
@@ -25,13 +25,13 @@  discard block
 block discarded – undo
25 25
 	$output .= '</urlset>';
26 26
 	
27 27
 	
28
-} else if (isset($_GET['type']) && $_GET['type'] == "aircraft"){
28
+} else if (isset($_GET['type']) && $_GET['type'] == "aircraft") {
29 29
 
30 30
 	$output .= '<?xml version="1.0" encoding="UTF-8"?>';
31 31
 	$output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">';
32 32
 		$aircraft_types = $Stats->getAllAircraftTypes();
33 33
 		if (empty($aircraft_types)) $aircraft_types = $Spotter->getAllAircraftTypes();
34
-		foreach($aircraft_types as $aircraft_item)
34
+		foreach ($aircraft_types as $aircraft_item)
35 35
 		{
36 36
 			$output .= '<url>';
37 37
 			    $output .= '<loc>'.'http://'.$_SERVER['HTTP_HOST'].$globalURL.'/aircraft/'.urlencode($aircraft_item['aircraft_icao']).'</loc>';
@@ -42,13 +42,13 @@  discard block
 block discarded – undo
42 42
 	$output .= '</urlset>';
43 43
 	
44 44
 	
45
-} else if (isset($_GET['type']) && $_GET['type'] == "registration"){
45
+} else if (isset($_GET['type']) && $_GET['type'] == "registration") {
46 46
 
47 47
 	$output .= '<?xml version="1.0" encoding="UTF-8"?>';
48 48
 	$output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">';
49 49
 
50 50
 		$aircraft_registrations = $Spotter->getAllAircraftRegistrations();
51
-		foreach($aircraft_registrations as $aircraft_item)
51
+		foreach ($aircraft_registrations as $aircraft_item)
52 52
 		{
53 53
 			$output .= '<url>';
54 54
 			    $output .= '<loc>'.'http://'.$_SERVER['HTTP_HOST'].$globalURL.'/registration/'.urlencode($aircraft_item['registration']).'</loc>';
@@ -58,13 +58,13 @@  discard block
 block discarded – undo
58 58
 		}
59 59
 	$output .= '</urlset>';
60 60
 	
61
-} else if (isset($_GET['type']) && $_GET['type'] == "airline"){
61
+} else if (isset($_GET['type']) && $_GET['type'] == "airline") {
62 62
 
63 63
 	$output .= '<?xml version="1.0" encoding="UTF-8"?>';
64 64
 	$output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">';
65 65
 
66 66
 		$airline_names = $Stats->getAllAirlineNames();
67
-		foreach($airline_names as $airline_item)
67
+		foreach ($airline_names as $airline_item)
68 68
 		{
69 69
 			$output .= '<url>';
70 70
 			    $output .= '<loc>'.'http://'.$_SERVER['HTTP_HOST'].$globalURL.'/airline/'.urlencode($airline_item['airline_icao']).'</loc>';
@@ -74,14 +74,14 @@  discard block
 block discarded – undo
74 74
 		}
75 75
 	$output .= '</urlset>';
76 76
 	
77
-} else if (isset($_GET['type']) && $_GET['type'] == "airport"){
77
+} else if (isset($_GET['type']) && $_GET['type'] == "airport") {
78 78
 
79 79
 	$output .= '<?xml version="1.0" encoding="UTF-8"?>';
80 80
 	$output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">';
81 81
 
82 82
 		$airport_names = $Stats->getAllAirportNames();
83 83
 		if (empty($airport_names)) $airport_names = $Spotter->getAllAirportNames();
84
-		foreach($airport_names as $airport_item)
84
+		foreach ($airport_names as $airport_item)
85 85
 		{
86 86
 			$output .= '<url>';
87 87
 			    $output .= '<loc>'.'http://'.$_SERVER['HTTP_HOST'].$globalURL.'/airport/'.$airport_item['airport_icao'].'</loc>';
@@ -91,14 +91,14 @@  discard block
 block discarded – undo
91 91
 		}
92 92
 	$output .= '</urlset>';
93 93
 	
94
-} else if (isset($_GET['type']) && $_GET['type'] == "manufacturer"){
94
+} else if (isset($_GET['type']) && $_GET['type'] == "manufacturer") {
95 95
 
96 96
 	$output .= '<?xml version="1.0" encoding="UTF-8"?>';
97 97
 	$output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">';
98 98
 
99 99
 		$manufacturer_names = $Stats->getAllManufacturers();
100 100
 		if (empty($manufacturer_names)) $manufacturer_names = $Spotter->getAllManufacturers();
101
-		foreach($manufacturer_names as $manufacturer_item)
101
+		foreach ($manufacturer_names as $manufacturer_item)
102 102
 		{
103 103
 			$output .= '<url>';
104 104
 			    $output .= '<loc>'.'http://'.$_SERVER['HTTP_HOST'].$globalURL.'/manufacturer/'.urlencode(strtolower(str_replace(" ", "-", $manufacturer_item['aircraft_manufacturer']))).'</loc>';
@@ -108,13 +108,13 @@  discard block
 block discarded – undo
108 108
 		}
109 109
 	$output .= '</urlset>';
110 110
 	
111
-} else if (isset($_GET['type']) && $_GET['type'] == "country"){
111
+} else if (isset($_GET['type']) && $_GET['type'] == "country") {
112 112
 
113 113
 	$output .= '<?xml version="1.0" encoding="UTF-8"?>';
114 114
 	$output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">';
115 115
 
116 116
 		$country_names = $Spotter->getAllCountries();
117
-		foreach($country_names as $country_item)
117
+		foreach ($country_names as $country_item)
118 118
 		{
119 119
 			$output .= '<url>';
120 120
 			    $output .= '<loc>'.'http://'.$_SERVER['HTTP_HOST'].$globalURL.'/country/'.urlencode(strtolower(str_replace(" ", "-", $country_item['country']))).'</loc>';
@@ -124,13 +124,13 @@  discard block
 block discarded – undo
124 124
 		}
125 125
 	$output .= '</urlset>';
126 126
 	
127
-} else if (isset($_GET['type']) && $_GET['type'] == "ident"){
127
+} else if (isset($_GET['type']) && $_GET['type'] == "ident") {
128 128
 
129 129
 	$output .= '<?xml version="1.0" encoding="UTF-8"?>';
130 130
 	$output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">';
131 131
 
132 132
 		$ident_names = $Spotter->getAllIdents();
133
-		foreach($ident_names as $ident_item)
133
+		foreach ($ident_names as $ident_item)
134 134
 		{
135 135
 			if (ctype_alnum($ident_item['ident'])) {
136 136
 				$output .= '<url>';
@@ -142,13 +142,13 @@  discard block
 block discarded – undo
142 142
 		}
143 143
 	$output .= '</urlset>';
144 144
 	
145
-} else if (isset($_GET['type']) && $_GET['type'] == "date"){
145
+} else if (isset($_GET['type']) && $_GET['type'] == "date") {
146 146
 
147 147
 	$output .= '<?xml version="1.0" encoding="UTF-8"?>';
148 148
 	$output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">';
149 149
 
150 150
 		$date_names = $Spotter->getAllDates();
151
-		foreach($date_names as $date_item)
151
+		foreach ($date_names as $date_item)
152 152
 		{
153 153
 			$output .= '<url>';
154 154
 			    $output .= '<loc>'.'http://'.$_SERVER['HTTP_HOST'].$globalURL.'/date/'.date("Y-m-d", strtotime($date_item['date'])).'</loc>';
@@ -158,13 +158,13 @@  discard block
 block discarded – undo
158 158
 		}
159 159
 	$output .= '</urlset>';
160 160
 	
161
-} else if (isset($_GET['type']) && $_GET['type'] == "route"){
161
+} else if (isset($_GET['type']) && $_GET['type'] == "route") {
162 162
 
163 163
 	$output .= '<?xml version="1.0" encoding="UTF-8"?>';
164 164
 	$output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">';
165 165
 
166 166
 		$route_names = $Spotter->getAllRoutes();
167
-		foreach($route_names as $route_item)
167
+		foreach ($route_names as $route_item)
168 168
 		{
169 169
 			$output .= '<url>';
170 170
 			    $output .= '<loc>'.'http://'.$_SERVER['HTTP_HOST'].$globalURL.'/route/'.$route_item['airport_departure_icao'].'/'.$route_item['airport_arrival_icao'].'</loc>';
@@ -174,7 +174,7 @@  discard block
 block discarded – undo
174 174
 		}
175 175
 	$output .= '</urlset>';
176 176
 	
177
-} else if (isset($_GET['type']) && $_GET['type'] == "static"){
177
+} else if (isset($_GET['type']) && $_GET['type'] == "static") {
178 178
 
179 179
 	$output .= '<?xml version="1.0" encoding="UTF-8"?>';
180 180
 	$output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">';
Please login to merge, or discard this patch.
require/class.Source.php 1 patch
Spacing   +30 added lines, -30 removed lines patch added patch discarded remove patch
@@ -16,7 +16,7 @@  discard block
 block discarded – undo
16 16
 		try {
17 17
 			$sth = $this->db->prepare($query);
18 18
 			$sth->execute($query_values);
19
-		} catch(PDOException $e) {
19
+		} catch (PDOException $e) {
20 20
 			return "error : ".$e->getMessage();
21 21
 		}
22 22
 		$all = $sth->fetchAll(PDO::FETCH_ASSOC);
@@ -29,20 +29,20 @@  discard block
 block discarded – undo
29 29
 		try {
30 30
 			$sth = $this->db->prepare($query);
31 31
 			$sth->execute($query_values);
32
-		} catch(PDOException $e) {
32
+		} catch (PDOException $e) {
33 33
 			return "error : ".$e->getMessage();
34 34
 		}
35 35
 		$all = $sth->fetchAll(PDO::FETCH_ASSOC);
36 36
 		return $all;
37 37
 	}
38 38
 
39
-	public function getLocationInfobyNameType($name,$type) {
39
+	public function getLocationInfobyNameType($name, $type) {
40 40
 		$query = "SELECT * FROM source_location WHERE name = :name AND type = :type";
41
-		$query_values = array(':name' => $name,':type' => $type);
41
+		$query_values = array(':name' => $name, ':type' => $type);
42 42
 		try {
43 43
 			$sth = $this->db->prepare($query);
44 44
 			$sth->execute($query_values);
45
-		} catch(PDOException $e) {
45
+		} catch (PDOException $e) {
46 46
 			return "error : ".$e->getMessage();
47 47
 		}
48 48
 		$all = $sth->fetchAll(PDO::FETCH_ASSOC);
@@ -55,7 +55,7 @@  discard block
 block discarded – undo
55 55
 		try {
56 56
 			$sth = $this->db->prepare($query);
57 57
 			$sth->execute($query_values);
58
-		} catch(PDOException $e) {
58
+		} catch (PDOException $e) {
59 59
 			return "error : ".$e->getMessage();
60 60
 		}
61 61
 		$all = $sth->fetchAll(PDO::FETCH_ASSOC);
@@ -65,10 +65,10 @@  discard block
 block discarded – undo
65 65
 	public function getLocationInfoByType($type, $coord = array(), $limit = false) {
66 66
 		$query = "SELECT * FROM source_location WHERE type = :type";
67 67
 		if (is_array($coord) && !empty($coord)) {
68
-			$minlong = filter_var($coord[0],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
69
-			$minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
70
-			$maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
71
-			$maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
68
+			$minlong = filter_var($coord[0], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
69
+			$minlat = filter_var($coord[1], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
70
+			$maxlong = filter_var($coord[2], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
71
+			$maxlat = filter_var($coord[3], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
72 72
 			$query .= " AND source_location.latitude BETWEEN ".$minlat." AND ".$maxlat." AND source_location.longitude BETWEEN ".$minlong." AND ".$maxlong." AND source_location.latitude <> 0 AND source_location.longitude <> 0";
73 73
 		}
74 74
 		$query .= " ORDER BY last_seen DESC";
@@ -77,7 +77,7 @@  discard block
 block discarded – undo
77 77
 		try {
78 78
 			$sth = $this->db->prepare($query);
79 79
 			$sth->execute($query_values);
80
-		} catch(PDOException $e) {
80
+		} catch (PDOException $e) {
81 81
 			return "error : ".$e->getMessage();
82 82
 		}
83 83
 		$all = $sth->fetchAll(PDO::FETCH_ASSOC);
@@ -90,7 +90,7 @@  discard block
 block discarded – undo
90 90
 		try {
91 91
 			$sth = $this->db->prepare($query);
92 92
 			$sth->execute($query_values);
93
-		} catch(PDOException $e) {
93
+		} catch (PDOException $e) {
94 94
 			return "error : ".$e->getMessage();
95 95
 		}
96 96
 		$all = $sth->fetchAll(PDO::FETCH_ASSOC);
@@ -103,56 +103,56 @@  discard block
 block discarded – undo
103 103
 		try {
104 104
 			$sth = $this->db->prepare($query);
105 105
 			$sth->execute($query_values);
106
-		} catch(PDOException $e) {
106
+		} catch (PDOException $e) {
107 107
 			return "error : ".$e->getMessage();
108 108
 		}
109 109
 		$all = $sth->fetchAll(PDO::FETCH_ASSOC);
110 110
 		return $all;
111 111
 	}
112 112
 
113
-	public function addLocation($name,$latitude,$longitude,$altitude,$city,$country,$source,$logo = 'antenna.png',$type = '',$source_id = 0,$location_id = 0,$last_seen = '', $description = '') {
113
+	public function addLocation($name, $latitude, $longitude, $altitude, $city, $country, $source, $logo = 'antenna.png', $type = '', $source_id = 0, $location_id = 0, $last_seen = '', $description = '') {
114 114
 		if ($last_seen == '') $last_seen = date('Y-m-d H:i:s');
115 115
 		$query = "INSERT INTO source_location (name,latitude,longitude,altitude,country,city,logo,source,type,source_id,last_seen,location_id,description) VALUES (:name,:latitude,:longitude,:altitude,:country,:city,:logo,:source,:type,:source_id,:last_seen,:location_id,:description)";
116
-		$query_values = array(':name' => $name,':latitude' => $latitude, ':longitude' => $longitude,':altitude' => $altitude,':city' => $city,':country' => $country,':logo' => $logo,':source' => $source,':type' => $type,':source_id' => $source_id,':last_seen' => $last_seen,':location_id' => $location_id,':description' => $description);
116
+		$query_values = array(':name' => $name, ':latitude' => $latitude, ':longitude' => $longitude, ':altitude' => $altitude, ':city' => $city, ':country' => $country, ':logo' => $logo, ':source' => $source, ':type' => $type, ':source_id' => $source_id, ':last_seen' => $last_seen, ':location_id' => $location_id, ':description' => $description);
117 117
 		try {
118 118
 			$sth = $this->db->prepare($query);
119 119
 			$sth->execute($query_values);
120
-		} catch(PDOException $e) {
120
+		} catch (PDOException $e) {
121 121
 			echo "error : ".$e->getMessage();
122 122
 		}
123 123
 	}
124 124
 
125
-	public function updateLocation($name,$latitude,$longitude,$altitude,$city,$country,$source,$logo = 'antenna.png',$type = '',$source_id = 0,$location_id = 0,$last_seen = '',$description = '') {
125
+	public function updateLocation($name, $latitude, $longitude, $altitude, $city, $country, $source, $logo = 'antenna.png', $type = '', $source_id = 0, $location_id = 0, $last_seen = '', $description = '') {
126 126
 		if ($last_seen == '') $last_seen = date('Y-m-d H:i:s');
127 127
 		$query = "UPDATE source_location SET latitude = :latitude,longitude = :longitude,altitude = :altitude,country = :country,city = :city,logo = :logo,type = :type, source_id = :source_id, last_seen = :last_seen,location_id = :location_id, description = :description WHERE name = :name AND source = :source";
128
-		$query_values = array(':name' => $name,':latitude' => $latitude, ':longitude' => $longitude,':altitude' => $altitude,':city' => $city,':country' => $country,':logo' => $logo,':source' => $source,':type' => $type,':source_id' => $source_id,':last_seen' => $last_seen,':location_id' => $location_id,':description' => $description);
128
+		$query_values = array(':name' => $name, ':latitude' => $latitude, ':longitude' => $longitude, ':altitude' => $altitude, ':city' => $city, ':country' => $country, ':logo' => $logo, ':source' => $source, ':type' => $type, ':source_id' => $source_id, ':last_seen' => $last_seen, ':location_id' => $location_id, ':description' => $description);
129 129
 		try {
130 130
 			$sth = $this->db->prepare($query);
131 131
 			$sth->execute($query_values);
132
-		} catch(PDOException $e) {
132
+		} catch (PDOException $e) {
133 133
 			return "error : ".$e->getMessage();
134 134
 		}
135 135
 	}
136 136
 
137
-	public function updateLocationDescByName($name,$source,$source_id = 0,$description = '') {
137
+	public function updateLocationDescByName($name, $source, $source_id = 0, $description = '') {
138 138
 		$query = "UPDATE source_location SET description = :description WHERE source_id = :source_id AND name = :name AND source = :source";
139
-		$query_values = array(':name' => $name,':source' => $source,':source_id' => $source_id,':description' => $description);
139
+		$query_values = array(':name' => $name, ':source' => $source, ':source_id' => $source_id, ':description' => $description);
140 140
 		try {
141 141
 			$sth = $this->db->prepare($query);
142 142
 			$sth->execute($query_values);
143
-		} catch(PDOException $e) {
143
+		} catch (PDOException $e) {
144 144
 			return "error : ".$e->getMessage();
145 145
 		}
146 146
 	}
147 147
 
148
-	public function updateLocationByLocationID($name,$latitude,$longitude,$altitude,$city,$country,$source,$logo = 'antenna.png',$type = '',$source_id = 0, $location_id,$last_seen = '',$description = '') {
148
+	public function updateLocationByLocationID($name, $latitude, $longitude, $altitude, $city, $country, $source, $logo = 'antenna.png', $type = '', $source_id = 0, $location_id, $last_seen = '', $description = '') {
149 149
 		if ($last_seen == '') $last_seen = date('Y-m-d H:i:s');
150 150
 		$query = "UPDATE source_location SET latitude = :latitude,longitude = :longitude,altitude = :altitude,country = :country,city = :city,logo = :logo,type = :type, last_seen = :last_seen, description = :description WHERE location_id = :location_id AND source = :source AND source_id = :source_id";
151
-		$query_values = array(':source_id' => $source_id,':latitude' => $latitude, ':longitude' => $longitude,':altitude' => $altitude,':city' => $city,':country' => $country,':logo' => $logo,':source' => $source,':type' => $type,':last_seen' => $last_seen,':location_id' => $location_id,':description' => $description);
151
+		$query_values = array(':source_id' => $source_id, ':latitude' => $latitude, ':longitude' => $longitude, ':altitude' => $altitude, ':city' => $city, ':country' => $country, ':logo' => $logo, ':source' => $source, ':type' => $type, ':last_seen' => $last_seen, ':location_id' => $location_id, ':description' => $description);
152 152
 		try {
153 153
 			$sth = $this->db->prepare($query);
154 154
 			$sth->execute($query_values);
155
-		} catch(PDOException $e) {
155
+		} catch (PDOException $e) {
156 156
 			echo "error : ".$e->getMessage();
157 157
 		}
158 158
 	}
@@ -163,7 +163,7 @@  discard block
 block discarded – undo
163 163
 		try {
164 164
 			$sth = $this->db->prepare($query);
165 165
 			$sth->execute($query_values);
166
-		} catch(PDOException $e) {
166
+		} catch (PDOException $e) {
167 167
 			return "error : ".$e->getMessage();
168 168
 		}
169 169
 	}
@@ -174,7 +174,7 @@  discard block
 block discarded – undo
174 174
 		try {
175 175
 			$sth = $this->db->prepare($query);
176 176
 			$sth->execute($query_values);
177
-		} catch(PDOException $e) {
177
+		} catch (PDOException $e) {
178 178
 			return "error : ".$e->getMessage();
179 179
 		}
180 180
 	}
@@ -185,7 +185,7 @@  discard block
 block discarded – undo
185 185
 		try {
186 186
 			$sth = $this->db->prepare($query);
187 187
 			$sth->execute($query_values);
188
-		} catch(PDOException $e) {
188
+		} catch (PDOException $e) {
189 189
 			return "error : ".$e->getMessage();
190 190
 		}
191 191
 	}
@@ -195,7 +195,7 @@  discard block
 block discarded – undo
195 195
 		try {
196 196
 			$sth = $this->db->prepare($query);
197 197
 			$sth->execute();
198
-		} catch(PDOException $e) {
198
+		} catch (PDOException $e) {
199 199
 			return "error : ".$e->getMessage();
200 200
 		}
201 201
 	}
@@ -224,7 +224,7 @@  discard block
 block discarded – undo
224 224
 		try {
225 225
 			$sth = $this->db->prepare($query);
226 226
 			$sth->execute(array(':type' => $type));
227
-		} catch(PDOException $e) {
227
+		} catch (PDOException $e) {
228 228
 			return "error";
229 229
 		}
230 230
 		return "success";
Please login to merge, or discard this patch.
live-czml.php 1 patch
Spacing   +53 added lines, -53 removed lines patch added patch discarded remove patch
@@ -48,11 +48,11 @@  discard block
 block discarded – undo
48 48
     $s3 = sin($bank/2);
49 49
     $c1c2 = $c1*$c2;
50 50
     $s1s2 = $s1*$s2;
51
-    $w =$c1c2*$c3 - $s1s2*$s3;
52
-    $x =$c1c2*$s3 + $s1s2*$c3;
53
-    $y =$s1*$c2*$c3 + $c1*$s2*$s3;
54
-    $z =$c1*$s2*$c3 - $s1*$c2*$s3;
55
-    return array('x' => $x,'y' => $y,'z' => $z,'w' => $w);
51
+    $w = $c1c2*$c3 - $s1s2*$s3;
52
+    $x = $c1c2*$s3 + $s1s2*$c3;
53
+    $y = $s1*$c2*$c3 + $c1*$s2*$s3;
54
+    $z = $c1*$s2*$c3 - $s1*$c2*$s3;
55
+    return array('x' => $x, 'y' => $y, 'z' => $z, 'w' => $w);
56 56
 //    return array('x' => '0.0','y' => '-0.931','z' => '0.0','w' => '0.365');
57 57
 
58 58
 }
@@ -73,16 +73,16 @@  discard block
 block discarded – undo
73 73
 $min = false;
74 74
 $allhistory = false;
75 75
 $filter['source'] = array();
76
-if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalVATSIM) && $globalVATSIM && isset($_COOKIE['filter_ShowVATSIM']) && $_COOKIE['filter_ShowVATSIM'] == 'true') $filter['source'] = array_merge($filter['source'],array('vatsimtxt'));
77
-if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalIVAO) && $globalIVAO && isset($_COOKIE['filter_ShowIVAO']) && $_COOKIE['filter_ShowIVAO'] == 'true') $filter['source'] = array_merge($filter['source'],array('whazzup'));
78
-if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalphpVMS) && $globalphpVMS && isset($_COOKIE['filter_ShowVMS']) && $_COOKIE['filter_ShowVMS'] == 'true') $filter['source'] = array_merge($filter['source'],array('phpvmacars'));
79
-if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalSBS1) && $globalSBS1 && isset($_COOKIE['filter_ShowSBS1']) && $_COOKIE['filter_ShowSBS1'] == 'true') $filter['source'] = array_merge($filter['source'],array('sbs','famaprs'));
80
-if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalAPRS) && $globalAPRS && isset($_COOKIE['filter_ShowAPRS']) && $_COOKIE['filter_ShowAPRS'] == 'true') $filter['source'] = array_merge($filter['source'],array('aprs'));
81
-if (isset($_COOKIE['filter_ident']) && $_COOKIE['filter_ident'] != '') $filter['ident'] = filter_var($_COOKIE['filter_ident'],FILTER_SANITIZE_STRING);
82
-if (isset($_COOKIE['filter_Airlines']) && $_COOKIE['filter_Airlines'] != '') $filter['airlines'] = filter_var_array(explode(',',$_COOKIE['filter_Airlines']),FILTER_SANITIZE_STRING);
83
-if (isset($_COOKIE['filter_Sources']) && $_COOKIE['filter_Sources'] != '') $filter['source_aprs'] = filter_var_array(explode(',',$_COOKIE['filter_Sources']),FILTER_SANITIZE_STRING);
84
-if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] != 'all') $filter['airlinestype'] = filter_var($_COOKIE['filter_airlinestype'],FILTER_SANITIZE_STRING);
85
-if (isset($_COOKIE['filter_alliance']) && $_COOKIE['filter_alliance'] != 'all') $filter['alliance'] = filter_var($_COOKIE['filter_alliance'],FILTER_SANITIZE_STRING);
76
+if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalVATSIM) && $globalVATSIM && isset($_COOKIE['filter_ShowVATSIM']) && $_COOKIE['filter_ShowVATSIM'] == 'true') $filter['source'] = array_merge($filter['source'], array('vatsimtxt'));
77
+if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalIVAO) && $globalIVAO && isset($_COOKIE['filter_ShowIVAO']) && $_COOKIE['filter_ShowIVAO'] == 'true') $filter['source'] = array_merge($filter['source'], array('whazzup'));
78
+if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalphpVMS) && $globalphpVMS && isset($_COOKIE['filter_ShowVMS']) && $_COOKIE['filter_ShowVMS'] == 'true') $filter['source'] = array_merge($filter['source'], array('phpvmacars'));
79
+if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalSBS1) && $globalSBS1 && isset($_COOKIE['filter_ShowSBS1']) && $_COOKIE['filter_ShowSBS1'] == 'true') $filter['source'] = array_merge($filter['source'], array('sbs', 'famaprs'));
80
+if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalAPRS) && $globalAPRS && isset($_COOKIE['filter_ShowAPRS']) && $_COOKIE['filter_ShowAPRS'] == 'true') $filter['source'] = array_merge($filter['source'], array('aprs'));
81
+if (isset($_COOKIE['filter_ident']) && $_COOKIE['filter_ident'] != '') $filter['ident'] = filter_var($_COOKIE['filter_ident'], FILTER_SANITIZE_STRING);
82
+if (isset($_COOKIE['filter_Airlines']) && $_COOKIE['filter_Airlines'] != '') $filter['airlines'] = filter_var_array(explode(',', $_COOKIE['filter_Airlines']), FILTER_SANITIZE_STRING);
83
+if (isset($_COOKIE['filter_Sources']) && $_COOKIE['filter_Sources'] != '') $filter['source_aprs'] = filter_var_array(explode(',', $_COOKIE['filter_Sources']), FILTER_SANITIZE_STRING);
84
+if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] != 'all') $filter['airlinestype'] = filter_var($_COOKIE['filter_airlinestype'], FILTER_SANITIZE_STRING);
85
+if (isset($_COOKIE['filter_alliance']) && $_COOKIE['filter_alliance'] != 'all') $filter['alliance'] = filter_var($_COOKIE['filter_alliance'], FILTER_SANITIZE_STRING);
86 86
 /*
87 87
 if (isset($globalMapPopup) && !$globalMapPopup && !(isset($_COOKIE['flightpopup']) && $_COOKIE['flightpopup'] == 'true')) {
88 88
 	$min = true;
@@ -129,12 +129,12 @@  discard block
 block discarded – undo
129 129
 	$from_archive = true;
130 130
 //	$begindate = filter_input(INPUT_GET,'begindate',FILTER_VALIDATE_REGEXP,array("options"=>array("regexp"=>'~^\d{4}/\d{2}/\d{2}$~')));
131 131
 //	$enddate = filter_input(INPUT_GET,'enddate',FILTER_VALIDATE_REGEXP,array("options"=>array("regexp"=>'~^\d{4}/\d{2}/\d{2}$~')));
132
-	$begindate = filter_input(INPUT_GET,'begindate',FILTER_SANITIZE_NUMBER_INT);
133
-	$enddate = filter_input(INPUT_GET,'enddate',FILTER_SANITIZE_NUMBER_INT);
134
-	$archivespeed = filter_input(INPUT_GET,'speed',FILTER_SANITIZE_NUMBER_INT);
135
-	$begindate = date('Y-m-d H:i:s',$begindate);
136
-	$enddate = date('Y-m-d H:i:s',$enddate);
137
-	$spotter_array = $SpotterArchive->getMinLiveSpotterDataPlayback($begindate,$enddate,$filter);
132
+	$begindate = filter_input(INPUT_GET, 'begindate', FILTER_SANITIZE_NUMBER_INT);
133
+	$enddate = filter_input(INPUT_GET, 'enddate', FILTER_SANITIZE_NUMBER_INT);
134
+	$archivespeed = filter_input(INPUT_GET, 'speed', FILTER_SANITIZE_NUMBER_INT);
135
+	$begindate = date('Y-m-d H:i:s', $begindate);
136
+	$enddate = date('Y-m-d H:i:s', $enddate);
137
+	$spotter_array = $SpotterArchive->getMinLiveSpotterDataPlayback($begindate, $enddate, $filter);
138 138
 } elseif (isset($_COOKIE['archive']) && isset($_COOKIE['archive_begin']) && isset($_COOKIE['archive_end']) && isset($_COOKIE['archive_speed'])) {
139 139
 	$from_archive = true;
140 140
 //	$begindate = filter_input(INPUT_GET,'begindate',FILTER_VALIDATE_REGEXP,array("options"=>array("regexp"=>'~^\d{4}/\d{2}/\d{2}$~')));
@@ -144,34 +144,34 @@  discard block
 block discarded – undo
144 144
 	$begindate = $_COOKIE['archive_begin'];
145 145
 	$enddate = $_COOKIE['archive_end'];
146 146
 
147
-	$archivespeed = filter_var($_COOKIE['archive_speed'],FILTER_SANITIZE_NUMBER_INT);
148
-	$begindate = date('Y-m-d H:i:s',$begindate);
149
-	$enddate = date('Y-m-d H:i:s',$enddate);
147
+	$archivespeed = filter_var($_COOKIE['archive_speed'], FILTER_SANITIZE_NUMBER_INT);
148
+	$begindate = date('Y-m-d H:i:s', $begindate);
149
+	$enddate = date('Y-m-d H:i:s', $enddate);
150 150
 //	echo 'Begin : '.$begindate.' - End : '.$enddate."\n";
151
-	$spotter_array = $SpotterArchive->getMinLiveSpotterData($begindate,$enddate,$filter);
151
+	$spotter_array = $SpotterArchive->getMinLiveSpotterData($begindate, $enddate, $filter);
152 152
 } elseif ($tracker) {
153 153
 	$coord = array();
154 154
 	if (isset($_GET['coord']) && $_GET['coord'] != '') {
155
-		$coord = explode(',',$_GET['coord']);
155
+		$coord = explode(',', $_GET['coord']);
156 156
 	}
157
-	$spotter_array = $TrackerLive->getMinLastLiveTrackerData($coord,$filter,true);
157
+	$spotter_array = $TrackerLive->getMinLastLiveTrackerData($coord, $filter, true);
158 158
 } elseif ($marine) {
159 159
 	$coord = array();
160 160
 	if (isset($_GET['coord']) && $_GET['coord'] != '') {
161
-		$coord = explode(',',$_GET['coord']);
161
+		$coord = explode(',', $_GET['coord']);
162 162
 	}
163
-	$spotter_array = $MarineLive->getMinLastLiveMarineData($coord,$filter,true);
163
+	$spotter_array = $MarineLive->getMinLastLiveMarineData($coord, $filter, true);
164 164
 } else {
165 165
 	$coord = array();
166 166
 	if (isset($_GET['coord']) && $_GET['coord'] != '') {
167
-		$coord = explode(',',$_GET['coord']);
167
+		$coord = explode(',', $_GET['coord']);
168 168
 	}
169
-	$spotter_array = $SpotterLive->getMinLastLiveSpotterData($coord,$filter,true);
169
+	$spotter_array = $SpotterLive->getMinLastLiveSpotterData($coord, $filter, true);
170 170
 }
171 171
 //print_r($spotter_array);
172 172
 if (!empty($spotter_array) && isset($coord)) {
173 173
 	if (isset($_GET['archive'])) {
174
-		$flightcnt = $SpotterArchive->getLiveSpotterCount($begindate,$enddate,$filter);
174
+		$flightcnt = $SpotterArchive->getLiveSpotterCount($begindate, $enddate, $filter);
175 175
 	} elseif ($tracker) {
176 176
 		$flightcnt = $TrackerLive->getLiveTrackerCount($filter);
177 177
 	} elseif ($marine) {
@@ -182,15 +182,15 @@  discard block
 block discarded – undo
182 182
 	if ($flightcnt == '') $flightcnt = 0;
183 183
 } else $flightcnt = 0;
184 184
 
185
-$sqltime = round(microtime(true)-$begintime,2);
185
+$sqltime = round(microtime(true) - $begintime, 2);
186 186
 $minitime = time();
187 187
 $maxitime = 0;
188
-$lastupdate = filter_input(INPUT_GET,'update',FILTER_SANITIZE_NUMBER_INT);
188
+$lastupdate = filter_input(INPUT_GET, 'update', FILTER_SANITIZE_NUMBER_INT);
189 189
 $modelsdb = array();
190 190
 if (file_exists(dirname(__FILE__).'/models/modelsdb')) {
191
-	if (($handle = fopen(dirname(__FILE__).'/models/modelsdb','r')) !== FALSE) {
192
-		while (($row = fgetcsv($handle,1000)) !== FALSE) {
193
-			if (isset($row[1]) ){
191
+	if (($handle = fopen(dirname(__FILE__).'/models/modelsdb', 'r')) !== FALSE) {
192
+		while (($row = fgetcsv($handle, 1000)) !== FALSE) {
193
+			if (isset($row[1])) {
194 194
 				$model = $row[0];
195 195
 				$modelsdb[$model] = $row[1];
196 196
 			}
@@ -227,7 +227,7 @@  discard block
 block discarded – undo
227 227
 if (!empty($spotter_array) && is_array($spotter_array))
228 228
 {
229 229
 	$nblatlong = 0;
230
-	foreach($spotter_array as $spotter_item)
230
+	foreach ($spotter_array as $spotter_item)
231 231
 	{
232 232
 		$j++;
233 233
 		//if (isset($spotter_item['format_source']) && $spotter_item['format_source'] == 'airwhere') $heightrelative = 'RELATIVE_TO_GROUND';
@@ -267,11 +267,11 @@  discard block
 block discarded – undo
267 267
 			$output .= '"lastupdate": "'.$lastupdate.'",';
268 268
 			$output .= '"format": "'.$spotter_item['format_source'].'",';
269 269
 			if ($tracker) {
270
-				$output.= '"type": "tracker"';
270
+				$output .= '"type": "tracker"';
271 271
 			} elseif ($marine) {
272
-				$output.= '"type": "marine"';
272
+				$output .= '"type": "marine"';
273 273
 			} else {
274
-				$output.= '"type": "flight"';
274
+				$output .= '"type": "flight"';
275 275
 			}
276 276
 			$output .= '},';
277 277
 
@@ -615,8 +615,8 @@  discard block
 block discarded – undo
615 615
 					$output .= '},';
616 616
 				}
617 617
 			}
618
-			if (isset($onground) && $onground) $output = str_replace('%onground%','true',$output);
619
-			else $output = str_replace('%onground%','false',$output);
618
+			if (isset($onground) && $onground) $output = str_replace('%onground%', 'true', $output);
619
+			else $output = str_replace('%onground%', 'false', $output);
620 620
 
621 621
 	//		$output .= '"heightReference": "CLAMP_TO_GROUND",';
622 622
 			//$output .= '"heightReference": "'.$heightrelative.'",';
@@ -631,7 +631,7 @@  discard block
 block discarded – undo
631 631
 			$output .= '"cartographicDegrees": [';
632 632
 			if ($minitime > strtotime($spotter_item['date'])) $minitime = strtotime($spotter_item['date']);
633 633
 			if ($maxitime < strtotime($spotter_item['date'])) $maxitime = strtotime($spotter_item['date']);
634
-			$output .= '"'.date("c",strtotime($spotter_item['date'])).'", ';
634
+			$output .= '"'.date("c", strtotime($spotter_item['date'])).'", ';
635 635
 			$output .= $spotter_item['longitude'].', ';
636 636
 			$output .= $spotter_item['latitude'];
637 637
 			$prevlong = $spotter_item['longitude'];
@@ -659,8 +659,8 @@  discard block
 block discarded – undo
659 659
 			//$quat = quaternionrotate(deg2rad($spotter_item['heading']),deg2rad(0),deg2rad(0));
660 660
 			//$orientation .= '"'.date("c",strtotime($spotter_item['date'])).'",'.$quat['x'].','.$quat['y'].','.$quat['z'].','.$quat['w'];
661 661
 		} else {
662
-			$nblatlong = $nblatlong+1;
663
-			$output .= ',"'.date("c",strtotime($spotter_item['date'])).'", ';
662
+			$nblatlong = $nblatlong + 1;
663
+			$output .= ',"'.date("c", strtotime($spotter_item['date'])).'", ';
664 664
 			if ($maxitime < strtotime($spotter_item['date'])) $maxitime = strtotime($spotter_item['date']);
665 665
 			if ($spotter_item['ground_speed'] == 0) {
666 666
 				$output .= $prevlong.', ';
@@ -700,15 +700,15 @@  discard block
 block discarded – undo
700 700
 }
701 701
 $output .= ']';
702 702
 if (isset($globalArchive) && $globalArchive === TRUE) {
703
-	if ((time()-$globalLiveInterval) > $minitime) {
704
-		if (time()-$globalLiveInterval > $maxitime) {
705
-			$output = str_replace('%minitime%',date("c",$maxitime),$output);
703
+	if ((time() - $globalLiveInterval) > $minitime) {
704
+		if (time() - $globalLiveInterval > $maxitime) {
705
+			$output = str_replace('%minitime%', date("c", $maxitime), $output);
706 706
 		} else {
707
-			$output = str_replace('%minitime%',date("c",time()-$globalLiveInterval),$output);
707
+			$output = str_replace('%minitime%', date("c", time() - $globalLiveInterval), $output);
708 708
 		}
709 709
 	}
710
-	else $output = str_replace('%minitime%',date("c",$minitime),$output);
711
-} else $output = str_replace('%minitime%',date("c",$minitime),$output);
712
-$output = str_replace('%maxitime%',date("c",$maxitime),$output);
710
+	else $output = str_replace('%minitime%', date("c", $minitime), $output);
711
+} else $output = str_replace('%minitime%', date("c", $minitime), $output);
712
+$output = str_replace('%maxitime%', date("c", $maxitime), $output);
713 713
 print $output;
714 714
 ?>
Please login to merge, or discard this patch.