Poster of the day

[Crazy Pete]

It's because the query calculates the posts from 24hrs ago at that particular time, so for example if someone posted something at 3AM the day before, and it's now 4AM, that post wouldn't count in their top posters thing.

What I'd like to see is have this query run once every day at say midnight, and tally up the post counts from then and keep them cached, the run again the next day at midnight and so on. I'm trying to do this by integrating this code with Firefly's Member Of The Day hack but I can't quite get it to work correctly. Any ideas?

[Drowned]

Today at 03:56 PM Crazy Pete said this in Post #11
It's because the query calculates the posts from 24hrs ago at that particular time, so for example if someone posted something at 3AM the day before, and it's now 4AM, that post wouldn't count in their top posters thing.

What I'd like to see is have this query run once every day at say midnight, and tally up the post counts from then and keep them cached, the run again the next day at midnight and so on. I'm trying to do this by integrating this code with Firefly's Member Of The Day hack but I can't quite get it to work correctly. Any ideas?

That's EXACTLY what I was looking for and I came up with that conclusion about the hack this afternoon too

I guess I just explained it wrong... I bet somebody can come up with a fix for it in few mins If they could just read this thread, hehehe

[g-force2k2]

i doubt thats the case...

since his post count is decreasing rather then increasing perhaps its because he isn't post 100+ per in the last day? i mean its sounds resonable to me and the coding looks sound...

besides twenty four hours is twenty four hours no matter where you live...

g-force2k2

[Drowned]