Photopost 4.8d - Highest Rated Accuracy

[mitchjaz2]

I'm curious as to what the criteria is for "Highest Rated" on the Highest Rated pal. The i"highest Rated" have been stagnent for some time, and I believe that there are other images that are indeed more highly rated. Gallery is at -

www.dphoto.us/forumphotos

[Chuck S]

well should be highest rating by date descending

[mitchjaz2]

Well, if you look at the dates those images were posted,,,,that's not the way they're posting.

[Chuck S]

That is exactly how they are posted!!

Remeber the highest rated is 10 which is what is displayed first and then all the ten's are then secondarily sorted by date descending. After all the ten's are displayed in date descending then comes 9.9 9.8 etc

It is displayed exactly as I stated

[mitchjaz2]

They are not displayed by date descending, here are the dates as listed:

1 - Jen - Sun Feb 15, 2004

2 - Come on in - Sat Feb 7, 2004

3 - Johnny A - Wed Dec 3, 2003

4 - Pacemates in action - Mon Nov 24, 2003

5 - Megan - Mon Feb 9, 2004

6 - The Fly Thu Jan 29, 2004

7 - Sao In Sunset - Wed Dec 10, 2003

8 - Water On Rocks - Mon Nov 24, 2003

9 - Sitting Tiger -Tue Dec 30, 2003

10 - Reflection - Sun Feb 1, 2004

They all have ratings of 10. Unless I'm missing something, That's not ordered by dates descending.

[Chuck S]

OKay there is this. Michael has it sorted by views not date. Okay so that makes sense now. Instead of looking I made the mistake of assuming it was simple as the rating and then subsorted by date. Forgot Michael takes into account that user's actually wanting to view the images takes part in his mind as far as rating.

$query = "SELECT cat,id,title,rating FROM {$Globals['pp_db_prefix']}photos ORDER BY rating DESC,views DESC LIMIT {$Globals['mostpoppal']}";