Completed
Push — master ( 8c94fe...9091ef )
by Yannick
34:02 queued 02:35
created
require/class.Marine.php 1 patch
Braces   +173 added lines, -62 removed lines patch added patch discarded remove patch
@@ -8,7 +8,9 @@  discard block
 block discarded – undo
8 8
 	public function __construct($dbc = null) {
9 9
 		$Connection = new Connection($dbc);
10 10
 		$this->db = $Connection->db();
11
-		if ($this->db === null) die('Error: No DB connection.');
11
+		if ($this->db === null) {
12
+			die('Error: No DB connection.');
13
+		}
12 14
 	}
13 15
 
14 16
 	/**
@@ -30,7 +32,9 @@  discard block
 block discarded – undo
30 32
 		if (isset($filter[0]['source'])) {
31 33
 			$filters = array_merge($filters,$filter);
32 34
 		}
33
-		if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter);
35
+		if (is_array($globalFilter)) {
36
+			$filter = array_merge($filter,$globalFilter);
37
+		}
34 38
 		$filter_query_join = '';
35 39
 		$filter_query_where = '';
36 40
 		foreach($filters as $flt) {
@@ -69,8 +73,11 @@  discard block
 block discarded – undo
69 73
 				$filter_query_where .= " AND EXTRACT(DAY FROM marine_output.date) = '".$filter['day']."'";
70 74
 			}
71 75
 		}
72
-		if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE';
73
-		elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND';
76
+		if ($filter_query_where == '' && $where) {
77
+			$filter_query_where = ' WHERE';
78
+		} elseif ($filter_query_where != '' && $and) {
79
+			$filter_query_where .= ' AND';
80
+		}
74 81
 		if ($filter_query_where != '') {
75 82
 			$filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where);
76 83
 		}
@@ -124,32 +131,54 @@  discard block
 block discarded – undo
124 131
 				$temp_array['spotter_id'] = $row['spotter_archive_id'];
125 132
 			} elseif (isset($row['spotter_archive_output_id'])) {
126 133
 				$temp_array['spotter_id'] = $row['spotter_archive_output_id'];
127
-			*/} 
128
-			elseif (isset($row['marineid'])) {
134
+			*/} elseif (isset($row['marineid'])) {
129 135
 				$temp_array['marine_id'] = $row['marineid'];
130 136
 			} else {
131 137
 				$temp_array['marine_id'] = '';
132 138
 			}
133
-			if (isset($row['fammarine_id'])) $temp_array['fammarine_id'] = $row['fammarine_id'];
134
-			if (isset($row['mmsi'])) $temp_array['mmsi'] = $row['mmsi'];
135
-			if (isset($row['type'])) $temp_array['type'] = $row['type'];
136
-			if (isset($row['type_id'])) $temp_array['type_id'] = $row['type_id'];
137
-			if (isset($row['ident'])) $temp_array['ident'] = $row['ident'];
138
-			if (isset($row['latitude'])) $temp_array['latitude'] = $row['latitude'];
139
-			if (isset($row['longitude'])) $temp_array['longitude'] = $row['longitude'];
140
-			if (isset($row['format_source'])) $temp_array['format_source'] = $row['format_source'];
139
+			if (isset($row['fammarine_id'])) {
140
+				$temp_array['fammarine_id'] = $row['fammarine_id'];
141
+			}
142
+			if (isset($row['mmsi'])) {
143
+				$temp_array['mmsi'] = $row['mmsi'];
144
+			}
145
+			if (isset($row['type'])) {
146
+				$temp_array['type'] = $row['type'];
147
+			}
148
+			if (isset($row['type_id'])) {
149
+				$temp_array['type_id'] = $row['type_id'];
150
+			}
151
+			if (isset($row['ident'])) {
152
+				$temp_array['ident'] = $row['ident'];
153
+			}
154
+			if (isset($row['latitude'])) {
155
+				$temp_array['latitude'] = $row['latitude'];
156
+			}
157
+			if (isset($row['longitude'])) {
158
+				$temp_array['longitude'] = $row['longitude'];
159
+			}
160
+			if (isset($row['format_source'])) {
161
+				$temp_array['format_source'] = $row['format_source'];
162
+			}
141 163
 			if (isset($row['heading'])) {
142 164
 				$temp_array['heading'] = $row['heading'];
143 165
 				$heading_direction = $this->parseDirection($row['heading']);
144
-				if (isset($heading_direction[0]['direction_fullname'])) $temp_array['heading_name'] = $heading_direction[0]['direction_fullname'];
166
+				if (isset($heading_direction[0]['direction_fullname'])) {
167
+					$temp_array['heading_name'] = $heading_direction[0]['direction_fullname'];
168
+				}
169
+			}
170
+			if (isset($row['ground_speed'])) {
171
+				$temp_array['ground_speed'] = $row['ground_speed'];
145 172
 			}
146
-			if (isset($row['ground_speed'])) $temp_array['ground_speed'] = $row['ground_speed'];
147 173
 
148 174
 			if($temp_array['mmsi'] != "")
149 175
 			{
150 176
 				$Image = new Image($this->db);
151
-				if (isset($temp_array['ident']) && $temp_array['ident'] != '') $image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']);
152
-				else $image_array = $Image->getMarineImage($temp_array['mmsi']);
177
+				if (isset($temp_array['ident']) && $temp_array['ident'] != '') {
178
+					$image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']);
179
+				} else {
180
+					$image_array = $Image->getMarineImage($temp_array['mmsi']);
181
+				}
153 182
 				unset($Image);
154 183
 				if (count($image_array) > 0) {
155 184
 					$temp_array['image'] = $image_array[0]['image'];
@@ -201,13 +230,21 @@  discard block
 block discarded – undo
201 230
 			}
202 231
 			
203 232
 			$fromsource = NULL;
204
-			if (isset($row['source_name']) && $row['source_name'] != '') $temp_array['source_name'] = $row['source_name'];
205
-			if (isset($row['over_country']) && $row['over_country'] != '') $temp_array['over_country'] = $row['over_country'];
206
-			if (isset($row['distance']) && $row['distance'] != '') $temp_array['distance'] = $row['distance'];
233
+			if (isset($row['source_name']) && $row['source_name'] != '') {
234
+				$temp_array['source_name'] = $row['source_name'];
235
+			}
236
+			if (isset($row['over_country']) && $row['over_country'] != '') {
237
+				$temp_array['over_country'] = $row['over_country'];
238
+			}
239
+			if (isset($row['distance']) && $row['distance'] != '') {
240
+				$temp_array['distance'] = $row['distance'];
241
+			}
207 242
 			$temp_array['query_number_rows'] = $num_rows;
208 243
 			$spotter_array[] = $temp_array;
209 244
 		}
210
-		if ($num_rows == 0) return array();
245
+		if ($num_rows == 0) {
246
+			return array();
247
+		}
211 248
 		$spotter_array[0]['query_number_rows'] = $num_rows;
212 249
 		return $spotter_array;
213 250
 	}	
@@ -233,8 +270,12 @@  discard block
 block discarded – undo
233 270
 			{
234 271
 				//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1];
235 272
 				$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0];
236
-			} else $limit_query = "";
237
-		} else $limit_query = "";
273
+			} else {
274
+				$limit_query = "";
275
+			}
276
+		} else {
277
+			$limit_query = "";
278
+		}
238 279
 		if ($sort != "")
239 280
 		{
240 281
 			$search_orderby_array = $this->getOrderBy();
@@ -258,7 +299,9 @@  discard block
 block discarded – undo
258 299
 		global $global_query;
259 300
 		
260 301
 		date_default_timezone_set('UTC');
261
-		if ($id == '') return array();
302
+		if ($id == '') {
303
+			return array();
304
+		}
262 305
 		$additional_query = "marine_output.fammarine_id = :id";
263 306
 		$query_values = array(':id' => $id);
264 307
 		$query  = $global_query." WHERE ".$additional_query." ";
@@ -401,8 +444,11 @@  discard block
 block discarded – undo
401 444
 		$query .= " ORDER BY marine_output.source_name ASC";
402 445
 
403 446
 		$sth = $this->db->prepare($query);
404
-		if (!empty($query_values)) $sth->execute($query_values);
405
-		else $sth->execute();
447
+		if (!empty($query_values)) {
448
+			$sth->execute($query_values);
449
+		} else {
450
+			$sth->execute();
451
+		}
406 452
 
407 453
 		$source_array = array();
408 454
 		$temp_array = array();
@@ -457,8 +503,11 @@  discard block
 block discarded – undo
457 503
 		$sth = $this->db->prepare($query);
458 504
 		$sth->execute(array(':mmsi' => $mmsi));
459 505
 		$result = $sth->fetchAll(PDO::FETCH_ASSOC);
460
-		if (isset($result[0])) return $result[0];
461
-		else return array();
506
+		if (isset($result[0])) {
507
+			return $result[0];
508
+		} else {
509
+			return array();
510
+		}
462 511
 	}
463 512
 
464 513
 	/*
@@ -474,7 +523,9 @@  discard block
 block discarded – undo
474 523
 			date_default_timezone_set($globalTimezone);
475 524
 			$datetime = new DateTime();
476 525
 			$offset = $datetime->format('P');
477
-		} else $offset = '+00:00';
526
+		} else {
527
+			$offset = '+00:00';
528
+		}
478 529
 
479 530
 		if ($globalDBdriver == 'mysql') {
480 531
 			$query  = "SELECT DISTINCT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) as date
@@ -704,9 +755,15 @@  discard block
 block discarded – undo
704 755
             		$latitude = 0;
705 756
             		$longitude = 0;
706 757
             	}
707
-                if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0;
708
-                if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0;
709
-                if ($arrival_date == '') $arrival_date = NULL;
758
+                if ($heading == '' || $Common->isInteger($heading) === false) {
759
+                	$heading = 0;
760
+                }
761
+                if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) {
762
+                	$groundspeed = 0;
763
+                }
764
+                if ($arrival_date == '') {
765
+                	$arrival_date = NULL;
766
+                }
710 767
 		$query  = "INSERT INTO marine_output (fammarine_id, ident, latitude, longitude, heading, ground_speed, date, format_source, source_name, mmsi, type, status,imo,arrival_port_name,arrival_port_date) 
711 768
 		    VALUES (:fammarine_id,:ident,:latitude,:longitude,:heading,:speed,:date,:format_source, :source_name,:mmsi,:type,:status,:imo,:arrival_port_name,:arrival_port_date)";
712 769
 
@@ -814,7 +871,9 @@  discard block
 block discarded – undo
814 871
 		global $globalDBdriver, $globalArchive;
815 872
 		//$filter_query = $this->getFilter($filters,true,true);
816 873
 		$Connection= new Connection($this->db);
817
-		if (!$Connection->tableExists('countries')) return array();
874
+		if (!$Connection->tableExists('countries')) {
875
+			return array();
876
+		}
818 877
 		require_once('class.SpotterLive.php');
819 878
 		if (!isset($globalArchive) || $globalArchive !== TRUE) {
820 879
 			$MarineLive = new MarineLive($this->db);
@@ -858,7 +917,9 @@  discard block
 block discarded – undo
858 917
 			$query = "SELECT c.name, c.iso3, c.iso2, count(c.name) as nb FROM countries c INNER JOIN (SELECT DISTINCT fammarine_id,over_country FROM marine_archive".$filter_query.") l ON c.iso2 = l.over_country ";
859 918
 		}
860 919
 		$query .= "GROUP BY c.name,c.iso3,c.iso2 ORDER BY nb DESC";
861
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
920
+		if ($limit) {
921
+			$query .= " LIMIT 10 OFFSET 0";
922
+		}
862 923
 
863 924
 		$sth = $this->db->prepare($query);
864 925
 		$sth->execute();
@@ -892,12 +953,18 @@  discard block
 block discarded – undo
892 953
 		$query  = "SELECT DISTINCT marine_output.ident, COUNT(marine_output.ident) AS callsign_icao_count 
893 954
                     FROM marine_output".$filter_query." marine_output.ident <> ''";
894 955
 		 if ($olderthanmonths > 0) {
895
-			if ($globalDBdriver == 'mysql') $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)';
896
-			else $query .= " AND marine_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'";
956
+			if ($globalDBdriver == 'mysql') {
957
+				$query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)';
958
+			} else {
959
+				$query .= " AND marine_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'";
960
+			}
897 961
 		}
898 962
 		if ($sincedate != '') {
899
-			if ($globalDBdriver == 'mysql') $query .= " AND marine_output.date > '".$sincedate."'";
900
-			else $query .= " AND marine_output.date > CAST('".$sincedate."' AS TIMESTAMP)";
963
+			if ($globalDBdriver == 'mysql') {
964
+				$query .= " AND marine_output.date > '".$sincedate."'";
965
+			} else {
966
+				$query .= " AND marine_output.date > CAST('".$sincedate."' AS TIMESTAMP)";
967
+			}
901 968
 		}
902 969
 		$query_values = array();
903 970
 		if ($year != '') {
@@ -928,7 +995,9 @@  discard block
 block discarded – undo
928 995
 			}
929 996
 		}
930 997
 		$query .= " GROUP BY marine_output.ident ORDER BY callsign_icao_count DESC";
931
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
998
+		if ($limit) {
999
+			$query .= " LIMIT 10 OFFSET 0";
1000
+		}
932 1001
       		
933 1002
 		$sth = $this->db->prepare($query);
934 1003
 		$sth->execute($query_values);
@@ -963,7 +1032,9 @@  discard block
 block discarded – undo
963 1032
 			date_default_timezone_set($globalTimezone);
964 1033
 			$datetime = new DateTime();
965 1034
 			$offset = $datetime->format('P');
966
-		} else $offset = '+00:00';
1035
+		} else {
1036
+			$offset = '+00:00';
1037
+		}
967 1038
 
968 1039
 		if ($globalDBdriver == 'mysql') {
969 1040
 			$query  = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1013,7 +1084,9 @@  discard block
 block discarded – undo
1013 1084
 			date_default_timezone_set($globalTimezone);
1014 1085
 			$datetime = new DateTime();
1015 1086
 			$offset = $datetime->format('P');
1016
-		} else $offset = '+00:00';
1087
+		} else {
1088
+			$offset = '+00:00';
1089
+		}
1017 1090
 		$filter_query = $this->getFilter($filters,true,true);
1018 1091
 		if ($globalDBdriver == 'mysql') {
1019 1092
 			$query  = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1059,7 +1132,9 @@  discard block
 block discarded – undo
1059 1132
 			date_default_timezone_set($globalTimezone);
1060 1133
 			$datetime = new DateTime();
1061 1134
 			$offset = $datetime->format('P');
1062
-		} else $offset = '+00:00';
1135
+		} else {
1136
+			$offset = '+00:00';
1137
+		}
1063 1138
 		$filter_query = $this->getFilter($filters,true,true);
1064 1139
 		if ($globalDBdriver == 'mysql') {
1065 1140
 			$query  = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1107,7 +1182,9 @@  discard block
 block discarded – undo
1107 1182
 			date_default_timezone_set($globalTimezone);
1108 1183
 			$datetime = new DateTime();
1109 1184
 			$offset = $datetime->format('P');
1110
-		} else $offset = '+00:00';
1185
+		} else {
1186
+			$offset = '+00:00';
1187
+		}
1111 1188
 
1112 1189
 		if ($globalDBdriver == 'mysql') {
1113 1190
 			$query  = "SELECT YEAR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS year_name,MONTH(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS month_name, count(*) as date_count
@@ -1156,7 +1233,9 @@  discard block
 block discarded – undo
1156 1233
 			date_default_timezone_set($globalTimezone);
1157 1234
 			$datetime = new DateTime();
1158 1235
 			$offset = $datetime->format('P');
1159
-		} else $offset = '+00:00';
1236
+		} else {
1237
+			$offset = '+00:00';
1238
+		}
1160 1239
 		$filter_query = $this->getFilter($filters,true,true);
1161 1240
 		if ($globalDBdriver == 'mysql') {
1162 1241
 			$query  = "SELECT MONTH(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS month_name, YEAR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS year_name, count(*) as date_count
@@ -1205,7 +1284,9 @@  discard block
 block discarded – undo
1205 1284
 			date_default_timezone_set($globalTimezone);
1206 1285
 			$datetime = new DateTime();
1207 1286
 			$offset = $datetime->format('P');
1208
-		} else $offset = '+00:00';
1287
+		} else {
1288
+			$offset = '+00:00';
1289
+		}
1209 1290
 
1210 1291
 		$orderby_sql = '';
1211 1292
 		if ($orderby == "hour")
@@ -1274,7 +1355,9 @@  discard block
 block discarded – undo
1274 1355
 			date_default_timezone_set($globalTimezone);
1275 1356
 			$datetime = new DateTime($date);
1276 1357
 			$offset = $datetime->format('P');
1277
-		} else $offset = '+00:00';
1358
+		} else {
1359
+			$offset = '+00:00';
1360
+		}
1278 1361
 
1279 1362
 		if ($globalDBdriver == 'mysql') {
1280 1363
 			$query  = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1322,7 +1405,9 @@  discard block
 block discarded – undo
1322 1405
 			date_default_timezone_set($globalTimezone);
1323 1406
 			$datetime = new DateTime();
1324 1407
 			$offset = $datetime->format('P');
1325
-		} else $offset = '+00:00';
1408
+		} else {
1409
+			$offset = '+00:00';
1410
+		}
1326 1411
 
1327 1412
 		if ($globalDBdriver == 'mysql') {
1328 1413
 			$query  = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1387,8 +1472,11 @@  discard block
 block discarded – undo
1387 1472
 				$query_values = array_merge($query_values,array(':month' => $month));
1388 1473
 			}
1389 1474
 		}
1390
-		if (empty($query_values)) $queryi .= $this->getFilter($filters);
1391
-		else $queryi .= $this->getFilter($filters,true,true).substr($query,4);
1475
+		if (empty($query_values)) {
1476
+			$queryi .= $this->getFilter($filters);
1477
+		} else {
1478
+			$queryi .= $this->getFilter($filters,true,true).substr($query,4);
1479
+		}
1392 1480
 		
1393 1481
 		$sth = $this->db->prepare($queryi);
1394 1482
 		$sth->execute($query_values);
@@ -1425,8 +1513,11 @@  discard block
 block discarded – undo
1425 1513
 				$query_values = array_merge($query_values,array(':month' => $month));
1426 1514
 			}
1427 1515
 		}
1428
-		if (empty($query_values)) $queryi .= $this->getFilter($filters);
1429
-		else $queryi .= $this->getFilter($filters,true,true).substr($query,4);
1516
+		if (empty($query_values)) {
1517
+			$queryi .= $this->getFilter($filters);
1518
+		} else {
1519
+			$queryi .= $this->getFilter($filters,true,true).substr($query,4);
1520
+		}
1430 1521
 		
1431 1522
 		$sth = $this->db->prepare($queryi);
1432 1523
 		$sth->execute($query_values);
@@ -1448,7 +1539,9 @@  discard block
 block discarded – undo
1448 1539
 			date_default_timezone_set($globalTimezone);
1449 1540
 			$datetime = new DateTime();
1450 1541
 			$offset = $datetime->format('P');
1451
-		} else $offset = '+00:00';
1542
+		} else {
1543
+			$offset = '+00:00';
1544
+		}
1452 1545
 
1453 1546
 		if ($globalDBdriver == 'mysql') {
1454 1547
 			$query  = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1552,7 +1645,9 @@  discard block
 block discarded – undo
1552 1645
 	*/
