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: Help with top 10  (Read 3512 times)

0 Members and 1 Guest are viewing this topic.

ian ditch

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Help with top 10
« 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.
« Last Edit: October 16, 2005, 03:01:08 pm by GauGau »
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Help with top 10
« Reply #1 on: October 16, 2005, 11:22:46 am »

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

ian ditch

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Re: Help with top 10
« Reply #2 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?
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Help with top 10
« Reply #3 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

ian ditch

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Re: Help with top 10
« Reply #4 on: October 16, 2005, 11:58:34 am »

Thanks for your replys Stramm, your input is appreciated.

Keep up the great work ;D
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 22 queries.