Completed
Push — master ( 50e4fb...9cf4ee )
by Yannick
32:17
created
require/class.Accident.php 1 patch
Spacing   +55 added lines, -55 removed lines patch added patch discarded remove patch
@@ -28,20 +28,20 @@  discard block
 block discarded – undo
28 28
 	* @param String $date get data for a date
29 29
 	* @return Array Return Accidents data in array
30 30
 	*/
31
-	public function getAccidentData($limit = '',$type = '',$date = '') {
31
+	public function getAccidentData($limit = '', $type = '', $date = '') {
32 32
 		global $globalURL, $globalDBdriver;
33 33
 		$Image = new Image($this->db);
34 34
 		$Spotter = new Spotter($this->db);
35 35
 		$Translation = new Translation($this->db);
36
-		$date = filter_var($date,FILTER_SANITIZE_STRING);
36
+		$date = filter_var($date, FILTER_SANITIZE_STRING);
37 37
 		date_default_timezone_set('UTC');
38 38
 		$result = array();
39 39
 		$limit_query = '';
40 40
 		if ($limit != "")
41 41
 		{
42 42
 			$limit_array = explode(",", $limit);
43
-			$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT);
44
-			$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT);
43
+			$limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT);
44
+			$limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT);
45 45
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0)
46 46
 			{
47 47
 				$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0];
@@ -50,29 +50,29 @@  discard block
 block discarded – undo
50 50
 
