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: Link on top 'most comments' possible ??  (Read 1974 times)

0 Members and 1 Guest are viewing this topic.

danyball

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Link on top 'most comments' possible ??
« on: September 22, 2008, 12:18:05 pm »

Hi!
Is there any way to create a link to see the pictures with the most comments?! like 'newest comments' ....

thanks!!!!
daniel
Logged

danyball

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: Link on top 'most comments' possible ??
« Reply #1 on: September 24, 2008, 05:47:30 pm »

The SQL-Query i want is:
Code: [Select]
SELECT pid, count(*) as summe FROM `cpg148_comments` group by pid order by summe desc
i only need help in which file i have to copy it. i want a thumbnail-site with these pictures....

thanks!
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Link on top 'most comments' possible ??
« Reply #2 on: September 24, 2008, 07:53:29 pm »

You need to create a new set of meta-albums. Take a look at index.php and include/functions.inc.php: search for the case selectors there and come up with a new case for your meta album.
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 20 queries.