Recent Posts

Pages: [1] 2 3 ... 10
1
Support for Installation / Re: Error on first start
« Last post by Endrigow on June 20, 2022, 05:09:00 PM »
Good morning, I'm Endrigo from Brazil, I'm having the same problem, from what I've seen it's a problem in capcha, I'm using the local system in xampp, have you managed to solve your problem?
2
Noticias y anuncios / Re: ¿Nos juntamos todos para retomar el proyecto?
« Last post by ManuLence on June 13, 2022, 07:17:42 AM »
Hola, sigue activo el server de Discord?. Me gustaria unirme y compartir conocimientos e ideas para continuar con el proyecto. Muchas gracias!
https://discord.gg/W2xqJgCM

Perdón, lo vi tarde al mensaje y se venció la invitación. Me podrías enviar la invitación a mi email? manu.lence@gmail.com.
Muchas gracias!!
3
Support for VAM 2.4 - 2.6 / [SOLUTION] Aircraft details are now shown
« Last post by blan94 on June 07, 2022, 01:31:03 AM »
Hi everyone 8),

The issue's solution is mentioned below step by step.

1 - open db > fleets and add hub_base information for each of your aircraft. For example in my case my hub is LTBR so I added LTBR into the hub_base.
2 - go to your ftp and edit the following file -> plane_info_public.php,
3 - go to the row number 46 it must be containing the following syntax "inner join airports a2 on a2.ident=hub", if it's not located at the line number 46 so search for it. It supposed to be -+ 1 line. Edit this as the following syntax "inner join airports a2 on a2.ident=f.hub_base"

Follow the further steps for adjusting the table dimensions:
1 - Search with the following keyword "col-md-2" and replace with the following keyword "col-md-3"
2 - Search with the following keyword "col-md-10" and replace with the following keyword "col-md-9"

I hope this will help all of you who has this issue.
For more questions you can contact me via dm.
6
Noticias y anuncios / Re: ¿Nos juntamos todos para retomar el proyecto?
« Last post by X-Plane Español on April 28, 2022, 09:34:44 AM »
Hola, sigue activo el server de Discord?. Me gustaria unirme y compartir conocimientos e ideas para continuar con el proyecto. Muchas gracias!
https://discord.gg/W2xqJgCM
7
Noticias y anuncios / Re: ¿Nos juntamos todos para retomar el proyecto?
« Last post by ManuLence on March 30, 2022, 11:11:45 PM »
Hola, sigue activo el server de Discord?. Me gustaria unirme y compartir conocimientos e ideas para continuar con el proyecto. Muchas gracias!
8
Support for Installation / Error on first start
« Last post by furiaceka21 on March 30, 2022, 04:20:10 PM »
Hi all,
i'm Nico from Italy and i'm very interesting on this VA manager.

I configured it all to lunch it on Xamp but when i try to start i got this message on browser:

Fatal error: Uncaught Exception: Required GD library is missing in C:\xampp\htdocs\caacvirtual\vam\captcha\simple-php-captcha.php:13 Stack trace: #0 C:\xampp\htdocs\caacvirtual\vam\index.php(15): simple_php_captcha() #1 {main} thrown in C:\xampp\htdocs\caacvirtual\vam\captcha\simple-php-captcha.php on line 13

Can someone help me to fix it please?

Regards

Nico
9
Support for VAM 2.4 - 2.6 / Live flights map showing only 1 pilot
« Last post by cristian79652 on March 26, 2022, 05:22:28 AM »
Hi there! Will need help with this problem that i've been unabled to solve along 8 months. (Sorry for my english)

I have the admin LTE template installed, and I reorganized main_index.php to easy apply changes when needed related to the information I want to show on the page. Because of this, the map developed on the main_index is now written on a diferent .php and then added to the main index through an "include".

As I said on tittle, when there are more than one pilot fliying, only one (randomly) is show on the list, but every pilot is shown on the map.

