Page 1 of 1

SQL command doesn't appear inside the file

Posted: 22 Oct 2010, 15:58
by triskel
Hello all,
I've checked in all file inside the official zip file of the installation Phocagallery 2.7.5 pack but I never seen any
SQL command regarding the INSERT INTO,can someone help me?


King Regards
Triskel

Re: SQL command doesn't appear inside the file

Posted: 22 Oct 2010, 18:48
by Benno
Hi,
SQL commands are in install.bak
Kind regards,
Benno

Re: SQL command doesn't appear inside the file

Posted: 22 Oct 2010, 20:08
by triskel
hello benno,
thanks for your reply but inside the install.bck there are only the SQL command regarding the drop e create.
My request is regarding the "insert into" involved when some user upload a file and the phocagallery store this
info inside the DB.

king regards
Triskel

Re: SQL command doesn't appear inside the file

Posted: 31 Oct 2010, 16:58
by Jan
Hi, Phoca Gallery does not insert any images at the start of using the component, so there is no "INSERT" :idea:

Jan

Re: SQL command doesn't appear inside the file

Posted: 02 Nov 2010, 23:01
by triskel
Hello Jan,
you mean that when the user upload an image the func doesn't use any SQL "insert" for store
the data in the DB?
it's strange.....I've seen the upload func use the joomla standard store() function,can you provide
some details regarding part of code.

King Regards
Triskel

Re: SQL command doesn't appear inside the file

Posted: 02 Nov 2010, 23:58
by Jan
Hi, I have read the first post, so I thought you mean the install.bak file.

Of course there is an sql while adding images in frontend, you can find it in model of ucp, see:

components\com_phocagallery\models\user.php

BTW it is written in Joomla! framework so you will find not "INSERT" query

Jan