Diving Log Online
NO DEVELOP OR SUPPORT ANYMORE!
NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 3 times in total.
Re: Diving Log Online
Is it possible to show pictures in Diving Log Online?
Henrik
Henrik
NO DEVELOP OR SUPPORT ANYMORE!
NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 4 times in total.
NO DEVELOP OR SUPPORT ANYMORE!
NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 3 times in total.
NO DEVELOP OR SUPPORT ANYMORE!
NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 1 time in total.
Re: Diving Log Online
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.
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.
NO DEVELOP OR SUPPORT ANYMORE!
NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:28, edited 1 time in total.
Re: Diving Log Online
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 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.
NO DEVELOP OR SUPPORT ANYMORE!
NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:29, edited 1 time in total.
Re: Diving Log Online
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.
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.
Re: Diving Log Online
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
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
Re: Diving Log Online
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...
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...
Re: Diving Log Online
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?
NO DEVELOP OR SUPPORT ANYMORE!
NO DEVELOP OR SUPPORT ANYMORE!
Last edited by vasco_nl on Mon Aug 02, 2010 13:29, edited 1 time in total.
Re: Diving Log Online
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
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