This is the PHP:
===========================================
<head>
<?php
include('./db_login.php');
$db_map = new mysqli($db_host , $db_username , $db_password , $db_database);
$db_map->set_charset("utf8");
if ($db_map->connect_errno > 0) {
die('Unable to connect to database [' . $db_map->connect_error . ']');
}
$sql_map = "select r.flight as flightnum, plane_type, ias, flight_id,u.gvauser_id as gvauser_id,u.callsign as callsign,u.name as name,gs,altitude,surname, lf.departure as departure, lf.arrival as arrival, lf.latitude as latitude, lf.longitude as longitude, lf.flight_status as flight_status,lf.heading as heading,perc_completed, pending_nm, a1.latitude_deg as dep_lat, a1.longitude_deg as dep_lon , a2.latitude_deg as arr_lat, a2.longitude_deg as arr_lon , network from vam_live_flights lf, gvausers u, routes r, airports a1, airports a2 where u.gvauser_id=lf.gvauser_id and lf.departure=a1.ident and lf.arrival=a2.ident and r.route_id= u.route_id";
$sql_map = "select r.flight as flightnum,plane_type,ias,flight_id,u.gvauser_id as gvauser_id,u.callsign as callsign,u.name as name, gs,altitude,surname,lf.departure, lf.arrival,lf.latitude,lf.longitude,lf.flight_status,lf.heading,lf.perc_completed,
pending_nm, a1.latitude_deg as dep_lat, a1.longitude_deg as dep_lon , a2.latitude_deg as arr_lat, a2.longitude_deg as arr_lon , network
from vam_live_flights lf, gvausers u , airports a1, airports a2, routes r where u.gvauser_id=lf.gvauser_id  and lf.departure=a1.ident and lf.arrival=a2.ident and r.route_id= u.route_id";
if (!$result = $db_map->query($sql_map)) {
die('There was an error running the query  [' . $db_map->error . ']');
}
unset($flights_coordinates);
unset($flight);
unset($liveflights);
unset($datos);
unset($jsonarray);
$flights_coordinates = array();
$datos = array ();
$flight = array();
$liveflights = array ();
$jsonarray = array ();
$index = 0;
$index2=0;
$flightindex=0;
while ($row = $result->fetch_assoc()) {
$flight["gvauser_id"]=$row["gvauser_id"];
$flight["callsign"]=$row["callsign"];
      $flight["flightnum"]=$row["flightnum"];
$flight["name"]=$row["name"];
$flight["gs"]=$row["gs"];
$flight["ias"]=$row["ias"];
$flight["altitude"]=$row["altitude"];
$flight["surname"]=$row["surname"];
$flight["departure"]=$row["departure"];
$flight["arrival"]=$row["arrival"];
$flight["latitude"]=$row["latitude"];
$flight["longitude"]=$row["longitude"];
$flight["flight_status"]=$row["flight_status"];
$flight["heading"]=$row["heading"];
$flight["dep_lat"]=$row["dep_lat"];
$flight["dep_lon"]=$row["dep_lon"];
$flight["arr_lat"]=$row["arr_lat"];
$flight["arr_lon"]=$row["arr_lon"];
$flight["perc_completed"]=$row["perc_completed"];
$flight["pending_nm"]=$row["pending_nm"];
$flight["network"]=$row["network"];
$flight["plane_type"]=$row["plane_type"];
$liveflights[$flightindex] =$flight;
$sql_map2 = "select * from vam_live_acars where flight_id='".$row["flight_id"]."' order by id desc"; 
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 ++;
}
$index=0  ;
$index2 ++;
$flightindex ++;
}
$jsonarray[0]=$liveflights;
$jsonarray[1]=$datos;
?>

</head>


        <div class="box box-primary direct-chat direct-chat-primary">
            <div class="box-header with-border">
              <i class="fa fa-location-arrow"></i>
<?php
            $sql = 'select callsign, vf.arrival as arrival, vf.departure as departure, vf.flight_id as flight_id, vf.flight_status as flight_status, name, surname, pending_nm, plane_type, gu.route_id as route_id, ro.flight as flightnum from vam_live_flights vf, routes ro, gvausers gu where gu.gvauser_id = vf.gvauser_id and gu.route_id = ro.route_id group by callsign order by pending_nm asc ';
            if (!$result = $db->query($sql)) {
                die('There was an error running the query [' . $db->error . ']');
            }
            $row_cnt = $result->num_rows;
            $sql = "SELECT flight_id FROM `vam_live_flights` WHERE UNIX_TIMESTAMP (now())-UNIX_TIMESTAMP (last_update)>180";
            if (!$result = $db->query($sql)) {
                die('There was an error running the query [' . $db->error . ']');
            }
            while ($row = $result->fetch_assoc())
            {
                $sql_inner = "delete from vam_live_acars where flight_id='".$row["flight_id"]."'";
                if (!$result_acars = $db->query($sql_inner))
                {
                die('There was an error running the query [' . $db->error . ']');
                }
                $sql_inner = "delete from vam_live_flights where flight_id='".$row["flight_id"]."'";
                if (!$result_acars = $db->query($sql_inner))
                {
                die('There was an error running the query [' . $db->error . ']');
                }
            }
            if ($row_cnt>0){
        ?>
              <h3 class="box-title"><?php echo "En el aire"; ?></h3>
                  
              </div>
                    <div class="panel-body;">
                        <div class="table-responsive">
                                       <table class="table table-hover" id="live_flights_table">
                            <?php
                                    echo "<tr><th>" . 'ID' . "</th><th>" . 'Piloto' . "</th><th>" . 'Origen' . "</th><th>" . 'Destino' . "</th><th>" . 'Etapa' . "</th><th>". 'Equipo' . "</th><th>" . 'Completado' ."</th><th>" . 'Millas restantes' . "</th></tr>";
                                        echo '<td>';      
                                                      echo $flight["callsign"] . '</td><td>';
                                                      echo $flight["name"] . ' ' . $flight["surname"] . '</td><td>';
                                                      echo $flight["departure"] . '</td><td>';
                                                      echo $flight["arrival"] . '</td><td>';
                                                      echo $flight["flight_status"] . '</td><td>';
                                                      echo $flight["plane_type"] . '</td><td>';
                                                      echo '<div class="progress progress-sm active">
                                    <div class="progress-bar progress-bar-success progress-bar-striped" role="progressbar" aria-valuemin="0" aria-valuemax="100" style="width: ' . $flight["perc_completed"] . '%">
                                    <span><data-label="90% completed"> '. $flight["perc_completed"] . '%' .' </span>
                                    </div>
                                    </div>' . '</td><td>';   
                                                      echo $flight["pending_nm"] . 'NM ' . '</td>';
                                          ?>
                            </table>

                            </div>
                                   

                                                        <?php include ('./vam_live_flights_map.php') ?>
                                                        <br>
            </div>
        </div>
 <?php
            }
            else {
        ?>
            <h3 class="box-title"><?php echo "Sin pilotos en el aire"; ?></h3>
                  
              </div>
                    <div class="panel-body;">
                        <br> 
           
       
       
 <?php     
 }
?>       



</body>
</html>

==================================



Thanks in advance
10
Errores e incidencias / Re: No llegan los correos con el Callsign
« Last post by Thduarte on February 23, 2022, 11:36:11 AM »
I have the same issue.
Pages: [1] 2 3 ... 10