forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: ian ditch on October 15, 2005, 06:26:18 pm

Title: Help with top 10
Post by: ian ditch on October 15, 2005, 06:26:18 pm

Hi

I,m trying to get a top 10 page working on my site... I have allready done a top posters and a top uploaders section as can be seen here-

http://www.british-babes.co.uk/top10.php (totally safe for work content)

Now what I would link to do is to have the top 10 ablums (most viewed Ablums) in a table above these, but i am unsure how this is done.

The 'top posters/uploaders' is done in anycontent3 and the banner is in anycontent2 .

Any help would be appreciated.

Title: Re: Help with top 10
Post by: Stramm on October 16, 2005, 11:22:46 am

seems to work ;) you just need to do some table cleanup

Title: Re: Help with top 10
Post by: ian ditch on October 16, 2005, 11:30:22 am

I'm trying to get the top 10 most viewed albums shown in a seperate table.

Any Ideas on how to do this?

Title: Re: Help with top 10
Post by: Stramm on October 16, 2005, 11:49:32 am

puuh... I wouldn't recommend it. There's no db entry for views on albums. So you'll take some heat on the server if you've some pics and albums. Either a mysql count on the pictures for each album. Not good for huge albums. Or prefetch the aid from the pictures table and sort/ count the array

Title: Re: Help with top 10
Post by: ian ditch on October 16, 2005, 11:58:34 am

Thanks for your replys Stramm, your input is appreciated.

Keep up the great work ;D