top posters within a certain period of time
 

Is there a way to get the top 10 posters within XX period of time for v3.5.2? Help! :)

I'm looking for the same thing for 3.6 to place in the left column on all of my forum pages.

Paul - I have your 3.6 RC version installed already. Is there a way to pull the top posters from the last 24 hours (only) and display it in a left column on the forum pages?

Not with that hack their isn't.

You could copy the relevant SQL and write your own code to display it.

I have no clue how to do that.

I'll keep looking - I see there are several hacks that include "top poster" info, they just all seem to only count total posts.

I could give you code to display that, but you might want to rethink this. It can be a pretty server heavy thing to add on main pages, let alone every forum page...

If that was the goal I'd probably go with setting up a sperate table to store the results in and getting a cron job to update it every hour or so.

But you aren't going to want to run that query everytime someone visits a forum page...

Thank you! I'm a newbie to all of this so please bear with me.
Duly noted. :)
A separate table that I could display in my left column (and note that it only updates every hour) or one that I would have to give its own page? Would you be able to teach me how to set up the cron job?

As another thought, would it be easier to try to modify this hack to display last 24 hours instead of all time? (provided it works with 3.6)

Yes, you could modify the sql in that to just pull out the last 24 hours.

Would this be the part I need to modify?
If so, what do I need to change it to?