sort albums by date

[zieloo]

Hi

How do I sort albums inside a category by date (asc or desc, whatever) ?

Thanks

[just_some_guy]

use the "DATE + -" buttons on the top right.

[zieloo]

use the "DATE + -" buttons on the top right.

I want to sort the albums NOT the pictures within them...

[zieloo]

Anyone?

[Nibbler]

You can make a small mod to index.php to adjust the sort order. Search the board - the answer is already posted.

[zieloo]

Done.
Change:

Code Select Expand

'    $sql = 'SELECT a.aid, a.title, a.description, visibility, filepath, ' . 'filename, url_prefix, pwidth, pheight ' . 'FROM ' . $CONFIG['TABLE_ALBUMS'] . ' as a ' . 'LEFT JOIN ' . $CONFIG['TABLE_PICTURES'] . ' as p ' . 'ON a.thumb=p.pid ' . 'WHERE category=' . $cat . $album_filter . ' ORDER BY a.pos' . $limit;'

to:

Code Select Expand

'    $sql = 'SELECT a.aid, a.title, a.description, visibility, filepath, ' . 'filename, url_prefix, pwidth, pheight ' . 'FROM ' . $CONFIG['TABLE_ALBUMS'] . ' as a ' . 'LEFT JOIN ' . $CONFIG['TABLE_PICTURES'] . ' as p ' . 'ON a.thumb=p.pid ' . 'WHERE category=' . $cat . $album_filter . ' ORDER BY a.pos DESC ' . $limit;'

line: aprox 605, file: index.php

Thanks, Nibbler