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?
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.
Quote:
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...
Duly noted.
Quote:
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.
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)
08-01-2006, 03:27 PM
Linear Mode
