Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Timothee

Pages: [1] 2 3 ... 6
1
Support for VAM 2.4 - 2.6 / Re: Using HTTPS
« on: March 06, 2019, 01:31:10 PM »
About one or two files need some small changes because they link to non HTTPS sites.
Check here: http://virtualairlinesmanager.net/foro//index.php?topic=1881.msg7259#msg7259

2
Bug reports / Re: THIS FLIGHT IS ALREADY REPORTED TO THE WEB SYSTEM
« on: February 15, 2019, 10:06:44 AM »
Does the livery name for the aircraft in use contain any special characters, for example apostrophes?
If so VAM has a problem accepting those since the values are not correctly escaped.

A while ago I added an escape function to the receivevampirep.php:
Code: [Select]
function instert_flight( $flight , $data ,$db){
        [...]
$aircraft= $db->real_escape_string($data[0]["aircraft"]);
        [...]
        }

3
Bug reports / Re: Bad QNH = CRASH?
« on: February 12, 2019, 03:19:23 PM »
Hi FREDDO

SIMAcars can work only with the values received from FSUIPC. FSUIPC reads the default offset from FSX/P3D. Since neither the Majestic Dash (QNH, Beacon, Taxi & Nav(?) Lights) nor PMDG (Taxi Lights) use the default offsets for their functions, FSUIPC will never be aware of what is actually set. This is something you have to address to the publishers and not to SIMAcars.

However, there is a workaround for the QNH in the Majestic Dash. The 'B' key doesn't set the QNH in the Dash 8 but it sets the offset in the simulator. This means, just press the 'B' key before takeoff and before landing and you are fine.

There is currently no way around this.

4
Bug reports / Re: [VAM2.6.2] Acars Data MAX_JOIN_SIZE
« on: January 10, 2019, 11:25:33 AM »
Over time another query leads to the same problem.

In flight_details.php the first SQL statement (about line 34) again contains more joins than necessary.

Original statement:
Code: [Select]
$sql = "select * , date_format(flight_date,'$va_date_format') as flight_date from vam_track vt , vampireps vp ,gvausers u where vt.flight_id = vp.flightid and u.gvauser_id = vp.gvauser_id and vp.flightid='" . $vamflightid . "'";

Modified statement:
Code: [Select]
$sql = "select * , date_format(flight_date,'$va_date_format') as flight_date from vampireps vp, gvausers u where u.gvauser_id = vp.gvauser_id and vp.flightid='" . $vamflightid . "'";

5
Support for VAM 2.4 - 2.6 / Re: Flight Validation
« on: September 19, 2018, 10:20:14 PM »
Yes thats a well known problem. Create an index for the column report_id of the table va_finances.

Code: [Select]
ALTER TABLE va_finances ADD INDEX (report_id);

6
Support for VAM 2.4 - 2.6 / Re: Fleet page shows no aircraft
« on: August 03, 2018, 01:57:37 PM »
Set a location (ICAO code) for your planes. I'm sure that solves your problem.

7
Support for VAM 2.4 - 2.6 / Re: Fleet page shows no aircraft
« on: August 02, 2018, 06:30:19 PM »
Impossible to say without further information. In the SQL query are at least 5 tables involved, so depends in which one you are missing something.
Post a screenshot of the following screen from the Admin Panel: Fleet manager -> <your aircraft> -> Edit

8
Support for VAM 2.4 - 2.6 / Re: Problem calling Details of Flight
« on: August 02, 2018, 10:11:19 AM »
Note sure if this was the problem you are describing but check this solution
http://virtualairlinesmanager.net/foro//index.php?topic=1319.0

9
So just in case, I only told half the truth. Looks like it depends on the server configuration whether HTTPS works. One possible solution for a problem is found here:
http://virtualairlinesmanager.net/foro//index.php?topic=1886.0

