how do I change the photo sorting in a album: The Chill Out Zone

Navigation

Home
Search

Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.

how do I change the photo sorting in a album

Last updated on 4 years ago

9.10

Track thread Print

tjakobNewbie

Posted 4 years ago

Hello All,
how do I change the photo sorting in an album. I want the gallery to start with the newest photo. Sorting now starts with the oldest.
Regards and Happy New Year 2022!

Edited by Falk on 08-01-2022 11:18, 4 years ago

douwe_yntemaSenior Member

Posted 4 years ago

Goto file
yoursite/infusions/gallery/gallery.php.

Search for line 265:

Code Download source

 GROUP BY photo_id ORDER BY photo_order

change to:

Code Download source

 GROUP BY photo_id ORDER BY photo_order DESC

This is for the listing of the album.

For browsing, search for line 51:

Code Download source

 WHERE ".groupaccess('album_access')." AND photo_id='".intval($_GET['photo_id'])."' GROUP BY p.photo_id");

change to:

Code Download source

WHERE ".groupaccess('album_access')." AND photo_id='".intval($_GET['photo_id'])."' GROUP BY p.photo_id ORDER BY photo_order DESC");

And search for line 57/58:

Code Download source

$pres = dbquery("SELECT photo_id FROM ".DB_PHOTOS." WHERE photo_order=:porder AND album_id=:albumid", [':porder' => ($data['photo_order'] - 1), ':albumid' => $data['album_id']]);

 $nres = dbquery("SELECT photo_id FROM ".DB_PHOTOS." WHERE photo_order=:porder AND album_id=:albumid", [':porder' => ($data['photo_order'] + 1), ':albumid' => $data['album_id']]);

Change to:

Code Download source

$pres = dbquery("SELECT photo_id FROM ".DB_PHOTOS." WHERE photo_order=:porder AND album_id=:albumid", [':porder' => ($data['photo_order'] + 1), ':albumid' => $data['album_id']]);

 $nres = dbquery("SELECT photo_id FROM ".DB_PHOTOS." WHERE photo_order=:porder AND album_id=:albumid", [':porder' => ($data['photo_order'] - 1), ':albumid' => $data['album_id']]);

1 user reacted to this post

tjakob

tjakobNewbie

Posted 4 years ago

THANK YOU!
Happy New Year 2022!

You can view all discussion threads in this forum.
You cannot start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.

Moderator: Support Team

Users who participated in discussion: tjakob, douwe_yntema