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: Sorting albums alphabetically  (Read 5825 times)

0 Members and 1 Guest are viewing this topic.

Criss

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
Sorting albums alphabetically
« on: June 21, 2010, 01:04:25 pm »

Hi,

Can anyone tell me how can I sort albums alphabetically under category? Modification for version 1.4 doesn't work anymore.

http://joejonasphotos.org

Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Sorting albums alphabetically
« Reply #1 on: June 21, 2010, 01:32:53 pm »

The instructions in the other thread say you need to replace
Code: [Select]
ORDER BY a.poswith
Code: [Select]
ORDER BY a.titlein index.php in the relevant queries. Did you try that? It's in the code two times - the corresponding queries are
Code: [Select]
        $sql = 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner '
            . ' FROM ' . $CONFIG['TABLE_ALBUMS'] . ' as a '
            . ' LEFT JOIN ' . $CONFIG['TABLE_PICTURES'] . ' as p ' . 'ON a.thumb=p.pid '
            . ' WHERE a.category=' . $cat . $album_filter
            . ' ORDER BY a.pos, a.aid ' . $limit;
and
Code: [Select]
    $sql = "SELECT a.aid, count( p.pid ) AS pic_count, max( p.pid ) AS last_pid, max( p.ctime ) AS last_upload, a.keyword, a.alb_hits"
            ." FROM {$CONFIG['TABLE_ALBUMS']} AS a "
            ." LEFT JOIN {$CONFIG['TABLE_PICTURES']} AS p ON a.aid = p.aid AND p.approved = 'YES' "
            ." WHERE a.category = $cat $album_filter GROUP BY a.aid ORDER BY a.pos, a.aid $limit";
Logged

Criss

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 36
Re: Sorting albums alphabetically
« Reply #2 on: June 21, 2010, 10:19:48 pm »

Got it! Thanks!  ;)
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.