10
Support for SIM ACARS / Re: [Solved] Error trying to connect (SSL?)
« on: July 31, 2018, 08:12:09 PM »
Glad you solved it.
You can actually test it by yourself. Go to https://www.ssllabs.com and select test your server.
If you look for TLS 1.0 in the report it will be shown as not supported (Off).

11
Support for SIM ACARS / Re: Error trying to connect (SSL?)
« on: July 31, 2018, 07:53:43 PM »
Assuming the URL in your signature is your VA I did some tests with it. Don't worry, before SIM ACARS tries to connect to VAM a SSL/TLS handshake has to be established, so I don't need a valid URL or a VAM user.

What I noticed is, SIM ACARS is trying to negotiate TLS 1.0, which is disabled on your webserver. Thats actually a good practice. Since TLS 1.0 is still enabled on our webserver I never had this issue.
I don't have some deep knowledge about .NET but what I assume is SIM ACARS was compiled to be compatible with older frameworks or has the security protocol explicitly set to TLS 1.0.

However, luckily we are able to override this behaviour. Create a new file in your SIM ACARS directory called "SIM ACARS.exe.config".
Put the following content inside that file:
Code: [Select]
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <runtime>
      <AppContextSwitchOverrides value="Switch.System.Net.DontEnableSchUseStrongCrypto=false" />
    </runtime>
</configuration>

The value is a bit misleading but you actually tell the application to use strong protocols. Now test again. If it works you have to provide this additional file to your VA pilots.

12
This issue is bothering me since I started to use VAM.
I havenĀ“t looked into the files yet so this is just an idea: Why not do the sql call with each map refresh and count the rows/data sets.
If you could output the table as an array (like $live_flights = array( "$flight_no1", "$flight_no2", ...), you could probably use foreach or a for loop to create a marker for each flight.
I will play arround with MySQL a bit and test a few ideas.

Regards
Tim

This isn't really the issue here. The markers for every plane etc. works perfectly fine, even if multiple flights at the same time are active. What we are talking about are the initial coordinates the map is centered on when loaded.

13
Yes that was what I was going for, glad you found it ;)

14
Just a wild guess but how many rows does the table "airports" count in your installation?

15
The SQL query you pasted isn't the one responsible for the map coordinates. There are the following lines just below:

Code: [Select]
[...]
$sql_map2 = "select * from vam_live_acars where flight_id='".$row["flight_id"]."' order by id asc";
if (!$result2 = $db_map->query($sql_map2)) {
die('There was an error running the query  [' . $db_map->error . ']');
}
while ($row2 = $result2->fetch_assoc()) {
$flights_coordinates ["gvauser_id"] = $row2["gvauser_id"];
$flights_coordinates ["latitude"] = $row2["latitude"];
$flights_coordinates ["longitude"] = $row2["longitude"];
$flights_coordinates ["heading"] = $row2["heading"];
$datos [$index2][$index] = $flights_coordinates;
$index ++;
}
[...]
var var_location = new google.maps.LatLng(<?php echo $datos[0][0]["latitude"]; ?>,<?php echo $datos[0][0]["longitude"]; ?>);
[...]

As you will see, the source of the coordinates is vam_live_acars (sorted ascending). Obviously the map can only have one view location, so the location is set to the first coordinates found in vam_live_acars. This will always return the departure airport of the first flight (in case multiple flights are active). Don't get me wrong, the query is used to display the current flight path of each flight so it needs to be there, but it can not be used to set the map coordinates.

What you probably could do is implementing the tracking of the selected aircraft, quite similiar to the follow mode in Flightradar24. But to achieve this a complete rewrite of the current map would be necessary. Currently VAM reloads the complete page to refresh the map. It would be much smoother to reload only the markers. This is just an idea and not something I have done already.

Whatever you have in mind doing, for the current coordinates of each pilot the table vam_live_flights is your friend. There is one line per flight including the coordinates since the last update from SIMAcars.


Pages: [1] 2 3 ... 6