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: Help with top 10  (Read 3657 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 19 queries.