@@ -13,7 +13,7 @@ discard block |
||
| 13 | 13 | } else { |
| 14 | 14 | print '<option value="">All</option>'; |
| 15 | 15 | } |
| 16 | - foreach($airlines as $airline) { |
|
| 16 | + foreach ($airlines as $airline) { |
|
| 17 | 17 | if (isset($airline_icao) && $airline_icao == $airline['airline_icao']) { |
| 18 | 18 | print '<option value="'.$airline['airline_icao'].'" selected>'.$airline['airline_name'].'</option>'; |
| 19 | 19 | } else { |
@@ -28,7 +28,7 @@ discard block |
||
| 28 | 28 | <div class="sub-menu sub-menu-container"> |
| 29 | 29 | <ul class="nav"> |
| 30 | 30 | <li class="dropdown"> |
| 31 | - <a class="dropdown-toggle <?php if(strtolower($current_page) == "statistics-aircraft" || strtolower($current_page) == "statistics-registration" || strtolower($current_page) == "statistics-manufacturer"){ print 'active'; } ?>" data-toggle="dropdown" href="#" > |
|
| 31 | + <a class="dropdown-toggle <?php if (strtolower($current_page) == "statistics-aircraft" || strtolower($current_page) == "statistics-registration" || strtolower($current_page) == "statistics-manufacturer") { print 'active'; } ?>" data-toggle="dropdown" href="#" > |
|
| 32 | 32 | <?php echo _("Aircraft"); ?> <span class="caret"></span> |
| 33 | 33 | </a> |
| 34 | 34 | <ul class="dropdown-menu"> |
@@ -39,7 +39,7 @@ discard block |
||
| 39 | 39 | </ul> |
| 40 | 40 | </li> |
| 41 | 41 | <li class="dropdown"> |
| 42 | - <a class="dropdown-toggle <?php if(strtolower($current_page) == "statistics-airline" || strtolower($current_page) == "statistics-airline-country" || strtolower($current_page) == "statistics-callsign"){ print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
| 42 | + <a class="dropdown-toggle <?php if (strtolower($current_page) == "statistics-airline" || strtolower($current_page) == "statistics-airline-country" || strtolower($current_page) == "statistics-callsign") { print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
| 43 | 43 | <?php echo _("Airline"); ?> <span class="caret"></span> |
| 44 | 44 | </a> |
| 45 | 45 | <ul class="dropdown-menu" role="menu"> |
@@ -49,7 +49,7 @@ discard block |
||
| 49 | 49 | </ul> |
| 50 | 50 | </li> |
| 51 | 51 | <li class="dropdown"> |
| 52 | - <a class="dropdown-toggle <?php if(strtolower($current_page) == "statistics-airport-departure" || strtolower($current_page) == "statistics-airport-departure-country" || strtolower($current_page) == "statistics-airport-arrival" || strtolower($current_page) == "statistics-airport-arrival-country"){ print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
| 52 | + <a class="dropdown-toggle <?php if (strtolower($current_page) == "statistics-airport-departure" || strtolower($current_page) == "statistics-airport-departure-country" || strtolower($current_page) == "statistics-airport-arrival" || strtolower($current_page) == "statistics-airport-arrival-country") { print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
| 53 | 53 | <?php echo _("Airport"); ?> <span class="caret"></span> |
| 54 | 54 | </a> |
| 55 | 55 | <ul class="dropdown-menu" role="menu"> |
@@ -60,7 +60,7 @@ discard block |
||
| 60 | 60 | </ul> |
| 61 | 61 | </li> |
| 62 | 62 | <li class="dropdown"> |
| 63 | - <a class="dropdown-toggle <?php if(strtolower($current_page) == "statistics-route-airport" || strtolower($current_page) == "statistics-route-waypoint"){ print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
| 63 | + <a class="dropdown-toggle <?php if (strtolower($current_page) == "statistics-route-airport" || strtolower($current_page) == "statistics-route-waypoint") { print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
| 64 | 64 | <?php echo _("Route"); ?> <span class="caret"></span> |
| 65 | 65 | </a> |
| 66 | 66 | <ul class="dropdown-menu" role="menu"> |
@@ -69,7 +69,7 @@ discard block |
||
| 69 | 69 | </ul> |
| 70 | 70 | </li> |
| 71 | 71 | <li class="dropdown"> |
| 72 | - <a class="dropdown-toggle <?php if(strtolower($current_page) == "statistics-date" || strtolower($current_page) == "statistics-time"){ print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
| 72 | + <a class="dropdown-toggle <?php if (strtolower($current_page) == "statistics-date" || strtolower($current_page) == "statistics-time") { print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
| 73 | 73 | <?php echo _("Date & Time"); ?> <span class="caret"></span> |
| 74 | 74 | </a> |
| 75 | 75 | <ul class="dropdown-menu" role="menu"> |
@@ -7,7 +7,7 @@ |
||
| 7 | 7 | <button type="button" class="close">×</button> |
| 8 | 8 | <?php |
| 9 | 9 | |
| 10 | -$notamref = filter_input(INPUT_GET,'notam',FILTER_SANITIZE_STRING); |
|
| 10 | +$notamref = filter_input(INPUT_GET, 'notam', FILTER_SANITIZE_STRING); |
|
| 11 | 11 | $notamref = urldecode($notamref); |
| 12 | 12 | $NOTAM = new NOTAM(); |
| 13 | 13 | $notam = $NOTAM->getNOTAMbyRef($notamref); |
@@ -982,19 +982,19 @@ discard block |
||
| 982 | 982 | try { |
| 983 | 983 | $sth = $this->db->prepare($query); |
| 984 | 984 | $sth->execute($query_values); |
| 985 | - } catch(PDOException $e) { |
|
| 985 | + } catch (PDOException $e) { |
|
| 986 | 986 | echo "error : ".$e->getMessage(); |
| 987 | 987 | } |
| 988 | 988 | $all = $sth->fetchAll(PDO::FETCH_ASSOC); |
| 989 | 989 | return $all; |
| 990 | 990 | } |
| 991 | 991 | public function getAllNOTAMtext() { |
| 992 | - $query = 'SELECT full_notam FROM notam'; |
|
| 992 | + $query = 'SELECT full_notam FROM notam'; |
|
| 993 | 993 | $query_values = array(); |
| 994 | 994 | try { |
| 995 | 995 | $sth = $this->db->prepare($query); |
| 996 | 996 | $sth->execute($query_values); |
| 997 | - } catch(PDOException $e) { |
|
| 997 | + } catch (PDOException $e) { |
|
| 998 | 998 | echo "error : ".$e->getMessage(); |
| 999 | 999 | } |
| 1000 | 1000 | $all = $sth->fetchAll(PDO::FETCH_ASSOC); |
@@ -1003,13 +1003,13 @@ discard block |
||
| 1003 | 1003 | public function createNOTAMtextFile($filename) { |
| 1004 | 1004 | $allnotam_result = $this->getAllNOTAMtext(); |
| 1005 | 1005 | $notamtext = ''; |
| 1006 | - foreach($allnotam_result as $notam) { |
|
| 1006 | + foreach ($allnotam_result as $notam) { |
|
| 1007 | 1007 | $notamtext .= '%%'."\n"; |
| 1008 | 1008 | $notamtext .= $notam['full_notam']; |
| 1009 | 1009 | $notamtext .= "\n".'%%'."\n"; |
| 1010 | 1010 | } |
| 1011 | 1011 | //$allnotam = implode('\n%%%%\n',$allnotam_result); |
| 1012 | - file_put_contents($filename,$notamtext); |
|
| 1012 | + file_put_contents($filename, $notamtext); |
|
| 1013 | 1013 | } |
| 1014 | 1014 | public function parseNOTAMtextFile($filename) { |
| 1015 | 1015 | $data = file_get_contents($filename); |
@@ -1030,7 +1030,7 @@ discard block |
||
| 1030 | 1030 | try { |
| 1031 | 1031 | $sth = $this->db->prepare($query); |
| 1032 | 1032 | $sth->execute($query_values); |
| 1033 | - } catch(PDOException $e) { |
|
| 1033 | + } catch (PDOException $e) { |
|
| 1034 | 1034 | echo "error : ".$e->getMessage(); |
| 1035 | 1035 | } |
| 1036 | 1036 | $all = $sth->fetchAll(PDO::FETCH_ASSOC); |
@@ -1039,10 +1039,10 @@ discard block |
||
| 1039 | 1039 | public function getAllNOTAMbyCoord($coord) { |
| 1040 | 1040 | global $globalDBdriver; |
| 1041 | 1041 | if (is_array($coord)) { |
| 1042 | - $minlong = filter_var($coord[0],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
| 1043 | - $minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
| 1044 | - $maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
| 1045 | - $maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
| 1042 | + $minlong = filter_var($coord[0], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
| 1043 | + $minlat = filter_var($coord[1], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
| 1044 | + $maxlong = filter_var($coord[2], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
| 1045 | + $maxlat = filter_var($coord[3], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
| 1046 | 1046 | } else return array(); |
| 1047 | 1047 | if ($globalDBdriver == 'mysql') { |
| 1048 | 1048 | $query = 'SELECT * FROM notam WHERE center_latitude BETWEEN '.$minlat.' AND '.$maxlat.' AND center_longitude BETWEEN '.$minlong.' AND '.$maxlong.' AND radius > 0 AND date_end > UTC_TIMESTAMP() AND date_begin < UTC_TIMESTAMP()'; |
@@ -1054,19 +1054,19 @@ discard block |
||
| 1054 | 1054 | try { |
| 1055 | 1055 | $sth = $this->db->prepare($query); |
| 1056 | 1056 | $sth->execute($query_values); |
| 1057 | - } catch(PDOException $e) { |
|
| 1057 | + } catch (PDOException $e) { |
|
| 1058 | 1058 | echo "error : ".$e->getMessage(); |
| 1059 | 1059 | } |
| 1060 | 1060 | $all = $sth->fetchAll(PDO::FETCH_ASSOC); |
| 1061 | 1061 | return $all; |
| 1062 | 1062 | } |
| 1063 | - public function getAllNOTAMbyCoordScope($coord,$scope) { |
|
| 1063 | + public function getAllNOTAMbyCoordScope($coord, $scope) { |
|
| 1064 | 1064 | global $globalDBdriver; |
| 1065 | 1065 | if (is_array($coord)) { |
| 1066 | - $minlong = filter_var($coord[0],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
| 1067 | - $minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
| 1068 | - $maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
| 1069 | - $maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
| 1066 | + $minlong = filter_var($coord[0], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
| 1067 | + $minlat = filter_var($coord[1], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
| 1068 | + $maxlong = filter_var($coord[2], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
| 1069 | + $maxlat = filter_var($coord[3], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
| 1070 | 1070 | } else return array(); |
| 1071 | 1071 | if ($globalDBdriver == 'mysql') { |
| 1072 | 1072 | $query = 'SELECT * FROM notam WHERE center_latitude BETWEEN '.$minlat.' AND '.$maxlat.' AND center_longitude BETWEEN '.$minlong.' AND '.$maxlong.' AND radius > 0 AND date_end > UTC_TIMESTAMP() AND date_begin < UTC_TIMESTAMP() AND scope = :scope'; |
@@ -1078,7 +1078,7 @@ discard block |
||
| 1078 | 1078 | try { |
| 1079 | 1079 | $sth = $this->db->prepare($query); |
| 1080 | 1080 | $sth->execute($query_values); |
| 1081 | - } catch(PDOException $e) { |
|
| 1081 | + } catch (PDOException $e) { |
|
| 1082 | 1082 | echo "error : ".$e->getMessage(); |
| 1083 | 1083 | } |
| 1084 | 1084 | $all = $sth->fetchAll(PDO::FETCH_ASSOC); |
@@ -1090,7 +1090,7 @@ discard block |
||
| 1090 | 1090 | try { |
| 1091 | 1091 | $sth = $this->db->prepare($query); |
| 1092 | 1092 | $sth->execute($query_values); |
| 1093 | - } catch(PDOException $e) { |
|
| 1093 | + } catch (PDOException $e) { |
|
| 1094 | 1094 | return "error : ".$e->getMessage(); |
| 1095 | 1095 | } |
| 1096 | 1096 | $all = $sth->fetchAll(PDO::FETCH_ASSOC); |
@@ -1098,13 +1098,13 @@ discard block |
||
| 1098 | 1098 | else return array(); |
| 1099 | 1099 | } |
| 1100 | 1100 | |
| 1101 | - public function addNOTAM($ref,$title,$type,$fir,$code,$rules,$scope,$lower_limit,$upper_limit,$center_latitude,$center_longitude,$radius,$date_begin,$date_end,$permanent,$text,$full_notam) { |
|
| 1101 | + public function addNOTAM($ref, $title, $type, $fir, $code, $rules, $scope, $lower_limit, $upper_limit, $center_latitude, $center_longitude, $radius, $date_begin, $date_end, $permanent, $text, $full_notam) { |
|
| 1102 | 1102 | $query = "INSERT INTO notam (ref,title,notam_type,fir,code,rules,scope,lower_limit,upper_limit,center_latitude,center_longitude,radius,date_begin,date_end,permanent,notam_text,full_notam) VALUES (:ref,:title,:type,:fir,:code,:rules,:scope,:lower_limit,:upper_limit,:center_latitude,:center_longitude,:radius,:date_begin,:date_end,:permanent,:text,:full_notam)"; |
| 1103 | - $query_values = array(':ref' => $ref,':title' => $title,':type' => $type,':fir' => $fir,':code' => $code,':rules' => $rules,':scope' => $scope,':lower_limit' => $lower_limit,':upper_limit' => $upper_limit,':center_latitude' => $center_latitude,':center_longitude' => $center_longitude,':radius' => $radius,':date_begin' => $date_begin,':date_end' => $date_end,':permanent' => $permanent,':text' => $text,':full_notam' => $full_notam); |
|
| 1103 | + $query_values = array(':ref' => $ref, ':title' => $title, ':type' => $type, ':fir' => $fir, ':code' => $code, ':rules' => $rules, ':scope' => $scope, ':lower_limit' => $lower_limit, ':upper_limit' => $upper_limit, ':center_latitude' => $center_latitude, ':center_longitude' => $center_longitude, ':radius' => $radius, ':date_begin' => $date_begin, ':date_end' => $date_end, ':permanent' => $permanent, ':text' => $text, ':full_notam' => $full_notam); |
|
| 1104 | 1104 | try { |
| 1105 | 1105 | $sth = $this->db->prepare($query); |
| 1106 | 1106 | $sth->execute($query_values); |
| 1107 | - } catch(PDOException $e) { |
|
| 1107 | + } catch (PDOException $e) { |
|
| 1108 | 1108 | return "error : ".$e->getMessage(); |
| 1109 | 1109 | } |
| 1110 | 1110 | } |
@@ -1115,7 +1115,7 @@ discard block |
||
| 1115 | 1115 | try { |
| 1116 | 1116 | $sth = $this->db->prepare($query); |
| 1117 | 1117 | $sth->execute($query_values); |
| 1118 | - } catch(PDOException $e) { |
|
| 1118 | + } catch (PDOException $e) { |
|
| 1119 | 1119 | return "error : ".$e->getMessage(); |
| 1120 | 1120 | } |
| 1121 | 1121 | } |
@@ -1130,7 +1130,7 @@ discard block |
||
| 1130 | 1130 | try { |
| 1131 | 1131 | $sth = $this->db->prepare($query); |
| 1132 | 1132 | $sth->execute($query_values); |
| 1133 | - } catch(PDOException $e) { |
|
| 1133 | + } catch (PDOException $e) { |
|
| 1134 | 1134 | return "error : ".$e->getMessage(); |
| 1135 | 1135 | } |
| 1136 | 1136 | } |
@@ -1140,7 +1140,7 @@ discard block |
||
| 1140 | 1140 | try { |
| 1141 | 1141 | $sth = $this->db->prepare($query); |
| 1142 | 1142 | $sth->execute($query_values); |
| 1143 | - } catch(PDOException $e) { |
|
| 1143 | + } catch (PDOException $e) { |
|
| 1144 | 1144 | return "error : ".$e->getMessage(); |
| 1145 | 1145 | } |
| 1146 | 1146 | } |
@@ -1149,7 +1149,7 @@ discard block |
||
| 1149 | 1149 | try { |
| 1150 | 1150 | $sth = $this->db->prepare($query); |
| 1151 | 1151 | $sth->execute(); |
| 1152 | - } catch(PDOException $e) { |
|
| 1152 | + } catch (PDOException $e) { |
|
| 1153 | 1153 | return "error : ".$e->getMessage(); |
| 1154 | 1154 | } |
| 1155 | 1155 | } |
@@ -1158,7 +1158,7 @@ discard block |
||
| 1158 | 1158 | try { |
| 1159 | 1159 | $sth = $this->db->prepare($query); |
| 1160 | 1160 | $sth->execute(); |
| 1161 | - } catch(PDOException $e) { |
|
| 1161 | + } catch (PDOException $e) { |
|
| 1162 | 1162 | return "error : ".$e->getMessage(); |
| 1163 | 1163 | } |
| 1164 | 1164 | } |
@@ -1166,14 +1166,14 @@ discard block |
||
| 1166 | 1166 | public function updateNOTAM() { |
| 1167 | 1167 | global $globalNOTAMAirports; |
| 1168 | 1168 | if (isset($globalNOTAMAirports) && is_array($globalNOTAMAirports) && count($globalNOTAMAirports) > 0) { |
| 1169 | - foreach (array_chunk($globalNOTAMAirports,10) as $airport) { |
|
| 1170 | - $airport_icao = implode(',',$airport); |
|
| 1169 | + foreach (array_chunk($globalNOTAMAirports, 10) as $airport) { |
|
| 1170 | + $airport_icao = implode(',', $airport); |
|
| 1171 | 1171 | $alldata = $this->downloadNOTAM($airport_icao); |
| 1172 | 1172 | if (count($alldata) > 0) { |
| 1173 | 1173 | foreach ($alldata as $initial_data) { |
| 1174 | 1174 | $data = $this->parse($initial_data); |
| 1175 | 1175 | $notamref = $this->getNOTAMbyRef($data['ref']); |
| 1176 | - if (count($notamref) == 0) $this->addNOTAM($data['ref'],$data['title'],'',$data['fir'],$data['code'],'',$data['scope'],$data['lower_limit'],$data['upper_limit'],$data['latitude'],$data['longitude'],$data['radius'],$data['date_begin'],$data['date_end'],$data['permanent'],$data['text'],$data['full_notam']); |
|
| 1176 | + if (count($notamref) == 0) $this->addNOTAM($data['ref'], $data['title'], '', $data['fir'], $data['code'], '', $data['scope'], $data['lower_limit'], $data['upper_limit'], $data['latitude'], $data['longitude'], $data['radius'], $data['date_begin'], $data['date_end'], $data['permanent'], $data['text'], $data['full_notam']); |
|
| 1177 | 1177 | } |
| 1178 | 1178 | } |
| 1179 | 1179 | } |
@@ -1186,7 +1186,7 @@ discard block |
||
| 1186 | 1186 | foreach ($alldata as $initial_data) { |
| 1187 | 1187 | $data = $this->parse($initial_data); |
| 1188 | 1188 | $notamref = $this->getNOTAMbyRef($data['ref']); |
| 1189 | - if (!isset($notamref['notam_id'])) $this->addNOTAM($data['ref'],$data['title'],'',$data['fir'],$data['code'],'',$data['scope'],$data['lower_limit'],$data['upper_limit'],$data['latitude'],$data['longitude'],$data['radius'],$data['date_begin'],$data['date_end'],$data['permanent'],$data['text'],$data['full_notam']); |
|
| 1189 | + if (!isset($notamref['notam_id'])) $this->addNOTAM($data['ref'], $data['title'], '', $data['fir'], $data['code'], '', $data['scope'], $data['lower_limit'], $data['upper_limit'], $data['latitude'], $data['longitude'], $data['radius'], $data['date_begin'], $data['date_end'], $data['permanent'], $data['text'], $data['full_notam']); |
|
| 1190 | 1190 | } |
| 1191 | 1191 | } |
| 1192 | 1192 | } |
@@ -1195,12 +1195,12 @@ discard block |
||
| 1195 | 1195 | global $globalTransaction; |
| 1196 | 1196 | $Spotter = new Spotter(); |
| 1197 | 1197 | $allairports = $Spotter->getAllAirportInfo(); |
| 1198 | - foreach (array_chunk($allairports,20) as $airport) { |
|
| 1198 | + foreach (array_chunk($allairports, 20) as $airport) { |
|
| 1199 | 1199 | $airports_icao = array(); |
| 1200 | - foreach($airport as $icao) { |
|
| 1200 | + foreach ($airport as $icao) { |
|
| 1201 | 1201 | if (isset($icao['icao'])) $airports_icao[] = $icao['icao']; |
| 1202 | 1202 | } |
| 1203 | - $airport_icao = implode(',',$airports_icao); |
|
| 1203 | + $airport_icao = implode(',', $airports_icao); |
|
| 1204 | 1204 | $alldata = $this->downloadNOTAM($airport_icao); |
| 1205 | 1205 | if ($globalTransaction) $this->db->beginTransaction(); |
| 1206 | 1206 | if (count($alldata) > 0) { |
@@ -1213,7 +1213,7 @@ discard block |
||
| 1213 | 1213 | if (count($notamref) == 0) { |
| 1214 | 1214 | if (isset($data['ref_replaced'])) $this->deleteNOTAMbyRef($data['ref_replaced']); |
| 1215 | 1215 | if (isset($data['ref_cancelled'])) $this->deleteNOTAMbyRef($data['ref_cancelled']); |
| 1216 | - elseif (isset($data['latitude']) && isset($data['scope']) && isset($data['text']) && isset($data['permanent'])) echo $this->addNOTAM($data['ref'],'','',$data['fir'],$data['code'],'',$data['scope'],$data['lower_limit'],$data['upper_limit'],$data['latitude'],$data['longitude'],$data['radius'],$data['date_begin'],$data['date_end'],$data['permanent'],$data['text'],$data['full_notam']); |
|
| 1216 | + elseif (isset($data['latitude']) && isset($data['scope']) && isset($data['text']) && isset($data['permanent'])) echo $this->addNOTAM($data['ref'], '', '', $data['fir'], $data['code'], '', $data['scope'], $data['lower_limit'], $data['upper_limit'], $data['latitude'], $data['longitude'], $data['radius'], $data['date_begin'], $data['date_end'], $data['permanent'], $data['text'], $data['full_notam']); |
|
| 1217 | 1217 | } |
| 1218 | 1218 | } |
| 1219 | 1219 | } |
@@ -1227,7 +1227,7 @@ discard block |
||
| 1227 | 1227 | date_default_timezone_set("UTC"); |
| 1228 | 1228 | $Common = new Common(); |
| 1229 | 1229 | //$url = str_replace('{icao}',$icao,'https://pilotweb.nas.faa.gov/PilotWeb/notamRetrievalByICAOAction.do?method=displayByICAOs&reportType=RAW&formatType=DOMESTIC&retrieveLocId={icao}&actionType=notamRetrievalByICAOs'); |
| 1230 | - $url = str_replace('{icao}',$icao,'https://pilotweb.nas.faa.gov/PilotWeb/notamRetrievalByICAOAction.do?method=displayByICAOs&reportType=RAW&formatType=ICAO&retrieveLocId={icao}&actionType=notamRetrievalByICAOs'); |
|
| 1230 | + $url = str_replace('{icao}', $icao, 'https://pilotweb.nas.faa.gov/PilotWeb/notamRetrievalByICAOAction.do?method=displayByICAOs&reportType=RAW&formatType=ICAO&retrieveLocId={icao}&actionType=notamRetrievalByICAOs'); |
|
| 1231 | 1231 | $data = $Common->getData($url); |
| 1232 | 1232 | preg_match_all("/<pre>(.+?)<\/pre>/is", $data, $matches); |
| 1233 | 1233 | //print_r($matches); |
@@ -1239,14 +1239,14 @@ discard block |
||
| 1239 | 1239 | $Common = new Common(); |
| 1240 | 1240 | $result = array(); |
| 1241 | 1241 | $result['full_notam'] = $data; |
| 1242 | - $data = str_ireplace(array("\r","\n",'\r','\n'),' ',$data); |
|
| 1243 | - $data = preg_split('#(?=([A-Z]\)\s))#',$data); |
|
| 1242 | + $data = str_ireplace(array("\r", "\n", '\r', '\n'), ' ', $data); |
|
| 1243 | + $data = preg_split('#(?=([A-Z]\)\s))#', $data); |
|
| 1244 | 1244 | //print_r($data); |
| 1245 | 1245 | foreach ($data as $line) { |
| 1246 | 1246 | $line = trim($line); |
| 1247 | - if (preg_match('#Q\) (.*)#',$line,$matches)) { |
|
| 1248 | - $line = str_replace(' ','',$line); |
|
| 1249 | - if (preg_match('#Q\)([A-Z]{4})\/([A-Z]{5})\/(IV|I|V)\/([A-Z]{1,3})\/([A-Z]{1,2})\/([0-9]{3})\/([0-9]{3})\/([0-9]{4})(N|S)([0-9]{5})(E|W)([0-9]{3})#',$line,$matches)) { |
|
| 1247 | + if (preg_match('#Q\) (.*)#', $line, $matches)) { |
|
| 1248 | + $line = str_replace(' ', '', $line); |
|
| 1249 | + if (preg_match('#Q\)([A-Z]{4})\/([A-Z]{5})\/(IV|I|V)\/([A-Z]{1,3})\/([A-Z]{1,2})\/([0-9]{3})\/([0-9]{3})\/([0-9]{4})(N|S)([0-9]{5})(E|W)([0-9]{3})#', $line, $matches)) { |
|
| 1250 | 1250 | //if (preg_match('#Q\)([A-Z]{4})\/([A-Z]{5})\/(IV|I|V)\/([A-Z]{1,3})\/([A-Z]{1,2})\/([0-9]{3})\/([0-9]{3})\/([0-9]{4})(N|S)([0-9]{5})(E|W)([0-9]{3})#',$line,$matches)) { |
| 1251 | 1251 | //print_r($matches); |
| 1252 | 1252 | $result['fir'] = $matches[1]; |
@@ -1292,30 +1292,30 @@ discard block |
||
| 1292 | 1292 | elseif ($matches[5] == 'AW') $result['scope'] = 'Airport/Navigation warning'; |
| 1293 | 1293 | $result['lower_limit'] = $matches[6]; |
| 1294 | 1294 | $result['upper_limit'] = $matches[7]; |
| 1295 | - $latitude = $Common->convertDec($matches[8],'latitude'); |
|
| 1295 | + $latitude = $Common->convertDec($matches[8], 'latitude'); |
|
| 1296 | 1296 | if ($matches[9] == 'S') $latitude = -$latitude; |
| 1297 | - $longitude = $Common->convertDec($matches[10],'longitude'); |
|
| 1297 | + $longitude = $Common->convertDec($matches[10], 'longitude'); |
|
| 1298 | 1298 | if ($matches[11] == 'W') $longitude = -$longitude; |
| 1299 | 1299 | $result['latitude'] = $latitude; |
| 1300 | 1300 | $result['longitude'] = $longitude; |
| 1301 | 1301 | $result['radius'] = intval($matches[12]); |
| 1302 | 1302 | } else echo 'ERROR : '.$line."\n"; |
| 1303 | 1303 | } |
| 1304 | - elseif (preg_match('#A\) (.*)#',$line,$matches)) { |
|
| 1304 | + elseif (preg_match('#A\) (.*)#', $line, $matches)) { |
|
| 1305 | 1305 | $result['icao'] = $matches[1]; |
| 1306 | 1306 | } |
| 1307 | - elseif (preg_match('#B\) ([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})#',$line,$matches)) { |
|
| 1307 | + elseif (preg_match('#B\) ([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})#', $line, $matches)) { |
|
| 1308 | 1308 | if ($matches[1] > 50) $year = '19'.$matches[1]; |
| 1309 | 1309 | else $year = '20'.$matches[1]; |
| 1310 | 1310 | $result['date_begin'] = $year.'/'.$matches[2].'/'.$matches[3].' '.$matches[4].':'.$matches[5]; |
| 1311 | 1311 | } |
| 1312 | - elseif (preg_match('#C\) ([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})$#',$line,$matches)) { |
|
| 1312 | + elseif (preg_match('#C\) ([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})$#', $line, $matches)) { |
|
| 1313 | 1313 | if ($matches[1] > 50) $year = '19'.$matches[1]; |
| 1314 | 1314 | else $year = '20'.$matches[1]; |
| 1315 | 1315 | $result['date_end'] = $year.'/'.$matches[2].'/'.$matches[3].' '.$matches[4].':'.$matches[5]; |
| 1316 | 1316 | $result['permanent'] = 0; |
| 1317 | 1317 | } |
| 1318 | - elseif (preg_match('#C\) ([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2}) (EST|PERM)$#',$line,$matches)) { |
|
| 1318 | + elseif (preg_match('#C\) ([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2}) (EST|PERM)$#', $line, $matches)) { |
|
| 1319 | 1319 | if ($matches[1] > 50) $year = '19'.$matches[1]; |
| 1320 | 1320 | else $year = '20'.$matches[1]; |
| 1321 | 1321 | $result['date_end'] = $year.'/'.$matches[2].'/'.$matches[3].' '.$matches[4].':'.$matches[5]; |
@@ -1324,26 +1324,26 @@ discard block |
||
| 1324 | 1324 | if ($matches[6] == 'PERM') $result['permanent'] = 1; |
| 1325 | 1325 | else $result['permanent'] = 0; |
| 1326 | 1326 | } |
| 1327 | - elseif (preg_match('#C\) (EST|PERM)$#',$line,$matches)) { |
|
| 1327 | + elseif (preg_match('#C\) (EST|PERM)$#', $line, $matches)) { |
|
| 1328 | 1328 | $result['date_end'] = '2030/12/20 12:00'; |
| 1329 | 1329 | if ($matches[1] == 'EST') $result['estimated'] = 1; |
| 1330 | 1330 | else $result['estimated'] = 0; |
| 1331 | 1331 | if ($matches[1] == 'PERM') $result['permanent'] = 1; |
| 1332 | 1332 | else $result['permanent'] = 0; |
| 1333 | 1333 | } |
| 1334 | - elseif (preg_match('#E\) (.*)#',$line,$matches)) { |
|
| 1334 | + elseif (preg_match('#E\) (.*)#', $line, $matches)) { |
|
| 1335 | 1335 | $rtext = array(); |
| 1336 | - $text = explode(' ',$matches[1]); |
|
| 1336 | + $text = explode(' ', $matches[1]); |
|
| 1337 | 1337 | foreach ($text as $word) { |
| 1338 | 1338 | if (isset($this->abbr[$word])) $rtext[] = strtoupper($this->abbr[$word]); |
| 1339 | - elseif (ctype_digit(strval(substr($word,3))) && isset($this->abbr[substr($word,0,3)])) $rtext[] = strtoupper($this->abbr[substr($word,0,3)]).' '.substr($word,3); |
|
| 1339 | + elseif (ctype_digit(strval(substr($word, 3))) && isset($this->abbr[substr($word, 0, 3)])) $rtext[] = strtoupper($this->abbr[substr($word, 0, 3)]).' '.substr($word, 3); |
|
| 1340 | 1340 | else $rtext[] = $word; |
| 1341 | 1341 | } |
| 1342 | - $result['text'] = implode(' ',$rtext); |
|
| 1342 | + $result['text'] = implode(' ', $rtext); |
|
| 1343 | 1343 | //} elseif (preg_match('#F\) (.*)#',$line,$matches)) { |
| 1344 | 1344 | //} elseif (preg_match('#G\) (.*)#',$line,$matches)) { |
| 1345 | - } elseif (preg_match('#(NOTAMN|NOTAMR|NOTAMC)#',$line,$matches)) { |
|
| 1346 | - $text = explode(' ',$line); |
|
| 1345 | + } elseif (preg_match('#(NOTAMN|NOTAMR|NOTAMC)#', $line, $matches)) { |
|
| 1346 | + $text = explode(' ', $line); |
|
| 1347 | 1347 | $result['ref'] = $text[0]; |
| 1348 | 1348 | if ($matches[1] == 'NOTAMN') $result['type'] = 'new'; |
| 1349 | 1349 | if ($matches[1] == 'NOTAMC') { |
@@ -10,24 +10,24 @@ discard block |
||
| 10 | 10 | |
| 11 | 11 | if (isset($_GET['coord'])) |
| 12 | 12 | { |
| 13 | - $coords = explode(',',$_GET['coord']); |
|
| 13 | + $coords = explode(',', $_GET['coord']); |
|
| 14 | 14 | if (isset($_COOKIE['notamscope']) && $_COOKIE['notamscope'] != '' && $_COOKIE['notamscope'] != 'All') { |
| 15 | - $scope = filter_var($_COOOKIE['notamscope'],FILTER_SANITIZE_STRING); |
|
| 16 | - $spotter_array = $NOTAM->getAllNOTAMbyCoordScope($coords,$scope); |
|
| 15 | + $scope = filter_var($_COOOKIE['notamscope'], FILTER_SANITIZE_STRING); |
|
| 16 | + $spotter_array = $NOTAM->getAllNOTAMbyCoordScope($coords, $scope); |
|
| 17 | 17 | } elseif (isset($_GET['scope']) && $_GET['scope'] != '' && $_GET['scope'] != 'All') { |
| 18 | - $scope = filter_input(INPUT_GET,'scope',FILTER_SANITIZE_STRING); |
|
| 19 | - $spotter_array = $NOTAM->getAllNOTAMbyCoordScope($coords,$scope); |
|
| 18 | + $scope = filter_input(INPUT_GET, 'scope', FILTER_SANITIZE_STRING); |
|
| 19 | + $spotter_array = $NOTAM->getAllNOTAMbyCoordScope($coords, $scope); |
|
| 20 | 20 | } else { |
| 21 | 21 | $spotter_array = $NOTAM->getAllNOTAMbyCoord($coords); |
| 22 | 22 | } |
| 23 | 23 | // $spotter_array = $NOTAM->getAllNOTAM(); |
| 24 | 24 | } else { |
| 25 | 25 | if (isset($_COOKIE['notamscope']) && $_COOKIE['notamscope'] != '' && $_COOKIE['notamscope'] != 'All') { |
| 26 | - $scope = filter_var($_COOKIE['notamscope'],FILTER_SANITIZE_STRING); |
|
| 26 | + $scope = filter_var($_COOKIE['notamscope'], FILTER_SANITIZE_STRING); |
|
| 27 | 27 | $spotter_array = $NOTAM->getAllNOTAMbyScope($scope); |
| 28 | 28 | } elseif (isset($_GET['scope']) && $_GET['scope'] != '' && $_GET['scope'] != 'All') { |
| 29 | - $scope = filter_input(INPUT_GET,'scope',FILTER_SANITIZE_STRING); |
|
| 30 | - $spotter_array = $NOTAM->getAllNOTAMbyCoordScope($coords,$scope); |
|
| 29 | + $scope = filter_input(INPUT_GET, 'scope', FILTER_SANITIZE_STRING); |
|
| 30 | + $spotter_array = $NOTAM->getAllNOTAMbyCoordScope($coords, $scope); |
|
| 31 | 31 | } else { |
| 32 | 32 | $spotter_array = $NOTAM->getAllNOTAM(); |
| 33 | 33 | } |
@@ -37,7 +37,7 @@ discard block |
||
| 37 | 37 | |
| 38 | 38 | if (!empty($spotter_array)) |
| 39 | 39 | { |
| 40 | - foreach($spotter_array as $spotter_item) |
|
| 40 | + foreach ($spotter_array as $spotter_item) |
|
| 41 | 41 | { |
| 42 | 42 | date_default_timezone_set('UTC'); |
| 43 | 43 | //waypoint plotting |
@@ -46,7 +46,7 @@ discard block |
||
| 46 | 46 | $output .= '"ref": "'.$spotter_item['ref'].'",'; |
| 47 | 47 | $output .= '"title": "'.$spotter_item['title'].'",'; |
| 48 | 48 | $output .= '"fir": "'.$spotter_item['fir'].'",'; |
| 49 | - $output .= '"text": "'.str_replace(array("\r\n", "\r", "\n"),'<br />',str_replace(array('"',"\t"), '',$spotter_item['notam_text'])).'",'; |
|
| 49 | + $output .= '"text": "'.str_replace(array("\r\n", "\r", "\n"), '<br />', str_replace(array('"', "\t"), '', $spotter_item['notam_text'])).'",'; |
|
| 50 | 50 | $output .= '"latitude": '.$spotter_item['center_latitude'].','; |
| 51 | 51 | $output .= '"longitude": '.$spotter_item['center_longitude'].','; |
| 52 | 52 | $output .= '"lower_limit": '.$spotter_item['lower_limit'].','; |
@@ -85,7 +85,7 @@ discard block |
||
| 85 | 85 | $output .= '}'; |
| 86 | 86 | $output .= '},'; |
| 87 | 87 | } |
| 88 | - $output = substr($output, 0, -1); |
|
| 88 | + $output = substr($output, 0, -1); |
|
| 89 | 89 | } |
| 90 | 90 | $output .= ']}'; |
| 91 | 91 | |
@@ -10,7 +10,7 @@ discard block |
||
| 10 | 10 | |
| 11 | 11 | if (isset($_GET['coord'])) |
| 12 | 12 | { |
| 13 | - $coords = explode(',',$_GET['coord']); |
|
| 13 | + $coords = explode(',', $_GET['coord']); |
|
| 14 | 14 | $spotter_array = $Spotter->getAllWaypointsInfobyCoord($coords); |
| 15 | 15 | } else { |
| 16 | 16 | die; |
@@ -21,7 +21,7 @@ discard block |
||
| 21 | 21 | if (!empty($spotter_array)) |
| 22 | 22 | { |
| 23 | 23 | // print_r($spotter_array); |
| 24 | - foreach($spotter_array as $spotter_item) |
|
| 24 | + foreach ($spotter_array as $spotter_item) |
|
| 25 | 25 | { |
| 26 | 26 | date_default_timezone_set('UTC'); |
| 27 | 27 | //waypoint plotting |
@@ -102,7 +102,7 @@ discard block |
||
| 102 | 102 | $output .= '"geometry": {'; |
| 103 | 103 | $output .= '"type": "Point",'; |
| 104 | 104 | $output .= '"coordinates": ['; |
| 105 | - $output .= $spotter_item['longitude_begin'].', '.$spotter_item['latitude_begin'].', '.round($spotter_item['base']*100*0.3048);; |
|
| 105 | + $output .= $spotter_item['longitude_begin'].', '.$spotter_item['latitude_begin'].', '.round($spotter_item['base']*100*0.3048); ; |
|
| 106 | 106 | $output .= ']'; |
| 107 | 107 | $output .= '}'; |
| 108 | 108 | |
@@ -7,7 +7,7 @@ discard block |
||
| 7 | 7 | <button type="button" class="close">×</button> |
| 8 | 8 | <?php |
| 9 | 9 | |
| 10 | -$airspaceid = filter_input(INPUT_GET,'airspace',FILTER_SANITIZE_NUMBER_INT); |
|
| 10 | +$airspaceid = filter_input(INPUT_GET, 'airspace', FILTER_SANITIZE_NUMBER_INT); |
|
| 11 | 11 | //$notamref = urldecode($notamref); |
| 12 | 12 | if ($globalDBdriver == 'mysql') { |
| 13 | 13 | $query = "SELECT * FROM airspace WHERE ogr_fid = :id"; |
@@ -18,10 +18,10 @@ discard block |
||
| 18 | 18 | try { |
| 19 | 19 | $sth = $Connection->db->prepare($query); |
| 20 | 20 | $sth->execute(array(':id' => $airspaceid)); |
| 21 | -} catch(PDOException $e) { |
|
| 21 | +} catch (PDOException $e) { |
|
| 22 | 22 | echo "error"; |
| 23 | 23 | } |
| 24 | -$result=$sth->fetchAll(PDO::FETCH_ASSOC); |
|
| 24 | +$result = $sth->fetchAll(PDO::FETCH_ASSOC); |
|
| 25 | 25 | $airspace = $result[0]; |
| 26 | 26 | date_default_timezone_set('UTC'); |
| 27 | 27 | print '<div class="top">'; |
@@ -16,14 +16,14 @@ discard block |
||
| 16 | 16 | |
| 17 | 17 | if (isset($_GET['coord'])) |
| 18 | 18 | { |
| 19 | - $coords = explode(',',$_GET['coord']); |
|
| 19 | + $coords = explode(',', $_GET['coord']); |
|
| 20 | 20 | if ($globalDBdriver == 'mysql') { |
| 21 | 21 | $query = "SELECT *, ST_AsWKB(SHAPE) AS wkb FROM airspace WHERE ST_Intersects(SHAPE, ST_Envelope(linestring(point(:minlon,:minlat), point(:maxlon,:maxlat))))"; |
| 22 | 22 | try { |
| 23 | 23 | $sth = $Connection->db->prepare($query); |
| 24 | - $sth->execute(array(':minlon' => $coords[0],':minlat' => $coords[1],':maxlon' => $coords[2],':maxlat' => $coords[3])); |
|
| 24 | + $sth->execute(array(':minlon' => $coords[0], ':minlat' => $coords[1], ':maxlon' => $coords[2], ':maxlat' => $coords[3])); |
|
| 25 | 25 | //$sth->execute(); |
| 26 | - } catch(PDOException $e) { |
|
| 26 | + } catch (PDOException $e) { |
|
| 27 | 27 | echo "error"; |
| 28 | 28 | } |
| 29 | 29 | } else { |
@@ -32,7 +32,7 @@ discard block |
||
| 32 | 32 | $sth = $Connection->db->prepare($query); |
| 33 | 33 | //$sth->execute(array(':minlon' => $coords[0],':minlat' => $coords[1],':maxlon' => $coords[2],':maxlat' => $coords[3])); |
| 34 | 34 | $sth->execute(); |
| 35 | - } catch(PDOException $e) { |
|
| 35 | + } catch (PDOException $e) { |
|
| 36 | 36 | echo "error"; |
| 37 | 37 | } |
| 38 | 38 | } |
@@ -45,7 +45,7 @@ discard block |
||
| 45 | 45 | try { |
| 46 | 46 | $sth = $Connection->db->prepare($query); |
| 47 | 47 | $sth->execute(); |
| 48 | - } catch(PDOException $e) { |
|
| 48 | + } catch (PDOException $e) { |
|
| 49 | 49 | echo "error"; |
| 50 | 50 | } |
| 51 | 51 | } |
@@ -73,20 +73,20 @@ discard block |
||
| 73 | 73 | elseif (isset($properties['ogc_fid'])) $properties['id'] = $properties['ogc_fid']; |
| 74 | 74 | if (isset($properties['ceiling'])) $properties['tops'] = $properties['ceiling']; |
| 75 | 75 | if (isset($properties['floor'])) $properties['base'] = $properties['floor']; |
| 76 | - if (preg_match('/^FL(\s)*(?<alt>\d+)/',strtoupper($properties['tops']),$matches)) { |
|
| 76 | + if (preg_match('/^FL(\s)*(?<alt>\d+)/', strtoupper($properties['tops']), $matches)) { |
|
| 77 | 77 | $properties['upper_limit'] = round($matches['alt']*100*0.38048); |
| 78 | - } elseif (preg_match('/^(?<alt>\d+)(\s)*(FT|AGL|ALT|MSL)/',strtoupper($properties['tops']),$matches)) { |
|
| 78 | + } elseif (preg_match('/^(?<alt>\d+)(\s)*(FT|AGL|ALT|MSL)/', strtoupper($properties['tops']), $matches)) { |
|
| 79 | 79 | $properties['upper_limit'] = round($matches['alt']*0.38048); |
| 80 | - } elseif (preg_match('/^(?<alt>\d+)(\s)*M/',strtoupper($properties['tops']),$matches)) { |
|
| 80 | + } elseif (preg_match('/^(?<alt>\d+)(\s)*M/', strtoupper($properties['tops']), $matches)) { |
|
| 81 | 81 | $properties['upper_limit'] = $matches['alt']; |
| 82 | 82 | } |
| 83 | 83 | if ($properties['base'] == 'SFC' || $properties['base'] == 'MSL' || $properties['base'] == 'GROUND' || $properties['base'] == 'GND') { |
| 84 | 84 | $properties['lower_limit'] = 0; |
| 85 | - } elseif (preg_match('/^FL(\s)*(?<alt>\d+)/',strtoupper($properties['base']),$matches)) { |
|
| 85 | + } elseif (preg_match('/^FL(\s)*(?<alt>\d+)/', strtoupper($properties['base']), $matches)) { |
|
| 86 | 86 | $properties['lower_limit'] = round($matches['alt']*100*0.38048); |
| 87 | - } elseif (preg_match('/^(?<alt>\d+)(\s)*(FT|AGL|ALT|MSL)/',strtoupper($properties['base']),$matches)) { |
|
| 87 | + } elseif (preg_match('/^(?<alt>\d+)(\s)*(FT|AGL|ALT|MSL)/', strtoupper($properties['base']), $matches)) { |
|
| 88 | 88 | $properties['lower_limit'] = round($matches['alt']*0.38048); |
| 89 | - } elseif (preg_match('/^(?<alt>\d+)(\s)*M/',strtoupper($properties['base']),$matches)) { |
|
| 89 | + } elseif (preg_match('/^(?<alt>\d+)(\s)*M/', strtoupper($properties['base']), $matches)) { |
|
| 90 | 90 | $properties['lower_limit'] = $matches['alt']; |
| 91 | 91 | } |
| 92 | 92 | if ($properties['type'] == 'RESTRICTED' || $properties['type'] == 'R') { |
@@ -9,7 +9,7 @@ |
||
| 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) if (strpos($line, "update_db.php") && !strpos($line, "sh ")) $j++; |
|
| 13 | 13 | if ($j > 1) { |
| 14 | 14 | echo "Script is already runnning..."; |
| 15 | 15 | die(); |
@@ -11,27 +11,27 @@ |
||
| 11 | 11 | die(); |
| 12 | 12 | } |
| 13 | 13 | $query = 'select * from vam_live_flights rc, gvausers gu where gu.gvauser_id = rc.gvauser_id'; |
| 14 | -$json_data=array(); |
|
| 14 | +$json_data = array(); |
|
| 15 | 15 | $result = $db->query($query); |
| 16 | 16 | while ($rec = $result->fetch_assoc()) |
| 17 | 17 | { |
| 18 | - $json_array['gvauser_id']=$rec['gvauser_id']; // users "pilot unique ID" "40" |
|
| 19 | - $json_array['flight_id']=$rec['flight_id']; // flight_id |
|
| 20 | - $json_array['pilot_id']=$rec['callsign']; // users pilot_id "VAM500" |
|
| 21 | - $json_array['callsign']=substr($rec['flight_id'],-7); // substr icao Flight "AFR524" |
|
| 22 | - $json_array['pilot_name']=$rec['name'] .' '.$rec['surname'] ; // Users "name + surname" |
|
| 23 | - $json_array['plane_type']=$rec['plane_type']; // type Plane "B739" |
|
| 24 | - $json_array['departure']=$rec['departure']; // departure ICAO |
|
| 25 | - $json_array['arrival']=$rec['arrival']; // arrival Ident |
|
| 26 | - $json_array['latitude']=$rec['latitude']; // return 55.7328860921521 |
|
| 27 | - $json_array['longitude']=$rec['longitude']; // return 8.87433614409404 |
|
| 28 | - $json_array['altitude']=$rec['altitude']; // return "147" |
|
| 29 | - $json_array['heading']=$rec['heading']; // return "307" |
|
| 30 | - $json_array['ias']=$rec['ias']; // return speed "IAS" |
|
| 31 | - $json_array['gs']=$rec['gs']; // return speed "GS" |
|
| 18 | + $json_array['gvauser_id'] = $rec['gvauser_id']; // users "pilot unique ID" "40" |
|
| 19 | + $json_array['flight_id'] = $rec['flight_id']; // flight_id |
|
| 20 | + $json_array['pilot_id'] = $rec['callsign']; // users pilot_id "VAM500" |
|
| 21 | + $json_array['callsign'] = substr($rec['flight_id'], -7); // substr icao Flight "AFR524" |
|
| 22 | + $json_array['pilot_name'] = $rec['name'].' '.$rec['surname']; // Users "name + surname" |
|
| 23 | + $json_array['plane_type'] = $rec['plane_type']; // type Plane "B739" |
|
| 24 | + $json_array['departure'] = $rec['departure']; // departure ICAO |
|
| 25 | + $json_array['arrival'] = $rec['arrival']; // arrival Ident |
|
| 26 | + $json_array['latitude'] = $rec['latitude']; // return 55.7328860921521 |
|
| 27 | + $json_array['longitude'] = $rec['longitude']; // return 8.87433614409404 |
|
| 28 | + $json_array['altitude'] = $rec['altitude']; // return "147" |
|
| 29 | + $json_array['heading'] = $rec['heading']; // return "307" |
|
| 30 | + $json_array['ias'] = $rec['ias']; // return speed "IAS" |
|
| 31 | + $json_array['gs'] = $rec['gs']; // return speed "GS" |
|
| 32 | 32 | // $json_array['routes']=$rec['routes']; // (unusable) |
| 33 | - $json_array['flight_status']=$rec['flight_status']; // "return Status" |
|
| 34 | - $json_array['last_update']=$rec['last_update']; // return "DateTime" |
|
| 33 | + $json_array['flight_status'] = $rec['flight_status']; // "return Status" |
|
| 34 | + $json_array['last_update'] = $rec['last_update']; // return "DateTime" |
|
| 35 | 35 | $json_data[] = $json_array; |
| 36 | 36 | } |
| 37 | 37 | echo json_encode($json_data); |