Page 1 of 1

I unpublished some p

Posted: 11 Apr 2008, 16:33
by thomric2
I unpublished some photos yesterday, so they did not show up in the standard phoca gallery, however they were still visible in piclens. I figured out a way to prevent this by adding a line to the WHERE clause in the SQL query that gets the list of images to be used in piclens.

In \administrator\components\com_phocagallery\models I modified function piclens in phocagalleryc.php. I added a line to the $query after the WHERE line and before the ORDER line that says:
. ' AND a.published = 1'

Ive tested this code and it works as expected, no more unpublished photos.

Enjoy!

Rick

Great, thank you, I

Posted: 11 Apr 2008, 21:24
by Jan
Great, thank you, I will take a look at it,

Jan