@@ -42,7 +42,9 @@ discard block |
||
42 | 42 | } |
43 | 43 | $Stats = new Stats(); |
44 | 44 | $airline_names = $Stats->getAllAirlineNames(); |
45 | - if (empty($airline_names)) $airline_names = $Spotter->getAllAirlineNames(); |
|
45 | + if (empty($airline_names)) { |
|
46 | + $airline_names = $Spotter->getAllAirlineNames(); |
|
47 | + } |
|
46 | 48 | foreach($airline_names as $airline_name) |
47 | 49 | { |
48 | 50 | if($airline == $airline_name['airline_icao']) |
@@ -65,8 +67,7 @@ discard block |
||
65 | 67 | if ($globalIVAO && @getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif')) |
66 | 68 | { |
67 | 69 | print '<img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif" alt="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" title="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" class="logo" />'; |
68 | - } |
|
69 | - elseif (@getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png')) |
|
70 | + } elseif (@getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png')) |
|
70 | 71 | { |
71 | 72 | print '<img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png" alt="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" title="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" class="logo" />'; |
72 | 73 | } |
@@ -42,7 +42,9 @@ discard block |
||
42 | 42 | } |
43 | 43 | $Stats = new Stats(); |
44 | 44 | $airline_names = $Stats->getAllAirlineNames(); |
45 | - if (empty($airline_names)) $airline_names = $Spotter->getAllAirlineNames(); |
|
45 | + if (empty($airline_names)) { |
|
46 | + $airline_names = $Spotter->getAllAirlineNames(); |
|
47 | + } |
|
46 | 48 | foreach($airline_names as $airline_name) |
47 | 49 | { |
48 | 50 | if($airline == $airline_name['airline_icao']) |
@@ -65,8 +67,7 @@ discard block |
||
65 | 67 | if ($globalIVAO && @getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif')) |
66 | 68 | { |
67 | 69 | print '<img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif" alt="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" title="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" class="logo" />'; |
68 | - } |
|
69 | - elseif (@getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png')) |
|
70 | + } elseif (@getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png')) |
|
70 | 71 | { |
71 | 72 | print '<img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png" alt="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" title="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" class="logo" />'; |
72 | 73 | } |
@@ -42,7 +42,9 @@ discard block |
||
42 | 42 | } |
43 | 43 | $Stats = new Stats(); |
44 | 44 | $airline_names = $Stats->getAllAirlineNames(); |
45 | - if (empty($airline_names)) $airline_names = $Spotter->getAllAirlineNames(); |
|
45 | + if (empty($airline_names)) { |
|
46 | + $airline_names = $Spotter->getAllAirlineNames(); |
|
47 | + } |
|
46 | 48 | foreach($airline_names as $airline_name) |
47 | 49 | { |
48 | 50 | if($airline == $airline_name['airline_icao']) |
@@ -65,8 +67,7 @@ discard block |
||
65 | 67 | if ($globalIVAO && @getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif')) |
66 | 68 | { |
67 | 69 | print '<img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif" alt="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" title="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" class="logo" />'; |
68 | - } |
|
69 | - elseif (@getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png')) |
|
70 | + } elseif (@getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png')) |
|
70 | 71 | { |
71 | 72 | print '<img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png" alt="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" title="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" class="logo" />'; |
72 | 73 | } |
@@ -42,7 +42,9 @@ discard block |
||
42 | 42 | } |
43 | 43 | $Stats = new Stats(); |
44 | 44 | $airline_names = $Stats->getAllAirlineNames(); |
45 | - if (empty($airline_names)) $airline_names = $Spotter->getAllAirlineNames(); |
|
45 | + if (empty($airline_names)) { |
|
46 | + $airline_names = $Spotter->getAllAirlineNames(); |
|
47 | + } |
|
46 | 48 | foreach($airline_names as $airline_name) |
47 | 49 | { |
48 | 50 | if($airline == $airline_name['airline_icao']) |
@@ -65,8 +67,7 @@ discard block |
||
65 | 67 | if ($globalIVAO && @getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif')) |
66 | 68 | { |
67 | 69 | print '<img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif" alt="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" title="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" class="logo" />'; |
68 | - } |
|
69 | - elseif (@getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png')) |
|
70 | + } elseif (@getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png')) |
|
70 | 71 | { |
71 | 72 | print '<img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png" alt="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" title="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" class="logo" />'; |
72 | 73 | } |
@@ -17,7 +17,9 @@ discard block |
||
17 | 17 | curl_setopt($ch, CURLOPT_URL, $url); |
18 | 18 | curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); |
19 | 19 | curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); |
20 | - if ($referer != '') curl_setopt($ch, CURLOPT_REFERER, $referer); |
|
20 | + if ($referer != '') { |
|
21 | + curl_setopt($ch, CURLOPT_REFERER, $referer); |
|
22 | + } |
|
21 | 23 | curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 GTB5'); |
22 | 24 | curl_setopt($ch, CURLOPT_FILE, $fp); |
23 | 25 | curl_exec($ch); |
@@ -28,12 +30,16 @@ discard block |
||
28 | 30 | public static function gunzip($in_file,$out_file_name = '') { |
29 | 31 | //echo $in_file.' -> '.$out_file_name."\n"; |
30 | 32 | $buffer_size = 4096; // read 4kb at a time |
31 | - if ($out_file_name == '') $out_file_name = str_replace('.gz', '', $in_file); |
|
33 | + if ($out_file_name == '') { |
|
34 | + $out_file_name = str_replace('.gz', '', $in_file); |
|
35 | + } |
|
32 | 36 | if ($in_file != '' && file_exists($in_file)) { |
33 | 37 | // PHP version of Ubuntu use gzopen64 instead of gzopen |
34 | - if (function_exists('gzopen')) $file = gzopen($in_file,'rb'); |
|
35 | - elseif (function_exists('gzopen64')) $file = gzopen64($in_file,'rb'); |
|
36 | - else { |
|
38 | + if (function_exists('gzopen')) { |
|
39 | + $file = gzopen($in_file,'rb'); |
|
40 | + } elseif (function_exists('gzopen64')) { |
|
41 | + $file = gzopen64($in_file,'rb'); |
|
42 | + } else { |
|
37 | 43 | echo 'gzopen not available'; |
38 | 44 | die; |
39 | 45 | } |
@@ -54,8 +60,12 @@ discard block |
||
54 | 60 | if ($res === TRUE) { |
55 | 61 | $zip->extractTo($path); |
56 | 62 | $zip->close(); |
57 | - } else return false; |
|
58 | - } else return false; |
|
63 | + } else { |
|
64 | + return false; |
|
65 | + } |
|
66 | + } else { |
|
67 | + return false; |
|
68 | + } |
|
59 | 69 | } |
60 | 70 | |
61 | 71 | public static function connect_sqlite($database) { |
@@ -70,7 +80,9 @@ discard block |
||
70 | 80 | public static function retrieve_route_sqlite_to_dest($database_file) { |
71 | 81 | global $globalDebug, $globalTransaction; |
72 | 82 | //$query = 'TRUNCATE TABLE routes'; |
73 | - if ($globalDebug) echo " - Delete previous routes from DB -"; |
|
83 | + if ($globalDebug) { |
|
84 | + echo " - Delete previous routes from DB -"; |
|
85 | + } |
|
74 | 86 | $query = "DELETE FROM routes WHERE Source = '' OR Source = :source"; |
75 | 87 | $Connection = new Connection(); |
76 | 88 | try { |
@@ -81,7 +93,9 @@ discard block |
||
81 | 93 | return "error : ".$e->getMessage(); |
82 | 94 | } |
83 | 95 | |
84 | - if ($globalDebug) echo " - Add routes to DB -"; |
|
96 | + if ($globalDebug) { |
|
97 | + echo " - Add routes to DB -"; |
|
98 | + } |
|
85 | 99 | update_db::connect_sqlite($database_file); |
86 | 100 | //$query = 'select Route.RouteID, Route.callsign, operator.Icao AS operator_icao, FromAir.Icao AS FromAirportIcao, ToAir.Icao AS ToAirportIcao from Route inner join operator ON Route.operatorId = operator.operatorId LEFT JOIN Airport AS FromAir ON route.FromAirportId = FromAir.AirportId LEFT JOIN Airport AS ToAir ON ToAir.AirportID = route.ToAirportID'; |
87 | 101 | $query = "select Route.RouteID, Route.callsign, operator.Icao AS operator_icao, FromAir.Icao AS FromAirportIcao, ToAir.Icao AS ToAirportIcao, rstp.allstop AS AllStop from Route inner join operator ON Route.operatorId = operator.operatorId LEFT JOIN Airport AS FromAir ON route.FromAirportId = FromAir.AirportId LEFT JOIN Airport AS ToAir ON ToAir.AirportID = route.ToAirportID LEFT JOIN (select RouteId,GROUP_CONCAT(icao,' ') as allstop from routestop left join Airport as air ON routestop.AirportId = air.AirportID group by RouteID) AS rstp ON Route.RouteID = rstp.RouteID"; |
@@ -96,15 +110,21 @@ discard block |
||
96 | 110 | $Connection = new Connection(); |
97 | 111 | $sth_dest = $Connection->db->prepare($query_dest); |
98 | 112 | try { |
99 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
113 | + if ($globalTransaction) { |
|
114 | + $Connection->db->beginTransaction(); |
|
115 | + } |
|
100 | 116 | while ($values = $sth->fetch(PDO::FETCH_ASSOC)) { |
101 | 117 | //$query_dest_values = array(':RouteID' => $values['RouteId'],':CallSign' => $values['Callsign'],':Operator_ICAO' => $values['operator_icao'],':FromAirport_ICAO' => $values['FromAirportIcao'],':ToAirport_ICAO' => $values['ToAirportIcao'],':routestop' => $values['AllStop'],':source' => $database_file); |
102 | 118 | $query_dest_values = array(':CallSign' => $values['Callsign'],':Operator_ICAO' => $values['operator_icao'],':FromAirport_ICAO' => $values['FromAirportIcao'],':ToAirport_ICAO' => $values['ToAirportIcao'],':routestop' => $values['AllStop'],':source' => $database_file); |
103 | 119 | $sth_dest->execute($query_dest_values); |
104 | 120 | } |
105 | - if ($globalTransaction) $Connection->db->commit(); |
|
121 | + if ($globalTransaction) { |
|
122 | + $Connection->db->commit(); |
|
123 | + } |
|
106 | 124 | } catch(PDOException $e) { |
107 | - if ($globalTransaction) $Connection->db->rollBack(); |
|
125 | + if ($globalTransaction) { |
|
126 | + $Connection->db->rollBack(); |
|
127 | + } |
|
108 | 128 | return "error : ".$e->getMessage(); |
109 | 129 | } |
110 | 130 | return ''; |
@@ -112,7 +132,9 @@ discard block |
||
112 | 132 | public static function retrieve_route_oneworld($database_file) { |
113 | 133 | global $globalDebug, $globalTransaction; |
114 | 134 | //$query = 'TRUNCATE TABLE routes'; |
115 | - if ($globalDebug) echo " - Delete previous routes from DB -"; |
|
135 | + if ($globalDebug) { |
|
136 | + echo " - Delete previous routes from DB -"; |
|
137 | + } |
|
116 | 138 | $query = "DELETE FROM routes WHERE Source = '' OR Source = :source"; |
117 | 139 | $Connection = new Connection(); |
118 | 140 | try { |
@@ -123,14 +145,18 @@ discard block |
||
123 | 145 | return "error : ".$e->getMessage(); |
124 | 146 | } |
125 | 147 | |
126 | - if ($globalDebug) echo " - Add routes to DB -"; |
|
148 | + if ($globalDebug) { |
|
149 | + echo " - Add routes to DB -"; |
|
150 | + } |
|
127 | 151 | require_once(dirname(__FILE__).'/../require/class.Spotter.php'); |
128 | 152 | $Spotter = new Spotter(); |
129 | 153 | if ($fh = fopen($database_file,"r")) { |
130 | 154 | $query_dest = 'INSERT INTO routes (CallSign,Operator_ICAO,FromAirport_ICAO,FromAirport_Time,ToAirport_ICAO,ToAirport_Time,RouteStop,Source) VALUES (:CallSign, :Operator_ICAO, :FromAirport_ICAO,:FromAirport_Time, :ToAirport_ICAO, :ToAirport_Time,:routestop, :source)'; |
131 | 155 | $Connection = new Connection(); |
132 | 156 | $sth_dest = $Connection->db->prepare($query_dest); |
133 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
157 | + if ($globalTransaction) { |
|
158 | + $Connection->db->beginTransaction(); |
|
159 | + } |
|
134 | 160 | while (!feof($fh)) { |
135 | 161 | $line = fgetcsv($fh,9999,','); |
136 | 162 | if ($line[0] != '') { |
@@ -139,13 +165,17 @@ discard block |
||
139 | 165 | $query_dest_values = array(':CallSign' => str_replace('*','',$line[7]),':Operator_ICAO' => '',':FromAirport_ICAO' => $Spotter->getAirportICAO($line[0]),':FromAirport_Time' => $line[5],':ToAirport_ICAO' => $Spotter->getAirportICAO($line[1]),':ToAirport_Time' => $line[6],':routestop' => '',':source' => 'oneworld'); |
140 | 166 | $sth_dest->execute($query_dest_values); |
141 | 167 | } catch(PDOException $e) { |
142 | - if ($globalTransaction) $Connection->db->rollBack(); |
|
168 | + if ($globalTransaction) { |
|
169 | + $Connection->db->rollBack(); |
|
170 | + } |
|
143 | 171 | return "error : ".$e->getMessage(); |
144 | 172 | } |
145 | 173 | } |
146 | 174 | } |
147 | 175 | } |
148 | - if ($globalTransaction) $Connection->db->commit(); |
|
176 | + if ($globalTransaction) { |
|
177 | + $Connection->db->commit(); |
|
178 | + } |
|
149 | 179 | } |
150 | 180 | return ''; |
151 | 181 | } |
@@ -153,7 +183,9 @@ discard block |
||
153 | 183 | public static function retrieve_route_skyteam($database_file) { |
154 | 184 | global $globalDebug, $globalTransaction; |
155 | 185 | //$query = 'TRUNCATE TABLE routes'; |
156 | - if ($globalDebug) echo " - Delete previous routes from DB -"; |
|
186 | + if ($globalDebug) { |
|
187 | + echo " - Delete previous routes from DB -"; |
|
188 | + } |
|
157 | 189 | $query = "DELETE FROM routes WHERE Source = '' OR Source = :source"; |
158 | 190 | $Connection = new Connection(); |
159 | 191 | try { |
@@ -164,7 +196,9 @@ discard block |
||
164 | 196 | return "error : ".$e->getMessage(); |
165 | 197 | } |
166 | 198 | |
167 | - if ($globalDebug) echo " - Add routes to DB -"; |
|
199 | + if ($globalDebug) { |
|
200 | + echo " - Add routes to DB -"; |
|
201 | + } |
|
168 | 202 | |
169 | 203 | require_once(dirname(__FILE__).'/../require/class.Spotter.php'); |
170 | 204 | $Spotter = new Spotter(); |
@@ -173,7 +207,9 @@ discard block |
||
173 | 207 | $Connection = new Connection(); |
174 | 208 | $sth_dest = $Connection->db->prepare($query_dest); |
175 | 209 | try { |
176 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
210 | + if ($globalTransaction) { |
|
211 | + $Connection->db->beginTransaction(); |
|
212 | + } |
|
177 | 213 | while (!feof($fh)) { |
178 | 214 | $line = fgetcsv($fh,9999,','); |
179 | 215 | if ($line[0] != '') { |
@@ -184,9 +220,13 @@ discard block |
||
184 | 220 | } |
185 | 221 | } |
186 | 222 | } |
187 | - if ($globalTransaction) $Connection->db->commit(); |
|
223 | + if ($globalTransaction) { |
|
224 | + $Connection->db->commit(); |
|
225 | + } |
|
188 | 226 | } catch(PDOException $e) { |
189 | - if ($globalTransaction) $Connection->db->rollBack(); |
|
227 | + if ($globalTransaction) { |
|
228 | + $Connection->db->rollBack(); |
|
229 | + } |
|
190 | 230 | return "error : ".$e->getMessage(); |
191 | 231 | } |
192 | 232 | } |
@@ -229,11 +269,16 @@ discard block |
||
229 | 269 | $sth_dest = $Connection->db->prepare($query_dest); |
230 | 270 | $sth_dest_owner = $Connection->db->prepare($query_dest_owner); |
231 | 271 | try { |
232 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
272 | + if ($globalTransaction) { |
|
273 | + $Connection->db->beginTransaction(); |
|
274 | + } |
|
233 | 275 | while ($values = $sth->fetch(PDO::FETCH_ASSOC)) { |
234 | 276 | //$query_dest_values = array(':AircraftID' => $values['AircraftID'],':FirstCreated' => $values['FirstCreated'],':LastModified' => $values['LastModified'],':ModeS' => $values['ModeS'],':ModeSCountry' => $values['ModeSCountry'],':Registration' => $values['Registration'],':ICAOTypeCode' => $values['ICAOTypeCode'],':SerialNo' => $values['SerialNo'], ':OperatorFlagCode' => $values['OperatorFlagCode'], ':Manufacturer' => $values['Manufacturer'], ':Type' => $values['Type'], ':FirstRegDate' => $values['FirstRegDate'], ':CurrentRegDate' => $values['CurrentRegDate'], ':Country' => $values['Country'], ':PreviousID' => $values['PreviousID'], ':DeRegDate' => $values['DeRegDate'], ':Status' => $values['Status'], ':PopularName' => $values['PopularName'],':GenericName' => $values['GenericName'],':AircraftClass' => $values['AircraftClass'], ':Engines' => $values['Engines'], ':OwnershipStatus' => $values['OwnershipStatus'],':RegisteredOwners' => $values['RegisteredOwners'],':MTOW' => $values['MTOW'], ':TotalHours' => $values['TotalHours'],':YearBuilt' => $values['YearBuilt'], ':CofACategory' => $values['CofACategory'], ':CofAExpiry' => $values['CofAExpiry'], ':UserNotes' => $values['UserNotes'], ':Interested' => $values['Interested'], ':UserTag' => $values['UserTag'], ':InfoUrl' => $values['InfoURL'], ':PictureUrl1' => $values['PictureURL1'], ':PictureUrl2' => $values['PictureURL2'], ':PictureUrl3' => $values['PictureURL3'], ':UserBool1' => $values['UserBool1'], ':UserBool2' => $values['UserBool2'], ':UserBool3' => $values['UserBool3'], ':UserBool4' => $values['UserBool4'], ':UserBool5' => $values['UserBool5'], ':UserString1' => $values['UserString1'], ':UserString2' => $values['UserString2'], ':UserString3' => $values['UserString3'], ':UserString4' => $values['UserString4'], ':UserString5' => $values['UserString5'], ':UserInt1' => $values['UserInt1'], ':UserInt2' => $values['UserInt2'], ':UserInt3' => $values['UserInt3'], ':UserInt4' => $values['UserInt4'], ':UserInt5' => $values['UserInt5']); |
235 | - if ($values['UserString4'] == 'M') $type = 'military'; |
|
236 | - else $type = null; |
|
277 | + if ($values['UserString4'] == 'M') { |
|
278 | + $type = 'military'; |
|
279 | + } else { |
|
280 | + $type = null; |
|
281 | + } |
|
237 | 282 | $query_dest_values = array(':LastModified' => $values['LastModified'],':ModeS' => $values['ModeS'],':ModeSCountry' => $values['ModeSCountry'],':Registration' => $values['Registration'],':ICAOTypeCode' => $values['ICAOTypeCode'],':source' => $database_file,':type' => $type); |
238 | 283 | $sth_dest->execute($query_dest_values); |
239 | 284 | if ($values['RegisteredOwners'] != '' && $values['RegisteredOwners'] != NULL && $values['RegisteredOwners'] != 'Private') { |
@@ -241,7 +286,9 @@ discard block |
||
241 | 286 | $sth_dest_owner->execute($query_dest_owner_values); |
242 | 287 | } |
243 | 288 | } |
244 | - if ($globalTransaction) $Connection->db->commit(); |
|
289 | + if ($globalTransaction) { |
|
290 | + $Connection->db->commit(); |
|
291 | + } |
|
245 | 292 | } catch(PDOException $e) { |
246 | 293 | return "error : ".$e->getMessage(); |
247 | 294 | } |
@@ -278,7 +325,9 @@ discard block |
||
278 | 325 | $Connection = new Connection(); |
279 | 326 | $sth_dest = $Connection->db->prepare($query_dest); |
280 | 327 | try { |
281 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
328 | + if ($globalTransaction) { |
|
329 | + $Connection->db->beginTransaction(); |
|
330 | + } |
|
282 | 331 | while (!feof($fh)) { |
283 | 332 | $values = array(); |
284 | 333 | $line = $Common->hex2str(fgets($fh,9999)); |
@@ -289,7 +338,9 @@ discard block |
||
289 | 338 | // Check if we can find ICAO, else set it to GLID |
290 | 339 | $aircraft_name_split = explode(' ',$aircraft_name); |
291 | 340 | $search_more = ''; |
292 | - if (count($aircraft_name) > 1 && strlen($aircraft_name_split[1]) > 3) $search_more .= " AND LIKE '%".$aircraft_name_split[0]."%'"; |
|
341 | + if (count($aircraft_name) > 1 && strlen($aircraft_name_split[1]) > 3) { |
|
342 | + $search_more .= " AND LIKE '%".$aircraft_name_split[0]."%'"; |
|
343 | + } |
|
293 | 344 | $query_search = "SELECT * FROM aircraft WHERE type LIKE '%".$aircraft_name."%'".$search_more; |
294 | 345 | $sth_search = $Connection->db->prepare($query_search); |
295 | 346 | try { |
@@ -302,7 +353,9 @@ discard block |
||
302 | 353 | } catch(PDOException $e) { |
303 | 354 | return "error : ".$e->getMessage(); |
304 | 355 | } |
305 | - if (!isset($values['ICAOTypeCode'])) $values['ICAOTypeCode'] = 'GLID'; |
|
356 | + if (!isset($values['ICAOTypeCode'])) { |
|
357 | + $values['ICAOTypeCode'] = 'GLID'; |
|
358 | + } |
|
306 | 359 | // Add data to db |
307 | 360 | if ($values['Registration'] != '' && $values['Registration'] != '0000') { |
308 | 361 | //$query_dest_values = array(':AircraftID' => $values['AircraftID'],':FirstCreated' => $values['FirstCreated'],':LastModified' => $values['LastModified'],':ModeS' => $values['ModeS'],':ModeSCountry' => $values['ModeSCountry'],':Registration' => $values['Registration'],':ICAOTypeCode' => $values['ICAOTypeCode'],':SerialNo' => $values['SerialNo'], ':OperatorFlagCode' => $values['OperatorFlagCode'], ':Manufacturer' => $values['Manufacturer'], ':Type' => $values['Type'], ':FirstRegDate' => $values['FirstRegDate'], ':CurrentRegDate' => $values['CurrentRegDate'], ':Country' => $values['Country'], ':PreviousID' => $values['PreviousID'], ':DeRegDate' => $values['DeRegDate'], ':Status' => $values['Status'], ':PopularName' => $values['PopularName'],':GenericName' => $values['GenericName'],':AircraftClass' => $values['AircraftClass'], ':Engines' => $values['Engines'], ':OwnershipStatus' => $values['OwnershipStatus'],':RegisteredOwners' => $values['RegisteredOwners'],':MTOW' => $values['MTOW'], ':TotalHours' => $values['TotalHours'],':YearBuilt' => $values['YearBuilt'], ':CofACategory' => $values['CofACategory'], ':CofAExpiry' => $values['CofAExpiry'], ':UserNotes' => $values['UserNotes'], ':Interested' => $values['Interested'], ':UserTag' => $values['UserTag'], ':InfoUrl' => $values['InfoURL'], ':PictureUrl1' => $values['PictureURL1'], ':PictureUrl2' => $values['PictureURL2'], ':PictureUrl3' => $values['PictureURL3'], ':UserBool1' => $values['UserBool1'], ':UserBool2' => $values['UserBool2'], ':UserBool3' => $values['UserBool3'], ':UserBool4' => $values['UserBool4'], ':UserBool5' => $values['UserBool5'], ':UserString1' => $values['UserString1'], ':UserString2' => $values['UserString2'], ':UserString3' => $values['UserString3'], ':UserString4' => $values['UserString4'], ':UserString5' => $values['UserString5'], ':UserInt1' => $values['UserInt1'], ':UserInt2' => $values['UserInt2'], ':UserInt3' => $values['UserInt3'], ':UserInt4' => $values['UserInt4'], ':UserInt5' => $values['UserInt5']); |
@@ -311,7 +364,9 @@ discard block |
||
311 | 364 | $sth_dest->execute($query_dest_values); |
312 | 365 | } |
313 | 366 | } |
314 | - if ($globalTransaction) $Connection->db->commit(); |
|
367 | + if ($globalTransaction) { |
|
368 | + $Connection->db->commit(); |
|
369 | + } |
|
315 | 370 | } catch(PDOException $e) { |
316 | 371 | return "error : ".$e->getMessage(); |
317 | 372 | } |
@@ -347,7 +402,9 @@ discard block |
||
347 | 402 | $Connection = new Connection(); |
348 | 403 | $sth_dest = $Connection->db->prepare($query_dest); |
349 | 404 | try { |
350 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
405 | + if ($globalTransaction) { |
|
406 | + $Connection->db->beginTransaction(); |
|
407 | + } |
|
351 | 408 | $tmp = fgetcsv($fh,9999,',',"'"); |
352 | 409 | while (!feof($fh)) { |
353 | 410 | $line = fgetcsv($fh,9999,',',"'"); |
@@ -361,13 +418,17 @@ discard block |
||
361 | 418 | // Check if we can find ICAO, else set it to GLID |
362 | 419 | $aircraft_name_split = explode(' ',$aircraft_name); |
363 | 420 | $search_more = ''; |
364 | - if (count($aircraft_name) > 1 && strlen($aircraft_name_split[1]) > 3) $search_more .= " AND LIKE '%".$aircraft_name_split[0]."%'"; |
|
421 | + if (count($aircraft_name) > 1 && strlen($aircraft_name_split[1]) > 3) { |
|
422 | + $search_more .= " AND LIKE '%".$aircraft_name_split[0]."%'"; |
|
423 | + } |
|
365 | 424 | $query_search = "SELECT * FROM aircraft WHERE type LIKE '%".$aircraft_name."%'".$search_more; |
366 | 425 | $sth_search = $Connection->db->prepare($query_search); |
367 | 426 | try { |
368 | 427 | $sth_search->execute(); |
369 | 428 | $result = $sth_search->fetch(PDO::FETCH_ASSOC); |
370 | - if (isset($result['icao']) && $result['icao'] != '') $values['ICAOTypeCode'] = $result['icao']; |
|
429 | + if (isset($result['icao']) && $result['icao'] != '') { |
|
430 | + $values['ICAOTypeCode'] = $result['icao']; |
|
431 | + } |
|
371 | 432 | } catch(PDOException $e) { |
372 | 433 | return "error : ".$e->getMessage(); |
373 | 434 | } |
@@ -380,7 +441,9 @@ discard block |
||
380 | 441 | $sth_dest->execute($query_dest_values); |
381 | 442 | } |
382 | 443 | } |
383 | - if ($globalTransaction) $Connection->db->commit(); |
|
444 | + if ($globalTransaction) { |
|
445 | + $Connection->db->commit(); |
|
446 | + } |
|
384 | 447 | } catch(PDOException $e) { |
385 | 448 | return "error : ".$e->getMessage(); |
386 | 449 | } |
@@ -419,7 +482,9 @@ discard block |
||
419 | 482 | $sth_dest = $Connection->db->prepare($query_dest); |
420 | 483 | $sth_modes = $Connection->db->prepare($query_modes); |
421 | 484 | try { |
422 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
485 | + if ($globalTransaction) { |
|
486 | + $Connection->db->beginTransaction(); |
|
487 | + } |
|
423 | 488 | $tmp = fgetcsv($fh,9999,',','"'); |
424 | 489 | while (!feof($fh)) { |
425 | 490 | $line = fgetcsv($fh,9999,',','"'); |
@@ -429,16 +494,22 @@ discard block |
||
429 | 494 | $values['registration'] = $line[0]; |
430 | 495 | $values['base'] = $line[4]; |
431 | 496 | $values['owner'] = $line[5]; |
432 | - if ($line[6] == '') $values['date_first_reg'] = null; |
|
433 | - else $values['date_first_reg'] = date("Y-m-d",strtotime($line[6])); |
|
497 | + if ($line[6] == '') { |
|
498 | + $values['date_first_reg'] = null; |
|
499 | + } else { |
|
500 | + $values['date_first_reg'] = date("Y-m-d",strtotime($line[6])); |
|
501 | + } |
|
434 | 502 | $values['cancel'] = $line[7]; |
435 | 503 | } elseif ($country == 'EI') { |
436 | 504 | // TODO : add modeS & reg to aircraft_modes |
437 | 505 | $values['registration'] = $line[0]; |
438 | 506 | $values['base'] = $line[3]; |
439 | 507 | $values['owner'] = $line[2]; |
440 | - if ($line[1] == '') $values['date_first_reg'] = null; |
|
441 | - else $values['date_first_reg'] = date("Y-m-d",strtotime($line[1])); |
|
508 | + if ($line[1] == '') { |
|
509 | + $values['date_first_reg'] = null; |
|
510 | + } else { |
|
511 | + $values['date_first_reg'] = date("Y-m-d",strtotime($line[1])); |
|
512 | + } |
|
442 | 513 | $values['cancel'] = ''; |
443 | 514 | $values['modes'] = $line[7]; |
444 | 515 | $values['icao'] = $line[8]; |
@@ -457,16 +528,22 @@ discard block |
||
457 | 528 | $values['registration'] = $line[3]; |
458 | 529 | $values['base'] = null; |
459 | 530 | $values['owner'] = $line[5]; |
460 | - if ($line[18] == '') $values['date_first_reg'] = null; |
|
461 | - else $values['date_first_reg'] = date("Y-m-d",strtotime($line[18])); |
|
531 | + if ($line[18] == '') { |
|
532 | + $values['date_first_reg'] = null; |
|
533 | + } else { |
|
534 | + $values['date_first_reg'] = date("Y-m-d",strtotime($line[18])); |
|
535 | + } |
|
462 | 536 | $values['cancel'] = ''; |
463 | 537 | } elseif ($country == 'VH') { |
464 | 538 | // TODO : add modeS & reg to aircraft_modes |
465 | 539 | $values['registration'] = $line[0]; |
466 | 540 | $values['base'] = null; |
467 | 541 | $values['owner'] = $line[12]; |
468 | - if ($line[28] == '') $values['date_first_reg'] = null; |
|
469 | - else $values['date_first_reg'] = date("Y-m-d",strtotime($line[28])); |
|
542 | + if ($line[28] == '') { |
|
543 | + $values['date_first_reg'] = null; |
|
544 | + } else { |
|
545 | + $values['date_first_reg'] = date("Y-m-d",strtotime($line[28])); |
|
546 | + } |
|
470 | 547 | |
471 | 548 | $values['cancel'] = $line[39]; |
472 | 549 | } elseif ($country == 'OE' || $country == '9A' || $country == 'VP' || $country == 'LX' || $country == 'P2' || $country == 'HC') { |
@@ -485,29 +562,41 @@ discard block |
||
485 | 562 | $values['registration'] = $line[0]; |
486 | 563 | $values['base'] = null; |
487 | 564 | $values['owner'] = $line[8]; |
488 | - if ($line[7] == '') $values['date_first_reg'] = null; |
|
489 | - else $values['date_first_reg'] = date("Y-m-d",strtotime($line[7])); |
|
565 | + if ($line[7] == '') { |
|
566 | + $values['date_first_reg'] = null; |
|
567 | + } else { |
|
568 | + $values['date_first_reg'] = date("Y-m-d",strtotime($line[7])); |
|
569 | + } |
|
490 | 570 | $values['cancel'] = ''; |
491 | 571 | } elseif ($country == 'PP') { |
492 | 572 | $values['registration'] = $line[0]; |
493 | 573 | $values['base'] = null; |
494 | 574 | $values['owner'] = $line[4]; |
495 | - if ($line[6] == '') $values['date_first_reg'] = null; |
|
496 | - else $values['date_first_reg'] = date("Y-m-d",strtotime($line[6])); |
|
575 | + if ($line[6] == '') { |
|
576 | + $values['date_first_reg'] = null; |
|
577 | + } else { |
|
578 | + $values['date_first_reg'] = date("Y-m-d",strtotime($line[6])); |
|
579 | + } |
|
497 | 580 | $values['cancel'] = $line[7]; |
498 | 581 | } elseif ($country == 'E7') { |
499 | 582 | $values['registration'] = $line[0]; |
500 | 583 | $values['base'] = null; |
501 | 584 | $values['owner'] = $line[4]; |
502 | - if ($line[5] == '') $values['date_first_reg'] = null; |
|
503 | - else $values['date_first_reg'] = date("Y-m-d",strtotime($line[5])); |
|
585 | + if ($line[5] == '') { |
|
586 | + $values['date_first_reg'] = null; |
|
587 | + } else { |
|
588 | + $values['date_first_reg'] = date("Y-m-d",strtotime($line[5])); |
|
589 | + } |
|
504 | 590 | $values['cancel'] = ''; |
505 | 591 | } elseif ($country == '8Q') { |
506 | 592 | $values['registration'] = $line[0]; |
507 | 593 | $values['base'] = null; |
508 | 594 | $values['owner'] = $line[3]; |
509 | - if ($line[7] == '') $values['date_first_reg'] = null; |
|
510 | - else $values['date_first_reg'] = date("Y-m-d",strtotime($line[7])); |
|
595 | + if ($line[7] == '') { |
|
596 | + $values['date_first_reg'] = null; |
|
597 | + } else { |
|
598 | + $values['date_first_reg'] = date("Y-m-d",strtotime($line[7])); |
|
599 | + } |
|
511 | 600 | $values['cancel'] = ''; |
512 | 601 | } elseif ($country == 'ZK') { |
513 | 602 | $values['registration'] = $line[0]; |
@@ -552,7 +641,9 @@ discard block |
||
552 | 641 | $sth_modes->execute($query_modes_values); |
553 | 642 | } |
554 | 643 | } |
555 | - if ($globalTransaction) $Connection->db->commit(); |
|
644 | + if ($globalTransaction) { |
|
645 | + $Connection->db->commit(); |
|
646 | + } |
|
556 | 647 | } catch(PDOException $e) { |
557 | 648 | return "error : ".$e->getMessage(); |
558 | 649 | } |
@@ -688,25 +779,45 @@ discard block |
||
688 | 779 | VALUES (:name, :city, :country, :iata, :icao, :latitude, :longitude, :altitude, :type, :home_link, :wikipedia_link, :image_thumb, :image)"; |
689 | 780 | $Connection = new Connection(); |
690 | 781 | $sth_dest = $Connection->db->prepare($query_dest); |
691 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
782 | + if ($globalTransaction) { |
|
783 | + $Connection->db->beginTransaction(); |
|
784 | + } |
|
692 | 785 | |
693 | 786 | $i = 0; |
694 | 787 | while($row = sparql_fetch_array($result)) |
695 | 788 | { |
696 | 789 | if ($i >= 1) { |
697 | 790 | //print_r($row); |
698 | - if (!isset($row['iata'])) $row['iata'] = ''; |
|
699 | - if (!isset($row['icao'])) $row['icao'] = ''; |
|
700 | - if (!isset($row['type'])) $row['type'] = ''; |
|
701 | - if (!isset($row['altitude'])) $row['altitude'] = ''; |
|
791 | + if (!isset($row['iata'])) { |
|
792 | + $row['iata'] = ''; |
|
793 | + } |
|
794 | + if (!isset($row['icao'])) { |
|
795 | + $row['icao'] = ''; |
|
796 | + } |
|
797 | + if (!isset($row['type'])) { |
|
798 | + $row['type'] = ''; |
|
799 | + } |
|
800 | + if (!isset($row['altitude'])) { |
|
801 | + $row['altitude'] = ''; |
|
802 | + } |
|
702 | 803 | if (isset($row['city_bis'])) { |
703 | 804 | $row['city'] = $row['city_bis']; |
704 | 805 | } |
705 | - if (!isset($row['city'])) $row['city'] = ''; |
|
706 | - if (!isset($row['country'])) $row['country'] = ''; |
|
707 | - if (!isset($row['homepage'])) $row['homepage'] = ''; |
|
708 | - if (!isset($row['wikipedia_page'])) $row['wikipedia_page'] = ''; |
|
709 | - if (!isset($row['name'])) continue; |
|
806 | + if (!isset($row['city'])) { |
|
807 | + $row['city'] = ''; |
|
808 | + } |
|
809 | + if (!isset($row['country'])) { |
|
810 | + $row['country'] = ''; |
|
811 | + } |
|
812 | + if (!isset($row['homepage'])) { |
|
813 | + $row['homepage'] = ''; |
|
814 | + } |
|
815 | + if (!isset($row['wikipedia_page'])) { |
|
816 | + $row['wikipedia_page'] = ''; |
|
817 | + } |
|
818 | + if (!isset($row['name'])) { |
|
819 | + continue; |
|
820 | + } |
|
710 | 821 | if (!isset($row['image'])) { |
711 | 822 | $row['image'] = ''; |
712 | 823 | $row['image_thumb'] = ''; |
@@ -762,7 +873,9 @@ discard block |
||
762 | 873 | |
763 | 874 | $i++; |
764 | 875 | } |
765 | - if ($globalTransaction) $Connection->db->commit(); |
|
876 | + if ($globalTransaction) { |
|
877 | + $Connection->db->commit(); |
|
878 | + } |
|
766 | 879 | /* |
767 | 880 | echo "Delete duplicate rows...\n"; |
768 | 881 | $query = 'ALTER IGNORE TABLE airport ADD UNIQUE INDEX icaoidx (icao)'; |
@@ -805,7 +918,9 @@ discard block |
||
805 | 918 | $delimiter = ','; |
806 | 919 | $out_file = $tmp_dir.'airports.csv'; |
807 | 920 | update_db::download('http://ourairports.com/data/airports.csv',$out_file); |
808 | - if (!file_exists($out_file) || !is_readable($out_file)) return FALSE; |
|
921 | + if (!file_exists($out_file) || !is_readable($out_file)) { |
|
922 | + return FALSE; |
|
923 | + } |
|
809 | 924 | echo "Add data from ourairports.com...\n"; |
810 | 925 | |
811 | 926 | $header = NULL; |
@@ -815,8 +930,9 @@ discard block |
||
815 | 930 | //$Connection->db->beginTransaction(); |
816 | 931 | while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) |
817 | 932 | { |
818 | - if(!$header) $header = $row; |
|
819 | - else { |
|
933 | + if(!$header) { |
|
934 | + $header = $row; |
|
935 | + } else { |
|
820 | 936 | $data = array(); |
821 | 937 | $data = array_combine($header, $row); |
822 | 938 | try { |
@@ -857,7 +973,9 @@ discard block |
||
857 | 973 | echo "Download data from another free database...\n"; |
858 | 974 | $out_file = $tmp_dir.'GlobalAirportDatabase.zip'; |
859 | 975 | update_db::download('http://www.partow.net/downloads/GlobalAirportDatabase.zip',$out_file); |
860 | - if (!file_exists($out_file) || !is_readable($out_file)) return FALSE; |
|
976 | + if (!file_exists($out_file) || !is_readable($out_file)) { |
|
977 | + return FALSE; |
|
978 | + } |
|
861 | 979 | update_db::unzip($out_file); |
862 | 980 | $header = NULL; |
863 | 981 | echo "Add data from another free database...\n"; |
@@ -868,8 +986,9 @@ discard block |
||
868 | 986 | //$Connection->db->beginTransaction(); |
869 | 987 | while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) |
870 | 988 | { |
871 | - if(!$header) $header = $row; |
|
872 | - else { |
|
989 | + if(!$header) { |
|
990 | + $header = $row; |
|
991 | + } else { |
|
873 | 992 | $data = $row; |
874 | 993 | |
875 | 994 | $query = 'UPDATE airport SET city = :city, country = :country WHERE icao = :icao'; |
@@ -1038,7 +1157,9 @@ discard block |
||
1038 | 1157 | if (($handle = fopen($tmp_dir.'MASTER.txt', 'r')) !== FALSE) |
1039 | 1158 | { |
1040 | 1159 | $i = 0; |
1041 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
1160 | + if ($globalTransaction) { |
|
1161 | + $Connection->db->beginTransaction(); |
|
1162 | + } |
|
1042 | 1163 | while (($data = fgetcsv($handle, 1000, $delimiter)) !== FALSE) |
1043 | 1164 | { |
1044 | 1165 | if ($i > 0) { |
@@ -1051,7 +1172,9 @@ discard block |
||
1051 | 1172 | } |
1052 | 1173 | $result_search = $sths->fetchAll(PDO::FETCH_ASSOC); |
1053 | 1174 | if (!empty($result_search)) { |
1054 | - if ($globalDebug) echo '.'; |
|
1175 | + if ($globalDebug) { |
|
1176 | + echo '.'; |
|
1177 | + } |
|
1055 | 1178 | //if ($globalDBdriver == 'mysql') { |
1056 | 1179 | // $queryi = 'INSERT INTO faamfr (mfr,icao) VALUES (:mfr,:icao) ON DUPLICATE KEY UPDATE icao = :icao'; |
1057 | 1180 | //} else { |
@@ -1073,8 +1196,12 @@ discard block |
||
1073 | 1196 | } |
1074 | 1197 | $result_search_mfr = $sthsm->fetchAll(PDO::FETCH_ASSOC); |
1075 | 1198 | if (!empty($result_search_mfr)) { |
1076 | - if (trim($data[16]) == '' && trim($data[23]) != '') $data[16] = $data[23]; |
|
1077 | - if (trim($data[16]) == '' && trim($data[15]) != '') $data[16] = $data[15]; |
|
1199 | + if (trim($data[16]) == '' && trim($data[23]) != '') { |
|
1200 | + $data[16] = $data[23]; |
|
1201 | + } |
|
1202 | + if (trim($data[16]) == '' && trim($data[15]) != '') { |
|
1203 | + $data[16] = $data[15]; |
|
1204 | + } |
|
1078 | 1205 | $queryf = 'INSERT INTO aircraft_modes (FirstCreated,LastModified,ModeS,ModeSCountry,Registration,ICAOTypeCode,Source) VALUES (:FirstCreated,:LastModified,:ModeS,:ModeSCountry,:Registration,:ICAOTypeCode,:source)'; |
1079 | 1206 | try { |
1080 | 1207 | $sthf = $Connection->db->prepare($queryf); |
@@ -1085,7 +1212,9 @@ discard block |
||
1085 | 1212 | } |
1086 | 1213 | } |
1087 | 1214 | if (strtotime($data[29]) > time()) { |
1088 | - if ($globalDebug) echo 'i'; |
|
1215 | + if ($globalDebug) { |
|
1216 | + echo 'i'; |
|
1217 | + } |
|
1089 | 1218 | $query = 'INSERT INTO aircraft_owner (registration,base,owner,date_first_reg,Source) VALUES (:registration,:base,:owner,:date_first_reg,:source)'; |
1090 | 1219 | try { |
1091 | 1220 | $sth = $Connection->db->prepare($query); |
@@ -1096,13 +1225,19 @@ discard block |
||
1096 | 1225 | } |
1097 | 1226 | } |
1098 | 1227 | if ($i % 90 == 0) { |
1099 | - if ($globalTransaction) $Connection->db->commit(); |
|
1100 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
1228 | + if ($globalTransaction) { |
|
1229 | + $Connection->db->commit(); |
|
1230 | + } |
|
1231 | + if ($globalTransaction) { |
|
1232 | + $Connection->db->beginTransaction(); |
|
1233 | + } |
|
1101 | 1234 | } |
1102 | 1235 | $i++; |
1103 | 1236 | } |
1104 | 1237 | fclose($handle); |
1105 | - if ($globalTransaction) $Connection->db->commit(); |
|
1238 | + if ($globalTransaction) { |
|
1239 | + $Connection->db->commit(); |
|
1240 | + } |
|
1106 | 1241 | } |
1107 | 1242 | //print_r($mfr); |
1108 | 1243 | return ''; |
@@ -1127,11 +1262,15 @@ discard block |
||
1127 | 1262 | $i = 0; |
1128 | 1263 | //$Connection->db->setAttribute(PDO::ATTR_AUTOCOMMIT, FALSE); |
1129 | 1264 | //$Connection->db->beginTransaction(); |
1130 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
1265 | + if ($globalTransaction) { |
|
1266 | + $Connection->db->beginTransaction(); |
|
1267 | + } |
|
1131 | 1268 | while (($data = fgetcsv($handle, 1000, $delimiter)) !== FALSE) |
1132 | 1269 | { |
1133 | 1270 | if ($i > 0) { |
1134 | - if ($data[1] == 'NULL') $data[1] = $data[0]; |
|
1271 | + if ($data[1] == 'NULL') { |
|
1272 | + $data[1] = $data[0]; |
|
1273 | + } |
|
1135 | 1274 | $query = 'INSERT INTO aircraft_modes (FirstCreated,LastModified,ModeS,ModeSCountry,Registration,ICAOTypeCode,type_flight,Source) VALUES (:FirstCreated,:LastModified,:ModeS,:ModeSCountry,:Registration,:ICAOTypeCode,:type_flight,:source)'; |
1136 | 1275 | try { |
1137 | 1276 | $sth = $Connection->db->prepare($query); |
@@ -1143,7 +1282,9 @@ discard block |
||
1143 | 1282 | $i++; |
1144 | 1283 | } |
1145 | 1284 | fclose($handle); |
1146 | - if ($globalTransaction) $Connection->db->commit(); |
|
1285 | + if ($globalTransaction) { |
|
1286 | + $Connection->db->commit(); |
|
1287 | + } |
|
1147 | 1288 | } |
1148 | 1289 | return ''; |
1149 | 1290 | } |
@@ -1164,7 +1305,9 @@ discard block |
||
1164 | 1305 | if (($handle = fopen($tmp_dir.'owners.tsv', 'r')) !== FALSE) |
1165 | 1306 | { |
1166 | 1307 | $i = 0; |
1167 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
1308 | + if ($globalTransaction) { |
|
1309 | + $Connection->db->beginTransaction(); |
|
1310 | + } |
|
1168 | 1311 | while (($data = fgetcsv($handle, 1000, $delimiter)) !== FALSE) |
1169 | 1312 | { |
1170 | 1313 | if ($i > 0) { |
@@ -1180,7 +1323,9 @@ discard block |
||
1180 | 1323 | $i++; |
1181 | 1324 | } |
1182 | 1325 | fclose($handle); |
1183 | - if ($globalTransaction) $Connection->db->commit(); |
|
1326 | + if ($globalTransaction) { |
|
1327 | + $Connection->db->commit(); |
|
1328 | + } |
|
1184 | 1329 | } |
1185 | 1330 | return ''; |
1186 | 1331 | } |
@@ -1200,7 +1345,9 @@ discard block |
||
1200 | 1345 | if (($handle = fopen($tmp_dir.'routes.tsv', 'r')) !== FALSE) |
1201 | 1346 | { |
1202 | 1347 | $i = 0; |
1203 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
1348 | + if ($globalTransaction) { |
|
1349 | + $Connection->db->beginTransaction(); |
|
1350 | + } |
|
1204 | 1351 | while (($data = fgetcsv($handle, 1000, $delimiter)) !== FALSE) |
1205 | 1352 | { |
1206 | 1353 | if ($i > 0) { |
@@ -1209,13 +1356,17 @@ discard block |
||
1209 | 1356 | $sth = $Connection->db->prepare($query); |
1210 | 1357 | $sth->execute(array(':CallSign' => $data[0],':Operator_ICAO' => $data[1],':FromAirport_ICAO' => $data[2],':FromAirport_Time' => $data[3], ':ToAirport_ICAO' => $data[4],':ToAirport_Time' => $data[5],':RouteStop' => $data[6],':source' => 'website_fam')); |
1211 | 1358 | } catch(PDOException $e) { |
1212 | - if ($globalDebug) echo "error: ".$e->getMessage()." - data: ".implode(',',$data); |
|
1359 | + if ($globalDebug) { |
|
1360 | + echo "error: ".$e->getMessage()." - data: ".implode(',',$data); |
|
1361 | + } |
|
1213 | 1362 | } |
1214 | 1363 | } |
1215 | 1364 | $i++; |
1216 | 1365 | } |
1217 | 1366 | fclose($handle); |
1218 | - if ($globalTransaction) $Connection->db->commit(); |
|
1367 | + if ($globalTransaction) { |
|
1368 | + $Connection->db->commit(); |
|
1369 | + } |
|
1219 | 1370 | } |
1220 | 1371 | return ''; |
1221 | 1372 | } |
@@ -1240,7 +1391,9 @@ discard block |
||
1240 | 1391 | $i = 0; |
1241 | 1392 | //$Connection->db->setAttribute(PDO::ATTR_AUTOCOMMIT, FALSE); |
1242 | 1393 | //$Connection->db->beginTransaction(); |
1243 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
1394 | + if ($globalTransaction) { |
|
1395 | + $Connection->db->beginTransaction(); |
|
1396 | + } |
|
1244 | 1397 | while (($data = fgetcsv($handle, 1000, $delimiter)) !== FALSE) |
1245 | 1398 | { |
1246 | 1399 | if ($i > 0) { |
@@ -1256,7 +1409,9 @@ discard block |
||
1256 | 1409 | $i++; |
1257 | 1410 | } |
1258 | 1411 | fclose($handle); |
1259 | - if ($globalTransaction) $Connection->db->commit(); |
|
1412 | + if ($globalTransaction) { |
|
1413 | + $Connection->db->commit(); |
|
1414 | + } |
|
1260 | 1415 | } |
1261 | 1416 | return ''; |
1262 | 1417 | } |
@@ -1275,7 +1430,9 @@ discard block |
||
1275 | 1430 | $Connection = new Connection(); |
1276 | 1431 | if (($handle = fopen($tmp_dir.'ban_eu.csv', 'r')) !== FALSE) |
1277 | 1432 | { |
1278 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
1433 | + if ($globalTransaction) { |
|
1434 | + $Connection->db->beginTransaction(); |
|
1435 | + } |
|
1279 | 1436 | while (($data = fgetcsv($handle, 1000)) !== FALSE) |
1280 | 1437 | { |
1281 | 1438 | $query = 'UPDATE airlines SET ban_eu = 1 WHERE icao = :icao AND forsource IS NULL'; |
@@ -1290,7 +1447,9 @@ discard block |
||
1290 | 1447 | } |
1291 | 1448 | } |
1292 | 1449 | fclose($handle); |
1293 | - if ($globalTransaction) $Connection->db->commit(); |
|
1450 | + if ($globalTransaction) { |
|
1451 | + $Connection->db->commit(); |
|
1452 | + } |
|
1294 | 1453 | } |
1295 | 1454 | return ''; |
1296 | 1455 | } |
@@ -1444,7 +1603,9 @@ discard block |
||
1444 | 1603 | if (($handle = fopen($filename, 'r')) !== FALSE) |
1445 | 1604 | { |
1446 | 1605 | $i = 0; |
1447 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
1606 | + if ($globalTransaction) { |
|
1607 | + $Connection->db->beginTransaction(); |
|
1608 | + } |
|
1448 | 1609 | while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) |
1449 | 1610 | { |
1450 | 1611 | $i++; |
@@ -1472,7 +1633,9 @@ discard block |
||
1472 | 1633 | } |
1473 | 1634 | } |
1474 | 1635 | fclose($handle); |
1475 | - if ($globalTransaction) $Connection->db->commit(); |
|
1636 | + if ($globalTransaction) { |
|
1637 | + $Connection->db->commit(); |
|
1638 | + } |
|
1476 | 1639 | } |
1477 | 1640 | return ''; |
1478 | 1641 | } |
@@ -1495,7 +1658,9 @@ discard block |
||
1495 | 1658 | $Connection = new Connection(); |
1496 | 1659 | if (($handle = fopen($filename, 'r')) !== FALSE) |
1497 | 1660 | { |
1498 | - if ($globalTransaction) $Connection->db->beginTransaction(); |
|
1661 | + if ($globalTransaction) { |
|
1662 | + $Connection->db->beginTransaction(); |
|
1663 | + } |
|
1499 | 1664 | while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) |
1500 | 1665 | { |
1501 | 1666 | if(count($row) > 1) { |
@@ -1509,7 +1674,9 @@ discard block |
||
1509 | 1674 | } |
1510 | 1675 | } |
1511 | 1676 | fclose($handle); |
1512 | - if ($globalTransaction) $Connection->db->commit(); |
|
1677 | + if ($globalTransaction) { |
|
1678 | + $Connection->db->commit(); |
|
1679 | + } |
|
1513 | 1680 | } |
1514 | 1681 | return ''; |
1515 | 1682 | } |
@@ -1529,8 +1696,9 @@ discard block |
||
1529 | 1696 | } |
1530 | 1697 | |
1531 | 1698 | |
1532 | - if ($globalDBdriver == 'mysql') update_db::gunzip('../db/airspace.sql.gz',$tmp_dir.'airspace.sql'); |
|
1533 | - else { |
|
1699 | + if ($globalDBdriver == 'mysql') { |
|
1700 | + update_db::gunzip('../db/airspace.sql.gz',$tmp_dir.'airspace.sql'); |
|
1701 | + } else { |
|
1534 | 1702 | update_db::gunzip('../db/pgsql/airspace.sql.gz',$tmp_dir.'airspace.sql'); |
1535 | 1703 | $query = "CREATE EXTENSION postgis"; |
1536 | 1704 | $Connection = new Connection(null,null,$_SESSION['database_root'],$_SESSION['database_rootpass']); |
@@ -1549,20 +1717,30 @@ discard block |
||
1549 | 1717 | global $tmp_dir, $globalDebug; |
1550 | 1718 | include_once('class.create_db.php'); |
1551 | 1719 | require_once(dirname(__FILE__).'/../require/class.NOTAM.php'); |
1552 | - if ($globalDebug) echo "NOTAM from FlightAirMap website : Download..."; |
|
1720 | + if ($globalDebug) { |
|
1721 | + echo "NOTAM from FlightAirMap website : Download..."; |
|
1722 | + } |
|
1553 | 1723 | update_db::download('http://data.flightairmap.fr/data/notam.txt.gz',$tmp_dir.'notam.txt.gz'); |
1554 | 1724 | $error = ''; |
1555 | 1725 | if (file_exists($tmp_dir.'notam.txt.gz')) { |
1556 | - if ($globalDebug) echo "Gunzip..."; |
|
1726 | + if ($globalDebug) { |
|
1727 | + echo "Gunzip..."; |
|
1728 | + } |
|
1557 | 1729 | update_db::gunzip($tmp_dir.'notam.txt.gz'); |
1558 | - if ($globalDebug) echo "Add to DB..."; |
|
1730 | + if ($globalDebug) { |
|
1731 | + echo "Add to DB..."; |
|
1732 | + } |
|
1559 | 1733 | //$error = create_db::import_file($tmp_dir.'notam.sql'); |
1560 | 1734 | $NOTAM = new NOTAM(); |
1561 | 1735 | $NOTAM->updateNOTAMfromTextFile($tmp_dir.'notam.txt'); |
1562 | - } else $error = "File ".$tmp_dir.'notam.txt.gz'." doesn't exist. Download failed."; |
|
1736 | + } else { |
|
1737 | + $error = "File ".$tmp_dir.'notam.txt.gz'." doesn't exist. Download failed."; |
|
1738 | + } |
|
1563 | 1739 | if ($error != '') { |
1564 | 1740 | return $error; |
1565 | - } elseif ($globalDebug) echo "Done\n"; |
|
1741 | + } elseif ($globalDebug) { |
|
1742 | + echo "Done\n"; |
|
1743 | + } |
|
1566 | 1744 | return ''; |
1567 | 1745 | } |
1568 | 1746 | |
@@ -1616,67 +1794,111 @@ discard block |
||
1616 | 1794 | //if ($globalDebug) echo "IVAO : Download..."; |
1617 | 1795 | //update_db::download('http://fr.mirror.ivao.aero/software/ivae_feb2013.zip',$tmp_dir.'ivae_feb2013.zip'); |
1618 | 1796 | if (file_exists($tmp_dir.'ivae_feb2013.zip')) { |
1619 | - if ($globalDebug) echo "Unzip..."; |
|
1797 | + if ($globalDebug) { |
|
1798 | + echo "Unzip..."; |
|
1799 | + } |
|
1620 | 1800 | update_db::unzip($tmp_dir.'ivae_feb2013.zip'); |
1621 | - if ($globalDebug) echo "Add to DB..."; |
|
1801 | + if ($globalDebug) { |
|
1802 | + echo "Add to DB..."; |
|
1803 | + } |
|
1622 | 1804 | update_db::ivao_airlines($tmp_dir.'data/airlines.dat'); |
1623 | - if ($globalDebug) echo "Copy airlines logos to airlines images directory..."; |
|
1805 | + if ($globalDebug) { |
|
1806 | + echo "Copy airlines logos to airlines images directory..."; |
|
1807 | + } |
|
1624 | 1808 | if (is_writable(dirname(__FILE__).'/../images/airlines')) { |
1625 | - if (!$Common->xcopy($tmp_dir.'logos/',dirname(__FILE__).'/../images/airlines/')) $error = "Failed to copy airlines logo."; |
|
1626 | - } else $error = "The directory ".dirname(__FILE__).'/../images/airlines'." must be writable"; |
|
1627 | - } else $error = "File ".$tmp_dir.'ivao.zip'." doesn't exist. Download failed."; |
|
1809 | + if (!$Common->xcopy($tmp_dir.'logos/',dirname(__FILE__).'/../images/airlines/')) { |
|
1810 | + $error = "Failed to copy airlines logo."; |
|
1811 | + } |
|
1812 | + } else { |
|
1813 | + $error = "The directory ".dirname(__FILE__).'/../images/airlines'." must be writable"; |
|
1814 | + } |
|
1815 | + } else { |
|
1816 | + $error = "File ".$tmp_dir.'ivao.zip'." doesn't exist. Download failed."; |
|
1817 | + } |
|
1628 | 1818 | if ($error != '') { |
1629 | 1819 | return $error; |
1630 | - } elseif ($globalDebug) echo "Done\n"; |
|
1820 | + } elseif ($globalDebug) { |
|
1821 | + echo "Done\n"; |
|
1822 | + } |
|
1631 | 1823 | return ''; |
1632 | 1824 | } |
1633 | 1825 | |
1634 | 1826 | public static function update_routes() { |
1635 | 1827 | global $tmp_dir, $globalDebug; |
1636 | 1828 | $error = ''; |
1637 | - if ($globalDebug) echo "Routes : Download..."; |
|
1829 | + if ($globalDebug) { |
|
1830 | + echo "Routes : Download..."; |
|
1831 | + } |
|
1638 | 1832 | update_db::download('http://www.virtualradarserver.co.uk/Files/StandingData.sqb.gz',$tmp_dir.'StandingData.sqb.gz'); |
1639 | 1833 | if (file_exists($tmp_dir.'StandingData.sqb.gz')) { |
1640 | - if ($globalDebug) echo "Gunzip..."; |
|
1834 | + if ($globalDebug) { |
|
1835 | + echo "Gunzip..."; |
|
1836 | + } |
|
1641 | 1837 | update_db::gunzip($tmp_dir.'StandingData.sqb.gz'); |
1642 | - if ($globalDebug) echo "Add to DB..."; |
|
1838 | + if ($globalDebug) { |
|
1839 | + echo "Add to DB..."; |
|
1840 | + } |
|
1643 | 1841 | $error = update_db::retrieve_route_sqlite_to_dest($tmp_dir.'StandingData.sqb'); |
1644 | - } else $error = "File ".$tmp_dir.'StandingData.sqb.gz'." doesn't exist. Download failed."; |
|
1842 | + } else { |
|
1843 | + $error = "File ".$tmp_dir.'StandingData.sqb.gz'." doesn't exist. Download failed."; |
|
1844 | + } |
|
1645 | 1845 | if ($error != '') { |
1646 | 1846 | return $error; |
1647 | - } elseif ($globalDebug) echo "Done\n"; |
|
1847 | + } elseif ($globalDebug) { |
|
1848 | + echo "Done\n"; |
|
1849 | + } |
|
1648 | 1850 | return ''; |
1649 | 1851 | } |
1650 | 1852 | public static function update_oneworld() { |
1651 | 1853 | global $tmp_dir, $globalDebug; |
1652 | 1854 | $error = ''; |
1653 | - if ($globalDebug) echo "Schedules Oneworld : Download..."; |
|
1855 | + if ($globalDebug) { |
|
1856 | + echo "Schedules Oneworld : Download..."; |
|
1857 | + } |
|
1654 | 1858 | update_db::download('http://data.flightairmap.fr/data/schedules/oneworld.csv.gz',$tmp_dir.'oneworld.csv.gz'); |
1655 | 1859 | if (file_exists($tmp_dir.'oneworld.csv.gz')) { |
1656 | - if ($globalDebug) echo "Gunzip..."; |
|
1860 | + if ($globalDebug) { |
|
1861 | + echo "Gunzip..."; |
|
1862 | + } |
|
1657 | 1863 | update_db::gunzip($tmp_dir.'oneworld.csv.gz'); |
1658 | - if ($globalDebug) echo "Add to DB..."; |
|
1864 | + if ($globalDebug) { |
|
1865 | + echo "Add to DB..."; |
|
1866 | + } |
|
1659 | 1867 | $error = update_db::retrieve_route_oneworld($tmp_dir.'oneworld.csv'); |
1660 | - } else $error = "File ".$tmp_dir.'oneworld.csv.gz'." doesn't exist. Download failed."; |
|
1868 | + } else { |
|
1869 | + $error = "File ".$tmp_dir.'oneworld.csv.gz'." doesn't exist. Download failed."; |
|
1870 | + } |
|
1661 | 1871 | if ($error != '') { |
1662 | 1872 | return $error; |
1663 | - } elseif ($globalDebug) echo "Done\n"; |
|
1873 | + } elseif ($globalDebug) { |
|
1874 | + echo "Done\n"; |
|
1875 | + } |
|
1664 | 1876 | return ''; |
1665 | 1877 | } |
1666 | 1878 | public static function update_skyteam() { |
1667 | 1879 | global $tmp_dir, $globalDebug; |
1668 | 1880 | $error = ''; |
1669 | - if ($globalDebug) echo "Schedules Skyteam : Download..."; |
|
1881 | + if ($globalDebug) { |
|
1882 | + echo "Schedules Skyteam : Download..."; |
|
1883 | + } |
|
1670 | 1884 | update_db::download('http://data.flightairmap.fr/data/schedules/skyteam.csv.gz',$tmp_dir.'skyteam.csv.gz'); |
1671 | 1885 | if (file_exists($tmp_dir.'skyteam.csv.gz')) { |
1672 | - if ($globalDebug) echo "Gunzip..."; |
|
1886 | + if ($globalDebug) { |
|
1887 | + echo "Gunzip..."; |
|
1888 | + } |
|
1673 | 1889 | update_db::gunzip($tmp_dir.'skyteam.csv.gz'); |
1674 | - if ($globalDebug) echo "Add to DB..."; |
|
1890 | + if ($globalDebug) { |
|
1891 | + echo "Add to DB..."; |
|
1892 | + } |
|
1675 | 1893 | $error = update_db::retrieve_route_skyteam($tmp_dir.'skyteam.csv'); |
1676 | - } else $error = "File ".$tmp_dir.'skyteam.csv.gz'." doesn't exist. Download failed."; |
|
1894 | + } else { |
|
1895 | + $error = "File ".$tmp_dir.'skyteam.csv.gz'." doesn't exist. Download failed."; |
|
1896 | + } |
|
1677 | 1897 | if ($error != '') { |
1678 | 1898 | return $error; |
1679 | - } elseif ($globalDebug) echo "Done\n"; |
|
1899 | + } elseif ($globalDebug) { |
|
1900 | + echo "Done\n"; |
|
1901 | + } |
|
1680 | 1902 | return ''; |
1681 | 1903 | } |
1682 | 1904 | public static function update_ModeS() { |
@@ -1693,355 +1915,619 @@ discard block |
||
1693 | 1915 | exit; |
1694 | 1916 | } elseif ($globalDebug) echo "Done\n"; |
1695 | 1917 | */ |
1696 | - if ($globalDebug) echo "Modes : Download..."; |
|
1697 | -// update_db::download('http://planebase.biz/sqb.php?f=basestationall.zip',$tmp_dir.'basestation_latest.zip','http://planebase.biz/bstnsqb'); |
|
1918 | + if ($globalDebug) { |
|
1919 | + echo "Modes : Download..."; |
|
1920 | + } |
|
1921 | + // update_db::download('http://planebase.biz/sqb.php?f=basestationall.zip',$tmp_dir.'basestation_latest.zip','http://planebase.biz/bstnsqb'); |
|
1698 | 1922 | update_db::download('http://data.flightairmap.fr/data/BaseStation.sqb.gz',$tmp_dir.'BaseStation.sqb.gz'); |
1699 | 1923 | |
1700 | 1924 | // if (file_exists($tmp_dir.'basestation_latest.zip')) { |
1701 | 1925 | if (file_exists($tmp_dir.'BaseStation.sqb.gz')) { |
1702 | - if ($globalDebug) echo "Unzip..."; |
|
1703 | -// update_db::unzip($tmp_dir.'basestation_latest.zip'); |
|
1926 | + if ($globalDebug) { |
|
1927 | + echo "Unzip..."; |
|
1928 | + } |
|
1929 | + // update_db::unzip($tmp_dir.'basestation_latest.zip'); |
|
1704 | 1930 | update_db::gunzip($tmp_dir.'BaseStation.sqb.gz'); |
1705 | - if ($globalDebug) echo "Add to DB..."; |
|
1931 | + if ($globalDebug) { |
|
1932 | + echo "Add to DB..."; |
|
1933 | + } |
|
1706 | 1934 | $error = update_db::retrieve_modes_sqlite_to_dest($tmp_dir.'BaseStation.sqb'); |
1707 | 1935 | // $error = update_db::retrieve_modes_sqlite_to_dest($tmp_dir.'basestation.sqb'); |
1708 | - } else $error = "File ".$tmp_dir.'basestation_latest.zip'." doesn't exist. Download failed."; |
|
1936 | + } else { |
|
1937 | + $error = "File ".$tmp_dir.'basestation_latest.zip'." doesn't exist. Download failed."; |
|
1938 | + } |
|
1709 | 1939 | if ($error != '') { |
1710 | 1940 | return $error; |
1711 | - } elseif ($globalDebug) echo "Done\n"; |
|
1941 | + } elseif ($globalDebug) { |
|
1942 | + echo "Done\n"; |
|
1943 | + } |
|
1712 | 1944 | return ''; |
1713 | 1945 | } |
1714 | 1946 | |
1715 | 1947 | public static function update_ModeS_faa() { |
1716 | 1948 | global $tmp_dir, $globalDebug; |
1717 | - if ($globalDebug) echo "Modes FAA: Download..."; |
|
1949 | + if ($globalDebug) { |
|
1950 | + echo "Modes FAA: Download..."; |
|
1951 | + } |
|
1718 | 1952 | update_db::download('http://registry.faa.gov/database/ReleasableAircraft.zip',$tmp_dir.'ReleasableAircraft.zip'); |
1719 | 1953 | if (file_exists($tmp_dir.'ReleasableAircraft.zip')) { |
1720 | - if ($globalDebug) echo "Unzip..."; |
|
1954 | + if ($globalDebug) { |
|
1955 | + echo "Unzip..."; |
|
1956 | + } |
|
1721 | 1957 | update_db::unzip($tmp_dir.'ReleasableAircraft.zip'); |
1722 | - if ($globalDebug) echo "Add to DB..."; |
|
1958 | + if ($globalDebug) { |
|
1959 | + echo "Add to DB..."; |
|
1960 | + } |
|
1723 | 1961 | $error = update_db::modes_faa(); |
1724 | - } else $error = "File ".$tmp_dir.'ReleasableAircraft.zip'." doesn't exist. Download failed."; |
|
1962 | + } else { |
|
1963 | + $error = "File ".$tmp_dir.'ReleasableAircraft.zip'." doesn't exist. Download failed."; |
|
1964 | + } |
|
1725 | 1965 | if ($error != '') { |
1726 | 1966 | return $error; |
1727 | - } elseif ($globalDebug) echo "Done\n"; |
|
1967 | + } elseif ($globalDebug) { |
|
1968 | + echo "Done\n"; |
|
1969 | + } |
|
1728 | 1970 | return ''; |
1729 | 1971 | } |
1730 | 1972 | |
1731 | 1973 | public static function update_ModeS_flarm() { |
1732 | 1974 | global $tmp_dir, $globalDebug; |
1733 | - if ($globalDebug) echo "Modes Flarmnet: Download..."; |
|
1975 | + if ($globalDebug) { |
|
1976 | + echo "Modes Flarmnet: Download..."; |
|
1977 | + } |
|
1734 | 1978 | update_db::download('http://flarmnet.org/files/data.fln',$tmp_dir.'data.fln'); |
1735 | 1979 | if (file_exists($tmp_dir.'data.fln')) { |
1736 | - if ($globalDebug) echo "Add to DB..."; |
|
1980 | + if ($globalDebug) { |
|
1981 | + echo "Add to DB..."; |
|
1982 | + } |
|
1737 | 1983 | $error = update_db::retrieve_modes_flarmnet($tmp_dir.'data.fln'); |
1738 | - } else $error = "File ".$tmp_dir.'data.fln'." doesn't exist. Download failed."; |
|
1984 | + } else { |
|
1985 | + $error = "File ".$tmp_dir.'data.fln'." doesn't exist. Download failed."; |
|
1986 | + } |
|
1739 | 1987 | if ($error != '') { |
1740 | 1988 | return $error; |
1741 | - } elseif ($globalDebug) echo "Done\n"; |
|
1989 | + } elseif ($globalDebug) { |
|
1990 | + echo "Done\n"; |
|
1991 | + } |
|
1742 | 1992 | return ''; |
1743 | 1993 | } |
1744 | 1994 | |
1745 | 1995 | public static function update_ModeS_ogn() { |
1746 | 1996 | global $tmp_dir, $globalDebug; |
1747 | - if ($globalDebug) echo "Modes OGN: Download..."; |
|
1997 | + if ($globalDebug) { |
|
1998 | + echo "Modes OGN: Download..."; |
|
1999 | + } |
|
1748 | 2000 | update_db::download('http://ddb.glidernet.org/download/',$tmp_dir.'ogn.csv'); |
1749 | 2001 | if (file_exists($tmp_dir.'ogn.csv')) { |
1750 | - if ($globalDebug) echo "Add to DB..."; |
|
2002 | + if ($globalDebug) { |
|
2003 | + echo "Add to DB..."; |
|
2004 | + } |
|
1751 | 2005 | $error = update_db::retrieve_modes_ogn($tmp_dir.'ogn.csv'); |
1752 | - } else $error = "File ".$tmp_dir.'ogn.csv'." doesn't exist. Download failed."; |
|
2006 | + } else { |
|
2007 | + $error = "File ".$tmp_dir.'ogn.csv'." doesn't exist. Download failed."; |
|
2008 | + } |
|
1753 | 2009 | if ($error != '') { |
1754 | 2010 | return $error; |
1755 | - } elseif ($globalDebug) echo "Done\n"; |
|
2011 | + } elseif ($globalDebug) { |
|
2012 | + echo "Done\n"; |
|
2013 | + } |
|
1756 | 2014 | return ''; |
1757 | 2015 | } |
1758 | 2016 | |
1759 | 2017 | public static function update_owner() { |
1760 | 2018 | global $tmp_dir, $globalDebug, $globalMasterSource; |
1761 | 2019 | |
1762 | - if ($globalDebug) echo "Owner France: Download..."; |
|
2020 | + if ($globalDebug) { |
|
2021 | + echo "Owner France: Download..."; |
|
2022 | + } |
|
1763 | 2023 | update_db::download('http://antonakis.co.uk/registers/France.txt',$tmp_dir.'owner_f.csv'); |
1764 | 2024 | if (file_exists($tmp_dir.'owner_f.csv')) { |
1765 | - if ($globalDebug) echo "Add to DB..."; |
|
2025 | + if ($globalDebug) { |
|
2026 | + echo "Add to DB..."; |
|
2027 | + } |
|
1766 | 2028 | $error = update_db::retrieve_owner($tmp_dir.'owner_f.csv','F'); |
1767 | - } else $error = "File ".$tmp_dir.'owner_f.csv'." doesn't exist. Download failed."; |
|
2029 | + } else { |
|
2030 | + $error = "File ".$tmp_dir.'owner_f.csv'." doesn't exist. Download failed."; |
|
2031 | + } |
|
1768 | 2032 | if ($error != '') { |
1769 | 2033 | return $error; |
1770 | - } elseif ($globalDebug) echo "Done\n"; |
|
2034 | + } elseif ($globalDebug) { |
|
2035 | + echo "Done\n"; |
|
2036 | + } |
|
1771 | 2037 | |
1772 | - if ($globalDebug) echo "Owner Ireland: Download..."; |
|
2038 | + if ($globalDebug) { |
|
2039 | + echo "Owner Ireland: Download..."; |
|
2040 | + } |
|
1773 | 2041 | update_db::download('http://antonakis.co.uk/registers/Ireland.txt',$tmp_dir.'owner_ei.csv'); |
1774 | 2042 | if (file_exists($tmp_dir.'owner_ei.csv')) { |
1775 | - if ($globalDebug) echo "Add to DB..."; |
|
2043 | + if ($globalDebug) { |
|
2044 | + echo "Add to DB..."; |
|
2045 | + } |
|
1776 | 2046 | $error = update_db::retrieve_owner($tmp_dir.'owner_ei.csv','EI'); |
1777 | - } else $error = "File ".$tmp_dir.'owner_ei.csv'." doesn't exist. Download failed."; |
|
2047 | + } else { |
|
2048 | + $error = "File ".$tmp_dir.'owner_ei.csv'." doesn't exist. Download failed."; |
|
2049 | + } |
|
1778 | 2050 | if ($error != '') { |
1779 | 2051 | return $error; |
1780 | - } elseif ($globalDebug) echo "Done\n"; |
|
1781 | - if ($globalDebug) echo "Owner Switzerland: Download..."; |
|
2052 | + } elseif ($globalDebug) { |
|
2053 | + echo "Done\n"; |
|
2054 | + } |
|
2055 | + if ($globalDebug) { |
|
2056 | + echo "Owner Switzerland: Download..."; |
|
2057 | + } |
|
1782 | 2058 | update_db::download('http://antonakis.co.uk/registers/Switzerland.txt',$tmp_dir.'owner_hb.csv'); |
1783 | 2059 | if (file_exists($tmp_dir.'owner_hb.csv')) { |
1784 | - if ($globalDebug) echo "Add to DB..."; |
|
2060 | + if ($globalDebug) { |
|
2061 | + echo "Add to DB..."; |
|
2062 | + } |
|
1785 | 2063 | $error = update_db::retrieve_owner($tmp_dir.'owner_hb.csv','HB'); |
1786 | - } else $error = "File ".$tmp_dir.'owner_hb.csv'." doesn't exist. Download failed."; |
|
2064 | + } else { |
|
2065 | + $error = "File ".$tmp_dir.'owner_hb.csv'." doesn't exist. Download failed."; |
|
2066 | + } |
|
1787 | 2067 | if ($error != '') { |
1788 | 2068 | return $error; |
1789 | - } elseif ($globalDebug) echo "Done\n"; |
|
1790 | - if ($globalDebug) echo "Owner Czech Republic: Download..."; |
|
2069 | + } elseif ($globalDebug) { |
|
2070 | + echo "Done\n"; |
|
2071 | + } |
|
2072 | + if ($globalDebug) { |
|
2073 | + echo "Owner Czech Republic: Download..."; |
|
2074 | + } |
|
1791 | 2075 | update_db::download('http://antonakis.co.uk/registers/CzechRepublic.txt',$tmp_dir.'owner_ok.csv'); |
1792 | 2076 | if (file_exists($tmp_dir.'owner_ok.csv')) { |
1793 | - if ($globalDebug) echo "Add to DB..."; |
|
2077 | + if ($globalDebug) { |
|
2078 | + echo "Add to DB..."; |
|
2079 | + } |
|
1794 | 2080 | $error = update_db::retrieve_owner($tmp_dir.'owner_ok.csv','OK'); |
1795 | - } else $error = "File ".$tmp_dir.'owner_ok.csv'." doesn't exist. Download failed."; |
|
2081 | + } else { |
|
2082 | + $error = "File ".$tmp_dir.'owner_ok.csv'." doesn't exist. Download failed."; |
|
2083 | + } |
|
1796 | 2084 | if ($error != '') { |
1797 | 2085 | return $error; |
1798 | - } elseif ($globalDebug) echo "Done\n"; |
|
1799 | - if ($globalDebug) echo "Owner Australia: Download..."; |
|
2086 | + } elseif ($globalDebug) { |
|
2087 | + echo "Done\n"; |
|
2088 | + } |
|
2089 | + if ($globalDebug) { |
|
2090 | + echo "Owner Australia: Download..."; |
|
2091 | + } |
|
1800 | 2092 | update_db::download('http://antonakis.co.uk/registers/Australia.txt',$tmp_dir.'owner_vh.csv'); |
1801 | 2093 | if (file_exists($tmp_dir.'owner_vh.csv')) { |
1802 | - if ($globalDebug) echo "Add to DB..."; |
|
2094 | + if ($globalDebug) { |
|
2095 | + echo "Add to DB..."; |
|
2096 | + } |
|
1803 | 2097 | $error = update_db::retrieve_owner($tmp_dir.'owner_vh.csv','VH'); |
1804 | - } else $error = "File ".$tmp_dir.'owner_vh.csv'." doesn't exist. Download failed."; |
|
2098 | + } else { |
|
2099 | + $error = "File ".$tmp_dir.'owner_vh.csv'." doesn't exist. Download failed."; |
|
2100 | + } |
|
1805 | 2101 | if ($error != '') { |
1806 | 2102 | return $error; |
1807 | - } elseif ($globalDebug) echo "Done\n"; |
|
1808 | - if ($globalDebug) echo "Owner Austria: Download..."; |
|
2103 | + } elseif ($globalDebug) { |
|
2104 | + echo "Done\n"; |
|
2105 | + } |
|
2106 | + if ($globalDebug) { |
|
2107 | + echo "Owner Austria: Download..."; |
|
2108 | + } |
|
1809 | 2109 | update_db::download('http://antonakis.co.uk/registers/Austria.txt',$tmp_dir.'owner_oe.csv'); |
1810 | 2110 | if (file_exists($tmp_dir.'owner_oe.csv')) { |
1811 | - if ($globalDebug) echo "Add to DB..."; |
|
2111 | + if ($globalDebug) { |
|
2112 | + echo "Add to DB..."; |
|
2113 | + } |
|
1812 | 2114 | $error = update_db::retrieve_owner($tmp_dir.'owner_oe.csv','OE'); |
1813 | - } else $error = "File ".$tmp_dir.'owner_oe.csv'." doesn't exist. Download failed."; |
|
2115 | + } else { |
|
2116 | + $error = "File ".$tmp_dir.'owner_oe.csv'." doesn't exist. Download failed."; |
|
2117 | + } |
|
1814 | 2118 | if ($error != '') { |
1815 | 2119 | return $error; |
1816 | - } elseif ($globalDebug) echo "Done\n"; |
|
1817 | - if ($globalDebug) echo "Owner Chile: Download..."; |
|
2120 | + } elseif ($globalDebug) { |
|
2121 | + echo "Done\n"; |
|
2122 | + } |
|
2123 | + if ($globalDebug) { |
|
2124 | + echo "Owner Chile: Download..."; |
|
2125 | + } |
|
1818 | 2126 | update_db::download('http://antonakis.co.uk/registers/Chile.txt',$tmp_dir.'owner_cc.csv'); |
1819 | 2127 | if (file_exists($tmp_dir.'owner_cc.csv')) { |
1820 | - if ($globalDebug) echo "Add to DB..."; |
|
2128 | + if ($globalDebug) { |
|
2129 | + echo "Add to DB..."; |
|
2130 | + } |
|
1821 | 2131 | $error = update_db::retrieve_owner($tmp_dir.'owner_cc.csv','CC'); |
1822 | - } else $error = "File ".$tmp_dir.'owner_cc.csv'." doesn't exist. Download failed."; |
|
2132 | + } else { |
|
2133 | + $error = "File ".$tmp_dir.'owner_cc.csv'." doesn't exist. Download failed."; |
|
2134 | + } |
|
1823 | 2135 | if ($error != '') { |
1824 | 2136 | return $error; |
1825 | - } elseif ($globalDebug) echo "Done\n"; |
|
1826 | - if ($globalDebug) echo "Owner Colombia: Download..."; |
|
2137 | + } elseif ($globalDebug) { |
|
2138 | + echo "Done\n"; |
|
2139 | + } |
|
2140 | + if ($globalDebug) { |
|
2141 | + echo "Owner Colombia: Download..."; |
|
2142 | + } |
|
1827 | 2143 | update_db::download('http://antonakis.co.uk/registers/Colombia.txt',$tmp_dir.'owner_hj.csv'); |
1828 | 2144 | if (file_exists($tmp_dir.'owner_hj.csv')) { |
1829 | - if ($globalDebug) echo "Add to DB..."; |
|
2145 | + if ($globalDebug) { |
|
2146 | + echo "Add to DB..."; |
|
2147 | + } |
|
1830 | 2148 | $error = update_db::retrieve_owner($tmp_dir.'owner_hj.csv','HJ'); |
1831 | - } else $error = "File ".$tmp_dir.'owner_hj.csv'." doesn't exist. Download failed."; |
|
2149 | + } else { |
|
2150 | + $error = "File ".$tmp_dir.'owner_hj.csv'." doesn't exist. Download failed."; |
|
2151 | + } |
|
1832 | 2152 | if ($error != '') { |
1833 | 2153 | return $error; |
1834 | - } elseif ($globalDebug) echo "Done\n"; |
|
1835 | - if ($globalDebug) echo "Owner Bosnia Herzegobina: Download..."; |
|
2154 | + } elseif ($globalDebug) { |
|
2155 | + echo "Done\n"; |
|
2156 | + } |
|
2157 | + if ($globalDebug) { |
|
2158 | + echo "Owner Bosnia Herzegobina: Download..."; |
|
2159 | + } |
|
1836 | 2160 | update_db::download('http://antonakis.co.uk/registers/BosniaHerzegovina.txt',$tmp_dir.'owner_e7.csv'); |
1837 | 2161 | if (file_exists($tmp_dir.'owner_e7.csv')) { |
1838 | - if ($globalDebug) echo "Add to DB..."; |
|
2162 | + if ($globalDebug) { |
|
2163 | + echo "Add to DB..."; |
|
2164 | + } |
|
1839 | 2165 | $error = update_db::retrieve_owner($tmp_dir.'owner_e7.csv','E7'); |
1840 | - } else $error = "File ".$tmp_dir.'owner_e7.csv'." doesn't exist. Download failed."; |
|
2166 | + } else { |
|
2167 | + $error = "File ".$tmp_dir.'owner_e7.csv'." doesn't exist. Download failed."; |
|
2168 | + } |
|
1841 | 2169 | if ($error != '') { |
1842 | 2170 | return $error; |
1843 | - } elseif ($globalDebug) echo "Done\n"; |
|
1844 | - if ($globalDebug) echo "Owner Brazil: Download..."; |
|
2171 | + } elseif ($globalDebug) { |
|
2172 | + echo "Done\n"; |
|
2173 | + } |
|
2174 | + if ($globalDebug) { |
|
2175 | + echo "Owner Brazil: Download..."; |
|
2176 | + } |
|
1845 | 2177 | update_db::download('http://antonakis.co.uk/registers/Brazil.txt',$tmp_dir.'owner_pp.csv'); |
1846 | 2178 | if (file_exists($tmp_dir.'owner_pp.csv')) { |
1847 | - if ($globalDebug) echo "Add to DB..."; |
|
2179 | + if ($globalDebug) { |
|
2180 | + echo "Add to DB..."; |
|
2181 | + } |
|
1848 | 2182 | $error = update_db::retrieve_owner($tmp_dir.'owner_pp.csv','PP'); |
1849 | - } else $error = "File ".$tmp_dir.'owner_pp.csv'." doesn't exist. Download failed."; |
|
2183 | + } else { |
|
2184 | + $error = "File ".$tmp_dir.'owner_pp.csv'." doesn't exist. Download failed."; |
|
2185 | + } |
|
1850 | 2186 | if ($error != '') { |
1851 | 2187 | return $error; |
1852 | - } elseif ($globalDebug) echo "Done\n"; |
|
1853 | - if ($globalDebug) echo "Owner Cayman Islands: Download..."; |
|
2188 | + } elseif ($globalDebug) { |
|
2189 | + echo "Done\n"; |
|
2190 | + } |
|
2191 | + if ($globalDebug) { |
|
2192 | + echo "Owner Cayman Islands: Download..."; |
|
2193 | + } |
|
1854 | 2194 | update_db::download('http://antonakis.co.uk/registers/CaymanIslands.txt',$tmp_dir.'owner_vp.csv'); |
1855 | 2195 | if (file_exists($tmp_dir.'owner_vp.csv')) { |
1856 | - if ($globalDebug) echo "Add to DB..."; |
|
2196 | + if ($globalDebug) { |
|
2197 | + echo "Add to DB..."; |
|
2198 | + } |
|
1857 | 2199 | $error = update_db::retrieve_owner($tmp_dir.'owner_vp.csv','VP'); |
1858 | - } else $error = "File ".$tmp_dir.'owner_vp.csv'." doesn't exist. Download failed."; |
|
2200 | + } else { |
|
2201 | + $error = "File ".$tmp_dir.'owner_vp.csv'." doesn't exist. Download failed."; |
|
2202 | + } |
|
1859 | 2203 | if ($error != '') { |
1860 | 2204 | return $error; |
1861 | - } elseif ($globalDebug) echo "Done\n"; |
|
1862 | - if ($globalDebug) echo "Owner Croatia: Download..."; |
|
2205 | + } elseif ($globalDebug) { |
|
2206 | + echo "Done\n"; |
|
2207 | + } |
|
2208 | + if ($globalDebug) { |
|
2209 | + echo "Owner Croatia: Download..."; |
|
2210 | + } |
|
1863 | 2211 | update_db::download('http://antonakis.co.uk/registers/Croatia.txt',$tmp_dir.'owner_9a.csv'); |
1864 | 2212 | if (file_exists($tmp_dir.'owner_9a.csv')) { |
1865 | - if ($globalDebug) echo "Add to DB..."; |
|
2213 | + if ($globalDebug) { |
|
2214 | + echo "Add to DB..."; |
|
2215 | + } |
|
1866 | 2216 | $error = update_db::retrieve_owner($tmp_dir.'owner_9a.csv','9A'); |
1867 | - } else $error = "File ".$tmp_dir.'owner_9a.csv'." doesn't exist. Download failed."; |
|
2217 | + } else { |
|
2218 | + $error = "File ".$tmp_dir.'owner_9a.csv'." doesn't exist. Download failed."; |
|
2219 | + } |
|
1868 | 2220 | if ($error != '') { |
1869 | 2221 | return $error; |
1870 | - } elseif ($globalDebug) echo "Done\n"; |
|
1871 | - if ($globalDebug) echo "Owner Luxembourg: Download..."; |
|
2222 | + } elseif ($globalDebug) { |
|
2223 | + echo "Done\n"; |
|
2224 | + } |
|
2225 | + if ($globalDebug) { |
|
2226 | + echo "Owner Luxembourg: Download..."; |
|
2227 | + } |
|
1872 | 2228 | update_db::download('http://antonakis.co.uk/registers/Luxembourg.txt',$tmp_dir.'owner_lx.csv'); |
1873 | 2229 | if (file_exists($tmp_dir.'owner_lx.csv')) { |
1874 | - if ($globalDebug) echo "Add to DB..."; |
|
2230 | + if ($globalDebug) { |
|
2231 | + echo "Add to DB..."; |
|
2232 | + } |
|
1875 | 2233 | $error = update_db::retrieve_owner($tmp_dir.'owner_lx.csv','LX'); |
1876 | - } else $error = "File ".$tmp_dir.'owner_lx.csv'." doesn't exist. Download failed."; |
|
2234 | + } else { |
|
2235 | + $error = "File ".$tmp_dir.'owner_lx.csv'." doesn't exist. Download failed."; |
|
2236 | + } |
|
1877 | 2237 | if ($error != '') { |
1878 | 2238 | return $error; |
1879 | - } elseif ($globalDebug) echo "Done\n"; |
|
1880 | - if ($globalDebug) echo "Owner Maldives: Download..."; |
|
2239 | + } elseif ($globalDebug) { |
|
2240 | + echo "Done\n"; |
|
2241 | + } |
|
2242 | + if ($globalDebug) { |
|
2243 | + echo "Owner Maldives: Download..."; |
|
2244 | + } |
|
1881 | 2245 | update_db::download('http://antonakis.co.uk/registers/Maldives.txt',$tmp_dir.'owner_8q.csv'); |
1882 | 2246 | if (file_exists($tmp_dir.'owner_8q.csv')) { |
1883 | - if ($globalDebug) echo "Add to DB..."; |
|
2247 | + if ($globalDebug) { |
|
2248 | + echo "Add to DB..."; |
|
2249 | + } |
|
1884 | 2250 | $error = update_db::retrieve_owner($tmp_dir.'owner_8q.csv','8Q'); |
1885 | - } else $error = "File ".$tmp_dir.'owner_8q.csv'." doesn't exist. Download failed."; |
|
2251 | + } else { |
|
2252 | + $error = "File ".$tmp_dir.'owner_8q.csv'." doesn't exist. Download failed."; |
|
2253 | + } |
|
1886 | 2254 | if ($error != '') { |
1887 | 2255 | return $error; |
1888 | - } elseif ($globalDebug) echo "Done\n"; |
|
1889 | - if ($globalDebug) echo "Owner New Zealand: Download..."; |
|
2256 | + } elseif ($globalDebug) { |
|
2257 | + echo "Done\n"; |
|
2258 | + } |
|
2259 | + if ($globalDebug) { |
|
2260 | + echo "Owner New Zealand: Download..."; |
|
2261 | + } |
|
1890 | 2262 | update_db::download('http://antonakis.co.uk/registers/NewZealand.txt',$tmp_dir.'owner_zk.csv'); |
1891 | 2263 | if (file_exists($tmp_dir.'owner_zk.csv')) { |
1892 | - if ($globalDebug) echo "Add to DB..."; |
|
2264 | + if ($globalDebug) { |
|
2265 | + echo "Add to DB..."; |
|
2266 | + } |
|
1893 | 2267 | $error = update_db::retrieve_owner($tmp_dir.'owner_zk.csv','ZK'); |
1894 | - } else $error = "File ".$tmp_dir.'owner_zk.csv'." doesn't exist. Download failed."; |
|
2268 | + } else { |
|
2269 | + $error = "File ".$tmp_dir.'owner_zk.csv'." doesn't exist. Download failed."; |
|
2270 | + } |
|
1895 | 2271 | if ($error != '') { |
1896 | 2272 | return $error; |
1897 | - } elseif ($globalDebug) echo "Done\n"; |
|
1898 | - if ($globalDebug) echo "Owner Papua New Guinea: Download..."; |
|
2273 | + } elseif ($globalDebug) { |
|
2274 | + echo "Done\n"; |
|
2275 | + } |
|
2276 | + if ($globalDebug) { |
|
2277 | + echo "Owner Papua New Guinea: Download..."; |
|
2278 | + } |
|
1899 | 2279 | update_db::download('http://antonakis.co.uk/registers/PapuaNewGuinea.txt',$tmp_dir.'owner_p2.csv'); |
1900 | 2280 | if (file_exists($tmp_dir.'owner_p2.csv')) { |
1901 | - if ($globalDebug) echo "Add to DB..."; |
|
2281 | + if ($globalDebug) { |
|
2282 | + echo "Add to DB..."; |
|
2283 | + } |
|
1902 | 2284 | $error = update_db::retrieve_owner($tmp_dir.'owner_p2.csv','P2'); |
1903 | - } else $error = "File ".$tmp_dir.'owner_p2.csv'." doesn't exist. Download failed."; |
|
2285 | + } else { |
|
2286 | + $error = "File ".$tmp_dir.'owner_p2.csv'." doesn't exist. Download failed."; |
|
2287 | + } |
|
1904 | 2288 | if ($error != '') { |
1905 | 2289 | return $error; |
1906 | - } elseif ($globalDebug) echo "Done\n"; |
|
1907 | - if ($globalDebug) echo "Owner Slovakia: Download..."; |
|
2290 | + } elseif ($globalDebug) { |
|
2291 | + echo "Done\n"; |
|
2292 | + } |
|
2293 | + if ($globalDebug) { |
|
2294 | + echo "Owner Slovakia: Download..."; |
|
2295 | + } |
|
1908 | 2296 | update_db::download('http://antonakis.co.uk/registers/Slovakia.txt',$tmp_dir.'owner_om.csv'); |
1909 | 2297 | if (file_exists($tmp_dir.'owner_om.csv')) { |
1910 | - if ($globalDebug) echo "Add to DB..."; |
|
2298 | + if ($globalDebug) { |
|
2299 | + echo "Add to DB..."; |
|
2300 | + } |
|
1911 | 2301 | $error = update_db::retrieve_owner($tmp_dir.'owner_om.csv','OM'); |
1912 | - } else $error = "File ".$tmp_dir.'owner_om.csv'." doesn't exist. Download failed."; |
|
2302 | + } else { |
|
2303 | + $error = "File ".$tmp_dir.'owner_om.csv'." doesn't exist. Download failed."; |
|
2304 | + } |
|
1913 | 2305 | if ($error != '') { |
1914 | 2306 | return $error; |
1915 | - } elseif ($globalDebug) echo "Done\n"; |
|
1916 | - if ($globalDebug) echo "Owner Ecuador: Download..."; |
|
2307 | + } elseif ($globalDebug) { |
|
2308 | + echo "Done\n"; |
|
2309 | + } |
|
2310 | + if ($globalDebug) { |
|
2311 | + echo "Owner Ecuador: Download..."; |
|
2312 | + } |
|
1917 | 2313 | update_db::download('http://antonakis.co.uk/registers/Ecuador.txt',$tmp_dir.'owner_hc.csv'); |
1918 | 2314 | if (file_exists($tmp_dir.'owner_hc.csv')) { |
1919 | - if ($globalDebug) echo "Add to DB..."; |
|
2315 | + if ($globalDebug) { |
|
2316 | + echo "Add to DB..."; |
|
2317 | + } |
|
1920 | 2318 | $error = update_db::retrieve_owner($tmp_dir.'owner_hc.csv','HC'); |
1921 | - } else $error = "File ".$tmp_dir.'owner_hc.csv'." doesn't exist. Download failed."; |
|
2319 | + } else { |
|
2320 | + $error = "File ".$tmp_dir.'owner_hc.csv'." doesn't exist. Download failed."; |
|
2321 | + } |
|
1922 | 2322 | if ($error != '') { |
1923 | 2323 | return $error; |
1924 | - } elseif ($globalDebug) echo "Done\n"; |
|
1925 | - if ($globalDebug) echo "Owner Iceland: Download..."; |
|
2324 | + } elseif ($globalDebug) { |
|
2325 | + echo "Done\n"; |
|
2326 | + } |
|
2327 | + if ($globalDebug) { |
|
2328 | + echo "Owner Iceland: Download..."; |
|
2329 | + } |
|
1926 | 2330 | update_db::download('http://antonakis.co.uk/registers/Iceland.txt',$tmp_dir.'owner_tf.csv'); |
1927 | 2331 | if (file_exists($tmp_dir.'owner_tf.csv')) { |
1928 | - if ($globalDebug) echo "Add to DB..."; |
|
2332 | + if ($globalDebug) { |
|
2333 | + echo "Add to DB..."; |
|
2334 | + } |
|
1929 | 2335 | $error = update_db::retrieve_owner($tmp_dir.'owner_tf.csv','TF'); |
1930 | - } else $error = "File ".$tmp_dir.'owner_tf.csv'." doesn't exist. Download failed."; |
|
2336 | + } else { |
|
2337 | + $error = "File ".$tmp_dir.'owner_tf.csv'." doesn't exist. Download failed."; |
|
2338 | + } |
|
1931 | 2339 | if ($error != '') { |
1932 | 2340 | return $error; |
1933 | - } elseif ($globalDebug) echo "Done\n"; |
|
1934 | - if ($globalDebug) echo "Owner Isle of Man: Download..."; |
|
2341 | + } elseif ($globalDebug) { |
|
2342 | + echo "Done\n"; |
|
2343 | + } |
|
2344 | + if ($globalDebug) { |
|
2345 | + echo "Owner Isle of Man: Download..."; |
|
2346 | + } |
|
1935 | 2347 | update_db::download('http://antonakis.co.uk/registers/IsleOfMan.txt',$tmp_dir.'owner_m.csv'); |
1936 | 2348 | if (file_exists($tmp_dir.'owner_m.csv')) { |
1937 | - if ($globalDebug) echo "Add to DB..."; |
|
2349 | + if ($globalDebug) { |
|
2350 | + echo "Add to DB..."; |
|
2351 | + } |
|
1938 | 2352 | $error = update_db::retrieve_owner($tmp_dir.'owner_m.csv','M'); |
1939 | - } else $error = "File ".$tmp_dir.'owner_m.csv'." doesn't exist. Download failed."; |
|
2353 | + } else { |
|
2354 | + $error = "File ".$tmp_dir.'owner_m.csv'." doesn't exist. Download failed."; |
|
2355 | + } |
|
1940 | 2356 | if ($error != '') { |
1941 | 2357 | return $error; |
1942 | - } elseif ($globalDebug) echo "Done\n"; |
|
2358 | + } elseif ($globalDebug) { |
|
2359 | + echo "Done\n"; |
|
2360 | + } |
|
1943 | 2361 | if ($globalMasterSource) { |
1944 | - if ($globalDebug) echo "ModeS Netherlands: Download..."; |
|
2362 | + if ($globalDebug) { |
|
2363 | + echo "ModeS Netherlands: Download..."; |
|
2364 | + } |
|
1945 | 2365 | update_db::download('http://antonakis.co.uk/registers/Netherlands.txt',$tmp_dir.'owner_ph.csv'); |
1946 | 2366 | if (file_exists($tmp_dir.'owner_ph.csv')) { |
1947 | - if ($globalDebug) echo "Add to DB..."; |
|
2367 | + if ($globalDebug) { |
|
2368 | + echo "Add to DB..."; |
|
2369 | + } |
|
1948 | 2370 | $error = update_db::retrieve_owner($tmp_dir.'owner_ph.csv','PH'); |
1949 | - } else $error = "File ".$tmp_dir.'owner_ph.csv'." doesn't exist. Download failed."; |
|
2371 | + } else { |
|
2372 | + $error = "File ".$tmp_dir.'owner_ph.csv'." doesn't exist. Download failed."; |
|
2373 | + } |
|
1950 | 2374 | if ($error != '') { |
1951 | 2375 | return $error; |
1952 | - } elseif ($globalDebug) echo "Done\n"; |
|
1953 | - if ($globalDebug) echo "ModeS Denmark: Download..."; |
|
2376 | + } elseif ($globalDebug) { |
|
2377 | + echo "Done\n"; |
|
2378 | + } |
|
2379 | + if ($globalDebug) { |
|
2380 | + echo "ModeS Denmark: Download..."; |
|
2381 | + } |
|
1954 | 2382 | update_db::download('http://antonakis.co.uk/registers/Denmark.txt',$tmp_dir.'owner_oy.csv'); |
1955 | 2383 | if (file_exists($tmp_dir.'owner_oy.csv')) { |
1956 | - if ($globalDebug) echo "Add to DB..."; |
|
2384 | + if ($globalDebug) { |
|
2385 | + echo "Add to DB..."; |
|
2386 | + } |
|
1957 | 2387 | $error = update_db::retrieve_owner($tmp_dir.'owner_oy.csv','OY'); |
1958 | - } else $error = "File ".$tmp_dir.'owner_oy.csv'." doesn't exist. Download failed."; |
|
2388 | + } else { |
|
2389 | + $error = "File ".$tmp_dir.'owner_oy.csv'." doesn't exist. Download failed."; |
|
2390 | + } |
|
1959 | 2391 | if ($error != '') { |
1960 | 2392 | return $error; |
1961 | - } elseif ($globalDebug) echo "Done\n"; |
|
1962 | - } elseif ($globalDebug) echo "Done\n"; |
|
2393 | + } elseif ($globalDebug) { |
|
2394 | + echo "Done\n"; |
|
2395 | + } |
|
2396 | + } elseif ($globalDebug) { |
|
2397 | + echo "Done\n"; |
|
2398 | + } |
|
1963 | 2399 | return ''; |
1964 | 2400 | } |
1965 | 2401 | |
1966 | 2402 | public static function update_translation() { |
1967 | 2403 | global $tmp_dir, $globalDebug; |
1968 | 2404 | $error = ''; |
1969 | - if ($globalDebug) echo "Translation : Download..."; |
|
2405 | + if ($globalDebug) { |
|
2406 | + echo "Translation : Download..."; |
|
2407 | + } |
|
1970 | 2408 | update_db::download('http://www.acarsd.org/download/translation.php',$tmp_dir.'translation.zip'); |
1971 | 2409 | if (file_exists($tmp_dir.'translation.zip')) { |
1972 | - if ($globalDebug) echo "Unzip..."; |
|
2410 | + if ($globalDebug) { |
|
2411 | + echo "Unzip..."; |
|
2412 | + } |
|
1973 | 2413 | update_db::unzip($tmp_dir.'translation.zip'); |
1974 | - if ($globalDebug) echo "Add to DB..."; |
|
2414 | + if ($globalDebug) { |
|
2415 | + echo "Add to DB..."; |
|
2416 | + } |
|
1975 | 2417 | $error = update_db::translation(); |
1976 | - } else $error = "File ".$tmp_dir.'translation.zip'." doesn't exist. Download failed."; |
|
2418 | + } else { |
|
2419 | + $error = "File ".$tmp_dir.'translation.zip'." doesn't exist. Download failed."; |
|
2420 | + } |
|
1977 | 2421 | if ($error != '') { |
1978 | 2422 | return $error; |
1979 | - } elseif ($globalDebug) echo "Done\n"; |
|
2423 | + } elseif ($globalDebug) { |
|
2424 | + echo "Done\n"; |
|
2425 | + } |
|
1980 | 2426 | return ''; |
1981 | 2427 | } |
1982 | 2428 | |
1983 | 2429 | public static function update_translation_fam() { |
1984 | 2430 | global $tmp_dir, $globalDebug; |
1985 | - if ($globalDebug) echo "Translation from FlightAirMap website : Download..."; |
|
2431 | + if ($globalDebug) { |
|
2432 | + echo "Translation from FlightAirMap website : Download..."; |
|
2433 | + } |
|
1986 | 2434 | update_db::download('http://data.flightairmap.fr/data/translation.tsv.gz',$tmp_dir.'translation.tsv.gz'); |
1987 | 2435 | if (file_exists($tmp_dir.'translation.tsv.gz')) { |
1988 | - if ($globalDebug) echo "Gunzip..."; |
|
2436 | + if ($globalDebug) { |
|
2437 | + echo "Gunzip..."; |
|
2438 | + } |
|
1989 | 2439 | update_db::gunzip($tmp_dir.'translation.tsv.gz'); |
1990 | - if ($globalDebug) echo "Add to DB..."; |
|
2440 | + if ($globalDebug) { |
|
2441 | + echo "Add to DB..."; |
|
2442 | + } |
|
1991 | 2443 | $error = update_db::translation_fam(); |
1992 | - } else $error = "File ".$tmp_dir.'translation.tsv.gz'." doesn't exist. Download failed."; |
|
2444 | + } else { |
|
2445 | + $error = "File ".$tmp_dir.'translation.tsv.gz'." doesn't exist. Download failed."; |
|
2446 | + } |
|
1993 | 2447 | if ($error != '') { |
1994 | 2448 | return $error; |
1995 | - } elseif ($globalDebug) echo "Done\n"; |
|
2449 | + } elseif ($globalDebug) { |
|
2450 | + echo "Done\n"; |
|
2451 | + } |
|
1996 | 2452 | return ''; |
1997 | 2453 | } |
1998 | 2454 | public static function update_ModeS_fam() { |
1999 | 2455 | global $tmp_dir, $globalDebug; |
2000 | - if ($globalDebug) echo "ModeS from FlightAirMap website : Download..."; |
|
2456 | + if ($globalDebug) { |
|
2457 | + echo "ModeS from FlightAirMap website : Download..."; |
|
2458 | + } |
|
2001 | 2459 | update_db::download('http://data.flightairmap.fr/data/modes.tsv.gz',$tmp_dir.'modes.tsv.gz'); |
2002 | 2460 | if (file_exists($tmp_dir.'modes.tsv.gz')) { |
2003 | - if ($globalDebug) echo "Gunzip..."; |
|
2461 | + if ($globalDebug) { |
|
2462 | + echo "Gunzip..."; |
|
2463 | + } |
|
2004 | 2464 | update_db::gunzip($tmp_dir.'modes.tsv.gz'); |
2005 | - if ($globalDebug) echo "Add to DB..."; |
|
2465 | + if ($globalDebug) { |
|
2466 | + echo "Add to DB..."; |
|
2467 | + } |
|
2006 | 2468 | $error = update_db::modes_fam(); |
2007 | - } else $error = "File ".$tmp_dir.'modes.tsv.gz'." doesn't exist. Download failed."; |
|
2469 | + } else { |
|
2470 | + $error = "File ".$tmp_dir.'modes.tsv.gz'." doesn't exist. Download failed."; |
|
2471 | + } |
|
2008 | 2472 | if ($error != '') { |
2009 | 2473 | return $error; |
2010 | - } elseif ($globalDebug) echo "Done\n"; |
|
2474 | + } elseif ($globalDebug) { |
|
2475 | + echo "Done\n"; |
|
2476 | + } |
|
2011 | 2477 | return ''; |
2012 | 2478 | } |
2013 | 2479 | public static function update_owner_fam() { |
2014 | 2480 | global $tmp_dir, $globalDebug, $globalOwner; |
2015 | - if ($globalDebug) echo "owner from FlightAirMap website : Download..."; |
|
2481 | + if ($globalDebug) { |
|
2482 | + echo "owner from FlightAirMap website : Download..."; |
|
2483 | + } |
|
2016 | 2484 | if ($globalOwner === TRUE) { |
2017 | 2485 | update_db::download('http://data.flightairmap.fr/data/owners_all.tsv.gz',$tmp_dir.'owners.tsv.gz'); |
2018 | 2486 | } else { |
2019 | 2487 | update_db::download('http://data.flightairmap.fr/data/owners.tsv.gz',$tmp_dir.'owners.tsv.gz'); |
2020 | 2488 | } |
2021 | 2489 | if (file_exists($tmp_dir.'owners.tsv.gz')) { |
2022 | - if ($globalDebug) echo "Gunzip..."; |
|
2490 | + if ($globalDebug) { |
|
2491 | + echo "Gunzip..."; |
|
2492 | + } |
|
2023 | 2493 | update_db::gunzip($tmp_dir.'owners.tsv.gz'); |
2024 | - if ($globalDebug) echo "Add to DB..."; |
|
2494 | + if ($globalDebug) { |
|
2495 | + echo "Add to DB..."; |
|
2496 | + } |
|
2025 | 2497 | $error = update_db::owner_fam(); |
2026 | - } else $error = "File ".$tmp_dir.'owners.tsv.gz'." doesn't exist. Download failed."; |
|
2498 | + } else { |
|
2499 | + $error = "File ".$tmp_dir.'owners.tsv.gz'." doesn't exist. Download failed."; |
|
2500 | + } |
|
2027 | 2501 | if ($error != '') { |
2028 | 2502 | return $error; |
2029 | - } elseif ($globalDebug) echo "Done\n"; |
|
2503 | + } elseif ($globalDebug) { |
|
2504 | + echo "Done\n"; |
|
2505 | + } |
|
2030 | 2506 | return ''; |
2031 | 2507 | } |
2032 | 2508 | public static function update_routes_fam() { |
2033 | 2509 | global $tmp_dir, $globalDebug; |
2034 | - if ($globalDebug) echo "Routes from FlightAirMap website : Download..."; |
|
2510 | + if ($globalDebug) { |
|
2511 | + echo "Routes from FlightAirMap website : Download..."; |
|
2512 | + } |
|
2035 | 2513 | update_db::download('http://data.flightairmap.fr/data/routes.tsv.gz',$tmp_dir.'routes.tsv.gz'); |
2036 | 2514 | if (file_exists($tmp_dir.'routes.tsv.gz')) { |
2037 | - if ($globalDebug) echo "Gunzip..."; |
|
2515 | + if ($globalDebug) { |
|
2516 | + echo "Gunzip..."; |
|
2517 | + } |
|
2038 | 2518 | update_db::gunzip($tmp_dir.'routes.tsv.gz'); |
2039 | - if ($globalDebug) echo "Add to DB..."; |
|
2519 | + if ($globalDebug) { |
|
2520 | + echo "Add to DB..."; |
|
2521 | + } |
|
2040 | 2522 | $error = update_db::routes_fam(); |
2041 | - } else $error = "File ".$tmp_dir.'routes.tsv.gz'." doesn't exist. Download failed."; |
|
2523 | + } else { |
|
2524 | + $error = "File ".$tmp_dir.'routes.tsv.gz'." doesn't exist. Download failed."; |
|
2525 | + } |
|
2042 | 2526 | if ($error != '') { |
2043 | 2527 | return $error; |
2044 | - } elseif ($globalDebug) echo "Done\n"; |
|
2528 | + } elseif ($globalDebug) { |
|
2529 | + echo "Done\n"; |
|
2530 | + } |
|
2045 | 2531 | return ''; |
2046 | 2532 | } |
2047 | 2533 | public static function update_marine_identity_fam() { |
@@ -2051,14 +2537,22 @@ discard block |
||
2051 | 2537 | $marine_identity_md5_file = explode(' ',file_get_contents($tmp_dir.'marine_identity.tsv.gz.md5')); |
2052 | 2538 | $marine_identity_md5 = $marine_identity_md5_file[0]; |
2053 | 2539 | if (!update_db::check_marine_identity_version($marine_identity_md5)) { |
2054 | - if ($globalDebug) echo "Marine identity from FlightAirMap website : Download..."; |
|
2540 | + if ($globalDebug) { |
|
2541 | + echo "Marine identity from FlightAirMap website : Download..."; |
|
2542 | + } |
|
2055 | 2543 | update_db::download('http://data.flightairmap.fr/data/marine_identity.tsv.gz',$tmp_dir.'marine_identity.tsv.gz'); |
2056 | 2544 | if (file_exists($tmp_dir.'marine_identity.tsv.gz')) { |
2057 | - if ($globalDebug) echo "Gunzip..."; |
|
2545 | + if ($globalDebug) { |
|
2546 | + echo "Gunzip..."; |
|
2547 | + } |
|
2058 | 2548 | update_db::gunzip($tmp_dir.'marine_identity.tsv.gz'); |
2059 | - if ($globalDebug) echo "Add to DB..."; |
|
2549 | + if ($globalDebug) { |
|
2550 | + echo "Add to DB..."; |
|
2551 | + } |
|
2060 | 2552 | $error = update_db::marine_identity_fam(); |
2061 | - } else $error = "File ".$tmp_dir.'marine_identity.tsv.gz'." doesn't exist. Download failed."; |
|
2553 | + } else { |
|
2554 | + $error = "File ".$tmp_dir.'marine_identity.tsv.gz'." doesn't exist. Download failed."; |
|
2555 | + } |
|
2062 | 2556 | if ($error != '') { |
2063 | 2557 | return $error; |
2064 | 2558 | } elseif ($globalDebug) { |
@@ -2071,17 +2565,25 @@ discard block |
||
2071 | 2565 | } |
2072 | 2566 | public static function update_banned_fam() { |
2073 | 2567 | global $tmp_dir, $globalDebug; |
2074 | - if ($globalDebug) echo "Banned airlines in Europe from FlightAirMap website : Download..."; |
|
2568 | + if ($globalDebug) { |
|
2569 | + echo "Banned airlines in Europe from FlightAirMap website : Download..."; |
|
2570 | + } |
|
2075 | 2571 | update_db::download('http://data.flightairmap.fr/data/ban-eu.csv',$tmp_dir.'ban_eu.csv'); |
2076 | 2572 | if (file_exists($tmp_dir.'ban_eu.csv')) { |
2077 | 2573 | //if ($globalDebug) echo "Gunzip..."; |
2078 | 2574 | //update_db::gunzip($tmp_dir.'ban_ue.csv'); |
2079 | - if ($globalDebug) echo "Add to DB..."; |
|
2575 | + if ($globalDebug) { |
|
2576 | + echo "Add to DB..."; |
|
2577 | + } |
|
2080 | 2578 | $error = update_db::banned_fam(); |
2081 | - } else $error = "File ".$tmp_dir.'ban_eu.csv'." doesn't exist. Download failed."; |
|
2579 | + } else { |
|
2580 | + $error = "File ".$tmp_dir.'ban_eu.csv'." doesn't exist. Download failed."; |
|
2581 | + } |
|
2082 | 2582 | if ($error != '') { |
2083 | 2583 | return $error; |
2084 | - } elseif ($globalDebug) echo "Done\n"; |
|
2584 | + } elseif ($globalDebug) { |
|
2585 | + echo "Done\n"; |
|
2586 | + } |
|
2085 | 2587 | return ''; |
2086 | 2588 | } |
2087 | 2589 | |
@@ -2089,7 +2591,9 @@ discard block |
||
2089 | 2591 | global $tmp_dir, $globalDebug, $globalDBdriver; |
2090 | 2592 | include_once('class.create_db.php'); |
2091 | 2593 | $error = ''; |
2092 | - if ($globalDebug) echo "Airspace from FlightAirMap website : Download..."; |
|
2594 | + if ($globalDebug) { |
|
2595 | + echo "Airspace from FlightAirMap website : Download..."; |
|
2596 | + } |
|
2093 | 2597 | if ($globalDBdriver == 'mysql') { |
2094 | 2598 | update_db::download('http://data.flightairmap.fr/data/airspace_mysql.sql.gz.md5',$tmp_dir.'airspace.sql.gz.md5'); |
2095 | 2599 | } else { |
@@ -2105,9 +2609,13 @@ discard block |
||
2105 | 2609 | update_db::download('http://data.flightairmap.fr/data/airspace_pgsql.sql.gz',$tmp_dir.'airspace.sql.gz'); |
2106 | 2610 | } |
2107 | 2611 | if (file_exists($tmp_dir.'airspace.sql.gz')) { |
2108 | - if ($globalDebug) echo "Gunzip..."; |
|
2612 | + if ($globalDebug) { |
|
2613 | + echo "Gunzip..."; |
|
2614 | + } |
|
2109 | 2615 | update_db::gunzip($tmp_dir.'airspace.sql.gz'); |
2110 | - if ($globalDebug) echo "Add to DB..."; |
|
2616 | + if ($globalDebug) { |
|
2617 | + echo "Add to DB..."; |
|
2618 | + } |
|
2111 | 2619 | $Connection = new Connection(); |
2112 | 2620 | if ($Connection->tableExists('airspace')) { |
2113 | 2621 | $query = 'DROP TABLE airspace'; |
@@ -2120,19 +2628,27 @@ discard block |
||
2120 | 2628 | } |
2121 | 2629 | $error = create_db::import_file($tmp_dir.'airspace.sql'); |
2122 | 2630 | update_db::insert_airspace_version($airspace_md5); |
2123 | - } else $error = "File ".$tmp_dir.'airpsace.sql.gz'." doesn't exist. Download failed."; |
|
2631 | + } else { |
|
2632 | + $error = "File ".$tmp_dir.'airpsace.sql.gz'." doesn't exist. Download failed."; |
|
2633 | + } |
|
2124 | 2634 | } |
2125 | - } else $error = "File ".$tmp_dir.'airpsace.sql.gz.md5'." doesn't exist. Download failed."; |
|
2635 | + } else { |
|
2636 | + $error = "File ".$tmp_dir.'airpsace.sql.gz.md5'." doesn't exist. Download failed."; |
|
2637 | + } |
|
2126 | 2638 | if ($error != '') { |
2127 | 2639 | return $error; |
2128 | - } elseif ($globalDebug) echo "Done\n"; |
|
2640 | + } elseif ($globalDebug) { |
|
2641 | + echo "Done\n"; |
|
2642 | + } |
|
2129 | 2643 | return ''; |
2130 | 2644 | } |
2131 | 2645 | |
2132 | 2646 | public static function update_geoid_fam() { |
2133 | 2647 | global $tmp_dir, $globalDebug, $globalGeoidSource; |
2134 | 2648 | $error = ''; |
2135 | - if ($globalDebug) echo "Geoid from FlightAirMap website : Download..."; |
|
2649 | + if ($globalDebug) { |
|
2650 | + echo "Geoid from FlightAirMap website : Download..."; |
|
2651 | + } |
|
2136 | 2652 | update_db::download('http://data.flightairmap.fr/data/geoid/'.$globalGeoidSource.'.pgm.gz.md5',$tmp_dir.$globalGeoidSource.'.pgm.gz.md5'); |
2137 | 2653 | if (file_exists($tmp_dir.$globalGeoidSource.'.pgm.gz.md5')) { |
2138 | 2654 | $geoid_md5_file = explode(' ',file_get_contents($tmp_dir.$globalGeoidSource.'.pgm.gz.md5')); |
@@ -2140,36 +2656,54 @@ discard block |
||
2140 | 2656 | if (!update_db::check_geoid_version($geoid_md5)) { |
2141 | 2657 | update_db::download('http://data.flightairmap.fr/data/geoid/'.$globalGeoidSource.'.pgm.gz',$tmp_dir.$globalGeoidSource.'.pgm.gz'); |
2142 | 2658 | if (file_exists($tmp_dir.$globalGeoidSource.'.pgm.gz')) { |
2143 | - if ($globalDebug) echo "Gunzip..."; |
|
2659 | + if ($globalDebug) { |
|
2660 | + echo "Gunzip..."; |
|
2661 | + } |
|
2144 | 2662 | update_db::gunzip($tmp_dir.$globalGeoidSource.'.pgm.gz',dirname(__FILE__).'/../data/'.$globalGeoidSource.'.pgm'); |
2145 | 2663 | if (file_exists(dirname(__FILE__).'/../data/'.$globalGeoidSource.'.pgm')) { |
2146 | 2664 | update_db::insert_geoid_version($geoid_md5); |
2147 | 2665 | } |
2148 | - } else $error = "File ".$tmp_dir.$globalGeoidSource.'.pgm.gz'." doesn't exist. Download failed."; |
|
2666 | + } else { |
|
2667 | + $error = "File ".$tmp_dir.$globalGeoidSource.'.pgm.gz'." doesn't exist. Download failed."; |
|
2668 | + } |
|
2149 | 2669 | } |
2150 | - } else $error = "File ".$tmp_dir.$globalGeoidSource.'.pgm.gz.md5'." doesn't exist. Download failed."; |
|
2670 | + } else { |
|
2671 | + $error = "File ".$tmp_dir.$globalGeoidSource.'.pgm.gz.md5'." doesn't exist. Download failed."; |
|
2672 | + } |
|
2151 | 2673 | if ($error != '') { |
2152 | 2674 | return $error; |
2153 | - } elseif ($globalDebug) echo "Done\n"; |
|
2675 | + } elseif ($globalDebug) { |
|
2676 | + echo "Done\n"; |
|
2677 | + } |
|
2154 | 2678 | return ''; |
2155 | 2679 | } |
2156 | 2680 | |
2157 | 2681 | public static function update_tle() { |
2158 | 2682 | global $tmp_dir, $globalDebug; |
2159 | - if ($globalDebug) echo "Download TLE : Download..."; |
|
2683 | + if ($globalDebug) { |
|
2684 | + echo "Download TLE : Download..."; |
|
2685 | + } |
|
2160 | 2686 | $alltle = array('stations.txt','gps-ops.txt','glo-ops.txt','galileo.txt','weather.txt','noaa.txt','goes.txt','resource.txt','dmc.txt','tdrss.txt','geo.txt','intelsat.txt','gorizont.txt', |
2161 | 2687 | 'raduga.txt','molniya.txt','iridium.txt','orbcomm.txt','globalstar.txt','amateur.txt','x-comm.txt','other-comm.txt','sbas.txt','nnss.txt','musson.txt','science.txt','geodetic.txt', |
2162 | 2688 | 'engineering.txt','education.txt','military.txt','radar.txt','cubesat.txt','other.txt','tle-new.txt'); |
2163 | 2689 | foreach ($alltle as $filename) { |
2164 | - if ($globalDebug) echo "downloading ".$filename.'...'; |
|
2690 | + if ($globalDebug) { |
|
2691 | + echo "downloading ".$filename.'...'; |
|
2692 | + } |
|
2165 | 2693 | update_db::download('http://celestrak.com/NORAD/elements/'.$filename,$tmp_dir.$filename); |
2166 | 2694 | if (file_exists($tmp_dir.$filename)) { |
2167 | - if ($globalDebug) echo "Add to DB ".$filename."..."; |
|
2695 | + if ($globalDebug) { |
|
2696 | + echo "Add to DB ".$filename."..."; |
|
2697 | + } |
|
2168 | 2698 | $error = update_db::tle($tmp_dir.$filename,str_replace('.txt','',$filename)); |
2169 | - } else $error = "File ".$tmp_dir.$filename." doesn't exist. Download failed."; |
|
2699 | + } else { |
|
2700 | + $error = "File ".$tmp_dir.$filename." doesn't exist. Download failed."; |
|
2701 | + } |
|
2170 | 2702 | if ($error != '') { |
2171 | 2703 | echo $error."\n"; |
2172 | - } elseif ($globalDebug) echo "Done\n"; |
|
2704 | + } elseif ($globalDebug) { |
|
2705 | + echo "Done\n"; |
|
2706 | + } |
|
2173 | 2707 | } |
2174 | 2708 | return ''; |
2175 | 2709 | } |
@@ -2177,10 +2711,14 @@ discard block |
||
2177 | 2711 | public static function update_models() { |
2178 | 2712 | global $tmp_dir, $globalDebug; |
2179 | 2713 | $error = ''; |
2180 | - if ($globalDebug) echo "Models from FlightAirMap website : Download..."; |
|
2714 | + if ($globalDebug) { |
|
2715 | + echo "Models from FlightAirMap website : Download..."; |
|
2716 | + } |
|
2181 | 2717 | update_db::download('http://data.flightairmap.fr/data/models/models.md5sum',$tmp_dir.'models.md5sum'); |
2182 | 2718 | if (file_exists($tmp_dir.'models.md5sum')) { |
2183 | - if ($globalDebug) echo "Check files...\n"; |
|
2719 | + if ($globalDebug) { |
|
2720 | + echo "Check files...\n"; |
|
2721 | + } |
|
2184 | 2722 | $newmodelsdb = array(); |
2185 | 2723 | if (($handle = fopen($tmp_dir.'models.md5sum','r')) !== FALSE) { |
2186 | 2724 | while (($row = fgetcsv($handle,1000," ")) !== FALSE) { |
@@ -2199,25 +2737,35 @@ discard block |
||
2199 | 2737 | } |
2200 | 2738 | $diff = array_diff($newmodelsdb,$modelsdb); |
2201 | 2739 | foreach ($diff as $key => $value) { |
2202 | - if ($globalDebug) echo 'Downloading model '.$key.' ...'."\n"; |
|
2740 | + if ($globalDebug) { |
|
2741 | + echo 'Downloading model '.$key.' ...'."\n"; |
|
2742 | + } |
|
2203 | 2743 | update_db::download('http://data.flightairmap.fr/data/models/'.$key,dirname(__FILE__).'/../models/'.$key); |
2204 | 2744 | |
2205 | 2745 | } |
2206 | 2746 | update_db::download('http://data.flightairmap.fr/data/models/models.md5sum',dirname(__FILE__).'/../models/models.md5sum'); |
2207 | - } else $error = "File ".$tmp_dir.'models.md5sum'." doesn't exist. Download failed."; |
|
2747 | + } else { |
|
2748 | + $error = "File ".$tmp_dir.'models.md5sum'." doesn't exist. Download failed."; |
|
2749 | + } |
|
2208 | 2750 | if ($error != '') { |
2209 | 2751 | return $error; |
2210 | - } elseif ($globalDebug) echo "Done\n"; |
|
2752 | + } elseif ($globalDebug) { |
|
2753 | + echo "Done\n"; |
|
2754 | + } |
|
2211 | 2755 | return ''; |
2212 | 2756 | } |
2213 | 2757 | |
2214 | 2758 | public static function update_space_models() { |
2215 | 2759 | global $tmp_dir, $globalDebug; |
2216 | 2760 | $error = ''; |
2217 | - if ($globalDebug) echo "Space models from FlightAirMap website : Download..."; |
|
2761 | + if ($globalDebug) { |
|
2762 | + echo "Space models from FlightAirMap website : Download..."; |
|
2763 | + } |
|
2218 | 2764 | update_db::download('http://data.flightairmap.fr/data/models/space/space_models.md5sum',$tmp_dir.'space_models.md5sum'); |
2219 | 2765 | if (file_exists($tmp_dir.'space_models.md5sum')) { |
2220 | - if ($globalDebug) echo "Check files...\n"; |
|
2766 | + if ($globalDebug) { |
|
2767 | + echo "Check files...\n"; |
|
2768 | + } |
|
2221 | 2769 | $newmodelsdb = array(); |
2222 | 2770 | if (($handle = fopen($tmp_dir.'space_models.md5sum','r')) !== FALSE) { |
2223 | 2771 | while (($row = fgetcsv($handle,1000," ")) !== FALSE) { |
@@ -2236,25 +2784,35 @@ discard block |
||
2236 | 2784 | } |
2237 | 2785 | $diff = array_diff($newmodelsdb,$modelsdb); |
2238 | 2786 | foreach ($diff as $key => $value) { |
2239 | - if ($globalDebug) echo 'Downloading space model '.$key.' ...'."\n"; |
|
2787 | + if ($globalDebug) { |
|
2788 | + echo 'Downloading space model '.$key.' ...'."\n"; |
|
2789 | + } |
|
2240 | 2790 | update_db::download('http://data.flightairmap.fr/data/models/space/'.$key,dirname(__FILE__).'/../models/space/'.$key); |
2241 | 2791 | |
2242 | 2792 | } |
2243 | 2793 | update_db::download('http://data.flightairmap.fr/data/models/space/space_models.md5sum',dirname(__FILE__).'/../models/space/space_models.md5sum'); |
2244 | - } else $error = "File ".$tmp_dir.'models.md5sum'." doesn't exist. Download failed."; |
|
2794 | + } else { |
|
2795 | + $error = "File ".$tmp_dir.'models.md5sum'." doesn't exist. Download failed."; |
|
2796 | + } |
|
2245 | 2797 | if ($error != '') { |
2246 | 2798 | return $error; |
2247 | - } elseif ($globalDebug) echo "Done\n"; |
|
2799 | + } elseif ($globalDebug) { |
|
2800 | + echo "Done\n"; |
|
2801 | + } |
|
2248 | 2802 | return ''; |
2249 | 2803 | } |
2250 | 2804 | |
2251 | 2805 | public static function update_vehicules_models() { |
2252 | 2806 | global $tmp_dir, $globalDebug; |
2253 | 2807 | $error = ''; |
2254 | - if ($globalDebug) echo "Vehicules models from FlightAirMap website : Download..."; |
|
2808 | + if ($globalDebug) { |
|
2809 | + echo "Vehicules models from FlightAirMap website : Download..."; |
|
2810 | + } |
|
2255 | 2811 | update_db::download('http://data.flightairmap.fr/data/models/vehicules/vehicules_models.md5sum',$tmp_dir.'vehicules_models.md5sum'); |
2256 | 2812 | if (file_exists($tmp_dir.'vehicules_models.md5sum')) { |
2257 | - if ($globalDebug) echo "Check files...\n"; |
|
2813 | + if ($globalDebug) { |
|
2814 | + echo "Check files...\n"; |
|
2815 | + } |
|
2258 | 2816 | $newmodelsdb = array(); |
2259 | 2817 | if (($handle = fopen($tmp_dir.'vehicules_models.md5sum','r')) !== FALSE) { |
2260 | 2818 | while (($row = fgetcsv($handle,1000," ")) !== FALSE) { |
@@ -2273,15 +2831,21 @@ discard block |
||
2273 | 2831 | } |
2274 | 2832 | $diff = array_diff($newmodelsdb,$modelsdb); |
2275 | 2833 | foreach ($diff as $key => $value) { |
2276 | - if ($globalDebug) echo 'Downloading vehicules model '.$key.' ...'."\n"; |
|
2834 | + if ($globalDebug) { |
|
2835 | + echo 'Downloading vehicules model '.$key.' ...'."\n"; |
|
2836 | + } |
|
2277 | 2837 | update_db::download('http://data.flightairmap.fr/data/models/vehicules/'.$key,dirname(__FILE__).'/../models/vehicules/'.$key); |
2278 | 2838 | |
2279 | 2839 | } |
2280 | 2840 | update_db::download('http://data.flightairmap.fr/data/models/vehicules/vehicules_models.md5sum',dirname(__FILE__).'/../models/vehicules/vehicules_models.md5sum'); |
2281 | - } else $error = "File ".$tmp_dir.'models.md5sum'." doesn't exist. Download failed."; |
|
2841 | + } else { |
|
2842 | + $error = "File ".$tmp_dir.'models.md5sum'." doesn't exist. Download failed."; |
|
2843 | + } |
|
2282 | 2844 | if ($error != '') { |
2283 | 2845 | return $error; |
2284 | - } elseif ($globalDebug) echo "Done\n"; |
|
2846 | + } elseif ($globalDebug) { |
|
2847 | + echo "Done\n"; |
|
2848 | + } |
|
2285 | 2849 | return ''; |
2286 | 2850 | } |
2287 | 2851 | |
@@ -2324,7 +2888,9 @@ discard block |
||
2324 | 2888 | } |
2325 | 2889 | |
2326 | 2890 | $error = ''; |
2327 | - if ($globalDebug) echo "Notam : Download..."; |
|
2891 | + if ($globalDebug) { |
|
2892 | + echo "Notam : Download..."; |
|
2893 | + } |
|
2328 | 2894 | update_db::download($globalNOTAMSource,$tmp_dir.'notam.rss'); |
2329 | 2895 | if (file_exists($tmp_dir.'notam.rss')) { |
2330 | 2896 | $notams = json_decode(json_encode(simplexml_load_file($tmp_dir.'notam.rss')),true); |
@@ -2339,14 +2905,30 @@ discard block |
||
2339 | 2905 | $data['fir'] = $q[0]; |
2340 | 2906 | $data['code'] = $q[1]; |
2341 | 2907 | $ifrvfr = $q[2]; |
2342 | - if ($ifrvfr == 'IV') $data['rules'] = 'IFR/VFR'; |
|
2343 | - if ($ifrvfr == 'I') $data['rules'] = 'IFR'; |
|
2344 | - if ($ifrvfr == 'V') $data['rules'] = 'VFR'; |
|
2345 | - if ($q[4] == 'A') $data['scope'] = 'Airport warning'; |
|
2346 | - if ($q[4] == 'E') $data['scope'] = 'Enroute warning'; |
|
2347 | - if ($q[4] == 'W') $data['scope'] = 'Navigation warning'; |
|
2348 | - if ($q[4] == 'AE') $data['scope'] = 'Airport/Enroute warning'; |
|
2349 | - if ($q[4] == 'AW') $data['scope'] = 'Airport/Navigation warning'; |
|
2908 | + if ($ifrvfr == 'IV') { |
|
2909 | + $data['rules'] = 'IFR/VFR'; |
|
2910 | + } |
|
2911 | + if ($ifrvfr == 'I') { |
|
2912 | + $data['rules'] = 'IFR'; |
|
2913 | + } |
|
2914 | + if ($ifrvfr == 'V') { |
|
2915 | + $data['rules'] = 'VFR'; |
|
2916 | + } |
|
2917 | + if ($q[4] == 'A') { |
|
2918 | + $data['scope'] = 'Airport warning'; |
|
2919 | + } |
|
2920 | + if ($q[4] == 'E') { |
|
2921 | + $data['scope'] = 'Enroute warning'; |
|
2922 | + } |
|
2923 | + if ($q[4] == 'W') { |
|
2924 | + $data['scope'] = 'Navigation warning'; |
|
2925 | + } |
|
2926 | + if ($q[4] == 'AE') { |
|
2927 | + $data['scope'] = 'Airport/Enroute warning'; |
|
2928 | + } |
|
2929 | + if ($q[4] == 'AW') { |
|
2930 | + $data['scope'] = 'Airport/Navigation warning'; |
|
2931 | + } |
|
2350 | 2932 | //$data['scope'] = $q[4]; |
2351 | 2933 | $data['lower_limit'] = $q[5]; |
2352 | 2934 | $data['upper_limit'] = $q[6]; |
@@ -2354,8 +2936,12 @@ discard block |
||
2354 | 2936 | sscanf($latlonrad,'%4c%c%5c%c%3d',$las,$lac,$lns,$lnc,$radius); |
2355 | 2937 | $latitude = $Common->convertDec($las,'latitude'); |
2356 | 2938 | $longitude = $Common->convertDec($lns,'longitude'); |
2357 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
2358 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
2939 | + if ($lac == 'S') { |
|
2940 | + $latitude = '-'.$latitude; |
|
2941 | + } |
|
2942 | + if ($lnc == 'W') { |
|
2943 | + $longitude = '-'.$longitude; |
|
2944 | + } |
|
2359 | 2945 | $data['center_latitude'] = $latitude; |
2360 | 2946 | $data['center_longitude'] = $longitude; |
2361 | 2947 | $data['radius'] = intval($radius); |
@@ -2385,10 +2971,14 @@ discard block |
||
2385 | 2971 | $NOTAM->addNOTAM($data['ref'],$data['title'],'',$data['fir'],$data['code'],'',$data['scope'],$data['lower_limit'],$data['upper_limit'],$data['center_latitude'],$data['center_longitude'],$data['radius'],$data['date_begin'],$data['date_end'],$data['permanent'],$data['text'],$data['full_notam']); |
2386 | 2972 | unset($data); |
2387 | 2973 | } |
2388 | - } else $error = "File ".$tmp_dir.'notam.rss'." doesn't exist. Download failed."; |
|
2974 | + } else { |
|
2975 | + $error = "File ".$tmp_dir.'notam.rss'." doesn't exist. Download failed."; |
|
2976 | + } |
|
2389 | 2977 | if ($error != '') { |
2390 | 2978 | return $error; |
2391 | - } elseif ($globalDebug) echo "Done\n"; |
|
2979 | + } elseif ($globalDebug) { |
|
2980 | + echo "Done\n"; |
|
2981 | + } |
|
2392 | 2982 | return ''; |
2393 | 2983 | } |
2394 | 2984 | |
@@ -2413,7 +3003,9 @@ discard block |
||
2413 | 3003 | $airspace_lst = $Common->getData('https://raw.githubusercontent.com/XCSoar/xcsoar-data-repository/master/data/airspace.json'); |
2414 | 3004 | $airspace_json = json_decode($airspace_lst,true); |
2415 | 3005 | foreach ($airspace_json['records'] as $airspace) { |
2416 | - if ($globalDebug) echo $airspace['name']."...\n"; |
|
3006 | + if ($globalDebug) { |
|
3007 | + echo $airspace['name']."...\n"; |
|
3008 | + } |
|
2417 | 3009 | update_db::download($airspace['uri'],$tmp_dir.$airspace['name']); |
2418 | 3010 | if (file_exists($tmp_dir.$airspace['name'])) { |
2419 | 3011 | file_put_contents($tmp_dir.$airspace['name'], utf8_encode(file_get_contents($tmp_dir.$airspace['name']))); |
@@ -2457,8 +3049,11 @@ discard block |
||
2457 | 3049 | return "error : ".$e->getMessage(); |
2458 | 3050 | } |
2459 | 3051 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
2460 | - if ($row['nb'] > 0) return false; |
|
2461 | - else return true; |
|
3052 | + if ($row['nb'] > 0) { |
|
3053 | + return false; |
|
3054 | + } else { |
|
3055 | + return true; |
|
3056 | + } |
|
2462 | 3057 | } |
2463 | 3058 | |
2464 | 3059 | public static function insert_last_update() { |
@@ -2483,8 +3078,11 @@ discard block |
||
2483 | 3078 | return "error : ".$e->getMessage(); |
2484 | 3079 | } |
2485 | 3080 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
2486 | - if ($row['nb'] > 0) return true; |
|
2487 | - else return false; |
|
3081 | + if ($row['nb'] > 0) { |
|
3082 | + return true; |
|
3083 | + } else { |
|
3084 | + return false; |
|
3085 | + } |
|
2488 | 3086 | } |
2489 | 3087 | |
2490 | 3088 | public static function check_geoid_version($version) { |
@@ -2497,8 +3095,11 @@ discard block |
||
2497 | 3095 | return "error : ".$e->getMessage(); |
2498 | 3096 | } |
2499 | 3097 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
2500 | - if ($row['nb'] > 0) return true; |
|
2501 | - else return false; |
|
3098 | + if ($row['nb'] > 0) { |
|
3099 | + return true; |
|
3100 | + } else { |
|
3101 | + return false; |
|
3102 | + } |
|
2502 | 3103 | } |
2503 | 3104 | |
2504 | 3105 | public static function check_marine_identity_version($version) { |
@@ -2511,8 +3112,11 @@ discard block |
||
2511 | 3112 | return "error : ".$e->getMessage(); |
2512 | 3113 | } |
2513 | 3114 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
2514 | - if ($row['nb'] > 0) return true; |
|
2515 | - else return false; |
|
3115 | + if ($row['nb'] > 0) { |
|
3116 | + return true; |
|
3117 | + } else { |
|
3118 | + return false; |
|
3119 | + } |
|
2516 | 3120 | } |
2517 | 3121 | |
2518 | 3122 | |
@@ -2567,8 +3171,11 @@ discard block |
||
2567 | 3171 | return "error : ".$e->getMessage(); |
2568 | 3172 | } |
2569 | 3173 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
2570 | - if ($row['nb'] > 0) return false; |
|
2571 | - else return true; |
|
3174 | + if ($row['nb'] > 0) { |
|
3175 | + return false; |
|
3176 | + } else { |
|
3177 | + return true; |
|
3178 | + } |
|
2572 | 3179 | } |
2573 | 3180 | |
2574 | 3181 | public static function insert_last_notam_update() { |
@@ -2598,8 +3205,11 @@ discard block |
||
2598 | 3205 | return "error : ".$e->getMessage(); |
2599 | 3206 | } |
2600 | 3207 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
2601 | - if ($row['nb'] > 0) return false; |
|
2602 | - else return true; |
|
3208 | + if ($row['nb'] > 0) { |
|
3209 | + return false; |
|
3210 | + } else { |
|
3211 | + return true; |
|
3212 | + } |
|
2603 | 3213 | } |
2604 | 3214 | |
2605 | 3215 | public static function insert_last_airspace_update() { |
@@ -2629,8 +3239,11 @@ discard block |
||
2629 | 3239 | return "error : ".$e->getMessage(); |
2630 | 3240 | } |
2631 | 3241 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
2632 | - if ($row['nb'] > 0) return false; |
|
2633 | - else return true; |
|
3242 | + if ($row['nb'] > 0) { |
|
3243 | + return false; |
|
3244 | + } else { |
|
3245 | + return true; |
|
3246 | + } |
|
2634 | 3247 | } |
2635 | 3248 | |
2636 | 3249 | public static function insert_last_geoid_update() { |
@@ -2660,8 +3273,11 @@ discard block |
||
2660 | 3273 | return "error : ".$e->getMessage(); |
2661 | 3274 | } |
2662 | 3275 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
2663 | - if ($row['nb'] > 0) return false; |
|
2664 | - else return true; |
|
3276 | + if ($row['nb'] > 0) { |
|
3277 | + return false; |
|
3278 | + } else { |
|
3279 | + return true; |
|
3280 | + } |
|
2665 | 3281 | } |
2666 | 3282 | |
2667 | 3283 | public static function insert_last_owner_update() { |
@@ -2690,8 +3306,11 @@ discard block |
||
2690 | 3306 | return "error : ".$e->getMessage(); |
2691 | 3307 | } |
2692 | 3308 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
2693 | - if ($row['nb'] > 0) return false; |
|
2694 | - else return true; |
|
3309 | + if ($row['nb'] > 0) { |
|
3310 | + return false; |
|
3311 | + } else { |
|
3312 | + return true; |
|
3313 | + } |
|
2695 | 3314 | } |
2696 | 3315 | |
2697 | 3316 | public static function insert_last_schedules_update() { |
@@ -2720,8 +3339,11 @@ discard block |
||
2720 | 3339 | return "error : ".$e->getMessage(); |
2721 | 3340 | } |
2722 | 3341 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
2723 | - if ($row['nb'] > 0) return false; |
|
2724 | - else return true; |
|
3342 | + if ($row['nb'] > 0) { |
|
3343 | + return false; |
|
3344 | + } else { |
|
3345 | + return true; |
|
3346 | + } |
|
2725 | 3347 | } |
2726 | 3348 | |
2727 | 3349 | public static function insert_last_tle_update() { |
@@ -2750,8 +3372,11 @@ discard block |
||
2750 | 3372 | return "error : ".$e->getMessage(); |
2751 | 3373 | } |
2752 | 3374 | $row = $sth->fetch(PDO::FETCH_ASSOC); |
2753 | - if ($row['nb'] > 0) return false; |
|
2754 | - else return true; |
|
3375 | + if ($row['nb'] > 0) { |
|
3376 | + return false; |
|
3377 | + } else { |
|
3378 | + return true; |
|
3379 | + } |
|
2755 | 3380 | } |
2756 | 3381 | |
2757 | 3382 | public static function insert_last_marine_identity_update() { |
@@ -23,14 +23,19 @@ discard block |
||
23 | 23 | */ |
24 | 24 | public function ident2icao($ident) { |
25 | 25 | if (substr($ident,0,2) == 'AF') { |
26 | - if (filter_var(substr($ident,2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) $icao = $ident; |
|
27 | - else $icao = 'AFR'.ltrim(substr($ident,2),'0'); |
|
26 | + if (filter_var(substr($ident,2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) { |
|
27 | + $icao = $ident; |
|
28 | + } else { |
|
29 | + $icao = 'AFR'.ltrim(substr($ident,2),'0'); |
|
30 | + } |
|
28 | 31 | } else { |
29 | 32 | $Spotter = new Spotter($this->db); |
30 | 33 | $identicao = $Spotter->getAllAirlineInfo(substr($ident,0,2)); |
31 | 34 | if (isset($identicao[0])) { |
32 | 35 | $icao = $identicao[0]['icao'].ltrim(substr($ident,2),'0'); |
33 | - } else $icao = $ident; |
|
36 | + } else { |
|
37 | + $icao = $ident; |
|
38 | + } |
|
34 | 39 | } |
35 | 40 | return $icao; |
36 | 41 | } |
@@ -103,14 +108,24 @@ discard block |
||
103 | 108 | $message = ''; |
104 | 109 | $result = array(); |
105 | 110 | $n = sscanf($data,'(null) %*d %*02d/%*02d/%*04d %*02d:%*02d:%*02d %*d %*[0-9-] %*[A-Z0-9] %7s %*c %2[0-9a-zA-Z_] %d %4[0-9A-Z] %6[0-9A-Z] %[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
106 | - if ($n == 0) $n = sscanf($data,'AC%*c %7s %*c %2[0-9a-zA-Z_] %d %4[0-9A-Z] %6[0-9A-Z] %[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
107 | - if ($n == 0) $n = sscanf($data,'%*04d-%*02d-%*02d,%*02d:%*02d:%*02d,%*7s,%*c,%6[0-9A-Z-],%*c,%2[0-9a-zA-Z_],%d,%4[0-9A-Z],%6[0-9A-Z],%[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
108 | - if ($n == 0) $n = sscanf($data,'%*04d-%*02d-%*02d,%*02d:%*02d:%*02d,%*7s,%*c,%5[0-9A-Z],%*c,%2[0-9a-zA-Z_],%d,%4[0-9A-Z],%6[0-9A-Z],%[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
111 | + if ($n == 0) { |
|
112 | + $n = sscanf($data,'AC%*c %7s %*c %2[0-9a-zA-Z_] %d %4[0-9A-Z] %6[0-9A-Z] %[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
113 | + } |
|
114 | + if ($n == 0) { |
|
115 | + $n = sscanf($data,'%*04d-%*02d-%*02d,%*02d:%*02d:%*02d,%*7s,%*c,%6[0-9A-Z-],%*c,%2[0-9a-zA-Z_],%d,%4[0-9A-Z],%6[0-9A-Z],%[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
116 | + } |
|
117 | + if ($n == 0) { |
|
118 | + $n = sscanf($data,'%*04d-%*02d-%*02d,%*02d:%*02d:%*02d,%*7s,%*c,%5[0-9A-Z],%*c,%2[0-9a-zA-Z_],%d,%4[0-9A-Z],%6[0-9A-Z],%[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
119 | + } |
|
109 | 120 | if ($n != 0) { |
110 | 121 | $registration = str_replace('.','',$registration); |
111 | 122 | $result = array('registration' => $registration, 'ident' => $ident,'label' => $label, 'block_id' => $block_id,'msg_no' => $msg_no,'message' => $message); |
112 | - if ($globalDebug) echo "Reg. : ".$registration." - Ident : ".$ident." - Label : ".$label." - Message : ".$message."\n"; |
|
113 | - } else $message = $data; |
|
123 | + if ($globalDebug) { |
|
124 | + echo "Reg. : ".$registration." - Ident : ".$ident." - Label : ".$label." - Message : ".$message."\n"; |
|
125 | + } |
|
126 | + } else { |
|
127 | + $message = $data; |
|
128 | + } |
|
114 | 129 | $decode = array(); |
115 | 130 | $found = false; |
116 | 131 | // if ($registration != '' && $ident != '' && $registration != '!') { |
@@ -130,12 +145,21 @@ discard block |
||
130 | 145 | if ($n > 5 && ($lac == 'N' || $lac == 'S') && ($lnc == 'E' || $lnc == 'W')) { |
131 | 146 | $latitude = $la / 10000.0; |
132 | 147 | $longitude = $ln / 10000.0; |
133 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
134 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
148 | + if ($lac == 'S') { |
|
149 | + $latitude = '-'.$latitude; |
|
150 | + } |
|
151 | + if ($lnc == 'W') { |
|
152 | + $longitude = '-'.$longitude; |
|
153 | + } |
|
135 | 154 | // Temp not always available |
136 | - if ($globalDebug) echo 'latitude : '.$latitude.' - longitude : '.$longitude.' - airport depart : '.$dair.' - airport arrival : '.$darr.' - température : '.$temp."°C\n"; |
|
137 | - if ($temp == '') $decode = array('Latitude' => $latitude, 'Longitude' => $longitude, 'Departure airport' => $dair, 'Arrival airport' => $darr,'Altitude' => $alt); |
|
138 | - else $decode = array('Latitude' => $latitude, 'Longitude' => $longitude, 'Departure airport' => $dair, 'Arrival airport' => $darr, 'Altitude' => 'FL'.$alt,'Temperature' => $temp.'°C'); |
|
155 | + if ($globalDebug) { |
|
156 | + echo 'latitude : '.$latitude.' - longitude : '.$longitude.' - airport depart : '.$dair.' - airport arrival : '.$darr.' - température : '.$temp."°C\n"; |
|
157 | + } |
|
158 | + if ($temp == '') { |
|
159 | + $decode = array('Latitude' => $latitude, 'Longitude' => $longitude, 'Departure airport' => $dair, 'Arrival airport' => $darr,'Altitude' => $alt); |
|
160 | + } else { |
|
161 | + $decode = array('Latitude' => $latitude, 'Longitude' => $longitude, 'Departure airport' => $dair, 'Arrival airport' => $darr, 'Altitude' => 'FL'.$alt,'Temperature' => $temp.'°C'); |
|
162 | + } |
|
139 | 163 | |
140 | 164 | //$icao = $Translation->checkTranslation($ident); |
141 | 165 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
@@ -149,25 +173,35 @@ discard block |
||
149 | 173 | $ahour = ''; |
150 | 174 | $n = sscanf($message, "ARR01 %4[A-Z]%4d %4[A-Z]%4d", $dair, $dhour, $darr,$ahour); |
151 | 175 | if ($n == 4 && strlen($darr) == 4) { |
152 | - if ($dhour != '') $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
153 | - if ($ahour != '') $ahour = substr(sprintf('%04d',$ahour),0,2).':'.substr(sprintf('%04d',$ahour),2); |
|
154 | - if ($globalDebug) echo 'departure airport : '.$dair.' - arrival airport : '. $darr.' - departure hour : '. $dhour.' - arrival hour : '.$ahour."\n"; |
|
176 | + if ($dhour != '') { |
|
177 | + $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
178 | + } |
|
179 | + if ($ahour != '') { |
|
180 | + $ahour = substr(sprintf('%04d',$ahour),0,2).':'.substr(sprintf('%04d',$ahour),2); |
|
181 | + } |
|
182 | + if ($globalDebug) { |
|
183 | + echo 'departure airport : '.$dair.' - arrival airport : '. $darr.' - departure hour : '. $dhour.' - arrival hour : '.$ahour."\n"; |
|
184 | + } |
|
155 | 185 | //$icao = ACARS->ident2icao($ident); |
156 | 186 | //$icao = $Translation->checkTranslation($ident); |
157 | 187 | //$Schedule->addSchedule($icao,$dair,$dhour,$darr,$ahour,'ACARS'); |
158 | 188 | $decode = array('Departure airport' => $dair, 'Departure hour' => $dhour, 'Arrival airport' => $darr, 'Arrival hour' => $ahour); |
159 | 189 | $found = true; |
160 | - } |
|
161 | - elseif ($n == 2 || $n == 4) { |
|
162 | - if ($dhour != '') $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
163 | - if ($globalDebug) echo 'airport arrival : '.$dair.' - arrival hour : '.$dhour."\n"; |
|
190 | + } elseif ($n == 2 || $n == 4) { |
|
191 | + if ($dhour != '') { |
|
192 | + $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
193 | + } |
|
194 | + if ($globalDebug) { |
|
195 | + echo 'airport arrival : '.$dair.' - arrival hour : '.$dhour."\n"; |
|
196 | + } |
|
164 | 197 | //$icao = ACARS->ident2icao($ident); |
165 | 198 | //$icao = $Translation->checkTranslation($ident); |
166 | 199 | $decode = array('Arrival airport' => $dair, 'Arrival hour' => $dhour); |
167 | 200 | $found = true; |
168 | - } |
|
169 | - elseif ($n == 1) { |
|
170 | - if ($globalDebug) echo 'airport arrival : '.$darr."\n"; |
|
201 | + } elseif ($n == 1) { |
|
202 | + if ($globalDebug) { |
|
203 | + echo 'airport arrival : '.$darr."\n"; |
|
204 | + } |
|
171 | 205 | //$icao = ACARS->ident2icao($ident); |
172 | 206 | //$icao = $Translation->checkTranslation($ident); |
173 | 207 | $decode = array('Arrival airport' => $darr); |
@@ -185,7 +219,9 @@ discard block |
||
185 | 219 | $darr = ''; |
186 | 220 | $n = sscanf($message, "%4c,%4c,%*7s,%*d", $dair, $darr); |
187 | 221 | if ($n == 4) { |
188 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
222 | + if ($globalDebug) { |
|
223 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
224 | + } |
|
189 | 225 | //$icao = ACARS->ident2icao($ident); |
190 | 226 | //$icao = $Translation->checkTranslation($ident); |
191 | 227 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
@@ -219,14 +255,23 @@ discard block |
||
219 | 255 | $apiste = ''; |
220 | 256 | $n = sscanf(str_replace(array("\r\n", "\n", "\r"),'',$message), "%*[0-9A-Z]/%*3d/%4s/%*cSCH/%6[0-9A-Z ]/%4c/%4c/%5s/%4d%*3c/%4d/%4c/%[0-9A-Z ]/", $airicao,$aident,$dair, $darr, $ddate, $dhour,$ahour, $aair, $apiste); |
221 | 257 | if ($n > 8) { |
222 | - if ($globalDebug) echo 'airicao : '. $airicao.' - ident : '.$aident.' - departure airport : '.$dair.' - arrival airport : '. $darr.' - date depart : '.$ddate.' - departure hour : '. $dhour.' - arrival hour : '.$ahour.' - arrival airport : '.$aair.' - arrival piste : '.$apiste."\n"; |
|
223 | - if ($dhour != '') $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
224 | - if ($ahour != '') $ahour = substr(sprintf('%04d',$ahour),0,2).':'.substr(sprintf('%04d',$ahour),2); |
|
258 | + if ($globalDebug) { |
|
259 | + echo 'airicao : '. $airicao.' - ident : '.$aident.' - departure airport : '.$dair.' - arrival airport : '. $darr.' - date depart : '.$ddate.' - departure hour : '. $dhour.' - arrival hour : '.$ahour.' - arrival airport : '.$aair.' - arrival piste : '.$apiste."\n"; |
|
260 | + } |
|
261 | + if ($dhour != '') { |
|
262 | + $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
263 | + } |
|
264 | + if ($ahour != '') { |
|
265 | + $ahour = substr(sprintf('%04d',$ahour),0,2).':'.substr(sprintf('%04d',$ahour),2); |
|
266 | + } |
|
225 | 267 | $icao = trim($aident); |
226 | 268 | |
227 | 269 | //$decode = 'Departure airport : '.$dair.' ('.$ddate.' at '.$dhour.') - Arrival Airport : '.$aair.' (at '.$ahour.') way '.$apiste; |
228 | - if ($ahour == '') $decode = array('Departure airport' => $dair, 'Departure date' => $ddate, 'Departure hour' => $dhour, 'Arrival airport' => $darr); |
|
229 | - else $decode = array('Departure airport' => $dair, 'Departure date' => $ddate, 'Departure hour' => $dhour, 'Arrival airport' => $darr, 'Arrival hour' => $ahour, 'Arrival way' => $apiste); |
|
270 | + if ($ahour == '') { |
|
271 | + $decode = array('Departure airport' => $dair, 'Departure date' => $ddate, 'Departure hour' => $dhour, 'Arrival airport' => $darr); |
|
272 | + } else { |
|
273 | + $decode = array('Departure airport' => $dair, 'Departure date' => $ddate, 'Departure hour' => $dhour, 'Arrival airport' => $darr, 'Arrival hour' => $ahour, 'Arrival way' => $apiste); |
|
274 | + } |
|
230 | 275 | //$Schedule->addSchedule($icao,$dair,$dhour,$darr,$ahour,'ACARS'); |
231 | 276 | $decode['icao'] = $icao; |
232 | 277 | $found = true; |
@@ -248,9 +293,15 @@ discard block |
||
248 | 293 | $lns = $lns.'.'.$lns; |
249 | 294 | $latitude = $las / 1000.0; |
250 | 295 | $longitude = $lns / 1000.0; |
251 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
252 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
253 | - if ($globalDebug) echo 'latitude : '.$latitude.' - longitude : '.$longitude."\n"; |
|
296 | + if ($lac == 'S') { |
|
297 | + $latitude = '-'.$latitude; |
|
298 | + } |
|
299 | + if ($lnc == 'W') { |
|
300 | + $longitude = '-'.$longitude; |
|
301 | + } |
|
302 | + if ($globalDebug) { |
|
303 | + echo 'latitude : '.$latitude.' - longitude : '.$longitude."\n"; |
|
304 | + } |
|
254 | 305 | $decode = array('Latitude' => $latitude, 'Longitude' => $longitude); |
255 | 306 | $found = true; |
256 | 307 | } |
@@ -268,7 +319,9 @@ discard block |
||
268 | 319 | $darr = ''; |
269 | 320 | $n = sscanf($message, "%*[0-9A-Z ]/%*s %4c/%4c .", $dair, $darr); |
270 | 321 | if ($n == 4) { |
271 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
322 | + if ($globalDebug) { |
|
323 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
324 | + } |
|
272 | 325 | //$icao = $Translation->checkTranslation($ident); |
273 | 326 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
274 | 327 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -281,7 +334,9 @@ discard block |
||
281 | 334 | $darr = ''; |
282 | 335 | $n = sscanf($message, "%*[0-9],%4c,%4c,", $dair, $darr); |
283 | 336 | if ($n == 4) { |
284 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
337 | + if ($globalDebug) { |
|
338 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
339 | + } |
|
285 | 340 | //$icao = $Translation->checkTranslation($ident); |
286 | 341 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
287 | 342 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -294,7 +349,9 @@ discard block |
||
294 | 349 | $darr = ''; |
295 | 350 | $n = sscanf($message, "002AF %4c %4c ", $dair, $darr); |
296 | 351 | if ($n == 2) { |
297 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
352 | + if ($globalDebug) { |
|
353 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
354 | + } |
|
298 | 355 | //$icao = $Translation->checkTranslation($ident); |
299 | 356 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
300 | 357 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
@@ -308,7 +365,9 @@ discard block |
||
308 | 365 | $darr = ''; |
309 | 366 | $n = sscanf($message, "#DFBA%*02d/%*[A-Z-],%*[0-9A-Z],%*d,%4c,%4c", $dair, $darr); |
310 | 367 | if ($n == 6) { |
311 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
368 | + if ($globalDebug) { |
|
369 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
370 | + } |
|
312 | 371 | //$icao = $Translation->checkTranslation($ident); |
313 | 372 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
314 | 373 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -321,7 +380,9 @@ discard block |
||
321 | 380 | $darr = ''; |
322 | 381 | $n = sscanf($message, "#DFBA%*02d/%*[0-9A-Z,]/%*[A-Z-],%*[0-9A-Z],%*d,%4c,%4c", $dair, $darr); |
323 | 382 | if ($n == 7) { |
324 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
383 | + if ($globalDebug) { |
|
384 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
385 | + } |
|
325 | 386 | //$icao = $Translation->checkTranslation($ident); |
326 | 387 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
327 | 388 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -349,8 +410,12 @@ discard block |
||
349 | 410 | $decode['icao'] = $icao; |
350 | 411 | $latitude = $las / 100.0; |
351 | 412 | $longitude = $lns / 100.0; |
352 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
353 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
413 | + if ($lac == 'S') { |
|
414 | + $latitude = '-'.$latitude; |
|
415 | + } |
|
416 | + if ($lnc == 'W') { |
|
417 | + $longitude = '-'.$longitude; |
|
418 | + } |
|
354 | 419 | |
355 | 420 | $decode = array('Latitude' => $latitude,'Longitude' => $longitude,'Altitude' => 'FL'.$alt,'Fuel' => $fuel,'speed' => $speed); |
356 | 421 | $found = true; |
@@ -368,8 +433,12 @@ discard block |
||
368 | 433 | if ($n == 4) { |
369 | 434 | $latitude = $las; |
370 | 435 | $longitude = $lns; |
371 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
372 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
436 | + if ($lac == 'S') { |
|
437 | + $latitude = '-'.$latitude; |
|
438 | + } |
|
439 | + if ($lnc == 'W') { |
|
440 | + $longitude = '-'.$longitude; |
|
441 | + } |
|
373 | 442 | |
374 | 443 | $decode = array('Latitude' => $latitude,'Longitude' => $longitude); |
375 | 444 | $found = true; |
@@ -385,7 +454,9 @@ discard block |
||
385 | 454 | $darr = ''; |
386 | 455 | $n = sscanf($message, "%*[0-9A-Z] NLINFO %*d/%*d %4c/%4c .", $dair, $darr); |
387 | 456 | if ($n == 5) { |
388 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
457 | + if ($globalDebug) { |
|
458 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
459 | + } |
|
389 | 460 | //$icao = $Translation->checkTranslation($ident); |
390 | 461 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
391 | 462 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -406,7 +477,9 @@ discard block |
||
406 | 477 | $aident = ''; |
407 | 478 | $n = sscanf(str_replace(array("\r\n", "\n", "\r"),'',$message), "%*[0-9A-Z],,%*[0-9A-Z],%*[0-9A-Z],%4s,%4s,.%*6s,%*4[A-Z],%[0-9A-Z],", $dair, $darr, $aident); |
408 | 479 | if ($n == 8) { |
409 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
480 | + if ($globalDebug) { |
|
481 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
482 | + } |
|
410 | 483 | $icao = trim($aident); |
411 | 484 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
412 | 485 | $decode['icao'] = $icao; |
@@ -423,7 +496,9 @@ discard block |
||
423 | 496 | $darr = ''; |
424 | 497 | $n = sscanf($message, "%*d/%*d %4s/%4s .%*6s", $dair, $darr); |
425 | 498 | if ($n == 5) { |
426 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
499 | + if ($globalDebug) { |
|
500 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
501 | + } |
|
427 | 502 | //$icao = $Translation->checkTranslation($ident); |
428 | 503 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
429 | 504 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -438,7 +513,9 @@ discard block |
||
438 | 513 | $darr = ''; |
439 | 514 | $n = sscanf($message,'%4[A-Z]%4[A-Z]%*4d',$dair,$darr); |
440 | 515 | if ($n == 3) { |
441 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
516 | + if ($globalDebug) { |
|
517 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
518 | + } |
|
442 | 519 | //$icao = $Translation->checkTranslation($ident); |
443 | 520 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
444 | 521 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -453,7 +530,9 @@ discard block |
||
453 | 530 | $darr = ''; |
454 | 531 | $n = sscanf($message,'3J01 DSPTCH %*d/%*d %4s/%4s .%*6s',$dair,$darr); |
455 | 532 | if ($n == 3) { |
456 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
533 | + if ($globalDebug) { |
|
534 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
535 | + } |
|
457 | 536 | //$icao = $Translation->checkTranslation($ident); |
458 | 537 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
459 | 538 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -463,7 +542,9 @@ discard block |
||
463 | 542 | if (!$found) { |
464 | 543 | $n = sscanf($message,'MET01%4c',$airport); |
465 | 544 | if ($n == 1) { |
466 | - if ($globalDebug) echo 'airport name : '.$airport; |
|
545 | + if ($globalDebug) { |
|
546 | + echo 'airport name : '.$airport; |
|
547 | + } |
|
467 | 548 | $decode = array('Airport/Waypoint name' => $airport); |
468 | 549 | $found = true; |
469 | 550 | } |
@@ -471,184 +552,126 @@ discard block |
||
471 | 552 | if ($label == 'H1') { |
472 | 553 | if (preg_match('/^#CFBFLR/',$message) || preg_match('/^#CFBWRN/',$message)) { |
473 | 554 | $decode = array_merge(array('Message nature' => 'Equipment failure'),$decode); |
474 | - } |
|
475 | - elseif (preg_match('/^#DFB\*TKO/',$message) || preg_match('/^#DFBTKO/',$message)) { |
|
555 | + } elseif (preg_match('/^#DFB\*TKO/',$message) || preg_match('/^#DFBTKO/',$message)) { |
|
476 | 556 | $decode = array_merge(array('Message nature' => 'Take off performance data'),$decode); |
477 | - } |
|
478 | - elseif (preg_match('/^#DFB\*CRZ/',$message) || preg_match('/^#DFBCRZ/',$message)) { |
|
557 | + } elseif (preg_match('/^#DFB\*CRZ/',$message) || preg_match('/^#DFBCRZ/',$message)) { |
|
479 | 558 | $decode = array_merge(array('Message nature' => 'Cruise performance data'),$decode); |
480 | - } |
|
481 | - elseif (preg_match('/^#DFB\*WOB/',$message) || preg_match('/^#DFBWOB/',$message)) { |
|
559 | + } elseif (preg_match('/^#DFB\*WOB/',$message) || preg_match('/^#DFBWOB/',$message)) { |
|
482 | 560 | $decode = array_merge(array('Message nature' => 'Weather observation'),$decode); |
483 | - } |
|
484 | - elseif (preg_match(':^#DFB/PIREP:',$message)) { |
|
561 | + } elseif (preg_match(':^#DFB/PIREP:',$message)) { |
|
485 | 562 | $decode = array_merge(array('Message nature' => 'Pilot Report'),$decode); |
486 | - } |
|
487 | - elseif (preg_match('/^#DFBEDA/',$message) || preg_match('/^#DFBENG/',$message)) { |
|
563 | + } elseif (preg_match('/^#DFBEDA/',$message) || preg_match('/^#DFBENG/',$message)) { |
|
488 | 564 | $decode = array_merge(array('Message nature' => 'Engine Data'),$decode); |
489 | - } |
|
490 | - elseif (preg_match(':^#M1AAEP:',$message)) { |
|
565 | + } elseif (preg_match(':^#M1AAEP:',$message)) { |
|
491 | 566 | $decode = array_merge(array('Message nature' => 'Position/Weather Report'),$decode); |
492 | - } |
|
493 | - elseif (preg_match(':^#M2APWD:',$message)) { |
|
567 | + } elseif (preg_match(':^#M2APWD:',$message)) { |
|
494 | 568 | $decode = array_merge(array('Message nature' => 'Flight plan predicted wind data'),$decode); |
495 | - } |
|
496 | - elseif (preg_match(':^#M1BREQPWI:',$message)) { |
|
569 | + } elseif (preg_match(':^#M1BREQPWI:',$message)) { |
|
497 | 570 | $decode = array_merge(array('Message nature' => 'Predicted wind info request'),$decode); |
498 | - } |
|
499 | - elseif (preg_match(':^#CF:',$message)) { |
|
571 | + } elseif (preg_match(':^#CF:',$message)) { |
|
500 | 572 | $decode = array_merge(array('Message nature' => 'Central Fault Display'),$decode); |
501 | - } |
|
502 | - elseif (preg_match(':^#DF:',$message)) { |
|
573 | + } elseif (preg_match(':^#DF:',$message)) { |
|
503 | 574 | $decode = array_merge(array('Message nature' => 'Digital Flight Data Acquisition Unit'),$decode); |
504 | - } |
|
505 | - elseif (preg_match(':^#EC:',$message)) { |
|
575 | + } elseif (preg_match(':^#EC:',$message)) { |
|
506 | 576 | $decode = array_merge(array('Message nature' => 'Engine Display System'),$decode); |
507 | - } |
|
508 | - elseif (preg_match(':^#EI:',$message)) { |
|
577 | + } elseif (preg_match(':^#EI:',$message)) { |
|
509 | 578 | $decode = array_merge(array('Message nature' => 'Engine Report'),$decode); |
510 | - } |
|
511 | - elseif (preg_match(':^#H1:',$message)) { |
|
579 | + } elseif (preg_match(':^#H1:',$message)) { |
|
512 | 580 | $decode = array_merge(array('Message nature' => 'HF Data Radio - Left'),$decode); |
513 | - } |
|
514 | - elseif (preg_match(':^#H2:',$message)) { |
|
581 | + } elseif (preg_match(':^#H2:',$message)) { |
|
515 | 582 | $decode = array_merge(array('Message nature' => 'HF Data Radio - Right'),$decode); |
516 | - } |
|
517 | - elseif (preg_match(':^#HD:',$message)) { |
|
583 | + } elseif (preg_match(':^#HD:',$message)) { |
|
518 | 584 | $decode = array_merge(array('Message nature' => 'HF Data Radio - Selected'),$decode); |
519 | - } |
|
520 | - elseif (preg_match(':^#M1:',$message)) { |
|
585 | + } elseif (preg_match(':^#M1:',$message)) { |
|
521 | 586 | $decode = array_merge(array('Message nature' => 'Flight Management Computer - Left'),$decode); |
522 | - } |
|
523 | - elseif (preg_match(':^#M2:',$message)) { |
|
587 | + } elseif (preg_match(':^#M2:',$message)) { |
|
524 | 588 | $decode = array_merge(array('Message nature' => 'Flight Management Computer - Right'),$decode); |
525 | - } |
|
526 | - elseif (preg_match(':^#M3:',$message)) { |
|
589 | + } elseif (preg_match(':^#M3:',$message)) { |
|
527 | 590 | $decode = array_merge(array('Message nature' => 'Flight Management Computer - Center'),$decode); |
528 | - } |
|
529 | - elseif (preg_match(':^#MD:',$message)) { |
|
591 | + } elseif (preg_match(':^#MD:',$message)) { |
|
530 | 592 | $decode = array_merge(array('Message nature' => 'Flight Management Computer - Selected'),$decode); |
531 | - } |
|
532 | - elseif (preg_match(':^#PS:',$message)) { |
|
593 | + } elseif (preg_match(':^#PS:',$message)) { |
|
533 | 594 | $decode = array_merge(array('Message nature' => 'Keyboard/Display Unit'),$decode); |
534 | - } |
|
535 | - elseif (preg_match(':^#S1:',$message)) { |
|
595 | + } elseif (preg_match(':^#S1:',$message)) { |
|
536 | 596 | $decode = array_merge(array('Message nature' => 'SDU - Left'),$decode); |
537 | - } |
|
538 | - elseif (preg_match(':^#S2:',$message)) { |
|
597 | + } elseif (preg_match(':^#S2:',$message)) { |
|
539 | 598 | $decode = array_merge(array('Message nature' => 'SDU - Right'),$decode); |
540 | - } |
|
541 | - elseif (preg_match(':^#SD:',$message)) { |
|
599 | + } elseif (preg_match(':^#SD:',$message)) { |
|
542 | 600 | $decode = array_merge(array('Message nature' => 'SDU - Selected'),$decode); |
543 | - } |
|
544 | - elseif (preg_match(':^#T[0-8]:',$message)) { |
|
601 | + } elseif (preg_match(':^#T[0-8]:',$message)) { |
|
545 | 602 | $decode = array_merge(array('Message nature' => 'Cabin Terminal Messages'),$decode); |
546 | - } |
|
547 | - elseif (preg_match(':^#WO:',$message)) { |
|
603 | + } elseif (preg_match(':^#WO:',$message)) { |
|
548 | 604 | $decode = array_merge(array('Message nature' => 'Weather Observation Report'),$decode); |
549 | - } |
|
550 | - elseif (preg_match(':^#A1:',$message)) { |
|
605 | + } elseif (preg_match(':^#A1:',$message)) { |
|
551 | 606 | $decode = array_merge(array('Message nature' => 'Oceanic Clearance'),$decode); |
552 | - } |
|
553 | - elseif (preg_match(':^#A3:',$message)) { |
|
607 | + } elseif (preg_match(':^#A3:',$message)) { |
|
554 | 608 | $decode = array_merge(array('Message nature' => 'Departure Clearance Response'),$decode); |
555 | - } |
|
556 | - elseif (preg_match(':^#A4:',$message)) { |
|
609 | + } elseif (preg_match(':^#A4:',$message)) { |
|
557 | 610 | $decode = array_merge(array('Message nature' => 'Flight Systems Message'),$decode); |
558 | - } |
|
559 | - elseif (preg_match(':^#A6:',$message)) { |
|
611 | + } elseif (preg_match(':^#A6:',$message)) { |
|
560 | 612 | $decode = array_merge(array('Message nature' => 'Request ADS Reports'),$decode); |
561 | - } |
|
562 | - elseif (preg_match(':^#A8:',$message)) { |
|
613 | + } elseif (preg_match(':^#A8:',$message)) { |
|
563 | 614 | $decode = array_merge(array('Message nature' => 'Deliver Departure Slot'),$decode); |
564 | - } |
|
565 | - elseif (preg_match(':^#A9:',$message)) { |
|
615 | + } elseif (preg_match(':^#A9:',$message)) { |
|
566 | 616 | $decode = array_merge(array('Message nature' => 'ATIS report'),$decode); |
567 | - } |
|
568 | - elseif (preg_match(':^#A0:',$message)) { |
|
617 | + } elseif (preg_match(':^#A0:',$message)) { |
|
569 | 618 | $decode = array_merge(array('Message nature' => 'ATIS Facility Notification (AFN)'),$decode); |
570 | - } |
|
571 | - elseif (preg_match(':^#AA:',$message)) { |
|
619 | + } elseif (preg_match(':^#AA:',$message)) { |
|
572 | 620 | $decode = array_merge(array('Message nature' => 'ATCComm'),$decode); |
573 | - } |
|
574 | - elseif (preg_match(':^#AB:',$message)) { |
|
621 | + } elseif (preg_match(':^#AB:',$message)) { |
|
575 | 622 | $decode = array_merge(array('Message nature' => 'TWIP Report'),$decode); |
576 | - } |
|
577 | - elseif (preg_match(':^#AC:',$message)) { |
|
623 | + } elseif (preg_match(':^#AC:',$message)) { |
|
578 | 624 | $decode = array_merge(array('Message nature' => 'Pushback Clearance'),$decode); |
579 | - } |
|
580 | - elseif (preg_match(':^#AD:',$message)) { |
|
625 | + } elseif (preg_match(':^#AD:',$message)) { |
|
581 | 626 | $decode = array_merge(array('Message nature' => 'Expected Taxi Clearance'),$decode); |
582 | - } |
|
583 | - elseif (preg_match(':^#AF:',$message)) { |
|
627 | + } elseif (preg_match(':^#AF:',$message)) { |
|
584 | 628 | $decode = array_merge(array('Message nature' => 'CPC Command/Response'),$decode); |
585 | - } |
|
586 | - elseif (preg_match(':^#B1:',$message)) { |
|
629 | + } elseif (preg_match(':^#B1:',$message)) { |
|
587 | 630 | $decode = array_merge(array('Message nature' => 'Request Oceanic Clearance'),$decode); |
588 | - } |
|
589 | - elseif (preg_match(':^#B2:',$message)) { |
|
631 | + } elseif (preg_match(':^#B2:',$message)) { |
|
590 | 632 | $decode = array_merge(array('Message nature' => 'Oceanic Clearance Readback'),$decode); |
591 | - } |
|
592 | - elseif (preg_match(':^#B3:',$message)) { |
|
633 | + } elseif (preg_match(':^#B3:',$message)) { |
|
593 | 634 | $decode = array_merge(array('Message nature' => 'Request Departure Clearance'),$decode); |
594 | - } |
|
595 | - elseif (preg_match(':^#B4:',$message)) { |
|
635 | + } elseif (preg_match(':^#B4:',$message)) { |
|
596 | 636 | $decode = array_merge(array('Message nature' => 'Departure Clearance Readback'),$decode); |
597 | - } |
|
598 | - elseif (preg_match(':^#B6:',$message)) { |
|
637 | + } elseif (preg_match(':^#B6:',$message)) { |
|
599 | 638 | $decode = array_merge(array('Message nature' => 'Provide ADS Report'),$decode); |
600 | - } |
|
601 | - elseif (preg_match(':^#B8:',$message)) { |
|
639 | + } elseif (preg_match(':^#B8:',$message)) { |
|
602 | 640 | $decode = array_merge(array('Message nature' => 'Request Departure Slot'),$decode); |
603 | - } |
|
604 | - elseif (preg_match(':^#B9:',$message)) { |
|
641 | + } elseif (preg_match(':^#B9:',$message)) { |
|
605 | 642 | $decode = array_merge(array('Message nature' => 'Request ATIS Report'),$decode); |
606 | - } |
|
607 | - elseif (preg_match(':^#B0:',$message)) { |
|
643 | + } elseif (preg_match(':^#B0:',$message)) { |
|
608 | 644 | $decode = array_merge(array('Message nature' => 'ATS Facility Notification'),$decode); |
609 | - } |
|
610 | - elseif (preg_match(':^#BA:',$message)) { |
|
645 | + } elseif (preg_match(':^#BA:',$message)) { |
|
611 | 646 | $decode = array_merge(array('Message nature' => 'ATCComm'),$decode); |
612 | - } |
|
613 | - elseif (preg_match(':^#BB:',$message)) { |
|
647 | + } elseif (preg_match(':^#BB:',$message)) { |
|
614 | 648 | $decode = array_merge(array('Message nature' => 'Request TWIP Report'),$decode); |
615 | - } |
|
616 | - elseif (preg_match(':^#BC:',$message)) { |
|
649 | + } elseif (preg_match(':^#BC:',$message)) { |
|
617 | 650 | $decode = array_merge(array('Message nature' => 'Pushback Clearance Request'),$decode); |
618 | - } |
|
619 | - elseif (preg_match(':^#BD:',$message)) { |
|
651 | + } elseif (preg_match(':^#BD:',$message)) { |
|
620 | 652 | $decode = array_merge(array('Message nature' => 'Expected Taxi Clearance Request'),$decode); |
621 | - } |
|
622 | - elseif (preg_match(':^#BE:',$message)) { |
|
653 | + } elseif (preg_match(':^#BE:',$message)) { |
|
623 | 654 | $decode = array_merge(array('Message nature' => 'CPC Aircraft Log-On/Off Request'),$decode); |
624 | - } |
|
625 | - elseif (preg_match(':^#BF:',$message)) { |
|
655 | + } elseif (preg_match(':^#BF:',$message)) { |
|
626 | 656 | $decode = array_merge(array('Message nature' => 'CPC WILCO/UNABLE Response'),$decode); |
627 | - } |
|
628 | - elseif (preg_match(':^#H3:',$message)) { |
|
657 | + } elseif (preg_match(':^#H3:',$message)) { |
|
629 | 658 | $decode = array_merge(array('Message nature' => 'Icing Report'),$decode); |
630 | 659 | } |
631 | 660 | } |
632 | 661 | if ($label == '10') { |
633 | 662 | if (preg_match(':^DTO01:',$message)) { |
634 | 663 | $decode = array_merge(array('Message nature' => 'Delayed Takeoff Report'),$decode); |
635 | - } |
|
636 | - elseif (preg_match(':^AIS01:',$message)) { |
|
664 | + } elseif (preg_match(':^AIS01:',$message)) { |
|
637 | 665 | $decode = array_merge(array('Message nature' => 'AIS Request'),$decode); |
638 | - } |
|
639 | - elseif (preg_match(':^FTX01:',$message)) { |
|
666 | + } elseif (preg_match(':^FTX01:',$message)) { |
|
640 | 667 | $decode = array_merge(array('Message nature' => 'Free Text Downlink'),$decode); |
641 | - } |
|
642 | - elseif (preg_match(':^FPL01:',$message)) { |
|
668 | + } elseif (preg_match(':^FPL01:',$message)) { |
|
643 | 669 | $decode = array_merge(array('Message nature' => 'Flight Plan Request'),$decode); |
644 | - } |
|
645 | - elseif (preg_match(':^WAB01:',$message)) { |
|
670 | + } elseif (preg_match(':^WAB01:',$message)) { |
|
646 | 671 | $decode = array_merge(array('Message nature' => 'Weight & Balance Request'),$decode); |
647 | - } |
|
648 | - elseif (preg_match(':^MET01:',$message)) { |
|
672 | + } elseif (preg_match(':^MET01:',$message)) { |
|
649 | 673 | $decode = array_merge(array('Message nature' => 'Weather Data Request'),$decode); |
650 | - } |
|
651 | - elseif (preg_match(':^WAB02:',$message)) { |
|
674 | + } elseif (preg_match(':^WAB02:',$message)) { |
|
652 | 675 | $decode = array_merge(array('Message nature' => 'Weight and Balance Acknowledgement'),$decode); |
653 | 676 | } |
654 | 677 | } |
@@ -663,38 +686,28 @@ discard block |
||
663 | 686 | $vsta = array('Version' => $version); |
664 | 687 | if ($state == 'E') { |
665 | 688 | $vsta = array_merge($vsta,array('Link state' => 'Established')); |
666 | - } |
|
667 | - elseif ($state == 'L') { |
|
689 | + } elseif ($state == 'L') { |
|
668 | 690 | $vsta = array_merge($vsta,array('Link state' => 'Lost')); |
669 | - } |
|
670 | - else { |
|
691 | + } else { |
|
671 | 692 | $vsta = array_merge($vsta,array('Link state' => 'Unknown')); |
672 | 693 | } |
673 | 694 | if ($type == 'V') { |
674 | 695 | $vsta = array_merge($vsta,array('Link type' => 'VHF ACARS')); |
675 | - } |
|
676 | - elseif ($type == 'S') { |
|
696 | + } elseif ($type == 'S') { |
|
677 | 697 | $vsta = array_merge($vsta,array('Link type' => 'Generic SATCOM')); |
678 | - } |
|
679 | - elseif ($type == 'H') { |
|
698 | + } elseif ($type == 'H') { |
|
680 | 699 | $vsta = array_merge($vsta,array('Link type' => 'HF')); |
681 | - } |
|
682 | - elseif ($type == 'G') { |
|
700 | + } elseif ($type == 'G') { |
|
683 | 701 | $vsta = array_merge($vsta,array('Link type' => 'GlobalStar SATCOM')); |
684 | - } |
|
685 | - elseif ($type == 'C') { |
|
702 | + } elseif ($type == 'C') { |
|
686 | 703 | $vsta = array_merge($vsta,array('Link type' => 'ICO SATCOM')); |
687 | - } |
|
688 | - elseif ($type == '2') { |
|
704 | + } elseif ($type == '2') { |
|
689 | 705 | $vsta = array_merge($vsta,array('Link type' => 'VDL Mode 2')); |
690 | - } |
|
691 | - elseif ($type == 'X') { |
|
706 | + } elseif ($type == 'X') { |
|
692 | 707 | $vsta = array_merge($vsta,array('Link type' => 'Inmarsat Aero')); |
693 | - } |
|
694 | - elseif ($type == 'I') { |
|
708 | + } elseif ($type == 'I') { |
|
695 | 709 | $vsta = array_merge($vsta,array('Link type' => 'Irridium SATCOM')); |
696 | - } |
|
697 | - else { |
|
710 | + } else { |
|
698 | 711 | $vsta = array_merge($vsta,array('Link type' => 'Unknown')); |
699 | 712 | } |
700 | 713 | $vsta = array_merge($vsta,array('Event occured at' => implode(':',str_split($at,2)))); |
@@ -703,7 +716,9 @@ discard block |
||
703 | 716 | } |
704 | 717 | |
705 | 718 | $title = $this->getTitlefromLabel($label); |
706 | - if ($title != '') $decode = array_merge(array('Message title' => $title),$decode); |
|
719 | + if ($title != '') { |
|
720 | + $decode = array_merge(array('Message title' => $title),$decode); |
|
721 | + } |
|
707 | 722 | /* |
708 | 723 | // Business jets always use GS0001 |
709 | 724 | if ($ident != 'GS0001') $info = $this->addModeSData($ident,$registration,$icao,$airicao,$latitude,$longitude); |
@@ -738,31 +753,54 @@ discard block |
||
738 | 753 | $msg = $message['message']; |
739 | 754 | $decode = $message['decode']; |
740 | 755 | $registration = (string)$message['registration']; |
741 | - if (isset($decode['latitude'])) $latitude = $decode['latitude']; |
|
742 | - else $latitude = ''; |
|
743 | - if (isset($decode['longitude'])) $longitude = $decode['longitude']; |
|
744 | - else $longitude = ''; |
|
745 | - if (isset($decode['airicao'])) $airicao = $decode['airicao']; |
|
746 | - else $airicao = ''; |
|
747 | - if (isset($decode['icao'])) $icao = $decode['icao']; |
|
748 | - else $icao = $Translation->checkTranslation($ident); |
|
756 | + if (isset($decode['latitude'])) { |
|
757 | + $latitude = $decode['latitude']; |
|
758 | + } else { |
|
759 | + $latitude = ''; |
|
760 | + } |
|
761 | + if (isset($decode['longitude'])) { |
|
762 | + $longitude = $decode['longitude']; |
|
763 | + } else { |
|
764 | + $longitude = ''; |
|
765 | + } |
|
766 | + if (isset($decode['airicao'])) { |
|
767 | + $airicao = $decode['airicao']; |
|
768 | + } else { |
|
769 | + $airicao = ''; |
|
770 | + } |
|
771 | + if (isset($decode['icao'])) { |
|
772 | + $icao = $decode['icao']; |
|
773 | + } else { |
|
774 | + $icao = $Translation->checkTranslation($ident); |
|
775 | + } |
|
749 | 776 | $image_array = $Image->getSpotterImage($registration); |
750 | 777 | if (!isset($image_array[0]['registration'])) { |
751 | 778 | $Image->addSpotterImage($registration); |
752 | 779 | } |
753 | 780 | // Business jets always use GS0001 |
754 | - if ($ident != 'GS0001') $info = $this->addModeSData($ident,$registration,$icao,$airicao,$latitude,$longitude); |
|
755 | - if ($globalDebug && isset($info) && $info != '') echo $info; |
|
756 | - if (count($decode) > 0) $decode_json = json_encode($decode); |
|
757 | - else $decode_json = ''; |
|
781 | + if ($ident != 'GS0001') { |
|
782 | + $info = $this->addModeSData($ident,$registration,$icao,$airicao,$latitude,$longitude); |
|
783 | + } |
|
784 | + if ($globalDebug && isset($info) && $info != '') { |
|
785 | + echo $info; |
|
786 | + } |
|
787 | + if (count($decode) > 0) { |
|
788 | + $decode_json = json_encode($decode); |
|
789 | + } else { |
|
790 | + $decode_json = ''; |
|
791 | + } |
|
758 | 792 | if (isset($decode['Departure airport']) && isset($decode['Departure hour']) && isset($decode['Arrival airport']) && isset($decode['Arrival hour'])) { |
759 | 793 | $Schedule->addSchedule($icao,$decode['Departure airport'],$decode['Departure hour'],$decode['Arrival airport'],$decode['Arrival hour'],'ACARS'); |
760 | 794 | } elseif (isset($decode['Departure airport']) && isset($decode['Arrival airport'])) { |
761 | 795 | $Schedule->addSchedule($icao,$decode['Departure airport'],'',$decode['Arrival airport'],'','ACARS'); |
762 | 796 | } |
763 | 797 | $result = $this->addLiveAcarsData($ident,$registration,$label,$block_id,$msg_no,$msg,$decode_json); |
764 | - if (!isset($globalACARSArchive)) $globalACARSArchive = array('10','80','81','82','3F'); |
|
765 | - if ($result && in_array($label,$globalACARSArchive)) $this->addArchiveAcarsData($ident,$registration,$label,$block_id,$msg_no,$msg,$decode_json); |
|
798 | + if (!isset($globalACARSArchive)) { |
|
799 | + $globalACARSArchive = array('10','80','81','82','3F'); |
|
800 | + } |
|
801 | + if ($result && in_array($label,$globalACARSArchive)) { |
|
802 | + $this->addArchiveAcarsData($ident,$registration,$label,$block_id,$msg_no,$msg,$decode_json); |
|
803 | + } |
|
766 | 804 | if ($globalDebug && count($decode) > 0) { |
767 | 805 | echo "Human readable data : ".implode(' - ',$decode)."\n"; |
768 | 806 | } |
@@ -785,7 +823,9 @@ discard block |
||
785 | 823 | if ($label != 'SQ' && $label != 'Q0' && $label != '_d' && $message != '') { |
786 | 824 | $Connection = new Connection($this->db); |
787 | 825 | $this->db = $Connection->db; |
788 | - if ($globalDebug) echo "Test if not already in Live ACARS table..."; |
|
826 | + if ($globalDebug) { |
|
827 | + echo "Test if not already in Live ACARS table..."; |
|
828 | + } |
|
789 | 829 | $query_test = "SELECT COUNT(*) as nb FROM acars_live WHERE ident = :ident AND registration = :registration AND message = :message"; |
790 | 830 | $query_test_values = array(':ident' => $ident,':registration' => $registration, ':message' => $message); |
791 | 831 | try { |
@@ -795,7 +835,9 @@ discard block |
||
795 | 835 | return "error : ".$e->getMessage(); |
796 | 836 | } |
797 | 837 | if ($stht->fetchColumn() == 0) { |
798 | - if ($globalDebug) echo "Add Live ACARS data..."; |
|
838 | + if ($globalDebug) { |
|
839 | + echo "Add Live ACARS data..."; |
|
840 | + } |
|
799 | 841 | $query = "INSERT INTO acars_live (ident,registration,label,block_id,msg_no,message,decode,date) VALUES (:ident,:registration,:label,:block_id,:msg_no,:message,:decode,:date)"; |
800 | 842 | $query_values = array(':ident' => $ident,':registration' => $registration, ':label' => $label,':block_id' => $block_id, ':msg_no' => $msg_no, ':message' => $message, ':decode' => $decode,':date' => date("Y-m-d H:i:s")); |
801 | 843 | try { |
@@ -805,10 +847,14 @@ discard block |
||
805 | 847 | return "error : ".$e->getMessage(); |
806 | 848 | } |
807 | 849 | } else { |
808 | - if ($globalDebug) echo "Data already in DB...\n"; |
|
850 | + if ($globalDebug) { |
|
851 | + echo "Data already in DB...\n"; |
|
852 | + } |
|
809 | 853 | return false; |
810 | 854 | } |
811 | - if ($globalDebug) echo "Done\n"; |
|
855 | + if ($globalDebug) { |
|
856 | + echo "Done\n"; |
|
857 | + } |
|
812 | 858 | return true; |
813 | 859 | } |
814 | 860 | } |
@@ -839,7 +885,9 @@ discard block |
||
839 | 885 | } |
840 | 886 | if ($stht->fetchColumn() == 0) { |
841 | 887 | */ |
842 | - if ($globalDebug) echo "Add Live ACARS data..."; |
|
888 | + if ($globalDebug) { |
|
889 | + echo "Add Live ACARS data..."; |
|
890 | + } |
|
843 | 891 | $query = "INSERT INTO acars_archive (ident,registration,label,block_id,msg_no,message,decode) VALUES (:ident,:registration,:label,:block_id,:msg_no,:message,:decode)"; |
844 | 892 | $query_values = array(':ident' => $ident,':registration' => $registration, ':label' => $label,':block_id' => $block_id, ':msg_no' => $msg_no, ':message' => $message, ':decode' => $decode); |
845 | 893 | try { |
@@ -848,7 +896,9 @@ discard block |
||
848 | 896 | } catch(PDOException $e) { |
849 | 897 | return "error : ".$e->getMessage(); |
850 | 898 | } |
851 | - if ($globalDebug) echo "Done\n"; |
|
899 | + if ($globalDebug) { |
|
900 | + echo "Done\n"; |
|
901 | + } |
|
852 | 902 | } |
853 | 903 | } |
854 | 904 | |
@@ -871,8 +921,11 @@ discard block |
||
871 | 921 | return ''; |
872 | 922 | } |
873 | 923 | $row = $sth->fetchAll(PDO::FETCH_ASSOC); |
874 | - if (count($row) > 0) return $row[0]['title']; |
|
875 | - else return ''; |
|
924 | + if (count($row) > 0) { |
|
925 | + return $row[0]['title']; |
|
926 | + } else { |
|
927 | + return ''; |
|
928 | + } |
|
876 | 929 | } |
877 | 930 | |
878 | 931 | /** |
@@ -891,8 +944,11 @@ discard block |
||
891 | 944 | return array(); |
892 | 945 | } |
893 | 946 | $row = $sth->fetchAll(PDO::FETCH_ASSOC); |
894 | - if (count($row) > 0) return $row; |
|
895 | - else return array(); |
|
947 | + if (count($row) > 0) { |
|
948 | + return $row; |
|
949 | + } else { |
|
950 | + return array(); |
|
951 | + } |
|
896 | 952 | } |
897 | 953 | |
898 | 954 | /** |
@@ -912,8 +968,11 @@ discard block |
||
912 | 968 | return array(); |
913 | 969 | } |
914 | 970 | $row = $sth->fetchAll(PDO::FETCH_ASSOC); |
915 | - if (count($row) > 0) return $row[0]; |
|
916 | - else return array(); |
|
971 | + if (count($row) > 0) { |
|
972 | + return $row[0]; |
|
973 | + } else { |
|
974 | + return array(); |
|
975 | + } |
|
917 | 976 | } |
918 | 977 | |
919 | 978 | /** |
@@ -958,19 +1017,35 @@ discard block |
||
958 | 1017 | if ($row['registration'] != '') { |
959 | 1018 | $row['registration'] = str_replace('.','',$row['registration']); |
960 | 1019 | $image_array = $Image->getSpotterImage($row['registration']); |
961 | - 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'])); |
|
962 | - else $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
963 | - } else $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
964 | - if ($row['registration'] == '') $row['registration'] = 'NA'; |
|
965 | - if ($row['ident'] == '') $row['ident'] = 'NA'; |
|
1020 | + if (count($image_array) > 0) { |
|
1021 | + $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'])); |
|
1022 | + } else { |
|
1023 | + $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1024 | + } |
|
1025 | + } else { |
|
1026 | + $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1027 | + } |
|
1028 | + if ($row['registration'] == '') { |
|
1029 | + $row['registration'] = 'NA'; |
|
1030 | + } |
|
1031 | + if ($row['ident'] == '') { |
|
1032 | + $row['ident'] = 'NA'; |
|
1033 | + } |
|
966 | 1034 | $identicao = $Spotter->getAllAirlineInfo(substr($row['ident'],0,2)); |
967 | 1035 | if (isset($identicao[0])) { |
968 | 1036 | if (substr($row['ident'],0,2) == 'AF') { |
969 | - if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) $icao = $row['ident']; |
|
970 | - else $icao = 'AFR'.ltrim(substr($row['ident'],2),'0'); |
|
971 | - } else $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0'); |
|
1037 | + if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) { |
|
1038 | + $icao = $row['ident']; |
|
1039 | + } else { |
|
1040 | + $icao = 'AFR'.ltrim(substr($row['ident'],2),'0'); |
|
1041 | + } |
|
1042 | + } else { |
|
1043 | + $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0'); |
|
1044 | + } |
|
972 | 1045 | $data = array_merge($data,array('airline_icao' => $identicao[0]['icao'],'airline_name' => $identicao[0]['name'])); |
973 | - } else $icao = $row['ident']; |
|
1046 | + } else { |
|
1047 | + $icao = $row['ident']; |
|
1048 | + } |
|
974 | 1049 | $icao = $Translation->checkTranslation($icao,false); |
975 | 1050 | $decode = json_decode($row['decode'],true); |
976 | 1051 | $found = false; |
@@ -995,7 +1070,9 @@ discard block |
||
995 | 1070 | $found = true; |
996 | 1071 | } |
997 | 1072 | } |
998 | - if ($found) $row['decode'] = json_encode($decode); |
|
1073 | + if ($found) { |
|
1074 | + $row['decode'] = json_encode($decode); |
|
1075 | + } |
|
999 | 1076 | $data = array_merge($data,array('registration' => $row['registration'],'message' => $row['message'], 'date' => $row['date'], 'ident' => $icao, 'decode' => $row['decode'])); |
1000 | 1077 | $result[] = $data; |
1001 | 1078 | $i++; |
@@ -1003,8 +1080,9 @@ discard block |
||
1003 | 1080 | if (isset($result)) { |
1004 | 1081 | $result[0]['query_number_rows'] = $i; |
1005 | 1082 | return $result; |
1083 | + } else { |
|
1084 | + return array(); |
|
1006 | 1085 | } |
1007 | - else return array(); |
|
1008 | 1086 | } |
1009 | 1087 | |
1010 | 1088 | /** |
@@ -1053,31 +1131,51 @@ discard block |
||
1053 | 1131 | if ($row['registration'] != '') { |
1054 | 1132 | $row['registration'] = str_replace('.','',$row['registration']); |
1055 | 1133 | $image_array = $Image->getSpotterImage($row['registration']); |
1056 | - if (count($image_array) > 0) $data = array_merge($data,array('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'])); |
|
1057 | - else $data = array_merge($data,array('image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1058 | - } else $data = array_merge($data,array('image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1134 | + if (count($image_array) > 0) { |
|
1135 | + $data = array_merge($data,array('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'])); |
|
1136 | + } else { |
|
1137 | + $data = array_merge($data,array('image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1138 | + } |
|
1139 | + } else { |
|
1140 | + $data = array_merge($data,array('image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1141 | + } |
|
1059 | 1142 | $icao = ''; |
1060 | - if ($row['registration'] == '') $row['registration'] = 'NA'; |
|
1061 | - if ($row['ident'] == '') $row['ident'] = 'NA'; |
|
1143 | + if ($row['registration'] == '') { |
|
1144 | + $row['registration'] = 'NA'; |
|
1145 | + } |
|
1146 | + if ($row['ident'] == '') { |
|
1147 | + $row['ident'] = 'NA'; |
|
1148 | + } |
|
1062 | 1149 | $identicao = $Spotter->getAllAirlineInfo(substr($row['ident'],0,2)); |
1063 | 1150 | if (isset($identicao[0])) { |
1064 | 1151 | if (substr($row['ident'],0,2) == 'AF') { |
1065 | - if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) $icao = $row['ident']; |
|
1066 | - else $icao = 'AFR'.ltrim(substr($row['ident'],2),'0'); |
|
1067 | - } else $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0'); |
|
1152 | + if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) { |
|
1153 | + $icao = $row['ident']; |
|
1154 | + } else { |
|
1155 | + $icao = 'AFR'.ltrim(substr($row['ident'],2),'0'); |
|
1156 | + } |
|
1157 | + } else { |
|
1158 | + $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0'); |
|
1159 | + } |
|
1068 | 1160 | $data = array_merge($data,array('airline_icao' => $identicao[0]['icao'],'airline_name' => $identicao[0]['name'])); |
1069 | - } else $icao = $row['ident']; |
|
1161 | + } else { |
|
1162 | + $icao = $row['ident']; |
|
1163 | + } |
|
1070 | 1164 | $icao = $Translation->checkTranslation($icao); |
1071 | 1165 | $decode = json_decode($row['decode'],true); |
1072 | 1166 | $found = false; |
1073 | 1167 | if ($decode != '' && array_key_exists('Departure airport',$decode)) { |
1074 | 1168 | $airport_info = $Spotter->getAllAirportInfo($decode['Departure airport']); |
1075 | - if (isset($airport_info[0]['icao'])) $decode['Departure airport'] = '<a href="'.$globalURL.'/airport/'.$airport_info[0]['icao'].'">'.$airport_info[0]['city'].','.$airport_info[0]['country'].' ('.$airport_info[0]['icao'].')</a>'; |
|
1169 | + if (isset($airport_info[0]['icao'])) { |
|
1170 | + $decode['Departure airport'] = '<a href="'.$globalURL.'/airport/'.$airport_info[0]['icao'].'">'.$airport_info[0]['city'].','.$airport_info[0]['country'].' ('.$airport_info[0]['icao'].')</a>'; |
|
1171 | + } |
|
1076 | 1172 | $found = true; |
1077 | 1173 | } |
1078 | 1174 | if ($decode != '' && array_key_exists('Arrival airport',$decode)) { |
1079 | 1175 | $airport_info = $Spotter->getAllAirportInfo($decode['Arrival airport']); |
1080 | - if (isset($airport_info[0]['icao'])) $decode['Arrival airport'] = '<a href="'.$globalURL.'/airport/'.$airport_info[0]['icao'].'">'.$airport_info[0]['city'].','.$airport_info[0]['country'].' ('.$airport_info[0]['icao'].')</a>'; |
|
1176 | + if (isset($airport_info[0]['icao'])) { |
|
1177 | + $decode['Arrival airport'] = '<a href="'.$globalURL.'/airport/'.$airport_info[0]['icao'].'">'.$airport_info[0]['city'].','.$airport_info[0]['country'].' ('.$airport_info[0]['icao'].')</a>'; |
|
1178 | + } |
|
1081 | 1179 | $found = true; |
1082 | 1180 | } |
1083 | 1181 | if ($decode != '' && array_key_exists('Airport/Waypoint name',$decode)) { |
@@ -1087,7 +1185,9 @@ discard block |
||
1087 | 1185 | $found = true; |
1088 | 1186 | } |
1089 | 1187 | } |
1090 | - if ($found) $row['decode'] = json_encode($decode); |
|
1188 | + if ($found) { |
|
1189 | + $row['decode'] = json_encode($decode); |
|
1190 | + } |
|
1091 | 1191 | $data = array_merge($data,array('registration' => $row['registration'],'message' => $row['message'], 'date' => $row['date'], 'ident' => $icao, 'decode' => $row['decode'])); |
1092 | 1192 | $result[] = $data; |
1093 | 1193 | $i++; |
@@ -1095,7 +1195,9 @@ discard block |
||
1095 | 1195 | if (isset($result)) { |
1096 | 1196 | $result[0]['query_number_rows'] = $i; |
1097 | 1197 | return $result; |
1098 | - } else return array(); |
|
1198 | + } else { |
|
1199 | + return array(); |
|
1200 | + } |
|
1099 | 1201 | } |
1100 | 1202 | |
1101 | 1203 | /** |
@@ -1111,25 +1213,37 @@ discard block |
||
1111 | 1213 | $ident = trim($ident); |
1112 | 1214 | $Translation = new Translation($this->db); |
1113 | 1215 | $Spotter = new Spotter($this->db); |
1114 | - if ($globalDebug) echo "Test if we add ModeS data..."; |
|
1216 | + if ($globalDebug) { |
|
1217 | + echo "Test if we add ModeS data..."; |
|
1218 | + } |
|
1115 | 1219 | //if ($icao == '') $icao = ACARS->ident2icao($ident); |
1116 | - if ($icao == '') $icao = $Translation->checkTranslation($ident); |
|
1117 | - if ($globalDebug) echo '- Ident : '.$icao.' - '; |
|
1220 | + if ($icao == '') { |
|
1221 | + $icao = $Translation->checkTranslation($ident); |
|
1222 | + } |
|
1223 | + if ($globalDebug) { |
|
1224 | + echo '- Ident : '.$icao.' - '; |
|
1225 | + } |
|
1118 | 1226 | if ($ident == '' || $registration == '') { |
1119 | - if ($globalDebug) echo "Ident or registration null, exit\n"; |
|
1227 | + if ($globalDebug) { |
|
1228 | + echo "Ident or registration null, exit\n"; |
|
1229 | + } |
|
1120 | 1230 | return ''; |
1121 | 1231 | } |
1122 | 1232 | $registration = str_replace('.','',$registration); |
1123 | 1233 | $ident = $Translation->ident2icao($ident); |
1124 | 1234 | // Check if a flight with same registration is flying now, if ok check if callsign = name in ACARS, else add it to translation |
1125 | - if ($globalDebug) echo "Check if needed to add translation ".$ident.'... '; |
|
1235 | + if ($globalDebug) { |
|
1236 | + echo "Check if needed to add translation ".$ident.'... '; |
|
1237 | + } |
|
1126 | 1238 | $querysi = "SELECT ident FROM spotter_live s,aircraft_modes a WHERE a.ModeS = s.ModeS AND a.Registration = :registration AND s.format_source <> 'ACARS' LIMIT 1"; |
1127 | 1239 | $querysi_values = array(':registration' => $registration); |
1128 | 1240 | try { |
1129 | 1241 | $sthsi = $this->db->prepare($querysi); |
1130 | 1242 | $sthsi->execute($querysi_values); |
1131 | 1243 | } catch(PDOException $e) { |
1132 | - if ($globalDebug) echo $e->getMessage(); |
|
1244 | + if ($globalDebug) { |
|
1245 | + echo $e->getMessage(); |
|
1246 | + } |
|
1133 | 1247 | return "error : ".$e->getMessage(); |
1134 | 1248 | } |
1135 | 1249 | $resultsi = $sthsi->fetch(PDO::FETCH_ASSOC); |
@@ -1137,9 +1251,14 @@ discard block |
||
1137 | 1251 | if (count($resultsi) > 0 && $resultsi['ident'] != $ident && $resultsi['ident'] != '') { |
1138 | 1252 | $Translation = new Translation($this->db); |
1139 | 1253 | $trans_ident = $Translation->getOperator($resultsi['ident']); |
1140 | - if ($globalDebug) echo 'Add translation to table : '.$ident.' -> '.$resultsi['ident'].' '; |
|
1141 | - if ($ident != $trans_ident) $Translation->addOperator($resultsi['ident'],$ident,'ACARS'); |
|
1142 | - elseif ($trans_ident == $ident) $Translation->updateOperator($resultsi['ident'],$ident,'ACARS'); |
|
1254 | + if ($globalDebug) { |
|
1255 | + echo 'Add translation to table : '.$ident.' -> '.$resultsi['ident'].' '; |
|
1256 | + } |
|
1257 | + if ($ident != $trans_ident) { |
|
1258 | + $Translation->addOperator($resultsi['ident'],$ident,'ACARS'); |
|
1259 | + } elseif ($trans_ident == $ident) { |
|
1260 | + $Translation->updateOperator($resultsi['ident'],$ident,'ACARS'); |
|
1261 | + } |
|
1143 | 1262 | } else { |
1144 | 1263 | if ($registration != '' && $latitude != '' && $longitude != '') { |
1145 | 1264 | $query = "SELECT ModeS FROM aircraft_modes WHERE Registration = :registration LIMIT 1"; |
@@ -1148,32 +1267,44 @@ discard block |
||
1148 | 1267 | $sth = $this->db->prepare($query); |
1149 | 1268 | $sth->execute($query_values); |
1150 | 1269 | } catch(PDOException $e) { |
1151 | - if ($globalDebug) echo $e->getMessage(); |
|
1270 | + if ($globalDebug) { |
|
1271 | + echo $e->getMessage(); |
|
1272 | + } |
|
1152 | 1273 | return "error : ".$e->getMessage(); |
1153 | 1274 | } |
1154 | 1275 | $result = $sth->fetch(PDO::FETCH_ASSOC); |
1155 | 1276 | $sth->closeCursor(); |
1156 | - if (isset($result['modes'])) $hex = $result['modes']; |
|
1157 | - else $hex = ''; |
|
1277 | + if (isset($result['modes'])) { |
|
1278 | + $hex = $result['modes']; |
|
1279 | + } else { |
|
1280 | + $hex = ''; |
|
1281 | + } |
|
1158 | 1282 | $SI_data = array('hex' => $hex,'ident' => $ident,'aircraft_icao' => $ICAOTypeCode,'registration' => $registration,'latitude' => $latitude,'$longitude' => $longitude,'format_source' => 'ACARS'); |
1159 | 1283 | $this->SI->add($SI_data); |
1160 | 1284 | } |
1161 | 1285 | } |
1162 | - if ($globalDebug) echo 'Done'."\n"; |
|
1286 | + if ($globalDebug) { |
|
1287 | + echo 'Done'."\n"; |
|
1288 | + } |
|
1163 | 1289 | $query = "SELECT flightaware_id, ModeS FROM spotter_output WHERE ident = :ident AND format_source <> 'ACARS' ORDER BY spotter_id DESC LIMIT 1"; |
1164 | 1290 | $query_values = array(':ident' => $icao); |
1165 | 1291 | try { |
1166 | 1292 | $sth = $this->db->prepare($query); |
1167 | 1293 | $sth->execute($query_values); |
1168 | 1294 | } catch(PDOException $e) { |
1169 | - if ($globalDebug) echo $e->getMessage(); |
|
1295 | + if ($globalDebug) { |
|
1296 | + echo $e->getMessage(); |
|
1297 | + } |
|
1170 | 1298 | return "error : ".$e->getMessage(); |
1171 | 1299 | } |
1172 | 1300 | $result = $sth->fetch(PDO::FETCH_ASSOC); |
1173 | 1301 | $sth->closeCursor(); |
1174 | 1302 | if (isset($result['flightaware_id'])) { |
1175 | - if (isset($result['ModeS'])) $ModeS = $result['ModeS']; |
|
1176 | - else $ModeS = ''; |
|
1303 | + if (isset($result['ModeS'])) { |
|
1304 | + $ModeS = $result['ModeS']; |
|
1305 | + } else { |
|
1306 | + $ModeS = ''; |
|
1307 | + } |
|
1177 | 1308 | if ($ModeS == '') { |
1178 | 1309 | $id = explode('-',$result['flightaware_id']); |
1179 | 1310 | $ModeS = $id[0]; |
@@ -1186,24 +1317,32 @@ discard block |
||
1186 | 1317 | $sthc = $this->db->prepare($queryc); |
1187 | 1318 | $sthc->execute($queryc_values); |
1188 | 1319 | } catch(PDOException $e) { |
1189 | - if ($globalDebug) echo $e->getMessage(); |
|
1320 | + if ($globalDebug) { |
|
1321 | + echo $e->getMessage(); |
|
1322 | + } |
|
1190 | 1323 | return "error : ".$e->getMessage(); |
1191 | 1324 | } |
1192 | 1325 | $row = $sthc->fetch(PDO::FETCH_ASSOC); |
1193 | 1326 | $sthc->closeCursor(); |
1194 | 1327 | if (count($row) == 0) { |
1195 | - if ($globalDebug) echo " Add to ModeS table - "; |
|
1328 | + if ($globalDebug) { |
|
1329 | + echo " Add to ModeS table - "; |
|
1330 | + } |
|
1196 | 1331 | $queryi = "INSERT INTO aircraft_modes (ModeS,ModeSCountry,Registration,ICAOTypeCode,Source) VALUES (:ModeS,:ModeSCountry,:Registration, :ICAOTypeCode,'ACARS')"; |
1197 | 1332 | $queryi_values = array(':ModeS' => $ModeS,':ModeSCountry' => $country,':Registration' => $registration, ':ICAOTypeCode' => $ICAOTypeCode); |
1198 | 1333 | try { |
1199 | 1334 | $sthi = $this->db->prepare($queryi); |
1200 | 1335 | $sthi->execute($queryi_values); |
1201 | 1336 | } catch(PDOException $e) { |
1202 | - if ($globalDebug) echo $e->getMessage(); |
|
1337 | + if ($globalDebug) { |
|
1338 | + echo $e->getMessage(); |
|
1339 | + } |
|
1203 | 1340 | return "error : ".$e->getMessage(); |
1204 | 1341 | } |
1205 | 1342 | } else { |
1206 | - if ($globalDebug) echo " Update ModeS table - "; |
|
1343 | + if ($globalDebug) { |
|
1344 | + echo " Update ModeS table - "; |
|
1345 | + } |
|
1207 | 1346 | if ($ICAOTypeCode != '') { |
1208 | 1347 | $queryi = "UPDATE aircraft_modes SET ModeSCountry = :ModeSCountry,Registration = :Registration,ICAOTypeCode = :ICAOTypeCode,Source = 'ACARS',LastModified = NOW() WHERE ModeS = :ModeS"; |
1209 | 1348 | $queryi_values = array(':ModeS' => $ModeS,':ModeSCountry' => $country,':Registration' => $registration, ':ICAOTypeCode' => $ICAOTypeCode); |
@@ -1215,7 +1354,9 @@ discard block |
||
1215 | 1354 | $sthi = $this->db->prepare($queryi); |
1216 | 1355 | $sthi->execute($queryi_values); |
1217 | 1356 | } catch(PDOException $e) { |
1218 | - if ($globalDebug) echo $e->getMessage(); |
|
1357 | + if ($globalDebug) { |
|
1358 | + echo $e->getMessage(); |
|
1359 | + } |
|
1219 | 1360 | return "error : ".$e->getMessage(); |
1220 | 1361 | } |
1221 | 1362 | } |
@@ -1236,7 +1377,9 @@ discard block |
||
1236 | 1377 | return "error : ".$e->getMessage(); |
1237 | 1378 | } |
1238 | 1379 | */ |
1239 | - if ($globalDebug) echo " Update Spotter_output table - "; |
|
1380 | + if ($globalDebug) { |
|
1381 | + echo " Update Spotter_output table - "; |
|
1382 | + } |
|
1240 | 1383 | if ($ICAOTypeCode != '') { |
1241 | 1384 | if ($globalDBdriver == 'mysql') { |
1242 | 1385 | $queryi = "UPDATE spotter_output SET registration = :Registration,aircraft_icao = :ICAOTypeCode WHERE ident = :ident AND date >= date_sub(UTC_TIMESTAMP(), INTERVAL 1 HOUR)"; |
@@ -1247,8 +1390,7 @@ discard block |
||
1247 | 1390 | } else { |
1248 | 1391 | if ($globalDBdriver == 'mysql') { |
1249 | 1392 | $queryi = "UPDATE spotter_output SET registration = :Registration WHERE ident = :ident AND date >= date_sub(UTC_TIMESTAMP(), INTERVAL 1 HOUR)"; |
1250 | - } |
|
1251 | - elseif ($globalDBdriver == 'pgsql') { |
|
1393 | + } elseif ($globalDBdriver == 'pgsql') { |
|
1252 | 1394 | $queryi = "UPDATE spotter_output SET registration = :Registration WHERE ident = :ident AND date >= NOW() AT TIME ZONE 'UTC' - INTERVAL '1 HOUR'"; |
1253 | 1395 | } |
1254 | 1396 | $queryi_values = array(':Registration' => $registration,':ident' => $icao); |
@@ -1257,14 +1399,20 @@ discard block |
||
1257 | 1399 | $sthi = $this->db->prepare($queryi); |
1258 | 1400 | $sthi->execute($queryi_values); |
1259 | 1401 | } catch(PDOException $e) { |
1260 | - if ($globalDebug) echo $e->getMessage(); |
|
1402 | + if ($globalDebug) { |
|
1403 | + echo $e->getMessage(); |
|
1404 | + } |
|
1261 | 1405 | return "error : ".$e->getMessage(); |
1262 | 1406 | } |
1263 | 1407 | } |
1264 | 1408 | } else { |
1265 | - if ($globalDebug) echo " Can't find ModeS in spotter_output - "; |
|
1409 | + if ($globalDebug) { |
|
1410 | + echo " Can't find ModeS in spotter_output - "; |
|
1411 | + } |
|
1412 | + } |
|
1413 | + if ($globalDebug) { |
|
1414 | + echo "Done\n"; |
|
1266 | 1415 | } |
1267 | - if ($globalDebug) echo "Done\n"; |
|
1268 | 1416 | } |
1269 | 1417 | } |
1270 | 1418 | ?> |
@@ -25,7 +25,9 @@ discard block |
||
25 | 25 | echo json_encode($marinecnt); |
26 | 26 | } elseif ($ask == 'manufacturer') { |
27 | 27 | $manufacturers = $Stats->getAllManufacturers(); |
28 | - if (empty($manufacturers)) $manufacturers = $Spotter->getAllManufacturers(); |
|
28 | + if (empty($manufacturers)) { |
|
29 | + $manufacturers = $Spotter->getAllManufacturers(); |
|
30 | + } |
|
29 | 31 | $all_manufacturers = array(); |
30 | 32 | foreach($manufacturers as $manufacturer) |
31 | 33 | { |
@@ -34,7 +36,9 @@ discard block |
||
34 | 36 | echo json_encode($all_manufacturers); |
35 | 37 | } elseif ($ask == 'aircrafttypes') { |
36 | 38 | $aircraft_types = $Stats->getAllAircraftTypes(); |
37 | - if (empty($aircraft_types)) $aircraft_types = $Spotter->getAllAircraftTypes(); |
|
39 | + if (empty($aircraft_types)) { |
|
40 | + $aircraft_types = $Spotter->getAllAircraftTypes(); |
|
41 | + } |
|
38 | 42 | $all_aircraft_types = array(); |
39 | 43 | foreach($aircraft_types as $aircraft_type) |
40 | 44 | { |
@@ -59,7 +63,9 @@ discard block |
||
59 | 63 | echo json_encode($all_airline_countries); |
60 | 64 | } elseif ($ask == 'airportnames' || $ask == 'departureairportnames' || $ask == 'arrivalairportnames') { |
61 | 65 | $airport_names = $Stats->getAllAirportNames(); |
62 | - if (empty($airport_names)) $airport_names = $Spotter->getAllAirportNames(); |
|
66 | + if (empty($airport_names)) { |
|
67 | + $airport_names = $Spotter->getAllAirportNames(); |
|
68 | + } |
|
63 | 69 | ksort($airport_names); |
64 | 70 | $all_airport_names = array(); |
65 | 71 | foreach($airport_names as $airport_name) |
@@ -31,7 +31,9 @@ discard block |
||
31 | 31 | $output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">'; |
32 | 32 | |
33 | 33 | $aircraft_types = $Stats->getAllAircraftTypes(); |
34 | - if (empty($aircraft_types)) $aircraft_types = $Spotter->getAllAircraftTypes(); |
|
34 | + if (empty($aircraft_types)) { |
|
35 | + $aircraft_types = $Spotter->getAllAircraftTypes(); |
|
36 | + } |
|
35 | 37 | foreach($aircraft_types as $aircraft_item) |
36 | 38 | { |
37 | 39 | $output .= '<url>'; |
@@ -81,7 +83,9 @@ discard block |
||
81 | 83 | $output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">'; |
82 | 84 | |
83 | 85 | $airport_names = $Stats->getAllAirportNames(); |
84 | - if (empty($airport_names)) $airport_names = $Spotter->getAllAirportNames(); |
|
86 | + if (empty($airport_names)) { |
|
87 | + $airport_names = $Spotter->getAllAirportNames(); |
|
88 | + } |
|
85 | 89 | foreach($airport_names as $airport_item) |
86 | 90 | { |
87 | 91 | $output .= '<url>'; |
@@ -98,7 +102,9 @@ discard block |
||
98 | 102 | $output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">'; |
99 | 103 | |
100 | 104 | $manufacturer_names = $Stats->getAllManufacturers(); |
101 | - if (empty($manufacturer_names)) $manufacturer_names = $Spotter->getAllManufacturers(); |
|
105 | + if (empty($manufacturer_names)) { |
|
106 | + $manufacturer_names = $Spotter->getAllManufacturers(); |
|
107 | + } |
|
102 | 108 | foreach($manufacturer_names as $manufacturer_item) |
103 | 109 | { |
104 | 110 | $output .= '<url>'; |
@@ -9,7 +9,9 @@ discard block |
||
9 | 9 | if (strtoupper(substr(PHP_OS, 0, 3)) != 'WIN') { |
10 | 10 | exec("ps ux", $output, $result); |
11 | 11 | $j = 0; |
12 | - foreach ($output as $line) if(strpos($line, "update_db.php") && !strpos($line, "sh ")) $j++; |
|
12 | + foreach ($output as $line) { |
|
13 | + if(strpos($line, "update_db.php") && !strpos($line, "sh ")) $j++; |
|
14 | + } |
|
13 | 15 | if ($j > 1) { |
14 | 16 | echo "Script is already runnning..."; |
15 | 17 | die(); |
@@ -29,14 +31,18 @@ discard block |
||
29 | 31 | $update_db->update_notam(); |
30 | 32 | } |
31 | 33 | $update_db->insert_last_notam_update(); |
32 | - } elseif (isset($globalDebug) && $globalDebug && isset($globalNOTAM) && $globalNOTAM) echo "NOTAM are only updated once a day.\n"; |
|
34 | + } elseif (isset($globalDebug) && $globalDebug && isset($globalNOTAM) && $globalNOTAM) { |
|
35 | + echo "NOTAM are only updated once a day.\n"; |
|
36 | + } |
|
33 | 37 | if ($update_db->check_last_update() && (!isset($globalVA) || !$globalVA) && (!isset($globalIVAO) || !$globalIVAO) && (!isset($globalVATSIM) || !$globalVATSIM) && (!isset($globalphpVMS) || !$globalphpVMS)) { |
34 | 38 | $update_db->update_all(); |
35 | 39 | // require_once(dirname(__FILE__).'/../require/class.Spotter.php'); |
36 | 40 | // $Spotter = new Spotter(); |
37 | 41 | // $Spotter->updateFieldsFromOtherTables(); |
38 | 42 | $update_db->insert_last_update(); |
39 | - } elseif (isset($globalDebug) && $globalDebug && (!isset($globalVA) || !$globalVA) && (!isset($globalphpVMS) || !$globalphpVMS) && (!isset($globalIVAO) || !$globalIVAO) && (!isset($globalVATSIM) || !$globalVATSIM)) echo "DB are populated with external data only every 15 days ! Files are not updated more often.\n"; |
|
43 | + } elseif (isset($globalDebug) && $globalDebug && (!isset($globalVA) || !$globalVA) && (!isset($globalphpVMS) || !$globalphpVMS) && (!isset($globalIVAO) || !$globalIVAO) && (!isset($globalVATSIM) || !$globalVATSIM)) { |
|
44 | + echo "DB are populated with external data only every 15 days ! Files are not updated more often.\n"; |
|
45 | + } |
|
40 | 46 | if (isset($globalWaypoints) && $globalWaypoints && $update_db->check_last_airspace_update()) { |
41 | 47 | echo "Check if new airspace version exist..."; |
42 | 48 | echo $update_db->update_airspace_fam(); |
@@ -45,8 +51,11 @@ discard block |
||
45 | 51 | if (isset($globalGeoid) && $globalGeoid && $update_db->check_last_geoid_update()) { |
46 | 52 | echo "Check if new geoid version exist..."; |
47 | 53 | $error = $update_db->update_geoid_fam(); |
48 | - if ($error == '') $update_db->insert_last_geoid_update(); |
|
49 | - else echo $error; |
|
54 | + if ($error == '') { |
|
55 | + $update_db->insert_last_geoid_update(); |
|
56 | + } else { |
|
57 | + echo $error; |
|
58 | + } |
|
50 | 59 | } |
51 | 60 | if (isset($globalMarine) && $globalMarine && $update_db->check_last_marine_identity_update()) { |
52 | 61 | echo "Check if new marine identity version exist..."; |
@@ -64,7 +73,9 @@ discard block |
||
64 | 73 | //echo "Done"; |
65 | 74 | } |
66 | 75 | $update_db->insert_last_owner_update(); |
67 | - } elseif (isset($globalDebug) && $globalDebug && (!isset($globalVA) || !$globalVA) && (!isset($globalIVAO) || !$globalIVAO) && (!isset($globalVATSIM) || !$globalVATSIM) && (!isset($globalphpVMS) || !$globalphpVMS)) echo "Owner are only updated every 15 days.\n"; |
|
76 | + } elseif (isset($globalDebug) && $globalDebug && (!isset($globalVA) || !$globalVA) && (!isset($globalIVAO) || !$globalIVAO) && (!isset($globalVATSIM) || !$globalVATSIM) && (!isset($globalphpVMS) || !$globalphpVMS)) { |
|
77 | + echo "Owner are only updated every 15 days.\n"; |
|
78 | + } |
|
68 | 79 | |
69 | 80 | if (isset($globalAccidents) && $globalAccidents && (!isset($globalVA) || !$globalVA) && (!isset($globalIVAO) || !$globalIVAO) && (!isset($globalVATSIM) || !$globalVATSIM) && (!isset($globalphpVMS) || !$globalphpVMS)) { |
70 | 81 | require_once(dirname(__FILE__).'/../require/class.Accident.php'); |
@@ -73,7 +84,9 @@ discard block |
||
73 | 84 | if ($Accident->check_last_accidents_update()) { |
74 | 85 | $Accident->download_update(); |
75 | 86 | $Accident->insert_last_accidents_update(); |
76 | - } else echo "Accidents are updated once a day.\n"; |
|
87 | + } else { |
|
88 | + echo "Accidents are updated once a day.\n"; |
|
89 | + } |
|
77 | 90 | } |
78 | 91 | |
79 | 92 | } |
@@ -86,15 +99,19 @@ discard block |
||
86 | 99 | if ($METAR->check_last_update()) { |
87 | 100 | $METAR->addMETARCycle(); |
88 | 101 | $METAR->insert_last_update(); |
89 | - } else echo "METAR are only updated every 30 minutes.\n"; |
|
90 | -} |
|
102 | + } else { |
|
103 | + echo "METAR are only updated every 30 minutes.\n"; |
|
104 | + } |
|
105 | + } |
|
91 | 106 | |
92 | 107 | if (isset($globalSchedules) && $globalSchedules && $update_db->check_last_schedules_update() && (!isset($globalVA) || !$globalVA) && (!isset($globalIVAO) || !$globalIVAO) && (!isset($globalVATSIM) || !$globalVATSIM) && (!isset($globalphpVMS) || !$globalphpVMS)) { |
93 | 108 | echo "Updating schedules..."; |
94 | 109 | //$update_db->update_oneworld(); |
95 | 110 | $update_db->update_skyteam(); |
96 | 111 | $update_db->insert_last_schedules_update(); |
97 | -} elseif (isset($globalDebug) && $globalDebug && isset($globalOwner) && $globalOwner && (!isset($globalVA) || !$globalVA) && (!isset($globalIVAO) || !$globalIVAO) && (!isset($globalVATSIM) || !$globalVATSIM) && (!isset($globalphpVMS) || !$globalphpVMS)) echo "Schedules are only updated every 15 days.\n"; |
|
112 | +} elseif (isset($globalDebug) && $globalDebug && isset($globalOwner) && $globalOwner && (!isset($globalVA) || !$globalVA) && (!isset($globalIVAO) || !$globalIVAO) && (!isset($globalVATSIM) || !$globalVATSIM) && (!isset($globalphpVMS) || !$globalphpVMS)) { |
|
113 | + echo "Schedules are only updated every 15 days.\n"; |
|
114 | +} |
|
98 | 115 | |
99 | 116 | if (isset($globalArchiveMonths) && $globalArchiveMonths > 0) { |
100 | 117 | echo "Updating statistics and archive old data..."; |