Report to view count of members posts by day

[tpearl5]

I'm looking for something to allow me to view how many posts a member has posted by day/week/month.

Any ideas?

[tpearl5]

nvm, I figured out a query that can be run...

SELECT COUNT(1) AS posts, FROM_UNIXTIME( dateline, '%Y-%m-%d' ) AS DATE FROM post WHERE userid =1 GROUP BY FROM_UNIXTIME(dateline, '%Y-%m-%d');

Just change the userid.

And if you want to count and group by month:
SELECT COUNT(1) AS posts, FROM_UNIXTIME( dateline, '%Y-%m' ) AS DATE FROM post WHERE userid =1 GROUP BY FROM_UNIXTIME(dateline, '%Y-%m');