Top Posters and Highest rated
 

I would like to change the Top Posters listing on my site to display only the results from the past month or current month - rather than over all time.

Also - I would like for the Highest Rated to be changed - to show the most viewed for the month.

Are either of these possible?

Patti

Hello look at the queries and you would need to add something like this to the highest rated and top posters queries

Hey Chuck,
Can you give the correct/complete statement to be searched and replaced with in the required filename as well ?

thanks this should be quite handy

bumping back, chuck sorry to bother ya, but can you look forward for a possible solution here ? :)

thanks.

Sandeep what are you looking for I posted what needs to be added to a query above.

Simple add the AND clause anywhere right after the WHERE clause in any specific query you are trying to do. For specific ways to see how it would look simply look at other queries within our files. Many examples of the use of an AND clause in queries. The queries you want to modify are in index.php

I tried to change
to

but this wont work.

cannot find toprated query..

Thats because there is no WHERE CLAUSE and you have it in the wrong spot

this works fine now for both top posters and highest rated images pal.
thanks chuck.

File name?
 

I apologize if this seems obvious, but I am unable to find the location of the queries to change to make this work. Can you tell me if they are in a specific directory or the main directory - and what the file name would be.

Thank you
Patti

index.php is the file being discussed

What file would I go to, to change the "title" of each category - for instance to Top Posters for Month instead of just Top Posters.

Also - is there a simple way to change the Top Rated - to most viewed? I tried a couple of changes - but not knowing PHP very well - it didn't work!

You post is not making sense to me here

category titles and a top posters pal box have no correlation so your loosing me here. The top rated pal already pulls photos highest rated secondary sorted by most views

Each "pal" box has a title on it. One says "Top Posters" at the top, and under it the results of the query. I want to change that "title".

Okay yeah saying edit the category titles threw me off. Just edit your language file english.php and change the language string.

I have had thumbincluder running fine for quite some time. I recently moved to a new server and my hosting company transferred everything over for me. My gallery is working fine - no problems.

But - my thumbincluder wont show the most recent images. It will show only the last 5 images that were uploaded before the server move.

Any ideas??

I would suggest you look at your thumbnailer to see your looking for the proper database and other info ;)

top posters and highest rated
 

I made the modifications in this thread and all was working great until I upgraded to the newest version (5.5). Now the index.php refers to a "topposterspal" and doesn't have anywhere to make the changes to make this work again.

Any ideas on how I can go back to showing the top posters for the month and higest rated for the month?

Patti

the query is now within a function in pp-inc.php

Top Poster
 

I have the following information in my pp-inc.php file. However, the numbers *never* change. The same people are always listed, and it just seems to stay static.

But I would ask are the results accurate though because based on the query they would be. You can try turning off the category cache in admin global options and see if they change.