|
@@ -11,27 +11,27 @@ |
|
|
block discarded – undo |
|
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); |
Ysurac /
FlightAirMap
