jb123

Hi all, I believe I'm having a similar issue: after a pirep is approved, phpvms is not updating number of pilot flights, number of pilot hours and number of airline hours. It is however updating all the rest as it should (total airline flights, total passengers per pilot, total miles per pilot, ...)... Any idea why this is happening?? Thanks. Joao

Thanks CedGauche, but it doesn't work. I believe is because I'm not looking for an average value of a given column. I don't have a column to get the average from. What I have is 2 columns from different tables that I need to apply a formula ($pirep->routefuel - $pirep->fuelused) * 100 / $pirep->routefuel). And only then calculate the average of that formula's result.

Hi, I'm trying to create a Fuel Rate indicator for my VA, but I'm not an expert on PHP, can someone help? I already have each pirep report showing what I called the Fuel Rate (the idea is to have a value that demonstrates, for each flight, the percentage of fuel spent in relation to what was initially foreseen by the VA for that given flight). I did it this way: <?php $fuelrate = substr(($pirep->routefuel - $pirep->fuelused) * 100 / $pirep->routefuel, 0, 4); echo $fuelrate?> % (routefuel is a new column I created in the 'schedules' DB). This is running fine, showing in each pirep report. What I want is to have the average of this Fuel Rate per each pilot, considering all his flights. And I'd like to show it at the pilot's public profile. Can somebody help? Thanks. Joao

Thanks for your reply. When I meant A32F, I meant A319, A320 and A321 versions.

Hello, I'm looking for liveries for A32F, A332, A343 and A346 (from Wilco) for a new virtual airline. Already have logos. Anyone interested in doing that work? Thanks. Tony

I'm looking for liveries for A32F, A332, A343 and A346 (from Wilco) for a new virtual airline. Already have logos. Anyone interested in doing that work? Thanks. Tony

Thanks Kyle! It worked like a charm ;-) Regards,

Hi, I optimized tables in admin panel, and the following error occured: phpvms.phpvmsschedules - Table './a8424333_phpvms/phpvmsschedules' is marked as crashed and last (automatic?) repair failed Now all my schedules were deleted. I have a backup, but the problem is that phpvms doesn't let me to even add a new schedule. When trying to add, the message appears: There was an error adding the schedule, already exists DB error: Table './a8424333_phpvms/phpvmsschedules' is marked as crashed and last (automatic?) repair failed What can I do? Is there a way to simply delete the table and install a new one...?

Hi tgycgijoes, Thanks for the help. Your explanation gave some ideas and I found a solution that I post here in case someone in the future has a similar problem. I edited the csv file in notepad and found that before the airline code the line started with ". This was not visible in Excel. So I deleted the " character, and saved in notepad. Then I opened the csv file in excel, didn't change anything, just did a save. Uploaded and it's fine! Regards,

Hi, I'm having a problem: - I exported my schedules, changed airline ICAO and tried to import the file. - I previously changed the airline in phpvms. The problem is I can't manage to import successfully. It keeps stating that the airline code doesn't exist (but it does exist). It seems that phpvms is reading all the line as the airline code, instead of reading just the two initial letters (TE) as it should. Please see below the error, and the schedules template in attachment: Airline with code TE,003,LPPT,SBNT,"NAKO4S NAKOS BAROK UN873 SAMAR UN873 LIMAL UN873 CVS UN873 INTOL UN873 NTL",CS-TOO,38000,3054.72,"15:50 GMT"," 20:25 GMT-3"," 7.35"," "," 1968"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,004,SBNT,LPPT,"IBAGA UN873 INTOL UN873 LIMAL UN873 SAMAR UN873 BAROK LIGRA LIGR4A",CS-TOO,37000,3054.72,"21:55 GMT-3"," 08:05 GMT"," 7.1"," "," 1855"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,011,LPPT,SBRF,"NAKO2N NAKOS BAROK UN873 SAMAR UN873 LIMAL UN873 INTOL UN873 NTL UZ10 RUMBA UW33 REC ESGUMA",CS-TOO,36000,3166.24,"16:30 GMT"," 21:30 GMT-3"," 8"," "," 1162"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,012,SBRF,LPPT,"ISAD3A ISADO ESGUM UB623 FNO UN857 NEURA UN857 BOTNO UN857 ETIBA UN857 DEREV UN729 SAMAR UN873 BAROK LIGRA LIGR4A",CS-TOO,35000,3166.24,"23:25 GMT-3"," 10:00 GMT"," 7.35"," "," 1150"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,019,LPPT,SBSV,"BUSE2P BUSEN LUTAK 3520N 3026N 2529N ULTEM 1032N NANIK UN741 JOBER UN741 FLZ UZ19 FROTI BONF BONF",CS-TOO,36000,3512.83,"16:30 GMT"," 23:15 GMT-3"," 8.45"," "," 1111"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,024,SBSV,LPPT,"PUCA NTL UN873 FEMUR UN873 INTOL UN873 IPERA UN873 LIMAL UN873 SAMAR UN873 BAROK LIGRA LIGR4A",CS-TOO,37000,3512.83,"23:55 GMT-3"," 11:10 GMT"," 8.15"," "," 1005"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,027,LPPT,SBFZ,"GANS4S GANSU NELSO UN741 GAMBA UN741 NANIK UN741 JOBER UN741 FLZ",CS-TOO,38000,3033.81,"16:35 GMT"," 21:05 GMT-3"," 7.3"," "," 1121"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,028,SBFZ,LPPT,"URAXA MAGNO UN866 SAKSI UN866 IREDO UN866 APASO UN866 KONBA UN866 BEXAL LIGRA LIGR4A",CS-TOO,39000,3033.81,"00:55 GMT-3"," 11:00 GMT"," 7.05"," "," 1025"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,047,LPPT,SBPA,"NAKO2N NAKOS BAROK UN873 SAMAR UN873 LIMAL UN873 POMAT UN873 INTOL UN873 FEMUR UN873 NTL UN873 GONZA UW58 MAVIK UW58 SCB UA310 CTB UW24 OCASO HERA1",CS-TOO,38000,4757.22,"09:40 GMT"," 18:55 GMT-3"," 11.15"," "," 1213"," P"," 0123456"," 1" does not exist! Skipping... Anyone can help? Tony schedules.csv

