Twiebie |
|
||
---|---|---|---|
I want to create a little plugin that shows the weekly top posters in a list. I've grabbed a bit of code from the forum stats plugin to get started, but now i'm wondering how I can get/specify the users post count for a specific timespan (a week for example).
Thanks. |
Trustmaster |
|
||
---|---|---|---|
The users table does not keep history information, so you cannot extract statistics for a given time span. Instead, the information should be extracted from the forum posts table. The query for top 10 posters for the last 7 days looks like this:
May the Source be with you!
|
Twiebie |
|
---|---|
Thanks for the quick reply, Trustmaster! Got it working now. :) |