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: Title link list  (Read 2684 times)

0 Members and 1 Guest are viewing this topic.

AK_CCM

  • Coppermine regular visitor
  • **
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 63
  • Mushroom Hobby Photograph
    • Ent◊l◊ma.de – Rötlinge, Wiesenpilze und andere Schwammerln
Title link list
« on: June 25, 2010, 01:10:18 pm »

A few years ago I added a title link list of all images to a CPG 1.4.x installation. Now I want a title link list for CPG 1.5.x in which the titles are subdivided by albums as you can see at the attached screenshot or live here: http://www.pilzteam-bayern.de/galerie/inhalt.php

But how could I change the code so CPG shows the title links ordered by title and do not change the sequence of the albums? Also I want that CPG groups identical entries together into a single entry.

Code: [Select]
$result = mysql_query("SELECT a.pid, a.aid, a.title, b.title atitle from {$CONFIG['TABLE_PICTURES']} a, {$CONFIG['TABLE_ALBUMS']} b where a.aid = b.aid order by a.aid, a.pid desc");
I will be glad if anyone could help me.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Title link list
« Reply #1 on: June 28, 2010, 02:42:04 pm »

Where exactly do you need help? With the order of the titles?
Logged
Pages: [1]   Go Up
 

Page created in 0.015 seconds with 20 queries.