phpDivingLog

3rd party extensions (phpDivingLog, dive computer downloader,...)
Post Reply
lloyd_borrett
Posts: 228
Joined: Sun Jun 11, 2006 09:24
Location: Frankston South, Victoria, Australia
Contact:

phpDivingLog

Post by lloyd_borrett »

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.
Last edited by lloyd_borrett on Tue Jul 18, 2006 11:09, edited 1 time in total.
divinglog
Site Admin
Posts: 5764
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Post by divinglog »

Hi Lloyd

Thanks for the link, great work! 8)

I have plans to add a direct MySQL database upload tool, so this will be easier for you to get your data online.

Sven
lloyd_borrett
Posts: 228
Joined: Sun Jun 11, 2006 09:24
Location: Frankston South, Victoria, Australia
Contact:

Post by lloyd_borrett »

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...
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.
lloyd_borrett
Posts: 228
Joined: Sun Jun 11, 2006 09:24
Location: Frankston South, Victoria, Australia
Contact:

Post by lloyd_borrett »

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.
Last edited by lloyd_borrett on Wed Jul 12, 2006 11:24, edited 1 time in total.
divinglog
Site Admin
Posts: 5764
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Post by divinglog »

Hello

Thank you for sharing your online logbook, really great! :) 8)

Sven
lloyd_borrett
Posts: 228
Joined: Sun Jun 11, 2006 09:24
Location: Frankston South, Victoria, Australia
Contact:

Post by lloyd_borrett »

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.
divinglog
Site Admin
Posts: 5764
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Post by divinglog »

I have fixed the 3 links, because the "http://www.borrett.id.au" was missing. The picture display and the pictures are really good!
lloyd_borrett
Posts: 228
Joined: Sun Jun 11, 2006 09:24
Location: Frankston South, Victoria, Australia
Contact:

Post by lloyd_borrett »

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.
divinglog
Site Admin
Posts: 5764
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Post by divinglog »

I'll check the language file and I think it's no problem for me to release a German language file.
lloyd_borrett
Posts: 228
Joined: Sun Jun 11, 2006 09:24
Location: Frankston South, Victoria, Australia
Contact:

Post by lloyd_borrett »

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.
lloyd_borrett
Posts: 228
Joined: Sun Jun 11, 2006 09:24
Location: Frankston South, Victoria, Australia
Contact:

Post by lloyd_borrett »

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.
absalon
Posts: 40
Joined: Sat Jan 28, 2006 08:40
Location: Vojens / Denmark
Contact:

Bug in the dive site

Post by absalon »

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
lloyd_borrett
Posts: 228
Joined: Sun Jun 11, 2006 09:24
Location: Frankston South, Victoria, Australia
Contact:

Post by lloyd_borrett »

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.
lloyd_borrett
Posts: 228
Joined: Sun Jun 11, 2006 09:24
Location: Frankston South, Victoria, Australia
Contact:

Post by lloyd_borrett »

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.
lloyd_borrett
Posts: 228
Joined: Sun Jun 11, 2006 09:24
Location: Frankston South, Victoria, Australia
Contact:

Post by lloyd_borrett »

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.
Post Reply