Hi, I'm having a problem: - I exported my schedules, changed airline ICAO and tried to import the file. - I previously changed the airline in phpvms. The problem is I can't manage to import successfully. It keeps stating that the airline code doesn't exist (but it does exist). It seems that phpvms is reading all the line as the airline code, instead of reading just the two initial letters (TE) as it should. Please see below the error, and the schedules template in attachment: Airline with code TE,003,LPPT,SBNT,"NAKO4S NAKOS BAROK UN873 SAMAR UN873 LIMAL UN873 CVS UN873 INTOL UN873 NTL",CS-TOO,38000,3054.72,"15:50 GMT"," 20:25 GMT-3"," 7.35"," "," 1968"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,004,SBNT,LPPT,"IBAGA UN873 INTOL UN873 LIMAL UN873 SAMAR UN873 BAROK LIGRA LIGR4A",CS-TOO,37000,3054.72,"21:55 GMT-3"," 08:05 GMT"," 7.1"," "," 1855"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,011,LPPT,SBRF,"NAKO2N NAKOS BAROK UN873 SAMAR UN873 LIMAL UN873 INTOL UN873 NTL UZ10 RUMBA UW33 REC ESGUMA",CS-TOO,36000,3166.24,"16:30 GMT"," 21:30 GMT-3"," 8"," "," 1162"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,012,SBRF,LPPT,"ISAD3A ISADO ESGUM UB623 FNO UN857 NEURA UN857 BOTNO UN857 ETIBA UN857 DEREV UN729 SAMAR UN873 BAROK LIGRA LIGR4A",CS-TOO,35000,3166.24,"23:25 GMT-3"," 10:00 GMT"," 7.35"," "," 1150"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,019,LPPT,SBSV,"BUSE2P BUSEN LUTAK 3520N 3026N 2529N ULTEM 1032N NANIK UN741 JOBER UN741 FLZ UZ19 FROTI BONF BONF",CS-TOO,36000,3512.83,"16:30 GMT"," 23:15 GMT-3"," 8.45"," "," 1111"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,024,SBSV,LPPT,"PUCA NTL UN873 FEMUR UN873 INTOL UN873 IPERA UN873 LIMAL UN873 SAMAR UN873 BAROK LIGRA LIGR4A",CS-TOO,37000,3512.83,"23:55 GMT-3"," 11:10 GMT"," 8.15"," "," 1005"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,027,LPPT,SBFZ,"GANS4S GANSU NELSO UN741 GAMBA UN741 NANIK UN741 JOBER UN741 FLZ",CS-TOO,38000,3033.81,"16:35 GMT"," 21:05 GMT-3"," 7.3"," "," 1121"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,028,SBFZ,LPPT,"URAXA MAGNO UN866 SAKSI UN866 IREDO UN866 APASO UN866 KONBA UN866 BEXAL LIGRA LIGR4A",CS-TOO,39000,3033.81,"00:55 GMT-3"," 11:00 GMT"," 7.05"," "," 1025"," P"," 0123456"," 1" does not exist! Skipping... Airline with code TE,047,LPPT,SBPA,"NAKO2N NAKOS BAROK UN873 SAMAR UN873 LIMAL UN873 POMAT UN873 INTOL UN873 FEMUR UN873 NTL UN873 GONZA UW58 MAVIK UW58 SCB UA310 CTB UW24 OCASO HERA1",CS-TOO,38000,4757.22,"09:40 GMT"," 18:55 GMT-3"," 11.15"," "," 1213"," P"," 0123456"," 1" does not exist! Skipping... Anyone can help? Tony