1553 1646
 	public function parseDirection($direction = 0)
1554 1647
 	{
1555
-		if ($direction == '') $direction = 0;
1648
+		if ($direction == '') {
1649
+			$direction = 0;
1650
+		}
1556 1651
 		$direction_array = array();
1557 1652
 		$temp_array = array();
1558 1653
 
@@ -1641,7 +1736,9 @@  discard block
 block discarded – undo
1641 1736
 		$longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
1642 1737
 	
1643 1738
 		$Connection = new Connection($this->db);
1644
-		if (!$Connection->tableExists('countries')) return '';
1739
+		if (!$Connection->tableExists('countries')) {
1740
+			return '';
1741
+		}
1645 1742
 	
1646 1743
 		try {
1647 1744
 			/*
@@ -1661,9 +1758,13 @@  discard block
 block discarded – undo
1661 1758
 			$sth->closeCursor();
1662 1759
 			if (count($row) > 0) {
1663 1760
 				return $row;
1664
-			} else return '';
1761
+			} else {
1762
+				return '';
1763
+			}
1665 1764
 		} catch (PDOException $e) {
1666
-			if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n";
1765
+			if (isset($globalDebug) && $globalDebug) {
1766
+				echo 'Error : '.$e->getMessage()."\n";
1767
+			}
1667 1768
 			return '';
1668 1769
 		}
1669 1770
 	
@@ -1681,7 +1782,9 @@  discard block
 block discarded – undo
1681 1782
 		$iso2 = filter_var($iso2,FILTER_SANITIZE_STRING);
1682 1783
 	
1683 1784
 		$Connection = new Connection($this->db);
1684
-		if (!$Connection->tableExists('countries')) return '';
1785
+		if (!$Connection->tableExists('countries')) {
1786
+			return '';
1787
+		}
1685 1788
 	
1686 1789
 		try {
1687 1790
 			$query = "SELECT name,iso2,iso3 FROM countries WHERE iso2 = :iso2 LIMIT 1";
@@ -1693,9 +1796,13 @@  discard block
 block discarded – undo
1693 1796
 			$sth->closeCursor();
1694 1797
 			if (count($row) > 0) {
1695 1798
 				return $row;
1696
-			} else return '';
1799
+			} else {
1800
+				return '';
1801
+			}
1697 1802
 		} catch (PDOException $e) {
1698
-			if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n";
1803
+			if (isset($globalDebug) && $globalDebug) {
1804
+				echo 'Error : '.$e->getMessage()."\n";
1805
+			}
1699 1806
 			return '';
1700 1807
 		}
1701 1808
 	
@@ -1713,7 +1820,9 @@  discard block
 block discarded – undo
1713 1820
 	{
1714 1821
 		global $globalBitlyAccessToken;
1715 1822
 		
1716
-		if ($globalBitlyAccessToken == '') return $url;
1823
+		if ($globalBitlyAccessToken == '') {
1824
+			return $url;
1825
+		}
1717 1826
         
1718 1827
 		$google_url = 'https://api-ssl.bitly.com/v3/shorten?access_token='.$globalBitlyAccessToken.'&longUrl='.$url;
1719 1828
 		
@@ -1789,7 +1898,9 @@  discard block
 block discarded – undo
1789 1898
 			}
1790 1899
 		}
1791 1900
 		$query .= " GROUP BY marine_output.type ORDER BY marine_type_count DESC";
1792
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
1901
+		if ($limit) {
1902
+			$query .= " LIMIT 10 OFFSET 0";
1903
+		}
1793 1904
 		$sth = $this->db->prepare($query);
1794 1905
 		$sth->execute($query_values);
1795 1906
 		$marine_array = array();
Please login to merge, or discard this patch.
require/class.Accident.php 1 patch
Braces   +87 added lines, -31 removed lines patch added patch discarded remove patch
@@ -10,7 +10,9 @@  discard block
 block discarded – undo
10 10
 	public function __construct($dbc = null) {
11 11
 		$Connection = new Connection($dbc);
12 12
 		$this->db = $Connection->db();
13
-		if ($this->db === null) die('Error: No DB connection.');
13
+		if ($this->db === null) {
14
+			die('Error: No DB connection.');
15
+		}
14 16
 	}
15 17
 
16 18
 	public function get() {
@@ -109,8 +111,11 @@  discard block
 block discarded – undo
109 111
 				$data = array();
110 112
 				if ($row['registration'] != '') {
111 113
 					$image_array = $Image->getSpotterImage($row['registration']);
112
-					if (count($image_array) > 0) $data = array_merge($data,array('image' => $image_array[0]['image'],'image_thumbnail' => $image_array[0]['image_thumbnail'],'image_copyright' => $image_array[0]['image_copyright'],'image_source' => $image_array[0]['image_source'],'image_source_website' => $image_array[0]['image_source_website']));
113
-					else $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => ''));
114
+					if (count($image_array) > 0) {
115
+						$data = array_merge($data,array('image' => $image_array[0]['image'],'image_thumbnail' => $image_array[0]['image_thumbnail'],'image_copyright' => $image_array[0]['image_copyright'],'image_source' => $image_array[0]['image_source'],'image_source_website' => $image_array[0]['image_source_website']));
116
+					} else {
117
+						$data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => ''));
118
+					}
114 119
 					$aircraft_type = $Spotter->getAllAircraftTypeByRegistration($row['registration']);
115 120
 					$aircraft_info = $Spotter->getAllAircraftInfo($aircraft_type);
116 121
 					if (!empty($aircraft_info)) {
@@ -126,17 +131,30 @@  discard block
 block discarded – undo
126 131
 						$data['aircraft_base'] = $owner_data['base'];
127 132
 						$data['aircraft_date_first_reg'] = $owner_data['date_first_reg'];
128 133
 					}
129
-				} else $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => ''));
130
-				if ($row['registration'] == '') $row['registration'] = 'NA';
131
-				if ($row['ident'] == '') $row['ident'] = 'NA';
134
+				} else {
135
+					$data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => ''));
136
+				}
137
+				if ($row['registration'] == '') {
138
+					$row['registration'] = 'NA';
139
+				}
140
+				if ($row['ident'] == '') {
141
+					$row['ident'] = 'NA';
142
+				}
132 143
 				$identicao = $Spotter->getAllAirlineInfo(substr($row['ident'],0,3));
133 144
 				if (isset($identicao[0])) {
134 145
 					if (substr($row['ident'],0,2) == 'AF') {
135
-						if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) $icao = $row['ident'];
136
-						else $icao = 'AFR'.ltrim(substr($row['ident'],2),'0');
137
-					} else $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0');
146
+						if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) {
147
+							$icao = $row['ident'];
148
+						} else {
149
+							$icao = 'AFR'.ltrim(substr($row['ident'],2),'0');
150
+						}
151
+					} else {
152
+						$icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0');
153
+					}
138 154
 					$data = array_merge($data,array('airline_icao' => $identicao[0]['icao'],'airline_name' => $identicao[0]['name']));
139
-				} else $icao = $row['ident'];
155
+				} else {
156
+					$icao = $row['ident'];
157
+				}
140 158
 				$icao = $Translation->checkTranslation($icao,false);
141 159
 				//$data = array_merge($data,array('registration' => $row['registration'], 'date' => $row['date'], 'ident' => $icao,'url' => $row['url']));
142 160
 				if ($row['airline_name'] != '' && !isset($data['airline_name'])) {
@@ -151,10 +169,14 @@  discard block
 block discarded – undo
151 169
 					//else echo 'No data...'."\n";
152 170
 				}
153 171
 				$data = array_merge($row,$data);
154
-				if ($data['ident'] == null) $data['ident'] = $icao;
172
+				if ($data['ident'] == null) {
173
+					$data['ident'] = $icao;
174
+				}
155 175
 				if ($data['title'] == null) {
156 176
 					$data['message'] = $row['type'].' of '.$row['registration'].' at '.$row['place'].','.$row['country'];
157
-				} else $data['message'] = strtolower($data['title']);
177
+				} else {
178
+					$data['message'] = strtolower($data['title']);
179
+				}
158 180
 				$ids = $Spotter->getAllIDByRegistration($data['registration'],true);
159 181
 				$date = $data['date'];
160 182
 				if (isset($ids[$date])) {
@@ -173,8 +195,9 @@  discard block
 block discarded – undo
173 195
 		if (isset($result)) {
174 196
 			$result[0]['query_number_rows'] = $i;
175 197
 			return $result;
198
+		} else {
199
+			return array();
176 200
 		}
177
-		else return array();
178 201
 	}
179 202
 
180 203
 	/*
@@ -219,7 +242,9 @@  discard block
 block discarded – undo
219 242
 	*/
220 243
 	public function import($file) {
221 244
 		global $globalTransaction, $globalDebug;
222
-		if ($globalDebug) echo 'Import '.$file."\n";
245
+		if ($globalDebug) {
246
+			echo 'Import '.$file."\n";
247
+		}
223 248
 		$result = array();
224 249
 		if (file_exists($file)) {
225 250
 			if (($handle = fopen($file,'r')) !== FALSE) {
@@ -230,8 +255,11 @@  discard block
 block discarded – undo
230 255
 				}
231 256
 				fclose($handle);
232 257
 			}
233
-			if (!empty($result)) $this->add($result,true);
234
-			elseif ($globalDebug) echo 'Nothing to import';
258
+			if (!empty($result)) {
259
+				$this->add($result,true);
260
+			} elseif ($globalDebug) {
261
+				echo 'Nothing to import';
262
+			}
235 263
 		}
236 264
 	}
237 265
 
@@ -267,14 +295,23 @@  discard block
 block discarded – undo
267 295
 					}
268 296
 				}
269 297
 				fclose($handle);
270
-			} elseif ($globalDebug) echo "Can't open ".dirname(__FILE__).'/../install/tmp/cr-all.md5';
271
-		} elseif ($globalDebug) echo 'Download cr-all.md5 failed. '.dirname(__FILE__).'/../install/tmp/cr-all.md5 not here.';
298
+			} elseif ($globalDebug) {
299
+				echo "Can't open ".dirname(__FILE__).'/../install/tmp/cr-all.md5';
300
+			}
301
+		} elseif ($globalDebug) {
302
+			echo 'Download cr-all.md5 failed. '.dirname(__FILE__).'/../install/tmp/cr-all.md5 not here.';
303
+		}
272 304
 		$result = $Common->arr_diff($all_md5_new,$all_md5);
273
-		if (empty($result) && $globalDebug) echo 'Nothing to update';
305
+		if (empty($result) && $globalDebug) {
306
+			echo 'Nothing to update';
307
+		}
274 308
 		foreach ($result as $file => $md5) {
275 309
 			$Common->download('http://data.flightairmap.fr/data/cr/'.$file,dirname(__FILE__).'/../install/tmp/'.$file);
276
-			if (file_exists(dirname(__FILE__).'/../install/tmp/'.$file)) $this->import(dirname(__FILE__).'/../install/tmp/'.$file);
277
-			elseif ($globalDebug) echo 'Download '.$file.' failed';
310
+			if (file_exists(dirname(__FILE__).'/../install/tmp/'.$file)) {
311
+				$this->import(dirname(__FILE__).'/../install/tmp/'.$file);
312
+			} elseif ($globalDebug) {
313
+				echo 'Download '.$file.' failed';
314
+			}
278 315
 		}
279 316
 	}
280 317
 
@@ -291,13 +328,17 @@  discard block
 block discarded – undo
291 328
 		$Image = new Image($this->db);
292 329
 		$Spotter = new Spotter($this->db);
293 330
 
294
-		if (empty($crash)) return false;
331
+		if (empty($crash)) {
332
+			return false;
333
+		}
295 334
 		if (!$new) {
296 335
 			$query_delete = 'DELETE FROM accidents WHERE source = :source';
297 336
 			$sthd = $Connection->db->prepare($query_delete);
298 337
 			$sthd->execute(array(':source' => $crash[0]['source']));
299 338
 		}
300
-		if ($globalTransaction) $Connection->db->beginTransaction();
339
+		if ($globalTransaction) {
340
+			$Connection->db->beginTransaction();
341
+		}
301 342
 		$initial_array = array('ident' => null,'type' => 'accident','url' => null,'registration' => null, 'date' => null, 'place' => null,'country' => null, 'latitude' => null, 'longitude' => null, 'fatalities' => null, 'title' => '','source' => '','aircraft_manufacturer' => null,'aircraft_name' => null,'operator' => null);
302 343
 		$query_check = 'SELECT COUNT(*) as nb FROM accidents WHERE registration = :registration AND date = :date AND type = :type AND source = :source';
303 344
 		$sth_check = $Connection->db->prepare($query_check);
@@ -312,7 +353,9 @@  discard block
 block discarded – undo
312 353
 					return $value === "" ? NULL : $value;
313 354
 				}, $cr);
314 355
 				if ($cr['date'] != '' && $cr['registration'] != null && $cr['registration'] != '' && $cr['registration'] != '?' && $cr['registration'] != '-' && strtolower($cr['registration']) != 'unknown' && $cr['date'] < time() && !preg_match('/\s/',$cr['registration'])) {
315
-					if (strpos($cr['registration'],'-') === FALSE) $cr['registration'] = $Spotter->convertAircraftRegistration($cr['registration']);
356
+					if (strpos($cr['registration'],'-') === FALSE) {
357
+						$cr['registration'] = $Spotter->convertAircraftRegistration($cr['registration']);
358
+					}
316 359
 					$query_check_values = array(':registration' => $cr['registration'],':date' => date('Y-m-d',$cr['date']),':type' => $cr['type'],':source' => $cr['source']);
317 360
 					$sth_check->execute($query_check_values);
318 361
 					$result_check = $sth_check->fetch(PDO::FETCH_ASSOC);
@@ -321,13 +364,19 @@  discard block
 block discarded – undo
321 364
 						$sth->execute($query_values);
322 365
 						if ($cr['date'] > time()-(30*86400)) {
323 366
 							if (empty($Image->getSpotterImage($cr['registration']))) {
324
-								if ($globalDebug) echo "\t".'Get image for '.$cr['registration'].'...';
367
+								if ($globalDebug) {
368
+									echo "\t".'Get image for '.$cr['registration'].'...';
369
+								}
325 370
 								$Image->addSpotterImage($cr['registration']);
326
-								if ($globalDebug) echo "\t".'Done'."\n";
371
+								if ($globalDebug) {
372
+									echo "\t".'Done'."\n";
373
+								}
327 374
 							}
328 375
 							// elseif ($globalDebug) echo 'Image already in DB'."\n";
329 376
 						}
330
-						if ($cr['title'] == '') $cr['title'] = $cr['registration'].' '.$cr['type'];
377
+						if ($cr['title'] == '') {
378
+							$cr['title'] = $cr['registration'].' '.$cr['type'];
379
+						}
331 380
 						$Spotter->setHighlightFlightByRegistration($cr['registration'],$cr['title'],date('Y-m-d',$cr['date']));
332 381
 					}
333 382
 				}
@@ -336,9 +385,13 @@  discard block
 block discarded – undo
336 385
 					$Connection->db->beginTransaction();
337 386
 				}
338 387
 			}
339
-			if ($globalTransaction) $Connection->db->commit();
388
+			if ($globalTransaction) {
389
+				$Connection->db->commit();
390
+			}
340 391
 		} catch(PDOException $e) {
341
-			if ($globalTransaction) $Connection->db->rollBack();
392
+			if ($globalTransaction) {
393
+				$Connection->db->rollBack();
394
+			}
342 395
 			echo $e->getMessage();
343 396
 		}
344 397
 		$sth_check->closeCursor();
@@ -377,8 +430,11 @@  discard block
 block discarded – undo
377 430
 			return "error : ".$e->getMessage();
378 431
 		}
379 432
 		$row = $sth->fetch(PDO::FETCH_ASSOC);
380
-		if ($row['nb'] > 0) return false;
381
-		else return true;
433
+		if ($row['nb'] > 0) {
434
+			return false;
435
+		} else {
436
+			return true;
437
+		}
382 438
 	}
383 439
 
