|
Download
Download the current version of the APU here.
Read the below notes for installation:
Install notes for APU - Automated Pilot Utility
-
Create a database on your hosts site.
This step varies depending on the provider
mySQL version 4.x or higher required.
Note the database name, server name, and full access username and
password
as this will be needed as input to the install.php script.
-
3. In a web browser, navigate to the file install/install.htm
Example: http://www.mysite.com/apu/install/install/htm
Fill in the fields presented on the web form and click submit.
If all goes well, the APU database should be created.
Pilots
Pilots need to register in the APU system here:
/apu/register.htm
Optionally, you can register them yourself and give them their Cyber Air Pilot ID and password.
For yourself and current pilots that may have some flight hours already, I will explain further below on how to get these hours and PIREP into the APU.
Once pilots have been registered, they may change their password at any time on this page:
/apu/changepass.htm
When a pilot completes a flight, they need to visit this page to submit their PIREP. After a PIREP is submitted, the pilot will receive an e-mail with their flight details. An e-mail will be sent to the administrator and QA e-mail addresses, if they are enabled in the /apu/admin/config.inc file.
/apu/pirep.htm
When pilots submit a PIREP, visiting the Roster page will show this immediately. Pilots may visit the roster page to see theirs and other pilots current rank, hours, status, etc.
/apu/roster.php
APU Administration
The administration login page is here: /apu/admin/
Admin ID : The admin ID you specify in the /apu/admin/config.inc file.
Password: The password you specify in the /apu/admin/config.inc file.
Once logged on, you will be shown a page with a number of administration options.
These options are:
Edit Pilot
The Edit Pilot has a drop down to select from pilots in your database. Once you have selected the pilot, click the submit button. A new page will be displayed with the pilots information, name, Pilot ID, Rank number, number of hours, e-mail address etc. These can be edited as needed.
Also on the displayed pilot page, there are two check boxes at the top. The first one, Reset Password , if selected will reset this pilots password to a default password that is defined in the file /apu/admin/config.inc file. The second check box, Delete Pilot Record , when selected, will mark the pilot as deleted. The pilot will still exist in the database, but they will not be displayed on the pilot roster page. I chose to have pilot records not be removed from the database permanently as some times these pilots come back.
The pilot page has a section named Additional Flight Activities . These are check boxes for DART, SAR and Fleet Support, and can be enabled for a pilot when they have performed any of these additional flight types. When selected, a graphic representing the activity will be displayed on the pilot roster for this pilot.
And additional section on the pilot page is the Pilot Status section. This section contains check boxes to indicate if a pilot is on a leave of absence, or if the pilot is currently active. If the active check box is selected, the pilot will appear in the active pilots area of the roster. If the leave of absence check box is selected and the active check box is not selected, the pilot will appear in the leave of absence part of the pilot roster. If the active check box and the leave of absence check box is not selected, the pilot will show up on the inactive portion of the pilots roster.
After the pilots record information on the pilots page, all PIREP submitted by the pilot are displayed. These PIREP can be edited by clicking on the hyperlink at the beginning of each PIREP. Note that if you modify a PIREP hours, you will need to manually figure out the aircraft and or helicopter flight hours and the total hours and update the pilots record for these hours.
Create Monthly Report
At the beginning of a new month, you will want to come to this section and select the previous month and current year then click submit, so that a monthly report is created.
When a monthly report is created, it and all other monthly reports can be viewed from this link: /apu/monthly/monthly.php
Create Year to Date Report
This functionality is not currently implemented.
Groom No Fly Pilots
At the beginning of a new month, you will want to click on this option in order to have the APU look through the pilot's records and mark pilots as inactive or deleted, if they have not flown a certain number of days. Once they are marked, they will show up on the pilot roster as inactive or not show up at all if marked deleted.
The number of days a pilot has not flown can be configured in the /apu/admin/config.inc file.
The number of days until marked deleted should be greater than the number of days until marked inactive.
Backup Database
The backup database option should also be performed at the beginning of a new month. Click the submit button to be taken to a page that will display your database information. This information should be correct and no change needs to be done. Click the Find button on this page.
On the next page, all information should be good to go, except that you need to select the "Check All" radio button at the bottom of the Create a Backup section, and then click the Backup button.
The database will be backed up / exported to the /apu/admin/backup/dump folder. You will want to go get this file and copy it to your local computer, and then delete the file from your web host directory, as this backup has issues with any file already existing in the directory.
I have not ever t ested the Restore Backup feature .
The Delete Backup and Download Backup sections also have issues and may not work so ignore them.
Display Debug Information
This option simply displays a lot of information about your hosts installation and configuration of Apache, PHP and mySQL programs that are useful to me for any needed debugging purposes.
There are a number of files both htm and PHP in the APU that you might want to edit and change words refering to any specific Cyber Air VA or hub. |