lorlandi

Our Airline will be happy to be a tester when you release de cargo option in the future. Congratulations for this job and thanks for your time. Regards

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

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

Yes i know that 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

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

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

Ok thanks a lot....i'll wait for ti. Regards

Ok Kapitan, let's wait for a better way solution. Regards

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 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

Thanks for the help simpilot. Regards

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

Ok, thanks for the help parko, i'll change just the english words not the codes. Regards

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

Hi you can found the plug in the SimPilot page, http://www.simpilotgroup.com/ enter the site and look in the menu the option "Modules" in this page is the Plugin Manager Regards

Many Thanks parkho. Regards

My question is because in the forum on Bild Log is this upgrade Rev v2.1.934-188-gf2f7417 - refs #71 renamed all .tpl files to .php or i´m wrong that means to convert .tpl to php. Thanks parkho.

Hi all, i´m confuse regarding the renamed, last night i downloaded the Rev v2.1.935-0-g7303aa0 - security fix, updated to 2.1.935 but in all template folders the files are in .tpl , can tell me please wich is the correct procedure to upgrade the .tpl files to php. Thanks very much for the help.

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

We have a custom kacars, also i have checked all flights time on data base for both aircrafts and are correctly formated ex. (01.20.14)

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

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

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

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

Yes, if you saw the log is too long, my question is regarding a code who can add the possibility to shwo Route Map, Flown Data (Log) and Comments like a option and not at the same time. Thanks