384 440
 	public static function insert_last_accidents_update() {
Please login to merge, or discard this patch.
require/class.MarineImport.php 1 patch
Braces   +193 added lines, -66 removed lines patch added patch discarded remove patch
@@ -53,7 +53,9 @@  discard block
 block discarded – undo
53 53
 
54 54
     public function checkAll() {
55 55
 	global $globalDebug;
56
-	if ($globalDebug) echo "Update last seen tracked data...\n";
56
+	if ($globalDebug) {
57
+		echo "Update last seen tracked data...\n";
58
+	}
57 59
 	foreach ($this->all_tracked as $key => $flight) {
58 60
 	    if (isset($this->all_tracked[$key]['id'])) {
59 61
 		//echo $this->all_tracked[$key]['id'].' - '.$this->all_tracked[$key]['latitude'].'  '.$this->all_tracked[$key]['longitude']."\n";
@@ -66,13 +68,17 @@  discard block
 block discarded – undo
66 68
     public function del() {
67 69
 	global $globalDebug, $globalNoDB, $globalNoImport;
68 70
 	// Delete old infos
69
-	if ($globalDebug) echo 'Delete old values and update latest data...'."\n";
71
+	if ($globalDebug) {
72
+		echo 'Delete old values and update latest data...'."\n";
73
+	}
70 74
 	foreach ($this->all_tracked as $key => $flight) {
71 75
     	    if (isset($flight['lastupdate'])) {
72 76
         	if ($flight['lastupdate'] < (time()-3000)) {
73 77
             	    if ((!isset($globalNoImport) || $globalNoImport !== TRUE) && (!isset($globalNoDB) || $globalNoDB !== TRUE)) {
74 78
             		if (isset($this->all_tracked[$key]['id'])) {
75
-            		    if ($globalDebug) echo "--- Delete old values with id ".$this->all_tracked[$key]['id']."\n";
79
+            		    if ($globalDebug) {
80
+            		    	echo "--- Delete old values with id ".$this->all_tracked[$key]['id']."\n";
81
+            		    }
76 82
 			    /*
77 83
 			    $MarineLive = new MarineLive();
78 84
             		    $MarineLive->deleteLiveMarineDataById($this->all_tracked[$key]['id']);
@@ -82,7 +88,9 @@  discard block
 block discarded – undo
82 88
             		    $Marine = new Marine($this->db);
83 89
             		    if ($this->all_tracked[$key]['latitude'] != '' && $this->all_tracked[$key]['longitude'] != '') {
84 90
 				$result = $Marine->updateLatestMarineData($this->all_tracked[$key]['id'],$this->all_tracked[$key]['ident'],$this->all_tracked[$key]['latitude'],$this->all_tracked[$key]['longitude'],$this->all_tracked[$key]['speed'],$this->all_tracked[$key]['datetime']);
85
-				if ($globalDebug && $result != 'success') echo '!!! ERROR : '.$result."\n";
91
+				if ($globalDebug && $result != 'success') {
92
+					echo '!!! ERROR : '.$result."\n";
93
+				}
86 94
 			    }
87 95
 			    // Put in archive
88 96
 //				$Marine->db = null;
@@ -96,7 +104,9 @@  discard block
 block discarded – undo
96 104
 
97 105
     public function add($line) {
98 106
 	global $globalFork, $globalDistanceIgnore, $globalDaemon, $globalDebug, $globalCoordMinChange, $globalDebugTimeElapsed, $globalCenterLatitude, $globalCenterLongitude, $globalBeta, $globalSourcesupdate, $globalAllTracked, $globalNoImport, $globalNoDB, $globalServerAPRS,$APRSMarine;
99
-	if (!isset($globalCoordMinChange) || $globalCoordMinChange == '') $globalCoordMinChange = '0.02';
107
+	if (!isset($globalCoordMinChange) || $globalCoordMinChange == '') {
108
+		$globalCoordMinChange = '0.02';
109
+	}
100 110
 	date_default_timezone_set('UTC');
101 111
 	$dataFound = false;
102 112
 	$send = false;
@@ -110,20 +120,30 @@  discard block
 block discarded – undo
110 120
 		// Increment message number
111 121
 		if (isset($line['sourcestats']) && $line['sourcestats'] == TRUE) {
112 122
 		    $current_date = date('Y-m-d');
113
-		    if (isset($line['source_name'])) $source = $line['source_name'];
114
-		    else $source = '';
115
-		    if ($source == '' || $line['format_source'] == 'aprs') $source = $line['format_source'];
123
+		    if (isset($line['source_name'])) {
124
+		    	$source = $line['source_name'];
125
+		    } else {
126
+		    	$source = '';
127
+		    }
128
+		    if ($source == '' || $line['format_source'] == 'aprs') {
129
+		    	$source = $line['format_source'];
130
+		    }
116 131
 		    if (!isset($this->stats[$current_date][$source]['msg'])) {
117 132
 		    	$this->stats[$current_date][$source]['msg']['date'] = time();
118 133
 		    	$this->stats[$current_date][$source]['msg']['nb'] = 1;
119
-		    } else $this->stats[$current_date][$source]['msg']['nb'] += 1;
134
+		    } else {
135
+		    	$this->stats[$current_date][$source]['msg']['nb'] += 1;
136
+		    }
120 137
 		}
121 138
 		
122 139
 		
123 140
 		$Common = new Common();
124 141
 		$AIS = new AIS();
125
-	        if (!isset($line['id'])) $id = trim($line['mmsi']);
126
-	        else $id = trim($line['id']);
142
+	        if (!isset($line['id'])) {
143
+	        	$id = trim($line['mmsi']);
144
+	        } else {
145
+	        	$id = trim($line['id']);
146
+	        }
127 147
 		
128 148
 		if (!isset($this->all_tracked[$id])) {
129 149
 		    $this->all_tracked[$id] = array();
@@ -131,10 +151,16 @@  discard block
 block discarded – undo
131 151
 		    $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('ident' => '','latitude' => '', 'longitude' => '', 'speed' => '0', 'heading' => '', 'format_source' => '','source_name' => '','comment'=> '','type' => '','typeid' => '','noarchive' => false,'putinarchive' => true,'over_country' => '','mmsi' => '','status' => '','status_id' => '','imo' => '','callsign' => '','arrival_code' => '','arrival_date' => '','mmsi_type' => ''));
132 152
 		    $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('lastupdate' => time()));
133 153
 		    if (!isset($line['id'])) {
134
-			if (!isset($globalDaemon)) $globalDaemon = TRUE;
154
+			if (!isset($globalDaemon)) {
155
+				$globalDaemon = TRUE;
156
+			}
135 157
 			$this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $id.'-'.date('YmdHi')));
136
-		     } else $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $line['id']));
137
-		    if ($globalAllTracked !== FALSE) $dataFound = true;
158
+		     } else {
159
+		     	$this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $line['id']));
160
+		     }
161
+		    if ($globalAllTracked !== FALSE) {
162
+		    	$dataFound = true;
163
+		    }
138 164
 		}
139 165
 		
140 166
 		if (isset($line['mmsi']) && $line['mmsi'] != '' && $line['mmsi'] != $this->all_tracked[$id]['mmsi']) {
@@ -184,34 +210,49 @@  discard block
 block discarded – undo
184 210
 				$Marine = new Marine($this->db);
185 211
 				$fromsource = NULL;
186 212
 				$result = $Marine->updateIdentMarineData($this->all_tracked[$id]['id'],$this->all_tracked[$id]['ident'],$fromsource);
187
-				if ($globalDebug && $result != 'success') echo '!!! ERROR : '.$result."\n";
213
+				if ($globalDebug && $result != 'success') {
214
+					echo '!!! ERROR : '.$result."\n";
215
+				}
188 216
 				$Marine->db = null;
189
-				if ($globalDebugTimeElapsed) echo 'Time elapsed for update identspotterdata : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
217
+				if ($globalDebugTimeElapsed) {
218
+					echo 'Time elapsed for update identspotterdata : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
219
+				}
190 220
 			    }
191 221
 			}
192 222
 		    }
193
-		    if (!isset($this->all_tracked[$id]['id'])) $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $this->all_tracked[$id]['ident']));
223
+		    if (!isset($this->all_tracked[$id]['id'])) {
224
+		    	$this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $this->all_tracked[$id]['ident']));
225
+		    }
194 226
 		}
195 227
 
196 228
 		if (isset($line['datetime']) && strtotime($line['datetime']) > time()-20*60 && strtotime($line['datetime']) < time()+20*60) {
197 229
 		    if (!isset($this->all_tracked[$id]['datetime']) || strtotime($line['datetime']) > strtotime($this->all_tracked[$id]['datetime'])) {
198 230
 			$this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('datetime' => $line['datetime']));
199 231
 		    } else {
200
-				if (strtotime($line['datetime']) == strtotime($this->all_tracked[$id]['datetime']) && $globalDebug) echo "!!! Date is the same as previous data for ".$this->all_tracked[$id]['mmsi']."\n";
201
-				elseif (strtotime($line['datetime']) > strtotime($this->all_tracked[$id]['datetime']) && $globalDebug) echo "!!! Date previous latest data (".$line['datetime']." > ".$this->all_tracked[$id]['datetime'].") !!! for ".$this->all_tracked[$id]['hex']." - format : ".$line['format_source']."\n";
232
+				if (strtotime($line['datetime']) == strtotime($this->all_tracked[$id]['datetime']) && $globalDebug) {
233
+					echo "!!! Date is the same as previous data for ".$this->all_tracked[$id]['mmsi']."\n";
234
+				} elseif (strtotime($line['datetime']) > strtotime($this->all_tracked[$id]['datetime']) && $globalDebug) {
235
+					echo "!!! Date previous latest data (".$line['datetime']." > ".$this->all_tracked[$id]['datetime'].") !!! for ".$this->all_tracked[$id]['hex']." - format : ".$line['format_source']."\n";
236
+				}
202 237
 				return '';
203 238
 		    }
204 239
 		} elseif (isset($line['datetime']) && strtotime($line['datetime']) < time()-20*60) {
205
-			if ($globalDebug) echo "!!! Date is too old ".$this->all_tracked[$id]['mmsi']." - format : ".$line['format_source']."!!!";
240
+			if ($globalDebug) {
241
+				echo "!!! Date is too old ".$this->all_tracked[$id]['mmsi']." - format : ".$line['format_source']."!!!";
242
+			}
206 243
 			return '';
207 244
 		} elseif (isset($line['datetime']) && strtotime($line['datetime']) > time()+20*60) {
208
-			if ($globalDebug) echo "!!! Date is in the future ".$this->all_tracked[$id]['mmsi']." - format : ".$line['format_source']."!!!";
245
+			if ($globalDebug) {
246
+				echo "!!! Date is in the future ".$this->all_tracked[$id]['mmsi']." - format : ".$line['format_source']."!!!";
247
+			}
209 248
 			return '';
210 249
 		} elseif (!isset($line['datetime'])) {
211 250
 			date_default_timezone_set('UTC');
212 251
 			$this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('datetime' => date('Y-m-d H:i:s')));
213 252
 		} else {
214
-			if ($globalDebug) echo "!!! Unknow date error ".$this->all_tracked[$id]['mmsi']." - format : ".$line['format_source']."!!!";
253
+			if ($globalDebug) {
254
+				echo "!!! Unknow date error ".$this->all_tracked[$id]['mmsi']." - format : ".$line['format_source']."!!!";
255
+			}
215 256
 			return '';
216 257
 		}
217 258
 
@@ -224,14 +265,21 @@  discard block
 block discarded – undo
224 265
 		    if ($distance > 1000 && $distance < 10000) {
225 266
 			$speed = $distance/(time() - $this->all_tracked[$id]['time_last_coord']);
226 267
 			$speed = $speed*3.6;
227
-			if ($speed < 1000) $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('speed' => round($speed)));
228
-  			if ($globalDebug) echo "ø Calculated Speed for ".$this->all_tracked[$id]['hex']." : ".$speed." - distance : ".$distance."\n";
268
+			if ($speed < 1000) {
269
+				$this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('speed' => round($speed)));
270
+			}
271
+  			if ($globalDebug) {
272
+  				echo "ø Calculated Speed for ".$this->all_tracked[$id]['hex']." : ".$speed." - distance : ".$distance."\n";
273
+  			}
229 274
 		    }
230 275
 		}
231 276
 
232 277
 	        if (isset($line['latitude']) && isset($line['longitude']) && $line['latitude'] != '' && $line['longitude'] != '' && is_numeric($line['latitude']) && is_numeric($line['longitude'])) {
233
-	    	    if (isset($this->all_tracked[$id]['time_last_coord'])) $timediff = round(time()-$this->all_tracked[$id]['time_last_coord']);
234
-	    	    else unset($timediff);
278
+	    	    if (isset($this->all_tracked[$id]['time_last_coord'])) {
279
+	    	    	$timediff = round(time()-$this->all_tracked[$id]['time_last_coord']);
280
+	    	    } else {
281
+	    	    	unset($timediff);
282
+	    	    }
235 283
 	    	    if ($this->tmd > 5 || !isset($timediff) || $timediff > 2000 || ($timediff > 30 && isset($this->all_tracked[$id]['latitude']) && isset($this->all_tracked[$id]['longitude']) && $Common->withinThreshold($timediff,$Common->distance($line['latitude'],$line['longitude'],$this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude'],'m')))) {
236 284
 			if (isset($this->all_tracked[$id]['archive_latitude']) && isset($this->all_tracked[$id]['archive_longitude']) && isset($this->all_tracked[$id]['livedb_latitude']) && isset($this->all_tracked[$id]['livedb_longitude'])) {
237 285
 			    if (!$Common->checkLine($this->all_tracked[$id]['archive_latitude'],$this->all_tracked[$id]['archive_longitude'],$this->all_tracked[$id]['livedb_latitude'],$this->all_tracked[$id]['livedb_longitude'],$line['latitude'],$line['longitude'])) {
@@ -239,22 +287,32 @@  discard block
 block discarded – undo
239 287
 				$this->all_tracked[$id]['archive_longitude'] = $line['longitude'];
240 288
 				$this->all_tracked[$id]['putinarchive'] = true;
241 289
 				
242
-				if ($globalDebug) echo "\n".' ------- Check Country for '.$this->all_tracked[$id]['ident'].' with latitude : '.$line['latitude'].' and longitude : '.$line['longitude'].'.... ';
290
+				if ($globalDebug) {
291
+					echo "\n".' ------- Check Country for '.$this->all_tracked[$id]['ident'].' with latitude : '.$line['latitude'].' and longitude : '.$line['longitude'].'.... ';
292
+				}
243 293
 				$timeelapsed = microtime(true);
244 294
 				if (!isset($globalNoDB) || $globalNoDB !== TRUE) {
245 295
 				    $Marine = new Marine($this->db);
246 296
 				    $all_country = $Marine->getCountryFromLatitudeLongitude($line['latitude'],$line['longitude']);
247
-				    if (!empty($all_country)) $this->all_tracked[$id]['over_country'] = $all_country['iso2'];
297
+				    if (!empty($all_country)) {
298
+				    	$this->all_tracked[$id]['over_country'] = $all_country['iso2'];
299
+				    }
248 300
 				    $Marine->db = null;
249
-				    if ($globalDebugTimeElapsed) echo 'Time elapsed for update getCountryFromlatitudeLongitude : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
301
+				    if ($globalDebugTimeElapsed) {
302
+				    	echo 'Time elapsed for update getCountryFromlatitudeLongitude : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
303
+				    }
250 304
 				}
251 305
 				$this->tmd = 0;
252
-				if ($globalDebug) echo 'FOUND : '.$this->all_tracked[$id]['over_country'].' ---------------'."\n";
306
+				if ($globalDebug) {
307
+					echo 'FOUND : '.$this->all_tracked[$id]['over_country'].' ---------------'."\n";
308
+				}
253 309
 			    }
254 310
 			}
255 311
 
256 312
 			if (isset($line['latitude']) && $line['latitude'] != '' && $line['latitude'] != 0 && $line['latitude'] < 91 && $line['latitude'] > -90) {
257
-				if (!isset($this->all_tracked[$id]['archive_latitude'])) $this->all_tracked[$id]['archive_latitude'] = $line['latitude'];
313
+				if (!isset($this->all_tracked[$id]['archive_latitude'])) {
314
+					$this->all_tracked[$id]['archive_latitude'] = $line['latitude'];
315
+				}
258 316
 				if (!isset($this->all_tracked[$id]['livedb_latitude']) || abs($this->all_tracked[$id]['livedb_latitude']-$line['latitude']) > $globalCoordMinChange || $this->all_tracked[$id]['format_source'] == 'aprs') {
259 317
 				    $this->all_tracked[$id]['livedb_latitude'] = $line['latitude'];
260 318
 				    $dataFound = true;
@@ -263,8 +321,12 @@  discard block
 block discarded – undo
263 321
 				$this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('latitude' => $line['latitude']));
264 322
 			}
265 323
 			if (isset($line['longitude']) && $line['longitude'] != '' && $line['longitude'] != 0 && $line['longitude'] < 360 && $line['longitude'] > -180) {
266
-			    if ($line['longitude'] > 180) $line['longitude'] = $line['longitude'] - 360;
267
-				if (!isset($this->all_tracked[$id]['archive_longitude'])) $this->all_tracked[$id]['archive_longitude'] = $line['longitude'];
324
+			    if ($line['longitude'] > 180) {
325
+			    	$line['longitude'] = $line['longitude'] - 360;
326
+			    }
327
+				if (!isset($this->all_tracked[$id]['archive_longitude'])) {
328
+					$this->all_tracked[$id]['archive_longitude'] = $line['longitude'];
329
+				}
268 330
 				if (!isset($this->all_tracked[$id]['livedb_longitude']) || abs($this->all_tracked[$id]['livedb_longitude']-$line['longitude']) > $globalCoordMinChange || $this->all_tracked[$id]['format_source'] == 'aprs') {
269 331
 				    $this->all_tracked[$id]['livedb_longitude'] = $line['longitude'];
270 332
 				    $dataFound = true;
@@ -282,7 +344,9 @@  discard block
 block discarded – undo
282 344
 		    }
283 345
 		}
284 346
 		if (isset($line['last_update']) && $line['last_update'] != '') {
285
-		    if (isset($this->all_tracked[$id]['last_update']) && $this->all_tracked[$id]['last_update'] != $line['last_update']) $dataFound = true;
347
+		    if (isset($this->all_tracked[$id]['last_update']) && $this->all_tracked[$id]['last_update'] != $line['last_update']) {
348
+		    	$dataFound = true;
349
+		    }
286 350
 		    $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('last_update' => $line['last_update']));
287 351
 		}
288 352
 		if (isset($line['format_source']) && $line['format_source'] != '') {
@@ -312,15 +376,21 @@  discard block
 block discarded – undo
312 376
 		}
313 377
 		
314 378
 		if (isset($line['heading']) && $line['heading'] != '') {
315
-		    if (is_int($this->all_tracked[$id]['heading']) && abs($this->all_tracked[$id]['heading']-round($line['heading'])) > 10) $this->all_tracked[$id]['putinarchive'] = true;
379
+		    if (is_int($this->all_tracked[$id]['heading']) && abs($this->all_tracked[$id]['heading']-round($line['heading'])) > 10) {
380
+		    	$this->all_tracked[$id]['putinarchive'] = true;
381
+		    }
316 382
 		    $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('heading' => round($line['heading'])));
317 383
 		    $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('heading_fromsrc' => true));
318 384
 		    //$dataFound = true;
319 385
   		} elseif (!isset($this->all_tracked[$id]['heading_fromsrc']) && isset($this->all_tracked[$id]['archive_latitude']) && $this->all_tracked[$id]['archive_latitude'] != $this->all_tracked[$id]['latitude'] && isset($this->all_tracked[$id]['archive_longitude']) && $this->all_tracked[$id]['archive_longitude'] != $this->all_tracked[$id]['longitude']) {
320 386
   		    $heading = $Common->getHeading($this->all_tracked[$id]['archive_latitude'],$this->all_tracked[$id]['archive_longitude'],$this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude']);
321 387
 		    $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('heading' => round($heading)));
322
-		    if (abs($this->all_tracked[$id]['heading']-round($heading)) > 10) $this->all_tracked[$id]['putinarchive'] = true;
323
-  		    if ($globalDebug) echo "ø Calculated Heading for ".$this->all_tracked[$id]['ident']." : ".$heading."\n";
388
+		    if (abs($this->all_tracked[$id]['heading']-round($heading)) > 10) {
389
+		    	$this->all_tracked[$id]['putinarchive'] = true;
390
+		    }
391
+  		    if ($globalDebug) {
392
+  		    	echo "ø Calculated Heading for ".$this->all_tracked[$id]['ident']." : ".$heading."\n";
393
+  		    }
324 394
   		}
325 395
 		//if (isset($globalSourcesupdate) && $globalSourcesupdate != '' && isset($this->all_tracked[$id]['lastupdate']) && time()-$this->all_tracked[$id]['lastupdate'] < $globalSourcesupdate) $dataFound = false;
326 396
 
@@ -332,23 +402,38 @@  discard block
 block discarded – undo
332 402
 		        if (!isset($globalDistanceIgnore['latitude']) || $this->all_tracked[$id]['longitude'] == ''  || $this->all_tracked[$id]['latitude'] == '' || (isset($globalDistanceIgnore['latitude']) && $Common->distance($this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude'],$globalDistanceIgnore['latitude'],$globalDistanceIgnore['longitude']) < $globalDistanceIgnore['distance'])) {
333 403
 			    if (!isset($this->all_tracked[$id]['forcenew']) || $this->all_tracked[$id]['forcenew'] == 0) {
334 404
 				if (!isset($globalNoDB) || $globalNoDB !== TRUE) {
335
-				    if ($globalDebug) echo "Check if aircraft is already in DB...";
405
+				    if ($globalDebug) {
406
+				    	echo "Check if aircraft is already in DB...";
407
+				    }
336 408
 				    $timeelapsed = microtime(true);
337 409
 				    $MarineLive = new MarineLive($this->db);
338 410
 				    if (isset($line['id'])) {
339 411
 					$recent_ident = $MarineLive->checkIdRecent($line['id']);
340
-					if ($globalDebugTimeElapsed) echo 'Time elapsed for update checkIdRecent : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
412
+					if ($globalDebugTimeElapsed) {
413
+						echo 'Time elapsed for update checkIdRecent : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
414
+					}
341 415
 				    } elseif (isset($this->all_tracked[$id]['mmsi']) && $this->all_tracked[$id]['mmsi'] != '') {
342 416
 					$recent_ident = $MarineLive->checkMMSIRecent($this->all_tracked[$id]['mmsi']);
343
-					if ($globalDebugTimeElapsed) echo 'Time elapsed for update checkIdentRecent : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
417
+					if ($globalDebugTimeElapsed) {
418
+						echo 'Time elapsed for update checkIdentRecent : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
419
+					}
344 420
 				    } elseif (isset($this->all_tracked[$id]['ident']) && $this->all_tracked[$id]['ident'] != '') {
345 421
 					$recent_ident = $MarineLive->checkIdentRecent($this->all_tracked[$id]['ident']);
346
-					if ($globalDebugTimeElapsed) echo 'Time elapsed for update checkIdentRecent : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
347
-				    } else $recent_ident = '';
422
+					if ($globalDebugTimeElapsed) {
423
+						echo 'Time elapsed for update checkIdentRecent : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
424
+					}
425
+				    } else {
426
+				    	$recent_ident = '';
427
+				    }
348 428
 				    $MarineLive->db=null;
349
-				    if ($globalDebug && $recent_ident == '') echo " Not in DB.\n";
350
-				    elseif ($globalDebug && $recent_ident != '') echo " Already in DB.\n";
351
-				} else $recent_ident = '';
429
+				    if ($globalDebug && $recent_ident == '') {
430
+				    	echo " Not in DB.\n";
431
+				    } elseif ($globalDebug && $recent_ident != '') {
432
+				    	echo " Already in DB.\n";
433
+				    }
434
+				} else {
435
+					$recent_ident = '';
436
+				}
352 437
 			    } else {
353 438
 				$recent_ident = '';
354 439
 				$this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('forcenew' => 0));
@@ -356,30 +441,44 @@  discard block
 block discarded – undo
356 441
 			    //if there was no aircraft with the same callsign within the last hour and go post it into the archive
357 442
 			    if($recent_ident == "" && $this->all_tracked[$id]['latitude'] != '' && $this->all_tracked[$id]['longitude'] != '')
358 443
 			    {
359
-				if ($globalDebug) echo "\o/ Add ".$this->all_tracked[$id]['mmsi']." in archive DB : ";
444
+				if ($globalDebug) {
445
+					echo "\o/ Add ".$this->all_tracked[$id]['mmsi']." in archive DB : ";
446
+				}
360 447
 				//adds the spotter data for the archive
361 448
 				    $highlight = '';
362
-				    if (!isset($this->all_tracked[$id]['id'])) $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $this->all_tracked[$id]['mmsi'].'-'.date('YmdHi')));
449
+				    if (!isset($this->all_tracked[$id]['id'])) {
450
+				    	$this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $this->all_tracked[$id]['mmsi'].'-'.date('YmdHi')));
451
+				    }
363 452
 				    if (!isset($globalNoImport) || $globalNoImport !== TRUE) {
364 453
 					if (!isset($globalNoDB) || $globalNoDB !== TRUE) {
365 454
 					    $timeelapsed = microtime(true);
366 455
 					    $Marine = new Marine($this->db);
367 456
 					    $result = $Marine->addMarineData($this->all_tracked[$id]['id'], $this->all_tracked[$id]['ident'], $this->all_tracked[$id]['latitude'], $this->all_tracked[$id]['longitude'], $this->all_tracked[$id]['heading'], $this->all_tracked[$id]['speed'], $this->all_tracked[$id]['datetime'], $this->all_tracked[$id]['mmsi'], $this->all_tracked[$id]['type'],$this->all_tracked[$id]['typeid'],$this->all_tracked[$id]['imo'],$this->all_tracked[$id]['callsign'],$this->all_tracked[$id]['arrival_code'],$this->all_tracked[$id]['arrival_date'], $this->all_tracked[$id]['status'], $this->all_tracked[$id]['status_id'],$this->all_tracked[$id]['format_source'],$this->all_tracked[$id]['source_name']);
368 457
 					    $Marine->db = null;
369
-					    if ($globalDebug && isset($result)) echo $result."\n";
370
-					    if ($globalDebugTimeElapsed) echo 'Time elapsed for update addspotterdata : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
458
+					    if ($globalDebug && isset($result)) {
459
+					    	echo $result."\n";
460
+					    }
461
+					    if ($globalDebugTimeElapsed) {
462
+					    	echo 'Time elapsed for update addspotterdata : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
463
+					    }
371 464
 					}
372 465
 				    }
373 466
 				    if (isset($line['sourcestats']) && $line['sourcestats'] == TRUE && $this->all_tracked[$id]['latitude'] != '' && $this->all_tracked[$id]['longitude'] != '') {
374 467
 					// Add source stat in DB
375 468
 					$Stats = new Stats($this->db);
376 469
 					if (!empty($this->stats)) {
377
-					    if ($globalDebug) echo 'Add source stats : ';
470
+					    if ($globalDebug) {
471
+					    	echo 'Add source stats : ';
472
+					    }
378 473
 				    	    foreach($this->stats as $date => $data) {
379 474
 						foreach($data as $source => $sourced) {
380 475
 					    	    //print_r($sourced);
381
-				    	    	    if (isset($sourced['polar'])) echo $Stats->addStatSource(json_encode($sourced['polar']),$source,'polar_marine',$date);
382
-				    	    	    if (isset($sourced['hist'])) echo $Stats->addStatSource(json_encode($sourced['hist']),$source,'hist_marine',$date);
476
+				    	    	    if (isset($sourced['polar'])) {
477
+				    	    	    	echo $Stats->addStatSource(json_encode($sourced['polar']),$source,'polar_marine',$date);
478
+				    	    	    }
479
+				    	    	    if (isset($sourced['hist'])) {
480
+				    	    	    	echo $Stats->addStatSource(json_encode($sourced['hist']),$source,'hist_marine',$date);
481
+				    	    	    }
383 482
 				    		    if (isset($sourced['msg'])) {
384 483
 				    			if (time() - $sourced['msg']['date'] > 10) {
385 484
 				    		    	    $nbmsg = round($sourced['msg']['nb']/(time() - $sourced['msg']['date']));
@@ -392,7 +491,9 @@  discard block
 block discarded – undo
392 491
 			    			    unset($this->stats[$date]);
393 492
 			    			}
394 493
 				    	    }
395
-				    	    if ($globalDebug) echo 'Done'."\n";
494
+				    	    if ($globalDebug) {
495
+				    	    	echo 'Done'."\n";
496
+				    	    }
396 497
 					}
397 498
 					$Stats->db = null;
398 499
 				    }
@@ -402,13 +503,17 @@  discard block
 block discarded – undo
402 503
 				$this->all_tracked[$id]['addedMarine'] = 1;
403 504
 				//print_r($this->all_tracked[$id]);
404 505
 				if ($this->last_delete == 0 || time() - $this->last_delete > 1800) {
405
-				    if ($globalDebug) echo "---- Deleting Live Marine data older than 9 hours...";
506
+				    if ($globalDebug) {
507
+				    	echo "---- Deleting Live Marine data older than 9 hours...";
508
+				    }
406 509
 				    //MarineLive->deleteLiveMarineDataNotUpdated();
407 510
 				    if (!isset($globalNoDB) || $globalNoDB !== TRUE) {
408 511
 					$MarineLive = new MarineLive($this->db);
409 512
 					$MarineLive->deleteLiveMarineData();
410 513
 					$MarineLive->db=null;
411
-					if ($globalDebug) echo " Done\n";
514
+					if ($globalDebug) {
515
+						echo " Done\n";
516
+					}
412 517
 				    }
413 518
 				    $this->last_delete = time();
414 519
 				}
@@ -434,15 +539,21 @@  discard block
 block discarded – undo
434 539
 
435 540
 		    if (!$ignoreImport) {
436 541
 			if (!isset($globalDistanceIgnore['latitude']) || (isset($globalDistanceIgnore['latitude']) && $Common->distance($this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude'],$globalDistanceIgnore['latitude'],$globalDistanceIgnore['longitude']) < $globalDistanceIgnore['distance'])) {
437
-				if ($globalDebug) echo "\o/ Add ".$this->all_tracked[$id]['ident']." from ".$this->all_tracked[$id]['format_source']." in Live DB : ";
542
+				if ($globalDebug) {
543
+					echo "\o/ Add ".$this->all_tracked[$id]['ident']." from ".$this->all_tracked[$id]['format_source']." in Live DB : ";
544
+				}
438 545
 				if (!isset($globalNoImport) || $globalNoImport !== TRUE) {
439 546
 				    if (!isset($globalNoDB) || $globalNoDB !== TRUE) {
440 547
 					$timeelapsed = microtime(true);
441 548
 					$MarineLive = new MarineLive($this->db);
442 549
 					$result = $MarineLive->addLiveMarineData($this->all_tracked[$id]['id'], $this->all_tracked[$id]['ident'], $this->all_tracked[$id]['latitude'], $this->all_tracked[$id]['longitude'], $this->all_tracked[$id]['heading'], $this->all_tracked[$id]['speed'],$this->all_tracked[$id]['datetime'], $this->all_tracked[$id]['putinarchive'],$this->all_tracked[$id]['mmsi'],$this->all_tracked[$id]['type'],$this->all_tracked[$id]['typeid'],$this->all_tracked[$id]['imo'],$this->all_tracked[$id]['callsign'],$this->all_tracked[$id]['arrival_code'],$this->all_tracked[$id]['arrival_date'],$this->all_tracked[$id]['status'],$this->all_tracked[$id]['status_id'],$this->all_tracked[$id]['noarchive'],$this->all_tracked[$id]['format_source'],$this->all_tracked[$id]['source_name'],$this->all_tracked[$id]['over_country']);
443 550
 					$MarineLive->db = null;
444
-					if ($globalDebug) echo $result."\n";
445
-					if ($globalDebugTimeElapsed) echo 'Time elapsed for update addlivespotterdata : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
551
+					if ($globalDebug) {
552
+						echo $result."\n";
553
+					}
554
+					if ($globalDebugTimeElapsed) {
555
+						echo 'Time elapsed for update addlivespotterdata : '.round(microtime(true)-$timeelapsed,2).'s'."\n";
556
+					}
446 557
 				    }
447 558
 				}
448 559
 				if (isset($globalServerAPRS) && $globalServerAPRS && $this->all_tracked[$id]['putinarchive']) {
@@ -454,7 +565,9 @@  discard block
 block discarded – undo
454 565
 				
455 566
 				if (isset($line['sourcestats']) && $line['sourcestats'] == TRUE && $line['format_source'] != 'aprs' && $this->all_tracked[$id]['latitude'] != '' && $this->all_tracked[$id]['longitude'] != '') {
456 567
 					$source = $this->all_tracked[$id]['source_name'];
457
-					if ($source == '') $source = $this->all_tracked[$id]['format_source'];
568
+					if ($source == '') {
569
+						$source = $this->all_tracked[$id]['format_source'];
570
+					}
458 571
 					if (!isset($this->source_location[$source])) {
459 572
 						$Location = new Source($this->db);
460 573
 						$coord = $Location->getLocationInfobySourceName($source);
@@ -475,7 +588,9 @@  discard block
 block discarded – undo
475 588
 					$stats_heading = round($stats_heading/22.5);
476 589
 					$stats_distance = $Common->distance($latitude,$longitude,$this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude']);
477 590
 					$current_date = date('Y-m-d');
478
-					if ($stats_heading == 16) $stats_heading = 0;
591
+					if ($stats_heading == 16) {
592
+						$stats_heading = 0;
593
+					}
479 594
 					if (!isset($this->stats[$current_date][$source]['polar'][1])) {
480 595
 						for ($i=0;$i<=15;$i++) {
481 596
 						    $this->stats[$current_date][$source]['polar'][$i] = 0;
@@ -493,7 +608,9 @@  discard block
 block discarded – undo
493 608
 						if (isset($this->stats[$current_date][$source]['hist'][0])) {
494 609
 						    end($this->stats[$current_date][$source]['hist']);
495 610
 						    $mini = key($this->stats[$current_date][$source]['hist'])+10;
496
-						} else $mini = 0;
611
+						} else {
612
+							$mini = 0;
613
+						}
497 614
 						for ($i=$mini;$i<=$distance;$i+=10) {
498 615
 						    $this->stats[$current_date][$source]['hist'][$i] = 0;
499 616
 						}
@@ -505,19 +622,27 @@  discard block
 block discarded – undo
505 622
 				
506 623
 
507 624
 				$this->all_tracked[$id]['lastupdate'] = time();
508
-				if ($this->all_tracked[$id]['putinarchive']) $send = true;
509
-			} elseif (isset($this->all_tracked[$id]['latitude']) && isset($globalDistanceIgnore['latitude']) && $globalDebug) echo "!! Too far -> Distance : ".$Common->distance($this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude'],$globalDistanceIgnore['latitude'],$globalDistanceIgnore['longitude'])."\n";
625
+				if ($this->all_tracked[$id]['putinarchive']) {
626
+					$send = true;
627
+				}
628
+			} elseif (isset($this->all_tracked[$id]['latitude']) && isset($globalDistanceIgnore['latitude']) && $globalDebug) {
629
+				echo "!! Too far -> Distance : ".$Common->distance($this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude'],$globalDistanceIgnore['latitude'],$globalDistanceIgnore['longitude'])."\n";
630
+			}
510 631
 			//$this->del();
511 632
 			
512 633
 			
513 634
 			if ($this->last_delete_hourly == 0 || time() - $this->last_delete_hourly > 900) {
514 635
 			    if (!isset($globalNoDB) || $globalNoDB !== TRUE) {
515
-				if ($globalDebug) echo "---- Deleting Live Marine data Not updated since 2 hour...";
636
+				if ($globalDebug) {
637
+					echo "---- Deleting Live Marine data Not updated since 2 hour...";
638
+				}
516 639
 				$MarineLive = new MarineLive($this->db);
517 640
 				$MarineLive->deleteLiveMarineDataNotUpdated();
518 641
 				$MarineLive->db = null;
519 642
 				//MarineLive->deleteLiveMarineData();
520
-				if ($globalDebug) echo " Done\n";
643
+				if ($globalDebug) {
644
+					echo " Done\n";
645
+				}
521 646
 			    }
522 647
 			    $this->last_delete_hourly = time();
523 648
 			}
@@ -526,7 +651,9 @@  discard block
 block discarded – undo
526 651
 		    //$ignoreImport = false;
527 652
 		}
528 653
 		//if (function_exists('pcntl_fork') && $globalFork) pcntl_signal(SIGCHLD, SIG_IGN);
529
-		if ($send) return $this->all_tracked[$id];
654
+		if ($send) {
655
+			return $this->all_tracked[$id];
656
+		}
530 657
 	    }
531 658
 	}
532 659
     }
Please login to merge, or discard this patch.
require/class.Tracker.php 1 patch
Braces   +160 added lines, -57 removed lines patch added patch discarded remove patch
@@ -10,7 +10,9 @@  discard block
 block discarded – undo
10 10
 	public function __construct($dbc = null) {
11 11
 		$Connection = new Connection($dbc);
12 12
 		$this->db = $Connection->db();
13
-		if ($this->db === null) die('Error: No DB connection.');
13
+		if ($this->db === null) {
14
+			die('Error: No DB connection.');
15
+		}
14 16
 	}
15 17
 
16 18
 	/**
@@ -32,7 +34,9 @@  discard block
 block discarded – undo
32 34
 		if (isset($filter[0]['source'])) {
33 35
 			$filters = array_merge($filters,$filter);
34 36
 		}
35
-		if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter);
37
+		if (is_array($globalFilter)) {
38
+			$filter = array_merge($filter,$globalFilter);
39
+		}
36 40
 		$filter_query_join = '';
37 41
 		$filter_query_where = '';
38 42
 		foreach($filters as $flt) {
@@ -71,8 +75,11 @@  discard block
 block discarded – undo
71 75
 				$filter_query_where .= " AND EXTRACT(DAY FROM tracker_output.date) = '".$filter['day']."'";
72 76
 			}
73 77
 		}
74
-		if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE';
75
-		elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND';
78
+		if ($filter_query_where == '' && $where) {
79
+			$filter_query_where = ' WHERE';
80
+		} elseif ($filter_query_where != '' && $and) {
81
+			$filter_query_where .= ' AND';
82
+		}
76 83
 		if ($filter_query_where != '') {
77 84
 			$filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where);
78 85
 		}
@@ -126,26 +133,43 @@  discard block
 block discarded – undo
126 133
 				$temp_array['spotter_id'] = $row['spotter_archive_id'];
127 134
 			} elseif (isset($row['spotter_archive_output_id'])) {
128 135
 				$temp_array['spotter_id'] = $row['spotter_archive_output_id'];
129
-			*/} 
130
-			elseif (isset($row['trackerid'])) {
136
+			*/} elseif (isset($row['trackerid'])) {
131 137
 				$temp_array['trackerid'] = $row['trackerid'];
132 138
 			} else {
133 139
 				$temp_array['trackerid'] = '';
134 140
 			}
135
-			if (isset($row['famtrackid'])) $temp_array['famtrackid'] = $row['famtrackid'];
136
-			if (isset($row['type'])) $temp_array['type'] = $row['type'];
137
-			if (isset($row['comment'])) $temp_array['comment'] = $row['comment'];
141
+			if (isset($row['famtrackid'])) {
142
+				$temp_array['famtrackid'] = $row['famtrackid'];
143
+			}
144
+			if (isset($row['type'])) {
145
+				$temp_array['type'] = $row['type'];
146
+			}
147
+			if (isset($row['comment'])) {
148
+				$temp_array['comment'] = $row['comment'];
149
+			}
138 150
 			$temp_array['ident'] = $row['ident'];
139
-			if (isset($row['latitude'])) $temp_array['latitude'] = $row['latitude'];
140
-			if (isset($row['longitude'])) $temp_array['longitude'] = $row['longitude'];
141
-			if (isset($row['format_source'])) $temp_array['format_source'] = $row['format_source'];
142
-			if (isset($row['altitude'])) $temp_array['altitude'] = $row['altitude'];
151
+			if (isset($row['latitude'])) {
152
+				$temp_array['latitude'] = $row['latitude'];
153
+			}
154
+			if (isset($row['longitude'])) {
155
+				$temp_array['longitude'] = $row['longitude'];
156
+			}
157
+			if (isset($row['format_source'])) {
158
+				$temp_array['format_source'] = $row['format_source'];
159
+			}
160
+			if (isset($row['altitude'])) {
161
+				$temp_array['altitude'] = $row['altitude'];
162
+			}
143 163
 			if (isset($row['heading'])) {
144 164
 				$temp_array['heading'] = $row['heading'];
145 165
 				$heading_direction = $this->parseDirection($row['heading']);
146
-				if (isset($heading_direction[0]['direction_fullname'])) $temp_array['heading_name'] = $heading_direction[0]['direction_fullname'];
166
+				if (isset($heading_direction[0]['direction_fullname'])) {
167
+					$temp_array['heading_name'] = $heading_direction[0]['direction_fullname'];
168
+				}
169
+			}
170
+			if (isset($row['ground_speed'])) {
171
+				$temp_array['ground_speed'] = $row['ground_speed'];
147 172
 			}
148
-			if (isset($row['ground_speed'])) $temp_array['ground_speed'] = $row['ground_speed'];
149 173
 			
150 174
 			if (isset($row['date'])) {
151 175
 				$dateArray = $this->parseDateString($row['date']);
@@ -188,13 +212,21 @@  discard block
 block discarded – undo
188 212
 			}
189 213
 			
190 214
 			$fromsource = NULL;
191
-			if (isset($row['source_name']) && $row['source_name'] != '') $temp_array['source_name'] = $row['source_name'];
192
-			if (isset($row['over_country']) && $row['over_country'] != '') $temp_array['over_country'] = $row['over_country'];
193
-			if (isset($row['distance']) && $row['distance'] != '') $temp_array['distance'] = $row['distance'];
215
+			if (isset($row['source_name']) && $row['source_name'] != '') {
216
+				$temp_array['source_name'] = $row['source_name'];
217
+			}
218
+			if (isset($row['over_country']) && $row['over_country'] != '') {
219
+				$temp_array['over_country'] = $row['over_country'];
220
+			}
221
+			if (isset($row['distance']) && $row['distance'] != '') {
222
+				$temp_array['distance'] = $row['distance'];
223
+			}
194 224
 			$temp_array['query_number_rows'] = $num_rows;
195 225
 			$spotter_array[] = $temp_array;
196 226
 		}
197
-		if ($num_rows == 0) return array();
227
+		if ($num_rows == 0) {
228
+			return array();
229
+		}
198 230
 		$spotter_array[0]['query_number_rows'] = $num_rows;
199 231
 		return $spotter_array;
200 232
 	}	
@@ -225,8 +257,12 @@  discard block
 block discarded – undo
225 257
 			{
226 258
 				//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1];
227 259
 				$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0];
228
-			} else $limit_query = "";
229
-		} else $limit_query = "";
260
+			} else {
261
+				$limit_query = "";
262
+			}
263
+		} else {
264
+			$limit_query = "";
265
+		}
230 266
 		
231 267
 		if ($sort != "")
232 268
 		{
@@ -254,7 +290,9 @@  discard block
 block discarded – undo
254 290
 		global $global_query;
255 291
 		
256 292
 		date_default_timezone_set('UTC');
257
-		if ($id == '') return array();
293
+		if ($id == '') {
294
+			return array();
295
+		}
258 296
 		$additional_query = "tracker_output.famtrackid = :id";
259 297
 		$query_values = array(':id' => $id);
260 298
 		$query  = $global_query." WHERE ".$additional_query." ";
@@ -397,8 +435,11 @@  discard block
 block discarded – undo
397 435
 		$query .= " ORDER BY tracker_output.source_name ASC";
398 436
 
399 437
 		$sth = $this->db->prepare($query);
400
-		if (!empty($query_values)) $sth->execute($query_values);
401
-		else $sth->execute();
438
+		if (!empty($query_values)) {
439
+			$sth->execute($query_values);
440
+		} else {
441
+			$sth->execute();
442
+		}
402 443
 
403 444
 		$source_array = array();
404 445
 		$temp_array = array();
@@ -453,7 +494,9 @@  discard block
 block discarded – undo
453 494
 			date_default_timezone_set($globalTimezone);
454 495
 			$datetime = new DateTime();
455 496
 			$offset = $datetime->format('P');
456
-		} else $offset = '+00:00';
497
+		} else {
498
+			$offset = '+00:00';
499
+		}
457 500
 
458 501
 		if ($globalDBdriver == 'mysql') {
459 502
 			$query  = "SELECT DISTINCT DATE(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) as date
@@ -609,7 +652,9 @@  discard block
 block discarded – undo
609 652
 			{
610 653
 				return false;
611 654
 			}
612
-		} else $altitude = 0;
655
+		} else {
656
+			$altitude = 0;
657
+		}
613 658
 		
614 659
 		if ($heading != "")
615 660
 		{
@@ -648,8 +693,12 @@  discard block
 block discarded – undo
648 693
             		$latitude = 0;
649 694
             		$longitude = 0;
650 695
             	}
651
-                if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0;
652
-                if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0;
696
+                if ($heading == '' || $Common->isInteger($heading) === false) {
697
+                	$heading = 0;
698
+                }
699
+                if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) {
700
+                	$groundspeed = 0;
701
+                }
653 702
                 $query  = "INSERT INTO tracker_output (famtrackid, ident, latitude, longitude, altitude, heading, ground_speed, date, format_source, source_name, comment, type) 
