coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: danyball on September 22, 2008, 12:18:05 PM

Title: Link on top 'most comments' possible ??
Post by: danyball 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
Title: Re: Link on top 'most comments' possible ??
Post by: danyball on September 24, 2008, 05:47:30 PM
The SQL-Query i want is:
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!
Title: Re: Link on top 'most comments' possible ??
Post by: Joachim Müller 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.