Jump to content

lorlandi

Members
 View Profile  See their activity

  • Posts

    173

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Posts posted by lorlandi

  2. PilotManager_V2.1

    in Parkho's Addons

    Posted

    Hello Parkho,

    After install your module i have a problem with total pilots on screen, pilot manager show the last pilot as TPR295 instead TPR383, also i try in your "Module Test" with is the same problem, your last id pilot is ALD7016 but the pilot manager only show ALD6980.

    Can you help me please?

    Regards

  3. Maint Cron Job

    in Support Forum

    Posted

    I had many times the same problem with maintenace module, pireps and hours in "0" really don't know whats is wrong in my codes but i made some code to populate the data again. Try with the code below and insert it at the end of your PilotData.class located at core/common.

    public static function actualizarPagoPiloto($pilotid) {

    $sql = 'SELECT p.pirepid, p.submitdate, p.modifieddate FROM ' . TABLE_PREFIX . 'pireps p WHERE p.pilotid='.$pilotid.' AND `accepted`='.PIREP_ACCEPTED;

    $pireps = DB::get_results($sql);

    foreach ($pireps as $pirep)

    {

    $sqlupdate = 'UPDATE ' . TABLE_PREFIX . 'ledger l SET l.submitdate="' . $pirep->submitdate . '", l.modifieddate="' . $pirep->modifieddate . '" WHERE l.pirepid=' . $pirep->pirepid;

    DB::query($sqlupdate);

    }

    $total = DB::get_row('SELECT SUM(`amount`) AS `total` FROM `'.TABLE_PREFIX.'ledger` WHERE `pilotid`='.$pilotid);

    return $total->total;

    }

    public static function actualizarConteoVuelos($pilotid) {

    $sql = 'SELECT COUNT(*) as total FROM ' . TABLE_PREFIX . 'pireps p WHERE p.pilotid='.$pilotid.' AND `accepted`='.PIREP_ACCEPTED;

    $vuelos = DB::get_row($sql);

    $sqlupdate = 'UPDATE ' . TABLE_PREFIX . 'pilots l SET l.totalflights=' . $vuelos->total . ' WHERE l.pilotid=' . $pilotid;

    DB::query($sqlupdate);

    return $vuelos->total;

    }

    }

    Regards

  4. NavData Module

    in Support Forum

    Posted

    Yes i know that :(:unsure: will be a big work but the first step is to create the module, the main idea is the ability to change the information as you need according the flights and update the wrong route fixes in schedules not update all the table, and also to imput the new information like your post. I think is much better than to make changes directly in the data base with the risk to do somothing wrong with manual procedure.

    Regards

  5. NavData Module

    in Support Forum

    Posted

    Yes, the idea is to update manually the data base, and is true the airacs costs money but with this module we can have the ability to insert new points in case of new airports and procedures sid and stars. Any way i'll try to do something i'm not a programmer but have time.

    Regards

  6. NavData Module

    in Support Forum

    Posted

    Hi all, i wonder if it is possible to create a module to manually update the database navdata as for now it is only possible to do it directly in the database.

    A query module for the different fields to search on airway, location or name for easy searching and updating.

    Thanks and Regards

  9. Maintenance.php Bids removal

    in Support Forum

    Posted

    Hello Kapitan, in fact i have for many time the same problem with the bids, my solution is not a good solution but it's work for the moment, I go to the database table phpvms_schedules at the column with name "bids" who show the flight who are on bids whit the numer "1" and no bids with numer "0", i just compare the current bids with the bid value in the column, if you have 5 currents bids you must have 5 flights with numer 1 on the column bids at shedules data base, finsh that i just change the value to "0" without "" and your flights wll be as on bid. Is not a good practice because you change values on database but with care it's work. I make this procedure weekly with no problem untill now.

    According Felipe's post on April 5th i made a update with that files and the problem with bids is unsolved.....but i have erroneous data on my finances

    finnace_1.jpg

    Searching on files i found this code on core/common/LedgerData.class

    http://www.transpola...ages/ledger.jpg

    The values .$params['amount'].', NOW(), NOW() populate the table phpvms_ledger in the data base in the values `submitdate`and `modifieddate` with the present date and when the system makes the calculatin for pilotpay only shows the pilotpay for current months assuming all are reports are on this month instead by month due to the submit date is equal than modified date instead the submit date must have the date when the pirep was sent.

    Regards.

    Luis

    • Like 1

  11. Update by Git

    in Support Forum

    Posted

    Hi all,

    Reagarding update by git, on domumentation show this way to make the update but i do not understand, can you help me please.

    Updating from Git

    If you installed phpVMS using git, do:

    cd phpvms

    git checkout v2.0

    It will then automatically update to the latest. Navigation to install/update.php to complete the upgrade. At the moment, v2.0 is the latest tag which is available. When the next version is available, it will be listed here.

    Thanks and regards

  13. PilotManager_V2.0

    in Parkho's Addons

    Posted

    Hello, i have a question, i need to make somo translation in your templates for my spanish site, every time when uploaded the tpl file the pilot manager do not work, page is in blank.

    Also some problems with the images. Can you help me.

    Thanks

  18. Airline Status Report Not Showing Correctly

    in Support Forum

    Posted

    Well i had the same problem you can see in http://forum.phpvms.net/topic/7428-total-flight-time-in-aircraft-reports/ i made some changes in the fleet table.tpl adding a formula to make some correction to total hours like this:

    <?php foreach ($fleet as $aircraft)

    {

    ?>

    <?php

    $h=(int)(round($aircraft->totaltime*100)/100);

    $p=(round($aircraft->totaltime*100)/100);

    $m=($p-$h)*60;

    $o=(int)($m);

    $s=(int)(($m-$o)*60);

    ?>

    <tr style="text-align:center">

    <td><img src="<?php echo $aircraft->imagelink; ?>"width="80" height="50" ></td>

    <td><?php echo $aircraft->name; ?> </td>

    <td><?php echo $aircraft->registration; ?></td>

    <td><?php echo $h.":".$o.":".$s."<br>"; ?></td>

    Maby can help.you.

    Reagrds

  20. Total flight time in Aircraft Reports

    in Support Forum

    Posted

    Hi all, some weeks ago i have two aircraft with the same total flight time (838 hours), both of them have more than 1000 hours, the other aircraft less than 1000 hours have the total flight time correct. I did the query directly in the database for all aircrafts and there is indeed an error in the flight times of these two aircract.

    Boeing 747-400 ER Freighter (N269TP)

    Total Flights: 201

    Total Distance: 492820

    Average Flight Distance: 2451.84

    Total Hours: 838 instead 1113.36

    Average Flight Time: 5.54

    Boeing 737-700 Converter (N271TP)

    Total Flights: 109

    Total Distance: 37748

    Average Flight Distance: 346.31

    Total Hours: 140 checked and ok

    Average Flight Time: 1.08

    Boeing 767-300 ER Freighter (N303TP)

    Total Flights: 254

    Total Distance: 459809

    Average Flight Distance: 1810.27

    Total Hours: 838 instead 1094.16

    Average Flight Time: 4.31

    These data are from the admin panel Aircraft Reports.Any suggestions on this error or a change to the formula for calculating the total flight time.

    Many thanks

  21. Vatsim Online

    in Development Help

    Posted

    I have the following warning on my page:

    Warning: copy() [function.copy]: Filename cannot be empty in /home/xxxx/xxxxx/VatsimPHPgenerator.php on line 63

    Warning: copy() [function.copy]: Filename cannot be empty in /home/xxxxx/xxxxx/VatsimPHPgenerator.php on line 65

    Any have a solution, all was working good untill two weeks ago, and realy don`t now how solve this problem.

    Regards

  22. Pilot retired (SOLVED)

    in Support Forum

    Posted

    Thanks and sorry for not answer i was very busy in my job. The problem is solved, i have two sites in the same host one is the official site an the other one is the test site, the problem was the test site because it have the same database with pilots records, nobody flight via test site except me, for these reason the admin sistem in test site send messages to pilots under "Pilot retired", solution......delete all pilots from the test site except me and all is going well.

    Thanks anyway joeri, your help any time is well received.

    Regards

  23. Pilot retired (SOLVED)

    in Support Forum

    Posted

    Well, a email was sent to a pilot under "Pilot retired" due to last flight was 90 days ago, the detail is the last flight of this pilot was four days ago i checked the localconfig and all is going well. Several times the sistem send emails to pilots under "Pilot retired" instead they are active.

    Any suggestion.

    Thanks and regards

  25. Flight Information Options

    in Support Forum

    Posted

    Hi all, i have many information in all Pireps like a long list, due to that i'm trying to create a code to give the options on show Route Map, Flown Data (Log) and Comments in order to show only thats options and not all the information.

    Many thanks for the support.

×
×
  • Create New...