654 703
                 VALUES (:famtrackid,:ident,:latitude,:longitude,:altitude,:heading,:speed,:date,:format_source, :source_name,:comment,:type)";
655 704
 
@@ -758,7 +807,9 @@  discard block
 block discarded – undo
758 807
 		global $globalDBdriver, $globalArchive;
759 808
 		//$filter_query = $this->getFilter($filters,true,true);
760 809
 		$Connection= new Connection($this->db);
761
-		if (!$Connection->tableExists('countries')) return array();
810
+		if (!$Connection->tableExists('countries')) {
811
+			return array();
812
+		}
762 813
 		if (!isset($globalArchive) || $globalArchive !== TRUE) {
763 814
 			require_once('class.TrackerLive.php');
764 815
 			$TrackerLive = new TrackerLive($this->db);
@@ -801,7 +852,9 @@  discard block
 block discarded – undo
801 852
 			$query = "SELECT c.name, c.iso3, c.iso2, count(c.name) as nb FROM countries c INNER JOIN (SELECT DISTINCT famtrackid,over_country FROM tracker_archive".$filter_query.") l ON c.iso2 = l.over_country ";
802 853
 		}
803 854
 		$query .= "GROUP BY c.name,c.iso3,c.iso2 ORDER BY nb DESC";
804
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
855
+		if ($limit) {
856
+			$query .= " LIMIT 10 OFFSET 0";
857
+		}
805 858
       
