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.
Not a member yet? Click here to register.
Forgot Password?

Why this choice of ordering pictures?

Asked Modified Viewed 1,569 times
M
Martijn78
M
euhh...
  • Member, joined since
  • Contributed 107 posts on the community forums.
  • Started 25 threads in the forums
  • Started this discussions
asked
Member

Can someone explain why the order of the photos on the way like this? I would like the newest pictures on top. Could that be a choice option?
0 replies

1 post

A
Ankur
A
Ankur 10
Hi! Its me, Ankur Thakur! smile
  • Veteran Member, joined since
  • Contributed 1,277 posts on the community forums.
  • Started 60 threads in the forums
answered
Veteran Member

You can Suggest it at the Dev Site.

Otherwise, you can also Do it yourself. Open photogallery.php and find this Line :
[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false] $result = dbquery(
"SELECT tp.photo_id, tp.photo_title, tp.photo_thumb1, tp.photo_views, tp.photo_datestamp,
tu.user_id, tu.user_name, tu.user_status, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes
FROM ".DB_PHOTOS." tp
LEFT JOIN ".DB_USERS." tu ON tp.photo_user=tu.user_id
LEFT JOIN ".DB_RATINGS." tr ON tr.rating_item_id = tp.photo_id AND tr.rating_type='P'
WHERE album_id='".$_GET['album_id']."' GROUP BY photo_id ORDER BY photo_order LIMIT ".$_GET['rowstart'].",".$settings['thumbs_per_page']
);[/syntaxhighlighter]

Now see :

GROUP BY photo_id ORDER BY photo_order

Change it to :

GROUP BY photo_id ORDER BY photo_datestamp DESC

[ Moved to Modifications and Requests ]
0 replies

Labels

None yet

Statistics

  • Views 0 views
  • Posts 1 post
  • Votes 0 votes
  • Topic users 2 members

2 participants

M
M
euhh...
  • Member, joined since
  • Contributed 107 posts on the community forums.
  • Started 25 threads in the forums
  • Started this discussions
A
A
Ankur 10
Hi! Its me, Ankur Thakur! smile
  • Veteran Member, joined since
  • Contributed 1,277 posts on the community forums.
  • Started 60 threads in the forums

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet