phpDivingLog
-
- Posts: 228
- Joined: Sun Jun 11, 2006 09:24
- Location: Frankston South, Victoria, Australia
- Contact:
phpDivingLog
G'day,
Olaf van Zandwijk (see http://enschede.vanzandwijk.net/diving/) kindly gave me the PHP code he used to put his diving log database online. I've adapted it to suit my own preferences.
So now my logbook is online (see http://www.borrett.id.au/divelog/index.php), complete with dive profile charts where I have the data.
There are further enhancements I can think of making, but at least the basics are working.
Many thanks to Olaf, Sven and the others that helped me to get this working.
Best Regards, Lloyd Borrett.
Olaf van Zandwijk (see http://enschede.vanzandwijk.net/diving/) kindly gave me the PHP code he used to put his diving log database online. I've adapted it to suit my own preferences.
So now my logbook is online (see http://www.borrett.id.au/divelog/index.php), complete with dive profile charts where I have the data.
There are further enhancements I can think of making, but at least the basics are working.
Many thanks to Olaf, Sven and the others that helped me to get this working.
Best Regards, Lloyd Borrett.
Last edited by lloyd_borrett on Tue Jul 18, 2006 11:09, edited 1 time in total.
-
- Posts: 228
- Joined: Sun Jun 11, 2006 09:24
- Location: Frankston South, Victoria, Australia
- Contact:
G'day,
After a few requests, I've created a readme.txt file and ZIP file of everything used to do my online divelog.
Divelog version 1.1 can now be downloaded from http://www.borrett.id.au/downloads/divelog_v1-1.zip (2,600 KB ZIP file).
The readme.txt file contains...
Best Regards, Lloyd Borrett.
After a few requests, I've created a readme.txt file and ZIP file of everything used to do my online divelog.
Divelog version 1.1 can now be downloaded from http://www.borrett.id.au/downloads/divelog_v1-1.zip (2,600 KB ZIP file).
The readme.txt file contains...
Divelog version 1.1
2006-07-07 - Lloyd Borrett (http://www.borrett.id.au)
Original version 1.0 created by Olaf van Zandwijk (http://enschede.vanzandwijk.net)
USES:
JpGraph 1.20.4a (http://www.aditus.nu/jpgraph/)
RTFClass (http://www.phpclasses.org/browse/file/7632.html)
Rich Text Format - Parsing Class - (c) 2000 Markus Fischer
INSTALLATION:
Create a MySQL database on your server.
Edit the file includes/misc.inc.php and replace the values for
$username = "your_username";
$password = "your_password";
$server = "localhost";
$db = "your_database";
with the appropriate values for your database.
Edit the files includes/header.tpl and includes/footer.tpl
to have the HTML code needed for your web site.
Upload the files to your server.
Do a MySQL Dump from Diving Log 4.0
(https://www.divinglog.de/english/home/index.php)
Use phpMyAdmin or similar to upload the data into your database.
Best Regards, Lloyd Borrett.
-
- Posts: 228
- Joined: Sun Jun 11, 2006 09:24
- Location: Frankston South, Victoria, Australia
- Contact:
G'day,
I've updated the PHP scripts to add in a number of new features. See http://www.borrett.id.au/divelog/
STATISTICS
Separated statistics into divestats.php.
Added Diving Certifications to the statistics page.
Show program revisions on the statistics page.
DIVE SITES / LOCATIONS
Added Dive Sites as divesite.php.
Dive detail pages link to the dive site page.
Dive site pages link to the dives done at the site.
Supports having a link in the dive location comments to a Google Map for the dive site.
phpDivingLog version 1.2 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-2.zip (2,600 KB ZIP file).
Best Regards, Lloyd Borrett.
I've updated the PHP scripts to add in a number of new features. See http://www.borrett.id.au/divelog/
STATISTICS
Separated statistics into divestats.php.
Added Diving Certifications to the statistics page.
Show program revisions on the statistics page.
DIVE SITES / LOCATIONS
Added Dive Sites as divesite.php.
Dive detail pages link to the dive site page.
Dive site pages link to the dives done at the site.
Supports having a link in the dive location comments to a Google Map for the dive site.
phpDivingLog version 1.2 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-2.zip (2,600 KB ZIP file).
Best Regards, Lloyd Borrett.
Last edited by lloyd_borrett on Wed Jul 12, 2006 11:24, edited 1 time in total.
-
- Posts: 228
- Joined: Sun Jun 11, 2006 09:24
- Location: Frankston South, Victoria, Australia
- Contact:
G'day,
I've just succeeded in adding support for dive pictures to phpDivingLog.
The dives I have pictures for are:
http://www.borrett.id.au/divelog/index.php?nr=27
http://www.borrett.id.au/divelog/index.php?nr=23
http://www.borrett.id.au/divelog/index.php?nr=14
I've used Lightbox JS 2 to display the set of dive pictures.
Once I'm done cleaning up some code, I'll package it up and make this version available for download.
Best Regards, Lloyd Borrett.
I've just succeeded in adding support for dive pictures to phpDivingLog.
The dives I have pictures for are:
http://www.borrett.id.au/divelog/index.php?nr=27
http://www.borrett.id.au/divelog/index.php?nr=23
http://www.borrett.id.au/divelog/index.php?nr=14
I've used Lightbox JS 2 to display the set of dive pictures.
Once I'm done cleaning up some code, I'll package it up and make this version available for download.
Best Regards, Lloyd Borrett.
I have fixed the 3 links, because the "http://www.borrett.id.au" was missing. The picture display and the pictures are really good!
-
- Posts: 228
- Joined: Sun Jun 11, 2006 09:24
- Location: Frankston South, Victoria, Australia
- Contact:
G'day,
I've updated phpDivingLog to add in a number of new features. See http://www.borrett.id.au/divelog/
DIVE PICTURES
Added support for dive pictures
Added links to the other sections on each page
Dive profile now shows depth scales for metres and feet
Added link titles to links that didn't have them
PHP CODE CLEANUP
Moved CSS values into a CSS file
Moved configuration values into a config file
Moved language values into a languages file
Cleaned up some code
This makes phpDivingLog much easier to set up and get running on your web server.
It also means phpDivingLog is now a lot easier for those of you wanting to use a language other than English. I'm hoping others will contribute back language files for different languages.
phpDivingLog version 1.3 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-3.zip (2,700 KB ZIP file).
Best Regards, Lloyd Borrett.
I've updated phpDivingLog to add in a number of new features. See http://www.borrett.id.au/divelog/
DIVE PICTURES
Added support for dive pictures
Added links to the other sections on each page
Dive profile now shows depth scales for metres and feet
Added link titles to links that didn't have them
PHP CODE CLEANUP
Moved CSS values into a CSS file
Moved configuration values into a config file
Moved language values into a languages file
Cleaned up some code
This makes phpDivingLog much easier to set up and get running on your web server.
It also means phpDivingLog is now a lot easier for those of you wanting to use a language other than English. I'm hoping others will contribute back language files for different languages.
phpDivingLog version 1.3 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-3.zip (2,700 KB ZIP file).
Best Regards, Lloyd Borrett.
-
- Posts: 228
- Joined: Sun Jun 11, 2006 09:24
- Location: Frankston South, Victoria, Australia
- Contact:
G'day,
phpDivingLog 1.4 is now available, complete with new features.
DANISH LANGUAGE SUPPORT
Henrik Absalon - (http://www.absalon.org) has produced a Danish language file for this version.
EQUIPMENT LISTING and PHOTOS
Added support for equipment listing, equipment details and equipment photos.
LOCATION MAP IMAGES
Added support for location map images.
OTHER CHANGES
Added in a partial workaround for location latitude and longitude coordinate format problems.
Fixed links to dives at a given location.
Now showing no dive entry time instead of the bad value that is passed by MySQL Dump.
Cleaned up some code.
phpDivingLog version 1.4 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-4.zip (2,700 KB ZIP file).
See http://www.borrett.id.au/divelog/ for an example site.
Best Regards, Lloyd Borrett.
phpDivingLog 1.4 is now available, complete with new features.
DANISH LANGUAGE SUPPORT
Henrik Absalon - (http://www.absalon.org) has produced a Danish language file for this version.
EQUIPMENT LISTING and PHOTOS
Added support for equipment listing, equipment details and equipment photos.
LOCATION MAP IMAGES
Added support for location map images.
OTHER CHANGES
Added in a partial workaround for location latitude and longitude coordinate format problems.
Fixed links to dives at a given location.
Now showing no dive entry time instead of the bad value that is passed by MySQL Dump.
Cleaned up some code.
phpDivingLog version 1.4 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-4.zip (2,700 KB ZIP file).
See http://www.borrett.id.au/divelog/ for an example site.
Best Regards, Lloyd Borrett.
-
- Posts: 228
- Joined: Sun Jun 11, 2006 09:24
- Location: Frankston South, Victoria, Australia
- Contact:
G'day,
phpDivingLog 1.5 is now available, complete with new features.
GERMAN LANGUAGE SUPPORT
Sven Knoch - (https://www.divinglog.de) has produced a German language file for this version.
BETTER LANGUAGE SUPPORT
Improved support for other languages.
IMPROVED INSTALLATION DETAILS
Improved the readme.txt file to add extra details about installation and usage.
OTHER CHANGES
JpGraph config file includes/jpgraph/src/jpg-config.inc changed to have the values for a Linux system as the default. The files jpg-config-linux.inc and jpg-config-windows.inc are examples of this file that worked on those platforms.
Changed divestats.php to include a link to the phpDivingLog page at http://www.borrett.id.au/interests/phpdivinglog.htm.
Cleaned up some code.
phpDivingLog version 1.5 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-5.zip (2,700 KB ZIP file).
See http://www.borrett.id.au/divelog/ for an example site.
Best Regards, Lloyd Borrett.
phpDivingLog 1.5 is now available, complete with new features.
GERMAN LANGUAGE SUPPORT
Sven Knoch - (https://www.divinglog.de) has produced a German language file for this version.
BETTER LANGUAGE SUPPORT
Improved support for other languages.
IMPROVED INSTALLATION DETAILS
Improved the readme.txt file to add extra details about installation and usage.
OTHER CHANGES
JpGraph config file includes/jpgraph/src/jpg-config.inc changed to have the values for a Linux system as the default. The files jpg-config-linux.inc and jpg-config-windows.inc are examples of this file that worked on those platforms.
Changed divestats.php to include a link to the phpDivingLog page at http://www.borrett.id.au/interests/phpdivinglog.htm.
Cleaned up some code.
phpDivingLog version 1.5 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-5.zip (2,700 KB ZIP file).
See http://www.borrett.id.au/divelog/ for an example site.
Best Regards, Lloyd Borrett.
Bug in the dive site
I have found 2 bug in the dive sites.
1) The country is not show right! Try to log or change a dive whit a different country name. (The country name is the same fore all dive site.)
2) In dive site details, the country is not show right, I think the bug is in onecountry.
I have changed it to:
SELECT Number, Country
FROM Logbook
WHERE PlaceID = '$globals[locid]'
ORDER BY Number ASC
And now it is working
1) The country is not show right! Try to log or change a dive whit a different country name. (The country name is the same fore all dive site.)
2) In dive site details, the country is not show right, I think the bug is in onecountry.
I have changed it to:
SELECT Number, Country
FROM Logbook
WHERE PlaceID = '$globals[locid]'
ORDER BY Number ASC
And now it is working
-
- Posts: 228
- Joined: Sun Jun 11, 2006 09:24
- Location: Frankston South, Victoria, Australia
- Contact:
G'day,
phpDivingLog 1.6 is now available, complete with fixes and new features.
DIVING LOG MINOR UPDATE
Sven Knoch released a minor update to Diving Log 4.0.4 to fix a few bugs in the MySQL Dump export option
phpDivingLog has been updated to make use of these fixes.
phpDivingLog 1.6 WILL NOT WORK without the minor updates to Diving Log.
EDIT: This update is not necessary anymore when you use Diving Log 4.0.5
Dive entry time is now displayed.
Dive site latitude and longitude values are now properly formatted.
GOOGLE MAPS
Added link to Google Maps for the dive site if we have the latitude and longitude.
IMPROVED INSTALLATION DETAILS
Improved the readme.txt file to add extra details about installation and usage.
OTHER CHANGES
Fixed bug in phpDivingLog to display correct dive site country.
Fixed bug where a dive site might have no matching country or city.
Added additional checking of argument values to prevent potential security problem.
Improved the display of some null values.
phpDivingLog version 1.6 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-6.zip (2,700 KB ZIP file).
See http://www.borrett.id.au/divelog/ for an example site.
See the phpDivingLog page at http://www.borrett.id.au/interests/phpdivinglog.htm for more details about phpDivingLog.
Best Regards, Lloyd Borrett.
phpDivingLog 1.6 is now available, complete with fixes and new features.
DIVING LOG MINOR UPDATE
Sven Knoch released a minor update to Diving Log 4.0.4 to fix a few bugs in the MySQL Dump export option
phpDivingLog has been updated to make use of these fixes.
phpDivingLog 1.6 WILL NOT WORK without the minor updates to Diving Log.
EDIT: This update is not necessary anymore when you use Diving Log 4.0.5
Dive entry time is now displayed.
Dive site latitude and longitude values are now properly formatted.
GOOGLE MAPS
Added link to Google Maps for the dive site if we have the latitude and longitude.
IMPROVED INSTALLATION DETAILS
Improved the readme.txt file to add extra details about installation and usage.
OTHER CHANGES
Fixed bug in phpDivingLog to display correct dive site country.
Fixed bug where a dive site might have no matching country or city.
Added additional checking of argument values to prevent potential security problem.
Improved the display of some null values.
phpDivingLog version 1.6 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-6.zip (2,700 KB ZIP file).
See http://www.borrett.id.au/divelog/ for an example site.
See the phpDivingLog page at http://www.borrett.id.au/interests/phpdivinglog.htm for more details about phpDivingLog.
Best Regards, Lloyd Borrett.
-
- Posts: 228
- Joined: Sun Jun 11, 2006 09:24
- Location: Frankston South, Victoria, Australia
- Contact:
G'day,
phpDivingLog 1.7 is now available, complete with new features.
METRIC and IMPERIAL UNITS
phpDivingLog now supports length, pressure, weight, temperature and weight values being displayed with imperial units of measurement.
CERTIFICATION SCANS
Added support for displaying the certification scans in divestats.php.
DIVE SUMMARY
Added divesummary.php to allow the display of some summary details on a standard .htm page.
IMPROVED INSTALLATION DETAILS
Improved the readme.txt file to add extra details about installation and usage.
OTHER CHANGES
Improved the handling of situations where there are no site, equipment etc. details.
Improved the display of more null values.
Cleaned up the HTML output.
Language file compare tool added.
phpDivingLog version 1.7 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-7.zip (2,700 KB ZIP file).
See http://www.borrett.id.au/divelog/ for an example site.
See the phpDivingLog page at http://www.borrett.id.au/interests/phpdivinglog.htm for more details about phpDivingLog.
Best Regards, Lloyd Borrett.
phpDivingLog 1.7 is now available, complete with new features.
METRIC and IMPERIAL UNITS
phpDivingLog now supports length, pressure, weight, temperature and weight values being displayed with imperial units of measurement.
CERTIFICATION SCANS
Added support for displaying the certification scans in divestats.php.
DIVE SUMMARY
Added divesummary.php to allow the display of some summary details on a standard .htm page.
IMPROVED INSTALLATION DETAILS
Improved the readme.txt file to add extra details about installation and usage.
OTHER CHANGES
Improved the handling of situations where there are no site, equipment etc. details.
Improved the display of more null values.
Cleaned up the HTML output.
Language file compare tool added.
phpDivingLog version 1.7 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-7.zip (2,700 KB ZIP file).
See http://www.borrett.id.au/divelog/ for an example site.
See the phpDivingLog page at http://www.borrett.id.au/interests/phpdivinglog.htm for more details about phpDivingLog.
Best Regards, Lloyd Borrett.
-
- Posts: 228
- Joined: Sun Jun 11, 2006 09:24
- Location: Frankston South, Victoria, Australia
- Contact:
G'day,
phpDivingLog 1.8 is now available, complete with new features.
DIVE PROFILE GRAPH
Changes to the dive profile graph:
- Added average depth to the dive profile chart.
- Added descent and work warnings to the dive profile chart.
- Better support for metric and imperial units in the dive profile chart.
- Provided a default dive profile chart option that displays
well when there is no background image.
IMPROVED INSTALLATION DETAILS
Improved the readme.txt file to add extra details about installation and usage.
phpDivingLog version 1.8 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-8.zip (2,700 KB ZIP file).
See http://www.borrett.id.au/divelog/ for an example site.
See the phpDivingLog page at http://www.borrett.id.au/interests/phpdivinglog.htm for more details about phpDivingLog.
Best Regards, Lloyd Borrett.
phpDivingLog 1.8 is now available, complete with new features.
DIVE PROFILE GRAPH
Changes to the dive profile graph:
- Added average depth to the dive profile chart.
- Added descent and work warnings to the dive profile chart.
- Better support for metric and imperial units in the dive profile chart.
- Provided a default dive profile chart option that displays
well when there is no background image.
IMPROVED INSTALLATION DETAILS
Improved the readme.txt file to add extra details about installation and usage.
phpDivingLog version 1.8 can now be downloaded from http://www.borrett.id.au/downloads/phpd ... g_v1-8.zip (2,700 KB ZIP file).
See http://www.borrett.id.au/divelog/ for an example site.
See the phpDivingLog page at http://www.borrett.id.au/interests/phpdivinglog.htm for more details about phpDivingLog.
Best Regards, Lloyd Borrett.