806 859
 		
807 860
 		$sth = $this->db->prepare($query);
@@ -834,12 +887,18 @@  discard block
 block discarded – undo
834 887
 		$query  = "SELECT DISTINCT tracker_output.ident, COUNT(tracker_output.ident) AS callsign_icao_count 
835 888
                     FROM tracker_output".$filter_query." tracker_output.ident <> ''";
836 889
 		 if ($olderthanmonths > 0) {
837
-			if ($globalDBdriver == 'mysql') $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)';
838
-			else $query .= " AND tracker_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'";
890
+			if ($globalDBdriver == 'mysql') {
891
+				$query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)';
892
+			} else {
893
+				$query .= " AND tracker_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'";
894
+			}
839 895
 		}
840 896
 		if ($sincedate != '') {
841
-			if ($globalDBdriver == 'mysql') $query .= " AND tracker_output.date > '".$sincedate."'";
842
-			else $query .= " AND tracker_output.date > CAST('".$sincedate."' AS TIMESTAMP)";
897
+			if ($globalDBdriver == 'mysql') {
898
+				$query .= " AND tracker_output.date > '".$sincedate."'";
899
+			} else {
900
+				$query .= " AND tracker_output.date > CAST('".$sincedate."' AS TIMESTAMP)";
901
+			}
843 902
 		}
844 903
 		$query_values = array();
845 904
 		if ($year != '') {
@@ -870,7 +929,9 @@  discard block
 block discarded – undo
870 929
 			}
871 930
 		}
872 931
 		$query .= " GROUP BY tracker_output.ident ORDER BY callsign_icao_count DESC";
873
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
932
+		if ($limit) {
933
+			$query .= " LIMIT 10 OFFSET 0";
934
+		}
874 935
       		
875 936
 		$sth = $this->db->prepare($query);
876 937
 		$sth->execute($query_values);
@@ -905,7 +966,9 @@  discard block
 block discarded – undo
905 966
 			date_default_timezone_set($globalTimezone);
906 967
 			$datetime = new DateTime();
907 968
 			$offset = $datetime->format('P');
908
-		} else $offset = '+00:00';
969
+		} else {
970
+			$offset = '+00:00';
971
+		}
909 972
 
910 973
 		if ($globalDBdriver == 'mysql') {
911 974
 			$query  = "SELECT DATE(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -955,7 +1018,9 @@  discard block
 block discarded – undo
955 1018
 			date_default_timezone_set($globalTimezone);
956 1019
 			$datetime = new DateTime();
957 1020
 			$offset = $datetime->format('P');
958
-		} else $offset = '+00:00';
1021
+		} else {
1022
+			$offset = '+00:00';
1023
+		}
959 1024
 		$filter_query = $this->getFilter($filters,true,true);
960 1025
 		if ($globalDBdriver == 'mysql') {
961 1026
 			$query  = "SELECT DATE(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1001,7 +1066,9 @@  discard block
 block discarded – undo
1001 1066
 			date_default_timezone_set($globalTimezone);
1002 1067
 			$datetime = new DateTime();
1003 1068
 			$offset = $datetime->format('P');
1004
-		} else $offset = '+00:00';
1069
+		} else {
1070
+			$offset = '+00:00';
1071
+		}
1005 1072
 		$filter_query = $this->getFilter($filters,true,true);
1006 1073
 		if ($globalDBdriver == 'mysql') {
1007 1074
 			$query  = "SELECT DATE(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1049,7 +1116,9 @@  discard block
 block discarded – undo
1049 1116
 			date_default_timezone_set($globalTimezone);
1050 1117
 			$datetime = new DateTime();
1051 1118
 			$offset = $datetime->format('P');
1052
-		} else $offset = '+00:00';
1119
+		} else {
1120
+			$offset = '+00:00';
1121
+		}
1053 1122
 
1054 1123
 		if ($globalDBdriver == 'mysql') {
1055 1124
 			$query  = "SELECT YEAR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS year_name,MONTH(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS month_name, count(*) as date_count
@@ -1098,7 +1167,9 @@  discard block
 block discarded – undo
1098 1167
 			date_default_timezone_set($globalTimezone);
1099 1168
 			$datetime = new DateTime();
1100 1169
 			$offset = $datetime->format('P');
1101
-		} else $offset = '+00:00';
1170
+		} else {
1171
+			$offset = '+00:00';
1172
+		}
1102 1173
 		$filter_query = $this->getFilter($filters,true,true);
1103 1174
 		if ($globalDBdriver == 'mysql') {
1104 1175
 			$query  = "SELECT MONTH(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS month_name, YEAR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS year_name, count(*) as date_count
@@ -1147,7 +1218,9 @@  discard block
 block discarded – undo
1147 1218
 			date_default_timezone_set($globalTimezone);
1148 1219
 			$datetime = new DateTime();
1149 1220
 			$offset = $datetime->format('P');
1150
-		} else $offset = '+00:00';
1221
+		} else {
1222
+			$offset = '+00:00';
1223
+		}
1151 1224
 
1152 1225
 		$orderby_sql = '';
1153 1226
 		if ($orderby == "hour")
@@ -1216,7 +1289,9 @@  discard block
 block discarded – undo
1216 1289
 			date_default_timezone_set($globalTimezone);
1217 1290
 			$datetime = new DateTime($date);
1218 1291
 			$offset = $datetime->format('P');
1219
-		} else $offset = '+00:00';
1292
+		} else {
1293
+			$offset = '+00:00';
1294
+		}
1220 1295
 
1221 1296
 		if ($globalDBdriver == 'mysql') {
1222 1297
 			$query  = "SELECT HOUR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1264,7 +1339,9 @@  discard block
 block discarded – undo
1264 1339
 			date_default_timezone_set($globalTimezone);
1265 1340
 			$datetime = new DateTime();
1266 1341
 			$offset = $datetime->format('P');
1267
-		} else $offset = '+00:00';
1342
+		} else {
1343
+			$offset = '+00:00';
1344
+		}
1268 1345
 
1269 1346
 		if ($globalDBdriver == 'mysql') {
1270 1347
 			$query  = "SELECT HOUR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1329,8 +1406,11 @@  discard block
 block discarded – undo
1329 1406
 				$query_values = array_merge($query_values,array(':month' => $month));
1330 1407
 			}
1331 1408
 		}
1332
-		if (empty($query_values)) $queryi .= $this->getFilter($filters);
1333
-		else $queryi .= $this->getFilter($filters,true,true).substr($query,4);
1409
+		if (empty($query_values)) {
1410
+			$queryi .= $this->getFilter($filters);
1411
+		} else {
1412
+			$queryi .= $this->getFilter($filters,true,true).substr($query,4);
1413
+		}
1334 1414
 		
1335 1415
 		$sth = $this->db->prepare($queryi);
1336 1416
 		$sth->execute($query_values);
@@ -1367,8 +1447,11 @@  discard block
 block discarded – undo
1367 1447
 				$query_values = array_merge($query_values,array(':month' => $month));
1368 1448
 			}
1369 1449
 		}
1370
-		if (empty($query_values)) $queryi .= $this->getFilter($filters);
1371
-		else $queryi .= $this->getFilter($filters,true,true).substr($query,4);
1450
+		if (empty($query_values)) {
1451
+			$queryi .= $this->getFilter($filters);
1452
+		} else {
1453
+			$queryi .= $this->getFilter($filters,true,true).substr($query,4);
1454
+		}
1372 1455
 		
1373 1456
 		$sth = $this->db->prepare($queryi);
1374 1457
 		$sth->execute($query_values);
@@ -1390,7 +1473,9 @@  discard block
 block discarded – undo
1390 1473
 			date_default_timezone_set($globalTimezone);
1391 1474
 			$datetime = new DateTime();
1392 1475
 			$offset = $datetime->format('P');
1393
-		} else $offset = '+00:00';
1476
+		} else {
1477
+			$offset = '+00:00';
1478
+		}
1394 1479
 
