Download
* Access
The administration login page is located at: /apu/admin/
Admin ID : The admin ID you specify in the /apu/admin/config.php file.
Password: The password you specify in the /apu/admin/config.php 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.php 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 and it makes it easy to restore these pilots with their flights and flight hours retained.
If you wish to permanently delete a pilot you will need to delete their database table record using MySQL
or other MySQL database application
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.
An 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
* To perform a manual database install instead of above.
Using a mySQL application, such as phpMyAdmin, load/execute the SQL file located at /sql/all_tables.sql.
* 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.php file.
The number of days until marked deleted should be greater than the number of days until marked inactive.
* Backup Database
The backup and recovery section has been taken from another third party PHP author and has certain issues.
A more specific backup and restore feature may be added to a future version of the APU.
The backup database option should also be performed at the beginning of a new month or more frequently.
Click the submit button to be taken to a page that will display your database information.
This information should be correct and no changes should need 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 to a file in 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.
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/IIS, PHP and MySQL programs that may be useful for any needed debugging purposes.
There are a number of files both HTML and PHP in the APU that you might want to edit and change
words referring to any specific Cyber Air VA or hub, images and styles.
