albums sorted by name albums sorted by name
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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