1395 1480
 		if ($globalDBdriver == 'mysql') {
1396 1481
 			$query  = "SELECT HOUR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1494,7 +1579,9 @@  discard block
 block discarded – undo
1494 1579
 	*/
1495 1580
 	public function parseDirection($direction = 0)
1496 1581
 	{
1497
-		if ($direction == '') $direction = 0;
1582
+		if ($direction == '') {
1583
+			$direction = 0;
1584
+		}
1498 1585
 		$direction_array = array();
1499 1586
 		$temp_array = array();
1500 1587
 
@@ -1583,7 +1670,9 @@  discard block
 block discarded – undo
1583 1670
 		$longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
1584 1671
 	
1585 1672
 		$Connection = new Connection($this->db);
1586
-		if (!$Connection->tableExists('countries')) return '';
1673
+		if (!$Connection->tableExists('countries')) {
1674
+			return '';
1675
+		}
1587 1676
 	
1588 1677
 		try {
1589 1678
 			/*
@@ -1603,9 +1692,13 @@  discard block
 block discarded – undo
1603 1692
 			$sth->closeCursor();
1604 1693
 			if (count($row) > 0) {
1605 1694
 				return $row;
1606
-			} else return '';
1695
+			} else {
1696
+				return '';
1697
+			}
1607 1698
 		} catch (PDOException $e) {
1608
-			if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n";
1699
+			if (isset($globalDebug) && $globalDebug) {
1700
+				echo 'Error : '.$e->getMessage()."\n";
1701
+			}
1609 1702
 			return '';
1610 1703
 		}
1611 1704
 	
@@ -1623,7 +1716,9 @@  discard block
 block discarded – undo
1623 1716
 		$iso2 = filter_var($iso2,FILTER_SANITIZE_STRING);
1624 1717
 	
1625 1718
 		$Connection = new Connection($this->db);
1626
-		if (!$Connection->tableExists('countries')) return '';
1719
+		if (!$Connection->tableExists('countries')) {
1720
+			return '';
1721
+		}
1627 1722
 	
1628 1723
 		try {
1629 1724
 			$query = "SELECT name,iso2,iso3 FROM countries WHERE iso2 = :iso2 LIMIT 1";
@@ -1635,9 +1730,13 @@  discard block
 block discarded – undo
1635 1730
 			$sth->closeCursor();
1636 1731
 			if (count($row) > 0) {
1637 1732
 				return $row;
1638
-			} else return '';
1733
+			} else {
1734
+				return '';
1735
+			}
1639 1736
 		} catch (PDOException $e) {
1640
-			if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n";
1737
+			if (isset($globalDebug) && $globalDebug) {
1738
+				echo 'Error : '.$e->getMessage()."\n";
1739
+			}
1641 1740
 			return '';
1642 1741
 		}
1643 1742
 	
@@ -1698,7 +1797,9 @@  discard block
 block discarded – undo
1698 1797
 			}
1699 1798
 		}
1700 1799
 		$query .= " GROUP BY tracker_output.type ORDER BY tracker_type_count DESC";
1701
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
1800
+		if ($limit) {
1801
+			$query .= " LIMIT 10 OFFSET 0";
1802
+		}
1702 1803
 		$sth = $this->db->prepare($query);
1703 1804
 		$sth->execute($query_values);
1704 1805
 		$tracker_array = array();
@@ -1725,7 +1826,9 @@  discard block
 block discarded – undo
1725 1826
 	{
1726 1827
 		global $globalBitlyAccessToken;
1727 1828
 		
1728
-		if ($globalBitlyAccessToken == '') return $url;
1829
+		if ($globalBitlyAccessToken == '') {
1830
+			return $url;
1831
+		}
1729 1832
         
1730 1833
 		$google_url = 'https://api-ssl.bitly.com/v3/shorten?access_token='.$globalBitlyAccessToken.'&longUrl='.$url;
1731 1834
 		
Please login to merge, or discard this patch.
live-geojson.php 1 patch
Braces   +288 added lines, -113 removed lines patch added patch discarded remove patch
@@ -48,27 +48,52 @@  discard block
 block discarded – undo
48 48
 }
49 49
 header('Content-Type: text/javascript');
50 50
 
51
-if (!isset($globalJsonCompress)) $compress = true;
52
-else $compress = $globalJsonCompress;
51
+if (!isset($globalJsonCompress)) {
52
+	$compress = true;
53
+} else {
54
+	$compress = $globalJsonCompress;
55
+}
53 56
 
54 57
 $from_archive = false;
55 58
 $min = true;
56 59
 $allhistory = false;
57 60
 $filter['source'] = array();
58
-if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalVATSIM) && $globalVATSIM && isset($_COOKIE['filter_ShowVATSIM']) && $_COOKIE['filter_ShowVATSIM'] == 'true') $filter['source'] = array_merge($filter['source'],array('vatsimtxt'));
59
-if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalIVAO) && $globalIVAO && isset($_COOKIE['filter_ShowIVAO']) && $_COOKIE['filter_ShowIVAO'] == 'true') $filter['source'] = array_merge($filter['source'],array('whazzup'));
60
-if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalphpVMS) && $globalphpVMS && isset($_COOKIE['filter_ShowVMS']) && $_COOKIE['filter_ShowVMS'] == 'true') $filter['source'] = array_merge($filter['source'],array('phpvmacars'));
61
-if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalSBS1) && $globalSBS1 && isset($_COOKIE['filter_ShowSBS1']) && $_COOKIE['filter_ShowSBS1'] == 'true') $filter['source'] = array_merge($filter['source'],array('sbs','famaprs'));
62
-if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalAPRS) && $globalAPRS && isset($_COOKIE['filter_ShowAPRS']) && $_COOKIE['filter_ShowAPRS'] == 'true') $filter['source'] = array_merge($filter['source'],array('aprs'));
63
-if (isset($_COOKIE['filter_ident']) && $_COOKIE['filter_ident'] != '') $filter['ident'] = filter_var($_COOKIE['filter_ident'],FILTER_SANITIZE_STRING);
64
-if (isset($_COOKIE['filter_Airlines']) && $_COOKIE['filter_Airlines'] != '') $filter['airlines'] = filter_var_array(explode(',',$_COOKIE['filter_Airlines']),FILTER_SANITIZE_STRING);
65
-if (isset($_COOKIE['filter_Sources']) && $_COOKIE['filter_Sources'] != '') $filter['source_aprs'] = filter_var_array(explode(',',$_COOKIE['filter_Sources']),FILTER_SANITIZE_STRING);
66
-if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] != 'all') $filter['airlinestype'] = filter_var($_COOKIE['filter_airlinestype'],FILTER_SANITIZE_STRING);
67
-if (isset($_COOKIE['filter_alliance']) && $_COOKIE['filter_alliance'] != 'all') $filter['alliance'] = filter_var($_COOKIE['filter_alliance'],FILTER_SANITIZE_STRING);
61
+if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalVATSIM) && $globalVATSIM && isset($_COOKIE['filter_ShowVATSIM']) && $_COOKIE['filter_ShowVATSIM'] == 'true') {
62
+	$filter['source'] = array_merge($filter['source'],array('vatsimtxt'));
63
+}
64
+if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalIVAO) && $globalIVAO && isset($_COOKIE['filter_ShowIVAO']) && $_COOKIE['filter_ShowIVAO'] == 'true') {
65
+	$filter['source'] = array_merge($filter['source'],array('whazzup'));
66
+}
67
+if ((!isset($globalMapVAchoose) || $globalMapVAchoose) && isset($globalphpVMS) && $globalphpVMS && isset($_COOKIE['filter_ShowVMS']) && $_COOKIE['filter_ShowVMS'] == 'true') {
68
+	$filter['source'] = array_merge($filter['source'],array('phpvmacars'));
69
+}
70
+if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalSBS1) && $globalSBS1 && isset($_COOKIE['filter_ShowSBS1']) && $_COOKIE['filter_ShowSBS1'] == 'true') {
71
+	$filter['source'] = array_merge($filter['source'],array('sbs','famaprs'));
72
+}
73
+if ((!isset($globalMapchoose) || $globalMapchoose) && isset($globalAPRS) && $globalAPRS && isset($_COOKIE['filter_ShowAPRS']) && $_COOKIE['filter_ShowAPRS'] == 'true') {
74
+	$filter['source'] = array_merge($filter['source'],array('aprs'));
75
+}
76
+if (isset($_COOKIE['filter_ident']) && $_COOKIE['filter_ident'] != '') {
77
+	$filter['ident'] = filter_var($_COOKIE['filter_ident'],FILTER_SANITIZE_STRING);
78
+}
79
+if (isset($_COOKIE['filter_Airlines']) && $_COOKIE['filter_Airlines'] != '') {
80
+	$filter['airlines'] = filter_var_array(explode(',',$_COOKIE['filter_Airlines']),FILTER_SANITIZE_STRING);
81
+}
82
+if (isset($_COOKIE['filter_Sources']) && $_COOKIE['filter_Sources'] != '') {
83
+	$filter['source_aprs'] = filter_var_array(explode(',',$_COOKIE['filter_Sources']),FILTER_SANITIZE_STRING);
84
+}
85
+if (isset($_COOKIE['filter_airlinestype']) && $_COOKIE['filter_airlinestype'] != 'all') {
86
+	$filter['airlinestype'] = filter_var($_COOKIE['filter_airlinestype'],FILTER_SANITIZE_STRING);
87
+}
88
+if (isset($_COOKIE['filter_alliance']) && $_COOKIE['filter_alliance'] != 'all') {
89
+	$filter['alliance'] = filter_var($_COOKIE['filter_alliance'],FILTER_SANITIZE_STRING);
90
+}
68 91
 
69 92
 if (isset($globalMapPopup) && !$globalMapPopup && !(isset($_COOKIE['flightpopup']) && $_COOKIE['flightpopup'] == 'true')) {
70 93
 	$min = true;
71
-} else $min = false;
94
+} else {
95
+	$min = false;
96
+}
72 97
 
73 98
 if (isset($_GET['ident'])) {
74 99
 	$ident = urldecode(filter_input(INPUT_GET,'ident',FILTER_SANITIZE_STRING));
@@ -162,20 +187,30 @@  discard block
 block discarded – undo
162 187
 			$flightcnt = $SpotterLive->getLiveSpotterCount($filter);
163 188
 		}
164 189
 	}
165
-	if ($flightcnt == '') $flightcnt = 0;
166
-} else $flightcnt = 0;
190
+	if ($flightcnt == '') {
191
+		$flightcnt = 0;
192
+	}
193
+	} else {
194
+	$flightcnt = 0;
195
+}
167 196
 
168 197
 $sqltime = round(microtime(true)-$begintime,2);
169 198
 
170
-if ((!isset($_COOKIE['flightestimation']) && isset($globalMapEstimation) && $globalMapEstimation == FALSE) || (isset($_COOKIE['flightestimation']) && $_COOKIE['flightestimation'] == 'false')) $usenextlatlon = false;
171
-else $usenextlatlon = true;
199
+if ((!isset($_COOKIE['flightestimation']) && isset($globalMapEstimation) && $globalMapEstimation == FALSE) || (isset($_COOKIE['flightestimation']) && $_COOKIE['flightestimation'] == 'false')) {
200
+	$usenextlatlon = false;
201
+} else {
202
+	$usenextlatlon = true;
203
+}
172 204
 $j = 0;
173 205
 $prev_flightaware_id = '';
174 206
 $aircrafts_shadow = array();
175 207
 $output = '{';
176 208
 	$output .= '"type": "FeatureCollection",';
177
-		if ($min) $output .= '"minimal": "true",';
178
-		else $output .= '"minimal": "false",';
209
+		if ($min) {
210
+			$output .= '"minimal": "true",';
211
+		} else {
212
+			$output .= '"minimal": "false",';
213
+		}
179 214
 		//$output .= '"fc": "'.$flightcnt.'",';
180 215
 		$output .= '"sqt": "'.$sqltime.'",';
181 216
 
@@ -219,18 +254,29 @@  discard block
 block discarded – undo
219 254
 						}
220 255
 						$output .= '"properties": {';
221 256
 						if (isset($spotter_item['flightaware_id'])) {
222
-							if ($compress) $output .= '"fi": "'.$spotter_item['flightaware_id'].'",';
223
-							else $output .= '"flightaware_id": "'.$spotter_item['flightaware_id'].'",';
257
+							if ($compress) {
258
+								$output .= '"fi": "'.$spotter_item['flightaware_id'].'",';
259
+							} else {
260
+								$output .= '"flightaware_id": "'.$spotter_item['flightaware_id'].'",';
261
+							}
224 262
 						} elseif (isset($spotter_item['famtrackid'])) {
225
-							if ($compress) $output .= '"fti": "'.$spotter_item['famtrackid'].'",';
226
-							else $output .= '"famtrackid": "'.$spotter_item['famtrackid'].'",';
263
+							if ($compress) {
264
+								$output .= '"fti": "'.$spotter_item['famtrackid'].'",';
265
+							} else {
266
+								$output .= '"famtrackid": "'.$spotter_item['famtrackid'].'",';
267
+							}
227 268
 						} elseif (isset($spotter_item['fammarine_id'])) {
228
-							if ($compress) $output .= '"fmi": "'.$spotter_item['fammarine_id'].'",';
229
-							else $output .= '"fammarineid": "'.$spotter_item['fammarine_id'].'",';
269
+							if ($compress) {
270
+								$output .= '"fmi": "'.$spotter_item['fammarine_id'].'",';
271
+							} else {
272
+								$output .= '"fammarineid": "'.$spotter_item['fammarine_id'].'",';
273
+							}
230 274
 						}
231 275
 							$output .= '"fc": "'.$flightcnt.'",';
232 276
 							$output .= '"sqt": "'.$sqltime.'",';
233
-							if (isset($begindate)) $output .= '"archive_date": "'.$begindate.'",';
277
+							if (isset($begindate)) {
278
+								$output .= '"archive_date": "'.$begindate.'",';
279
+							}
234 280
 
235 281
 /*
236 282
 							if ($min) $output .= '"minimal": "true",';
@@ -238,14 +284,22 @@  discard block
 block discarded – undo
238 284
 */
239 285
 							//$output .= '"fc": "'.$spotter_item['nb'].'",';
240 286
 						if (isset($spotter_item['ident']) && $spotter_item['ident'] != '') {
241
-							if ($compress) $output .= '"c": "'.str_replace('\\','',$spotter_item['ident']).'",';
242
-							else $output .= '"callsign": "'.str_replace('\\','',$spotter_item['ident']).'",';
287
+							if ($compress) {
288
+								$output .= '"c": "'.str_replace('\\','',$spotter_item['ident']).'",';
289
+							} else {
290
+								$output .= '"callsign": "'.str_replace('\\','',$spotter_item['ident']).'",';
291
+							}
243 292
 							//"
244 293
 						} else {
245
-							if ($compress) $output .= '"c": "NA",';
246
-							else $output .= '"callsign": "NA",';
294
+							if ($compress) {
295
+								$output .= '"c": "NA",';
296
+							} else {
297
+								$output .= '"callsign": "NA",';
298
+							}
299
+						}
300
+						if (isset($spotter_item['registration'])) {
301
+							$output .= '"registration": "'.$spotter_item['registration'].'",';
247 302
 						}
248
-						if (isset($spotter_item['registration'])) $output .= '"registration": "'.$spotter_item['registration'].'",';
249 303
 						if (isset($spotter_item['aircraft_name']) && isset($spotter_item['aircraft_type'])) {
250 304
 							$output .= '"aircraft_name": "'.$spotter_item['aircraft_name'].' ('.$spotter_item['aircraft_type'].')",';
251 305
 							$output .= '"aircraft_wiki": "http://'.strtolower($globalLanguage).'.wikipedia.org/wiki/'.urlencode(str_replace(' ','_',$spotter_item['aircraft_name'])).'",';
@@ -258,16 +312,23 @@  discard block
 block discarded – undo
258 312
 							$output .= '"aircraft_icao": "'.$spotter_item['aircraft_icao'].'",';
259 313
 						}
260 314
 						if (!isset($spotter_item['aircraft_shadow']) && !$tracker) {
261
-							if (!isset($spotter_item['aircraft_icao']) || $spotter_item['aircraft_icao'] == '') $spotter_item['aircraft_shadow'] = '';
262
-							else {
315
+							if (!isset($spotter_item['aircraft_icao']) || $spotter_item['aircraft_icao'] == '') {
316
+								$spotter_item['aircraft_shadow'] = '';
317
+							} else {
263 318
 								$aircraft_icao = $spotter_item['aircraft_icao'];
264
-								if (isset($aircrafts_shadow[$aircraft_icao])) $spotter_item['aircraft_shadow'] = $aircrafts_shadow[$aircraft_icao];
265
-								else {
319
+								if (isset($aircrafts_shadow[$aircraft_icao])) {
320
+									$spotter_item['aircraft_shadow'] = $aircrafts_shadow[$aircraft_icao];
321
+								} else {
266 322
 									$aircraft_info = $Spotter->getAllAircraftInfo($spotter_item['aircraft_icao']);
267
-									if (count($aircraft_info) > 0) $spotter_item['aircraft_shadow'] = $aircraft_info[0]['aircraft_shadow'];
268
-									elseif (isset($spotter_item['format_source']) && $spotter_item['format_source'] == 'aprs') $spotter_item['aircraft_shadow'] = 'PA18.png';
269
-									elseif ($aircraft_icao == 'PARAGLIDER') $spotter_item['aircraft_shadow'] = 'PARAGLIDER.png';
270
-									else $spotter_item['aircraft_shadow'] = '';
323
+									if (count($aircraft_info) > 0) {
324
+										$spotter_item['aircraft_shadow'] = $aircraft_info[0]['aircraft_shadow'];
325
+									} elseif (isset($spotter_item['format_source']) && $spotter_item['format_source'] == 'aprs') {
326
+										$spotter_item['aircraft_shadow'] = 'PA18.png';
327
+									} elseif ($aircraft_icao == 'PARAGLIDER') {
328
+										$spotter_item['aircraft_shadow'] = 'PARAGLIDER.png';
329
+									} else {
330
+										$spotter_item['aircraft_shadow'] = '';
331
+									}
271 332
 									$aircrafts_shadow[$aircraft_icao] = $spotter_item['aircraft_shadow'];
272 333
 								}
273 334
 							}
@@ -275,73 +336,139 @@  discard block
 block discarded – undo
275 336
 						if (!isset($spotter_item['aircraft_shadow']) || $spotter_item['aircraft_shadow'] == '') {
276 337
 							if ($tracker) {
277 338
 								if (isset($spotter_item['type']) && $spotter_item['type'] == 'Ambulance') {
278
-									if ($compress) $output .= '"as": "ambulance.png",';
279
-									else $output .= '"aircraft_shadow": "ambulance.png",';
339
+									if ($compress) {
340
+										$output .= '"as": "ambulance.png",';
341
+									} else {
342
+										$output .= '"aircraft_shadow": "ambulance.png",';
343
+									}
280 344
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Police') {
281
-									if ($compress) $output .= '"as": "police.png",';
282
-									else $output .= '"aircraft_shadow": "police.png",';
345
+									if ($compress) {
346
+										$output .= '"as": "police.png",';
347
+									} else {
348
+										$output .= '"aircraft_shadow": "police.png",';
349
+									}
283 350
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Yacht (Sail)') {
284
-									if ($compress) $output .= '"as": "ship.png",';
285
-									else $output .= '"aircraft_shadow": "ship.png",';
351
+									if ($compress) {
352
+										$output .= '"as": "ship.png",';
353
+									} else {
354
+										$output .= '"aircraft_shadow": "ship.png",';
355
+									}
286 356
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Ship (Power Boat)') {
287
-									if ($compress) $output .= '"as": "ship.png",';
288
-									else $output .= '"aircraft_shadow": "ship.png",';
357
+									if ($compress) {
358
+										$output .= '"as": "ship.png",';
359
+									} else {
360
+										$output .= '"aircraft_shadow": "ship.png",';
361
+									}
289 362
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Shuttle') {
290
-									if ($compress) $output .= '"as": "ship.png",';
291
-									else $output .= '"aircraft_shadow": "ship.png",';
363
+									if ($compress) {
364
+										$output .= '"as": "ship.png",';
365
+									} else {
366
+										$output .= '"aircraft_shadow": "ship.png",';
367
+									}
292 368
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Truck') {
293
-									if ($compress) $output .= '"as": "truck.png",';
294
-									else $output .= '"aircraft_shadow": "truck.png",';
369
+									if ($compress) {
370
+										$output .= '"as": "truck.png",';
371
+									} else {
372
+										$output .= '"aircraft_shadow": "truck.png",';
373
+									}
295 374
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Truck (18 Wheeler)') {
296
-									if ($compress) $output .= '"as": "truck.png",';
297
-									else $output .= '"aircraft_shadow": "truck.png",';
375
+									if ($compress) {
376
+										$output .= '"as": "truck.png",';
377
+									} else {
378
+										$output .= '"aircraft_shadow": "truck.png",';
379
+									}
298 380
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Aircraft (small)') {
299
-									if ($compress) $output .= '"as": "aircraft.png",';
300
-									else $output .= '"aircraft_shadow": "aircraft.png",';
381
+									if ($compress) {
382
+										$output .= '"as": "aircraft.png",';
383
+									} else {
384
+										$output .= '"aircraft_shadow": "aircraft.png",';
385
+									}
301 386
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Large Aircraft') {
302
-									if ($compress) $output .= '"as": "aircraft.png",';
303
-									else $output .= '"aircraft_shadow": "aircraft.png",';
387
+									if ($compress) {
388
+										$output .= '"as": "aircraft.png",';
389
+									} else {
390
+										$output .= '"aircraft_shadow": "aircraft.png",';
391
+									}
304 392
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Helicopter') {
305
-									if ($compress) $output .= '"as": "helico.png",';
306
-									else $output .= '"aircraft_shadow": "helico.png",';
393
+									if ($compress) {
394
+										$output .= '"as": "helico.png",';
395
+									} else {
396
+										$output .= '"aircraft_shadow": "helico.png",';
397
+									}
307 398
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Railroad Engine') {
308
-									if ($compress) $output .= '"as": "rail.png",';
309
-									else $output .= '"aircraft_shadow": "rail.png",';
399
+									if ($compress) {
400
+										$output .= '"as": "rail.png",';
401
+									} else {
402
+										$output .= '"aircraft_shadow": "rail.png",';
403
+									}
310 404
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Firetruck') {
311
-									if ($compress) $output .= '"as": "firetruck.png",';
312
-									else $output .= '"aircraft_shadow": "firetruck.png",';
405
+									if ($compress) {
406
+										$output .= '"as": "firetruck.png",';
407
+									} else {
408
+										$output .= '"aircraft_shadow": "firetruck.png",';
409
+									}
313 410
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Bus') {
314
-									if ($compress) $output .= '"as": "bus.png",';
315
-									else $output .= '"aircraft_shadow": "bus.png",';
411
+									if ($compress) {
412
+										$output .= '"as": "bus.png",';
413
+									} else {
414
+										$output .= '"aircraft_shadow": "bus.png",';
415
+									}
316 416
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Phone') {
317
-									if ($compress) $output .= '"as": "phone.png",';
318
-									else $output .= '"aircraft_shadow": "phone.png",';
417
+									if ($compress) {
418
+										$output .= '"as": "phone.png",';
419
+									} else {
420
+										$output .= '"aircraft_shadow": "phone.png",';
421
+									}
319 422
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Jogger') {
320
-									if ($compress) $output .= '"as": "jogger.png",';
321
-									else $output .= '"aircraft_shadow": "jogger.png",';
423
+									if ($compress) {
424
+										$output .= '"as": "jogger.png",';
425
+									} else {
426
+										$output .= '"aircraft_shadow": "jogger.png",';
427
+									}
322 428
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Bike') {
323
-									if ($compress) $output .= '"as": "bike.png",';
324
-									else $output .= '"aircraft_shadow": "bike.png",';
429
+									if ($compress) {
430
+										$output .= '"as": "bike.png",';
431
+									} else {
432
+										$output .= '"aircraft_shadow": "bike.png",';
433
+									}
325 434
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Motorcycle') {
326
-									if ($compress) $output .= '"as": "motorcycle.png",';
327
-									else $output .= '"aircraft_shadow": "motorcycle.png",';
435
+									if ($compress) {
436
+										$output .= '"as": "motorcycle.png",';
437
+									} else {
438
+										$output .= '"aircraft_shadow": "motorcycle.png",';
439
+									}
328 440
 								} elseif (isset($spotter_item['type']) && $spotter_item['type'] == 'Balloon') {
329
-									if ($compress) $output .= '"as": "balloon.png",';
330
-									else $output .= '"aircraft_shadow": "balloon.png",';
441
+									if ($compress) {
442
+										$output .= '"as": "balloon.png",';
443
+									} else {
444
+										$output .= '"aircraft_shadow": "balloon.png",';
445
+									}
331 446
 								} else {
332
-									if ($compress) $output .= '"as": "car.png",';
333
-									else $output .= '"aircraft_shadow": "car.png",';
447
+									if ($compress) {
448
+										$output .= '"as": "car.png",';
449
+									} else {
450
+										$output .= '"aircraft_shadow": "car.png",';
451
+									}
334 452
 								}
335 453
 							} elseif ($marine) {
336
-								if ($compress) $output .= '"as": "ship.png",';
337
-								else $output .= '"aircraft_shadow": "ship.png",';
454
+								if ($compress) {
455
+									$output .= '"as": "ship.png",';
456
+								} else {
457
+									$output .= '"aircraft_shadow": "ship.png",';
458
+								}
338 459
 							} else {
339
-								if ($compress) $output .= '"as": "default.png",';
340
-								else $output .= '"aircraft_shadow": "default.png",';
460
+								if ($compress) {
461
+									$output .= '"as": "default.png",';
462
+								} else {
463
+									$output .= '"aircraft_shadow": "default.png",';
464
+								}
341 465
 							}
342 466
 						} else {
343
-							if ($compress) $output .= '"as": "'.$spotter_item['aircraft_shadow'].'",';
344
-							else $output .= '"aircraft_shadow": "'.$spotter_item['aircraft_shadow'].'",';
467
+							if ($compress) {
468
+								$output .= '"as": "'.$spotter_item['aircraft_shadow'].'",';
469
+							} else {
470
+								$output .= '"aircraft_shadow": "'.$spotter_item['aircraft_shadow'].'",';
471
+							}
345 472
 						}
346 473
 						if (isset($spotter_item['airline_name'])) {
347 474
 							$output .= '"airline_name": "'.$spotter_item['airline_name'].'",';
@@ -349,8 +476,11 @@  discard block
 block discarded – undo
349 476
 							$output .= '"airline_name": "NA",';
350 477
 						}
351 478
 						if (isset($spotter_item['departure_airport'])) {
352
-							if ($compress) $output .= '"dac": "'.$spotter_item['departure_airport'].'",';
353
-							else $output .= '"departure_airport_code": "'.$spotter_item['departure_airport'].'",';
479
+							if ($compress) {
480
+								$output .= '"dac": "'.$spotter_item['departure_airport'].'",';
481
+							} else {
482
+								$output .= '"departure_airport_code": "'.$spotter_item['departure_airport'].'",';
483
+							}
354 484
 						}
355 485
 						if (isset($spotter_item['departure_airport_city'])) {
356 486
 							$output .= '"departure_airport": "'.$spotter_item['departure_airport_city'].', '.$spotter_item['departure_airport_country'].'",';
@@ -362,8 +492,11 @@  discard block
 block discarded – undo
362 492
 							$output .= '"arrival_airport_time": "'.$spotter_item['arrival_airport_time'].'",';
363 493
 						}
364 494
 						if (isset($spotter_item['arrival_airport'])) {
365
-							if ($compress) $output .= '"aac": "'.$spotter_item['arrival_airport'].'",';
366
-							else $output .= '"arrival_airport_code": "'.$spotter_item['arrival_airport'].'",';
495
+							if ($compress) {
496
+								$output .= '"aac": "'.$spotter_item['arrival_airport'].'",';
497
+							} else {
498
+								$output .= '"arrival_airport_code": "'.$spotter_item['arrival_airport'].'",';
499
+							}
367 500
 						}
368 501
 						if (isset($spotter_item['arrival_airport_city'])) {
369 502
 							$output .= '"arrival_airport": "'.$spotter_item['arrival_airport_city'].', '.$spotter_item['arrival_airport_country'].'",';
@@ -382,11 +515,17 @@  discard block
 block discarded – undo
382 515
 						}
383 516
 						
384 517
 						if (isset($spotter_item['altitude'])) {
385
-							if ($compress) $output .= '"a": "'.$spotter_item['altitude'].'",';
386
-							else $output .= '"altitude": "'.$spotter_item['altitude'].'",';
518
+							if ($compress) {
519
+								$output .= '"a": "'.$spotter_item['altitude'].'",';
520
+							} else {
521
+								$output .= '"altitude": "'.$spotter_item['altitude'].'",';
522
+							}
523
+						}
524
+						if ($compress) {
525
+							$output .= '"h": "'.$spotter_item['heading'].'",';
526
+						} else {
527
+							$output .= '"heading": "'.$spotter_item['heading'].'",';
387 528
 						}
388
-						if ($compress)$output .= '"h": "'.$spotter_item['heading'].'",';
389
-						else $output .= '"heading": "'.$spotter_item['heading'].'",';
390 529
 						
391 530
 						if (isset($archivespeed)) {
392 531
 							$nextcoord = $Common->nextcoord($spotter_item['latitude'],$spotter_item['longitude'],$spotter_item['ground_speed'],$spotter_item['heading'],$archivespeed);
@@ -396,7 +535,9 @@  discard block
 block discarded – undo
396 535
 							$output .= '"nextlatlon": ['.$nextcoord['latitude'].','.$nextcoord['longitude'].'],';
397 536
 						}
398 537
 
399
-						if (!$min) $output .= '"image": "'.$image.'",';
538
+						if (!$min) {
539
+							$output .= '"image": "'.$image.'",';
540
+						}
400 541
 						if (isset($spotter_item['image_copyright']) && $spotter_item['image_copyright'] != '') {
401 542
 							$output .= '"image_copyright": "'.str_replace('"',"'",trim(str_replace(array("\r\n","\r","\n","\\r","\\n","\\r\\n"),'',$spotter_item['image_copyright']))).'",';
402 543
 						}
@@ -404,8 +545,11 @@  discard block
 block discarded – undo
404 545
 							$output .= '"image_source_website": "'.urlencode($spotter_item['image_source_website']).'",';
405 546
 						}
406 547
 						if (isset($spotter_item['squawk'])) {
407
-							if ($compress) $output .= '"sq": "'.$spotter_item['squawk'].'",';
408
-							else $output .= '"squawk": "'.$spotter_item['squawk'].'",';
548
+							if ($compress) {
549
+								$output .= '"sq": "'.$spotter_item['squawk'].'",';
550
+							} else {
551
+								$output .= '"squawk": "'.$spotter_item['squawk'].'",';
552
+							}
409 553
 						}
410 554
 						if (isset($spotter_item['squawk_usage'])) {
411 555
 							$output .= '"squawk_usage": "'.$spotter_item['squawk_usage'].'",';
@@ -424,14 +568,23 @@  discard block
 block discarded – undo
424 568
 						}
425 569
 						// type when not aircraft ?
426 570
 						if (isset($spotter_item['type'])) {
427
-							if ($compress) $output .= '"t": "'.$spotter_item['type'].'"';
428
-							else $output .= '"type": "'.$spotter_item['type'].'"';
571
+							if ($compress) {
572
+								$output .= '"t": "'.$spotter_item['type'].'"';
573
+							} else {
574
+								$output .= '"type": "'.$spotter_item['type'].'"';
575
+							}
429 576
 						} elseif ($marine) {
430
-							if ($compress) $output .= '"t": "ship"';
431
-							else $output .= '"type": "ship"';
577
+							if ($compress) {
578
+								$output .= '"t": "ship"';
579
+							} else {
580
+								$output .= '"type": "ship"';
581
+							}
432 582
 						} else {
433
-							if ($compress) $output .= '"t": "aircraft"';
434
-							else $output .= '"type": "aircraft"';
583
+							if ($compress) {
584
+								$output .= '"t": "aircraft"';
585
+							} else {
586
+								$output .= '"type": "aircraft"';
587
+							}
435 588
 						}
436 589
 						$output .= '},';
437 590
 						$output .= '"geometry": {';
@@ -499,7 +652,9 @@  discard block
 block discarded – undo
499 652
 			}
500 653
 */
501 654
 				$history = filter_input(INPUT_GET,'history',FILTER_SANITIZE_STRING);
502
-				if ($history == '' && isset($_COOKIE['history'])) $history = $_COOKIE['history'];
655
+				if ($history == '' && isset($_COOKIE['history'])) {
656
+					$history = $_COOKIE['history'];
657
+				}
503 658
 				
504 659
 				if (
505 660
 				    (isset($_COOKIE['flightpath']) && $_COOKIE['flightpath'] == 'true') 
@@ -543,8 +698,11 @@  discard block
 block discarded – undo
543 698
 									$output_history .= ']}},';
544 699
 									$output .= $output_history;
545 700
 								}
546
-								if ($compress) $output_history = '{"type": "Feature","properties": {"c": "'.$spotter_item['ident'].'","t": "history","a": "'.$alt.'"},"geometry": {"type": "LineString","coordinates": [';
547
-								else $output_history = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['ident'].'","type": "history","altitude": "'.$alt.'"},"geometry": {"type": "LineString","coordinates": [';
701
+								if ($compress) {
702
+									$output_history = '{"type": "Feature","properties": {"c": "'.$spotter_item['ident'].'","t": "history","a": "'.$alt.'"},"geometry": {"type": "LineString","coordinates": [';
703
+								} else {
704
+									$output_history = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['ident'].'","type": "history","altitude": "'.$alt.'"},"geometry": {"type": "LineString","coordinates": [';
705
+								}
548 706
 							}
549 707
 							$output_history .= '[';
550 708
 							$output_history .=  $spotter_history['longitude'].', ';
@@ -563,9 +721,14 @@  discard block
 block discarded – undo
563 721
 							$prev_alt = $alt;
564 722
 						} else {
565 723
 							if ($d == false) {
566
-								if ($compress) $output_history = '{"type": "Feature","properties": {"c": "'.$spotter_item['ident'].'","t": "history"},"geometry": {"type": "LineString","coordinates": [';
567
-								else $output_history = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['ident'].'","type": "history"},"geometry": {"type": "LineString","coordinates": [';
568
-							} else $d = true;
724
+								if ($compress) {
725
+									$output_history = '{"type": "Feature","properties": {"c": "'.$spotter_item['ident'].'","t": "history"},"geometry": {"type": "LineString","coordinates": [';
726
+								} else {
727
+									$output_history = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['ident'].'","type": "history"},"geometry": {"type": "LineString","coordinates": [';
728
+								}
729
+							} else {
730
+								$d = true;
731
+							}
569 732
 							$output_history .= '[';
570 733
 							$output_history .=  $spotter_history['longitude'].', ';
571 734
 							$output_history .=  $spotter_history['latitude'];
@@ -586,7 +749,9 @@  discard block
 block discarded – undo
586 749
 							$output_historyd = '[';
587 750
 							$output_historyd .=  $spotter_item['longitude'].', ';
588 751
 							$output_historyd .=  $spotter_item['latitude'];
589
-							if (isset($spotter_history['altitude'])) $output_historyd .=  ','.$spotter_item['altitude']*30.48;
752
+							if (isset($spotter_history['altitude'])) {
753
+								$output_historyd .=  ','.$spotter_item['altitude']*30.48;
754
+							}
590 755
 							$output_historyd .= '],';
591 756
 							//$output_history = $output_historyd.$output_history;
592 757
 							$output_history = $output_history.$output_historyd;
@@ -608,8 +773,11 @@  discard block
 block discarded – undo
608 773
 				        && $spotter_item['arrival_airport'] != 'NA' 
609 774
 				        && ((isset($_COOKIE['MapRoute']) && $_COOKIE['MapRoute'] == "true") 
610 775
 				    	    || (!isset($_COOKIE['MapRoute']) && isset($globalMapRoute) && $globalMapRoute)))) {
611
-				    if ($compress) $output_air = '{"type": "Feature","properties": {"c": "'.$spotter_item['ident'].'","t": "route"},"geometry": {"type": "LineString","coordinates": [';
612
-				    else $output_air = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['ident'].'","type": "route"},"geometry": {"type": "LineString","coordinates": [';
776
+				    if ($compress) {
777
+				    	$output_air = '{"type": "Feature","properties": {"c": "'.$spotter_item['ident'].'","t": "route"},"geometry": {"type": "LineString","coordinates": [';
778
+				    } else {
779
+				    	$output_air = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['ident'].'","type": "route"},"geometry": {"type": "LineString","coordinates": [';
780
+				    }
613 781
 				    if (isset($spotter_item['departure_airport_latitude'])) {
614 782
 					$output_air .= '['.$spotter_item['departure_airport_longitude'].','.$spotter_item['departure_airport_latitude'].'],';
615 783
 				    } elseif (isset($spotter_item['departure_airport']) && $spotter_item['departure_airport'] != 'NA') {
@@ -642,8 +810,11 @@  discard block
 block discarded – undo
642 810
 				    	    || (!isset($_COOKIE['MapRemainaingRoute']) && (!isset($globalMapRemainingRoute) 
643 811
 				    	    || (isset($globalMapRemainingRoute) && $globalMapRemainingRoute)))))) {
644 812
 				    $havedata = false;
645
-				    if ($compress) $output_dest = '{"type": "Feature","properties": {"c": "'.$spotter_item['ident'].'","t": "routedest"},"geometry": {"type": "LineString","coordinates": [';
646
-				    else $output_dest = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['ident'].'","type": "routedest"},"geometry": {"type": "LineString","coordinates": [';
813
+				    if ($compress) {
814
+				    	$output_dest = '{"type": "Feature","properties": {"c": "'.$spotter_item['ident'].'","t": "routedest"},"geometry": {"type": "LineString","coordinates": [';
815
+				    } else {
816
+				    	$output_dest = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['ident'].'","type": "routedest"},"geometry": {"type": "LineString","coordinates": [';
817
+				    }
647 818
 				    $output_dest .= '['.$spotter_item['longitude'].','.$spotter_item['latitude'].'],';
648 819
 
649 820
 				    if (isset($spotter_item['arrival_airport_latitude'])) {
@@ -658,7 +829,9 @@  discard block
 block discarded – undo
658 829
 				    }
659 830
 				    //$output_dest  = substr($output_dest, 0, -1);
660 831
 				    $output_dest .= ']}},';
661
-				    if ($havedata) $output .= $output_dest;
832
+				    if ($havedata) {
833
+				    	$output .= $output_dest;
834
+				    }
662 835
 				    unset($output_dest);
663 836
 				}
