mark1million

All seems OK now after running those manual sql updates.

OK so i had to manually run each line on the sql update because some tables were already modified and it was just stalling there, and its OK now done a recalculation of the finances and the cash has been updated as well. One final thing to check is that the pilots are getting paid now and the pireps and being populated with fuel and gross revenue.

Nabeel, No errors now but still getting, [ERROR] The column paytype is missing! [ERROR] The column payforflight is missing!

My main problems at the moment are, Finances, Pireps coming in with values of 0 Pilot Cash is 0 Admin, New schedules cant add Im just updating to the latest release and will report back.

Have i missed something in the recent finance overhaul???? All pireps and fuel are coming in as 0, there is a used fuel figure nut the values 0 Ill go and have a look over at the other releases just in case i missed something as its been about 8 months since i last updated a beta.

Any fix yet to the financials???

Thats in your, tablesorter.pager.js needs a slight change in line 22: change "absolute" to "static" I also right aligned the div tag to make it look better imo. File is in core/lib/js

Nabeel, Thats fixed the sql, now the pilots payments are all now sitting at 0, and no pirep finances are showing for fuel or load.

Try to reupload the lib/js/ofc and teh core/common/OFCharts.class.php

I have modded that file and directory so i didnt upload that on mine. Try re uploding that file see what happens

was about an hour ago now. should i re download?

I have some other issues with this as well, Schedules export doesn't have pilot pay per flight, currently all pireps coming in to my system are showing as 0 revenue as well.

Also tried with mysqli same thing, DB check shows missing, [ERROR] The column paytype is missing! [ERROR] The column payforflight is missing! So that is stopping the updater running. Check files gives the usual errors which are expected on the files i have manually changed.

Nabeel, What is this please? Came up on the install/update.php Warning: trim() expects parameter 1 to be string, array given in /core/classes/ezdb/ezdb_mysql.class.php on line 202

No worries i sorted it Nabeel, did you manage to get rid of that fs pax message about no aircraft entered?

Do you need to update that file plus the htaccess? to get this to work?

With a windows server you can add a task so the result will be the same

All the changes that have been happening i think i may need to look at updating my dev site to see whats changed, and re modding all the custom files i have changed, where to start. Good job i created notes when modding them all lol or i would be well and truly screwed.

Well currently i was looking at the possibility of creating a script that looked at the hours and added awards accordingly, this was based on a cron job nightly.

Yes

With out modding all the code i dont think you can, its been hardcoded in. Nabeel will be able to reply better to this.

You can just include a iframe in the schedules, so would be something like , Would be better making a module and including the template though. <iframe id="EURoute" src=http://www.euroutepro.com/fp/fp_main.php?dep=<?php $schedule->depicao?>&arr=<?php$schedule->arricao?>" width=700px height=250px marginwidth=0 marginheight=0 hspace=0 vspace=0 frameborder=0 scrolling=yes></iframe> Something like that would work in your schedule briefing page.

Same thing here Jeff, looks like a dns issue.

The server may be down for maintenance, try again later, if they have been sending then there isnt a problem your end