[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');