664 837
 			}
@@ -666,7 +839,9 @@  discard block
 block discarded – undo
666 839
 			$output .= ']';
667 840
 			$output .= ',"initial_sqltime": "'.$sqltime.'",';
668 841
 			$output .= '"totaltime": "'.round(microtime(true)-$begintime,2).'",';
669
-			if (isset($begindate)) $output .= '"archive_date": "'.$begindate.'",';
842
+			if (isset($begindate)) {
843
+				$output .= '"archive_date": "'.$begindate.'",';
844
+			}
670 845
 			$output .= '"fc": "'.$j.'"';
671 846
 		} else {
672 847
 			$output .= '"features": ';
Please login to merge, or discard this patch.
js/map-aircraft.3d.js.php 1 patch
Braces   +24 added lines, -4 removed lines patch added patch discarded remove patch
@@ -218,7 +218,12 @@  discard block
 block discarded – undo
218 218
 			<?php
219 219
 			    } else {
220 220
 			?>
221
-			if (parseInt(lastupdateentity) < Math.floor(Date.now()-<?php if (isset($globalMapRefresh)) print $globalMapRefresh*2000; else print '60000'; ?>)) {
221
+			if (parseInt(lastupdateentity) < Math.floor(Date.now()-<?php if (isset($globalMapRefresh)) {
222
+	print $globalMapRefresh*2000;
223
+} else {
224
+	print '60000';
225
+}
226
+?>)) {
222 227
 				viewer.dataSources.get(dsn).entities.remove(entity);
223 228
 				czmlds.entities.removeById(entityid);
224 229
 			}
@@ -502,7 +507,12 @@  discard block
 block discarded – undo
502 507
 		if (!((isset($globalIVAO) && $globalIVAO) || (isset($globalVATSIM) && $globalVATSIM) || (isset($globalphpVMS) && $globalphpVMS)) && (isset($_COOKIE['polar']) && $_COOKIE['polar'] == 'true')) {
503 508
 ?>
504 509
 update_polarLayer();
505
-setInterval(function(){update_polarLayer()},<?php if (isset($globalMapRefresh)) print $globalMapRefresh*1000*2; else print '60000'; ?>);
510
+setInterval(function(){update_polarLayer()},<?php if (isset($globalMapRefresh)) {
511
+	print $globalMapRefresh*1000*2;
512
+} else {
513
+	print '60000';
514
+}
515
+?>);
506 516
 <?php
507 517
 		}
508 518
 ?>
@@ -613,7 +623,12 @@  discard block
 block discarded – undo
613 623
 				}
614 624
 			}
615 625
 		}
