forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: ypp on December 03, 2005, 10:10:58 pm

Title: albums sorted by name
Post by: ypp on December 03, 2005, 10:10:58 pm

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 :)

Title: Re: albums sorted by name
Post by: ypp on December 03, 2005, 11:54:26 pm

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

Title: Re: albums sorted by name
Post by: ypp on December 04, 2005, 04:05:01 pm

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

Code: [Select]

$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

Code: [Select]

$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 ;)

Title: Re: albums sorted by name
Post by: flogghe on December 05, 2005, 07:41:52 pm

Thanks, works fine.  :)

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

Kind regards,
Frederic