Post count within a date range...

[Doc203]

Does anyone know if there is a way to get a post count for a certain date range? What I have done is started a contest this month for the most posts this month. The winner gets a Dell Pocket PC.

Anyway, I want to keep them updated as to who is in the lead thru-out the month, and the only way that I know to get these stats is in Admincp go to list top posters and go thru all the members. Anyone know of an easier way?

[Logician]

No easy way.. Your best bet is code a small script that will go through thread/posts tables and count the posts of users for the given time..

If you want to make info public, it would get slightly more complicated too. Because then the script had rather run a few days a day and save this info into a template instead of compiling them in real time. This is due to performance reasons. If that page is visited a lot or if there are too many posts inthe given date or the given date is too old, such compiling could affect performance so template solution is more performance friendly.

[Doc203]

Thats what I was afraid of... It doesn't have to be public, I can post that info myself but I don't think that I can do it myself.

Thanks for the info!