616
-	,<?php if (isset($globalMapRefresh)) print $globalMapRefresh*1000; else print '30000'; ?>);
626
+	,<?php if (isset($globalMapRefresh)) {
627
+	print $globalMapRefresh*1000;
628
+} else {
629
+	print '30000';
630
+}
631
+?>);
617 632
 } else {
618 633
 	//var widget = new Cesium.CesiumWidget('archivebox');
619 634
 //	var timeline = new Cesium.Timeline(viewer);
@@ -632,7 +647,12 @@  discard block
 block discarded – undo
632 647
     if ((isset($globalIVAO) && $globalIVAO) || (isset($globalVATSIM) && $globalVATSIM)) {
633 648
 ?>
634 649
 update_atcLayer();
635
-setInterval(function(){update_atcLayer()},<?php if (isset($globalMapRefresh)) print $globalMapRefresh*1000*2; else print '60000'; ?>);
650
+setInterval(function(){update_atcLayer()},<?php if (isset($globalMapRefresh)) {
651
+	print $globalMapRefresh*1000*2;
652
+} else {
653
+	print '60000';
654
+}
655
+?>);
636 656
 <?php
637 657
     }
638 658
 ?>
Please login to merge, or discard this patch.
js/map-marine.3d.js.php 1 patch
Braces   +12 added lines, -2 removed lines patch added patch discarded remove patch
@@ -47,7 +47,12 @@  discard block
 block discarded – undo
47 47
 			<?php
48 48
 			    } else {
49 49
 			?>
50
-			if (parseInt(lastupdateentity) < Math.floor(Date.now()-<?php if (isset($globalMapRefresh)) print $globalMapRefresh*2000; else print '60000'; ?>)) {
50
+			if (parseInt(lastupdateentity) < Math.floor(Date.now()-<?php if (isset($globalMapRefresh)) {
51
+	print $globalMapRefresh*2000;
52
+} else {
53
+	print '60000';
54
+}
55
+?>)) {
51 56
 				viewer.dataSources.get(dsn).entities.remove(entity);
52 57
 			}
53 58
 			<?php
@@ -129,7 +134,12 @@  discard block
 block discarded – undo
129 134
 		function(){
130 135
 			updateMarineData();
131 136
 		}
132
-	,<?php if (isset($globalMapRefresh)) print $globalMapRefresh*1000; else print '30000'; ?>);
137
+	,<?php if (isset($globalMapRefresh)) {
138
+	print $globalMapRefresh*1000;
139
+} else {
140
+	print '30000';
141
+}
142
+?>);
133 143
 } else {
134 144
 	var clockViewModel = new Cesium.ClockViewModel(viewer.clock);
135 145
 	var animationViewModel = new Cesium.AnimationViewModel(clockViewModel);
Please login to merge, or discard this patch.
js/map-tracker.3d.js.php 1 patch
Braces   +12 added lines, -2 removed lines patch added patch discarded remove patch
@@ -90,7 +90,12 @@  discard block
 block discarded – undo
90 90
 			<?php
91 91
 			    } else {
92 92
 			?>
93
-			if (parseInt(lastupdateentity) < Math.floor(Date.now()-<?php if (isset($globalMapRefresh)) print $globalMapRefresh*2000; else print '60000'; ?>)) {
93
+			if (parseInt(lastupdateentity) < Math.floor(Date.now()-<?php if (isset($globalMapRefresh)) {
94
+	print $globalMapRefresh*2000;
95
+} else {
96
+	print '60000';
97
+}
98
+?>)) {
94 99
 				viewer.dataSources.get(dsn).entities.remove(entity);
95 100
 				czmldstracker.entities.removeById(entityid);
96 101
 			}
@@ -173,7 +178,12 @@  discard block
 block discarded – undo
173 178
 		function(){
174 179
 			updateTrackerData();
175 180
 		}
176
-	,<?php if (isset($globalMapRefresh)) print $globalMapRefresh*1000; else print '30000'; ?>);
181
+	,<?php if (isset($globalMapRefresh)) {
182
+	print $globalMapRefresh*1000;
183
+} else {
184
+	print '30000';
185
+}
186
+?>);
177 187
 } else {
178 188
 	var clockViewModel = new Cesium.ClockViewModel(viewer.clock);
179 189
 	var animationViewModel = new Cesium.AnimationViewModel(clockViewModel);
Please login to merge, or discard this patch.
require/class.SpotterLive.php 1 patch
Braces   +122 added lines, -41 removed lines patch added patch discarded remove patch
@@ -8,7 +8,9 @@  discard block
 block discarded – undo
8 8
 	public function __construct($dbc = null) {
9 9
 		$Connection = new Connection($dbc);
10 10
 		$this->db = $Connection->db();
11
-		if ($this->db === null) die('Error: No DB connection.');
11
+		if ($this->db === null) {
12
+			die('Error: No DB connection.');
13
+		}
12 14
 	}
13 15
 
14 16
 
@@ -30,7 +32,9 @@  discard block
 block discarded – undo
30 32
 		if (isset($filter[0]['source'])) {
31 33
 			$filters = array_merge($filters,$filter);
32 34
 		}
33
-		if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter);
35
+		if (is_array($globalFilter)) {
36
+			$filter = array_merge($filter,$globalFilter);
37
+		}
34 38
 		$filter_query_join = '';
35 39
 		$filter_query_where = '';
36 40
 		foreach($filters as $flt) {
@@ -119,8 +123,11 @@  discard block
 block discarded – undo
119 123
 		if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) {
120 124
 			$filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')";
121 125
 		}
122
-		if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE';
123
-		elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND';
126
+		if ($filter_query_where == '' && $where) {
127
+			$filter_query_where = ' WHERE';
128
+		} elseif ($filter_query_where != '' && $and) {
129
+			$filter_query_where .= ' AND';
130
+		}
124 131
 		if ($filter_query_where != '') {
125 132
 			$filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where);
126 133
 		}
@@ -161,9 +168,13 @@  discard block
 block discarded – undo
161 168
 				$orderby_query = ' '.$search_orderby_array[$sort]['sql'];
162 169
 			}
163 170
 		}
164
-		if ($orderby_query == '') $orderby_query = ' ORDER BY date DESC';
171
+		if ($orderby_query == '') {
172
+			$orderby_query = ' ORDER BY date DESC';
173
+		}
165 174
 
166
-		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
175
+		if (!isset($globalLiveInterval)) {
176
+			$globalLiveInterval = '200';
177
+		}
167 178
 		if ($globalDBdriver == 'mysql') {
168 179
 			//$query  = "SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL 30 SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate";
169 180
 			$query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate'.$filter_query.$orderby_query;
@@ -186,7 +197,9 @@  discard block
 block discarded – undo
186 197
 		global $globalDBdriver, $globalLiveInterval, $globalArchive;
187 198
 		date_default_timezone_set('UTC');
188 199
 		$filter_query = $this->getFilter($filter,true,true);
189
-		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
200
+		if (!isset($globalLiveInterval)) {
201
+			$globalLiveInterval = '200';
202
+		}
190 203
 		if ($globalDBdriver == 'mysql') {
191 204
 			if (isset($globalArchive) && $globalArchive === TRUE) {
192 205
 				$query  = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source 
@@ -236,8 +249,12 @@  discard block
 block discarded – undo
236 249
 		}
237 250
 		$filter_query = $this->getFilter($filter,true,true);
238 251
 
239
-		if (!isset($globalLiveInterval) || $globalLiveInterval == '') $globalLiveInterval = '200';
240
-		if (!isset($globalMap3DAircraftsLimit) || $globalMap3DAircraftsLimit == '') $globalMap3DAircraftsLimit = '300';
252
+		if (!isset($globalLiveInterval) || $globalLiveInterval == '') {
253
+			$globalLiveInterval = '200';
254
+		}
255
+		if (!isset($globalMap3DAircraftsLimit) || $globalMap3DAircraftsLimit == '') {
256
+			$globalMap3DAircraftsLimit = '300';
257
+		}
241 258
 		if ($globalDBdriver == 'mysql') {
242 259
 			if (isset($globalArchive) && $globalArchive === TRUE) {
243 260
 				/*
@@ -248,22 +265,32 @@  discard block
 block discarded – undo
248 265
 				*/
249 266
 				$query  = 'SELECT * FROM (SELECT spotter_archive.ident, spotter_archive.flightaware_id, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, spotter_archive.date, spotter_archive.format_source 
250 267
 				FROM spotter_archive INNER JOIN (SELECT flightaware_id FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date) l ON l.flightaware_id = spotter_archive.flightaware_id ";
251
-				if ($usecoord) $query .= "AND spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong." ";
268
+				if ($usecoord) {
269
+					$query .= "AND spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong." ";
270
+				}
252 271
 				$query .= "UNION
253 272
 				SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source 
254 273
 				FROM spotter_live".$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date";
255
-				if ($usecoord) $query .= " AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong;
274
+				if ($usecoord) {
275
+					$query .= " AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong;
276
+				}
256 277
 				$query .= ") AS spotter 
257 278
 				WHERE latitude <> '0' AND longitude <> '0' 
258 279
 				ORDER BY flightaware_id, date";
259
-				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
280
+				if ($limit) {
281
+					$query .= " LIMIT ".$globalMap3DAircraftsLimit;
282
+				}
260 283
 			} else {
261 284
 				$query  = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source 
262 285
 				FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date ";
263
-				if ($usecoord) $query .= "AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong." ";
286
+				if ($usecoord) {
287
+					$query .= "AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong." ";
288
+				}
264 289
 				$query .= "AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' 
265 290
 				ORDER BY spotter_live.flightaware_id, spotter_live.date";
266
-				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
291
+				if ($limit) {
292
+					$query .= " LIMIT ".$globalMap3DAircraftsLimit;
293
+				}
267 294
 			}
268 295
 		} else {
269 296
 			if (isset($globalArchive) && $globalArchive === TRUE) {
@@ -275,21 +302,31 @@  discard block
 block discarded – undo
275 302
                                */
276 303
 				$query  = "SELECT * FROM (SELECT spotter_archive.ident, spotter_archive.flightaware_id, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, spotter_archive.date, spotter_archive.format_source 
277 304
 				FROM spotter_archive INNER JOIN (SELECT flightaware_id FROM spotter_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date) l ON l.flightaware_id = spotter_archive.flightaware_id ";
278
-				if ($usecoord) $query .= "AND spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong." ";
305
+				if ($usecoord) {
306
+					$query .= "AND spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong." ";
307
+				}
279 308
 				$query .= "UNION
280 309
 				SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source 
281 310
 				FROM spotter_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date";
282
-				if ($usecoord) $query .= " AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong;
311
+				if ($usecoord) {
312
+					$query .= " AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong;
313
+				}
283 314
 				$query .= ") AS spotter WHERE latitude <> '0' AND longitude <> '0' ";
284 315
 				$query .= "ORDER BY flightaware_id, date";
285
-				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
316
+				if ($limit) {
317
+					$query .= " LIMIT ".$globalMap3DAircraftsLimit;
318
+				}
286 319
 			} else {
287 320
 				$query  = "SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source 
288 321
 				FROM spotter_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date ";
289
-				if ($usecoord) $query .= "AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong." ";
322
+				if ($usecoord) {
323
+					$query .= "AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong." ";
324
+				}
290 325
 				$query .= "AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' 
291 326
 				ORDER BY spotter_live.flightaware_id, spotter_live.date";
292
-				if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit;
327
+				if ($limit) {
328
+					$query .= " LIMIT ".$globalMap3DAircraftsLimit;
329
+				}
293 330
 			}
294 331
 		}
295 332
 		try {
@@ -314,7 +351,9 @@  discard block
 block discarded – undo
314 351
 		global $globalDBdriver, $globalLiveInterval;
315 352
 		$filter_query = $this->getFilter($filter,true,true);
316 353
 
317
-		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
354
+		if (!isset($globalLiveInterval)) {
355
+			$globalLiveInterval = '200';
356
+		}
318 357
 		if ($globalDBdriver == 'mysql') {
319 358
 			//$query  = 'SELECT COUNT(*) as nb FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate'.$filter_query;
320 359
 			$query = 'SELECT COUNT(DISTINCT spotter_live.flightaware_id) as nb FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date';
@@ -344,7 +383,9 @@  discard block
 block discarded – undo
344 383
 	{
345 384
 		global $globalDBdriver, $globalLiveInterval;
346 385
 		$Spotter = new Spotter($this->db);
347
-		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
386
+		if (!isset($globalLiveInterval)) {
387
+			$globalLiveInterval = '200';
388
+		}
348 389
 		$filter_query = $this->getFilter($filter);
349 390
 
350 391
 		if (is_array($coord)) {
@@ -352,7 +393,9 @@  discard block
 block discarded – undo
352 393
 			$minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
353 394
 			$maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
354 395
 			$maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
355
-		} else return array();
396
+		} else {
397
+			return array();
398
+		}
356 399
 		if ($globalDBdriver == 'mysql') {
357 400
 			$query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate AND spotter_live.latitude BETWEEN '.$minlat.' AND '.$maxlat.' AND spotter_live.longitude BETWEEN '.$minlong.' AND '.$maxlong.' GROUP BY spotter_live.flightaware_id'.$filter_query;
358 401
 		} else {
@@ -373,7 +416,9 @@  discard block
 block discarded – undo
373 416
 	{
374 417
 		global $globalDBdriver, $globalLiveInterval, $globalArchive;
375 418
 		$Spotter = new Spotter($this->db);
376
-		if (!isset($globalLiveInterval)) $globalLiveInterval = '200';
419
+		if (!isset($globalLiveInterval)) {
420
+			$globalLiveInterval = '200';
421
+		}
377 422
 		$filter_query = $this->getFilter($filter,true,true);
378 423
 
379 424
 		if (is_array($coord)) {
@@ -381,7 +426,9 @@  discard block
 block discarded – undo
381 426
 			$minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
382 427
 			$maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
383 428
 			$maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
384
-		} else return array();
429
+		} else {
430
+			return array();
431
+		}
385 432
 		if ($globalDBdriver == 'mysql') {
386 433
 			if (isset($globalArchive) && $globalArchive === TRUE) {
387 434
 				$query  = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source 
@@ -608,11 +655,15 @@  discard block
 block discarded – undo
608 655
 		//$query  = self::$global_query.' WHERE spotter_live.flightaware_id = :id ORDER BY date';
609 656
 		if ($globalDBdriver == 'mysql') {
610 657
 			$query = 'SELECT spotter_live.* FROM spotter_live WHERE spotter_live.flightaware_id = :id';
611
-			if ($liveinterval) $query .= ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date';
658
+			if ($liveinterval) {
659
+				$query .= ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date';
660
+			}
612 661
 			$query .= ' ORDER BY date';
613 662
 		} else {
614 663
 			$query = 'SELECT spotter_live.* FROM spotter_live WHERE spotter_live.flightaware_id = :id';
615
-			if ($liveinterval) $query .= " AND CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= date";
664
+			if ($liveinterval) {
665
+				$query .= " AND CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= date";
666
+			}
616 667
 			$query .= ' ORDER BY date';
617 668
 		}
618 669
 
@@ -707,7 +758,9 @@  discard block
 block discarded – undo
707 758
 				$i++;
708 759
 				$j++;
709 760
 				if ($j == 30) {
710
-					if ($globalDebug) echo ".";
761
+					if ($globalDebug) {
762
+						echo ".";
763
+					}
711 764
 				    	try {
712 765
 						
713 766
 						$sth = $this->db->prepare(substr($query_delete,0,-1).")");
@@ -1014,7 +1067,9 @@  discard block
 block discarded – undo
1014 1067
 			{
1015 1068
 				return false;
1016 1069
 			}
1017
-		} else return '';
1070
+		} else {
1071
+			return '';
1072
+		}
1018 1073
 
1019 1074
 		if ($longitude != '')
1020 1075
 		{
@@ -1022,7 +1077,9 @@  discard block
 block discarded – undo
1022 1077
 			{
1023 1078
 				return false;
1024 1079
 			}
1025
-		} else return '';
1080
+		} else {
1081
+			return '';
1082
+		}
1026 1083
 
1027 1084
 		if ($waypoints != '')
1028 1085
 		{
@@ -1038,14 +1095,18 @@  discard block
 block discarded – undo
1038 1095
 			{
1039 1096
 				return false;
1040 1097
 			}
1041
-		} else $altitude = 0;
1098
+		} else {
1099
+			$altitude = 0;
1100
+		}
1042 1101
 		if ($altitude_real != '')
1043 1102
 		{
1044 1103
 			if (!is_numeric($altitude_real))
1045 1104
 			{
1046 1105
 				return false;
1047 1106
 			}
1048
-		} else $altitude_real = 0;
1107
+		} else {
1108
+			$altitude_real = 0;
1109
+		}
1049 1110
 
1050 1111
 		if ($heading != '')
1051 1112
 		{
@@ -1053,7 +1114,9 @@  discard block
 block discarded – undo
1053 1114
 			{
1054 1115
 				return false;
1055 1116
 			}
1056
-		} else $heading = 0;
1117
+		} else {
1118
+			$heading = 0;
1119
+		}
1057 1120
 
1058 1121
 		if ($groundspeed != '')
1059 1122
 		{
@@ -1061,9 +1124,13 @@  discard block
 block discarded – undo
1061 1124
 			{
1062 1125
 				return false;
1063 1126
 			}
1064
-		} else $groundspeed = 0;
1127
+		} else {
1128
+			$groundspeed = 0;
1129
+		}
1065 1130
 		date_default_timezone_set('UTC');
1066
-		if ($date == '') $date = date("Y-m-d H:i:s", time());
1131
+		if ($date == '') {
1132
+			$date = date("Y-m-d H:i:s", time());
1133
+		}
1067 1134
 
1068 1135
         
1069 1136
 		$flightaware_id = filter_var($flightaware_id,FILTER_SANITIZE_STRING);
@@ -1108,14 +1175,24 @@  discard block
 block discarded – undo
1108 1175
 		$arrival_airport_country = '';
1109 1176
 		
1110 1177
             	
1111
-            	if ($squawk == '' || $Common->isInteger($squawk) === false ) $squawk = NULL;
1112
-            	if ($verticalrate == '' || $Common->isInteger($verticalrate) === false ) $verticalrate = NULL;
1113
-            	if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) $groundspeed = 0;
1114
-            	if ($heading == '' || $Common->isInteger($heading) === false ) $heading = 0;
1178
+            	if ($squawk == '' || $Common->isInteger($squawk) === false ) {
1179
+            		$squawk = NULL;
1180
+            	}
1181
+            	if ($verticalrate == '' || $Common->isInteger($verticalrate) === false ) {
1182
+            		$verticalrate = NULL;
1183
+            	}
1184
+            	if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) {
1185
+            		$groundspeed = 0;
1186
+            	}
1187
+            	if ($heading == '' || $Common->isInteger($heading) === false ) {
1188
+            		$heading = 0;
1189
+            	}
1115 1190
 		
1116 1191
 		$query = '';
1117 1192
 		if ($globalArchive) {
1118
-			if ($globalDebug) echo '-- Delete previous data -- ';
1193
+			if ($globalDebug) {
1194
+				echo '-- Delete previous data -- ';
1195
+			}
1119 1196
 			$query .= 'DELETE FROM spotter_live WHERE flightaware_id = :flightaware_id;';
1120 1197
 		}
1121 1198
 
@@ -1132,10 +1209,14 @@  discard block
 block discarded – undo
1132 1209
 			return "error : ".$e->getMessage();
1133 1210
 		}
1134 1211
 		if (isset($globalArchive) && $globalArchive && $putinarchive && $noarchive !== true) {
1135
-		    if ($globalDebug) echo '(Add to SBS archive : ';
1212
+		    if ($globalDebug) {
1213
+		    	echo '(Add to SBS archive : ';
1214
+		    }
1136 1215
 		    $SpotterArchive = new SpotterArchive($this->db);
1137 1216
 		    $result =  $SpotterArchive->addSpotterArchiveData($flightaware_id, $ident, $registration, $airline_name, $airline_icao, $airline_country, $airline_type, $aircraft_icao, $aircraft_shadow, $aircraft_name, $aircraft_manufacturer, $departure_airport_icao, $departure_airport_name, $departure_airport_city, $departure_airport_country, $departure_airport_time,$arrival_airport_icao, $arrival_airport_name, $arrival_airport_city, $arrival_airport_country, $arrival_airport_time, $route_stop, $date,$latitude, $longitude, $waypoints, $altitude, $altitude_real,$heading, $groundspeed, $squawk, $ModeS, $pilot_id, $pilot_name,$verticalrate,$format_source,$source_name, $over_country);
1138
-		    if ($globalDebug) echo $result.')';
1217
+		    if ($globalDebug) {
1218
+		    	echo $result.')';
1219
+		    }
1139 1220
 		} elseif ($globalDebug && $putinarchive !== true) {
1140 1221
 			echo '(Not adding to archive)';
1141 1222
 		} elseif ($globalDebug && $noarchive === true) {
Please login to merge, or discard this patch.