By Sten Vesterli (sten@vesterli.com) for use in Roskilde Flyveklub.
Fulcrum is a web-based aircraft weight and balance calculator with graphing. It has support for multiple aircraft and administrators. It has a W&B page with a graphical view of the envelope and a separate admin page for maintaining aircraft.
It is a Dec 2020 fork from TippingPoint (http://tippingpoint.sourceforge.net) by Caleb Newville. At this time, 70% of the functionality is from that project.
- A web server with PHP 8
- MySQL/MariaDB
- Download the code
- Extract the archive to a separate directory $FULCRUMDIR (e.g.
fulcrum) on your webserver - Create an empty MySQL database
- Create a MySQL database user and grant that user all privileges on the database
- Go to http://(yourserver)/$FULCRUMDIR/setup.php
- Enter the database connection information and other config information when prompted
If the update does not affect the database, do the following:
- Change setup.php to mode 755 (rwxr-xr-x)
- Overwrite all files on the server with the new version
- Change setup.php back to mode 000 (---------) The config.func file on your server contains the connect information and will not be overwritten. The new code will thus inherit the existing database connection and tables
When a version is released that changes the database, it will come with a separate updateXXX.php file that you need to run after installing the code. E.g. to update to DB version 1.0.0, you run update100.php through your web browser.
If you want to reset your installation:
- Delete your MySQL database
- Create a new MySQL database
- Grant all privileges on the new database to the existing user
- Delete the
config.incfile on your web server and set the permissions onsetup.phpback to 755. - Run setup.php You will now be prompted for database connect information and be taken through the setup process again.
Go to the Issues page on GitHub to see existing bugs and already suggested improvements. If you have a Github account, you can add more.