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: Link on top 'most comments' possible ??  (Read 2045 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.026 seconds with 19 queries.