Administrators Nabeel Posted April 14, 2011 Administrators Report Share Posted April 14, 2011 Changed Files: m core/common/PilotData.class.php optimized pilot stats View complete changes Download from here Link to comment Share on other sites More sharing options...
Moderators mark1million Posted April 14, 2011 Moderators Report Share Posted April 14, 2011 Nabeel, I noticed after an update the total hours are reporting wrong, I have reset from the maintenance script and, Now counting from PIREPS Found 838:59:59 total hours, updated From VA Central, 17212.1 hours. Also the pilot count is not increasing in VA Central. Link to comment Share on other sites More sharing options...
Moderators mark1million Posted April 14, 2011 Moderators Report Share Posted April 14, 2011 Also all of the pirep counts (flights) have been reset to 0 for every pilot. Link to comment Share on other sites More sharing options...
Moderators mark1million Posted April 14, 2011 Moderators Report Share Posted April 14, 2011 These are some of the errors in the logs after the update, PHP Fatal error: Class 'Debug' not found in /core/codon.config.php on line 77 PHP Fatal error: Class 'TemplateSet' not found in /action.php on line 48 PHP Fatal error: Class 'PilotData' not found in /core/common/Auth.class.php on line 97 Sone of these were during the live update though so could have been when the files were being uploaded and people calling them. Link to comment Share on other sites More sharing options...
Guest lorathon Posted April 14, 2011 Report Share Posted April 14, 2011 There is a comma missing in the update. $sql = 'SELECT COUNT(`pirepid`) as `totalpireps`, SEC_TO_TIME(SUM(TIME_TO_SEC(`flighttime_stamp`))) as `totaltime` FROM `'.TABLE_PREFIX.'pireps` WHERE `pilotid`='.$pilotid.' AND `accepted`='.PIREP_ACCEPTED; Change the query under UpdatePilotStats to the above (around line 604). This change reduces the time to accept a pirep. Very noticeable difference. Link to comment Share on other sites More sharing options...
Moderators mark1million Posted April 14, 2011 Moderators Report Share Posted April 14, 2011 Just looking at that now Jeff, Cheers. Link to comment Share on other sites More sharing options...
Moderators mark1million Posted April 14, 2011 Moderators Report Share Posted April 14, 2011 How much difference a comma makes That's fixed it. Thanks again Jeff. Link to comment Share on other sites More sharing options...
Moderators mark1million Posted April 14, 2011 Moderators Report Share Posted April 14, 2011 Just reran the maintenance script and everyone's pireps are still showing as 0 but their hours are counted and have come back, how strange. Link to comment Share on other sites More sharing options...
Moderators joeri Posted April 14, 2011 Moderators Report Share Posted April 14, 2011 sounding verry stupid but i cant find it what file would i need to look jeff Link to comment Share on other sites More sharing options...
Guest lorathon Posted April 14, 2011 Report Share Posted April 14, 2011 Hold on. I am working with Nabeel to fix another issue this change resulted in. Link to comment Share on other sites More sharing options...
Moderators joeri Posted April 14, 2011 Moderators Report Share Posted April 14, 2011 ok i am on hold can i still breath Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted April 14, 2011 Author Administrators Report Share Posted April 14, 2011 Try the next revision, we've run into a few issues which will need resolving. But good news is there are a few performance updates, thanks Jeff! But there will be a few issues, keep reporting them Link to comment Share on other sites More sharing options...
Moderators mark1million Posted April 14, 2011 Moderators Report Share Posted April 14, 2011 I have noticed the performance updates, very good Link to comment Share on other sites More sharing options...
Recommended Posts