51 51
 		if ($type != '') {
52 52
 			if ($date != '') {
53
-				if (preg_match("/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/",$date)) {
53
+				if (preg_match("/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/", $date)) {
54 54
 					$query = "SELECT * FROM accidents WHERE accidents_id IN (SELECT max(accidents_id) FROM accidents WHERE type = :type AND date = :date GROUP BY registration) ORDER BY accidents.date DESC".$limit_query;
55 55
 					//$query = "SELECT accidents.registration, accidents.ident, accidents.date, accidents.url, accidents.country, accidents.place, accidents.title, accidents.fatalities, accidents.type, accidents.ident, accidents.aircraft_manufacturer, accidents.aircraft_name, accidents.airline_name, accidents.airline_icao, spotter_output.flightaware_id FROM accidents LEFT OUTER JOIN spotter_output ON accidents.registration = spotter_output.registration WHERE accidents_id IN (SELECT max(accidents_id) FROM accidents WHERE type = :type AND date = :date GROUP BY registration) ORDER BY accidents.date DESC".$limit_query;
56
-					$query_values = array(':type' => $type,':date' => $date);
57
-				} elseif (preg_match("/^[0-9]{4}-[0-9]{2}$/",$date)) {
56
+					$query_values = array(':type' => $type, ':date' => $date);
57
+				} elseif (preg_match("/^[0-9]{4}-[0-9]{2}$/", $date)) {
58 58
 					$query = "SELECT * FROM accidents WHERE accidents_id IN (SELECT max(accidents_id) FROM accidents WHERE type = :type AND date BETWEEN :dated AND :datef GROUP BY registration) ORDER BY accidents.date DESC".$limit_query;
59
-					$query_values = array(':type' => $type,':dated' => $date.'-01', ':datef' => $date.'-31');
60
-				} elseif (preg_match("/^[0-9]{4}$/",$date)) {
59
+					$query_values = array(':type' => $type, ':dated' => $date.'-01', ':datef' => $date.'-31');
60
+				} elseif (preg_match("/^[0-9]{4}$/", $date)) {
61 61
 					if ($globalDBdriver == 'mysql') {
62 62
 						$query = "SELECT * FROM accidents WHERE accidents_id IN (SELECT max(accidents_id) FROM accidents WHERE type = :type AND YEAR(date) = :date GROUP BY registration) ORDER BY accidents.date DESC".$limit_query;
63 63
 					} else {
64 64
 						$query = "SELECT * FROM accidents WHERE accidents_id IN (SELECT max(accidents_id) FROM accidents WHERE type = :type AND EXTRACT(YEAR FROM date) = :date GROUP BY registration) ORDER BY accidents.date DESC".$limit_query;
65 65
 					}
66
-					$query_values = array(':type' => $type,':date' => $date);
66
+					$query_values = array(':type' => $type, ':date' => $date);
67 67
 				} else {
68 68
 					$date = $date.'%';
69 69
 					if ($globalDBdriver == 'mysql') {
70 70
 						$query = "SELECT * FROM accidents WHERE accidents_id IN (SELECT max(accidents_id) FROM accidents WHERE type = :type AND DATE_FORMAT(date,'%Y-%m-%d') LIKE :date GROUP BY registration) ORDER BY accidents.date DESC".$limit_query;
71
-						$query_values = array(':type' => $type,':date' => $date);
71
+						$query_values = array(':type' => $type, ':date' => $date);
72 72
 					} else {
73 73
 						$query = "SELECT * FROM accidents WHERE accidents_id IN (SELECT max(accidents_id) FROM accidents WHERE type = :type AND to_char(date,'YYYY-MM-DD') LIKE :date GROUP BY registration) ORDER BY accidents.date DESC".$limit_query;
74 74
 						//$query = "SELECT accidents.registration, accidents.ident, accidents.date, accidents.url, accidents.country, accidents.place, accidents.title, accidents.fatalities, accidents.type, accidents.ident, accidents.aircraft_manufacturer, accidents.aircraft_name, accidents.airline_name, accidents.airline_icao, spotter_output.flightaware_id FROM accidents LEFT OUTER JOIN spotter_output ON accidents.registration = spotter_output.registration WHERE accidents_id IN (SELECT max(accidents_id) FROM accidents WHERE type = :type AND to_char(date,'YYYY-MM-DD') LIKE :date GROUP BY registration) ORDER BY accidents.date DESC".$limit_query;
75
-						$query_values = array(':type' => $type,':date' => $date);
75
+						$query_values = array(':type' => $type, ':date' => $date);
76 76
 					}
77 77
 				}
78 78
 			} else {
@@ -82,7 +82,7 @@  discard block
 block discarded – undo
82 82
 			}
83 83
 		} else {
84 84
 			if ($date != '') {
85
-				if (preg_match("/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/",$date)) {
85
+				if (preg_match("/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/", $date)) {
86 86
 					$query = "SELECT * FROM accidents WHERE accidents_id IN (SELECT max(accidents_id) FROM accidents WHERE date = :date GROUP BY registration) ORDER BY accidents.date DESC".$limit_query;
87 87
 					//$query = "SELECT accidents.registration, accidents.ident, accidents.date, accidents.url, accidents.country, accidents.place, accidents.title, accidents.fatalities, accidents.type, accidents.ident, accidents.aircraft_manufacturer, accidents.aircraft_name, accidents.airline_name, accidents.airline_icao, spotter_output.flightaware_id FROM accidents LEFT OUTER JOIN spotter_output ON accidents.registration = spotter_output.registration WHERE accidents_id IN (SELECT max(accidents_id) FROM accidents WHERE date = :date GROUP BY registration) ORDER BY accidents.date DESC".$limit_query;
88 88
 				} else {
@@ -100,17 +100,17 @@  discard block
 block discarded – undo
100 100
 		try {
101 101
 			$sth = $this->db->prepare($query);
102 102
 			$sth->execute($query_values);
103
-		} catch(PDOException $e) {
103
+		} catch (PDOException $e) {
104 104
 			echo "error : ".$e->getMessage();
105 105
 		}
106 106
 		$i = 0;
107 107
 		while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
108
-			if (preg_match('/^[\w\-]+$/',$row['registration'])) {
108
+			if (preg_match('/^[\w\-]+$/', $row['registration'])) {
109 109
 				$data = array();
110 110
 				if ($row['registration'] != '') {
111 111
 					$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' => ''));
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 114
 					$aircraft_type = $Spotter->getAllAircraftTypeByRegistration($row['registration']);
115 115
 					$aircraft_info = $Spotter->getAllAircraftInfo($aircraft_type);
116 116
 					if (!empty($aircraft_info)) {
@@ -118,7 +118,7 @@  discard block
 block discarded – undo
118 118
 						$data['aircraft_name'] = $aircraft_info[0]['type'];
119 119
 						$data['aircraft_manufacturer'] = $aircraft_info[0]['manufacturer'];
120 120
 					} else {
121
-						$data = array_merge($data,array('aircraft_type' => 'NA'));
121
+						$data = array_merge($data, array('aircraft_type' => 'NA'));
122 122
 					}
123 123
 					$owner_data = $Spotter->getAircraftOwnerByRegistration($row['registration']);
124 124
 					if (!empty($owner_data)) {
@@ -126,18 +126,18 @@  discard block
 block discarded – undo
126 126
 						$data['aircraft_base'] = $owner_data['base'];
127 127
 						$data['aircraft_date_first_reg'] = $owner_data['date_first_reg'];
128 128
 					}
129
-				} else $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => ''));
129
+				} else $data = array_merge($data, array('image' => '', 'image_thumbnail' => '', 'image_copyright' => '', 'image_source' => '', 'image_source_website' => ''));
130 130
 				if ($row['registration'] == '') $row['registration'] = 'NA';
131 131
 				if ($row['ident'] == '') $row['ident'] = 'NA';
132
-				$identicao = $Spotter->getAllAirlineInfo(substr($row['ident'],0,3));
132
+				$identicao = $Spotter->getAllAirlineInfo(substr($row['ident'], 0, 3));
133 133
 				if (isset($identicao[0])) {
134
-					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');
138
-					$data = array_merge($data,array('airline_icao' => $identicao[0]['icao'],'airline_name' => $identicao[0]['name']));
134
+					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');
138
+					$data = array_merge($data, array('airline_icao' => $identicao[0]['icao'], 'airline_name' => $identicao[0]['name']));
139 139
 				} else $icao = $row['ident'];
140
-				$icao = $Translation->checkTranslation($icao,false);
140
+				$icao = $Translation->checkTranslation($icao, false);
141 141
 				//$data = array_merge($data,array('registration' => $row['registration'], 'date' => $row['date'], 'ident' => $icao,'url' => $row['url']));
142 142
 				if ($row['airline_name'] != '' && !isset($data['airline_name'])) {
143 143
 					//echo 'Check airline info... for '.$row['airline_name'].' ';
@@ -146,16 +146,16 @@  discard block
 block discarded – undo
146 146
 					if (!empty($airline_info)) {
147 147
 						//echo 'data found !'."\n";
148 148
 						//print_r($airline_info);
149
-						$data = array_merge($data,$airline_info);
149
+						$data = array_merge($data, $airline_info);
150 150
 					} 
151 151
 					//else echo 'No data...'."\n";
152 152
 				}
153
-				$data = array_merge($row,$data);
153
+				$data = array_merge($row, $data);
154 154
 				if ($data['ident'] == null) $data['ident'] = $icao;
155 155
 				if ($data['title'] == null) {
156 156
 					$data['message'] = $row['type'].' of '.$row['registration'].' at '.$row['place'].','.$row['country'];
157 157
 				} else $data['message'] = strtolower($data['title']);
158
-				$ids = $Spotter->getAllIDByRegistration($data['registration'],true);
158
+				$ids = $Spotter->getAllIDByRegistration($data['registration'], true);
159 159
 				$date = $data['date'];
160 160
 				if (isset($ids[$date])) {
161 161
 					$data['spotted'] = TRUE;
@@ -187,7 +187,7 @@  discard block
 block discarded – undo
187 187
 		try {
188 188
 			$sth = $this->db->prepare($query);
189 189
 			$sth->execute();
190
-		} catch(PDOException $e) {
190
+		} catch (PDOException $e) {
191 191
 			echo "Error : ".$e->getMessage();
192 192
 		}
193 193
 		return $sth->fetchAll(PDO::FETCH_ASSOC);
@@ -207,7 +207,7 @@  discard block
 block discarded – undo
207 207
 		try {
208 208
 			$sth = $this->db->prepare($query);
209 209
 			$sth->execute();
210
-		} catch(PDOException $e) {
210
+		} catch (PDOException $e) {
211 211
 			echo "Error : ".$e->getMessage();
212 212
 		}
213 213
 		return $sth->fetchAll(PDO::FETCH_ASSOC);
@@ -222,15 +222,15 @@  discard block
 block discarded – undo
222 222
 		if ($globalDebug) echo 'Import '.$file."\n";
223 223
 		$result = array();
224 224
 		if (file_exists($file)) {
225
-			if (($handle = fopen($file,'r')) !== FALSE) {
226
-				while (($data = fgetcsv($handle,2000,",")) !== FALSE) {
225
+			if (($handle = fopen($file, 'r')) !== FALSE) {
226
+				while (($data = fgetcsv($handle, 2000, ",")) !== FALSE) {
227 227
 					if (isset($data[1]) && $data[1] != '0000-00-00 00:00:00') {
228
-						$result[] = array('registration' => $data[0],'date' => strtotime($data[1]),'url' => $data[2],'country' => $data[3],'place' => $data[4],'title' => $data[5],'fatalities' => $data[6],'latitude' => $data[7],'longitude' => $data[8],'type' => $data[9],'ident' => $data[10],'aircraft_manufacturer' => $data[11],'aircraft_name' => $data[12],'operator' => $data[13],'source' => 'website_fam');
228
+						$result[] = array('registration' => $data[0], 'date' => strtotime($data[1]), 'url' => $data[2], 'country' => $data[3], 'place' => $data[4], 'title' => $data[5], 'fatalities' => $data[6], 'latitude' => $data[7], 'longitude' => $data[8], 'type' => $data[9], 'ident' => $data[10], 'aircraft_manufacturer' => $data[11], 'aircraft_name' => $data[12], 'operator' => $data[13], 'source' => 'website_fam');
229 229
 					}
230 230
 				}
231 231
 				fclose($handle);
232 232
 			}
233
-			if (!empty($result)) $this->add($result,true);
233
+			if (!empty($result)) $this->add($result, true);
234 234
 			elseif ($globalDebug) echo 'Nothing to import';
235 235
 		}
236 236
 	}
@@ -246,8 +246,8 @@  discard block
 block discarded – undo
246 246
 		$all_md5_new = array();
247 247
 		if (file_exists(dirname(__FILE__).'/../install/tmp/cr-all.md5')) {
248 248
 			if ($this->check_accidents_nb() > 0) {
249
-				if (($handle = fopen(dirname(__FILE__).'/../install/tmp/cr-all.md5','r')) !== FALSE) {
250
-					while (($data = fgetcsv($handle,2000,"\t")) !== FALSE) {
249
+				if (($handle = fopen(dirname(__FILE__).'/../install/tmp/cr-all.md5', 'r')) !== FALSE) {
250
+					while (($data = fgetcsv($handle, 2000, "\t")) !== FALSE) {
251 251
 						if (isset($data[1])) {
252 252
 							$year = $data[0];
253 253
 							$all_md5[$year] = $data[1];
@@ -257,10 +257,10 @@  discard block
 block discarded – undo
257 257
 				}
258 258
 			}
259 259
 		}
260
-		$Common->download('http://data.flightairmap.fr/data/cr/cr-all.md5',dirname(__FILE__).'/../install/tmp/cr-all.md5');
260
+		$Common->download('http://data.flightairmap.fr/data/cr/cr-all.md5', dirname(__FILE__).'/../install/tmp/cr-all.md5');
261 261
 		if (file_exists(dirname(__FILE__).'/../install/tmp/cr-all.md5')) {
262
-			if (($handle = fopen(dirname(__FILE__).'/../install/tmp/cr-all.md5','r')) !== FALSE) {
263
-				while (($data = fgetcsv($handle,2000,"\t")) !== FALSE) {
262
+			if (($handle = fopen(dirname(__FILE__).'/../install/tmp/cr-all.md5', 'r')) !== FALSE) {
263
+				while (($data = fgetcsv($handle, 2000, "\t")) !== FALSE) {
264 264
 					if (isset($data[1])) {
265 265
 						$year = $data[0];
266 266
 						$all_md5_new[$year] = $data[1];
@@ -269,10 +269,10 @@  discard block
 block discarded – undo
269 269
 				fclose($handle);
270 270
 			} elseif ($globalDebug) echo "Can't open ".dirname(__FILE__).'/../install/tmp/cr-all.md5';
271 271
 		} elseif ($globalDebug) echo 'Download cr-all.md5 failed. '.dirname(__FILE__).'/../install/tmp/cr-all.md5 not here.';
272
-		$result = $Common->arr_diff($all_md5_new,$all_md5);
272
+		$result = $Common->arr_diff($all_md5_new, $all_md5);
273 273
 		if (empty($result) && $globalDebug) echo 'Nothing to update';
274 274
 		foreach ($result as $file => $md5) {
275
-			$Common->download('http://data.flightairmap.fr/data/cr/'.$file,dirname(__FILE__).'/../install/tmp/'.$file);
275
+			$Common->download('http://data.flightairmap.fr/data/cr/'.$file, dirname(__FILE__).'/../install/tmp/'.$file);
276 276
 			if (file_exists(dirname(__FILE__).'/../install/tmp/'.$file)) $this->import(dirname(__FILE__).'/../install/tmp/'.$file);
277 277
 			elseif ($globalDebug) echo 'Download '.$file.' failed';
278 278
 		}
@@ -282,7 +282,7 @@  discard block
 block discarded – undo
282 282
 	* Add data to DB
283 283
 	* @param Array $crash An array with accidents/incidents data
284 284
 	*/
285
-	public function add($crash,$new = false) {
285
+	public function add($crash, $new = false) {
286 286
 		global $globalTransaction, $globalDebug;
287 287
 		require_once('class.Connection.php');
288 288
 		require_once('class.Image.php');
@@ -298,7 +298,7 @@  discard block
 block discarded – undo
298 298
 			$sthd->execute(array(':source' => $crash[0]['source']));
299 299
 		}
300 300
 		if ($globalTransaction) $Connection->db->beginTransaction();
301
-		$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);
301
+		$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 302
 		$query_check = 'SELECT COUNT(*) as nb FROM accidents WHERE registration = :registration AND date = :date AND type = :type AND source = :source';
303 303
 		$sth_check = $Connection->db->prepare($query_check);
304 304
 		$query = 'INSERT INTO accidents (aircraft_manufacturer,aircraft_name,ident,registration,date,url,country,place,title,fatalities,latitude,longitude,type,airline_name,source) VALUES (:aircraft_manufacturer,:aircraft_name,:ident,:registration,:date,:url,:country,:place,:title,:fatalities,:latitude,:longitude,:type,:airline_name,:source)';
@@ -311,15 +311,15 @@  discard block
 block discarded – undo
311 311
 				$cr = array_map(function($value) {
312 312
 					return $value === "" ? NULL : $value;
313 313
 				}, $cr);
314
-				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']);
316
-					$query_check_values = array(':registration' => $cr['registration'],':date' => date('Y-m-d',$cr['date']),':type' => $cr['type'],':source' => $cr['source']);
314
+				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']);
316
+					$query_check_values = array(':registration' => $cr['registration'], ':date' => date('Y-m-d', $cr['date']), ':type' => $cr['type'], ':source' => $cr['source']);
317 317
 					$sth_check->execute($query_check_values);
318 318
 					$result_check = $sth_check->fetch(PDO::FETCH_ASSOC);
319 319
 					if ($result_check['nb'] == 0) {
320
-						$query_values = array(':registration' => trim($cr['registration']),':date' => date('Y-m-d',$cr['date']),':url' => $cr['url'],':country' => $cr['country'],':place' => $cr['place'],':title' => $cr['title'],':fatalities' => $cr['fatalities'],':latitude' => $cr['latitude'],':longitude' => $cr['longitude'],':type' => $cr['type'],':source' => $cr['source'],':ident' => $cr['ident'],':aircraft_manufacturer' => $cr['aircraft_manufacturer'],':aircraft_name' => $cr['aircraft_name'],':airline_name' => $cr['operator']);
320
+						$query_values = array(':registration' => trim($cr['registration']), ':date' => date('Y-m-d', $cr['date']), ':url' => $cr['url'], ':country' => $cr['country'], ':place' => $cr['place'], ':title' => $cr['title'], ':fatalities' => $cr['fatalities'], ':latitude' => $cr['latitude'], ':longitude' => $cr['longitude'], ':type' => $cr['type'], ':source' => $cr['source'], ':ident' => $cr['ident'], ':aircraft_manufacturer' => $cr['aircraft_manufacturer'], ':aircraft_name' => $cr['aircraft_name'], ':airline_name' => $cr['operator']);
321 321
 						$sth->execute($query_values);
322
-						if ($cr['date'] > time()-(30*86400)) {
322
+						if ($cr['date'] > time() - (30*86400)) {
323 323
 							if (empty($Image->getSpotterImage($cr['registration']))) {
324 324
 								if ($globalDebug) echo "\t".'Get image for '.$cr['registration'].'...';
325 325
 								$Image->addSpotterImage($cr['registration']);
@@ -328,16 +328,16 @@  discard block
 block discarded – undo
328 328
 							// elseif ($globalDebug) echo 'Image already in DB'."\n";
329 329
 						}
330 330
 						if ($cr['title'] == '') $cr['title'] = $cr['registration'].' '.$cr['type'];
331
-						$Spotter->setHighlightFlightByRegistration($cr['registration'],$cr['title'],date('Y-m-d',$cr['date']));
331
+						$Spotter->setHighlightFlightByRegistration($cr['registration'], $cr['title'], date('Y-m-d', $cr['date']));
332 332
 					}
333 333
 				}
334
-				if ($globalTransaction && $j % 1000 == 0) {
334
+				if ($globalTransaction && $j%1000 == 0) {
335 335
 					$Connection->db->commit();
336 336
 					$Connection->db->beginTransaction();
337 337
 				}
338 338
 			}
339 339
 			if ($globalTransaction) $Connection->db->commit();
340
-		} catch(PDOException $e) {
340
+		} catch (PDOException $e) {
341 341
 			if ($globalTransaction) $Connection->db->rollBack();
342 342
 			echo $e->getMessage();
343 343
 		}
@@ -355,7 +355,7 @@  discard block
 block discarded – undo
355 355
 			$Connection = new Connection();
356 356
 			$sth = $Connection->db->prepare($query);
357 357
 			$sth->execute();
358
-		} catch(PDOException $e) {
358
+		} catch (PDOException $e) {
359 359
 			return "error : ".$e->getMessage();
360 360
 		}
361 361
 		$row = $sth->fetch(PDO::FETCH_ASSOC);
@@ -373,7 +373,7 @@  discard block
 block discarded – undo
373 373
 			$Connection = new Connection();
374 374
 			$sth = $Connection->db->prepare($query);
375 375
 			$sth->execute();
376
-		} catch(PDOException $e) {
376
+		} catch (PDOException $e) {
377 377
 			return "error : ".$e->getMessage();
378 378
 		}
379 379
 		$row = $sth->fetch(PDO::FETCH_ASSOC);
@@ -388,7 +388,7 @@  discard block
 block discarded – undo
388 388
 			$Connection = new Connection();
389 389
 			$sth = $Connection->db->prepare($query);
390 390
 			$sth->execute();
391
-		} catch(PDOException $e) {
391
+		} catch (PDOException $e) {
392 392
 			return "error : ".$e->getMessage();
393 393
 		}
394 394
 	}
Please login to merge, or discard this patch.
accident-latest.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -8,7 +8,7 @@  discard block
 block discarded – undo
8 8
 
9 9
 $page_url = $globalURL.'/accident-latest';
10 10
 
11
-if(!isset($_GET['limit']))
11
+if (!isset($_GET['limit']))
12 12
 {
13 13
 	$limit_start = 0;
14 14
 	$limit_end = 25;
@@ -33,7 +33,7 @@  discard block
 block discarded – undo
33 33
 
34 34
 print '<div class="table column">';
35 35
 print '<p>'._("The table below shows the latest Accidents.").'</p>';
36
-$spotter_array = $Accident->getAccidentData($limit_start.",".$absolute_difference,'accident');
36
+$spotter_array = $Accident->getAccidentData($limit_start.",".$absolute_difference, 'accident');
37 37
 if (!empty($spotter_array) && isset($spotter_array[0]['query_number_rows']) && $spotter_array[0]['query_number_rows'] != 0) {
38 38
 	include('table-output.php');
39 39
 	print '<div class="pagination">';
Please login to merge, or discard this patch.
js/map-satellite.2d.js.php 1 patch
Spacing   +7 added lines, -7 removed lines patch added patch discarded remove patch
@@ -2,7 +2,7 @@  discard block
 block discarded – undo
2 2
 require_once('../require/settings.php');
3 3
 require_once('../require/class.Language.php'); 
4 4
 
5
-setcookie("MapFormat",'2d');
5
+setcookie("MapFormat", '2d');
6 6
 
7 7
 // Compressed GeoJson is used if true
8 8
 if (!isset($globalJsonCompress)) $compress = true;
@@ -18,10 +18,10 @@  discard block
 block discarded – undo
18 18
 
19 19
 <?php
20 20
 	if (isset($_GET['famsatid'])) {
21
-		$famsatid = filter_input(INPUT_GET,'famsatid',FILTER_SANITIZE_STRING);
21
+		$famsatid = filter_input(INPUT_GET, 'famsatid', FILTER_SANITIZE_STRING);
22 22
 	}
23 23
 	if (isset($_GET['ident'])) {
24
-		$ident = filter_input(INPUT_GET,'ident',FILTER_SANITIZE_STRING);
24
+		$ident = filter_input(INPUT_GET, 'ident', FILTER_SANITIZE_STRING);
25 25
 	}
26 26
 	if (!isset($ident) && !isset($famsatid)) {
27 27
 ?>
@@ -194,7 +194,7 @@  discard block
 block discarded – undo
194 194
 <?php
195 195
 		} else {
196 196
 ?>
197
-		    var movingtime = Math.round(<?php if (isset($archiveupdatetime)) print $archiveupdatetime*1000; else print $globalMapRefresh*1000+20000; ?>+feature.properties.sqt*1000);
197
+		    var movingtime = Math.round(<?php if (isset($archiveupdatetime)) print $archiveupdatetime*1000; else print $globalMapRefresh*1000 + 20000; ?>+feature.properties.sqt*1000);
198 198
 		    return new L.Marker.movingMarker([latLng, feature.properties.nextlatlon],[movingtime],{
199 199
 <?php
200 200
 		}
@@ -210,7 +210,7 @@  discard block
 block discarded – undo
210 210
 			    /*
211 211
 			    shadowUrl: iconURLShadowpath,
212 212
 			    shadowSize: [<?php print $globalAircraftSize; ?>, <?php print $globalAircraftSize; ?>],
213
-			    shadowAnchor: [<?php print ($globalAircraftSize/2)+1; ?>, <?php print $globalAircraftSize; ?>]
213
+			    shadowAnchor: [<?php print ($globalAircraftSize/2) + 1; ?>, <?php print $globalAircraftSize; ?>]
214 214
 			    */
215 215
 			})
216 216
 		    })
@@ -250,7 +250,7 @@  discard block
 block discarded – undo
250 250
 <?php
251 251
 		} else {
252 252
 ?>
253
-			    var movingtime = Math.round(<?php if (isset($archiveupdatetime)) print $archiveupdatetime*1000; else print $globalMapRefresh*1000+20000; ?>+feature.properties.sqt*1000);
253
+			    var movingtime = Math.round(<?php if (isset($archiveupdatetime)) print $archiveupdatetime*1000; else print $globalMapRefresh*1000 + 20000; ?>+feature.properties.sqt*1000);
254 254
 			    return new L.Marker.movingMarker([latLng, feature.properties.nextlatlon],[movingtime],{
255 255
 <?php
256 256
 		}
@@ -305,7 +305,7 @@  discard block
 block discarded – undo
305 305
 <?php
306 306
 		} else {
307 307
 ?>
308
-			    var movingtime = Math.round(<?php if (isset($archiveupdatetime)) print $archiveupdatetime*1000; else print $globalMapRefresh*1000+20000; ?>+feature.properties.sqt*1000);
308
+			    var movingtime = Math.round(<?php if (isset($archiveupdatetime)) print $archiveupdatetime*1000; else print $globalMapRefresh*1000 + 20000; ?>+feature.properties.sqt*1000);
309 309
 			    return new L.Marker.movingMarker([latLng, feature.properties.nextlatlon],[movingtime],{
310 310
 <?php
311 311
 		}
Please login to merge, or discard this patch.
airline.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -8,7 +8,7 @@  discard block
 block discarded – undo
8 8
 
9 9
 if (isset($_POST['airline']))
10 10
 {
11
-	header('Location: '.$globalURL.'/airline/'.filter_input(INPUT_POST,'airline',FILTER_SANITIZE_STRING));
11
+	header('Location: '.$globalURL.'/airline/'.filter_input(INPUT_POST, 'airline', FILTER_SANITIZE_STRING));
12 12
 } else {
13 13
 	$title = "Airlines";
14 14
 	require_once('header.php');
@@ -17,7 +17,7 @@  discard block
 block discarded – undo
17 17
 	print '<div class="column">';
18 18
 	print '<h1>'._("Airlines").'</h1>';
19 19
 	if (isset($_POST['airline_type'])) {
20
-		$airline_type = filter_input(INPUT_POST,'airline_type',FILTER_SANITIZE_STRING);
20
+		$airline_type = filter_input(INPUT_POST, 'airline_type', FILTER_SANITIZE_STRING);
21 21
 		//$airline_names = $Spotter->getAllAirlineNames($airline_type);
22 22
 	} else {
23 23
 		//$airline_names = $Spotter->getAllAirlineNames();
@@ -29,10 +29,10 @@  discard block
 block discarded – undo
29 29
 		print '<div class="alphabet">';
30 30
 		foreach ($alliances as $alliance) {
31 31
 			print '<div class="alphabet-airline alphabet-item">';
32
-			print '<a href="'.$globalURL.'/airline/alliance_'.str_replace(' ','_',$alliance['alliance']).'">';
33
-			if (file_exists('images/airlines/'.str_replace(' ','_',$alliance['alliance']).'.png'))
32
+			print '<a href="'.$globalURL.'/airline/alliance_'.str_replace(' ', '_', $alliance['alliance']).'">';
33
+			if (file_exists('images/airlines/'.str_replace(' ', '_', $alliance['alliance']).'.png'))
34 34
 			{
35
-				print '<img src="'.$globalURL.'/images/airlines/'.str_replace(' ','_',$alliance['alliance']).'.png" alt="'._("Click to see alliance activity").'" title="'._("Click to see alliance activity").'" /> ';
35
+				print '<img src="'.$globalURL.'/images/airlines/'.str_replace(' ', '_', $alliance['alliance']).'.png" alt="'._("Click to see alliance activity").'" title="'._("Click to see alliance activity").'" /> ';
36 36
 			} else print $alliance['alliance'];
37 37
 			print '</a>';
38 38
 			print '</div>';
@@ -55,7 +55,7 @@  discard block
 block discarded – undo
55 55
 	$Stats = new Stats();
56 56
 	if (isset($_POST['airline_type'])) 
57 57
 	{
58
-		$airline_type = filter_input(INPUT_POST,'airline_type',FILTER_SANITIZE_STRING);
58
+		$airline_type = filter_input(INPUT_POST, 'airline_type', FILTER_SANITIZE_STRING);
59 59
 		//$airline_names = $Stats->getAllAirlineNames($airline_type);
60 60
 		$airline_names = $Spotter->getAllAirlineNames($airline_type);
61 61
 	} else {
@@ -68,12 +68,12 @@  discard block
 block discarded – undo
68 68
 	}
69 69
 	$previous = null;
70 70
 	print '<div class="alphabet-legend">';
71
-	foreach($airline_names as $value) 
71
+	foreach ($airline_names as $value) 
72 72
 	{
73 73
 		//echo $value['airline_name']."\n";
74 74
 		//echo mb_substr($value['airline_name'],0,1).' - '.$value['airline_name']."\n";
75 75
 		$firstLetter = strtoupper($Common->replace_mb_substr($value['airline_name'], 0, 1));
76
-		if($previous !== $firstLetter)
76
+		if ($previous !== $firstLetter)
77 77
 		{
78 78
 			if ($previous !== null) print ' | ';
79 79
 			print '<a href="#'.$firstLetter.'">'.$firstLetter.'</a>';
@@ -82,11 +82,11 @@  discard block
 block discarded – undo
82 82
 	}
83 83
 	print '</div>';
84 84
 	$previous = null;
85
-	foreach($airline_names as $value) {
85
+	foreach ($airline_names as $value) {
86 86
 		$firstLetter = strtoupper($Common->replace_mb_substr($value['airline_name'], 0, 1));
87 87
 		if ($firstLetter != "")
88 88
 		{
89
-			if($previous !== $firstLetter)
89
+			if ($previous !== $firstLetter)
90 90
 			{
91 91
 				if ($previous !== null) print '</div>';
92 92
 				print '<a name="'.$firstLetter.'"></a><h4 class="alphabet-header">'.$firstLetter.'</h4><div class="alphabet">';
Please login to merge, or discard this patch.
airport.php 1 patch
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch
@@ -7,16 +7,16 @@  discard block
 block discarded – undo
7 7
 
8 8
 if (isset($_POST['airport']))
9 9
 {
10
-	header('Location: '.$globalURL.'/airport/'.filter_input(INPUT_POST,'airport',FILTER_SANITIZE_STRING));
11
-} else if (isset($_GET['airport'])){
10
+	header('Location: '.$globalURL.'/airport/'.filter_input(INPUT_POST, 'airport', FILTER_SANITIZE_STRING));
11
+} else if (isset($_GET['airport'])) {
12 12
 	$Spotter = new Spotter();
13 13
 	//calculuation for the pagination
14
-	if($_GET['limit'] == "")
14
+	if ($_GET['limit'] == "")
15 15
 	{
16 16
 	  $limit_start = 0;
17 17
 	  $limit_end = 25;
18 18
 	  $absolute_difference = 25;
19
-	}  else {
19
+	} else {
20 20
 		$limit_explode = explode(",", $_GET['limit']);
21 21
 		$limit_start = $limit_explode[0];
22 22
 		$limit_end = $limit_explode[1];
@@ -30,10 +30,10 @@  discard block
 block discarded – undo
30 30
 	$limit_previous_1 = $limit_start - $absolute_difference;
31 31
 	$limit_previous_2 = $limit_end - $absolute_difference;
32 32
 	
33
-	$airport = filter_input(INPUT_GET,'airport',FILTER_SANITIZE_STRING);
34
-	$sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING);
33
+	$airport = filter_input(INPUT_GET, 'airport', FILTER_SANITIZE_STRING);
34
+	$sort = filter_input(INPUT_GET, 'sort', FILTER_SANITIZE_STRING);
35 35
 	$page_url = $globalURL.'/airport/'.$airport;
36
-	$spotter_array = $Spotter->getSpotterDataByAirport($airport,$limit_start.",".$absolute_difference, $sort);
36
+	$spotter_array = $Spotter->getSpotterDataByAirport($airport, $limit_start.",".$absolute_difference, $sort);
37 37
 	$airport_array = $Spotter->getAllAirportInfo($airport);
38 38
 	
39 39
 	if (!empty($airport_array))
@@ -52,9 +52,9 @@  discard block
 block discarded – undo
52 52
 			$airport_names = $Spotter->getAllAirportNames();
53 53
 		}
54 54
 		ksort($airport_names);
55
-		foreach($airport_names as $airport_name)
55
+		foreach ($airport_names as $airport_name)
56 56
 		{
57
-			if($airport == $airport_name['airport_icao'])
57
+			if ($airport == $airport_name['airport_icao'])
58 58
 			{
59 59
 				print '<option value="'.$airport_name['airport_icao'].'" selected="selected">'.$airport_name['airport_city'].', '.$airport_name['airport_name'].', '.$airport_name['airport_country'].' ('.$airport_name['airport_icao'].')</option>';
60 60
 			} else {
@@ -87,7 +87,7 @@  discard block
 block discarded – undo
87 87
 		print '<div class="table column">';
88 88
 		if ($airport_array[0]['iata'] != "NA")
89 89
 		{
90
-			print '<p>'.sprintf(_("The table below shows the route(s) aircrafts have used to/from <strong>%s</strong>, sorted by the most recent one."),$airport_array[0]['name']).'</p>';
90
+			print '<p>'.sprintf(_("The table below shows the route(s) aircrafts have used to/from <strong>%s</strong>, sorted by the most recent one."), $airport_array[0]['name']).'</p>';
91 91
 		}
92 92
 
93 93
 		include('table-output.php');  
@@ -109,7 +109,7 @@  discard block
 block discarded – undo
109 109
 		print '<p>'._("Sorry, the airport does not exist in this database. :(").'</p>'; 
110 110
 	}
111 111
 } else {
112
-	$Spotter= new Spotter();
112
+	$Spotter = new Spotter();
113 113
 	$Stats = new Stats();
114 114
 	$Common = new Common();
115 115
 	$title = _("Airports");
@@ -123,11 +123,11 @@  discard block
 block discarded – undo
123 123
 	ksort($airport_names);
124 124
 	$previous = null;
125 125
 	print '<div class="alphabet-legend">';
126
-	foreach($airport_names as $value) {
126
+	foreach ($airport_names as $value) {
127 127
 		$firstLetter = strtoupper($Common->replace_mb_substr($value['airport_city'], 0, 1));
128
-		if($previous !== $firstLetter)
128
+		if ($previous !== $firstLetter)
129 129
 		{
130
-			if ($previous !== null){
130
+			if ($previous !== null) {
131 131
 				print ' | ';
132 132
 			}
133 133
 			print '<a href="#'.$firstLetter.'">'.$firstLetter.'</a>';
@@ -136,13 +136,13 @@  discard block
 block discarded – undo
136 136
 	}
137 137
 	print '</div>';
138 138
 	$previous = null;
139
-	foreach($airport_names as $value) {
139
+	foreach ($airport_names as $value) {
140 140
 		$firstLetter = strtoupper($Common->replace_mb_substr($value['airport_city'], 0, 1));
141 141
 		if ($firstLetter != "")
142 142
 		{
143
-			if($previous !== $firstLetter)
143
+			if ($previous !== $firstLetter)
144 144
 			{
145
-				if ($previous !== null){
145
+				if ($previous !== null) {
146 146
 					print '</div>';
147 147
 				}
148 148
 				print '<a name="'.$firstLetter.'"></a><h4 class="alphabet-header">'.$firstLetter.'</h4><div class="alphabet">';
Please login to merge, or discard this patch.
install/class.create_db.php 1 patch
Spacing   +19 added lines, -19 removed lines patch added patch discarded remove patch
@@ -8,25 +8,25 @@  discard block
 block discarded – undo
8 8
 	 * @param string $filename
9 9
 	 */
10 10
 	public static function import_file($filename) {
11
-		$filename = filter_var($filename,FILTER_SANITIZE_STRING);
11
+		$filename = filter_var($filename, FILTER_SANITIZE_STRING);
12 12
 		$Connection = new Connection();
13 13
 		if (!$Connection->connectionExists()) return 'error: DB connection failed';
14 14
 		//Connection::$db->beginTransaction();
15 15
 		$templine = '';
16
-		$handle = @fopen($filename,"r");
16
+		$handle = @fopen($filename, "r");
17 17
 		if ($handle) {
18 18
 			//$lines = file($filename);
19 19
 			//foreach ($lines as $line)
20
-			while (($line = fgets($handle,4096)) !== false)
20
+			while (($line = fgets($handle, 4096)) !== false)
21 21
 			{
22
-				if (substr($line,0,2) == '--' || $line == '') continue;
22
+				if (substr($line, 0, 2) == '--' || $line == '') continue;
23 23
 				$templine .= $line;
24
-				if (substr(trim($line), -1,1) == ';')
24
+				if (substr(trim($line), -1, 1) == ';')
25 25
 				{
26 26
 					try {
27 27
 						$sth = $Connection->db->prepare($templine);
28 28
 						$sth->execute();
29
-					} catch(PDOException $e) {
29
+					} catch (PDOException $e) {
30 30
 						return "error (import ".$filename.") : ".$e->getMessage()."\n";
31 31
 					}
32 32
 					$templine = '';
@@ -43,21 +43,21 @@  discard block
 block discarded – undo
43 43
 		$error = '';
44 44
 		$dh = opendir($directory);
45 45
 		//foreach (new RecursiveIteratorIterator(new RecursiveDirectoryIterator($directory)) as $filename)
46
-		while(false !== ($filename = readdir($dh)))
46
+		while (false !== ($filename = readdir($dh)))
47 47
 		{
48
-			if (preg_match('/\.sql$/',$filename)) $error .= create_db::import_file($directory.$filename);
48
+			if (preg_match('/\.sql$/', $filename)) $error .= create_db::import_file($directory.$filename);
49 49
 		}
50 50
 		return $error;
51 51
 	}
52 52
 
53
-	public static function create_database($root,$root_pass,$user,$pass,$db,$db_type,$host,$port = '') {
54
-		$root = filter_var($root,FILTER_SANITIZE_STRING);
55
-		$root_pass = filter_var($root_pass,FILTER_SANITIZE_STRING);
56
-		$user = filter_var($user,FILTER_SANITIZE_STRING);
57
-		$password = filter_var($pass,FILTER_SANITIZE_STRING);
58
-		$db = filter_var($db,FILTER_SANITIZE_STRING);
59
-		$db_type = filter_var($db_type,FILTER_SANITIZE_STRING);
60
-		$host = filter_var($host,FILTER_SANITIZE_STRING);
53
+	public static function create_database($root, $root_pass, $user, $pass, $db, $db_type, $host, $port = '') {
54
+		$root = filter_var($root, FILTER_SANITIZE_STRING);
55
+		$root_pass = filter_var($root_pass, FILTER_SANITIZE_STRING);
56
+		$user = filter_var($user, FILTER_SANITIZE_STRING);
57
+		$password = filter_var($pass, FILTER_SANITIZE_STRING);
58
+		$db = filter_var($db, FILTER_SANITIZE_STRING);
59
+		$db_type = filter_var($db_type, FILTER_SANITIZE_STRING);
60
+		$host = filter_var($host, FILTER_SANITIZE_STRING);
61 61
 		if ($db_type == 'mysql' && $port == '') $port = 3306;
62 62
 		elseif ($port == '') $port = 5432;
63 63
 		// Dirty hack
@@ -65,8 +65,8 @@  discard block
 block discarded – undo
65 65
 			$grantright = $_SERVER['SERVER_ADDR'];
66 66
 		} else $grantright = 'localhost';
67 67
 		try {
68
-			if ($host == 'localhost') $dbh = new PDO($db_type.':host=127.0.0.1',$root,$root_pass);
69
-			else $dbh = new PDO($db_type.':host='.$host.';port='.$port,$root,$root_pass);
68
+			if ($host == 'localhost') $dbh = new PDO($db_type.':host=127.0.0.1', $root, $root_pass);
69
+			else $dbh = new PDO($db_type.':host='.$host.';port='.$port, $root, $root_pass);
70 70
 			$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
71 71
 			if ($db_type == 'mysql') {
72 72
 				$dbh->exec('CREATE DATABASE IF NOT EXISTS `'.$db.'`;GRANT ALL ON `'.$db."`.* TO '".$user."'@'".$grantright."' IDENTIFIED BY '".$password."';FLUSH PRIVILEGES;");
@@ -76,7 +76,7 @@  discard block
 block discarded – undo
76 76
 				$dbh->exec("CREATE USER ".$user." WITH PASSWORD '".$password."';
77 77
 					GRANT ALL PRIVILEGES ON DATABASE ".$db." TO ".$user.";");
78 78
 			}
79
-		} catch(PDOException $e) {
79
+		} catch (PDOException $e) {
80 80
 			$dbh = null;
81 81
 			return "error : ".$e->getMessage();
82 82
 		}
Please login to merge, or discard this patch.
install/install-action.php 1 patch
Spacing   +72 added lines, -72 removed lines patch added patch discarded remove patch
@@ -70,15 +70,15 @@  discard block
 block discarded – undo
70 70
 	$globalDebug = FALSE;
71 71
 	$dbroot = $_SESSION['database_root'];
72 72
 	$dbrootpass = $_SESSION['database_rootpass'];
73
-	$error .= create_db::create_database($dbroot,$dbrootpass,$globalDBuser,$globalDBpass,$globalDBname,$globalDBdriver,$globalDBhost);
73
+	$error .= create_db::create_database($dbroot, $dbrootpass, $globalDBuser, $globalDBpass, $globalDBname, $globalDBdriver, $globalDBhost);
74 74
 	sleep(5);
75 75
 	if ($error != '') {
76 76
 		$_SESSION['error'] = $error;
77
-		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Create database'));
78
-	} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Create database'));
77
+		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Create database'));
78
+	} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Create database'));
79 79
 	$_SESSION['install'] = 'database_import';
80 80
 	$_SESSION['next'] = 'Create and import tables';
81
-	$result = array('error' => $error,'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
81
+	$result = array('error' => $error, 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
82 82
 	print json_encode($result);
83 83
 } else if (isset($_SESSION['install']) && $_SESSION['install'] == 'database_import') {
84 84
 	$globalDebug = FALSE;
@@ -92,8 +92,8 @@  discard block
 block discarded – undo
92 92
 		}
93 93
 		if ($error != '') {
94 94
 			$_SESSION['error'] = $error;
95
-			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Create and import tables'));
96
-		} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Create and import tables'));
95
+			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Create and import tables'));
96
+		} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Create and import tables'));
97 97
 		if ($globalSBS1 && !$globalIVAO && !$globalVATSIM && !$globalphpVMS) {
98 98
 			$_SESSION['install'] = 'populate';
99 99
 			$_SESSION['next'] = 'Populate aircraft_modes table with externals data for ADS-B';
@@ -101,23 +101,23 @@  discard block
 block discarded – undo
101 101
 		    $_SESSION['install'] = 'sources';
102 102
 		    $_SESSION['next'] = 'Insert data in source table';
103 103
 		}
104
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
104
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
105 105
 		print json_encode($result);
106 106
 	} elseif (!is_numeric($check_version)) {
107 107
 		$error .= $check_version;
108 108
 		$_SESSION['error'] = $error;
109
-		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Create and import tables'));
110
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
109
+		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Create and import tables'));
110
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
111 111
 		print json_encode($result);
112 112
 	} else {
113 113
 		$error .= update_schema::check_version(true);
114 114
 		if ($error != '') {
115 115
 			$_SESSION['error'] = $error;
116
-			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Update schema if needed'));
117
-		} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Update schema if needed'));
116
+			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Update schema if needed'));
117
+		} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Update schema if needed'));
118 118
 		$_SESSION['install'] = 'sources';
119 119
 		$_SESSION['next'] = 'Insert data in source table';
120
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
120
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
121 121
 		print json_encode($result);
122 122
 	}
123 123
 } else if (isset($_SESSION['install']) && $_SESSION['install'] == 'waypoints') {
@@ -126,11 +126,11 @@  discard block
 block discarded – undo
126 126
 	$error .= update_db::update_waypoints();
127 127
 	if ($error != '') {
128 128
 		$_SESSION['error'] = $error;
129
-		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate waypoints database'));
130
-	} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Populate waypoints database'));
129
+		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate waypoints database'));
130
+	} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Populate waypoints database'));
131 131
 	$_SESSION['install'] = 'airspace';
132 132
 	$_SESSION['next'] = 'Populate airspace table';
133
-	$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
133
+	$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
134 134
 	print json_encode($result);
135 135
 } else if (isset($_SESSION['install']) && $_SESSION['install'] == 'airspace') {
136 136
 	include_once('class.update_db.php');
@@ -138,11 +138,11 @@  discard block
 block discarded – undo
138 138
 	$error .= update_db::update_airspace_fam();
139 139
 	if ($error != '') {
140 140
 		$_SESSION['error'] = $error;
141
-		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate airspace database'));
142
-	} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Populate airspace database'));
141
+		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate airspace database'));
142
+	} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Populate airspace database'));
143 143
 	$_SESSION['install'] = 'countries';
144 144
 	$_SESSION['next'] = 'Populate countries table';
145
-	$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
145
+	$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
146 146
 	print json_encode($result);
147 147
 } else if (isset($_SESSION['install']) && $_SESSION['install'] == 'countries') {
148 148
 	include_once('class.update_db.php');
@@ -150,31 +150,31 @@  discard block
 block discarded – undo
150 150
 	$error .= update_db::update_countries();
151 151
 	if ($error != '') {
152 152
 		$_SESSION['error'] = $error;
153
-		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate countries database'));
154
-	} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Populate countries database'));
153
+		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate countries database'));
154
+	} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Populate countries database'));
155 155
 	if (isset($globalNOTAM) && $globalNOTAM && isset($globalNOTAMSource) && $globalNOTAMSource != '') {
156 156
 	    $_SESSION['install'] = 'notam';
157 157
 	    $_SESSION['next'] = 'Populate NOTAM table with externals data';
158
-	    $result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
158
+	    $result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
159 159
 	    print json_encode($result);
160 160
 	} elseif (isset($_SESSION['owner']) && $_SESSION['owner'] == 1) {
161 161
 	    $_SESSION['install'] = 'owner';
162 162
 	    $_SESSION['next'] = 'Populate owner table with externals data';
163 163
 	    unset($_SESSION['owner']);
164
-	    $result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
164
+	    $result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
165 165
 	    print json_encode($result);
166 166
 	} else {
167 167
 	    $_SESSION['install'] = 'sources';
168 168
 	    $_SESSION['next'] = 'Insert data in source table';
169
-	    $result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
169
+	    $result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
170 170
 	    print json_encode($result);
171 171
 	}
172 172
 } else if (isset($_SESSION['install']) && $_SESSION['install'] == 'populate') {
173 173
 	if (!is_writable('tmp')) {
174 174
 		$error = 'The directory <i>install/tmp</i> must be writable.';
175 175
 		$_SESSION['error'] = $error;
176
-		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate aircraft_modes table with externals data for ADS-B'));
177
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
176
+		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate aircraft_modes table with externals data for ADS-B'));
177
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
178 178
 		print json_encode($result);
179 179
 	} else {
180 180
 		include_once('class.update_db.php');
@@ -182,19 +182,19 @@  discard block
 block discarded – undo
182 182
 		$error .= update_db::update_ModeS_fam();
183 183
 		if ($error != '') {
184 184
 			$_SESSION['error'] = $error;
185
-			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate aircraft_modes table with externals data for ADS-B'));
186
-		} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Populate aircraft_modes table with externals data for ADS-B'));
185
+			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate aircraft_modes table with externals data for ADS-B'));
186
+		} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Populate aircraft_modes table with externals data for ADS-B'));
187 187
 		$_SESSION['install'] = 'populate_flarm';
188 188
 		$_SESSION['next'] = 'Populate aircraft_modes table with externals data for FLARM';
189
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
189
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
190 190
 		print json_encode($result);
191 191
 	}
192 192
 } else if (isset($_SESSION['install']) && $_SESSION['install'] == 'populate_flarm') {
193 193
 	if (!is_writable('tmp')) {
194 194
 		$error = 'The directory <i>install/tmp</i> must be writable.';
195 195
 		$_SESSION['error'] = $error;
196
-		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate aircraft_modes table with externals data for FLARM'));
197
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
196
+		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate aircraft_modes table with externals data for FLARM'));
197
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
198 198
 		print json_encode($result);
199 199
 	} else {
200 200
 		include_once('class.update_db.php');
@@ -203,8 +203,8 @@  discard block
 block discarded – undo
203 203
 		$error .= update_db::update_ModeS_ogn();
204 204
 		if ($error != '') {
205 205
 			$_SESSION['error'] = $error;
206
-			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate aircraft_modes table with externals data for FLARM'));
207
-		} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Populate aircraft_modes table with externals data for FLARM'));
206
+			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate aircraft_modes table with externals data for FLARM'));
207
+		} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Populate aircraft_modes table with externals data for FLARM'));
208 208
 		if ((isset($globalVATSIM) && $globalVATSIM) && (isset($globalIVAO) && $globalIVAO)) {
209 209
 			$_SESSION['install'] = 'vatsim';
210 210
 			if (file_exists('tmp/ivae_feb2013.zip')) $_SESSION['next'] = 'Insert IVAO data';
@@ -223,15 +223,15 @@  discard block
 block discarded – undo
223 223
 			$_SESSION['install'] = 'routes';
224 224
 			$_SESSION['next'] = 'Populate routes table with externals data';
225 225
 		}
226
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
226
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
227 227
 		print json_encode($result);
228 228
 	}
229 229
 } else if (isset($_SESSION['install']) && $_SESSION['install'] == 'routes') {
230 230
 	if (!is_writable('tmp')) {
231 231
 		$error = 'The directory <i>install/tmp</i> must be writable.';
232 232
 		$_SESSION['error'] = $error;
233
-		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate aircraft_modes table with externals data for ADS-B'));
234
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
233
+		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate aircraft_modes table with externals data for ADS-B'));
234
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
235 235
 		print json_encode($result);
236 236
 	} else {
237 237
 		include_once('class.update_db.php');
@@ -239,19 +239,19 @@  discard block
 block discarded – undo
239 239
 		$error .= update_db::update_routes_fam();
240 240
 		if ($error != '') {
241 241
 			$_SESSION['error'] = $error;
242
-			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate routes table with externals data'));
243
-		} else 	$_SESSION['done'] = array_merge($_SESSION['done'],array('Populate routes table with externals data'));
242
+			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate routes table with externals data'));
243
+		} else 	$_SESSION['done'] = array_merge($_SESSION['done'], array('Populate routes table with externals data'));
244 244
 		$_SESSION['install'] = 'translation';
245 245
 		$_SESSION['next'] = 'Populate translation table with externals data';
246
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
246
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
247 247
 		print json_encode($result);
248 248
 	}
249 249
 } else if (isset($_SESSION['install']) && $_SESSION['install'] == 'translation') {
250 250
 	if (!is_writable('tmp')) {
251 251
 		$error = 'The directory <i>install/tmp</i> must be writable.';
252 252
 		$_SESSION['error'] = $error;
253
-		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate translation table with externals data'));
254
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
253
+		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate translation table with externals data'));
254
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
255 255
 		print json_encode($result);
256 256
 	} else {
257 257
 		include_once('class.update_db.php');
@@ -259,8 +259,8 @@  discard block
 block discarded – undo
259 259
 		$error .= update_db::update_translation_fam();
260 260
 		if ($error != '') {
261 261
 			$_SESSION['error'] = $error;
262
-			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate translation table with externals data'));
263
-		} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Populate translation table with externals data'));
262
+			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate translation table with externals data'));
263
+		} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Populate translation table with externals data'));
264 264
 		if ($_SESSION['waypoints'] == 1) {
265 265
 			$_SESSION['install'] = 'waypoints';
266 266
 			$_SESSION['next'] = 'Populate waypoints table';
@@ -276,15 +276,15 @@  discard block
 block discarded – undo
276 276
 			$_SESSION['install'] = 'sources';
277 277
 			$_SESSION['next'] = 'Insert data in source table';
278 278
 		}
279
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
279
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
280 280
 		print json_encode($result);
281 281
 	}
282 282
 } else if (isset($_SESSION['install']) && $_SESSION['install'] == 'owner') {
283 283
 	if (!is_writable('tmp')) {
284 284
 		$error = 'The directory <i>install/tmp</i> must be writable.';
285 285
 		$_SESSION['error'] = $error;
286
-		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate owner table with externals data'));
287
-		$result = array('error' => $error,'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
286
+		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate owner table with externals data'));
287
+		$result = array('error' => $error, 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
288 288
 		print json_encode($result);
289 289
 	} else {
290 290
 		include_once('class.update_db.php');
@@ -292,19 +292,19 @@  discard block
 block discarded – undo
292 292
 		$error = update_db::update_owner_fam();
293 293
 		if ($error != '') {
294 294
 			$_SESSION['error'] = $error;
295
-			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate owner table with externals data'));
296
-		} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Populate owner table with externals data'));
295
+			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate owner table with externals data'));
296
+		} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Populate owner table with externals data'));
297 297
 		$_SESSION['install'] = 'sources';
298 298
 		$_SESSION['next'] = 'Insert data in source table';
299
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
299
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
300 300
 		print json_encode($result);
301 301
 	}
302 302
 } else if (isset($_SESSION['install']) && $_SESSION['install'] == 'notam') {
303 303
 	if (!is_writable('tmp')) {
304 304
 		$error = 'The directory <i>install/tmp</i> must be writable.';
305 305
 		$_SESSION['error'] = $error;
306
-		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate notam table with externals data'));
307
-		$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
306
+		$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate notam table with externals data'));
307
+		$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
308 308
 		print json_encode($result);
309 309
 	} else {
310 310
 		include_once('class.update_db.php');
@@ -313,24 +313,24 @@  discard block
 block discarded – undo
313 313
 			$error .= update_db::update_notam();
314 314
 			if ($error != '') {
315 315
 				$_SESSION['error'] = $error;
316
-				$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate notam table with externals data'));
317
-			} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Populate notam table with externals data'));
316
+				$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate notam table with externals data'));
317
+			} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Populate notam table with externals data'));
318 318
 		} else {
319 319
 			if ($error != '') {
320 320
 				$_SESSION['error'] = $error;
321
-				$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Populate notam table with externals data (no source defined)'));
322
-			} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Populate notam table with externals data (no source defined)'));
321
+				$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Populate notam table with externals data (no source defined)'));
322
+			} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Populate notam table with externals data (no source defined)'));
323 323
 		}
324 324
 		if (isset($_SESSION['owner']) && $_SESSION['owner'] == 1) {
325 325
 			$_SESSION['install'] = 'owner';
326 326
 			$_SESSION['next'] = 'Populate owner table';
327 327
 			unset($_SESSION['owner']);
328
-			$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
328
+			$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
329 329
 			print json_encode($result);
330 330
 		} else {
331 331
 			$_SESSION['install'] = 'sources';
332 332
 			$_SESSION['next'] = 'Insert data in source table';
333
-			$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
333
+			$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
334 334
 			print json_encode($result);
335 335
 		}
336 336
 	}
@@ -367,9 +367,9 @@  discard block
 block discarded – undo
367 367
 		$Source = new Source();
368 368
 		$Source->deleteAllLocation();
369 369
 		foreach ($sources as $src) {
370
-			if (isset($src['latitude']) && $src['latitude'] != '') $Source->addLocation($src['name'],$src['latitude'],$src['longitude'],$src['altitude'],$src['city'],$src['country'],$src['source'],'antenna.png');
370
+			if (isset($src['latitude']) && $src['latitude'] != '') $Source->addLocation($src['name'], $src['latitude'], $src['longitude'], $src['altitude'], $src['city'], $src['country'], $src['source'], 'antenna.png');
371 371
 		}
372
-		$_SESSION['done'] = array_merge($_SESSION['done'],array('Insert data in source table'));
372
+		$_SESSION['done'] = array_merge($_SESSION['done'], array('Insert data in source table'));
373 373
 		unset($_SESSION['sources']);
374 374
 	}
375 375
 	/*
@@ -394,7 +394,7 @@  discard block
 block discarded – undo
394 394
 		$_SESSION['install'] = 'finish';
395 395
 		$_SESSION['next'] = 'finish';
396 396
 	}
397
-	$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
397
+	$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
398 398
 	print json_encode($result);
399 399
 } else if (isset($_SESSION['install']) && $_SESSION['install'] == 'vatsim') {
400 400
 	include_once('../install/class.create_db.php');
@@ -406,48 +406,48 @@  discard block
 block discarded – undo
406 406
 			$error .= update_db::update_IVAO();
407 407
 			if ($error != '') {
408 408
 				$_SESSION['error'] = $error;
409
-				$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Insert IVAO data'));
410
-			} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Insert IVAO data'));
409
+				$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Insert IVAO data'));
410
+			} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Insert IVAO data'));
411 411
 		} else {
412 412
 			$error .= update_db::update_vatsim();
413 413
 			if ($error != '') {
414 414
 				$_SESSION['error'] = $error;
415
-				$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Insert VATSIM data'));
416
-			} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Insert VATSIM data'));
415
+				$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Insert VATSIM data'));
416
+			} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Insert VATSIM data'));
417 417
 		}
418 418
 	} elseif (isset($globalVATSIM) && $globalVATSIM) {
419 419
 		$error .= update_db::update_vatsim();
420 420
 		if ($error != '') {
421 421
 			$_SESSION['error'] = $error;
422
-			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Insert VATSIM data'));
423
-		} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Insert VATSIM data'));
422
+			$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Insert VATSIM data'));
423
+		} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Insert VATSIM data'));
424 424
 	} elseif (isset($globalIVAO) && $globalIVAO) {
425 425
 		if (file_exists('tmp/ivae_feb2013.zip')) {
426 426
 			$error .= update_db::update_IVAO();
427 427
 			if ($error != '') {
428 428
 				$_SESSION['error'] = $error;
429
-				$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Insert IVAO data'));
430
-			} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Insert IVAO data'));
429
+				$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Insert IVAO data'));
430
+			} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Insert IVAO data'));
431 431
 		} else {
432 432
 			$error .= update_db::update_vatsim();
433 433
 			if ($error != '') {
434 434
 				$_SESSION['error'] = $error;
435
-				$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'],array('Insert VATSIM data (IVAO not found)'));
436
-			} else $_SESSION['done'] = array_merge($_SESSION['done'],array('Insert VATSIM data (IVAO not found)'));
435
+				$_SESSION['errorlst'] = array_merge($_SESSION['errorlst'], array('Insert VATSIM data (IVAO not found)'));
436
+			} else $_SESSION['done'] = array_merge($_SESSION['done'], array('Insert VATSIM data (IVAO not found)'));
437 437
 		}
438 438
 	} elseif (isset($globalphpVMS) && $globalphpVMS) {
439
-		$_SESSION['done'] = array_merge($_SESSION['done'],array('Insert phpVMS data'));
439
+		$_SESSION['done'] = array_merge($_SESSION['done'], array('Insert phpVMS data'));
440 440
 	}
441 441
 	//$_SESSION['install'] = 'routes';
442 442
 	//$_SESSION['next'] = 'Populate routes table with externals data';
443 443
 	$_SESSION['install'] = 'finish';
444 444
 	$_SESSION['next'] = 'finish';
445
-	$result = array('error' => $error,'errorlst' => $_SESSION['errorlst'],'done' => $_SESSION['done'],'next' => $_SESSION['next'],'install' => $_SESSION['install']);
445
+	$result = array('error' => $error, 'errorlst' => $_SESSION['errorlst'], 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
446 446
 	print json_encode($result);
447 447
 } else {
448 448
 	//unset($_SESSION['install']);
449 449
 	$_SESSION['error'] = 'Unknwon task : '.$_SESSION['install'];
450
-	$result = array('error' => 'Unknwon task : '.$_SESSION['install'],'done' => $_SESSION['done'],'next' => 'finish','install' => 'finish');
450
+	$result = array('error' => 'Unknwon task : '.$_SESSION['install'], 'done' => $_SESSION['done'], 'next' => 'finish', 'install' => 'finish');
451 451
 	print json_encode($result);
452 452
 }
453 453
 ?>
454 454
\ No newline at end of file
Please login to merge, or discard this patch.
require/class.Satellite.php 1 patch
Spacing   +23 added lines, -23 removed lines patch added patch discarded remove patch
@@ -20,7 +20,7 @@  discard block
 block discarded – undo
20 20
 		try {
21 21
 			$sth = $this->db->prepare($query);
22 22
 			$sth->execute(array(':name' => $name));
23
-		} catch(PDOException $e) {
23
+		} catch (PDOException $e) {
24 24
 			echo $e->getMessage();
25 25
 		}
26 26
 		$result = $sth->fetchAll(PDO::FETCH_ASSOC);
@@ -32,7 +32,7 @@  discard block
 block discarded – undo
32 32
 		try {
33 33
 			$sth = $this->db->prepare($query);
34 34
 			$sth->execute();
35
-		} catch(PDOException $e) {
35
+		} catch (PDOException $e) {
36 36
 			echo $e->getMessage();
37 37
 		}
38 38
 		$result = $sth->fetchAll(PDO::FETCH_ASSOC);
@@ -44,7 +44,7 @@  discard block
 block discarded – undo
44 44
 		try {
45 45
 			$sth = $this->db->prepare($query);
46 46
 			$sth->execute();
47
-		} catch(PDOException $e) {
47
+		} catch (PDOException $e) {
48 48
 			echo $e->getMessage();
49 49
 		}
50 50
 		$result = $sth->fetchAll(PDO::FETCH_ASSOC);
@@ -56,7 +56,7 @@  discard block
 block discarded – undo
56 56
 		try {
57 57
 			$sth = $this->db->prepare($query);
58 58
 			$sth->execute(array(':type' => $type));
59
-		} catch(PDOException $e) {
59
+		} catch (PDOException $e) {
60 60
 			echo $e->getMessage();
61 61
 		}
62 62
 		$result = $sth->fetchAll(PDO::FETCH_ASSOC);
@@ -64,49 +64,49 @@  discard block
 block discarded – undo
64 64
 		else return array();
65 65
 	}
66 66
 	
67
-	public function position_all($timestamp_begin = '',$timestamp_end = '',$second = 10) {
67
+	public function position_all($timestamp_begin = '', $timestamp_end = '', $second = 10) {
68 68
 		$all_sat = $this->get_tle_names();
69 69
 		$result = array();
70 70
 		foreach ($all_sat as $sat) {
71
-			$position = $this->position($sat['tle_name'],$timestamp_begin,$timestamp_end,$second);
72
-			$result = array_merge($position,$result);
71
+			$position = $this->position($sat['tle_name'], $timestamp_begin, $timestamp_end, $second);
72
+			$result = array_merge($position, $result);
73 73
 		}
74 74
 		return $result;
75 75
 	}
76 76
 
77
-	public function position_all_type($type,$timestamp_begin = '',$timestamp_end = '',$second = 10) {
77
+	public function position_all_type($type, $timestamp_begin = '', $timestamp_end = '', $second = 10) {
78 78
 		$all_sat = $this->get_tle_names_type($type);
79 79
 		$result = array();
80 80
 		foreach ($all_sat as $sat) {
81
-			$position = $this->position($sat['tle_name'],$timestamp_begin,$timestamp_end,$second);
82
-			if (isset($position[0])) $result = array_merge($position,$result);
81
+			$position = $this->position($sat['tle_name'], $timestamp_begin, $timestamp_end, $second);
82
+			if (isset($position[0])) $result = array_merge($position, $result);
83 83
 			else $result[] = $position;
84 84
 		}
85 85
 		return $result;
86 86
 	}
87 87
 
88
-	public function position($name,$timestamp_begin = '',$timestamp_end = '',$second = 10) {
88
+	public function position($name, $timestamp_begin = '', $timestamp_end = '', $second = 10) {
89 89
 		$qth = new Predict_QTH();
90 90
 		$qth->lat = floatval(37.790252);
91 91
 		$qth->lon = floatval(-122.419968);
92 92
 	
93 93
 		$tle_file = $this->get_tle($name);
94 94
 		$type = $tle_file['tle_type'];
95
-		$tle = new Predict_TLE($tle_file['tle_name'],$tle_file['tle_tle1'],$tle_file['tle_tle2']);
95
+		$tle = new Predict_TLE($tle_file['tle_name'], $tle_file['tle_tle1'], $tle_file['tle_tle2']);
96 96
 		$sat = new Predict_Sat($tle);
97 97
 		$predict = new Predict();
98 98
 		//if ($timestamp == '') $now = Predict_Time::get_current_daynum();
99 99
 		if ($timestamp_begin == '') $timestamp_begin = time();
100 100
 		if ($timestamp_end == '') {
101 101
 			$now = Predict_Time::unix2daynum($timestamp_begin);
102
-			$predict->predict_calc($sat,$qth,$now);
103
-			return array('name' => $name, 'latitude' => $sat->ssplat,'longitude' => $sat->ssplon, 'altitude' => $sat->alt,'speed' => $sat->velo*60*60,'timestamp' => $timestamp_begin,'type' => $type);
102
+			$predict->predict_calc($sat, $qth, $now);
103
+			return array('name' => $name, 'latitude' => $sat->ssplat, 'longitude' => $sat->ssplon, 'altitude' => $sat->alt, 'speed' => $sat->velo*60*60, 'timestamp' => $timestamp_begin, 'type' => $type);
104 104
 		} else {
105 105
 			$result = array();
106
-			for ($timestamp = $timestamp_begin; $timestamp <= $timestamp_end; $timestamp=$timestamp+$second) {
106
+			for ($timestamp = $timestamp_begin; $timestamp <= $timestamp_end; $timestamp = $timestamp + $second) {
107 107
 				$now = Predict_Time::unix2daynum($timestamp);
108
-				$predict->predict_calc($sat,$qth,$now);
109
-				$result[] = array('name' => $name,'latitude' => $sat->ssplat,'longitude' => $sat->ssplon, 'altitude' => $sat->alt,'speed' => $sat->velo*60*60,'timestamp' => $timestamp,'type' => $type);
108
+				$predict->predict_calc($sat, $qth, $now);
109
+				$result[] = array('name' => $name, 'latitude' => $sat->ssplat, 'longitude' => $sat->ssplon, 'altitude' => $sat->alt, 'speed' => $sat->velo*60*60, 'timestamp' => $timestamp, 'type' => $type);
110 110
 			}
111 111
 			return $result;
112 112
 		}
@@ -117,7 +117,7 @@  discard block
 block discarded – undo
117 117
 		try {
118 118
 			$sth = $this->db->prepare($query);
119 119
 			$sth->execute(array(':name' => $name.'%'));
120
-		} catch(PDOException $e) {
120
+		} catch (PDOException $e) {
121 121
 			echo $e->getMessage();
122 122
 		}
123 123
 		$result = $sth->fetchAll(PDO::FETCH_ASSOC);
@@ -145,7 +145,7 @@  discard block
 block discarded – undo
145 145
 		$sth->execute($query_values);
146 146
 		$launch_site_array = array();
147 147
 		$temp_array = array();
148
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
148
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
149 149
 		{
150 150
 			$temp_array['launch_site'] = $row['launch_site'];
151 151
 			$temp_array['launch_site_count'] = $row['launch_site_count'];
@@ -174,7 +174,7 @@  discard block
 block discarded – undo
174 174
 		$sth->execute($query_values);
175 175
 		$owner_array = array();
176 176
 		$temp_array = array();
177
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
177
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
178 178
 		{
179 179
 			$temp_array['owner_name'] = $row['owner_name'];
180 180
 			$temp_array['owner_count'] = $row['owner_count'];
@@ -203,7 +203,7 @@  discard block
 block discarded – undo
203 203
 		$sth->execute($query_values);
204 204
 		$owner_array = array();
205 205
 		$temp_array = array();
206
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
206
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
207 207
 		{
208 208
 			$temp_array['country_name'] = $row['country_name'];
209 209
 			$temp_array['country_count'] = $row['country_count'];
@@ -247,7 +247,7 @@  discard block
 block discarded – undo
247 247
 		$sth->execute($query_data);
248 248
 		$date_array = array();
249 249
 		$temp_array = array();
250
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
250
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
251 251
 		{
252 252
 			$temp_array['year_name'] = $row['year_name'];
253 253
 			$temp_array['month_name'] = $row['month_name'];
@@ -292,7 +292,7 @@  discard block
 block discarded – undo
292 292
 		$sth->execute($query_data);
293 293
 		$date_array = array();
294 294
 		$temp_array = array();
295
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
295
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
296 296
 		{
297 297
 			$temp_array['year_name'] = $row['year_name'];
298 298
 			$temp_array['date_count'] = $row['date_count'];
Please login to merge, or discard this patch.
live-sat-geojson.php 1 patch
Spacing   +14 added lines, -14 removed lines patch added patch discarded remove patch
@@ -13,7 +13,7 @@  discard block
 block discarded – undo
13 13
 		header('Content-disposition: attachment; filename="flightairmap-sat.json"');
14 14
 	}
15 15
 }
16
-$history = urldecode(filter_input(INPUT_GET,'history',FILTER_SANITIZE_STRING));
16
+$history = urldecode(filter_input(INPUT_GET, 'history', FILTER_SANITIZE_STRING));
17 17
 header('Content-Type: text/javascript');
18 18
 
19 19
 $begintime = microtime(true);
@@ -21,10 +21,10 @@  discard block
 block discarded – undo
21 21
 
22 22
 $spotter_array = array();
23 23
 if (isset($_COOKIE['sattypes']) && $_COOKIE['sattypes'] != '') {
24
-	$sattypes = explode(',',$_COOKIE['sattypes']);
24
+	$sattypes = explode(',', $_COOKIE['sattypes']);
25 25
 	foreach ($sattypes as $sattype) {
26 26
 		//$spotter_array = array_merge($Satellite->position_all_type($sattype,$timeb-$globalLiveInterval,$timeb),$spotter_array);
27
-		$spotter_array = array_merge($Satellite->position_all_type($sattype),$spotter_array);
27
+		$spotter_array = array_merge($Satellite->position_all_type($sattype), $spotter_array);
28 28
 	}
29 29
 }
30 30
 
@@ -36,7 +36,7 @@  discard block
 block discarded – undo
36 36
 
37 37
 //$spotter_array = array_unique($spotter_array,SORT_REGULAR);
38 38
 //print_r($spotter_array);
39
-$sqltime = round(microtime(true)-$begintime,2);
39
+$sqltime = round(microtime(true) - $begintime, 2);
40 40
 
41 41
 $output = '{"type":"FeatureCollection","features":[';
42 42
 if (!empty($spotter_array) && is_array($spotter_array))
@@ -44,7 +44,7 @@  discard block
 block discarded – undo
44 44
 	$last_name = '';
45 45
 	$coordinatearray = '';
46 46
 	$timearray = array();
47
-	foreach($spotter_array as $spotter_item)
47
+	foreach ($spotter_array as $spotter_item)
48 48
 	{
49 49
 		$output_data = '';
50 50
 		$output_data .= '{"type":"Feature","properties":{';
@@ -61,14 +61,14 @@  discard block
 block discarded – undo
61 61
 		}
62 62
 		$output_data .= '"altitude":0,';
63 63
 		$output_data .= '"sqt":'.$sqltime.',';
64
-		$nextlatlon = $Satellite->position($spotter_item['name'],time()+$globalMapRefresh+20);
64
+		$nextlatlon = $Satellite->position($spotter_item['name'], time() + $globalMapRefresh + 20);
65 65
 		$nextlat = $nextlatlon['latitude'];
66
-		if (abs($nextlat-$spotter_item['latitude']) > 90) {
66
+		if (abs($nextlat - $spotter_item['latitude']) > 90) {
67 67
 			if ($spotter_item['latitude'] < 0) $nexlat = -90;
68 68
 			else $nexlat = 90;
69 69
 		}
70 70
 		$nextlon = $nextlatlon['longitude'];
71
-		if (abs($nextlon-$spotter_item['longitude']) > 180) {
71
+		if (abs($nextlon - $spotter_item['longitude']) > 180) {
72 72
 			if ($spotter_item['longitude'] < 0) $nextlon = -180;
73 73
 			else $nextlon = 180;
74 74
 		}
@@ -79,27 +79,27 @@  discard block
 block discarded – undo
79 79
 		$output_data .= ']}},';
80 80
 		$output .= $output_data;
81 81
 		if ($history == $spotter_item['name']) {
82
-			$spotter_history_array = $Satellite->position($spotter_item['name'],time()-6000,time());
82
+			$spotter_history_array = $Satellite->position($spotter_item['name'], time() - 6000, time());
83 83
 			$spotter_history_array = array_reverse($spotter_history_array);
84 84
 			$output_history = '{"type": "Feature","properties": {"callsign": "'.$spotter_item['name'].'","type": "history"},"geometry": {"type": "LineString","coordinates": [';
85 85
 			foreach ($spotter_history_array as $key => $spotter_history) {
86
-				if ((isset($previous_lon) && abs($previous_lon-$spotter_history['longitude']) > 180) || (isset($previous_lat) && abs($previous_lat-$spotter_history['latitude']) > 90)) {
86
+				if ((isset($previous_lon) && abs($previous_lon - $spotter_history['longitude']) > 180) || (isset($previous_lat) && abs($previous_lat - $spotter_history['latitude']) > 90)) {
87 87
 					break;
88 88
 				}
89 89
 				$output_history .= '[';
90
-				$output_history .=  $spotter_history['longitude'].', ';
91
-				$output_history .=  $spotter_history['latitude'];
90
+				$output_history .= $spotter_history['longitude'].', ';
91
+				$output_history .= $spotter_history['latitude'];
92 92
 				$output_history .= '],';
93 93
 				$previous_lon = $spotter_history['longitude'];
94 94
 				$previous_lat = $spotter_history['latitude'];
95 95
 			}
96
-			$output_history = substr($output_history,0,-1);
96
+			$output_history = substr($output_history, 0, -1);
97 97
 			$output_history .= ']}},';
98 98
 			$output .= $output_history;
99 99
 		}
100 100
 	}
101 101
 }
102
-if (isset($output_data)) $output = substr($output,0,-1);
102
+if (isset($output_data)) $output = substr($output, 0, -1);
103 103
 $output .= ']}';
104 104
 print $output;
105 105
 ?>
Please login to merge, or discard this patch.