Rev v2.1.934-102-gaff2864 - optimized pilot stats

[Nabeel]

Changed Files:

m core/common/PilotData.class.php

optimized pilot stats

View complete changes

Download from here

[mark1million]

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.

[mark1million]

Also all of the pirep counts (flights) have been reset to 0 for every pilot.

[mark1million]

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.

[Guest lorathon]

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.

[mark1million]

Just looking at that now Jeff, Cheers.

[mark1million]

How much difference a comma makes That's fixed it.

Thanks again Jeff.

[mark1million]

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.

[joeri]

sounding verry stupid but i cant find it what file would i need to look jeff

[Guest lorathon]

Hold on. I am working with Nabeel to fix another issue this change resulted in.

[joeri]

ok i am on hold can i still breath

[Nabeel]

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

[mark1million]

I have noticed the performance updates, very good