Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: albums sorted by name  (Read 3225 times)

0 Members and 1 Guest are viewing this topic.

ypp

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
albums sorted by name
« 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 :)
« Last Edit: December 05, 2005, 07:56:03 am by GauGau »
Logged

ypp

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
Re: albums sorted by name
« Reply #1 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
Logged

ypp

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
Re: albums sorted by name
« Reply #2 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 ;)
« Last Edit: December 04, 2005, 04:10:15 pm by ypp »
Logged

flogghe

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 44
    • MaritimeDigital Archive
Re: albums sorted by name
« Reply #3 on: December 05, 2005, 07:41:52 pm »

Thanks, works fine.  :)

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

Kind regards,
Frederic

Logged
Kind regards,

Frederic Logghe
Webmaster MaritimeDigital Archive
http://www.ibiblio.org/maritime
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.