CedGauche

Out of the blue this error is there again. I've checked all pilot names, there are no apostrophe in them. I've checked that the script stops at a pilot with the id 22, after this pilot the notam script stops working. The pilot with the id 22 and 23 have no apostrophe or german typo like ä,ö etc in them. Error: Fatal error: Uncaught exception 'Exception' with message 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's message inbox on 04/01/2015', '11', '1427875628')' at line 2' in /var/www/web1112/html/va/core/common/MailData.class.php:92 Stack trace: #0 /var/www/web1112/html/va/core/modules/Mail/Mail.php(138): MailData::send_new_mail('24', '1', 'Monatsbericht M...', 'You received a ...', 11, 1427875628) #1 /var/www/web1112/html/va/core/modules/Mail/Mail.php(38): Mail->send() #2 [internal function]: Mail->index() #3 /var/www/web1112/html/va/core/classes/MainController.class.php(218): call_user_func_array(Array, Array) #4 /var/www/web1112/html/va/index.php(60): MainController::RunAllActions() #5 {main} thrown in /var/www/web1112/html/va/core/common/MailData.class.php on line 92

we still have this problems

Same problem here, perhaps some DNS issus, cause PHPVMS Page wasn't reachable?

Sorry, but I can't get this work, it's too much. This is my sql query: public function comments($ssid) { $query = "SELECT COUNT(`id`) AS `total` FROM ".TABLE_PREFIX."screenshots_comments WHERE ss_id=$ssid"; return DB::get_row($query); } and this in the module $this->set('comments', ScreenshotsData::get_comments($id->id));

Hi, thank you. But i am not the php pro..where exactly should I put this code in? In the airport_search.tpl?

We have some inactive aircraft marked with "X" in the reg field and unmarked in the admin fleet-list, but these aircraft are still in the schedule search box. How can we remove them without deleting the whole ac from the database?

Hi, some users of our va mailed me, that they 'googled' their names and found plenty of results from VA Central and they are quite unhappy with this. Is there an option to hide the surename in VA Central or to sent just the first name? In our VA guests are not allowed to see the pilot list, it's part of the protection of data privacy. thx

Hey, i am trying the same thing, but Nuclear's code dont't work in my pilot:public_profile... It's just emptry. Also Jeff's code produce empty tables. Are there any news or a code that works? Thanks

Hi, look at the screens please. It seems the finances have some problems with the new month. In the summarysheet october is missing, months details has an empty error but in the year sheet everythin is okay. I have cleared caches and recalculated the expenses, but nothing happens. Also the expenses for last month has gone to zero, but until I added some new finances in the admin expanes menu, the expanses for september came back. Thank you

I'll check it, thank you

Hi, a pilot of our va reported me an error when sending a notam, it seems that the airmal was sent probably. Thanks for help Fatal error: Uncaught exception 'Exception' with message 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's message inbox on 09/22/2014', '25', '1411389143')' at line 2' in /var/www/web1112/html/va/core/common/MailData.class.php:92 Stack trace: #0 /var/www/web1112/html/va/core/modules/Mail/Mail.php(138): MailData::send_new_mail('33', '16', 'Vorschlag eines...', 'You received a ...', 25, 1411389143) #1 /var/www/web1112/html/va/core/modules/Mail/Mail.php(38): Mail->send() #2 [internal function]: Mail->index() #3 /var/www/web1112/html/va/core/classes/MainController.class.php(218): call_user_func_array(Array, Array) #4 /var/www/web1112/html/va/index.php(60): MainController::RunAllActions() #5 {main} thrown in /var/www/web1112/html/va/core/common/MailData.class.php on line 92

Hi, you need another AIRAC in your database. You can search in your database for 5230N, if you dont find it your AIRAC is not complete. You can Add this waypoint manually if you only need this waypoint, but if you have many routes over the atlantic the better way is to upgrade: http://forum.phpvms.net/topic/19993-navdata-update/page__hl__airac

Okay thank you, I've edited the data class query and now it works

Good morning, is there an option to show only airports with schedules in the arrival and depicao field? We have some airports in our db with no schedules, just for some charter flights, I don't want that these airports where shown in the airport search to keep it clear. bye Ced

Thank you for the help, but this seems to be too hard vor my, I dont know where I have to start. This is the only part of the $percomplete in my ACARS.php $percomplete = ABS(number_format(((($totaldistance - $flight->distremain) / $totaldistance) * 100), 2)); $c['percomplete'] = $percomplete;

Ok thank you for the hint, I've tried something, but I guess my knowledge is to poor for that: This is the part of the output of the procent table: <td> <div class="progress-container"> <div style="width: <%=flight.percomplete%>%"><%=flight.percomplete%>%</div> </td> So I guess this could work? <?php if($depicao == $arricao) { $percentage = "100"; } else { <td> <div class="progress-container"> <div style="width: <%=flight.percomplete%>%"><%=flight.percomplete%>%</div> </td> } ?> I can't try it at the moment in the office

Is there another solution for flights with the same origin an destination and the progress bar? Perhaps this error could be ignoriered when the distance between the airports is =0?

Try this: http://html-color-codes.info/colors-from-image/

Hi, some pilots of our va have rejected flights, but they still get their pilot earnings for this rejected flight. Is this an error or is there an option for this issue? thx Cedric

Ok thx, this is also a good solution. I'll try it..

Hey Parkho, I have the same problem, I am also searching for a solution, because our pilots also uses Front Schedules and can bid on the whole flightplan, so their rank don't limit their schedule results. Because this topic is old, do you have solution for this problem today?

Cacars looks really nice, the Interface is easy and direct. Good work! Some nice options would be: - Charter flights - Book flight without bid (enter flightnumber)

We don't use manual PIREPS, all Pirpes are made with kacars (which sends data in pounds) but in our local config we changed to kilograms. Which aircrafts seems to burn to much fuel in your ailrine? Perhaps we can compare to our aircrafts.

I don't know if you use $ oder Euro. But usual fuelprice at a german major airport is 1,70 Euro KG, at small airfields 2.20 Euro / KG . This is a realistic price to start with.

Also check up the fuel prices in the airports section, sometimes the option "real fuel prices" generates high fuel prices.