Nabeel

Can you paste the outputs of: /action.php/finances/viewexpensechart?type=m1301716800&submit=View+Report /admin/action.php/finances/viewexpensechart?type=m1301716800&submit=View+Report Or if you open view-source for that charts pages, and find the "data-file:" parameter of the chart, and go to that URL, can you paste the output of those two here?

Look in the admin finances & reports section, it'll have totals there

Yeah, because it doesn't properly pass HTTP headers, so the site thinks it's a new user every time

The templates are in /core/templates. They're filled in on-the-fly when the logged in user clicks the link

That's strange for the summary and yearly to work, since they all go back to the monthly. It's in core/modules/Finance.php. I can't look in detail at the moment, but any more info would help me

Changed Files: m admin/modules/Dashboard/Dashboard.php m core/common/CentralData.class.php m core/common/SiteData.class.php m core/common/StatsData.class.php m core/version m install/hashlist m install/install.php m install/sql/structure.xml m unittest/utils/vac_diag.php send va news to vacentral View complete changes Download from here

Yup

That's fine, it's not an error, just a notice

Weird, I'm not seeing it. Are you viewing the same month/year and all that?

Might be hardcoded in core/modules/profile

If there isn't an API call, then you can use SQL, but do let me know so I can add it in. But for calls where an API method can be used, it's best to use it, since it's the safest way for when there are changes in the database or how things work, they'll be invisible to you. For instance, there have been some changes to financials between the last two versions and this next one, so using raw SQL might just stop working. In 2.1 there were huge changes in how the basic queries were done and organized, and a few columns were removed (like flighttime going to flighttime_stamp), you wouldn't notice. The other reason is the API implements some level of caching, so that database heavy queries (especially ones having to do with statistics, which can potentially go through thousands of records), are cached for a sensible amount of time, so they don't unnecessarily tax your server. So unless you implement those cache read/writes yourself (which isn't difficult to do), then you're missing out on those optimizations.

In my signature, look at "Debug info". Then try doing a flight/doing what you did. Then attach the xacars.txt from core/logs and also the log.txt (put them in a zip file)

Tools -> Error Console

I just looked at the code, it only pulls the PAX type of 'P', so passenger flights. Make sure you haven't inadvertantly set a cargo flight to a pax type

Use Firefox and check your error console, you have javascript errors

Did you look at this? http://forum.phpvms.net/page/index.html?record=22 There's a video tutorial

That's there for security reason. If you search it, it's come up before with a work-around

Don't use raw SQL, use the API for these queries: $pilots = PilotData::getLatestPilots (10); // gets the last 10 pilots See my sig for API listings.

You'll have to use the strtotime function and you can use that to compare (in seconds) the flight status

THanks... would you be able to send me your VAs database so I can load it up and see what's happening locally? PM me...

Changed Files: m .gitignore m unittest/Tests/InstallTest.php - unittest/reports/coverage_report/RGraph.bar.js - unittest/reports/coverage_report/RGraph.common.core.js - unittest/reports/coverage_report/RGraph.common.tooltips.js - unittest/reports/coverage_report/RGraph.scatter.js - unittest/reports/coverage_report/bootstrap.inc.php.html - unittest/reports/coverage_report/butter.png - unittest/reports/coverage_report/chameleon.png - unittest/reports/coverage_report/classes.dashboard.html - unittest/reports/coverage_report/classes.html - unittest/reports/coverage_report/classes_CodonCache.class.php.html - unittest/reports/coverage_report/classes_CodonData.class.php.html - unittest/reports/coverage_report/classes_CodonModule.class.php.html - unittest/reports/coverage_report/classes_CodonRewrite.class.php.html - unittest/reports/coverage_report/classes_Config.class.php.html - unittest/reports/coverage_report/classes_Debug.class.php.html - unittest/reports/coverage_report/classes_Lang.class.php.html - unittest/reports/coverage_report/classes_MainController.class.php.html - unittest/reports/coverage_report/classes_SessionManager.class.php.html - unittest/reports/coverage_report/classes_Template.class.php.html - unittest/reports/coverage_report/classes_TemplateSet.class.php.html - unittest/reports/coverage_report/classes_Util.class.php.html - unittest/reports/coverage_report/classes_Vars.class.php.html - unittest/reports/coverage_report/classes_autoload.php.html - unittest/reports/coverage_report/classes_ezdb.dashboard.html - unittest/reports/coverage_report/classes_ezdb.html - unittest/reports/coverage_report/classes_ezdb_ezdb.class.php.html - unittest/reports/coverage_report/classes_ezdb_ezdb_base.class.php.html - unittest/reports/coverage_report/classes_ezdb_ezdb_mysqli.class.php.html - unittest/reports/coverage_report/close12_1.gif - unittest/reports/coverage_report/common.dashboard.html - unittest/reports/coverage_report/common.html - unittest/reports/coverage_report/common_Auth.class.php.html - unittest/reports/coverage_report/common_CentralData.class.php.html - unittest/reports/coverage_report/common_CronData.class.php.html - unittest/reports/coverage_report/common_FinanceData.class.php.html - unittest/reports/coverage_report/common_FuelData.class.php.html - unittest/reports/coverage_report/common_NavData.class.php.html - unittest/reports/coverage_report/common_OperationsData.class.php.html - unittest/reports/coverage_report/common_PIREPData.class.php.html - unittest/reports/coverage_report/common_PilotData.class.php.html - unittest/reports/coverage_report/common_PilotGroups.class.php.html - unittest/reports/coverage_report/common_RSSFeed.class.php.html - unittest/reports/coverage_report/common_RanksData.class.php.html - unittest/reports/coverage_report/common_RegistrationData.class.php.html - unittest/reports/coverage_report/common_SchedulesData.class.php.html - unittest/reports/coverage_report/common_SettingsData.class.php.html - unittest/reports/coverage_report/common_SiteData.class.php.html - unittest/reports/coverage_report/container-min.js - unittest/reports/coverage_report/container.css - unittest/reports/coverage_report/directory.png - unittest/reports/coverage_report/excanvas.compressed.js - unittest/reports/coverage_report/file.png - unittest/reports/coverage_report/glass.png - unittest/reports/coverage_report/index.dashboard.html - unittest/reports/coverage_report/index.html - unittest/reports/coverage_report/lib.dashboard.html - unittest/reports/coverage_report/lib.html - unittest/reports/coverage_report/lib_phpmailer.dashboard.html - unittest/reports/coverage_report/lib_phpmailer.html - unittest/reports/coverage_report/lib_phpmailer_class.phpmailer.php.html - unittest/reports/coverage_report/modules.dashboard.html - unittest/reports/coverage_report/modules.html - unittest/reports/coverage_report/modules_ACARS.dashboard.html - unittest/reports/coverage_report/modules_ACARS.html - unittest/reports/coverage_report/modules_ACARS_ACARS.php.html - unittest/reports/coverage_report/modules_Contact.dashboard.html - unittest/reports/coverage_report/modules_Contact.html - unittest/reports/coverage_report/modules_Contact_Contact.php.html - unittest/reports/coverage_report/modules_Downloads.dashboard.html - unittest/reports/coverage_report/modules_Downloads.html - unittest/reports/coverage_report/modules_Downloads_Downloads.php.html - unittest/reports/coverage_report/modules_FSFK.dashboard.html - unittest/reports/coverage_report/modules_FSFK.html - unittest/reports/coverage_report/modules_FSFK_FSFK.php.html - unittest/reports/coverage_report/modules_Finances.dashboard.html - unittest/reports/coverage_report/modules_Finances.html - unittest/reports/coverage_report/modules_Finances_Finances.php.html - unittest/reports/coverage_report/modules_FrontBids.dashboard.html - unittest/reports/coverage_report/modules_FrontBids.html - unittest/reports/coverage_report/modules_FrontBids_FrontBids.php.html - unittest/reports/coverage_report/modules_Frontpage.dashboard.html - unittest/reports/coverage_report/modules_Frontpage.html - unittest/reports/coverage_report/modules_Frontpage_Frontpage.php.html - unittest/reports/coverage_report/modules_Login.dashboard.html - unittest/reports/coverage_report/modules_Login.html - unittest/reports/coverage_report/modules_Login_Login.php.html - unittest/reports/coverage_report/modules_Logout.dashboard.html - unittest/reports/coverage_report/modules_Logout.html - unittest/reports/coverage_report/modules_Logout_Logout.php.html - unittest/reports/coverage_report/modules_PIREPS.dashboard.html - unittest/reports/coverage_report/modules_PIREPS.html - unittest/reports/coverage_report/modules_PIREPS_PIREPS.php.html - unittest/reports/coverage_report/modules_Pages.dashboard.html - unittest/reports/coverage_report/modules_Pages.html - unittest/reports/coverage_report/modules_Pages_Pages.php.html - unittest/reports/coverage_report/modules_Pilots.dashboard.html - unittest/reports/coverage_report/modules_Pilots.html - unittest/reports/coverage_report/modules_Pilots_Pilots.php.html - unittest/reports/coverage_report/modules_Profile.dashboard.html - unittest/reports/coverage_report/modules_Profile.html - unittest/reports/coverage_report/modules_Profile_Profile.php.html - unittest/reports/coverage_report/modules_Registration.dashboard.html - unittest/reports/coverage_report/modules_Registration.html - unittest/reports/coverage_report/modules_Registration_Registration.php.html - unittest/reports/coverage_report/modules_RouteMap.dashboard.html - unittest/reports/coverage_report/modules_RouteMap.html - unittest/reports/coverage_report/modules_RouteMap_RouteMap.php.html - unittest/reports/coverage_report/modules_Schedules.dashboard.html - unittest/reports/coverage_report/modules_Schedules.html - unittest/reports/coverage_report/modules_Schedules_Schedules.php.html - unittest/reports/coverage_report/modules_XML.dashboard.html - unittest/reports/coverage_report/modules_XML.html - unittest/reports/coverage_report/modules_XML_XML.php.html - unittest/reports/coverage_report/modules_kACARS_Free.dashboard.html - unittest/reports/coverage_report/modules_kACARS_Free.html - unittest/reports/coverage_report/modules_kACARS_Free_kACARS_Free.php.html - unittest/reports/coverage_report/modules_news.dashboard.html - unittest/reports/coverage_report/modules_news.html - unittest/reports/coverage_report/modules_news_news.php.html - unittest/reports/coverage_report/modules_test.dashboard.html - unittest/reports/coverage_report/modules_test.html - unittest/reports/coverage_report/modules_test_test.php.html - unittest/reports/coverage_report/scarlet_red.png - unittest/reports/coverage_report/snow.png - unittest/reports/coverage_report/style.css - unittest/reports/coverage_report/yahoo-dom-event.js - unittest/reports/testdox.html - unittest/reports/testdox.txt gitignore on unittest reports View complete changes Download from here

Changed Files: m .gitignore - lib/rss/latestpireps.rss - unittest/reports/coverage.xml - unittest/reports/logfile.json - unittest/web removed/ignored files in commits View complete changes Download from here

Changed Files: m .gitignore m lib/rss/latestpireps.rss m unittest/reports/coverage.xml m unittest/reports/logfile.json ignore files update View complete changes Download from here

Changed Files: m install/includes/loader.inc.php m install/templates/s1_db_setup.tpl m lib/rss/latestpireps.rss m unittest/reports/coverage.xml m unittest/reports/logfile.json preselect mysqli if present in installer View complete changes Download from here

Changed Files: m install/includes/Installer.class.php m install/includes/loader.inc.php m install/install.php m install/templates/footer.tpl m install/update.php m lib/rss/latestpireps.rss m unittest/reports/coverage.xml m unittest/reports/logfile.json m unittest/reports/testdox.html m unittest/reports/testdox.txt cleaned up installer/update code View complete changes Download from here