Hallo,
I must say thank you Trail for plugin showing pictures from Zoom Gallery.
I just need a litle change in this plugin, but I am not able to do that..it doesnt work...
Plugin from Trail shows all the pistures uploaded by some member (it compares id of user with uid of picture). But I need to compare name of picture with name of user...
Problem is, that I have many pictures from all members, but all photos are uploaded by me...so it shows all pictures in "my" gallery.
I was trying to change original zoom.php file from plugin (it looks like this):
[code:1]$queryGet = "SELECT zf.imgid, zf.imgfilename, zf.imgname, zf.imgdate, zf.imghits, zf.imgdescr, zf.published, zf.catid, zf.uid, z.catdir, z.catname";
$queryCount = "SELECT COUNT(zf.imgfilename)";
$queryRest = "\n FROM #__zoomfiles zf"
. "\n INNER JOIN #__zoom z ON zf.catid=z.catid"
. "\n WHERE zf.uid=".$user->user_id;
$queryLimit = "\n ORDER BY ".$order
. "\n LIMIT ".($pagingParams["img_limitstart"]?$pagingParams["img_limitstart"]:"0"«»).",".$imgNumberPerPage;[/code:1]
To this:
[code:1]
$queryGet = "SELECT zf.imgid, zf.imgfilename, zf.imgname, zf.imgdate, zf.imghits, zf.imgdescr, zf.published, zf.catid, zf.uid, z.catdir, z.catname";
$queryCount = "SELECT COUNT(zf.imgfilename)";
$queryRest = "\n FROM #__zoomfiles zf"
. "\n INNER JOIN #__zoom z ON zf.catid=z.catid"
. "\n WHERE zf.imgname=".$user->lastname;
$queryLimit = "\n ORDER BY ".$order
. "\n LIMIT ".($pagingParams["img_limitstart"]?$pagingParams["img_limitstart"]:"0"«»).",".$imgNumberPerPage;[/code:1]
If I do it, gallery in community builder stops working and shows no pictures at all.
Please, help me. How should I change it....???
Thank you
