Advanced search  

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]

Pages: [1]   Go Down

Author Topic: albums sorted by name  (Read 2763 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.015 seconds with 21 queries.