albums sorted by name albums sorted by name
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

albums sorted by name

Started by ypp, December 03, 2005, 10:10:58 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

ypp

Hello all, How can I let the albums automatically sorted by name in cpg1.4?
I have read there's a mod to do this....where is it?

Thanks :)

ypp

Hello, I will try to explain better myself: I've used Nibbler's spawner.php to batch many albums in one category but now the albums are not sorted by name.


Please, I need help ???
Thank you all

ypp

#2
OK, I solved my problem: I found old threads about simile problems but on cpg1.3 (I'm using cpg1.4 and it's nearly the same) so I
looked for in index.php...

found
$sql = 'SELECT a.aid, a.title, a.description, category, 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;

replaced with
$sql = 'SELECT a.aid, a.title, a.description, category, 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.title ' . $limit;

bye ;)

flogghe

Thanks, works fine.  :)

I had the same problem; now it is solved!!!

Kind regards,
Frederic

Kind regards,

Frederic Logghe
Webmaster MaritimeDigital Archive
http://www.ibiblio.org/maritime