Diving Log Online

3rd party extensions (phpDivingLog, dive computer downloader,...)
vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl »

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 3 times in total.
absalon
Posts: 40
Joined: Sat Jan 28, 2006 08:40
Location: Vojens / Denmark
Contact:

Re: Diving Log Online

Post by absalon »

Is it possible to show pictures in Diving Log Online?

Henrik
vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl »

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 4 times in total.
vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl »

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 3 times in total.
vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl »

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 1 time in total.
Inferno
Posts: 264
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: Diving Log Online

Post by Inferno »

The interface of Diving Log online really looks cool.

But be warned to me it looks like none of the MySQL queries are escaped well. Take a look on this page http://unixwiz.net/techtips/sql-injection.html and special look at "Escape/Quotesafe the input"

See here why addslashes doesn't work: http://cow.neondragon.net/index.php/130 ... on-Attacks

This project is made under GNU GPL which is nice, but next to being Open Source it would be nice if the code has some comments...

To me the outside looks nice, but the inside really could have some improvements.
vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl »

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 1 time in total.
Inferno
Posts: 264
Joined: Thu Apr 19, 2007 20:36
Location: The Netherlands
Contact:

Re: Diving Log Online

Post by Inferno »

vasco_nl wrote: I started this project to learn about PHP and MySQL so your comments are welcome to me. I read some things about SQL-injection and found at that time the use of addslashes should do the job. I'm going to read the pages you provide here and look more on the internet to see what I need to do against SQL-injections.
You can easily solve the problem by using an interface library like Pear MDB2 or AdoDB then those problem are solved for you.
vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl »

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:29, edited 1 time in total.
ianr
Posts: 47
Joined: Thu Sep 17, 2009 11:44

Re: Diving Log Online

Post by ianr »

Hi,

I'm trying to get this working but am struggling with MySQL. I have the diving log online side of things working but get the message 'A database is not found on this server, export databases from Diving Log first' I have tried configuring the diving log 4.0 app to connect to my database but apparently my host (1and1) don't allow direct connections to the database so this is a non starter. I can see the admin table in phpmyadmin but have no idea how to import the dump of the sql file from the diving log 4.0 app into my MySQL database. If I also read other posts in this thread correctly then the ability to do this is academic since you have to upload this file directly.

Is it worth my persisting and trying to fumble my through the MySQL admin or am I flogging a dead horse?

Thanks for your help.
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: Diving Log Online

Post by divinglog »

Hi

If your provider doesn't allow external access to the MySQL database you can export the data from Diving Log to a MySQL dump file and import this file using the phpMyAdmin program which should be available from your hoster (you can find there an easy way to select the dump file and execute it).

Kind regards,
Sven
ianr
Posts: 47
Joined: Thu Sep 17, 2009 11:44

Re: Diving Log Online

Post by ianr »

Hi,

I've tried to import the dump via myphpadmin but get lots of errors, assuming I;m doing it correctly, so the data still doesn't show up. I guess I need to read up on MySQL and myphpadmin a little more as it's very confusing...
divinglog
Site Admin
Posts: 5768
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: Diving Log Online

Post by divinglog »

There is also a chance that the MySQL dump file is not correctly exported from Diving Log. Can you copy/paste the errors from phpMyAdmin here or email them to me?
vasco_nl
Posts: 37
Joined: Tue Jul 24, 2007 22:25

NO DEVELOP OR SUPPORT ANYMORE!

Post by vasco_nl »

NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:29, edited 1 time in total.
ianr
Posts: 47
Joined: Thu Sep 17, 2009 11:44

Re: Diving Log Online

Post by ianr »

Hi Guys,

Thanks for the assistance.

errors are as follows:

SQL query:

#
# Data for table 'Equipment'
#
INSERT INTO Equipment
VALUES ( 1, 'Compass', '', '', NULL , NULL , '', '', NULL , , '', '', NULL , '771af827-72ea-4f3b-9092-c95ffb318fe8', NULL )

It appears to have created the extra tables in the database although I have little knowledge of MySQL.

Any ideas?

Thanks
Locked